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