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;
}
}
}
