public bool SignUp(SignUpBal bal)
{
bool status = false;
using (SqlConnection cn = new SqlConnection(ConfigurationManager
.ConnectionStrings["ZigmaCS"].ToString()))
{
try
{
SqlCommand cmd = new SqlCommand("InsertIntoSignUp", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Loginid", bal.UserId);
cmd.Parameters.AddWithValue("@Name", bal.Fullname);
cmd.Parameters.AddWithValue("@Address", bal.Address);
cmd.Parameters.AddWithValue("@Pno", bal.PhoneNumber);
cmd.Parameters.AddWithValue("@DOB", bal.DateOfBirth);
cmd.Parameters.AddWithValue("@NewPass", bal.Password);
cn.Open();
int row = cmd.ExecuteNonQuery();
if (row == -1)
{
status = true;
}
}
catch (Exception ex)
{
status = false;
throw new Exception(ex.Message);
}
return(status);
}
}
public ActionResult SignUp(SignUpModel signup)
{
SignUpBal bal = new SignUpBal();
//Session passing
bal.UserId = Convert.ToInt32(Session["loginid"]);
bal.Fullname = signup.Fullname;
bal.Address = signup.Address;
bal.DateOfBirth = signup.DateOfBirth;
bal.PhoneNumber = signup.PhoneNumber;
bal.Password = signup.NewPassword;
SignUpDal sgnup = new SignUpDal();
bool status = sgnup.SignUp(bal);
if (status)
{
return(RedirectToAction("MainLogin", "LoginMain"));
}
else
{
return(View());
}
}
