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")); }