MyProject

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace Verisk_Pro
{
    public partial class UserFrm : Form
    {
        public UserFrm()
        {
            InitializeComponent();
        }
        public int id;
        SqlConnection conn = new SqlConnection("Data Source=ASANGAM-PC\\MSSQLSERVER2008;Initial Catalog=Verisk_Pro;Integrated Security=True");
        private void button4_Click(object sender, EventArgs e)
        {
            //add

            int x = CrudOperation(0, txtFirstName.Text, txtLastName.Text, txtEmail.Text, txtUserName.Text, txtPassword.Text, cmbLevel.Text, 1);
            if (x > 0)
            {
                MessageBox.Show("User Created Successfully");
                GetAllUsers();

            }
            else
            {
                MessageBox.Show("Error in Creating User");

            }

            }
        public void GetAllUsers()
    {
     SqlCommand cmd=new SqlCommand("Select * from UserTable order by FirstName",conn);
     DataTable dt = new DataTable();
     conn.Open();
     SqlDataReader dr = cmd.ExecuteReader();
     dt.Load(dr);
     conn.Close();
     dgvUserDetails.DataSource=dt;

    }

        private void UserFrm_Load(object sender, EventArgs e)
        {
            GetAllUsers();
            //displaying the database in the data grid view with the form load
        }

        private void dgvUserDetails_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            txtFirstName.Text = dgvUserDetails.SelectedRows[0].Cells["FirstName"].Value.ToString();
            txtLastName.Text = dgvUserDetails.SelectedRows[0].Cells["LastName"].Value.ToString();
            txtEmail.Text = dgvUserDetails.SelectedRows[0].Cells["Email"].Value.ToString();
            txtUserName.Text = dgvUserDetails.SelectedRows[0].Cells["UserName"].Value.ToString();
            cmbLevel.Text = dgvUserDetails.SelectedRows[0].Cells["Level"].Value.ToString();
            txtPassword.Text = dgvUserDetails.SelectedRows[0].Cells["Password"].Value.ToString();
            txtConfirmPassword.Text = dgvUserDetails.SelectedRows[0].Cells["Password"].Value.ToString();
            id = Convert.ToInt32(dgvUserDetails.SelectedRows[0].Cells["UserId"].Value.ToString());
        }

        private void btnUpdate_Click(object sender, EventArgs e)
        {
           //update
            int update  = CrudOperation(id, txtFirstName.Text, txtLastName.Text, txtEmail.Text, txtUserName.Text, txtPassword.Text, cmbLevel.Text, 2);
            if (update > 0)
            {
                MessageBox.Show("User Updated Successfully");
                GetAllUsers();

            }
            else
            {
                MessageBox.Show("Error in Updating the User");

            }
        }

        private void btnDelete_Click(object sender, EventArgs e)
        {
           //delete

        }

        private void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        public void MakeFieldsBlank()
        {

            txtFirstName.Clear();
            txtLastName.Clear();
            txtEmail.Clear();
            txtPassword.Clear();
            txtUserName.Clear();
            txtConfirmPassword.Clear();
            cmbLevel.Text = "";
        }
        public int CrudOperation(int UserId,
            String FirstName,
            String LastName,
            String Email,
            String UserName,
            String Password,
            String Level,
            int Mode
            )
        {
            string txtSql="";
            if (Mode == 1)

              txtSql = "Insert into UserTable (FirstName=@FirstName,LastName=@LastName,Email=@Email,UserName=@UserName,Password=@Password,Level=@Level) values(@FirstName,@LastName,@Email,@UserName,@Password,@Level)";

            if(Mode==2)
             txtSql = "Update UserTable set FirstName=@FirstName,LastName=@LastName,Email=@Email,UserName=@UserName,Password=@Password,Level=@Level where UserId=@UserId";
            if (Mode == 3)
                txtSql = "Delete from UserTable where UserId=@UserId";

            SqlCommand cmd = new SqlCommand(txtSql, conn);
            cmd.CommandType=CommandType.Text;
            cmd.Parameters.AddWithValue("@FirstName", FirstName);
            cmd.Parameters.AddWithValue("@LastName", LastName);
            cmd.Parameters.AddWithValue("@Email", Email);
            cmd.Parameters.AddWithValue("@UserName", UserName);
           // cmd.Parameters.AddWithValue("@Email", Email);
            //cmd.Parameters.AddWithValue("@UserName", @UserName);
            cmd.Parameters.AddWithValue("@Password", Password);
            cmd.Parameters.AddWithValue("@Level", Level);
            conn.Open();
            int result=cmd.ExecuteNonQuery();
            conn.Close();
            return result;


        }

   }
}