private void InstantiateCustomerItems()
{
CustomerItemSource = new ObservableCollection <tblCustomer>();
_sqlCmdObserver = new SQLQueryCustodian(SQLGetCustomerQueryCallback);
DbManager.Instance.ExecuteQuery(SQLCommandKey.GET_ALL_ACTIVE_CUSTOMER_CMD_KEY
, _sqlCmdObserver);
}
private void SaveCurrentCustomerOrder()
{
if (CBPViewModel.IsOrderModified)
{
var mbRes = App.Current.ShowApplicationMessageBox("Bạn có đồng ý lưu hóa đơn này?",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.YesNo,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Question,
OwnerWindow.MainScreen,
"Thông báo!!");
if (mbRes == HPSolutionCCDevPackage.netFramework.AnubisMessgaeResult.ResultYes)
{
_sqlQueryObserver = new SQLQueryCustodian(UpdateCustomerOrderDetailQueryCallback);
UpdateCustomerOderDetails();
DbManager.Instance.ExecuteQueryAsync(SQLCommandKey.UPDATE_CUSTOMER_ORDER_DEATAIL_CMD_KEY,
PharmacyDefinitions.UPDATE_CUSTOMER_ORDER_DEATAIL_DELAY_TIME,
_sqlQueryObserver,
CBPViewModel.CurrentCustomerOrder
);
}
CBPViewModel.ButtonCommandOV.IsSaveButtonRunning = false;
}
}
private void InstantinateMedicineItems()
{
MedicineItemSource = new ObservableCollection <tblMedicine>();
_sqlCmdObserver = new SQLQueryCustodian(SQLGetMedicineQueryCallback);
DbManager.Instance.ExecuteQuery(SQLCommandKey.GET_ALL_ACTIVE_MEDICINE_DATA_CMD_KEY
, _sqlCmdObserver);
}
protected override void ExecuteCommand()
{
base.ExecuteCommand();
TextBox userNameTextEdit = (TextBox)DataTransfer[0];
PasswordBox userPasswordTextEdit = (PasswordBox)DataTransfer[1];
string userName = userNameTextEdit.Text;
string passWord = userPasswordTextEdit.Password;
try
{
_observer = new SQLQueryCustodian(SQLQueryCallback);
DbManager.Instance.ExecuteQueryAsync(SQLCommandKey.CHECK_USER_AVAIL_CMD_KEY
, PharmacyDefinitions.LOGIN_BUTTON_PERFORM_DELAY_TIME
, _observer
, userName, passWord);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
}
return;
}
protected override void ExecuteCommand()
{
if (!PIPViewModel.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!");
PIPViewModel.ButtonCommandOV.IsSaveButtonRunning = false;
return;
}
modifiedInfo = new tblUser();
modifiedInfo.Username = PIPViewModel.CurrentUser.Username;
modifiedInfo.FullName = PIPViewModel.FullNameText;
modifiedInfo.Address = PIPViewModel.AdressText;
modifiedInfo.Phone = PIPViewModel.PhoneText;
modifiedInfo.Email = PIPViewModel.EmailText;
modifiedInfo.Link = PIPViewModel.LinkText;
modifiedInfo.Job = PIPViewModel.CurrentUser.Job;
modifiedInfo.UserDataJSON = PIPViewModel.CurrentUser.GetUserDataJSON();
modifiedInfo.Password = String.IsNullOrEmpty(PIPViewModel.NewPassword) ?
App.Current.CurrentUser.Password : PIPViewModel.NewPassword;
_sqlCmdObserver = new SQLQueryCustodian(SQLQueryCallback);
DbManager.Instance.ExecuteQueryAsync(SQLCommandKey.UPDATE_USER_INFO_CMD_KEY
, PharmacyDefinitions.SAVE_USER_MODIFIED_INFO_BUTTON_PERFORM_DELAY_TIME
, _sqlCmdObserver
, modifiedInfo
, App.Current.CurrentUser.Username
, PIPViewModel.UserImageFileName);
return;
}
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 void GetWarehouseImportList()
{
SQLQueryCustodian _sqlCmdObserver = new SQLQueryCustodian((queryResult) =>
{
WarehouseImportItemSource = new ObservableCollection <MSW_WHMP_WarehouseImportOV>();
LstWarehouseImport = queryResult.Result as List <tblWarehouseImport>;
if (queryResult.MesResult == MessageQueryResult.Done)
{
foreach (var item in queryResult.Result as List <tblWarehouseImport> )
{
var detail = new MSW_WHMP_WarehouseImportOV();
detail.ImportID = item.ImportID;
detail.ImportTime = item.ImportTime;
detail.ImportDescription = item.ImportDescription;
detail.IsActive = item.IsActive;
detail.PurchasePrice = item.PurchasePrice;
detail.TotalPrice = item.TotalPrice;
detail.SupplierID = item.SupplierID;
detail.SupplierName = item.tblSupplier.SupplierName;
detail.tblWarehouseImportDetails = item.tblWarehouseImportDetails.Where(o => o.IsActive).ToList();
WarehouseImportItemSource.Add(detail);
}
}
Invalidate("WarehouseImportItemSource");
});
DbManager.Instance.ExecuteQuery(SQLCommandKey.GET_ALL_ACTIVE_WAREHOUSE_IMPORT_DATA_CMD_KEY
, _sqlCmdObserver);
}
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;
}
protected override void ExecuteCommand()
{
base.ExecuteCommand();
_customerDataGrid = DataTransfer[0] as DataGrid;
var mesResult = App.Current.ShowApplicationMessageBox("Bạn có chắc xóa khách hàng này?",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.YesNo,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Question,
OwnerWindow.MainScreen,
"Thông báo!");
if (mesResult == HPSolutionCCDevPackage.netFramework.AnubisMessgaeResult.ResultYes)
{
SQLQueryCustodian sqlQueryObserver = new SQLQueryCustodian((queryResult) =>
{
if (queryResult.MesResult == MessageQueryResult.Done)
{
App.Current.ShowApplicationMessageBox("Xóa khách hàng thành công!",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.Default,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Success,
OwnerWindow.MainScreen,
"Thông báo!");
CMPViewModel.CustomerItemSource.Remove((tblCustomer)_customerDataGrid.SelectedItem);
}
});
DbManager.Instance.ExecuteQuery(SQLCommandKey.SET_CUSTOMER_DEACTIVE_CMD_KEY,
sqlQueryObserver,
((tblCustomer)_customerDataGrid.SelectedItem).CustomerID);
}
}
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;
}
protected override void ExecuteCommand()
{
if (!MSPViewModel.IsSaveButtonCanPerform)
{
App.Current.ShowApplicationMessageBox("Kiểm tra lại tên và số điện thoại của nhà cung cấp!",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.Default,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Hand,
OwnerWindow.MainScreen,
"Thông báo!");
MSPViewModel.ButtonCommandOV.IsSaveButtonRunning = false;
return;
}
tblSupplier supplier = new tblSupplier();
supplier.SupplierID = MSPViewModel.SupplierInfo.SupplierID;
supplier.SupplierName = MSPViewModel.SupplierName;
supplier.Phone = MSPViewModel.Phone;
supplier.Email = MSPViewModel.Email;
supplier.Address = MSPViewModel.Address;
supplier.SupplierDescription = MSPViewModel.Description;
supplier.IsActive = true;
_sqlCmdObserver = new SQLQueryCustodian(SQLQueryCallback);
DbManager.Instance.ExecuteQueryAsync(SQLCommandKey.MODIFY_SUPPLIER_CMD_KEY,
PharmacyDefinitions.MODIFY_SUPPLIER_DELAY_TIME,
_sqlCmdObserver,
supplier);
return;
}
protected override void ExecuteCommand()
{
if (!UIPViewModel.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!");
UIPViewModel.ButtonCommandOV.IsSaveButtonRunning = false;
return;
}
if (!IsUseDefaultPassword())
{
UIPViewModel.ButtonCommandOV.IsSaveButtonRunning = false;
return;
}
_sqlCmdObserver = new SQLQueryCustodian(SQLQueryCallback);
DbManager.Instance.ExecuteQueryAsync(SQLCommandKey.ADD_NEW_USER_CMD_KEY,
PharmacyDefinitions.SAVE_USER_MODIFIED_INFO_BUTTON_PERFORM_DELAY_TIME,
_sqlCmdObserver,
_newUserInfo,
UIPViewModel.UserImageFileName);
return;
}
protected override void ExecuteCommand()
{
tblWarehouseImport import = MWIPViewModel.ImportInfo;
import.ImportDescription = MWIPViewModel.NoteString.Trim();
import.TotalPrice = MWIPViewModel.TotalPrice;
import.PurchasePrice = MWIPViewModel.PurchasedPrice;
List <tblWarehouseImportDetail> details = new List <tblWarehouseImportDetail>();
foreach (var item in MWIPViewModel.LstWarehouseImportDetail)
{
tblWarehouseImportDetail detail = new tblWarehouseImportDetail();
detail.IsActive = true;
detail.MedicineID = item.MedicineID;
detail.Price = item.UnitPrice;
detail.Quantity = item.Quantity;
details.Add(detail);
}
_sqlCmdObserver = new SQLQueryCustodian(SQLQueryCallback);
DbManager.Instance.ExecuteQueryAsync(SQLCommandKey.MODIFY_WAREHOUSE_IMPORT_CMD_KEY,
PharmacyDefinitions.MODIFY_WAREHOUSE_IMPORT_DELAY_TIME,
_sqlCmdObserver,
import,
details,
MWIPViewModel.InvoiceImageURL);
return;
}
private void GetOtherPaymentList()
{
SQLQueryCustodian _sqlCmdObserver = new SQLQueryCustodian((queryResult) =>
{
OtherPaymentItemSource = new ObservableCollection <tblOtherPayment>(queryResult.Result as List <tblOtherPayment>);
Invalidate("OtherPaymentItemSource");
});
DbManager.Instance.ExecuteQuery(SQLCommandKey.GET_ALL_ACTIVE_OTHER_PAYMENT_DATA_CMD_KEY
, _sqlCmdObserver);
}
private void GetMedicineList()
{
SQLQueryCustodian _sqlCmdObserver = new SQLQueryCustodian((queryResult) =>
{
if (queryResult.MesResult == MessageQueryResult.Done)
{
_lstMedicineFull = queryResult.Result as List <tblMedicine>;
}
});
DbManager.Instance.ExecuteQuery(SQLCommandKey.GET_ALL_ACTIVE_MEDICINE_DATA_CMD_KEY
, _sqlCmdObserver);
}
private void GetMedicineList()
{
SQLQueryCustodian _sqlCmdObserver = new SQLQueryCustodian((queryResult) =>
{
if (queryResult.MesResult == MessageQueryResult.Done)
{
MedicineItemSource = new ObservableCollection <tblMedicine>(queryResult.Result as List <tblMedicine>);
Invalidate("MedicineItemSource");
}
});
DbManager.Instance.ExecuteQuery(SQLCommandKey.GET_ALL_ACTIVE_MEDICINE_DATA_CMD_KEY
, _sqlCmdObserver);
}
private void GetSupplierList()
{
SQLQueryCustodian _sqlCmdObserver = new SQLQueryCustodian((queryResult) =>
{
if (queryResult.MesResult == MessageQueryResult.Done)
{
LstSupplier = new ObservableCollection <tblSupplier>(queryResult.Result as List <tblSupplier>);
Invalidate("LstSupplier");
}
});
DbManager.Instance.ExecuteQuery(SQLCommandKey.GET_ALL_ACTIVE_SUPPLIER_DATA_CMD_KEY
, _sqlCmdObserver);
}
protected override void ExecuteCommand()
{
var user = App.Current.CurrentUser;
user.GetUserData().FontZoomRatio = SPViewModel.FontSizeRatio;
user.UserDataJSON = user.GetUserDataJSON();
_sqlCmdObserver = new SQLQueryCustodian(SQLQueryCallback);
DbManager.Instance.ExecuteQueryAsync(SQLCommandKey.UPDATE_USER_INFO_CMD_KEY
, PharmacyDefinitions.SAVE_USER_MODIFIED_INFO_BUTTON_PERFORM_DELAY_TIME
, _sqlCmdObserver
, user
, App.Current.CurrentUser.Username
, "");
return;
}
private void GenerateOrder()
{
try
{
_newOrder = new tblOrder();
_newOrder.IsActive = true;
_newOrder.OrderTime = DateTime.Now;
_newOrder.UserID = App.Current.CurrentUser.Username;
_newOrder.CustomerID = SPViewModel.CustomerOV.CurrentSelectedCustomer.CustomerID;
_newOrder.OrderDescription = SPViewModel.OrderDescription;
_newOrder.TotalPrice = SPViewModel.MedicineOV.MedicineCost;
_newOrder.PurchasePrice = SPViewModel.MedicineOV.PaidAmount;
foreach (OrderDetailOV vo in SPViewModel.CustomerOrderDetailItemSource)
{
tblOrderDetail oD = new tblOrderDetail()
{
IsActive = true,
Quantity = Convert.ToDouble(vo.Quantity),
TotalPrice = vo.TotalPrice,
UnitPrice = vo.UnitPrice,
MedicineID = vo.MedicineID,
PromoPercent = vo.PromoPercent,
UnitBidPrice = vo.UnitBidPrice
};
_newOrder.tblOrderDetails.Add(oD);
}
}
catch (Exception e)
{
App.Current.ShowApplicationMessageBox("Không thể tạo hóa đơn mới, vui lòng liên hệ CSKH!",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.Default,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Info,
OwnerWindow.MainScreen,
"Lỗi!!");
SPViewModel.ButtonCommandOV.IsInstantiateNewOrderButtonRunning = false;
}
_previousDebt = SPViewModel.MedicineOV.DebtCost;
_createNewOrderQueryObserver = new SQLQueryCustodian(GenerateOrderCallback,
null,
typeof(MSW_SP_InstantiateNewOrderAction));
DbManager.Instance.ExecuteQueryAsync(SQLCommandKey.ADD_NEW_CUSTOMER_ORDER_CMD_KEY,
PharmacyDefinitions.ADD_NEW_CUSTOMER_ORDER_DELAY_TIME,
_createNewOrderQueryObserver,
_newOrder);
}
private void GetActiveSuppliers()
{
SQLQueryCustodian sqlCmdObserver = new SQLQueryCustodian(queryResult =>
{
if (queryResult.MesResult == MessageQueryResult.Done)
{
_lstActiveSuppliers = queryResult.Result as List <tblSupplier>;
}
else
{
_lstActiveSuppliers = new List <tblSupplier>();
}
});
DbManager.Instance.ExecuteQuery(SQLCommandKey.GET_ALL_ACTIVE_SUPPLIER_DATA_CMD_KEY,
sqlCmdObserver);
}
private void GetListOfMedicineType()
{
SQLQueryCustodian _sqlCmdObserver = new SQLQueryCustodian((queryResult) =>
{
if (queryResult.MesResult == MessageQueryResult.Done)
{
LstMedicineType = new ObservableCollection <tblMedicineType>(queryResult.Result as List <tblMedicineType>);
}
else
{
LstMedicineType = new ObservableCollection <tblMedicineType>();
}
});
DbManager.Instance.ExecuteQuery(SQLCommandKey.GET_ALL_MEDICINE_TYPE_DATA_CMD_KEY
, _sqlCmdObserver);
}
private void OnPagePreviewNavigate(object sender, EventArgs e, object paramater)
{
var x = CurrentPageSource.OriginalString;
switch (x)
{
case PharmacyDefinitions.SELLING_PAGE_URI_ORIGINAL_STRING:
if (RUNE.IS_SUPPORT_WINDOW_NAVIGATION_BUTTON_PANEL)
{
SQLQueryCustodian.DeactiveAllRegistrationsOfType(typeof(MSW_SP_AddOrderDetailAction));
}
// Disable navigate when the call back from this action be not executed
if (!SQLQueryCustodian.IsAllCallbackHandled(typeof(MSW_SP_InstantiateNewOrderAction)) &&
RUNE.IS_SUPPORT_WINDOW_NAVIGATION_BUTTON_PANEL)
{
// Stop navigating
(e as PreviewPageNavigateArgs).Handled = true;
App.Current.ShowApplicationMessageBox("Vui lòng chờ hoàn tất thao tác!",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.Default,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Info,
OwnerWindow.MainScreen,
"Thông báo!!");
}
break;
default:
// Disable navigate when the call back from this action be not executed
if (!SQLQueryCustodian.IsAllCallbackHandled(typeof(SQLQueryCustodian)) &&
RUNE.IS_SUPPORT_WINDOW_NAVIGATION_BUTTON_PANEL)
{
// Stop navigating
(e as PreviewPageNavigateArgs).Handled = true;
App.Current.ShowApplicationMessageBox("Vui lòng chờ hoàn tất thao tác!",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.Default,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Info,
OwnerWindow.MainScreen,
"Thông báo!!");
}
break;
}
}
private void AddAllMedicineTypeToFilterList()
{
SQLQueryCustodian _sqlCmdObserver = new SQLQueryCustodian((queryResult) =>
{
if (queryResult.MesResult == MessageQueryResult.Done)
{
foreach (var type in queryResult.Result as List <tblMedicineType> )
{
_lstMedicineTypeFilter.Add(type.MedicineTypeID);
_lstMedicineType.Add(type);
}
}
});
DbManager.Instance.ExecuteQuery(SQLCommandKey.GET_ALL_MEDICINE_TYPE_DATA_CMD_KEY
, _sqlCmdObserver);
}
private void GetCustomerList()
{
SQLQueryCustodian _sqlCmdObserver = new SQLQueryCustodian((queryResult) =>
{
if (queryResult.MesResult == MessageQueryResult.Done)
{
LstCustomer = queryResult.Result as List <tblCustomer>;
}
else
{
LstCustomer = new List <tblCustomer>();
}
SelectedCustomer = -1;
});
DbManager.Instance.ExecuteQuery(SQLCommandKey.GET_ALL_ACTIVE_CUSTOMER_CMD_KEY
, _sqlCmdObserver);
}
private void GetWarehouseImportDetail()
{
SQLQueryCustodian _sqlCmdObserver = new SQLQueryCustodian((queryResult) =>
{
if (queryResult.MesResult == MessageQueryResult.Done)
{
LstWarehouseImportDetail = new ObservableCollection <tblWarehouseImportDetail>(queryResult.Result as List <tblWarehouseImportDetail>);
}
else
{
LstWarehouseImportDetail = new ObservableCollection <tblWarehouseImportDetail>();
}
});
DbManager.Instance.ExecuteQuery(SQLCommandKey.GET_ALL_ACTIVE_MEDICINE_STOCK_IN_WAREHOUSE_DATA_CMD_KEY
, _sqlCmdObserver
, MedicineID);
}
protected override void ExecuteCommand()
{
if (IMPViewModel.CurrentSelectedOrderOV != null)
{
var x = App.Current.ShowApplicationMessageBox("Bạn có muốn xóa hóa đơn này?",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.YesNo,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Question,
OwnerWindow.MainScreen,
"Thông báo");
if (x == HPSolutionCCDevPackage.netFramework.AnubisMessgaeResult.ResultYes)
{
_sqlQueryObserver = new SQLQueryCustodian(SetDeactiveCustomerOrderQueryCallback);
DbManager.Instance.ExecuteQuery(SQLCommandKey.SET_CUSTOMER_ORDER_DEACTIVE_CMD_KEY,
_sqlQueryObserver,
IMPViewModel.CurrentSelectedOrderOV.Order
);
}
}
}
private void GetPromoListByMedicine()
{
SQLQueryCustodian _sqlCmdObserver = new SQLQueryCustodian((queryResult) =>
{
if (queryResult.MesResult == MessageQueryResult.Done)
{
LstPromo = new ObservableCollection <tblPromo>(queryResult.Result as List <tblPromo>);
}
else
{
LstPromo = new ObservableCollection <tblPromo>();
}
Invalidate("LstPromo");
});
DbManager.Instance.ExecuteQuery(SQLCommandKey.GET_ALL_ACTIVE_PROMO_BY_MEDICINE_CMD_KEY
, _sqlCmdObserver
, MedicineInfo.MedicineID);
}
private void IsMedicineIDExisted()
{
SQLQueryCustodian _sqlCmdObserver = new SQLQueryCustodian((queryResult) =>
{
if ((bool)(queryResult.Result) == true)
{
MedicineIDCheckingStatusText = MedicineIDCheckingStatusMessage.MedicineIDExisted.GetStringValue();
MedicineIDCheckingStatus = (int)MedicineIDCheckingStatusMessage.MedicineIDExisted;
}
else
{
MedicineIDCheckingStatusText = MedicineIDCheckingStatusMessage.MedicineIDAccepted.GetStringValue();
MedicineIDCheckingStatus = (int)MedicineIDCheckingStatusMessage.MedicineIDAccepted;
}
});
DbManager.Instance.ExecuteQuery(SQLCommandKey.CHECK_MEDICINEID_EXISTED_CMD_KEY
, _sqlCmdObserver
, MedicineID);
}
private void DeleteCurrentCustomerOrder()
{
var mbRes = App.Current.ShowApplicationMessageBox("Danh sách sản phẩm hiện tại đang trống.\nBạn có muốn xóa hóa đơn này?",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.YesNo,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Question,
OwnerWindow.MainScreen,
"Thông báo!!");
if (mbRes == HPSolutionCCDevPackage.netFramework.AnubisMessgaeResult.ResultYes)
{
_sqlQueryObserver = new SQLQueryCustodian(SetDeactiveCustomerOrderQueryCallback);
DbManager.Instance.ExecuteQueryAsync(SQLCommandKey.SET_CUSTOMER_ORDER_DEACTIVE_CMD_KEY,
PharmacyDefinitions.SET_CUSTOMER_ORDER_DEACTIVE_DELAY_TIME,
_sqlQueryObserver,
CBPViewModel.CurrentCustomerOrder
);
}
else
{
CBPViewModel.ButtonCommandOV.IsSaveButtonRunning = false;
}
}
private void ShouldCreateNewCustomer()
{
if (SPViewModel.CustomerOV.CurrentSelectedCustomer == null)
{
var x = App.Current.ShowApplicationMessageBox("Khách hàng hiện chưa trong cơ sở dữ liệu, bạn có muốn thêm mới?",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.YesNo,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Question,
OwnerWindow.MainScreen,
"Thông báo!!");
if (x == HPSolutionCCDevPackage.netFramework.AnubisMessgaeResult.ResultNo)
{
SPViewModel.ButtonCommandOV.IsAddOrderDeatailButtonRunning = false;
return;
}
else
{
tblCustomer newCustomer = new tblCustomer()
{
CustomerName = SPViewModel.CustomerOV.CustomerName,
Phone = SPViewModel.CustomerOV.CustomerPhone,
Address = SPViewModel.CustomerOV.CustomerAddress,
IsActive = true
};
_queryObserver = new SQLQueryCustodian(AddNewCustomerToDataBaseCallBack,
AddNewCustomerToDataBaseForceCallBack,
typeof(MSW_SP_AddOrderDetailAction));
DbManager.Instance.ExecuteQueryAsync(SQLCommandKey.ADD_NEW_CUSTOMER_CMD_KEY,
PharmacyDefinitions.ADD_NEW_CUSTOMER_DELAY_TIME,
_queryObserver,
newCustomer,
"");
}
}
else
{
CreateNewOrderDetail();
}
}
