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); }