//MenuSessionMng mSession = new MenuSessionMng();
public bool PaymentExpress(string table, string counterCode)
{
localhost.Ordering or = new localhost.Ordering();
int salesPK = or.GetAnySalesPKFromTableName(counterCode, table);
or.AddExpressCashPayment(salesPK, counterCode, false, true);
return(true);
}
//private double GetTotalPayment(int iSalesPK, string iCounterCode)
//{
// string iRevenueCenterCode = "All";
// double iTotalPayment = 0;
// System.Data.Common.DbConnection conn = dc.Connection;
// if (conn.State == ConnectionState.Closed)
// {
// conn.Open();
// }
// System.Data.Common.DbCommand cmd;// = new System.Data.Common.DbCommand();
// string query = null;
// query = "SELECT SUM(CreditCardPaymentAmount) ";
// query = query + "FROM tblCreditCardPayment ";
// query = query + "WHERE SalesPK = ?SalesPK AND RevenueCenterCode = '" + iRevenueCenterCode + "' ";
// query = query + "GROUP BY SalesPK ";
// cmd = new System.Data.Common.DbCommand(query, conn);
// cmd.Parameters.Add("?SalesPK", iSalesPK);
// iTotalPayment = iTotalPayment + double.Parse( cmd.ExecuteScalar().ToString());
// query = "SELECT SUM(CashPaymentAmount) ";
// query = query + "FROM tblCashPayment ";
// query = query + "WHERE SalesPK = ?SalesPK AND RevenueCenterCode = '" + iRevenueCenterCode + "' ";
// query = query + "GROUP BY SalesPK ";
// cmd = new MySqlCommand(query, conn);
// cmd.Parameters.Add("?SalesPK", iSalesPK);
// iTotalPayment = iTotalPayment + double.Parse(cmd.ExecuteScalar().ToString()); ;
// query = "SELECT SUM(HouseChequeAndCreditPaymentAmount) ";
// query = query + "FROM tblHouseChequeAndCreditPayment ";
// query = query + "WHERE SalesPK = ?SalesPK AND RevenueCenterCode = '" + iRevenueCenterCode + "' ";
// query = query + "GROUP BY SalesPK ";
// cmd = new MySqlCommand(query, conn);
// cmd.Parameters.Add("?SalesPK", iSalesPK);
// iTotalPayment = iTotalPayment + double.Parse(cmd.ExecuteScalar().ToString());
// return Math.Round(iTotalPayment, 2);
//}
private void Payment(string tableID)
{
localhost.Ordering or = new localhost.Ordering();
hfRefresh.Value = "False";
try
{
string amount = or.GetUnsettledAmount(mSession.CounterCode, tableID);
if (!string.IsNullOrWhiteSpace(amount))
{
if (tools.PaymentExpress(tableID, mSession.CounterCode))
{
List <string> allAmount = amount.Split('|').ToList <string>();
allAmount = allAmount.Where(z => !string.IsNullOrWhiteSpace(z)).ToList <string>();
var q = (from i in allAmount
select new
{
Amount = i.Split(" : ".ToCharArray()).Where(z => !string.IsNullOrWhiteSpace(z)).ToList()[1],
}).ToList();
amount = q.Sum(i => double.Parse(i.Amount)).ToString();
lblMessage.Text = "Successfully paid RM " + String.Format("{0:00}", amount);;
//or.GetAnySalesPKFromTableName(mSession.CounterCode, tableID), mSession.CounterCode).ToString();
txtTableNumber.Visible = false;
btnConfirmTableNumber.Visible = false;
lTable.Visible = false;
mSession.DiscardSessions();
hfRefresh.Value = "True";
}
else
{
mSession.TableName = "";
lblMessage.Text = "Can not be paid.";
}
}
else
{
lblMessage.Text = "There is no order for table : " + mSession.TableName;
mSession.TableName = "";
}
}
catch (Exception ex)
{ lblMessage.Text = ex.Message; mSession.TableName = ""; }
}
private void SendToWS(string tableID)
{
localhost.Ordering or = new localhost.Ordering();
string iConflictMessage = "True";
try
{
iConflictMessage = or.CheckLicenseConflict_EMenu(mSession.CounterCode);
}
catch (Exception ex)
{
iConflictMessage = ex.ToString();// "Connection failed, Please try again.";
}
if (iConflictMessage != "True")
{
DiscardSessions();
lblMessage.Text = iConflictMessage;
}
else
{
string guid = Guid.NewGuid().ToString();
string counter = mSession.CounterCode;
string basketStr = ConvertBasketToString();
try
{
if (or.AddiPadOrder(basketStr, counter, mSession.EmployeeCode, tableID,
false, true, ConfigFile.PrintOrderList, ConfigFile.PrintKitchenOrderList, ConfigFile.PrintBarOrderList, false, false, false, guid, 0))
{
lblMessage.Text = "Successfully sent to the kitchen.";
DiscardSessions();
}
else
{
lblMessage.Text = "Order didn't send to the kitchen";
}
}
catch (Exception ex)
{ lblMessage.Text = ex.Message; }
}
}
private void PrintReceipt(string tableID)
{
localhost.Ordering or = new localhost.Ordering();
hfRefresh.Value = "False";
try
{
int salesPK = or.GetAnySalesPKFromTableName(mSession.CounterCode, tableID);
string revenue = or.GetRevenueCenterCode(mSession.CounterCode);
if (or.AddPrintJobToPool(salesPK.ToString(), revenue, true, false, false, "", "", "", ConfigFile.PrintOrderList, ConfigFile.PrintKitchenOrderList, ConfigFile.PrintBarOrderList))
{
lblMessage.Text = "Successfully printed.";
hfRefresh.Value = "True";
}
else
{
lblMessage.Text = "Order didn't send to the printer";
}
}
catch (Exception ex)
{ lblMessage.Text = ex.Message; }
}
//MenuSessionMng mSession = new MenuSessionMng();
public bool PaymentExpress(string table, string counterCode)
{
localhost.Ordering or = new localhost.Ordering();
int salesPK = or.GetAnySalesPKFromTableName(counterCode, table);
or.AddExpressCashPayment(salesPK, counterCode, false, true);
return true;
}
private void SendToWS(string tableID)
{
localhost.Ordering or = new localhost.Ordering();
string iConflictMessage = "True";
try
{
iConflictMessage = or.CheckLicenseConflict_EMenu(mSession.CounterCode);
}
catch (Exception ex)
{
iConflictMessage = ex.ToString();// "Connection failed, Please try again.";
}
if (iConflictMessage != "True")
{
DiscardSessions();
lblMessage.Text = iConflictMessage;
}
else
{
string guid = Guid.NewGuid().ToString();
string counter = mSession.CounterCode;
string basketStr = ConvertBasketToString();
try
{
if (or.AddiPadOrder(basketStr, counter, mSession.EmployeeCode, tableID,
false, true, ConfigFile.PrintOrderList, ConfigFile.PrintKitchenOrderList, ConfigFile.PrintBarOrderList, false, false, false, guid, 0))
{
lblMessage.Text = "Successfully sent to the kitchen.";
DiscardSessions();
}
else
{
lblMessage.Text = "Order didn't send to the kitchen";
}
}
catch (Exception ex)
{ lblMessage.Text = ex.Message; }
}
}
private void LoadOrder(string tableID)
{
localhost.Ordering or = new localhost.Ordering();
hfRefresh.Value = "True";
try
{
int salesPK = or.GetAnySalesPKFromTableName(mSession.CounterCode, tableID);
string orders = or.GetSalesItem(mSession.CounterCode, salesPK);
if (!string.IsNullOrEmpty(orders))
{
List <string> arrOrder = orders.Split("^".ToCharArray()).ToList();
arrOrder = arrOrder.Where(z => !string.IsNullOrEmpty(z)).ToList();
List <Order> all = new List <Order>();
foreach (string str in arrOrder)
{
try
{
string[] order = str.Split("|".ToCharArray());
string FbCode = order[2];
Tblfoodbeverage pr = dc.Tblfoodbeverages.First(z => z.Foodbeveragecode == FbCode);
Order o = new Order();
o.fbCode = order[2];
o.Description = order[4];
o.AltDescription = order[4];
o.Quantity = 1;// arrOrder.Where(i => i.Split("|".ToCharArray())[4] == o.Description).Count();
// o.Pic = ConfigFile.PicVisible ? pr.Foodbeveragepicture : null;
o.fbUnitPrice = double.Parse(order[5]);
o.OldOrder = true;
if (all.Where(i => i.Description == o.Description).Count() > 0)
{
all.First(i => i.Description == o.Description).Quantity++;
}
else
{
all.Add(o);
}
}
catch (Exception ex) { }
}
mSession.Basket = all;
mSession.ViewingBasket = true;
// dtr.Item("SalesPK").ToString & "|" & dtr.Item("SalesItemPK").ToString & "|" & _
//dtr.Item("FoodBeverageCode").ToString & "|" & dtr.Item("SalesItemDescription").ToString & "|" & _
//dtr.Item("SalesItemKitchenDescription").ToString & "|" & dtr.Item("Amount").ToString & "|"
//lblMessage.Text = "<script type='text/javascript'> Close() </script>";
lblMessage.Text = "Successfully loaded.";
lTable.Visible = false;
txtTableNumber.Visible = false;
btnConfirmTableNumber.Visible = false;
}
else
{
lblMessage.Text = "Order doesn't exist, Select another table.";
mSession.TableName = "";
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
mSession.TableName = "";
}
}
private void PrintReceipt(string tableID)
{
localhost.Ordering or = new localhost.Ordering();
hfRefresh.Value = "False";
try
{
int salesPK = or.GetAnySalesPKFromTableName(mSession.CounterCode, tableID);
string revenue = or.GetRevenueCenterCode(mSession.CounterCode);
if (or.AddPrintJobToPool(salesPK.ToString(), revenue, true, false, false, "", "", "", ConfigFile.PrintOrderList, ConfigFile.PrintKitchenOrderList, ConfigFile.PrintBarOrderList))
{
lblMessage.Text = "Successfully printed.";
hfRefresh.Value = "True";
}
else
{
lblMessage.Text = "Order didn't send to the printer";
}
}
catch (Exception ex)
{ lblMessage.Text = ex.Message; }
}
//private double GetTotalPayment(int iSalesPK, string iCounterCode)
//{
// string iRevenueCenterCode = "All";
// double iTotalPayment = 0;
// System.Data.Common.DbConnection conn = dc.Connection;
// if (conn.State == ConnectionState.Closed)
// {
// conn.Open();
// }
// System.Data.Common.DbCommand cmd;// = new System.Data.Common.DbCommand();
// string query = null;
// query = "SELECT SUM(CreditCardPaymentAmount) ";
// query = query + "FROM tblCreditCardPayment ";
// query = query + "WHERE SalesPK = ?SalesPK AND RevenueCenterCode = '" + iRevenueCenterCode + "' ";
// query = query + "GROUP BY SalesPK ";
// cmd = new System.Data.Common.DbCommand(query, conn);
// cmd.Parameters.Add("?SalesPK", iSalesPK);
// iTotalPayment = iTotalPayment + double.Parse( cmd.ExecuteScalar().ToString());
// query = "SELECT SUM(CashPaymentAmount) ";
// query = query + "FROM tblCashPayment ";
// query = query + "WHERE SalesPK = ?SalesPK AND RevenueCenterCode = '" + iRevenueCenterCode + "' ";
// query = query + "GROUP BY SalesPK ";
// cmd = new MySqlCommand(query, conn);
// cmd.Parameters.Add("?SalesPK", iSalesPK);
// iTotalPayment = iTotalPayment + double.Parse(cmd.ExecuteScalar().ToString()); ;
// query = "SELECT SUM(HouseChequeAndCreditPaymentAmount) ";
// query = query + "FROM tblHouseChequeAndCreditPayment ";
// query = query + "WHERE SalesPK = ?SalesPK AND RevenueCenterCode = '" + iRevenueCenterCode + "' ";
// query = query + "GROUP BY SalesPK ";
// cmd = new MySqlCommand(query, conn);
// cmd.Parameters.Add("?SalesPK", iSalesPK);
// iTotalPayment = iTotalPayment + double.Parse(cmd.ExecuteScalar().ToString());
// return Math.Round(iTotalPayment, 2);
//}
private void Payment(string tableID)
{
localhost.Ordering or = new localhost.Ordering();
hfRefresh.Value = "False";
try
{
string amount = or.GetUnsettledAmount(mSession.CounterCode, tableID);
if (!string.IsNullOrWhiteSpace(amount))
{
if (tools.PaymentExpress(tableID, mSession.CounterCode))
{
List<string> allAmount = amount.Split('|').ToList<string>();
allAmount = allAmount.Where(z => !string.IsNullOrWhiteSpace(z)).ToList<string>();
var q = (from i in allAmount
select new
{
Amount = i.Split(" : ".ToCharArray()).Where(z => !string.IsNullOrWhiteSpace(z)).ToList()[1],
}).ToList();
amount = q.Sum(i => double.Parse(i.Amount)).ToString();
lblMessage.Text = "Successfully paid RM " + String.Format("{0:00}", amount);;
//or.GetAnySalesPKFromTableName(mSession.CounterCode, tableID), mSession.CounterCode).ToString();
txtTableNumber.Visible = false;
btnConfirmTableNumber.Visible = false;
lTable.Visible = false;
mSession.DiscardSessions();
hfRefresh.Value = "True";
}
else
{
mSession.TableName = "";
lblMessage.Text = "Can not be paid.";
}
}
else
{
lblMessage.Text = "There is no order for table : " + mSession.TableName;
mSession.TableName = "";
}
}
catch (Exception ex)
{ lblMessage.Text = ex.Message; mSession.TableName = ""; }
}
private void LoadOrder(string tableID)
{
localhost.Ordering or = new localhost.Ordering();
hfRefresh.Value = "True";
try
{
int salesPK = or.GetAnySalesPKFromTableName(mSession.CounterCode, tableID);
string orders = or.GetSalesItem(mSession.CounterCode, salesPK);
if (!string.IsNullOrEmpty(orders))
{
List<string> arrOrder = orders.Split("^".ToCharArray()).ToList();
arrOrder = arrOrder.Where(z => !string.IsNullOrEmpty(z)).ToList();
List<Order> all = new List<Order>();
foreach (string str in arrOrder)
{
try
{
string[] order = str.Split("|".ToCharArray());
string FbCode = order[2];
Tblfoodbeverage pr = dc.Tblfoodbeverages.First(z => z.Foodbeveragecode == FbCode);
Order o = new Order();
o.fbCode = order[2];
o.Description = order[4];
o.AltDescription = order[4];
o.Quantity = 1;// arrOrder.Where(i => i.Split("|".ToCharArray())[4] == o.Description).Count();
// o.Pic = ConfigFile.PicVisible ? pr.Foodbeveragepicture : null;
o.fbUnitPrice = double.Parse(order[5]);
o.OldOrder = true;
if (all.Where(i => i.Description == o.Description).Count() > 0)
{
all.First(i => i.Description == o.Description).Quantity++;
}
else
all.Add(o);
}
catch (Exception ex) { }
}
mSession.Basket = all;
mSession.ViewingBasket = true;
// dtr.Item("SalesPK").ToString & "|" & dtr.Item("SalesItemPK").ToString & "|" & _
//dtr.Item("FoodBeverageCode").ToString & "|" & dtr.Item("SalesItemDescription").ToString & "|" & _
//dtr.Item("SalesItemKitchenDescription").ToString & "|" & dtr.Item("Amount").ToString & "|"
//lblMessage.Text = "<script type='text/javascript'> Close() </script>";
lblMessage.Text = "Successfully loaded.";
lTable.Visible = false;
txtTableNumber.Visible = false;
btnConfirmTableNumber.Visible = false;
}
else
{
lblMessage.Text = "Order doesn't exist, Select another table.";
mSession.TableName = "";
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
mSession.TableName = "";
}
}
