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