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