public ActionResult Index(StudentRegisterClass studentRegister, string buttonType)
{
try
{
if (buttonType == "Save")
{
string msg = rdb.AddRegisterRecord(studentRegister);
TempData["msg"] = msg;
}
else if (buttonType == "Login")
{
string Value = ldb.chkLoginDetails(studentRegister);
if (Value == null)
{
TempData["msg"] = "Please enter valid credintials";
}
}
}
catch (Exception ex)
{
TempData["msg"] = ex.Message;
}
return(View());
}
public string AddRegisterRecord(StudentRegisterClass RegisterValues)
{
try
{
SqlCommand cmd = new SqlCommand("sp_Student_Register", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StudentName", RegisterValues.Name);
cmd.Parameters.AddWithValue("@UserName", RegisterValues.UserName);
cmd.Parameters.AddWithValue("@Email", RegisterValues.Email);
cmd.Parameters.AddWithValue("@MobileNumber", RegisterValues.MobileNumber);
cmd.Parameters.AddWithValue("@UserPassword", RegisterValues.UserPassword);
cmd.Parameters.AddWithValue("@DOB", RegisterValues.DOB);
cmd.Parameters.AddWithValue("@Gender", RegisterValues.Gender);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
return("you are successfully registered, Login using your credentials");
}
catch (Exception Ex)
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
return(Ex.Message.ToString());
}
}
public string chkLoginDetails(StudentRegisterClass login)
{
try
{
SqlCommand cmd = new SqlCommand("sp_Check_Login", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserName", login.LoginUserName);
cmd.Parameters.AddWithValue("@UserPassword", login.LoginPassword);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
return(reader.GetString(1));
}
}
return(null);
}
catch (Exception Ex)
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
return(Ex.Message.ToString());
}
finally {
con.Close();
}
}
