public Visit CreateVisit(Visit visit) { using (var context = new MDTContext()) { context.Visits.Add(visit); context.SaveChanges(); } return(visit); }
//Edit / Update public BloodExamination UpdateBloodExamination(BloodExamination bloodExamination) { using (var context = new MDTContext()) { context.BloodExaminations.Update(bloodExamination); context.SaveChanges(); } return(bloodExamination); }
//update public BiochemicalExamination UpdateBiochemicalExamination(BiochemicalExamination biochemicalExamination) { using (var context = new MDTContext()) { context.BiochemicalExaminations.Update(biochemicalExamination); context.SaveChanges(); } return(biochemicalExamination); }
//create public BiochemicalExamination CreateBiochemicalExamination(BiochemicalExamination biochemicalExamination) { using (var context = new MDTContext()) { context.BiochemicalExaminations.Add(biochemicalExamination); context.SaveChanges(); //biochemicalExamination.BiochemicalResultId = biochemicalExamination.BiochemicalResultId; } return(biochemicalExamination); }
public bool DeleteVisit(int id) { var status = false; using (var context = new MDTContext()) { var obj = context.Visits.SingleOrDefault(x => x.VisitId == id); if (obj != null) { context.Visits.Remove(obj); context.SaveChanges(); status = true; } } return(status); }
// Deete Blood Exam public bool DeleteBloodExamination(int id) { var deleteStatus = false; using (var context = new MDTContext()) { var dbRow = context.BloodExaminations.Find(id); if (dbRow != null) { context.BloodExaminations.Remove(dbRow); context.SaveChanges(); deleteStatus = true; } } return(deleteStatus); }
public bool CreateUser(User user) { var status = false; using (var context = new MDTContext()) { var dbRow = context.Users.Any(u => u.AMKA == user.AMKA && u.Email == user.Email); if (!dbRow) { context.Users.Add(user); context.SaveChanges(); status = true; } } return(status); }