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);
}
