public async void ExecuteRefreshCommand() { try { LoadingMessage = "Please Wait, Checking pending KOT"; IsLoading = true; { var functionResponse = await TableDataAccess.GetTableAsync(); if (functionResponse.status == "ok") { var list = JsonConvert.DeserializeObject <List <TableDetail> >(functionResponse.result.ToString()); Helpers.Data.TableList = JsonConvert.DeserializeObject <List <TableDetail> >(functionResponse.result.ToString()); } else { Helpers.Data.TableList = new List <TableDetail>(); } IsLoading = false; if (Helpers.Data.TableList.Count > 0) { TableList = Helpers.Data.TableList.Where(x => x.IsPacked == true).ToList(); DivideTableView(TableList); } else { DependencyService.Get <IMessage>().ShortAlert("No Tables available."); } } } catch (Exception e) { DependencyService.Get <IMessage>().ShortAlert(e.Message); } }
public async void ExecuteTableBTCommand(string TableNo) { try { LoadingMessage = "Please Wait, Loading Table Data"; IsLoading = true; Helpers.Data.SelectedTable = TableList.Find(x => x.TableNo == TableNo); var functionResponse = await TableDataAccess.GetTableDetailsAsync(TableNo); if (functionResponse.status == "ok") { var result = JsonConvert.DeserializeObject <List <KOTProd> >(functionResponse.result.ToString()); Helpers.Data.OrderItemsList = result; if (Helpers.Data.OrderItemsList != null && Helpers.Data.OrderItemsList.Count > 0) { Helpers.Data.PAX = Helpers.Data.OrderItemsList[0].PAX; } else { Helpers.Data.PAX = "0"; } } IsLoading = false; await App.Current.MainPage.Navigation.PushAsync(new KOTProdTabbedPage()); } catch (Exception ex) { IsLoading = false; DependencyService.Get <IMessage>().ShortAlert(ex.Message); //await App.Current.MainPage.Navigation.PushAsync(new KOTProdTabbedPage()); } }
public List<ICatalogJob> GetAllCatalogJob(string organization) { string tableName = NameHelper.GetCatalogJobTableName(organization); tableName = TableDataAccess.ValidateTableName(tableName); TableDataAccess tableDataAccess = new TableDataAccess(TableClient); CloudTable table = tableDataAccess.GetTable(tableName); if (table == null) return null; TableQuery<CatalogEntity> query = new TableQuery<CatalogEntity>().Where(TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, organization)); query.TakeCount = 100; TableRequestOptions a = new TableRequestOptions(); OperationContext c = new OperationContext(); var queryResult = table.ExecuteQuery(query); List<ICatalogJob> result = new List<ICatalogJob>(queryResult.Count()); foreach (CatalogEntity entity in queryResult) { CatalogEntity.SetOtherByPartitionRowKeys(entity); result.Add(entity); } return result; }
public async void ExecuteRefreshCommand() { try { SelectedOrder = new KOTProd(); LoadingMessage = "Please Wait! Tables Loading..."; IsLoading = true; var functionResponse = await TableDataAccess.GetTableAsync(); if (functionResponse.status == "ok") { var list = JsonConvert.DeserializeObject <List <TableDetail> >(functionResponse.result.ToString()); Helpers.Data.TableList = JsonConvert.DeserializeObject <List <TableDetail> >(functionResponse.result.ToString()); } else { Helpers.Data.TableList = new List <TableDetail>(); IsLoading = false; DependencyService.Get <IMessage>().ShortAlert(functionResponse.Message); } LoadingMessage = "Please Wait! Order Items Loading..."; IsLoading = true; functionResponse = await TableDataAccess.GetAllKOTProdAsync(Helpers.Constants.User.UserName); if (functionResponse.status == "ok") { IsLoading = false; DependencyService.Get <IMessage>().ShortAlert("Order Items loaded successfully"); Helpers.Data.OrderItemsList = JsonConvert.DeserializeObject <List <KOTAppClassLibrary.Models.KOTProd> >(functionResponse.result.ToString()); IsTable = true; SelectedTable = new TableDetail() { TableNo = "All" }; PackedTableList = Helpers.Data.TableList.Where(x => x.IsPacked == true).ToList(); PackedTableList.Insert(0, new TableDetail() { TableNo = "All" }); PackedTableList = new List <TableDetail>(PackedTableList); DisplayList = new ObservableCollection <KOTProd>(FilterOrderList()); OrderItemsList = new ObservableCollection <KOTProd>(DisplayList); ItemsList = new List <string>(DisplayList.Select(x => x.ItemDesc).Distinct().ToList()); ItemsList.Insert(0, "All"); } else { IsLoading = false; DependencyService.Get <IMessage>().ShortAlert("Error loading orders:" + functionResponse.Message); } }catch (Exception ex) { IsLoading = false; DependencyService.Get <IMessage>().ShortAlert(ex.Message); } }
private async void ExecuteRemarksOkCommand(object obj) { try { LoadingMessage = "Please Wait, Loading Table Data"; IsLoading = true; Helpers.Data.SelectedTable = TableList.Find(x => x.TableNo == SelectedTableNo); var functionResponse = await TableDataAccess.CancelOrdersAsync(SelectedTableNo, Helpers.Constants.User.UserName, Remarks); if (functionResponse.ToLower() == "success") { DependencyService.Get <IMessage>().ShortAlert("Table order canceled successfully"); } else { DependencyService.Get <IMessage>().ShortAlert(functionResponse); } IsLoading = false; IsRemarks = false; Remarks = ""; ExecuteRefreshCommand(); }catch (Exception ex) { IsLoading = false; IsRemarks = false; DependencyService.Get <IMessage>().ShortAlert(ex.Message); } }
//Command Execution for New and Save KOT Button public async void ExecuteKOTCommand(string val) { try { var res = await App.Current.MainPage.DisplayAlert("Confirm", "Are you sure?", "Yes", "No"); if (res) { //New KOT if (val == "1") { await App.Current.MainPage.Navigation.PopAsync(); } //Save KOT else if (val == "2") { if (OrderItemsList == null || OrderItemsList.Count == 0) { DependencyService.Get <IMessage>().ShortAlert("No Order Items"); return; } var items = OrderItemsList; if (items != null) { KOTListTransfer KOTData = new KOTListTransfer(); KOTData.TABLENO = Helpers.Data.SelectedTable.TableNo; KOTData.TRNUSER = Helpers.Constants.User.UserName; KOTData.PAX = Helpers.Data.PAX; KOTData.KOTProdList = OrderItemsList.ToList(); LoadingMessage = "Please Wait! Saving KOT Items"; IsLoading = true; var result = await TableDataAccess.SaveKOTProdListAsync(KOTData); if (result == "Success") { DependencyService.Get <IMessage>().ShortAlert("Order Saved Successfully"); App.Current.MainPage = new NavigationPage(new HomePage()); } else { DependencyService.Get <IMessage>().ShortAlert(result); } IsLoading = false; } } } }catch (Exception ex) { DependencyService.Get <IMessage>().ShortAlert(ex.Message); } }
async Task RunLoadTablesAsync(string connectionString) { Task.Yield(); using (var cnn = new SqlConnection(connectionString)) { var da = new TableDataAccess(cnn); var tables = await da.LoadNonAuditTable(); BeginInvoke((Action <List <Table> >)PopulateTableList, tables); } }
async Task RunLoadDatabasesAsync(string connectionString) { Task.Yield(); using (var cnn = new SqlConnection(connectionString)) { var da = new TableDataAccess(cnn); var databases = await da.ListDatabases(); BeginInvoke((Action <List <string>, string>)PopulateDatabases, databases, await da.CurrentDatabase()); } }
public async void CommonForMemoAndTransfer(int index) { LoadingMessage = "Please Wait, Checking pending KOT"; IsLoading = true; var res = await TableDataAccess.CheckPendingKOTAsync(); if (res == "0") { var functionResponse = await TableDataAccess.GetTableAsync(); if (functionResponse.status == "ok") { var list = JsonConvert.DeserializeObject <List <TableDetail> >(functionResponse.result.ToString()); Helpers.Data.TableList = JsonConvert.DeserializeObject <List <TableDetail> >(functionResponse.result.ToString()); } else { Helpers.Data.TableList = new List <TableDetail>(); } IsLoading = false; if (Helpers.Data.TableList.Count > 0) { if (index == 1) { await App.Current.MainPage.Navigation.PushAsync(new ChooseTablePage()); } else if (index == 2) { await App.Current.MainPage.Navigation.PushAsync(new TableViewPage()); } else if (index == 3) { await App.Current.MainPage.Navigation.PushAsync(new TransferTablePage()); } } else { DependencyService.Get <IMessage>().ShortAlert("No Tables available."); } } else if (res == "1") { await App.Current.MainPage.DisplayAlert("KOT Pending", "Clear all the pending to start new KOT", "Ok"); } else { DependencyService.Get <IMessage>().ShortAlert("Cannot Connect to Server."); } IsLoading = false; }
public async void ExecuteTableBTCommand(string TableNo) { try { var res = await App.Current.MainPage.DisplayActionSheet("Select any options", "Cancel", "", "Merge", "Split", "Transfer"); SelectedTransferFrom.TableNo = TableNo; if (res == "Transfer") { SelectedTransferTo = new TableDetail(); IsTransfer = true; } else if (res == "Split") { LoadingMessage = "Loading.. Please wait!!"; IsLoading = true; Helpers.Data.SelectedTable = TableList.Find(x => x.TableNo == TableNo); var functionResponse = await TableDataAccess.GetTableDetailsAsync(TableNo); IsLoading = false; if (functionResponse.status == "ok") { var result = JsonConvert.DeserializeObject <List <KOTProd> >(functionResponse.result.ToString()); Helpers.Data.OrderItemsList = result; await App.Current.MainPage.Navigation.PushModalAsync(new TransferSplitPage()); } else { DependencyService.Get <IMessage>().ShortAlert(functionResponse.Message); } } else if (res == "Merge") { Helpers.Data.SelectedTable = SelectedTransferFrom; await App.Current.MainPage.Navigation.PushModalAsync(new MergeTablePage()); } } catch (Exception ex) { DependencyService.Get <IMessage>().ShortAlert(ex.Message); } }
public async void ExecuteRefreshCommand() { try { LoadingMessage = "Please Wait, Checking pending KOT"; IsLoading = true; // var res = await TableDataAccess.CheckPendingKOTAsync(); //if (res == "0") { var functionResponse = await TableDataAccess.GetTableAsync(); if (functionResponse.status == "ok") { var list = JsonConvert.DeserializeObject <List <TableDetail> >(functionResponse.result.ToString()); Helpers.Data.TableList = JsonConvert.DeserializeObject <List <TableDetail> >(functionResponse.result.ToString()); TableList = Helpers.Data.TableList; } else { Helpers.Data.TableList = new List <TableDetail>(); TableList = Helpers.Data.TableList; } IsLoading = false; if (Helpers.Data.TableList.Count > 0) { SetLayout(); ViewSelectedTable("All"); SelectedLayout = "All"; } else { DependencyService.Get <IMessage>().ShortAlert("No Tables available."); } } }catch (Exception ex) { IsLoading = false; DependencyService.Get <IMessage>().ShortAlert(ex.Message); } }
private async void ExecuteDispatchCommand() { try { var res = await App.Current.MainPage.DisplayAlert("Confirm", "Are you sure to Dispatch Order Items?", "Yes", "No"); if (res) { LoadingMessage = "Please Wait! Tables Loading..."; IsLoading = true; var item = SelectedOrder; if (item != null) { item.KitchenDispatch = 1; item.DispatchTime = DateTime.Today.ToLocalTime(); item.DispatchUser = Helpers.Constants.User.UserName; item.Remarks = Remarks; var result = await TableDataAccess.SaveKitchenDispatch(item); if (result == "success") { DependencyService.Get <IMessage>().ShortAlert("Order Items Dispatched successfully"); ExecuteRefreshCommand(); } else { DependencyService.Get <IMessage>().ShortAlert(result); } } Remarks = "Order Dispatched"; IsLoading = false; } }catch (Exception ex) { IsLoading = false; DependencyService.Get <IMessage>().ShortAlert(ex.Message); } }
public async void ExecuteTableBTCommand(string TableNo) { try { var res = await App.Current.MainPage.DisplayActionSheet("Select any options", "Cancel", "", "Cancel Order", "View PreBill"); SelectedTableNo = TableNo; if (res == "Cancel Order") { Remarks = ""; IsRemarks = true; } else if (res == "View PreBill") { LoadingMessage = "Please Wait, Loading Table Data"; IsLoading = true; Helpers.Data.SelectedTable = TableList.Find(x => x.TableNo == TableNo); var functionResponse = await TableDataAccess.GetPreBillAsync(TableNo); if (functionResponse.status == "ok") { var result = JsonConvert.DeserializeObject <BillMain>(functionResponse.result.ToString()); Helpers.Data.BillMain = result; } else { DependencyService.Get <IMessage>().ShortAlert(functionResponse.Message); } IsLoading = false; await App.Current.MainPage.Navigation.PushAsync(new PreBillPage()); } } catch (Exception e) { IsLoading = false; DependencyService.Get <IMessage>().ShortAlert(e.Message); //await App.Current.MainPage.Navigation.PushAsync(new PreBillPage()); } }
public ActionResult AddNewTable(Table table) { TableDataAccess.NewTable(table, 1); return(View("AddNew")); }
public Table() { tableDataAccess = new TableDataAccess(); }
public async void ExecuteSaveCommand() { try { if (((FirstQuantity + SecondQuantity) != SelectedOrder.Quantity) || FirstQuantity == 0 || SecondQuantity == 0) { IsLoading = false; DependencyService.Get <IMessage>().ShortAlert("Quantity Entry Incorrect.."); return; } var result = await App.Current.MainPage.DisplayAlert("Confirm", "Are you sure to save Split?", "Yes", "No"); if (result) { LoadingMessage = "Loading Please Wait!!!"; IsLoading = true; SplitList = new List <KOTProd>(); SplitList.Add(new KOTProd(SelectedOrder) { Quantity = FirstQuantity, Remarks = FirstRemarks }); SplitList.Add(new KOTProd(SelectedOrder) { Quantity = SecondQuantity, Remarks = SecondRemarks }); var items = Helpers.Data.OrderItemsList.Where(x => x.TABLENO == SelectedOrder.TABLENO && x.MCODE != SelectedOrder.MCODE).ToList(); SplitList.AddRange(items); SplitTransfer SplitTransfer = new SplitTransfer(); SplitTransfer = new SplitTransfer() { TableNo = SelectedOrder.TABLENO, transferData = SplitList, TRNUSER = Helpers.Constants.User.UserName }; SplitTransfer.transferData.ForEach(x => x.DispatchTime = null); SplitTransfer.transferData.ForEach(x => x.TRNDATE = null); var res = await TableTransferAccess.GetSplitTableAsync(SplitTransfer); if (res.ToLower() == "success") { DependencyService.Get <IMessage>().ShortAlert("Split Successful"); LoadingMessage = "Please Wait! Tables Loading..."; IsLoading = true; var functionResponse = await TableDataAccess.GetTableAsync(); if (functionResponse.status == "ok") { var list = JsonConvert.DeserializeObject <List <TableDetail> >(functionResponse.result.ToString()); Helpers.Data.TableList = JsonConvert.DeserializeObject <List <TableDetail> >(functionResponse.result.ToString()); } else { Helpers.Data.TableList = new List <TableDetail>(); IsLoading = false; DependencyService.Get <IMessage>().ShortAlert(functionResponse.Message); } LoadingMessage = "Please Wait! Order Items Loading..."; IsLoading = true; functionResponse = await TableDataAccess.GetAllKOTProdAsync(Helpers.Constants.User.UserName); if (functionResponse.status == "ok") { IsLoading = false; DependencyService.Get <IMessage>().ShortAlert("Order Items loaded successfully"); Helpers.Data.OrderItemsList = JsonConvert.DeserializeObject <List <KOTAppClassLibrary.Models.KOTProd> >(functionResponse.result.ToString()); } else { IsLoading = false; DependencyService.Get <IMessage>().ShortAlert("Error loading orders:" + functionResponse.Message); } await App.Current.MainPage.Navigation.PopModalAsync(); } else { DependencyService.Get <IMessage>().ShortAlert(res); } } } catch (Exception e) { IsLoading = false; DependencyService.Get <IMessage>().ShortAlert(e.Message); } }
public ActionResult Management() { ViewData["TableList"] = TableDataAccess.getListTableByStoreId(1); return(View("Management")); }
public async void ExecuteMenuCommand(string index) { try { LoadingMessage = "Please Wait, for a moment..."; IsLoading = true; if (index == "1") { CommonForMemoAndTransfer(1); } else if (index == "2") { CommonForMemoAndTransfer(2); } else if (index == "3") { CommonForMemoAndTransfer(3); } else if (index == "4") { LoadingMessage = "Please Wait! Tables Loading..."; IsLoading = true; var functionResponse = await TableDataAccess.GetTableAsync(); if (functionResponse.status == "ok") { //var list = JsonConvert.DeserializeObject<List<TableDetail>>(functionResponse.result.ToString()); Helpers.Data.TableList = JsonConvert.DeserializeObject <List <TableDetail> >(functionResponse.result.ToString()); } else { Helpers.Data.TableList = new List <TableDetail>(); IsLoading = false; DependencyService.Get <IMessage>().ShortAlert(functionResponse.Message); return; } LoadingMessage = "Please Wait! Order Items Loading..."; IsLoading = true; functionResponse = await TableDataAccess.GetAllKOTProdAsync(Helpers.Constants.User.UserName); if (functionResponse.status == "ok") { IsLoading = false; DependencyService.Get <IMessage>().ShortAlert("Order Items loaded successfully"); Helpers.Data.OrderItemsList = JsonConvert.DeserializeObject <List <KOTAppClassLibrary.Models.KOTProd> >(functionResponse.result.ToString()); await App.Current.MainPage.Navigation.PushAsync(new KitchenDispatchPage()); } else { DependencyService.Get <IMessage>().ShortAlert("Couldnot Load: " + functionResponse.Message); } IsLoading = false; } else if (index == "5") { var res = await App.Current.MainPage.DisplayAlert("Confirm", "Are you sure to Sync MenuItems?", "Yes", "No"); if (res) { LoadingMessage = "Please Wait, MenuItems Loading"; IsLoading = true; var functionResponse = await LoadMenuItem.GetMenuItemAsync(); if (functionResponse.status == "ok") { DependencyService.Get <IMessage>().ShortAlert("MenuItems synced successfully"); MenuItemsList = JsonConvert.DeserializeObject <List <KOTAppClassLibrary.Models.MenuItem> >(functionResponse.result.ToString()); Helpers.Data.MenuItemsList = MenuItemsList; MenuItemsAccess.SaveList(App.DatabaseLocation, MenuItemsList); } else { DependencyService.Get <IMessage>().ShortAlert("Couldnot sync: " + functionResponse.Message); } } IsLoading = false; } else if (index == "6") { var res = await App.Current.MainPage.DisplayAlert("Confirm", "Are you sure to log Out?", "Yes", "No"); if (res) { LoginUser.DeleteUserAndIP(App.DatabaseLocation); App.Current.MainPage = new LoginPage(); } } }catch (Exception e) { IsLoading = false; DependencyService.Get <IMessage>().ShortAlert("Error: " + e.Message); } }
public ActionResult UpdateTable(Table table) { TableDataAccess.UpdateTable(table); return(RedirectToAction("Management")); }