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