public IEnumerable <StateMaster> getStates() { using (CISERPEntities db = new CISERPEntities()) { return(db.StateMasters.ToList()); } }
public IEnumerable <ClassMaster> GetClasses() { using (CISERPEntities db = new CISERPEntities()) { return(db.ClassMasters.ToList()); } }
public IEnumerable <BoardMaster> GetBoards() { using (CISERPEntities dn = new CISERPEntities()) { return(dn.BoardMasters.ToList()); } }
public IEnumerable <StateMaster> getStates(int id) { using (CISERPEntities db = new CISERPEntities()) { return(db.StateMasters.Where(a => a.CountryId == id).ToList()); } }
public IEnumerable <CountryMaster> GetCountries() { using (CISERPEntities db = new CISERPEntities()) { return(db.CountryMasters.ToList()); } }
public IEnumerable <CityMaster> getCitiesByStateId(int id) { using (CISERPEntities db = new CISERPEntities()) { return(db.CityMasters.Where(a => a.StateId == id).ToList()); } }
//methods public void SaveNewStudent(StudentGenaralDetailsCustomModel newData) { using (CISERPEntities db = new CISERPEntities()) { StudentGenaralDetail newStudent = new StudentGenaralDetail(); newStudent.FirstName = newData.FirstName; newStudent.LastName = newData.LastName; newStudent.Gender = newData.Gender; newStudent.DOB = newData.DateOfBirth; newStudent.BloodGroup = newData.BloodGroup; newStudent.Caste = newData.Cast; newStudent.Category = newData.Category; newStudent.Email = newData.Email; newStudent.MiddleName = newData.MiddleName; newStudent.MobileNumber = newData.MobileNumber; newStudent.Nationality = newData.Nationality; newStudent.Religion = newData.Religion; newStudent.StLocalAddress = newData.StLocalAddress; newStudent.StLocalCityId = newData.StLocalCityId; newStudent.StLocalStateId = newData.StLocalStateId; newStudent.StLocalZip = newData.StLocalZip; newStudent.StPerAddress = newData.StPerAddress; newStudent.StPerCityId = newData.StPerCityId; newStudent.StPerStateId = newData.StPerStateId; newStudent.StPerZip = newData.StPerZip; db.StudentGenaralDetails.Add(newStudent); db.SaveChanges(); } }
//methods public void AddFamilyDetails(StudentFamilyDetailsViewModel newData) { StudentFamilyDetail dbInstance = new StudentFamilyDetail(); using (CISERPEntities db = new CISERPEntities()) { dbInstance.FatherName = newData.FatherName; dbInstance.FatherContactNo = newData.FatherContactNo; dbInstance.FatherDesignation = newData.FatherDesignation; dbInstance.FatherEmail = newData.FatherEmail; dbInstance.FatherIncomeMonthly = newData.FatherIncomeMonthly; dbInstance.FatherOccupation = newData.FatherOccupation; dbInstance.FatherOfficeAddress = newData.FatherOfficeAddress; dbInstance.FatherQualification = newData.FatherQualification; dbInstance.MotherContactNo = newData.MotherContactNo; dbInstance.MotherDesignation = newData.MotherDesignation; dbInstance.MotherIncomeMonthly = newData.MotherIncomeMonthly; dbInstance.MotherName = newData.MotherName; dbInstance.MotherOccupation = newData.MotherOccupation; dbInstance.MotherOfficeAddress = newData.MotherOfficeAddress; dbInstance.MotherQualification = newData.MotherQualification; dbInstance.FamilyEmail = newData.FamilEmail; dbInstance.FamilyGuardianName = newData.FamilyGuardianName; dbInstance.FamilyIncomeMonthly = newData.FamilyIncomeMonthly; dbInstance.FamilyRelationship = newData.FamilyRelaltionship; dbInstance.FatherContactNo = newData.FatherContactNo; db.StudentFamilyDetails.Add(dbInstance); db.SaveChanges(); } }
public void SaveData() { using (CISERPEntities db = new CISERPEntities()) { StudentPreviousSchool newData = new StudentPreviousSchool(); newData.Board = this.Board; newData.CityId = this.CityId; newData.Class = this.Class; newData.CountryId = this.CountryId; newData.FromDate = this.FromDate; newData.Marks = this.Marks; newData.Medium = this.Medium; newData.Percentage = this.Percentage; newData.Schooladdress = this.SchooolAddress; newData.SchoolName = this.SchoolName; newData.ToDate = this.ToDate; newData.StateId = this.StateId; db.StudentPreviousSchools.Add(newData); db.SaveChanges(); } }