private void SQLQueryCallback(SQLQueryResult queryResult)
{
List <tblUser> result = (List <tblUser>)queryResult.Result;
try
{
int count = result.Count();
if (count == 1)
{
if (result[0].IsActive)
{
App.Current.SessionIDInstansiation(result[0]);
SaveUserName(result[0].Username);
}
else
{
App.Current.ShowApplicationMessageBox("Tài khoản này hiện tại đã bị xóa, vui lòng liên hệ admin để khôi phục!",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.Default,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Info,
OwnerWindow.LoginScreen);
}
}
else
{
App.Current.ShowApplicationMessageBox("Thông tin đăng nhập không chính xác!",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.Default,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Info,
OwnerWindow.LoginScreen);
}
}
catch (Exception e)
{
App.Current.ShowApplicationMessageBox(e.Message,
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.Default,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Error,
OwnerWindow.LoginScreen);
}
finally
{
if (LSWViewModel != null)
{
LSWViewModel.IsLoginButtonRunning = false;
}
//In this asycn action, till the call back method was done execute
//need to set the Compelete flag
SetCompleteFlagAfterExecuteCommand();
}
}
private void SQLGetMedicineQueryCallback(SQLQueryResult queryResult)
{
if (queryResult.MesResult == MessageQueryResult.Done)
{
MedicineItemSource = new ObservableCollection <tblMedicine>(queryResult.Result as List <tblMedicine>);
}
else
{
App.Current.ShowApplicationMessageBox("Lỗi load dữ liệu thuốc, vui lòng mở lại ứng dụng hoặc liên hệ CSKH để biết thêm thông tin!",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.Default,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Error,
OwnerWindow.MainScreen,
"Thông báo!");
}
}
/// <summary>
/// Gets the multiple keys.
/// </summary>
/// <returns>The multiple keys.</returns>
/// <param name="searchTerm">Search term.</param>
/// <param name="year">Year.</param>
/// <param name="database">Database.</param>
public static Dictionary <string, string> GetMultipleKeys(string searchTerm, int year, Db database)
{
Dictionary <string, string> retKeys = new Dictionary <string, string>();
SQLStoredProcedure sp = StoredProcedureManager.Get("GetFranchiseID");
sp.Parameters = new object[] { searchTerm, year };
SQLQueryResult result = database.ExecuteQuery(sp.Text);
foreach (DataRow row in result.DataTable.Rows)
{
retKeys.Add(row[0].ToString(), row[1].ToString());
}
return(retKeys);
}
/// <summary>
/// Loads the team group.
/// </summary>
/// <returns>TeamGroup</returns>
/// <param name="leagueName">string</param>
/// <param name="year">int</param>
/// <param name="database">Db</param>
/// <param name="seriesLength">int</param>
public static TeamGroupTree LoadRoot(string leagueName, int year, Db database, int seriesLength = 3)
{
TeamGroupTree league = null;
Dictionary <string, TeamGroup> divisions = new Dictionary <string, TeamGroup>();
SQLStoredProcedure sp = StoredProcedureManager.Get("GetDivisionInfo");
sp.Parameters = new object[] { leagueName, year };
SQLQueryResult result = database.ExecuteQuery(sp.Text);
DataTable teamGroupInfo = result.DataTable;
string leagueID = teamGroupInfo.Rows[0]["lgID"].ToString();
foreach (DataRow row in teamGroupInfo.Rows)
{
string teamID = row["teamID"].ToString();
string teamName = row["name"].ToString();
string divID = row["divID"].ToString();
TeamGroup group = null;
Team team = null;
team = DatabaseTeamLoader.LoadTeam(teamName, year, database);
if (!divisions.ContainsKey(divID))
{
group = new TeamGroup(divID, divID);
divisions.Add(divID, group);
if (!group.Contains(team))
{
group.Add(team);
}
}
else
{
divisions[divID].Add(team);
}
Console.WriteLine($"Added {team} to division '{divID}'");
System.Threading.Thread.Sleep(150);
}
league = new TeamGroupTree(leagueID, leagueName, seriesLength);
foreach (TeamGroup division in divisions.Values)
{
league.Add(division);
Console.WriteLine($"Added division '{division.Name}' to league '{league.Name}'");
System.Threading.Thread.Sleep(150);
}
return(league);
}
private SQLQueryResult GetAllMedicineTypeData(PharmacyDBContext appDBContext, object[] paramaters)
{
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
List <tblMedicineType> lstOutput = appDBContext.tblMedicineTypes.ToList();
result = new SQLQueryResult(lstOutput, MessageQueryResult.Done);
}
catch (Exception e)
{
App.Current.ShowApplicationMessageBox(e.Message);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
return(result);
}
private SQLQueryResult GetAllActiveSupplierData(PharmacyDBContext appDBContext, object[] paramaters)
{
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
List <tblSupplier> lstOutput = appDBContext.tblSuppliers.Where(o => o.IsActive).OrderBy(o => o.SupplierName).ToList();
result = new SQLQueryResult(lstOutput, MessageQueryResult.Done);
}
catch (Exception e)
{
App.Current.ShowApplicationMessageBox(e.Message);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
return(result);
}
public void TestYears()
{
Db database = new Db(MainClass.conn);
int startYear = 1884;
int endYear = DateTime.Now.Year - 1;
int iterations = 0;
int passes = 0;
List <int> yearsOmitted = new List <int>();
for (int year = startYear; year <= endYear; year++)
{
if (!emptyYears.Contains(year))
{
try
{
SQLQueryResult result = DatabaseChampionshipSeriesLoader.GetSeriesInfo(year, database);
int results = result.DataTable.Rows.Count;
Console.WriteLine($"{year}: Result Rows={results}");
if (results > 0)
{
passes++;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(ex.StackTrace);
}
iterations++;
}
else
{
yearsOmitted.Add(year);
}
}
Console.WriteLine($"Passed {passes}/{iterations}");
Console.Write("Years omitted:");
foreach (int year in yearsOmitted)
{
Console.Write($" {year}");
}
Console.WriteLine();
Assert.IsTrue(passes == iterations);
Assert.IsTrue(yearsOmitted.Count == emptyYears.Length);
}
/// <summary>
/// Loads the team.
/// </summary>
/// <returns>Team</returns>
/// <param name="searchTerm">string</param>
/// <param name="year">int</param>
/// <param name="database">Db</param>
public static Team LoadTeamFromTeamID(string searchTerm, int year, Db database)
{
SQLStoredProcedure sp = StoredProcedureManager.Get("GetFranchiseIDFromTeamID");
sp.Parameters = new object[] { searchTerm };
SQLQueryResult result = database.ExecuteQuery(sp.Text);
string franchKey = result.DataTable.Rows[0][0].ToString();
SQLStoredProcedure sp2 = StoredProcedureManager.Get("GetFranchiseInfo");
sp2.Parameters = new object[] { franchKey };
SQLQueryResult result2 = database.ExecuteQuery(sp2.Text);
string [] franchiseName = result2.DataTable.Rows[0][1].ToString().Split(' ');
ValueTuple <string, string> parts = Team.GetTeamNameParts(franchiseName);
string teamName = parts.Item1;
string teamMascot = parts.Item2;
Team team = new Team(teamName, teamMascot, year);
Roster roster = null;
Coach coach = null;
//Load roster
//Batting, Pitching, and Fielding stats are loading with the roster
try
{
roster = LoadRosterFromDatabase(team, searchTerm, year, database);
team.Roster = roster;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
//Load manager/coach
try
{
coach = LoadCoachFromDatabase(searchTerm, year, database);
team.Coach = coach;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(team);
}
public void TestSelectBatters()
{
string selectBatters = @"SELECT playerID, nameFirst, nameLast, bats, throws, weight, height, birth_date
FROM people
WHERE playerID IN (
SELECT playerID
FROM batting
WHERE teamID='NYA' AND yearID=2001
);";
int EXPECTED_ROWS = 47;
database = new Db(conn);
Assert.IsTrue(database.IsConnected);
SQLQueryResult result = database.ExecuteQuery(selectBatters);
Assert.IsTrue(result.RowsAffected == EXPECTED_ROWS);
}
private SQLQueryResult GetAllActivePromoByMedicineData(PharmacyDBContext appDBContext, object[] paramaters)
{
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
string MedicineID = paramaters[0] as string;
List <tblPromo> lstOutput = appDBContext.tblPromoes.Where(o => o.MedicineID == MedicineID && o.IsActive).ToList();
result = new SQLQueryResult(lstOutput, MessageQueryResult.Done);
}
catch (Exception e)
{
App.Current.ShowApplicationMessageBox(e.Message);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
return(result);
}
private SQLQueryResult GetAllActiveCustomerData(PharmacyDBContext appDBContext, object[] paramaters)
{
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblCustomers.
Where <tblCustomer>(cus => cus.IsActive).OrderBy(o => o.CustomerName).
ToList();
result = new SQLQueryResult(x, MessageQueryResult.Done);
}
catch (Exception e)
{
ShowErrorMessageBox(e);
}
return(result);
}
private void SQLQueryCallback(SQLQueryResult queryResult)
{
if (queryResult.MesResult == MessageQueryResult.Done)
{
App.Current.ShowApplicationMessageBox("Cập nhật thông tin thành công!",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.Default,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Success,
OwnerWindow.MainScreen,
"Thông báo!");
PageHost.UpdateCurrentPageSource(PageSource.HOME_PAGE);
}
else
{
App.Current.ShowApplicationMessageBox("Lỗi cập nhật thông tin!");
}
PIPViewModel.ButtonCommandOV.IsSaveButtonRunning = false;
}
private SQLQueryResult GetAllActiveCustomerOrdersData(PharmacyDBContext appDBContext, object[] paramaters)
{
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblOrders.
Where <tblOrder>(order => order.IsActive).OrderByDescending(o => o.OrderTime);
result = new SQLQueryResult(x, MessageQueryResult.Done);
}
catch (Exception e)
{
ShowErrorMessageBox(e);
result = new SQLQueryResult(null, MessageQueryResult.Aborted, "Lỗi load dữ liệu hóa đơn!");
}
return(result);
}
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 GetAllNonAdminUserData(PharmacyDBContext appDBContext, object[] paramaters)
{
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblUsers.
Where <tblUser>(user => !user.IsAdmin).
ToList();
result = new SQLQueryResult(x, MessageQueryResult.Done);
}
catch (Exception e)
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
ShowErrorMessageBox(e);
}
return(result);
}
private SQLQueryResult GetAllActiveUserData(PharmacyDBContext appDBContext, object[] paramaters)
{
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblUsers.
Where <tblUser>(user => user.IsActive).OrderByDescending(o => o.IsAdmin).ThenBy(o => o.Username).
ToList();
result = new SQLQueryResult(x, MessageQueryResult.Done);
}
catch (Exception e)
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
ShowErrorMessageBox(e);
}
return(result);
}
/// <summary>
/// 车单状态接口
/// </summary>
/// <param name="userID">车单编号（不能为空）</param>
/// <param name="status">状态（=0 无效，=1 有效）</param>
/// <param name="activationDate">生效日期（为空时不修改，格式yyyy-MM-dd）</param>
/// <returns>=0 成功，=其他 错误代码</returns>
public int SheetStatus(string userID, byte status, string activationDate)
{
try
{
if ((status != 0 && status != 1) ||
string.IsNullOrEmpty(userID))
{
return((int)InterfaceReturnCode.ParameterError);
}
//卡片状态 = 1 Enabled 已发行, = 3 Disabled 禁用,
byte cardStatus = (byte)(status == 0 ? 3 : 1);
SQLHelperProvider sqlHelper = new SQLHelperProvider(AppConifg.Current.ParkingConnection);
string cmdstr;
if (!string.IsNullOrEmpty(activationDate))
{
cmdstr = @"update Card set Status=@status,ActivationDate=@activationDate where CardID=@cardID";
}
else
{
cmdstr = @"update Card set Status=@status where CardID=@cardID";
}
SqlCommand cmd = new SqlCommand();
cmd.CommandText = cmdstr;
cmd.Parameters.AddWithValue("@status", cardStatus);
if (!string.IsNullOrEmpty(activationDate))
{
cmd.Parameters.AddWithValue("@activationDate", activationDate);
}
cmd.Parameters.AddWithValue("@cardID", userID);
SQLQueryResult <int> result = sqlHelper.SQLExecuteNonQuery(cmd);
InterfaceReturnCode code = CreateInterfaceReturnCode(result.Result);
if (code == InterfaceReturnCode.Success && result.QueryObject == 0)
{
//返回更新行数为0时，标识为无记录
code = InterfaceReturnCode.DatabaseNoRecord;
}
return((int)code);
}
catch (Exception)
{
return((int)InterfaceReturnCode.InterfaceException);//接口执行期间发生错误
}
}
private void SetData(SQLQueryResult QueryResult)
{
IList <ListViewItem> listItems = new List <ListViewItem>();
if (QueryResult.FieldInfo.Count > 0)
{
foreach (var row in QueryResult.Row)
{
ListViewItem item = new ListViewItem(row[0].Text);
for (int colNum = 1; colNum < QueryResult.FieldInfo.Count; colNum++)
{
item.SubItems.Add(new ListViewItem.ListViewSubItem(item, row[colNum].Text));
}
listItems.Add(item);
}
}
View.SetData(listItems.ToArray());
}
private SQLQueryResult UpdateUserInfo(PharmacyDBContext appDBContext, object[] paramaters)
{
tblUser modifiedUser = paramaters[0] as tblUser;
string userNameBeforeChanged = paramaters[1] as string;
string imageFolder = paramaters[2] as string;
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblUsers.Where <tblUser>(user => user.Username.Equals(userNameBeforeChanged)).First();
x.FullName = modifiedUser.FullName;
x.Address = modifiedUser.Address;
x.Phone = modifiedUser.Phone;
x.Email = modifiedUser.Email;
x.Link = modifiedUser.Link;
x.Job = modifiedUser.Job;
x.Password = modifiedUser.Password;
x.UserDataJSON = modifiedUser.UserDataJSON;
if (!SaveImageToFile(userNameBeforeChanged, imageFolder, ImageType.User))
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
return(result);
}
appDBContext.SaveChanges();
result = new SQLQueryResult(x, MessageQueryResult.Done);
}
catch (DbEntityValidationException e)
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
HandleDbEntityValidationException(e);
}
catch (Exception e)
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
ShowErrorMessageBox(e);
}
return(result);
}
private SQLQueryResult CheckUserNameExisted(PharmacyDBContext appDBContext, object[] paramaters)
{
string name = paramaters[0].ToString();
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblUsers.Where(user => user.Username.Equals(name)).
ToList();
bool IsExisted = x.Count > 0;
result = new SQLQueryResult(IsExisted, MessageQueryResult.Done);
return(result);
}
catch (Exception e)
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
ShowErrorMessageBox(e);
}
return(null);
}
private SQLQueryResult SetPromoDeactive(PharmacyDBContext appDBContext, object[] paramaters)
{
int id = (int)paramaters[0];
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblPromoes.Where(o => o.PromoID == id).FirstOrDefault();
x.IsActive = false;
appDBContext.SaveChanges();
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 GetAllActiveCustomerOrdersCallback(SQLQueryResult queryResult)
{
if (queryResult.MesResult == MessageQueryResult.Done)
{
var list = queryResult.Result as IEnumerable <tblOrder>;
CustomerOrdersItemSource = new ObservableCollection <CustomerOrderOV>();
foreach (tblOrder order in list)
{
CustomerOrdersItemSource.Add(new CustomerOrderOV(order));
}
}
else
{
App.Current.ShowApplicationMessageBox("Lỗi load dữ liệu hóa đơn, vui lòng mở lại ứng dụng hoặc liên hệ CSKH để biết thêm thông tin!",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.Default,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Error,
OwnerWindow.MainScreen,
"Thông báo!");
}
}
private SQLQueryResult GetAllActiveCustomerOrdersByDateData(PharmacyDBContext appDBContext, object[] paramaters)
{
DateTime startDate = (DateTime)paramaters[0];
DateTime endDate = (DateTime)paramaters[1];
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblOrders.
Where <tblOrder>(order => order.IsActive && order.OrderTime >= startDate && order.OrderTime <= endDate).ToList();
result = new SQLQueryResult(x, MessageQueryResult.Done);
}
catch (Exception e)
{
ShowErrorMessageBox(e);
result = new SQLQueryResult(null, MessageQueryResult.Aborted, "Lỗi load dữ liệu hóa đơn!");
}
return(result);
}
private SQLQueryResult UpdateCustomerOrder(PharmacyDBContext appDBContext, object[] paramaters)
{
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
tblOrder customerOrder = paramaters[0] as tblOrder;
var orderDB = appDBContext.tblOrders.First(o => o.OrderID == customerOrder.OrderID);
if (orderDB != null)
{
orderDB.OrderTime = customerOrder.OrderTime;
orderDB.OrderDescription = customerOrder.OrderDescription;
orderDB.IncludeVAT = customerOrder.IncludeVAT;
orderDB.IsActive = customerOrder.IsActive;
orderDB.PurchasePrice = customerOrder.PurchasePrice;
orderDB.TotalPrice = customerOrder.TotalPrice;
orderDB.UserID = customerOrder.UserID;
orderDB.CustomerID = customerOrder.CustomerID;
orderDB.tblOrderDetails = customerOrder.tblOrderDetails;
appDBContext.SaveChanges();
result = new SQLQueryResult(orderDB, MessageQueryResult.Done, "Cập nhật thông tin hóa đơn thành công!");
}
else
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted, "Không tìm thấy hóa đơn khi cập nhật cơ sở dữ liệu!");
}
}
catch (DbEntityValidationException e)
{
HandleDbEntityValidationException(e);
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
}
catch (Exception e)
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
ShowErrorMessageBox(e);
}
return(result);
}
private void SQLQueryCallback(SQLQueryResult queryResult)
{
if (queryResult.MesResult == MessageQueryResult.Done)
{
App.Current.ShowApplicationMessageBox("Lưu thông tin khuyến mãi thành công",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.Default,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Success,
OwnerWindow.MainScreen,
"Thông báo!");
_doRefresh = true;
}
else
{
App.Current.ShowApplicationMessageBox("Lỗi lưu thông tin khuyến mãi. Vui lòng liên hệ CSKH để biết thêm thông tin!",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.Default,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Error,
OwnerWindow.MainScreen,
"Thông báo!");
}
DBMPViewModel.ButtonCommandOV.IsSaveButtonRunning = false;
}
private void SetDeactiveCustomerOrderQueryCallback(SQLQueryResult queryResult)
{
if (queryResult.MesResult == MessageQueryResult.Done)
{
App.Current.ShowApplicationMessageBox("Xóa hóa đơn thành công!",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.Default,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Success,
OwnerWindow.MainScreen,
"Thông báo!!");
IMPViewModel.CustomerOrdersItemSource.Remove(IMPViewModel.CurrentSelectedOrderOV);
}
else
{
App.Current.ShowApplicationMessageBox("Lỗi xóa hóa đơn!",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.Default,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Error,
OwnerWindow.MainScreen,
"Thông báo!!");
}
}
private SQLQueryResult SetMedicineDeactive(PharmacyDBContext appDBContext, object[] paramaters)
{
string id = paramaters[0].ToString();
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblMedicines.Where(user => user.MedicineID.Equals(id)).
First();
x.IsActive = false;
appDBContext.SaveChanges();
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 SQLQueryCallback(SQLQueryResult queryResult)
{
if (queryResult.MesResult == MessageQueryResult.Done)
{
App.Current.ShowApplicationMessageBox("Chỉnh sửa thông tin nhập kho thành công",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.Default,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Success,
OwnerWindow.MainScreen,
"Thông báo!");
}
else
{
App.Current.ShowApplicationMessageBox("Lỗi thêm thông tin nhập kho. Vui lòng liên hệ CSKH để biết thêm thông tin!",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.Default,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Error,
OwnerWindow.MainScreen,
"Thông báo!");
}
MWIPViewModel.ButtonCommandOV.IsAddWarehouseImportButtonRunning = false;
PageHost.UpdateCurrentPageSource(PageSource.WAREHOUSE_MANAGEMENT_PAGE);
}
private void SQLQueryCallback(SQLQueryResult queryResult)
{
if (queryResult.MesResult == MessageQueryResult.Done)
{
App.Current.ShowApplicationMessageBox("Thêm thanh toán thành công",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.Default,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Success,
OwnerWindow.MainScreen,
"Thông báo!");
}
else
{
App.Current.ShowApplicationMessageBox("Lỗi thêm thanh toán. Vui lòng liên hệ CSKH để biết thêm thông tin!",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.Default,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Error,
OwnerWindow.MainScreen,
"Thông báo!");
}
AOPPViewModel.ButtonCommandOV.IsSaveButtonRunning = false;
PageHost.UpdateCurrentPageSource(PageSource.OTHER_PAYMENT_MANAGEMENT_PAGE);
}
private SQLQueryResult SetCustomerDeactive(PharmacyDBContext appDBContext, object[] paramaters)
{
int cusID = Convert.ToInt32(paramaters[0]);
SQLQueryResult result = new SQLQueryResult(null, MessageQueryResult.Non);
try
{
var x = appDBContext.tblCustomers.Where(cus => cus.CustomerID == cusID).
First();
x.IsActive = false;
appDBContext.SaveChanges();
result = new SQLQueryResult(null, MessageQueryResult.Done);
return(result);
}
catch (Exception e)
{
result = new SQLQueryResult(null, MessageQueryResult.Aborted);
App.Current.ShowApplicationMessageBox(e.Message);
}
return(result);
}
