public ActionResult addClass(tbl_ClassValidation cv) { try { Tbl_Class c = new Tbl_Class(); c.SchoolId = Convert.ToInt32(Session["school"]); c.Name = cv.Name; db.Tbl_Class.Add(c); db.SaveChanges(); ModelState.Clear(); ViewBag.Message = "Data Submitted"; } catch (Exception ex) { ViewBag.Message = "Not Submitted"; return(View()); } return(View()); }
public List <tbl_ClassValidation> GetClass(int schoolid) { List <tbl_ClassValidation> ClassInformation = new List <tbl_ClassValidation>(); SqlCommand sc = new SqlCommand("[Digital_School].get_SchoolClass", Connections.GetConnection()); sc.CommandType = CommandType.StoredProcedure; sc.Parameters.AddWithValue("@SchoolId", schoolid); SqlDataReader sdr = sc.ExecuteReader(); while (sdr.Read()) { tbl_ClassValidation gc = new tbl_ClassValidation(); //gc.CourseId = Convert.ToInt32(sdr["courseId"]); gc.Name = sdr["Name"].ToString(); gc.Class_Id = Convert.ToInt32(sdr["Class_Id"]); ClassInformation.Add(gc); } sdr.Close(); return(ClassInformation); }