protected override void ExecuteCommand() { if (!MMPViewModel.IsSaveButtonCanPerform) { App.Current.ShowApplicationMessageBox("Kiểm tra lại các trường bị sai trên!", HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.Default, HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Hand, OwnerWindow.MainScreen, "Thông báo!"); MMPViewModel.ButtonCommandOV.IsSaveButtonRunning = false; return; } tblMedicine medicine = new tblMedicine(); medicine.MedicineID = MMPViewModel.MedicineID.Trim(); medicine.MedicineName = MMPViewModel.MedicineName.Trim(); medicine.MedicineTypeID = MMPViewModel.LstMedicineType[MMPViewModel.MedicineTypeID].MedicineTypeID; medicine.MedicineUnitID = MMPViewModel.LstMedicineUnit[MMPViewModel.MedicineUnitID].MedicineUnitID; medicine.SupplierID = MMPViewModel.LstSupplier[MMPViewModel.SupplierID].SupplierID; medicine.BidPrice = MMPViewModel.BidPrice; medicine.AskingPrice = MMPViewModel.AskingPrice; medicine.MedicineDescription = MMPViewModel.MedicineDescription; medicine.IsActive = true; _sqlCmdObserver = new SQLQueryCustodian(SQLQueryCallback); DbManager.Instance.ExecuteQueryAsync(SQLCommandKey.MODIFY_MEDICINE_CMD_KEY, PharmacyDefinitions.MODIFY_MEDICINE_DELAY_TIME, _sqlCmdObserver, medicine, MMPViewModel.MedicineImageFileName); return; }
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); }
public ActionResult AddMedicine(int?medicine_id) { var model = new tblMedicine(); var cat = new MedicineDAL().GetCategories().ToList(); ViewBag.MedicineCat = cat; if (medicine_id != null) { model = new MedicineDAL().GetMedicine(Convert.ToInt32(medicine_id)); } return(View(model)); }
public override void RefreshViewModel() { MedicineTextSearch = ""; MedicineCost = 0; PaidAmount = 0; CurrentSelectedMedicine = null; Quantity = ""; Invalidate("DebtCost"); Invalidate("TotalCost"); Invalidate("RestAmount"); }
private void UpdateModifyData() { _modifiedMedicine = MSW_DataFlowHost.Current.CurrentModifiedMedicine; MedicineID = _modifiedMedicine.MedicineID; MedicineName = _modifiedMedicine.MedicineName; MedicineTypeID = LstMedicineType.IndexOf(_modifiedMedicine.tblMedicineType); MedicineUnitID = LstMedicineUnit.IndexOf(_modifiedMedicine.tblMedicineUnit); SupplierID = LstSupplier.IndexOf(_modifiedMedicine.tblSupplier); BidPrice = _modifiedMedicine.BidPrice; AskingPrice = _modifiedMedicine.AskingPrice; MedicineDescription = _modifiedMedicine.MedicineDescription; GetWarehouseImportDetail(); MedicineImageSource = FileIOUtil. GetBitmapFromName(_modifiedMedicine.MedicineID.ToString(), FileIOUtil.MEDICINE_IMAGE_FOLDER_NAME). ToImageSource(); }
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 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); }
public ActionResult AddMedicine(int?medicine_id, tblMedicine Obj) { string username = ""; HttpCookie cookie = HttpContext.Request.Cookies["AdminCookies"]; if (cookie != null) { username = Convert.ToString(cookie.Values["UserName"]); } try { Obj.isActive = true; // TODO: Add insert logic here if (medicine_id != null) { Obj.ID = Convert.ToInt32(medicine_id); new MedicineDAL().UpdateMedicine(Obj); TempData["AlertTask"] = "medicine updated successfully"; } else { Obj.CreatedBy = username; Obj.CreatedAt = DateTime.UtcNow; medicine_id = new MedicineDAL().AddMedicine(Obj); TempData["AlertTask"] = "medicine added successfully"; } return(Redirect("/medicine")); } catch { return(View()); } }
private bool FilterByType(tblMedicine medicine, string filterText) { return(RUNE.IS_SUPPORT_FILTER_MEDICINE_BY_TYPE ? (_lstMedicineTypeFilter.Contains(medicine.MedicineTypeID)) : false); }
private bool SearchBySupplierName(tblMedicine medicine, string filterText) { return(RUNE.IS_SUPPORT_SEARCH_MEDICINE_BY_SUPPLIER_NAME ? (CultureInfo.CurrentCulture.CompareInfo.IndexOf(medicine.tblSupplier.SupplierName, filterText, CompareOptions.IgnoreCase) >= 0) : false); }
private bool SearchByID(tblMedicine medicine, string filterText) { return(RUNE.IS_SUPPORT_SEARCH_MEDICINE_BY_ID ? (CultureInfo.CurrentCulture.CompareInfo.IndexOf(medicine.MedicineID, filterText, CompareOptions.IgnoreCase) >= 0) : false); }
private bool FilterMedicineList(tblMedicine medicine, string filterText) { return((SearchByID(medicine, filterText) || SearchByName(medicine, filterText) || SearchBySupplierName(medicine, filterText)) && FilterByType(medicine, filterText)); }