public void getDesignationName()
{
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
DesignationBL objDesignationBL = new DesignationBL();
objResult = objDesignationBL.Designation_SelectAll_ForDropDown();
if (objResult != null)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddlDesignation, "DesignationNameENG", "DesignationID");
if (objResult.resultDT.Rows.Count > 0)
{
}
ddlDesignation.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select All--", "-1"));
}
}
public void BindDesignation()
{
ApplicationResult objResult = new ApplicationResult();
DesignationBL objDesignationbl = new DesignationBL();
objResult = objDesignationbl.Designation_SelectAll();
if (objResult.resultDT.Rows.Count > 0)
{
gvDesignation.DataSource = objResult.resultDT;
gvDesignation.DataBind();
PanelVisibility(1);
}
else
{
PanelVisibility(2);
}
}
protected void gvDesignation_OnRowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
ApplicationResult objResult = new ApplicationResult();
DesignationBL objDesignationBL = new DesignationBL();
if (e.CommandName.ToString() == "Edit1")
{
ViewState["Mode"] = "Edit";
ViewState["DesignationID"] = e.CommandArgument.ToString();
objResult = objDesignationBL.Designation_Select(Convert.ToInt32(ViewState["DesignationID"].ToString()));
if (objResult != null)
{
DataTable dtResult = objResult.resultDT;
if (dtResult.Rows.Count > 0)
{
txtDesignationNameENG.Text = dtResult.Rows[0][DesignationBO.DESIGNATION_DESIGNATIONNAMEENG].ToString();
txtDesignationNameGUJ.Text = dtResult.Rows[0][DesignationBO.DESIGNATION_DESIGNATIONNAMEGUJ].ToString();
txtDescription.Text = dtResult.Rows[0][DesignationBO.DESIGNATION_DESCRIPTION].ToString();
PanelVisibility(2);
}
}
}
else if (e.CommandName.ToString() == "Delete1")
{
objResult = objDesignationBL.Designation_Delete(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session[ApplicationSession.USERID]),
DateTime.UtcNow.AddHours(5.5).ToString());
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record deleted successfully.');</script>");
PanelVisibility(1);
BindDesignation();
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You cannot delete this record because it is in used.');</script>");
}
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
protected void GetDesignation(int dept)
{
List <Designationtbl> lstDesignation = new List <Designationtbl>();
Designationtbl dsgt = new Designationtbl();
DesignationBL objDesignationBL = new DesignationBL();
dsgt.IsActive = 1;
dsgt.DepartmentId = dept;
lstDesignation = objDesignationBL.GetDesignationByDepIsActive(dsgt).ToList();
DDLDesignation.Items.Clear();
DDLDesignation.Items.Add(new ListItem("--Select--", "0"));
foreach (var cnt in lstDesignation)
{
ListItem li = new ListItem();
li.Text = cnt.DesignationName;
li.Value = cnt.DesignationId.ToString();
DDLDesignation.Items.Add(li);
}
}
protected void GetEmployeeById(int EmpId)
{
Employeetbl Emp = new Employeetbl
{
EmpId = EmpId
};
List <Employeetbl> lstEmp = new List <Employeetbl>();
lstEmp = objEmployeeBL.GetEmployeeById(Emp).ToList();
foreach (var el in lstEmp)
{
txtEID.Text = el.EmployeeId;
txtEmail.Text = el.Email;
txtDOB.Text = el.DateOfBirth;
txtMobile.Text = el.MobileNo;
txtUsername.Text = el.Username;
TxtPassword.Text = el.Password;
txtFname.Text = el.FirstName;
txtLName.Text = el.LastName;
DDLGender.SelectedValue = el.Gender;
DDLMaritalStatus.SelectedValue = el.MaritalStatus;
txtMobile.Text = el.MobileNo;
txtAddress.Text = el.Address;
txtDateOfJoin.Text = el.DateOfJoin;
DDLRole.SelectedValue = el.RoleId;
DDLDept.SelectedValue = el.DepartmentId.ToString();
DesignationBL objDesignationBL = new DesignationBL();
List <Designationtbl> lstdesg = new List <Designationtbl>();
GetDesignation(el.DepartmentId);
DDLDesignation.SelectedValue = el.DesignationId.ToString();
DDLRManager.SelectedValue = el.ReportingManager;
hdnEmpId.Value = el.EmpId.ToString();
hdnStatus.Value = el.IsActive.ToString();
}
}
protected void btnSaveClass_OnClick(object sender, EventArgs e)
{
try
{
DesignationBO objDesignationBO = new DesignationBO();
DesignationBL objDesignationBL = new DesignationBL();
ApplicationResult objResult = new ApplicationResult();
DataTable dtResult = new DataTable();
int intDesignationID = 0;
objDesignationBO.DesignationNameENG = txtDesignationNameENG.Text.Trim();
objDesignationBO.DesignationNameGUJ = txtDesignationNameGUJ.Text.Trim();
objDesignationBO.Description = txtDescription.Text.Trim();
objDesignationBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objDesignationBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
//Code For Validate Designation Name
if (ViewState["Mode"].ToString() == "Save")
{
intDesignationID = -1;
}
else if (ViewState["Mode"].ToString() == "Edit")
{
intDesignationID = Convert.ToInt32(ViewState["DesignationID"].ToString());
}
objResult = objDesignationBL.Designation_ValidateName(intDesignationID, objDesignationBO.DesignationNameENG);
if (objResult != null)
{
dtResult = objResult.resultDT;
if (dtResult.Rows.Count > 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Designation name already exist.');</script>");
}
else
{
if (ViewState["Mode"].ToString() == "Save")
{
objDesignationBO.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objDesignationBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objResult = objDesignationBL.Designation_Insert(objDesignationBO);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record saved successfully.');</script>");
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
objDesignationBO.DesignationID = Convert.ToInt32(ViewState["DesignationID"].ToString());
objResult = objDesignationBL.Designation_Update(objDesignationBO);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record updated successfully.');</script>");
}
}
ClearAll();
BindDesignation();
PanelVisibility(1);
}
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
