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