public ActionResult fregister(aip.Models.faculty model)
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["kiit"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("insert into faculty values('" + model.userid + "','" + model.pwd + "','" + model.name + "','" + model.email + "')", con);
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
ViewBag.msg = "REGISTER SUCCESS";
}
return(View(model));
}
public ActionResult facultylogin(aip.Models.faculty model)
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["kiit"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("Select * from faculty where userid='" + model.userid + "' and pwd='" + model.pwd + "'", con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
Session["userid"] = model.userid;
return(RedirectToAction("facultyhome", "faculty"));
}
else
{
ViewBag.msg = "invalid info";
return(View(model));
}
}