public ActionResult Index(LoginModel loginmodel, Logincradancial lg)
{
if (Session["firstname"] != null)
{
return(RedirectToAction("Index", "Home"));
}
else
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Product"].ConnectionString);
SqlCommand cmd = new SqlCommand("Login_credancial", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@email", loginmodel.email);
cmd.Parameters.AddWithValue("@password", loginmodel.password);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.Read())
{
Session["firstname"] = rdr["firstname"].ToString();
Session["lastname"] = rdr["lastname"].ToString();
Session["id"] = Convert.ToInt32(rdr["userid"]);
//HttpContext.Current.Session.Add("firstname", l.firstname);
//HttpContext.Current.Session.Add("lastname", l.firstname);
}
if (Session["firstname"] != null)
{
return(RedirectToAction("Index", "Home"));
}
}
return(View());
}
public object LoginCredancial(LoginModel lg)
{
Logincradancial l = new Logincradancial();
SqlCommand cmd = new SqlCommand("Login_credancial", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@email", lg.email);
cmd.Parameters.AddWithValue("@password", lg.password);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.Read())
{
l.firstname = rdr["firstname"].ToString();
l.lastname = rdr["lastname"].ToString();
l.id = Convert.ToInt32(rdr["userid"]);
//HttpContext.Current.Session.Add("firstname", l.firstname);
//HttpContext.Current.Session.Add("lastname", l.firstname);
}
return(l);
}
