public ActionResult studentlogin(aip.Models.student model)
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["kiit"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("Select * from student where userid='" + model.userid + "' and pwd='" + model.pwd + "'", con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
Session["userid"] = model.userid;
return(RedirectToAction("studenthome", "student"));
}
else
{
ViewBag.msg = "invalid info";
return(View(model));
}
}
public ActionResult register(aip.Models.student model)
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["kiit"].ConnectionString);
con.Open();
try
{
SqlCommand cmd = new SqlCommand("insert into student values('" + model.userid + "','" + model.pwd + "','" + model.name + "','" + model.rollno + "','" + model.email + "','" + model.regno + "')", con);
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
SqlCommand cmd1 = new SqlCommand("insert into student_profile values('" + model.userid + "','','','','','','','','','','blank.jpg')", con);
cmd1.ExecuteNonQuery();
ViewBag.msg = "REGISTER SUCCESS";
}
}
catch
{
ViewBag.msg1 = "Userid Already Exit!";
}
return(View(model));
}
