private SQLQueryResult SetCustomerOrderDeactive(PharmacyDBContext appDBContext, object[] paramaters)
{
tblOrder cusOrder = paramaters[0] as tblOrder;
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblOrders.Where(order => order.OrderID == cusOrder.OrderID).
First();
x.IsActive = false;
foreach (tblOrderDetail oD in cusOrder.tblOrderDetails)
{
oD.IsActive = false;
}
appDBContext.SaveChanges();
result = new SQLQueryResult(null, MessageQueryResult.Done);
return(result);
}
catch (Exception e)
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
App.Current.ShowApplicationMessageBox(e.Message);
}
return(result);
}
private SQLQueryResult AddNewMedicine(PharmacyDBContext appDBContext, object[] paramaters)
{
tblMedicine medicine = paramaters[0] as tblMedicine;
string imageFolder = paramaters[1] as string;
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
appDBContext.tblMedicines.Add(medicine);
if (!SaveImageToFile(medicine.MedicineID, imageFolder, ImageType.Medicine))
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
return(result);
}
appDBContext.SaveChanges();
result = new SQLQueryResult(null, MessageQueryResult.Done);
}
catch (DbEntityValidationException e)
{
HandleDbEntityValidationException(e);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
catch (Exception e)
{
App.Current.ShowApplicationMessageBox(e.Message);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
return(result);
}
private SQLQueryResult AddNewUser(PharmacyDBContext appDBContext, object[] paramaters)
{
tblUser newUser = paramaters[0] as tblUser;
string imageFolder = paramaters[1] as string;
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
appDBContext.tblUsers.Add(newUser);
if (!SaveImageToFile(newUser.Username, imageFolder, ImageType.User))
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
return(result);
}
appDBContext.SaveChanges();
result = new SQLQueryResult(null, MessageQueryResult.Done);
}
catch (DbEntityValidationException e)
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
HandleDbEntityValidationException(e);
}
catch (Exception e)
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
ShowErrorMessageBox(e);
}
return(result);
}
private SQLQueryResult AddNewWarehouseImport(PharmacyDBContext appDBContext, object[] paramaters)
{
tblWarehouseImport import = paramaters[0] as tblWarehouseImport;
string imageFolder = paramaters[1] as string;
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
appDBContext.tblWarehouseImports.Add(import);
appDBContext.SaveChanges();
if (imageFolder.Length > 0 && !SaveImageToFile(import.ImportID.ToString(), imageFolder, ImageType.WarehouseImport))
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
return(result);
}
result = new SQLQueryResult(null, MessageQueryResult.Done);
return(result);
}
catch (Exception e)
{
App.Current.ShowApplicationMessageBox(e.Message);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
return(result);
}
private SQLQueryResult AddNewCustomerOrder(PharmacyDBContext appDBContext, object[] paramaters)
{
tblOrder newOrder = paramaters[0] as tblOrder;
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
appDBContext.tblOrders.Add(newOrder);
appDBContext.SaveChanges();
result = new SQLQueryResult(newOrder, MessageQueryResult.Done, "Thêm hóa đơn mới thành công!");
}
catch (DbEntityValidationException e)
{
HandleDbEntityValidationException(e);
result = new SQLQueryResult(newOrder, MessageQueryResult.Aborted, "Lỗi thêm hóa đơn mới!");
}
catch (Exception e)
{
ShowErrorMessageBox(e);
result = new SQLQueryResult(newOrder, MessageQueryResult.Aborted, "Lỗi thêm hóa đơn mới!");
}
return(result);
}
private SQLQueryResult AddAndModifyPromo(PharmacyDBContext appDBContext, object[] paramaters)
{
tblPromo promoInfo = paramaters[0] as tblPromo;
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
tblPromo promo = appDBContext.tblPromoes.Where(o => o.CustomerID == promoInfo.CustomerID && o.MedicineID == promoInfo.MedicineID).FirstOrDefault();
if (promo == null) //Promo is not exist
{
appDBContext.tblPromoes.Add(promoInfo);
}
else //Promo deleted or Update Promo info
{
promo.PromoPercent = promoInfo.PromoPercent;
promo.PromoDescription = promoInfo.PromoDescription;
promo.IsActive = true;
}
appDBContext.SaveChanges();
result = new SQLQueryResult(null, MessageQueryResult.Done);
}
catch (DbEntityValidationException e)
{
HandleDbEntityValidationException(e);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
catch (Exception e)
{
App.Current.ShowApplicationMessageBox(e.Message);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
return(result);
}
private SQLQueryResult ModifyOtherPayment(PharmacyDBContext appDBContext, object[] paramaters)
{
tblOtherPayment payment = paramaters[0] as tblOtherPayment;
string imageFolder = paramaters[1] as string;
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var value = appDBContext.tblOtherPayments.Where(o => o.PaymentID == payment.PaymentID).FirstOrDefault();
value.PaymentTime = payment.PaymentTime;
value.PaymentType = payment.PaymentType;
value.PaymentContent = payment.PaymentContent;
value.TotalPrice = payment.TotalPrice;
appDBContext.SaveChanges();
if (imageFolder.Length > 0 && !SaveImageToFile(payment.PaymentID.ToString(), imageFolder, ImageType.OtherPayment))
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
return(result);
}
result = new SQLQueryResult(null, MessageQueryResult.Done);
return(result);
}
catch (Exception e)
{
App.Current.ShowApplicationMessageBox(e.Message);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
return(result);
}
private SQLQueryResult GetAllActivteMedicineStockInWarehouseData(PharmacyDBContext appDBContext, object[] paramaters)
{
string id = paramaters[0].ToString();
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
List <tblWarehouseImportDetail> lstOutput = new List <tblWarehouseImportDetail>();
foreach (var import in appDBContext.tblWarehouseImports.Where(o => o.IsActive).OrderByDescending(o => o.ImportTime))
{
foreach (var stock in import.tblWarehouseImportDetails.Where(o => o.MedicineID == id && o.IsActive))
{
lstOutput.Add(stock);
}
}
result = new SQLQueryResult(lstOutput, MessageQueryResult.Done);
return(result);
}
catch (Exception e)
{
App.Current.ShowApplicationMessageBox(e.Message);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
return(result);
}
private SQLQueryResult ModifySupplier(PharmacyDBContext appDBContext, object[] paramaters)
{
tblSupplier supplier = paramaters[0] as tblSupplier;
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var item = appDBContext.tblSuppliers.Where(o => o.SupplierID == supplier.SupplierID).FirstOrDefault();
item.SupplierName = supplier.SupplierName;
item.Phone = supplier.Phone;
item.Email = supplier.Email;
item.Address = supplier.Address;
item.SupplierDescription = supplier.SupplierDescription;
item.IsActive = true;
appDBContext.SaveChanges();
result = new SQLQueryResult(null, MessageQueryResult.Done);
}
catch (DbEntityValidationException e)
{
HandleDbEntityValidationException(e);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
catch (Exception e)
{
App.Current.ShowApplicationMessageBox(e.Message);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
return(result);
}
private SQLQueryResult ModifyWarehouseImport(PharmacyDBContext appDBContext, object[] paramaters)
{
tblWarehouseImport import = paramaters[0] as tblWarehouseImport;
List <tblWarehouseImportDetail> details = paramaters[1] as List <tblWarehouseImportDetail>;
string imageFolder = paramaters[2] as string;
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
tblWarehouseImport importInfo = appDBContext.tblWarehouseImports.Where(o => o.ImportID == import.ImportID).FirstOrDefault();
importInfo.IsActive = true;
importInfo.ImportDescription = import.ImportDescription;
importInfo.TotalPrice = import.TotalPrice;
importInfo.PurchasePrice = import.PurchasePrice;
//Add or Modify active import details
foreach (var item in details)
{
tblWarehouseImportDetail detail = importInfo.tblWarehouseImportDetails.Where(o => o.MedicineID == item.MedicineID).FirstOrDefault();
if (detail != null)
{
detail.IsActive = true;
detail.Price = item.Price;
detail.Quantity = item.Quantity;
}
else
{
importInfo.tblWarehouseImportDetails.Add(item);
}
}
//Deactive import details
foreach (var item in import.tblWarehouseImportDetails.Where(o => !o.IsActive))
{
tblWarehouseImportDetail detail = importInfo.tblWarehouseImportDetails.Where(o => o.MedicineID == item.MedicineID).FirstOrDefault();
if (detail != null)
{
detail.IsActive = false;
}
}
appDBContext.SaveChanges();
if (imageFolder.Length > 0 && !SaveImageToFile(import.ImportID.ToString(), imageFolder, ImageType.WarehouseImport))
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
return(result);
}
result = new SQLQueryResult(null, MessageQueryResult.Done);
return(result);
}
catch (Exception e)
{
App.Current.ShowApplicationMessageBox(e.Message);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
return(result);
}
public virtual SQLQueryResult Execute(PharmacyDBContext appDBContext, object[] paramaters)
{
if (CanExecute(paramaters))
{
return(_action?.Invoke(appDBContext, paramaters));
}
else
{
return(new SQLQueryResult(null, MessageQueryResult.Non));
}
}
private SQLQueryResult GetAllActiveSupplierData(PharmacyDBContext appDBContext, object[] paramaters)
{
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
List <tblSupplier> lstOutput = appDBContext.tblSuppliers.Where(o => o.IsActive).OrderBy(o => o.SupplierName).ToList();
result = new SQLQueryResult(lstOutput, MessageQueryResult.Done);
}
catch (Exception e)
{
App.Current.ShowApplicationMessageBox(e.Message);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
return(result);
}
private SQLQueryResult GetAllMedicineTypeData(PharmacyDBContext appDBContext, object[] paramaters)
{
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
List <tblMedicineType> lstOutput = appDBContext.tblMedicineTypes.ToList();
result = new SQLQueryResult(lstOutput, MessageQueryResult.Done);
}
catch (Exception e)
{
App.Current.ShowApplicationMessageBox(e.Message);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
return(result);
}
private SQLQueryResult GetAllActiveCustomerOrdersData(PharmacyDBContext appDBContext, object[] paramaters)
{
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblOrders.
Where <tblOrder>(order => order.IsActive).OrderByDescending(o => o.OrderTime);
result = new SQLQueryResult(x, MessageQueryResult.Done);
}
catch (Exception e)
{
ShowErrorMessageBox(e);
result = new SQLQueryResult(null, MessageQueryResult.Aborted, "Lỗi load dữ liệu hóa đơn!");
}
return(result);
}
private SQLQueryResult GetAllActiveCustomerData(PharmacyDBContext appDBContext, object[] paramaters)
{
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblCustomers.
Where <tblCustomer>(cus => cus.IsActive).OrderBy(o => o.CustomerName).
ToList();
result = new SQLQueryResult(x, MessageQueryResult.Done);
}
catch (Exception e)
{
ShowErrorMessageBox(e);
}
return(result);
}
private SQLQueryResult GetAllActivePromoByMedicineData(PharmacyDBContext appDBContext, object[] paramaters)
{
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
string MedicineID = paramaters[0] as string;
List <tblPromo> lstOutput = appDBContext.tblPromoes.Where(o => o.MedicineID == MedicineID && o.IsActive).ToList();
result = new SQLQueryResult(lstOutput, MessageQueryResult.Done);
}
catch (Exception e)
{
App.Current.ShowApplicationMessageBox(e.Message);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
return(result);
}
public void PostAndDeleteTest()
{
var options = new DbContextOptionsBuilder <PharmacyDBContext>()
.UseSqlServer("Server=localhost\\SQLEXPRESS;Database=PharmacyDB; Trusted_Connection=True;MultipleActiveResultSets=true")
.Options;
var context = new PharmacyDBContext(options);
EmployeesController controller = new EmployeesController(context);
var TestEmployees = new Employees {
FullName = "UnitTest3", Salary = System.Convert.ToDecimal(1111.22222), IdBranch = 1
};
var CallBack = (Employees)((CreatedAtActionResult)controller.PostEmployees(TestEmployees).Result.Result).Value;
var result = controller.DeleteEmployees(CallBack.Id).Result.Value;
Assert.Equal(CallBack, result);//Assert
}
private SQLQueryResult IsMedicineIDExisted(PharmacyDBContext appDBContext, object[] paramaters)
{
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
string id = paramaters[0] as string;
tblMedicine medicine = appDBContext.tblMedicines.Where(o => o.MedicineID == id).FirstOrDefault();
result = new SQLQueryResult(medicine == null ? false : true, MessageQueryResult.Done);
}
catch (Exception e)
{
App.Current.ShowApplicationMessageBox(e.Message);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
return(result);
}
private SQLQueryResult GetAllNonAdminUserData(PharmacyDBContext appDBContext, object[] paramaters)
{
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblUsers.
Where <tblUser>(user => !user.IsAdmin).
ToList();
result = new SQLQueryResult(x, MessageQueryResult.Done);
}
catch (Exception e)
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
ShowErrorMessageBox(e);
}
return(result);
}
private SQLQueryResult GetAllActiveUserData(PharmacyDBContext appDBContext, object[] paramaters)
{
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblUsers.
Where <tblUser>(user => user.IsActive).OrderByDescending(o => o.IsAdmin).ThenBy(o => o.Username).
ToList();
result = new SQLQueryResult(x, MessageQueryResult.Done);
}
catch (Exception e)
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
ShowErrorMessageBox(e);
}
return(result);
}
private SQLQueryResult UpdateUserInfo(PharmacyDBContext appDBContext, object[] paramaters)
{
tblUser modifiedUser = paramaters[0] as tblUser;
string userNameBeforeChanged = paramaters[1] as string;
string imageFolder = paramaters[2] as string;
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblUsers.Where <tblUser>(user => user.Username.Equals(userNameBeforeChanged)).First();
x.FullName = modifiedUser.FullName;
x.Address = modifiedUser.Address;
x.Phone = modifiedUser.Phone;
x.Email = modifiedUser.Email;
x.Link = modifiedUser.Link;
x.Job = modifiedUser.Job;
x.Password = modifiedUser.Password;
x.UserDataJSON = modifiedUser.UserDataJSON;
if (!SaveImageToFile(userNameBeforeChanged, imageFolder, ImageType.User))
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
return(result);
}
appDBContext.SaveChanges();
result = new SQLQueryResult(x, MessageQueryResult.Done);
}
catch (DbEntityValidationException e)
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
HandleDbEntityValidationException(e);
}
catch (Exception e)
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
ShowErrorMessageBox(e);
}
return(result);
}
private SQLQueryResult CheckUserNameExisted(PharmacyDBContext appDBContext, object[] paramaters)
{
string name = paramaters[0].ToString();
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblUsers.Where(user => user.Username.Equals(name)).
ToList();
bool IsExisted = x.Count > 0;
result = new SQLQueryResult(IsExisted, MessageQueryResult.Done);
return(result);
}
catch (Exception e)
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
ShowErrorMessageBox(e);
}
return(null);
}
private SQLQueryResult SetPromoDeactive(PharmacyDBContext appDBContext, object[] paramaters)
{
int id = (int)paramaters[0];
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblPromoes.Where(o => o.PromoID == id).FirstOrDefault();
x.IsActive = false;
appDBContext.SaveChanges();
result = new SQLQueryResult(null, MessageQueryResult.Done);
return(result);
}
catch (Exception e)
{
App.Current.ShowApplicationMessageBox(e.Message);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
return(result);
}
private SQLQueryResult GetAllActiveCustomerOrdersByDateData(PharmacyDBContext appDBContext, object[] paramaters)
{
DateTime startDate = (DateTime)paramaters[0];
DateTime endDate = (DateTime)paramaters[1];
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblOrders.
Where <tblOrder>(order => order.IsActive && order.OrderTime >= startDate && order.OrderTime <= endDate).ToList();
result = new SQLQueryResult(x, MessageQueryResult.Done);
}
catch (Exception e)
{
ShowErrorMessageBox(e);
result = new SQLQueryResult(null, MessageQueryResult.Aborted, "Lỗi load dữ liệu hóa đơn!");
}
return(result);
}
private SQLQueryResult UpdateCustomerOrder(PharmacyDBContext appDBContext, object[] paramaters)
{
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
tblOrder customerOrder = paramaters[0] as tblOrder;
var orderDB = appDBContext.tblOrders.First(o => o.OrderID == customerOrder.OrderID);
if (orderDB != null)
{
orderDB.OrderTime = customerOrder.OrderTime;
orderDB.OrderDescription = customerOrder.OrderDescription;
orderDB.IncludeVAT = customerOrder.IncludeVAT;
orderDB.IsActive = customerOrder.IsActive;
orderDB.PurchasePrice = customerOrder.PurchasePrice;
orderDB.TotalPrice = customerOrder.TotalPrice;
orderDB.UserID = customerOrder.UserID;
orderDB.CustomerID = customerOrder.CustomerID;
orderDB.tblOrderDetails = customerOrder.tblOrderDetails;
appDBContext.SaveChanges();
result = new SQLQueryResult(orderDB, MessageQueryResult.Done, "Cập nhật thông tin hóa đơn thành công!");
}
else
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted, "Không tìm thấy hóa đơn khi cập nhật cơ sở dữ liệu!");
}
}
catch (DbEntityValidationException e)
{
HandleDbEntityValidationException(e);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
catch (Exception e)
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
ShowErrorMessageBox(e);
}
return(result);
}
private SQLQueryResult SetUserDeactive(PharmacyDBContext appDBContext, object[] paramaters)
{
string name = paramaters[0].ToString();
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblUsers.Where(user => user.Username.Equals(name)).
First();
x.IsActive = false;
appDBContext.SaveChanges();
result = new SQLQueryResult(null, MessageQueryResult.Done);
return(result);
}
catch (Exception e)
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
ShowErrorMessageBox(e);
}
return(result);
}
private SQLQueryResult CheckUserAvail(PharmacyDBContext appDBContext, object[] paramaters)
{
string name = paramaters[0].ToString();
string pass = paramaters[1].ToString();
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblUsers.Where(user => user.Username.Equals(name) &&
user.Password.Equals(pass)).ToList();
result = new SQLQueryResult(x, MessageQueryResult.Done);
return(result);
}
catch (Exception e)
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
ShowErrorMessageBox(e);
}
return(null);
}
private SQLQueryResult SetCustomerDeactive(PharmacyDBContext appDBContext, object[] paramaters)
{
int cusID = Convert.ToInt32(paramaters[0]);
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblCustomers.Where(cus => cus.CustomerID == cusID).
First();
x.IsActive = false;
appDBContext.SaveChanges();
result = new SQLQueryResult(null, MessageQueryResult.Done);
return(result);
}
catch (Exception e)
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
App.Current.ShowApplicationMessageBox(e.Message);
}
return(result);
}
private SQLQueryResult SetMedicineDeactive(PharmacyDBContext appDBContext, object[] paramaters)
{
string id = paramaters[0].ToString();
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblMedicines.Where(user => user.MedicineID.Equals(id)).
First();
x.IsActive = false;
appDBContext.SaveChanges();
result = new SQLQueryResult(null, MessageQueryResult.Done);
return(result);
}
catch (Exception e)
{
App.Current.ShowApplicationMessageBox(e.Message);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
return(result);
}
private SQLQueryResult ModifyMedicine(PharmacyDBContext appDBContext, object[] paramaters)
{
tblMedicine updateMedicine = paramaters[0] as tblMedicine;
string imageFolder = paramaters[1] as string;
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
tblMedicine currentMedicine = MSW_DataFlowHost.Current.CurrentModifiedMedicine;
tblMedicine medicine = appDBContext.tblMedicines.Where(o => o.MedicineID == currentMedicine.MedicineID).FirstOrDefault();
medicine.MedicineName = updateMedicine.MedicineName;
medicine.MedicineTypeID = updateMedicine.MedicineTypeID;
medicine.MedicineUnitID = updateMedicine.MedicineUnitID;
medicine.SupplierID = updateMedicine.SupplierID;
medicine.BidPrice = updateMedicine.BidPrice;
medicine.AskingPrice = updateMedicine.AskingPrice;
medicine.MedicineDescription = updateMedicine.MedicineDescription;
medicine.IsActive = true;
if (!SaveImageToFile(medicine.MedicineID, imageFolder, ImageType.Medicine))
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
return(result);
}
appDBContext.SaveChanges();
result = new SQLQueryResult(null, MessageQueryResult.Done);
}
catch (DbEntityValidationException e)
{
HandleDbEntityValidationException(e);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
catch (Exception e)
{
App.Current.ShowApplicationMessageBox(e.Message);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
return(result);
}
