public JsonResult UpdateResignation(ResignationModel rmodel)
{
MastersModel mm = new MastersModel();
string res = "";
try
{
//res = r_layer.Update_Resignation(Convert.ToInt32(Session["EMP_ID"]), rmodel.Status);
res = r_layer.Update_Resignation(rmodel.EMP_ID, rmodel.Status, Convert.ToInt32(Session["EMP_ID"]));
string[] response = res.Split(',');
if (response[0] == "Success")
{
mm.SuccessMsg = response[1];
}
else if (response[0] == "Error")
{
mm.ErrorMsg = response[1];
}
}
catch (Exception ex)
{
mm.ErrorMsg = ex.Message;
}
return(Json(mm, JsonRequestBehavior.AllowGet));
}
// GET: Resignation
public ActionResult Emp_Resignation()
{
List <ResignationModel> EmpResignationList = new List <ResignationModel>();
try
{
dt = r_layer.GetEmpResignation(Convert.ToInt32(Session["Emp_id"]));
foreach (DataRow dr in dt.Rows)
{
ResignationModel rm = new ResignationModel();
rm.Role = Convert.ToInt32(dr["Role"]);
rm.EMP_ID = Convert.ToInt32(Session["Emp_id"]);
rm.NAME = dr["Emp_Name"].ToString();
rm.REPORTING_MANAGER = dr["MANAGER_NAME"].ToString();
rm.DEPARTMENT = dr["department_name"].ToString();
rm.Current_Date = dr["currentDate"].ToString();
rm.LastWorking_Date = dr["LastWorkingDate"].ToString();
EmpResignationList.Add(rm);
//GetStatus();
//GetRole_id();
}
return(View(EmpResignationList));
}
catch (Exception ex)
{
return(View());
}
}
public JsonResult EditResignation(int EMP_ID)
{
ResignationModel objRM = new ResignationModel();
objRM = r_layer.GetResignationDetails(EMP_ID);
return(Json(objRM, JsonRequestBehavior.AllowGet));
}
public ActionResult Resignation_History()
{
List <ResignationModel> ResignationList = new List <ResignationModel>();
try
{
dt = r_layer.GetResignation_History(Convert.ToInt32(Session["EMP_ID"]));
foreach (DataRow dr in dt.Rows)
{
ResignationModel rm = new ResignationModel();
rm.Role = Convert.ToInt32(dr["Role"]);
rm.EMP_ID = Convert.ToInt32(dr["EMP_ID"]);
rm.NAME = dr["NAME"].ToString();
rm.REPORTING_MANAGER = dr["REPORTING_MANAGER"].ToString();
rm.DEPARTMENT = dr["DEPARTMENT"].ToString();
rm.Current_Date = dr["RESIGNATION_DATE"].ToString();
rm.LastWorking_Date = dr["LAST_WORKING_DATE"].ToString();
rm.Show_Status = dr["Status"].ToString();
ResignationList.Add(rm);
GetStatus();
GetRole_id();
}
}
catch (Exception)
{
throw;
}
return(View(ResignationList));
}
public ResignationModel GetResignationDetails(int EMP_ID)
{
ResignationModel objResignation = new ResignationModel();
try
{
connection();
using (SqlCommand objCmd = new SqlCommand("PRC_ViewResignationBYID", con))
{
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("@EMP_ID", EMP_ID);
con.Open();
SqlDataReader objDr = objCmd.ExecuteReader();
while (objDr.Read())
{
objResignation.RESIGNATION_ID = Convert.ToInt32(objDr["RESIGNATION_ID"]);
objResignation.EMP_ID = Convert.ToInt32(objDr["EMP_ID"]);
objResignation.NAME = objDr["NAME"].ToString();
objResignation.REPORTING_MANAGER = objDr["REPORTING_MANAGER"].ToString();
objResignation.DEPARTMENT = objDr["DEPARTMENT"].ToString();
objResignation.Current_Date = objDr["RESIGNATION_DATE"].ToString();
objResignation.LastWorking_Date = objDr["LAST_WORKING_DATE"].ToString();
}
con.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(objResignation);
}
public JsonResult CreateEmpResignation(ResignationModel rmodel)
{
MastersModel mm = new MastersModel();
string res = "";
try
{
res = r_layer.CreateEmpResignation(rmodel.EMP_ID, rmodel.NAME, rmodel.REPORTING_MANAGER, rmodel.DEPARTMENT, rmodel.RESIGNATION_DATE, rmodel.LAST_WORKING_DATE, rmodel.Status);
string[] response = res.Split(',');
if (response[0] == "Success")
{
mm.SuccessMsg = response[1];
}
else if (response[0] == "Error")
{
mm.ErrorMsg = response[1];
}
}
catch (Exception ex)
{
mm.ErrorMsg = ex.Message;
}
return(Json(mm, JsonRequestBehavior.AllowGet));
}
