private void btnDelete_Click(object sender, EventArgs e)
{
if (txtCode.Text != "")
{
DLDesignation objDLDesignation = new DLDesignation();
int ID = objDLDesignation.FetchIDbyCode(txtCode.Text);
if (ID > 0)
{
if (objDLDesignation.DeleteByID(ID) > 0)
{
MessageBox.Show("Record Deleted");
ClearControls();
}
else
{
MessageBox.Show("Record not Deleted");
}
}
else
{
MessageBox.Show("Invalid Code");
}
}
else
{
MessageBox.Show("Invalid Code");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
ELDesignation objELDesignation = new ELDesignation();
DLDesignation objDLDesignation = new DLDesignation();
int newID = 0;
if (lblDesignationID.Text.Length > 0)
{
objELDesignation.ID = Convert.ToInt32(lblDesignationID.Text);
}
else
{
newID = Common.GetNewID(tableName);
objELDesignation.ID = newID;
}
objELDesignation.Code = txtCode.Text;
objELDesignation.Name = txtName.Text;
objELDesignation.Creator = 0;
objELDesignation.Created = DateTime.Now;
objELDesignation.IsActive = false;
if (chkIsActive.Checked) objELDesignation.IsActive = true;
if (Validations())
{
if (objDLDesignation.Add(objELDesignation) > 0)
{
MessageBox.Show("Record Inserted");
// ClearControls();
}
else
{
MessageBox.Show("Record not Inserted");
}
}
}
private void gvDesignation_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex > 0)
{
string strCode = gvDesignation.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
string designationID = gvDesignation.Rows[e.RowIndex].Cells[0].Value.ToString();
ELDesignation objELDesignation = new ELDesignation();
DLDesignation objDLDesignation = new DLDesignation();
objELDesignation = objDLDesignation.FetchDesignationsByID(Convert.ToInt32(designationID));
if (objELDesignation != null)
{
lblDesignationID.Text = objELDesignation.ID.ToString();
txtCode.Text = objELDesignation.Code;
txtName.Text = objELDesignation.Name;
chkIsActive.Checked = Convert.ToBoolean(objELDesignation.IsActive);
}
}
gvDesignation.Visible = false;
}
private void btnView_Click(object sender, EventArgs e)
{
gvDesignation.Visible = true;
ClearControls();
DLDesignation objDLDesignation = new DLDesignation();
gvDesignation.DataSource = objDLDesignation.FetchDesginations();
if (gvDesignation.Rows.Count > 0)
{
for (int i = 0; i <= gvDesignation.Rows.Count - 1; i++)
{
gvDesignation.Columns[0].Visible = false;
}
}
}
