protected void GetDesignation()
{
Designationtbl ls = new Designationtbl();
List <Designationtbl> lst = new List <Designationtbl>();
lst = objDesignationBL.GetAllDesignation(ls).ToList();
gdvDesignation.DataSource = lst;
gdvDesignation.DataBind();
btnUpdate.Visible = false;
}
public ActionResult Create(Designationtbl category)
{
var result = category;
if (ModelState.IsValid)
{
result = designationService.Save(category);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
protected void GetDesignationById(int id)
{
Designationtbl cd = new Designationtbl();
cd.DepartmentId = id;
List <Designationtbl> lst = new List <Designationtbl>();
lst = objDesignationBL.GetDesignationById(cd).ToList();
foreach (var el in lst)
{
hdnDesignationId.Value = el.DesignationId.ToString();
ddlDeparment.SelectedValue = el.DepartmentId.ToString();
txtDesignation.Text = el.DesignationName;
hdnStatus.Value = el.IsActive.ToString();
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Designationtbl st = new Designationtbl();
st.DesignationId = Convert.ToInt32(hdnDesignationId.Value);
st.DesignationName = txtDesignation.Text;
st.DepartmentId = Convert.ToInt32(ddlDeparment.SelectedValue);
st.IsActive = Convert.ToInt32(hdnStatus.Value);
st.UpdatedBy = 1;
st.UpdatedDate = DateTime.Now.ToString(" yyyy-MM-dd HH:mm:ss");
List <Designationtbl> lst = new List <Designationtbl>();
lst = objDesignationBL.UpdateDesignation(st).ToList();
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "alertMessage('Designation Updated Successfully');", true);
Reset();
GetDesignation();
btnUpdate.Visible = false;
btnSave.Visible = true;
}
protected void GetDesignation(int DeptId)
{
Designationtbl desg = new Designationtbl();
desg.IsActive = 1;
desg.DepartmentId = DeptId;
//lstdesg = objDesignationBL.GetDesignationWithDepartment(desg).ToList();
lstdesg = objDesignationBL.GetDesignationByDepIsActive(desg).ToList();
DDLDesignation.Items.Clear();
DDLDesignation.Items.Add(new ListItem("--Select--", "0"));
foreach (var em in lstdesg)
{
//DDLDesignation.Items.Add(new ListItem(em.DesignationName, em.DesignationId.ToString()));
ListItem li = new ListItem();
li.Text = em.DesignationName;
li.Value = em.DesignationId.ToString();
DDLDesignation.Items.Add(li);
}
}
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 insertDesignation()
{
Designationtbl st = new Designationtbl();
st.DesignationName = txtDesignation.Text;
st.DepartmentId = Convert.ToInt32(ddlDeparment.SelectedValue);
st.IsActive = 1;
st.CreatedBy = 1;
st.CreatedDate = DateTime.Now.ToString(" yyyy-MM-dd HH:mm:ss");
st.UpdatedBy = 1;
st.UpdatedDate = DateTime.Now.ToString(" yyyy-MM-dd HH:mm:ss");
List <Designationtbl> lst = new List <Designationtbl>();
lst = objDesignationBL.SaveDesignation(st).ToList();
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "alertMessage('Designation Saved Successfully');", true);
btnSave.Visible = true;
GetDesignation();
}
protected void lbtnActive_Click(object sender, EventArgs e)
{
LinkButton lbtn = (LinkButton)sender;
GridViewRow gvr = (GridViewRow)lbtn.NamingContainer;
var val = gvr.DataItemIndex;
var status = gvr.Cells[3].Text;
Designationtbl st = new Designationtbl();
st.DesignationId = Convert.ToInt32(gvr.Cells[0].Text);
if (status == "Active")
{
st.IsActive = 0;
}
else if (status == "InActive")
{
st.IsActive = 1;
}
objDesignationBL.UpdateDesignationIsActive(st);
GetDesignation();
}
protected void lbtnEdit_Click(object sender, EventArgs e)
{
LinkButton lbtn = (LinkButton)sender;
GridViewRow gvr = (GridViewRow)lbtn.NamingContainer;
var val = gvr.DataItemIndex;
var id = Convert.ToInt32(gvr.Cells[0].Text);
Designationtbl st = new Designationtbl();
st.DesignationId = id;
List <Designationtbl> lst = new List <Designationtbl>();
lst = objDesignationBL.GetDesignationById(st).ToList();
foreach (var el in lst)
{
hdnDesignationId.Value = el.DesignationId.ToString();
hdnStatus.Value = el.IsActive.ToString();
ddlDeparment.SelectedValue = el.DepartmentId.ToString();
txtDesignation.Text = el.DesignationName;
}
btnSave.Visible = false;
btnUpdate.Visible = true;
}
public IEnumerable <Designationtbl> GetDesignationByDepIsActive(Designationtbl st)
{
return(objDesignationDA.DesignationAll(11, st));
}
public IEnumerable <Designationtbl> GetDesignationWithDepartment(Designationtbl st)
{
return(objDesignationDA.DesignationAll(9, st));
}
public IEnumerable <Designationtbl> GetDesignationByID(Designationtbl st)
{
return(objDesignationDA.DesignationAll(8, st));
}
public IEnumerable <Designationtbl> UpdateDesignationIsActive(Designationtbl st)
{
return(objDesignationDA.DesignationAll(6, st));
}
public IEnumerable <Designationtbl> DeleteDesignation(Designationtbl st)
{
return(objDesignationDA.DesignationAll(5, st));
}
public IEnumerable <Designationtbl> UpdateDesignation(Designationtbl st)
{
return(objDesignationDA.DesignationAll(4, st));
}
public IEnumerable <Designationtbl> SaveDesignation(Designationtbl st)
{
return(objDesignationDA.DesignationAll(3, st));
}
public IEnumerable <Designationtbl> GetAllDesignation(Designationtbl st)
{
return(objDesignationDA.DesignationAll(1, st));
}
protected void GetDesignation()
{
Designationtbl Desg = new Designationtbl();
lstDesg = objDesgBL.GetAllDesignation(Desg).ToList();
}
