public List <Medicine> GetAllMedicines()
{
using (context = new MedicalStore_dbEntities())
{
return(context.Medicines.ToList());
}
}
public List <Medicine> GetMedicines()
{
using (context = new MedicalStore_dbEntities())
{
return(context.Medicines.Where(m => m.IsLacking != true && m.Quantity > 2).ToList());
}
}
public int GetLackingMedicinesCount()
{
using (context = new MedicalStore_dbEntities())
{
var count = context.Medicines.Where(m => m.IsLacking == true).Count();
return(count);
}
}
public List <User> GetUsers()
{
using (context = new MedicalStore_dbEntities())
{
var result = context.Users.ToList();
return(result);
}
}
public int GetPendingBillsCount()
{
using (context = new MedicalStore_dbEntities())
{
var result = context.Bills.Where(p => p.BillStatus == false).Select(b => b.PatientID).Count();
return(result);
}
}
public void UpdateUser(User user)
{
using (context = new MedicalStore_dbEntities())
{
context.Entry(user).State = EntityState.Modified;
context.SaveChanges();
}
}
public string[] GetPateintNames()
{
using (context = new MedicalStore_dbEntities())
{
var Ids = context.Patients.Select(p => p.PatientName).ToArray();
return(Ids);
}
}
public void UpdateRecordToMedicines(RecordsMedicine recordsMedicine)
{
using (context = new MedicalStore_dbEntities())
{
context.Entry(recordsMedicine).State = EntityState.Modified;
context.SaveChanges();
}
}
public void BillToMedicines(BillMedicine billMedicine)
{
using (context = new MedicalStore_dbEntities())
{
context.BillMedicines.Add(billMedicine);
context.SaveChanges();
}
}
public void SavePatientToMedicines(RecordsMedicine recordsMedicine)
{
using (context = new MedicalStore_dbEntities())
{
context.RecordsMedicines.Add(recordsMedicine);
context.SaveChanges();
}
}
public void UpdatePatient(Patient objPateint)
{
using (context = new MedicalStore_dbEntities())
{
context.Patients.Attach(objPateint);
context.Entry(objPateint).State = EntityState.Modified;
context.SaveChanges();
}
}
public int SaveBill(Bill bill)
{
using (context = new MedicalStore_dbEntities())
{
context.Bills.Add(bill);
context.SaveChanges();
return(bill.ID);
}
}
public string[] getPateintIDs()
{
using (context = new MedicalStore_dbEntities())
{
var Ids = context.Patients.Select(p => p.ID).ToArray();
var IDs = Ids.Select(i => i.ToString()).ToArray();
return(IDs);
}
}
public Patient getPateintByID(int id)
{
using (null)
{
context = new MedicalStore_dbEntities();
var reslt = context.Patients.Find(id);
return(reslt);
}
}
/// <summary>
/// Getting the ID Based Pateint and Saves the Records against it.
/// </summary>
/// <param name="pateintID"></param>
/// <param name="pateintRecord"></param>
public void AddRecordToPatient(int pateintID, PateintRecord pateintRecord)
{
using (context = new MedicalStore_dbEntities())
{
Patient existingPateint = context.Patients.Find(pateintID);
pateintRecord.Patient = existingPateint;
context.PateintRecords.Add(pateintRecord);
context.SaveChanges();
}
}
public int SavePatient(PateintRecord pateintRecord)
{
using (context = new MedicalStore_dbEntities())
{
context.PateintRecords.Add(pateintRecord);
context.SaveChanges();
int SavedPatientID = pateintRecord.Patient.ID;
return(SavedPatientID);
}
}
MedicalStore_dbEntities context; //MedicalStore_dbEntities
public void BillPaied(int ID)
{
using (context = new LocalDataBase.MedicalStore_dbEntities())
{
var bill = context.Bills.Find(ID);
bill.BillStatus = true;
context.Entry(bill).State = EntityState.Modified;
context.SaveChanges();
}
}
public int SavePatient(Patient objPateint)
{
using (context = new MedicalStore_dbEntities())
{
context.Patients.Add(objPateint);
context.SaveChanges();
int SavedPatientID = objPateint.ID;
return(SavedPatientID);
}
}
public void CreateUser(User user)
{
using (context = new MedicalStore_dbEntities())
{
var Password = Encrypt(user.Password);
user.Password = Password;
context.Users.Add(user);
context.SaveChanges();
}
}
/// <summary>
/// Deletes the specified medicine according to the ID
/// </summary>
/// <param name="iD"></param>
public void DeleteMedicine(int iD)
{
using (context = new MedicalStore_dbEntities())
{
var model = context.Medicines.Find(iD);
context.Medicines.Remove(model);
context.Entry(model).State = EntityState.Deleted;
context.SaveChanges();
}
}
public void LoggoutUser(User LoggedInUser)
{
using (context = new MedicalStore_dbEntities())
{
var user = context.Users.Where(y => y.Password == LoggedInUser.Password && y.Username == LoggedInUser.Username).First();
user.IsLoggedin = false;
context.Entry(user).State = EntityState.Modified;
context.SaveChanges();
}
}
public async System.Threading.Tasks.Task <int> GetLackingMedicinesCountAsync()
{
var res = await Task.Run(() =>
{
using (context = new MedicalStore_dbEntities())
{
var count = context.Medicines.Where(m => m.IsLacking == true).Count();
return(count);
}
});
return(res);
}
public async Task <User> GetUser(string name, string pass)
{
var res = await Task.Run(() =>
{
using (context = new MedicalStore_dbEntities())
{
var result = context.Users.Where(y => y.Password == pass && y.Username == name);
return(result.First());
}
});
return(res);
}
public async Task <string> GetUserPasswordByName(string name)
{
var res = await Task.Run(() =>
{
using (context = new MedicalStore_dbEntities())
{
string result = context.Users.Where(u => u.Username == name).Select(x => x.Password).FirstOrDefault();
return(result);
}
});
return(res);
}
public async Task <int> GetPendingBillsCountAsync()
{
var res = await Task.Run(() =>
{
using (context = new MedicalStore_dbEntities())
{
var result = context.Bills.Where(p => p.BillStatus == false).Select(b => b.PatientID).Count();
return(result);
}
});
return(res);
}
/// <summary>
/// Confirms the user, if already exists, returns true.
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public bool UserExist(User user)
{
using (context = new MedicalStore_dbEntities())
{
var userExiting = context.Users.Where(u => u.Username == user.Username).FirstOrDefault();
if (userExiting != null)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// This function return a tuple of List<PateintRecord> with specified Pateint ID with paging accordingly
/// item 1: Patient
/// item 2: Records count
/// </summary>
/// <param name="pateintID"></param>
/// <returns></returns>
public Tuple <List <PateintRecord>, int> GetPatientRecords(int pateintID, int pageNo = 1, int pageSize = 1)
{
using (context = new MedicalStore_dbEntities())
{
Tuple <List <PateintRecord>, int> result = null;
var pateintRecords = context.PateintRecords.Include(p => p.Patient).Include(m => m.RecordsMedicines).Where(x => x.PatientID == pateintID).ToList();// as IQueryable;
var recordsCount = pateintRecords.Count();
pateintRecords = pateintRecords.Skip((pageNo - 1) * pageSize).Take(pageSize).ToList();
result = Tuple.Create(pateintRecords, recordsCount);
return(result);
}
}
public void UpdateMedicine(Medicine model, bool isSold, string cmboBxMedType = null)
{
try
{
//reducing Quantity
if (isSold)
{
model.Quantity = model.Quantity - 1;
//Checking If Lacking?
model.SoldQuantity += 1;
}
if (model.Quantity < 3)
{
model.IsLacking = true;
}
else
{
model.IsLacking = false;
}
if (cmboBxMedType != null)
{
//Get Medicine Type
string type = cmboBxMedType;
int medType = 0;
foreach (var item in Enum.GetValues(typeof(MedicineType)))
{
if (item.ToString() == type)
{
medType = (int)item;
}
}
model.MedType = medType;
}
using (context = new MedicalStore_dbEntities())
{
context.Medicines.Attach(model);
context.Entry(model).State = EntityState.Modified;
context.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
public object getLackingMedicines(string searchTerm = null)
{
using (context = new MedicalStore_dbEntities())
{
List <Medicine> result = null;
if (searchTerm == null)
{
result = context.Medicines.Where(m => m.IsLacking != false).ToList();
}
else
{
result = context.Medicines.Where(m => m.IsLacking != false && m.MedName.Contains(searchTerm)).ToList();
}
return(result);
}
}
public object SearchMedicine(string medName, string medTypeString = null)
{
using (context = new MedicalStore_dbEntities())
{
try
{
//Get Medicine Type
int medTypeInt = 0;
foreach (var item in Enum.GetValues(typeof(MedicineType)))
{
if (item.ToString() == medTypeString)
{
medTypeInt = (int)item;
}
}
if (medName != "" && medTypeString == null)
{
context.Medicines.Where(m => m.MedName.Contains(medName) && m.Quantity > 2).ToList();
}
if (medName == "" && medTypeInt > 0)
{
return(context.Medicines.Where(x => x.MedType == medTypeInt && x.Quantity > 2).ToList());
}
else if (medName != "" && medTypeInt <= 0)
{
return(context.Medicines.Where(x => x.MedName.Contains(medName) && x.Quantity > 2).ToList());
}
else if (medTypeInt > 0 && medName != "")
{
return(context.Medicines.Where(m => m.MedName.Contains(medName) && m.MedType == medTypeInt && m.Quantity > 2).ToList());
}
else
{
return(context.Medicines.ToList());
}
}
catch (Exception)
{
throw;
}
}
}
