public String SaveRegistrationDetails(MVC_LD.Models.RegisterModel model) { String returnvalue = String.Empty; String encryptedPassword = AppHelper.Encrypt(model.Password); try { using (connection = new SqlConnection(ConnectionString)) { using (command = new SqlCommand(HelperConstants.sp_sp_SaveRegistrationDetails, connection)) { command.CommandType = CommandType.StoredProcedure; SqlParameter EmployeeIdParameter = new SqlParameter(HelperConstants.sp_EmployeeId, model.EmployeeId); SqlParameter EmployeeNameParameter = new SqlParameter(HelperConstants.sp_EmployeeName, model.EmployeeName); SqlParameter PasswordParameter = new SqlParameter(HelperConstants.sp_Password, encryptedPassword); SqlParameter SexParameter = new SqlParameter(HelperConstants.sp_Sex, model.Sex); SqlParameter DOBParameter = new SqlParameter(HelperConstants.sp_DOB, model.DOB); SqlParameter VerticalParameter = new SqlParameter(HelperConstants.sp_Vertical, model.Vertical); SqlParameter ContactNoParameter = new SqlParameter(HelperConstants.sp_ContactNo, model.ContactNo); SqlParameter EmailIdParameter = new SqlParameter(HelperConstants.sp_EmailId, model.EmailID); int staffvalue = model.IsStaff == true ? 1 : 0; SqlParameter IsStaffParameter = new SqlParameter(HelperConstants.sp_IsStaff, staffvalue); SqlParameter ReturnMessageParameter = new SqlParameter(HelperConstants.sp_ReturnMessage, SqlDbType.VarChar, 20) { Direction = ParameterDirection.Output }; command.Parameters.AddRange(new SqlParameter[] { EmployeeIdParameter, EmployeeNameParameter, PasswordParameter, SexParameter, DOBParameter, VerticalParameter, ContactNoParameter, EmailIdParameter, IsStaffParameter, ReturnMessageParameter }); connection.Open(); command.ExecuteNonQuery(); returnvalue = Convert.ToString(ReturnMessageParameter.Value); } } } catch (Exception) { throw; } finally { connection.Close(); connection.Dispose(); } return(returnvalue); }
public ActionResult FirstTimeUserLogin(MVC_LD.Models.RegisterModel model) { String message = String.Empty; message = _dl.SaveRegistrationDetails(model); if (message.Equals(HelperConstants.Success)) { return(RedirectToAction("Login", "Account")); } else { TempData[HelperConstants.ErrorMessage] = HelperConstants.ErrorDescription; return(View(HelperConstants.view_Register)); } }