public static void SaveCoordinators(ExhibitionCoordinatorMaster Obj_Coordinator_Save)//save coordinator method.
{
try
{
using (SchoolExhibitionEntities db = new SchoolExhibitionEntities())
{
db.ExhibitionCoordinatorMasters.Add(Obj_Coordinator_Save);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public static void SaveClasses(ClassMaster Class_Save)//save class method.
{
try
{
using (SchoolExhibitionEntities db = new SchoolExhibitionEntities())
{
db.ClassMasters.Add(Class_Save);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public static void SaveStudents(StudentMaster Obj_Student_Save)//save method.
{
try
{
using (SchoolExhibitionEntities db = new SchoolExhibitionEntities())
{
db.StudentMasters.Add(Obj_Student_Save);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ClassMaster> GetClassDetails(string value)//get class detail method code
{
try
{
List <ClassMaster> Obj_Class_Detail = null;
using (SchoolExhibitionEntities db = new SchoolExhibitionEntities())
{
Obj_Class_Detail = (from c in db.ClassMasters where c.ID.ToString() == value select c).ToList();
}
return(Obj_Class_Detail
);
}
catch (Exception ex)
{
throw ex;
}
}
public static int UpdateCoordinator(ExhibitionCoordinatorMaster Obj_Coordinator_Update)//update method
{
try
{
using (SchoolExhibitionEntities db = new SchoolExhibitionEntities())
{
ExhibitionCoordinatorMaster c = db.ExhibitionCoordinatorMasters.SingleOrDefault(x => x.ID == Obj_Coordinator_Update.ID);//Lambda expression
c.Name = Obj_Coordinator_Update.Name;
db.SaveChanges();
return(Obj_Coordinator_Update.ID);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ExhibitionCoordinatorMaster> GetCoordinatorDetails(string value)
{
try
{
List <ExhibitionCoordinatorMaster> Obj_Coordinator_Detail = null;
using (SchoolExhibitionEntities db = new SchoolExhibitionEntities())
{
Obj_Coordinator_Detail = (from c in db.ExhibitionCoordinatorMasters where c.ID.ToString() == value select c).ToList();
}
return(Obj_Coordinator_Detail
);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <StudentMaster> GetStudentDetails(string value)//get student detail method
{
try
{
List <StudentMaster> Obj_Student_Detail = null;
using (SchoolExhibitionEntities db = new SchoolExhibitionEntities())
{
Obj_Student_Detail = (from c in db.StudentMasters where c.ID.ToString() == value select c).ToList();
}
return(Obj_Student_Detail
);
}
catch (Exception ex)
{
throw ex;
}
}
public static void DeleteClass(string Obj_Class_Delete)//delete class method
{
try
{
using (SchoolExhibitionEntities db = new SchoolExhibitionEntities())
{
ClassMaster c = db.ClassMasters.SingleOrDefault(x => x.ID.ToString().Trim() == Obj_Class_Delete.Trim());//Lambda expression
if (c != null)
{
db.ClassMasters.Remove(c);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static int UpdateClass(ClassMaster Obj_Class_Update)//updte class method
{
try
{
using (SchoolExhibitionEntities db = new SchoolExhibitionEntities())
{
ClassMaster c = db.ClassMasters.SingleOrDefault(x => x.ID == Obj_Class_Update.ID);//Lambda expression
c.ClassName = Obj_Class_Update.ClassName;
c.NumberOfStudents = Obj_Class_Update.NumberOfStudents;
c.Section = Obj_Class_Update.Section;
db.SaveChanges();
return(Obj_Class_Update.ID);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static int UpdateStudent(StudentMaster Obj_Student_Update)//update method
{
try
{
using (SchoolExhibitionEntities db = new SchoolExhibitionEntities())
{
//Lambda expression
StudentMaster c = db.StudentMasters.SingleOrDefault(x => x.ID == Obj_Student_Update.ID);
c.StudentName = Obj_Student_Update.StudentName;
c.ExhibitionCoordinatorMasterID = Obj_Student_Update.ExhibitionCoordinatorMasterID;
c.ClassMasterID = Obj_Student_Update.ClassMasterID;
db.SaveChanges();
return(Obj_Student_Update.ID);
}
}
catch (Exception ex)
{
throw ex;
}
}
