public static int InsertSchoolSection(SchoolSection section) { //create DBContext object using (var smsDB = new SMSEntities()) { smsDB.SchoolSections.Add(section); return(smsDB.SaveChanges()); } }
public static int EditSchoolSection(SchoolSection section) { //create DBContext object using (var smsDB = new SMSEntities()) { SchoolSection schoolSection = smsDB.SchoolSections.Find(section.SchoolSectionID); schoolSection.SchoolID = section.SchoolID; schoolSection.SectionID = section.SectionID; return(smsDB.SaveChanges()); } }
public static int DeleteSchoolSection(SchoolSection section) { using (var smsDB = new SMSEntities()) { SchoolSection schoolSection = smsDB.SchoolSections.Find(section); if (schoolSection != null) { smsDB.SchoolSections.Remove(schoolSection); return(smsDB.SaveChanges()); } else { return(0); // no record found } } }
private void InitializeStartUpComboList() { this.SearchType = new List <string>(); this.SearchType.Add("Add hoc"); this.SearchType.Add("By Class, Section and Roll"); this.SearchType.Add("Bulk"); this.VillList = new List <string>(); VillList.Add("Bakharpur"); VillList.Add("Bamongram"); VillList.Add("Chamagram"); VillList.Add("Chaspara"); VillList.Add("Goyeshbari"); VillList.Add("Harugram"); VillList.Add("Jalalpur"); VillList.Add("Mosimpur"); VillList.Add("Nazirpur"); VillList.Add("Paharpur"); VillList.Add("Sujapur"); this.POList = new List <string>(); POList.Add("Bakharpur"); POList.Add("Bamongram"); POList.Add("Chaspara"); POList.Add("Chhoto Sujapur"); POList.Add("Fatehkhani"); POList.Add("Gayeshbari"); POList.Add("Jalalpur"); POList.Add("Mosimpur"); POList.Add("Sujapur"); this.PSList = new List <string>(); PSList.Add("Kaliachak"); this.DistList = new List <string>(); DistList.Add("Malda"); this.PinList = new List <string>(); PinList.Add("732206"); this.Gender = new List <string>(); Gender.Add("Boy"); Gender.Add("Girl"); this.SchoolClass = new List <string>(); SchoolClass.Add("V"); SchoolClass.Add("VI"); SchoolClass.Add("VII"); SchoolClass.Add("VIII"); SchoolClass.Add("IX"); SchoolClass.Add("X"); SchoolClass.Add("XI"); SchoolClass.Add("XII"); this.SchoolSection = new List <string>(); SchoolSection.Add("A"); SchoolSection.Add("B"); SchoolSection.Add("C"); SchoolSection.Add("D"); SchoolSection.Add("E"); }