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
                }
            }
        }
Example #4
0
        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");
        }