public List<Class> GetAllClasses() { using (CosmosContext ctx = new CosmosContext()) { return ctx.Classes.ToList(); } }
public void Update(Guardian guardian) { using (CosmosContext ctx = new CosmosContext()) { Guardian attachedEnttiy = ctx.Guardians.Find(guardian.Id); if (attachedEnttiy != null) { try { attachedEnttiy.Address = guardian.Address; attachedEnttiy.Email = guardian.Email; attachedEnttiy.GuardianNo = guardian.GuardianNo; attachedEnttiy.Name = guardian.Name; attachedEnttiy.Relation = guardian.Relation; var attachedEntry = ctx.Entry(attachedEnttiy); attachedEntry.CurrentValues.SetValues(attachedEnttiy); ctx.SaveChanges(); } catch (Exception ex) { throw; } } } }
public bool UpdateFingerCode(int stdId, byte[] fingerData) { using (CosmosContext ctx = new CosmosContext()) { try { var attachedEntity = ctx.Students.Find(stdId); if (attachedEntity != null) { attachedEntity.FingerCode = fingerData; var attachedEntry = ctx.Entry(attachedEntity); attachedEntry.CurrentValues.SetValues(attachedEntity); ctx.SaveChanges(); return true; } return false; } catch (Exception ex) { return false; } } }
public List<ClassSection> GetAllSectionsByClassId(int id) { using (CosmosContext ctx = new CosmosContext()) { // LINQ (Language Integrated Query) return (from c in ctx.ClassSections where c.ClassId == id select c).ToList(); } }
public void AddStudentGuardian(StudentGardians studentGuardian) { using (CosmosContext ctx = new CosmosContext()) { ctx.StudentsGuardians.Add(studentGuardian); ctx.SaveChanges(); } }
public Guardian SelectGuardianByCNIC(string cnic) { using (CosmosContext ctx = new CosmosContext()) { return (from g in ctx.Guardians where g.CNIC.Equals(cnic, StringComparison.OrdinalIgnoreCase) select g).FirstOrDefault(); } }
public Student GetStudentById(int id) { using (CosmosContext ctx = new CosmosContext()) { return ctx.Students.Find(id); } }
public List<Student> GetAllStudents() { using (CosmosContext ctx = new CosmosContext()) { return ctx.Students.ToList(); } }
public GuardianTime AddGuardianTime(GuardianTime time) { using (CosmosContext ctx = new CosmosContext()) { ctx.GuardianTimes.Add(time); ctx.SaveChanges(); return time; } }
public void DeleteStudentById(int id) { using (CosmosContext ctx = new CosmosContext()) { Student std = ctx.Students.Find(id); ctx.Students.Remove(std); } }
public List<Guardian> SelectAllGuardians() { using (CosmosContext ctx = new CosmosContext()) { try { return ctx.Guardians.ToList(); } catch (Exception ex) { return null; } } }
public Guardian AddGuardian(Guardian obj) { try { using (CosmosContext ctx = new CosmosContext()) { ctx.Guardians.Add(obj); ctx.SaveChanges(); return obj; } } catch (Exception ex) { throw; } }
public int AddStudent(Student obj) { try { using (CosmosContext ctx = new CosmosContext()) { ctx.Students.Add(obj); ctx.SaveChanges(); return obj.Id; } } catch (Exception ex) { throw; } }
public List<Student> SelectAllStudentsByParentId(int id) { List<Student> students = new List<Student>(); using (CosmosContext ctx = new CosmosContext()) { List<StudentGardians> studentGuardians = ctx.StudentsGuardians.Where(m=>m.GuardianId == id).ToList(); if (studentGuardians != null && studentGuardians.Count > 0) { foreach (var stdGuardian in studentGuardians) { Student student = ctx.Students.Where(m => m.Id == (int)stdGuardian.StudentId).FirstOrDefault(); if (student != null) { students.Add(student); } } } return students; } }
public List<Guardian> FindLateGuardianTime() { using (CosmosContext ctx = new CosmosContext()) { var list = ctx.Guardians.Include("GuardiansTimes").ToList(); List<Guardian> guardiansLate = new List<Guardian>(); if (list != null && list.Count > 0) { foreach (var item in list) { if (item.GuardiansTimes != null && item.GuardiansTimes.Count > 0) { bool found = false; foreach (var time in item.GuardiansTimes) { if (time.DateTime.Date == DateTime.Today.Date) { found = true; } } if (!found) { guardiansLate.Add(item); } } else { guardiansLate.Add(item); } } } return guardiansLate; } }
public byte[] GetFingerCodeById(int stdId) { using (CosmosContext ctx = new CosmosContext()) { try { var attachedEntity = ctx.Students.Find(stdId); if (attachedEntity != null) { return attachedEntity.FingerCode; } return null; } catch (Exception ex) { return null; } } }