コード例 #1
0
ファイル: EmployeeController.cs プロジェクト: vksundaram/hrms
        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"));
        }