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