public JsonResult GetEmployeeDetails(string EmpId)
{
MTSHRDataLayer.Employee data_emp = new MTSHRDataLayer.Employee();
var employeeData = Json(JsonConvert.SerializeObject(data_emp.Read(EmpId).Tables[0]));
return(Json(new { result = employeeData }, JsonRequestBehavior.AllowGet));
}
public ActionResult UserDetails()
{
Int64 id = (Int64)TempData["rowId"];
TempData.Keep("rowId");
MTSHRDataLayer.Employee data_emp = new MTSHRDataLayer.Employee();
var employeeData = Json(JsonConvert.SerializeObject(data_emp.Read(id)), JsonRequestBehavior.AllowGet);
ViewBag.EmployeeData = employeeData.Data;
MTSHRDataLayer.EmployeeImage data_image = new MTSHRDataLayer.EmployeeImage();
byte[] imagedata = data_image.Read(id);
if (imagedata == null)
{
string path = Server.MapPath("~/Content/images/Default.jpg");
byte[] imageByteData = System.IO.File.ReadAllBytes(path);
String baseimage = Convert.ToBase64String(imageByteData);
ViewBag.Image = baseimage;
}
else if (imagedata != null)
{
String baseimage = Convert.ToBase64String(imagedata);
ViewBag.Image = baseimage;
}
return(View("UserDetails"));
}
private List <SelectListItem> getdepartment()
{
MTSHRDataLayer.Employee data_dep = new MTSHRDataLayer.Employee();
List <SelectListItem> departmentlist = new List <SelectListItem>();
try
{
var employeeDepartment = data_dep.getDepartment();
departmentlist.Add(new SelectListItem()
{
Value = "", Text = "---- Select Department----"
});
for (int i = 0; i < employeeDepartment.Tables[0].Rows.Count; i++)
{
departmentlist.Add(new SelectListItem()
{
Value = employeeDepartment.Tables[0].Rows[i]["id"].ToString(), Text = employeeDepartment.Tables[0].Rows[i]["Department"].ToString()
});
}
}
catch (Exception exec)
{
BaseExceptionHandler.HandleException(ref exec);
}
return(departmentlist);
}
private List <SelectListItem> getmaritalstatus()
{
MTSHRDataLayer.Employee data_emp = new MTSHRDataLayer.Employee();
List <SelectListItem> maritalstatus = new List <SelectListItem>();
try
{
var employeemaritalstatus = data_emp.getMaritalstatus();
maritalstatus.Add(new SelectListItem()
{
Value = "", Text = "---- Select Marital Status----"
});
for (int i = 0; i < employeemaritalstatus.Tables[0].Rows.Count; i++)
{
maritalstatus.Add(new SelectListItem()
{
Value = employeemaritalstatus.Tables[0].Rows[i]["id"].ToString(), Text = employeemaritalstatus.Tables[0].Rows[i]["Marital_status"].ToString()
});
}
}
catch (Exception exec)
{
BaseExceptionHandler.HandleException(ref exec);
}
return(maritalstatus);
}
public ActionResult EditEmployee(Employee emp)
{
try
{
MTSHRDataLayer.Employee data_emp = new MTSHRDataLayer.Employee();
data_emp.UpdateEmployeeLeavePolicy(emp.id, emp.DepartmentId);
Int64 result = data_emp.Edit(emp.Aadhar, emp.Dateofbirth, emp.Dateofjoin, emp.Designation, emp.DepartmentId, emp.Email, emp.Employee_ID, emp.Fathername, emp.Firstname, emp.Gender, emp.id, emp.Lastname, emp.Maritalstatus, emp.Mobile, emp.Nationality, emp.Pancard, emp.Spousename, emp.PF_AccountNumber, emp.PF_UAN, emp.ESI_Number, emp.FunctionalRole);
if (result >= 1)
{
TempData["employeeid"] = result;
TempData.Keep("employeeid");
return(Content("EditSuccess"));
}
else
{
return(Content("Failed"));
}
}
catch (Exception ex)
{
BaseExceptionHandler.HandleException(ref ex);
}
return(Content("Failed"));
}
private List <SelectListItem> getnationality()
{
MTSHRDataLayer.Employee data_emp = new MTSHRDataLayer.Employee();
List <SelectListItem> nationality = new List <SelectListItem>();
try
{
var employeenationality = data_emp.getNationality();
nationality.Add(new SelectListItem()
{
Value = "", Text = "----Select Nationality----"
});
for (int i = 0; i < employeenationality.Tables[0].Rows.Count; i++)
{
nationality.Add(new SelectListItem()
{
Value = employeenationality.Tables[0].Rows[i]["id"].ToString(), Text = employeenationality.Tables[0].Rows[i]["Nationality"].ToString()
});
}
}
catch (Exception exec)
{
BaseExceptionHandler.HandleException(ref exec);
}
return(nationality);
}
public int SetActive(Int64 id, int active, string inActiveDate)
{
MTSHRDataLayer.Employee data_emp = new MTSHRDataLayer.Employee();
int result = data_emp.ActivateAccount(id, active, inActiveDate);
return(result);
}
public JsonResult Read_Employeedetails()
{
string empid = Session["UserID"].ToString();
Int64 id = Convert.ToInt64(empid);
MTSHRDataLayer.Employee data_emp = new MTSHRDataLayer.Employee();
return(Json(JsonConvert.SerializeObject(data_emp.Read(id)), JsonRequestBehavior.AllowGet));
}
public ActionResult Employee()
{
try
{
Employee emp = new Employee();
MTSHRDataLayer.Employee data_emp = new MTSHRDataLayer.Employee();
ViewBag.designation = getdesignation();
ViewBag.department = getdepartment();
ViewBag.maritalstatus = getmaritalstatus();
ViewBag.nationality = getnationality();
ViewBag.EmployeeId = data_emp.getlastemployeeid();
ViewBag.FunctionalRoleList = getFunctionalRole();
ViewBag.actionURL = "AddEmployee";
string empid = TempData["employeeid"].ToString();
TempData.Keep("employeeid");
if (!String.IsNullOrEmpty(TempData["employeeid"].ToString()))
{
ViewBag.actionURL = "EditEmployee";
ViewBag.EmployeeData = JsonConvert.SerializeObject(data_emp.getemployeedetails(empid));
DataTable empdata = data_emp.getemployeedetails(empid);
if (empdata.Rows[0]["Aadhar"].ToString() != "")
{
emp.Aadhar = (Int64)empdata.Rows[0]["Aadhar"];
}
emp.Mobile = (String)empdata.Rows[0]["Mobile"];
emp.Dateofbirth = DateTime.Parse(empdata.Rows[0]["Dateofbirth"].ToString());
emp.Dateofjoin = DateTime.Parse(empdata.Rows[0]["Dateofjoin"].ToString());
emp.Designation = (Int64)empdata.Rows[0]["designationid"];
emp.DepartmentId = (Int64)empdata.Rows[0]["departmentid"];
emp.FunctionalRole = (Int64)empdata.Rows[0]["FunctionalRole"];
emp.Email = (String)empdata.Rows[0]["Email"];
emp.Employee_ID = (String)empdata.Rows[0]["Employee_Id"];
emp.Fathername = (String)empdata.Rows[0]["Fathername"];
emp.Firstname = (String)empdata.Rows[0]["Firstname"];
emp.Gender = (Int64)empdata.Rows[0]["Gender"];
emp.id = (Int64)empdata.Rows[0]["id"];
emp.Lastname = (String)empdata.Rows[0]["Lastname"];
emp.Maritalstatus = (Int64)empdata.Rows[0]["maritalid"];
emp.Nationality = (Int64)empdata.Rows[0]["nationalityid"];
emp.Pancard = empdata.Rows[0]["Pancard"]?.ToString();
emp.Spousename = (String)empdata.Rows[0]["Spousename"];
emp.PF_AccountNumber = empdata.Rows[0]["PF_AccountNumber"]?.ToString();
if (empdata.Rows[0]["PF_UAN"].ToString() != "")
{
emp.PF_UAN = (Int64)empdata.Rows[0]["PF_UAN"];
}
emp.ESI_Number = empdata.Rows[0]["ESI_Number"]?.ToString();
return(PartialView("Employee", emp));
}
}
catch (Exception exec)
{
BaseExceptionHandler.HandleException(ref exec);
}
return(PartialView("Employee"));
}
public ActionResult AddEmployee(Employee emp)
{
try
{
MTSHRDataLayer.Employee data_emp = new MTSHRDataLayer.Employee();
int Empidresult = data_emp.GetEmployeeId(emp.Employee_ID, emp.Email);
if (Empidresult != 1)
{
Encrypt encrypt = new Encrypt();
string password = encrypt.CreateRandomPassword(6);
string hashPwd = encrypt.GetSHA1HashData(password);
int RetVal = 0;
//Get Paremeters from the Database
//Status=1, initial status when user created.
string TemplateId = "2";
string SpName = emp.Email + "," + emp.Firstname + "," + emp.Lastname + "," + password;
DbCommand DCMD = DataAccess.ExecuteNonQueryCMD("MTS_AddEmailMasterEntry", TemplateId, SpName);
DbCommand cmd = DataAccess.ExecuteNonQueryCMD("MTS_ADDUSER",
emp.Email,
hashPwd,
emp.Firstname,
emp.Lastname,
emp.Email,
2, //Default user Role
true, //Active
1, //Status
false); //Locked
RetVal = Convert.ToInt16(cmd.Parameters["@RETURN_VALUE"].Value.ToString());
int result = data_emp.Create(emp.Aadhar, emp.Dateofbirth, emp.Dateofjoin, emp.Designation, emp.Email, emp.Employee_ID, emp.Fathername, emp.Firstname, emp.Gender, emp.Lastname, emp.Maritalstatus, emp.Mobile, emp.Nationality, emp.Pancard, emp.Spousename, emp.PF_AccountNumber, emp.PF_UAN, emp.ESI_Number, emp.DepartmentId, emp.FunctionalRole);
if (result > 0)
{
return(Content("Success"));
}
else
{
return(RedirectToAction("Employee", "Employee"));
}
}
else
{
return(Content("Failed"));
}
}
catch (Exception exec)
{
BaseExceptionHandler.HandleException(ref exec);
}
return(Content("Failed"));
}
public ActionResult EditRole(int?RoleId)
{
MTSHRDataLayer.Employee employee = new MTSHRDataLayer.Employee();
Int64 result = new Int64();
try
{
result = employee.EditRole((Int64)TempData["employeeid"], RoleId);
TempData.Keep("employeeid");
}
catch (Exception ex)
{
ex.Data.Clear();
result = -999;
}
return(Content(result.ToString()));
}
public ActionResult ReadEmployeeDetails()
{
try
{
Int64 id = (Int64)TempData["employeeid"];
TempData.Keep("employeeid");
MTSHRDataLayer.Employee data_emp = new MTSHRDataLayer.Employee();
var employeeData = Json(JsonConvert.SerializeObject(data_emp.Read(id)), JsonRequestBehavior.AllowGet);
ViewBag.EmployeeData = employeeData.Data;
MTSHRDataLayer.Employee employee = new MTSHRDataLayer.Employee();
var role = employee.GetRole(id);
Session["Role"] = role.Rows[0][0].ToString();
MTSHRDataLayer.EmployeeImage data_image = new MTSHRDataLayer.EmployeeImage();
byte[] imagedata = data_image.Read(id);
if (imagedata == null)
{
string path = Server.MapPath("~/Content/images/Default.jpg");
byte[] imageByteData = System.IO.File.ReadAllBytes(path);
String baseimage = Convert.ToBase64String(imageByteData);
ViewBag.Image = baseimage;
}
else if (imagedata != null)
{
String baseimage = Convert.ToBase64String(imagedata);
ViewBag.Image = baseimage;
}
}
catch (Exception exec)
{
BaseExceptionHandler.HandleException(ref exec);
}
return(View("EmployeeDetails"));
}
protected override void OnActionExecuting(ActionExecutingContext filterContext)
{
if (SessionHelper.LogonUser == null)
{
if (filterContext.HttpContext.Request.IsAjaxRequest())
{
filterContext.HttpContext.Response.StatusCode = 403;
filterContext.Result = new JsonResult
{
Data = "SessionTimeOut",
JsonRequestBehavior = JsonRequestBehavior.AllowGet
};
}
else
{
filterContext.Result = new RedirectToRouteResult(
new RouteValueDictionary(new
{
action = "logon",
controller = "account",
area = "MTS.Login"
}));
}
}
if (Request.Url.ToString().Length > 0)
{
string url = Request.Url.ToString();
Int64 roleid = Convert.ToInt64(Session["roleid"]);
MTSHRDataLayer.Employee data_emp = new MTSHRDataLayer.Employee();
//datatable dt = data_emp.checkauthorization();
//bool checkurl = dt.asenumerable().where(c => convert.tostring((c.field<string>("url"))).equals(url)).count() > 0;
//if (checkurl == true)
//{
int status = data_emp.CheckAccessURL(roleid, url, Convert.ToInt64(Session["UserId"])); //, Convert.ToInt64(Session["UserId"])
if (status == 0)
{
filterContext.Result = new RedirectToRouteResult(
new RouteValueDictionary(new
{
action = "logon",
controller = "account",
area = "mts.login"
}));
}
//}
}
if (filterContext.HttpContext.Request.IsAjaxRequest())
{
}
else
{
if (SessionHelper.AccessUrls != null)
{
bool isValidUrl = false;
var rd = HttpContext.Request.RequestContext.RouteData;
string areaName = rd.DataTokens["area"] as string;
areaName = string.IsNullOrEmpty(areaName) ? "" : areaName;
string actionName = "/" + rd.GetRequiredString("action");
string controllerName = string.IsNullOrEmpty(areaName) ? rd.GetRequiredString("controller") : "/" + rd.GetRequiredString("controller");
string baseurl = HttpContext.Request.ApplicationPath;
baseurl = baseurl.Length == 1 ? string.Empty : baseurl;
string currUlr = string.Concat(baseurl + "/", areaName, controllerName, actionName); //filterContext.HttpContext.Request.AppRelativeCurrentExecutionFilePath.Replace("~", "..");
List <string> lstAccessUrls = new List <string>(SessionHelper.AccessUrls);
foreach (string url in lstAccessUrls.AsEnumerable())
{
if (currUlr.ToLower().Trim().Equals(url.Trim().ToLower().Contains("?") ? url.Trim().ToLower().Remove(url.IndexOf('?')) : url.Trim().ToLower()))
{
isValidUrl = true;
}
}
if (!isValidUrl)
{
filterContext.Result = new RedirectToRouteResult(
new RouteValueDictionary(new
{
action = "logon",
controller = "account",
area = "MTS.Login"
}));
}
}
}
base.OnActionExecuting(filterContext);
}
