public bool DeleteMedicine(int?id)
{
bool Result = true;
try
{
Medicine medicine = GetMedicine(id);
if (medicine == null)
{
return(false);
}
using (var ctx = new DrugsContext())
{
ctx.Configuration.ValidateOnSaveEnabled = false;
ctx.Medicines.Attach(medicine);
ctx.Entry(medicine).State = EntityState.Deleted;
ctx.SaveChanges();
}
GoogleDriveAPITool.DeleteGoogleFileByName(medicine.imagePath);
}
catch (Exception)
{
Result = false;
}
return(Result);
}
public bool DeletePatient(int?id)
{
bool Result = true;
try
{
Patient patient = GetPatient(id);
if (patient == null)
{
return(false);
}
using (var ctx = new DrugsContext())
{
ctx.Configuration.ValidateOnSaveEnabled = false;
ctx.Patients.Attach(patient);
ctx.Entry(patient).State = EntityState.Deleted;
ctx.SaveChanges();
}
}
catch (Exception)
{
Result = false;
}
return(Result);
}
public Medicine GetMedicine(int?id)
{
using (var ctx = new DrugsContext())
{
return(ctx.Medicines.Find(id));
}
}
public bool DeleteDoctor(int?id)
{
bool Result = true;
try
{
Doctor doctor = GetDoctor(id);
if (doctor == null)
{
return(false);
}
using (var ctx = new DrugsContext())
{
ctx.Configuration.ValidateOnSaveEnabled = false;
ctx.Doctors.Attach(doctor);
ctx.Entry(doctor).State = EntityState.Deleted;
ctx.SaveChanges();
}
}
catch (Exception)
{
Result = false;
}
return(Result);
}
public IEnumerable <MedicineWrraper> GetAllNDC()
{
using (var ctx = new DrugsContext())
{
return(ctx.Name_NDC.ToList());
}
}
public Patient GetPatient(int?id)
{
using (var ctx = new DrugsContext())
{
return(ctx.Patients.Find(id));
}
}
public Prescription GetPrescription(int?id)
{
using (var ctx = new DrugsContext())
{
return(ctx.Prescriptions.Find(id));
}
}
public string GetNDCForMedicine(string genericName)
{
using (var ctx = new DrugsContext())
{
return(ctx.Name_NDC.Where(med => med.genericName == genericName).Select(med => med.NDCnumber).FirstOrDefault());
}
}
public Doctor GetDoctor(int?id)
{
using (var ctx = new DrugsContext())
{
return(ctx.Doctors.Find(id));
}
}
public IEnumerable <Patient> GetPatients(Func <Patient, bool> predicat = null)
{
using (var ctx = new DrugsContext())
{
if (predicat == null)
{
return(ctx.Patients.ToList());
}
var patien = ctx.Patients.Where(predicat).ToList();
return(patien);
}
}
public IEnumerable <Medicine> GetMedicines(Func <Medicine, bool> predicat = null)
{
using (var ctx = new DrugsContext())
{
if (predicat == null)
{
return(ctx.Medicines.ToList());
}
var med = ctx.Medicines.Where(predicat).ToList();
return(med);
}
}
public IEnumerable <Doctor> GetDoctors(Func <Doctor, bool> predicat = null)
{
using (var ctx = new DrugsContext())
{
if (predicat == null)
{
return(ctx.Doctors.ToList());
}
var doc = ctx.Doctors.Where(predicat).ToList();
return(doc);
}
}
public IEnumerable <Prescription> GetPrescriptions(Func <Prescription, bool> predicat = null)
{
using (var ctx = new DrugsContext())
{
if (predicat == null)
{
return(ctx.Prescriptions.ToList());
}
var pres = ctx.Prescriptions.Where(predicat).ToList();
return(pres);
}
}
public void UpdateDoctor(Doctor doctor)
{
try
{
using (var ctx = new DrugsContext())
{
ctx.Entry(doctor).State = EntityState.Modified;
ctx.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void AddPrescription(Prescription prescription)
{
try
{
using (var ctx = new DrugsContext())
{
ctx.Prescriptions.Add(prescription);
ctx.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void AddPatient(Patient patient)
{
try
{
using (var ctx = new DrugsContext())
{
ctx.Patients.Add(patient);
ctx.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void AddDoctor(Doctor doctor)
{
try
{
using (var ctx = new DrugsContext())
{
ctx.Doctors.Add(doctor);
ctx.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdatePatient(Patient patient)
{
try
{
using (var ctx = new DrugsContext())
{
ctx.Entry(patient).State = EntityState.Modified;
ctx.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void AddMedicine(Medicine medicine, HttpPostedFileBase httpPostedFile)
{
try
{
using (var ctx = new DrugsContext())
{
ctx.Medicines.Add(medicine);
ctx.SaveChanges();
}
GoogleDriveAPITool.FileUpload(httpPostedFile);
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateMedicine(Medicine medicine, HttpPostedFileBase httpPostedFile)
{
try
{
Medicine med = GetMedicine(medicine.Id);
GoogleDriveAPITool.DeleteGoogleFileByName(med.imagePath);
using (var ctx = new DrugsContext())
{
ctx.Entry(medicine).State = EntityState.Modified;
ctx.SaveChanges();
}
GoogleDriveAPITool.FileUpload(httpPostedFile);
}
catch (Exception ex)
{
throw ex;
}
}
public void Dispose()
{
DrugsContext db = new DrugsContext();
db.Dispose();
}
