protected override void ExecuteCommand()
{
if (!AOPPViewModel.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!");
AOPPViewModel.ButtonCommandOV.IsSaveButtonRunning = false;
return;
}
tblOtherPayment payment = new tblOtherPayment();
payment.PaymentTime = AOPPViewModel.PaymentTime;
payment.PaymentType = AOPPViewModel.PaymentType;
payment.PaymentContent = AOPPViewModel.PaymentDetail;
payment.TotalPrice = AOPPViewModel.PaymentPrice;
payment.IsActive = true;
_sqlCmdObserver = new SQLQueryCustodian(SQLQueryCallback);
DbManager.Instance.ExecuteQueryAsync(SQLCommandKey.ADD_OTHER_PAYMENT_CMD_KEY,
PharmacyDefinitions.ADD_NEW_OTHER_PAYMENT_DELAY_TIME,
_sqlCmdObserver,
payment,
AOPPViewModel.InvoiceImageURL);
return;
}
private SQLQueryResult AddNewOtherPayment(PharmacyDBContext appDBContext, object[] paramaters)
{
tblOtherPayment payment = paramaters[0] as tblOtherPayment;
string imageFolder = paramaters[1] as string;
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
appDBContext.tblOtherPayments.Add(payment);
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 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 void UpdateData()
{
OtherPaymentDetail = MSW_DataFlowHost.Current.CurrentSelectedOtherPayment;
PaymentPrice = OtherPaymentDetail.TotalPrice;
PaymentTime = OtherPaymentDetail.PaymentTime;
PaymentType = OtherPaymentDetail.PaymentType;
PaymentDetail = OtherPaymentDetail.PaymentContent;
}
private bool FilterByEndDate(tblOtherPayment item, DateTime?endDate)
{
if (endDate == null)
{
return(true);
}
else
{
return(RUNE.IS_SUPPORT_FILTER_OTHER_PAYMENT_BY_END_DATE
? item.PaymentTime <= endDate
: false);
}
}
private bool FilterByStartDate(tblOtherPayment item, DateTime?startDate)
{
if (startDate == null)
{
return(true);
}
else
{
return(RUNE.IS_SUPPORT_FILTER_OTHER_PAYMENT_BY_START_DATE
? item.PaymentTime >= startDate
: false);
}
}
private bool SearchByType(tblOtherPayment item, int selectedTypeIndex)
{
if (RUNE.IS_SUPPORT_SEARCH_OTHER_PAYMENT_BY_TYPE)
{
if (selectedTypeIndex == 0)
{
return(true);
}
else if (item.PaymentType == 0 && selectedTypeIndex == 1)
{
return(true);
}
else if (item.PaymentType == 1 && selectedTypeIndex == 2)
{
return(true);
}
}
return(false);
}
private bool FilterWarehouseImportInfoList(tblOtherPayment item, int selectedTypeIndex, DateTime?startDate, DateTime?endDate)
{
return(SearchByType(item, selectedTypeIndex) &&
FilterByStartDate(item, startDate) &&
FilterByEndDate(item, endDate));
}
