public Center GetCenterByLogIn(string code, string password)
{
CMAContext db = new CMAContext();
var existingCenter = db.Centers.FirstOrDefault(p => p.Code == code && p.Password == password);
return(existingCenter);
}
public List <Center> GetAllCenters()
{
CMAContext dbContext = new CMAContext();
var centers = dbContext.Centers.ToList();
return(centers);
}
public Doctor GetDoctorById(int id)
{
CMAContext db = new CMAContext();
var existingDoctor = db.Doctors.Where(c => c.Id == id).AsNoTracking().FirstOrDefault();
return(existingDoctor);
}
public District GetDistrictNamebyId(int districtId)
{
CMAContext dbContext = new CMAContext();
var existingDistrict = dbContext.Districts.Where(d => d.Id == districtId).AsNoTracking().FirstOrDefault();
return(existingDistrict);
}
public List <District> GetDistrictList()
{
CMAContext dbContext = new CMAContext();
var existingDistrict = dbContext.Districts.OrderBy(c => c.Name).ToList();
return(existingDistrict);
}
public int CountCenterNumber(int districtId, int thanaId)
{
CMAContext db = new CMAContext();
var existingCenter = db.Centers.Where(p => p.ThanaId == thanaId && p.DistrictId == districtId).AsNoTracking().ToList();
return(existingCenter.Count);
}
public Disease GetDiseaseNamebyId(int diseaseId)
{
CMAContext dbContext = new CMAContext();
var existingDisease = dbContext.Diseases.Where(d => d.Id == diseaseId).AsNoTracking().FirstOrDefault();
return(existingDisease);
}
public Medicine GetMedicineNamebyId(int medicineId)
{
CMAContext dbContext = new CMAContext();
var existingMedicine = dbContext.Medicines.Where(d => d.Id == medicineId).AsNoTracking().FirstOrDefault();
return(existingMedicine);
}
public Thana GetThanaNamebyId(int thanaId)
{
CMAContext dbContext = new CMAContext();
var existingThana = dbContext.Thanas.Where(d => d.Id == thanaId).AsNoTracking().FirstOrDefault();
return(existingThana);
}
public List <SendMedicine> GetMedicineByCenterId(int centerId)
{
CMAContext db = new CMAContext();
var existingCenter = db.SendMedicines.Where(p => p.CenterId == centerId).OrderBy(p => p.MedicineId).AsNoTracking().ToList();
return(existingCenter);
}
public List <Medicine> GetMedicineList()
{
CMAContext dbContext = new CMAContext();
var existingMedicine = dbContext.Medicines.ToList();
return(existingMedicine);
}
public bool DoesCodeExist(string code)
{
CMAContext db = new CMAContext();
bool result = db.Centers.Any(c => c.Code == code);
return(result);
}
public string GetThanaNameById(int thanaId)
{
CMAContext dbContext = new CMAContext();
var existingThana = dbContext.Thanas.Where(c => c.Id == thanaId).Select(c => c.Name).FirstOrDefault();
return(existingThana);
}
public bool IsCenterExist(Center center)
{
CMAContext db = new CMAContext();
var existingCenter = db.Centers.Any(p => p.Name == center.Name && p.ThanaId == center.ThanaId && p.DistrictId == center.DistrictId);
return(existingCenter);
}
public string GetDistrictNameById(int districtId)
{
CMAContext dbContext = new CMAContext();
var existingDistrict = dbContext.Districts.Where(c => c.Id == districtId).Select(c => c.Name).FirstOrDefault();
return(existingDistrict);
}
public List <Thana> GetThanaList()
{
CMAContext dbContext = new CMAContext();
var existingThanas = dbContext.Thanas.ToList();
return(existingThanas);
}
public List <Treatment> GetTreatmentList(string voterId)
{
CMAContext dbContext = new CMAContext();
var existingTreatments = dbContext.Treatments.Where(c => c.VoterIdNo == voterId).ToList();
return(existingTreatments);
}
public List <Doctor> GetDoctorList()
{
CMAContext dbContext = new CMAContext();
var existingDoctor = dbContext.Doctors.ToList();
return(existingDoctor);
}
public Medicine GetMedicineById(int id)
{
CMAContext db = new CMAContext();
var existingMedicine = db.Medicines.Where(c => c.Id == id).AsNoTracking().FirstOrDefault();
return(existingMedicine);
}
public List <int> GetCenterListByDistrictId(int districtId)
{
CMAContext dbContext = new CMAContext();
var centerList = dbContext.Centers.Where(c => c.DistrictId == districtId).AsNoTracking().Select(c => c.Id).ToList();
return(centerList);
}
public Center GetCenterNamebyId(int centerId)
{
CMAContext dbContext = new CMAContext();
var existingCenter = dbContext.Centers.Where(d => d.Id == centerId).AsNoTracking().FirstOrDefault();
return(existingCenter);
}
public Center GetCenterById(int id)
{
CMAContext db = new CMAContext();
var existingCenter = db.Centers.Where(c => c.Id == id).AsNoTracking().FirstOrDefault();
return(existingCenter);
}
public List <int> GetDiseaseIdList()
{
CMAContext dbContext = new CMAContext();
var id = dbContext.Diseases.Select(c => c.Id).ToList();
return(id);
}
public List <Center> GetCenterList()
{
CMAContext dbContext = new CMAContext();
var existingCenter = dbContext.Centers.ToList();
return(existingCenter);
}
public bool IsDiseaseExist(string name)
{
CMAContext db = new CMAContext();
var existingDisease = db.Diseases.Any(c => c.Name == name);
return(existingDisease);
}
public List <Disease> GetDiseaseList()
{
CMAContext dbContext = new CMAContext();
var existingDisease = dbContext.Diseases.ToList();
return(existingDisease);
}
public bool IsMedicineExist(string name, double mgMl)
{
CMAContext db = new CMAContext();
var existingMedicine = db.Medicines.Any(c => c.GenericName == name && Math.Abs(c.MgMl - mgMl) < 0.001);
return(existingMedicine);
}
public List <Treatment> GetTreatmentListByCenterId(int centerId, int diseaseId, DateTime fromDateTime, DateTime toDateTime)
{
CMAContext dbContext = new CMAContext();
//var patientList = dbContext.Treatments.Where(c => c.CenterId == centerId).AsNoTracking().GroupBy(x => x.VoterIdNo).Select(x => x.First()).Select(x=>x.VoterIdNo).ToList();
var treatmentList = dbContext.Treatments.Where(c => c.CenterId == centerId && c.DiseaseId == diseaseId && c.TodayDateTime >= fromDateTime && c.TodayDateTime <= toDateTime).AsNoTracking().ToList();
return(treatmentList);
}
public int SaveDoctor(Doctor aDoctor)
{
CMAContext db = new CMAContext();
db.Doctors.Add(aDoctor);
int rowAffected = db.SaveChanges();
return(rowAffected);
}
public int SaveSendMedicine(List <SendMedicine> sendMedicines)
{
CMAContext db = new CMAContext();
foreach (SendMedicine sendMedicine in sendMedicines)
{
db.SendMedicines.Add(sendMedicine);
}
int rowAffected = db.SaveChanges();
return(rowAffected);
}