protected override void ExecuteCommand()
{
_doRefresh = false;
if (!DBMPViewModel.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!");
DBMPViewModel.ButtonCommandOV.IsSaveButtonRunning = false;
return;
}
tblPromo promo = new tblPromo();
promo.PromoPercent = DBMPViewModel.PromoPercent;
promo.PromoDescription = DBMPViewModel.PromoDescription;
promo.MedicineID = DBMPViewModel.MedicineInfo.MedicineID;
promo.CustomerID = DBMPViewModel.LstCustomer[DBMPViewModel.SelectedCustomer].CustomerID;
promo.IsActive = true;
_sqlCmdObserver = new SQLQueryCustodian(SQLQueryCallback);
DbManager.Instance.ExecuteQuery(SQLCommandKey.ADD_MODIFY_PROMO_CMD_KEY,
_sqlCmdObserver,
promo);
if (_doRefresh)
{
DBMPViewModel.RefreshPage();
return;
}
return;
}
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 void GetPromo(OrderDetailOV orderDetailVO)
{
tblPromo appliedPromo = new tblPromo();
if (CBPViewModel.CurrentCustomerOrder != null)
{
foreach (tblPromo promo in CBPViewModel.CurrentCustomerOrder.tblCustomer.tblPromoes)
{
if (promo.MedicineID == CBPViewModel.MedicineOV.CurrentSelectedMedicine.MedicineID)
{
appliedPromo = promo;
break;
}
}
}
orderDetailVO.PromoPercent = appliedPromo.PromoPercent;
}
