private void dgvUsers_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int selectedRowIndex = this.dgvUsers.SelectedCells[0].RowIndex;
int selectedColumnIndex = this.dgvUsers.SelectedCells[0].ColumnIndex;
if (selectedColumnIndex == 0)//update
{
//MessageBox.Show("update click "+this.dgvUsers.Rows[selectedRowIndex].Cells[4].Value);access row value
cWorker w1 = new cWorker();
w1.wId = Convert.ToInt32(this.dgvUsers.Rows[selectedRowIndex].Cells[2].Value);
w1.wFullName = this.dgvUsers.Rows[selectedRowIndex].Cells[3].Value.ToString();
w1.wCNIC = this.dgvUsers.Rows[selectedRowIndex].Cells[4].Value.ToString();
w1.wAddress = this.dgvUsers.Rows[selectedRowIndex].Cells[5].Value.ToString();
w1.wMobileNo = this.dgvUsers.Rows[selectedRowIndex].Cells[6].Value.ToString();
w1.wEmergencyContact = this.dgvUsers.Rows[selectedRowIndex].Cells[7].Value.ToString();
w1.wdateOfJoin = Convert.ToDateTime(this.dgvUsers.Rows[selectedRowIndex].Cells[8].Value);
w1.wIsActive = Convert.ToBoolean(this.dgvUsers.Rows[selectedRowIndex].Cells[9].Value);
new cWorkerBLL().UpdateWorker(w1);
dgvUsers.DataSource = "";
dgvUsers.DataSource = new cWorkerBLL().getWorkers();
this.dgvUsers.Columns[2].ReadOnly = true;
MessageBox.Show("Data Updated...!!!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (selectedColumnIndex == 1)//delete
{
new cWorkerBLL().RemoveWorker(Convert.ToInt32(this.dgvUsers.Rows[selectedRowIndex].Cells[2].Value));
dgvUsers.DataSource = "";
dgvUsers.DataSource = new cWorkerBLL().getWorkers();
this.dgvUsers.Columns[2].ReadOnly = true;
MessageBox.Show("Data Deleted...!!!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public int InsertWorker(cWorker worker)
{
SqlConnection con = new SqlConnection(Helper.conStr);
if (con.State == System.Data.ConnectionState.Open)
{
con.Close();
}
con.Open();
string query = "INSERT into Workers (wFullname,wCNIC,wAddress,wMobileNo,wEmergencyContact,wdateOfJoin,uIsActive)" +
"values('" + worker.wFullName + "','" + worker.wCNIC + "','" + worker.wAddress + "','" + worker.wMobileNo + "','" + worker.wEmergencyContact + "','" + worker.wdateOfJoin + "','" + worker.wIsActive + "')";
SqlCommand cmd = new SqlCommand(query, con);
var result = cmd.ExecuteNonQuery();
con.Close();
cmd.Dispose();
con.Dispose();
return(result);
}
public int UpdateWorker(cWorker worker)
{
SqlConnection con = new SqlConnection(Helper.conStr);
if (con.State == System.Data.ConnectionState.Open)
{
con.Close();
}
con.Open();
string query = "UPDATE Workers " +
"SET wFullname = '" + worker.wFullName + "',wCNIC='" + worker.wCNIC + "',wAddress='" + worker.wAddress + "',wMobileNo='" + worker.wMobileNo + "',wEmergencyContact='" + worker.wEmergencyContact + "',wdateOfJoin='" + worker.wdateOfJoin + "',uIsActive='" + worker.wIsActive + "'" +
" WHERE wId ='" + worker.wId + "'";
SqlCommand cmd = new SqlCommand(query, con);
var result = cmd.ExecuteNonQuery();
con.Close();
cmd.Dispose();
con.Dispose();
return(result);
}
public List <cWorker> getWorkers(string workername)
{
List <cWorker> workers = new List <cWorker>();
SqlConnection con = new SqlConnection(Helper.conStr);
if (con.State == System.Data.ConnectionState.Open)
{
con.Close();
}
con.Open();
string query = "select * from Workers where wFullName LIKE '%" + workername + "%'";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
cWorker u1 = new cWorker();
u1.wId = Convert.ToInt32(reader["wId"]);
u1.wFullName = reader["wFullName"].ToString();
u1.wCNIC = reader["wCNIC"].ToString();
u1.wAddress = reader["wAddress"].ToString();
u1.wMobileNo = reader["wMobileNo"].ToString();
u1.wEmergencyContact = reader["wEmergencyContact"].ToString();
u1.wdateOfJoin = Convert.ToDateTime(reader["wdateOfJoin"]);
u1.wIsActive = Convert.ToBoolean(reader["uIsActive"]);
workers.Add(u1);
}
reader.Close();
con.Close();
con.Dispose();
cmd.Dispose();
return(workers);
}
private void button1_Click(object sender, EventArgs e)
{
cWorker worker = new cWorker();
worker.wFullName = txtfullname.Text.Trim();
worker.wCNIC = txtCNIC.Text.Trim();
worker.wAddress = txtAddress.Text.Trim();
worker.wMobileNo = txtMobileNo.Text.Trim();
worker.wEmergencyContact = cbEmergency.Text.Trim();
worker.wdateOfJoin = dtpJoining.Value;
worker.wIsActive = cbIsActive.Checked;
if (worker.wFullName != "")
{
if (worker.wCNIC != "")
{
if (worker.wAddress != "")
{
if (worker.wMobileNo != "")
{
if (worker.wEmergencyContact != "")
{
if (new cWorkerBLL().InsertWorker(worker) > 0)
{
//valid record or user
/**/
MessageBox.Show("Data stored...!!!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtfullname.Text = "";
txtCNIC.Text = "";
txtAddress.Text = "";
txtMobileNo.Text = "";
cbEmergency.Text = "";
cbEmergency.Items.Clear();
dtpJoining.ResetText();
cbIsActive.Checked = false;
}
else
{
MessageBox.Show("Data cannot be stored...!!!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("Emergencey Contact No. Must be entered...!!!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("Mobile No should be selected...!!!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("Address should be filled...!!!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("CNIC should be filled...!!!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("Full Name should be filled...!!!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public int UpdateWorker(cWorker worker)
{
return(new cWorkerDAL().UpdateWorker(worker));
}
public int InsertWorker(cWorker worker)
{
return(new cWorkerDAL().InsertWorker(worker));
}
