public EntityDepartment GetDepartMentByName(EntityDepartment ent)
{
EntityDepartment obj = (from tbl in objData.tblDepartments
where tbl.DeptDesc.Equals(ent.DeptDesc)
select new EntityDepartment {
DeptCode = tbl.DeptCode, DeptDesc = tbl.DeptDesc
}).FirstOrDefault();
return(obj);
}
protected void BtnEdit_Click(object sender, EventArgs e)
{
int lintCnt = 0;
try
{
EntityDepartment entDept = new EntityDepartment();
entDept.DeptCode = txtDeptCode.Text;
entDept.DeptDesc = txtDeptDesc.Text;
entDept.ChangeBy = SessionWrapper.UserName;
if (mobjDeptBLL.GetDepartMent(entDept) != null)
{
lintCnt = mobjDeptBLL.UpdateDepartment(entDept);
if (lintCnt > 0)
{
GetDepartments();
lblMessage.Text = "Record Updated Successfully";
}
else
{
lblMessage.Text = "Record Not Updated";
}
}
else if (mobjDeptBLL.GetDepartMentByName(entDept) == null)
{
lintCnt = mobjDeptBLL.UpdateDepartment(entDept);
if (lintCnt > 0)
{
GetDepartments();
lblMessage.Text = "Record Updated Successfully";
}
else
{
lblMessage.Text = "Record Not Updated";
}
}
else
{
lblMessage.Text = "Record already exist";
}
MultiView1.SetActiveView(View1);
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
public int DeleteDepartment(EntityDepartment entDept)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@DeptCode", DbType.String, entDept.DeptCode);
cnt = mobjDataAcces.ExecuteQuery("sp_DeleteDepartment", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("DepartmentBLL - DeleteDepartment(EntityDepartment entDept)", ex);
}
return(cnt);
}
protected void BtnSave_Click(object sender, EventArgs e)
{
int lintcnt = 0;
EntityDepartment entDept = new EntityDepartment();
if (string.IsNullOrEmpty(txtDeptCode.Text.Trim()))
{
lblMsg.Text = "Please Enter Department Code";
}
else
{
if (string.IsNullOrEmpty(txtDeptDesc.Text.Trim()))
{
lblMsg.Text = "Please Enter Department Description";
}
else
{
entDept.DeptCode = txtDeptCode.Text.Trim();
entDept.DeptDesc = txtDeptDesc.Text.Trim();
entDept.EntryBy = SessionWrapper.UserName;
if (!Commons.IsRecordExists("tblDepartment", "DeptDesc", entDept.DeptDesc))
{
lintcnt = mobjDeptBLL.InsertDepartment(entDept);
if (lintcnt > 0)
{
GetDepartments();
lblMessage.Text = "Record Inserted Successfully....";
Session["update"] = Server.UrlEncode(System.DateTime.Now.ToString());
}
else
{
lblMessage.Text = "Record Not Inserted...";
}
}
else
{
lblMessage.Text = "Record Already Exist....";
}
}
}
MultiView1.SetActiveView(View1);
}
protected void BtnDeleteOk_Click(object sender, EventArgs e)
{
EntityDepartment entDept = new EntityDepartment();
int cnt = 0;
try
{
foreach (GridViewRow drv in dgvDepartment.Rows)
{
CheckBox chkDelete = (CheckBox)drv.FindControl("chkDelete");
if (chkDelete.Checked)
{
LinkButton lnkDeptCode = (LinkButton)drv.FindControl("lnkDeptCode");
string lstrDeptCode = lnkDeptCode.Text;
entDept.DeptCode = lstrDeptCode;
cnt = mobjDeptBLL.DeleteDepartment(entDept);
if (cnt > 0)
{
lblMessage.Text = "Record Deleted Successfully....";
if (dgvDepartment.Rows.Count <= 0)
{
hdnPanel.Value = "none";
}
}
else
{
lblMessage.Text = "Record Not Deleted....";
}
}
}
GetDepartments();
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
