public bool updateDeleteStore(Stores store_detail)
{
using (ABCPharma_DBEntities context = new ABCPharma_DBEntities())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
Store store = new Store();
store.StoreName = store_detail.storeName;
store.StoreAddress = store_detail.storeAddress;
store.StorePhoneNo = store_detail.storePhoneNo;
context.Stores.Add(store);
context.SaveChanges();
transaction.Commit();
}
catch (System.Exception ex)
{
var abc = ex.Message;
transaction.Rollback();
}
}
}
return(true);
}
public bool updateDeleteMedicine(Medicines medicines_detail)
{
using (ABCPharma_DBEntities context = new ABCPharma_DBEntities())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
Medicine medicineToAdd = new Medicine();
medicineToAdd.MedicineName = medicines_detail.medicineName;
medicineToAdd.PKGDate = medicines_detail.pkgDate;
medicineToAdd.ExpiryDate = medicines_detail.expiryDate;
medicineToAdd.QuantityAvailable = medicines_detail.quantity;
medicineToAdd.UnitPrice = medicines_detail.unitPrice;
context.Medicines.Add(medicineToAdd);
context.SaveChanges();
transaction.Commit();
}
catch (System.Exception ex)
{
var abc = ex.Message;
transaction.Rollback();
}
}
}
return(true);
}
public Invoice SavePurchaseDetails(Purchases purchases_, JObject json)
{
using (ABCPharma_DBEntities context = new ABCPharma_DBEntities())
{
List <PurchasedMedicine> purchasedMedicines = MedicinesList(json);
Invoice inv = new Invoice();
Purchase purchase = new Purchase();
using (var transaction = context.Database.BeginTransaction())
{
try
{
if (purchases_.storeId != null)
{
purchase.StoreId = purchases_.storeId;
purchase.PurchaseDetails = purchases_.purchaseDetails;
purchase.PurchaseDate = purchases_.purchaseDate;
inv = GenerateInvoice(purchasedMedicines);
purchase.InvoiceDetails = JsonConvert.SerializeObject(inv);
context.Purchases.Add(purchase);
}
context.SaveChanges();
inv.purchaseId = purchase.PurchaseId;
transaction.Commit();
}
catch (System.Exception ex)
{
var abc = ex.Message;
transaction.Rollback();
}
}
return(inv);
}
}
public static List <Stores> GetAllStores()
{
using (var db = new ABCPharma_DBEntities())
{
var storeList = (from s in db.Stores
select new Stores
{
storeId = s.StoreId,
storeName = s.StoreName,
storeAddress = s.StoreAddress,
storePhoneNo = s.StorePhoneNo
}).ToList();
return(storeList);
}
}
public static Stores GetStoreById(int storeId_)
{
using (var db = new ABCPharma_DBEntities())
{
var store_ = (from s in db.Stores
where s.StoreId.Equals(storeId_)
select new Stores
{
storeId = s.StoreId,
storeName = s.StoreName,
storeAddress = s.StoreAddress,
storePhoneNo = s.StorePhoneNo
}).FirstOrDefault();
return(store_);
}
}
public static List <Medicines> GetAllMedicines()
{
using (var db = new ABCPharma_DBEntities())
{
var medicineList = (from m in db.Medicines
select new Medicines
{
itemId = m.MedicineId,
medicineName = m.MedicineName,
pkgDate = m.PKGDate,
expiryDate = m.ExpiryDate,
quantity = m.QuantityAvailable,
unitPrice = m.UnitPrice
}).ToList();
return(medicineList);
}
}
public static Medicines GetMedicineById(int medicineId_)
{
using (var db = new ABCPharma_DBEntities())
{
var medicine = (from m in db.Medicines
where m.MedicineId.Equals(medicineId_)
select new Medicines
{
itemId = m.MedicineId,
medicineName = m.MedicineName,
pkgDate = m.PKGDate,
expiryDate = m.ExpiryDate,
quantity = m.QuantityAvailable,
unitPrice = m.UnitPrice
}).FirstOrDefault();
return(medicine);
}
}
