public User Login(User user)
{
using (var context = new MDTContext())
{
var dbRow = context.Users.SingleOrDefault(u => u.Email == user.Email && u.Password == user.Password);
return(dbRow);
}
}
//Get all Blood independent of user
public List <BloodExamination> GetAllExamination()
{
var allBloodExaminations = new List <BloodExamination>();
var context = new MDTContext();
allBloodExaminations = context.BloodExaminations.ToList();
return(allBloodExaminations);
}
//Get All Biochemical independent of user
public List <BiochemicalExamination> GetAllExaminations()
{
var allBiochemicalExaminations = new List <BiochemicalExamination>();
var context = new MDTContext();
allBiochemicalExaminations = context.BiochemicalExaminations.ToList();
return(allBiochemicalExaminations);
}
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);
}
// get blood amka
public List <BloodExamination> GetBlooExaminationsByUser(long amka)
{
var bloodExamintationList = new List <BloodExamination>();
using (var context = new MDTContext())
{
bloodExamintationList = context.BloodExaminations.Where(bl => bl.UserId.Value == amka).ToList();
}
return(bloodExamintationList);
}
//create
public BiochemicalExamination CreateBiochemicalExamination(BiochemicalExamination biochemicalExamination)
{
using (var context = new MDTContext())
{
context.BiochemicalExaminations.Add(biochemicalExamination);
context.SaveChanges();
//biochemicalExamination.BiochemicalResultId = biochemicalExamination.BiochemicalResultId;
}
return(biochemicalExamination);
}
//Fere analoga to AMKA
public List <BiochemicalExamination> GetBiochemicalExaminationsByUser(long amka)
{
var biochemicalExaminationsList = new List <BiochemicalExamination>();
using (var context = new MDTContext())
{
biochemicalExaminationsList = context.BiochemicalExaminations.Where(be => be.UserId.Value == amka).ToList();
}
return(biochemicalExaminationsList);
}
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);
}
