public CResult GetDrawerLogDetails(Int64 startTime, Int64 endTime)
{
CResult tempcResult = new CResult();
List<CPayment> paymentdetails = new List<CPayment>();
string sqlCommand = String.Format(SqlQueries.GetQuery(Query.DrawerLogdetails), startTime, endTime);
IDataReader oReader = this.ExecuteReader(sqlCommand);
if (oReader != null)
{
while (oReader.Read())
{
CPayment tempPayment = new CPayment();
if (oReader["terminal_id"] != null)
{
tempPayment.PcID = int.Parse(oReader["terminal_id"].ToString());
}
if (oReader["userid"] != null)
{
tempPayment.UserID = Convert.ToString(oReader["userid"]);
}
if (oReader["opentime"] != null)
{
Int64 dateTime = Convert.ToInt64(oReader["opentime"].ToString());
tempPayment.PaymentTime = new DateTime(dateTime);// Convert.ToDateTime(dateTime);
}
paymentdetails.Add(tempPayment);
}
}
tempcResult.Data = paymentdetails;
return tempcResult;
}
public CResult GetPaymentByOrderID(Int64 inPaymentID)
{
CPayment tempPayment = new CPayment();
try
{
m_oResult.Data = Database.Instance.Payment.GetPaymentByOrderID(inPaymentID);
m_oResult.IsSuccess = true;
m_oResult.Message = "Data Read Successfully";
}
catch (Exception ex)
{
System.Console.WriteLine("Exception occuer at GetPaymentByOrderID() : " + ex.Message);
m_oResult.IsException = true;
m_oResult.Action = EERRORNAME.EXCEPTION_OCCURE;
//m_oResult.SetParams(ex.Message);
m_oResult.Message = ex.Message;
Logger.Write("Exception : " + ex + " in GetPaymentByOrderID()", LogLevel.Error, "COrderManager");
}
return m_oResult;
}
public void DeletePayment(CPayment inPayment)
{
try
{
this.OpenConnection();
string sSql = string.Format(SqlQueries.GetQuery(Query.PaymentDelete),inPayment.PaymentID);
this.ExecuteNonQuery(sSql);
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in DeletePayment()", LogLevel.Error, "Database");
throw new Exception("Exception occure at DeletePayment()", ex);
}
finally
{
this.CloseConnection();
}
}
public CPayment GetPaymentByOrderID(Int64 inOrderID)
{
CPayment tempPayment= new CPayment();
try
{
this.OpenConnection();
string sSql = string.Format(SqlQueries.GetQuery(Query.PayementGetByOrderID), inOrderID);
IDataReader oReader = this.ExecuteReader(sSql);
if (oReader != null)
{
while (oReader.Read())
{
tempPayment= ReaderToPayment(oReader);
}
}
}
catch (Exception ex)
{
Console.Write("###" + ex + "###");
Logger.Write("Exception : " + ex + " in GetPaymentByOrderID()", LogLevel.Error, "Database");
if (ex.GetType().Equals(typeof(SqlException)))
{
SqlException oSQLEx = ex as SqlException;
if (oSQLEx.Number != 7619)
throw new Exception("Exception occure at GetPaymentByOrderID()", ex);
}
else
{
throw new Exception("Exception occure at GetPaymentByOrderID()", ex);
}
}
finally
{
this.CloseConnection();
}
return tempPayment;
}
CPayment ReaderToPayment(IDataReader inReader)
{
CPayment tempPayment = new CPayment();
if (inReader["payment_id"] != null)
{
tempPayment.PaymentID = Int64.Parse(inReader["payment_id"].ToString());
}
if (inReader["order_id"] != null)
{
tempPayment.OrderID = Int64.Parse(inReader["order_id"].ToString());
}
if (inReader["pc_id"] != null)
{
tempPayment.PcID = int.Parse(inReader["pc_id"].ToString());
}
if (inReader["total_amount"] != null)
{
tempPayment.TotalAmount =Double.Parse(inReader["total_amount"].ToString());
}
if (inReader["cash_amount"] != null)
{
tempPayment.CashAmount= Double.Parse(inReader["cash_amount"].ToString());
}
if (inReader["eft_amount"] != null)
{
tempPayment.EFTAmount= Double.Parse(inReader["eft_amount"].ToString());
}
if (inReader["cheque_amount"] != null)
{
tempPayment.ChequeAmount = Double.Parse(inReader["cheque_amount"].ToString());
}
if (inReader["voucher_amount"] != null)
{
tempPayment.VoucherAmount= Double.Parse(inReader["voucher_amount"].ToString());
}
if (inReader["service_amount"] != null)
{
tempPayment.ServiceAmount = Double.Parse(inReader["service_amount"].ToString());
}
if (inReader["discount"] != null)
{
tempPayment.Discount = Double.Parse(inReader["discount"].ToString());
}
if (inReader["account_pay"] != null)
{
tempPayment.AccountPay = Double.Parse(inReader["account_pay"].ToString());
}
if (inReader["deposit_id"] != null)
{
tempPayment.DepositID = Int64.Parse(inReader["deposit_id"].ToString());
}
if (inReader["deposit_amount"] != null)
{
tempPayment.DepositAmount= Double.Parse(inReader["deposit_amount"].ToString());
}
return tempPayment;
}
//Changed
public void UpdatePayment(CPayment inPayment)
{
try
{
this.OpenConnectionWithTransection();
string sSql = string.Format(SqlQueries.GetQuery(Query.PaymentUpdate),
inPayment.OrderID, inPayment.PcID, inPayment.TotalAmount, inPayment.CashAmount,
inPayment.EFTAmount, inPayment.ChequeAmount, inPayment.VoucherAmount, inPayment.ServiceAmount,
inPayment.Discount, inPayment.AccountPay,inPayment.DepositID,inPayment.DepositAmount, inPayment.PaymentID);
this.ExecuteNonQuery(sSql);
sSql = String.Format(SqlQueries.GetQuery(Query.GetOrderIDFromBillPrintTime), inPayment.OrderID);
IDataReader oReader = this.ExecuteReader(sSql);
if (oReader != null)
{
bool bIsRead2 = oReader.Read();
if (bIsRead2)
{
oReader.Close();
//sSql = String.Format(SqlQueries.GetQuery(Query.UpdateBillPrintTime), inPayment.BillPrintTime, inPayment.PaymentTime, inPayment.OrderID);
sSql = String.Format(SqlQueries.GetQuery(Query.UpdateBillPrintTime), inPayment.BillPrintTime.Ticks, inPayment.PaymentTime.Ticks, inPayment.OrderID);
this.ExecuteNonQuery(sSql);
}
else
{
oReader.Close();
//sSql = String.Format(SqlQueries.GetQuery(Query.InsertBillPrintTime), inPayment.OrderID, inPayment.BillPrintTime, inPayment.PaymentTime);
sSql = String.Format(SqlQueries.GetQuery(Query.InsertBillPrintTime), inPayment.OrderID, inPayment.BillPrintTime.Ticks, inPayment.PaymentTime.Ticks);
this.ExecuteNonQuery(sSql);
}
}
this.CommitTransection();
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in UpdatePayment()", LogLevel.Error, "Database");
// throw new Exception("Exception occure at UpdatePayment()", ex);
this.RollBackTransection();
}
finally
{
this.CloseConnection();
}
}
/// <summary>
/// Save Drawing Opening logs
/// </summary>
/// <param name="terminal_id"></param>
/// <param name="user_id"></param>
/// <param name="dateTime"></param>
/// <returns></returns>
public CPayment SaveDrawerLogs(Int32 terminal_id, string user_id, Int64 dateTime)
{
CPayment tempPayment = new CPayment();
string sqlCommand = String.Format(SqlQueries.GetQuery(Query.SaveDrawerOpening), user_id, dateTime, terminal_id);
this.ExecuteNonQuery(sqlCommand);
sqlCommand = SqlQueries.GetQuery(Query.ScopeIdentity);
IDataReader oReader = this.ExecuteReader(sqlCommand);
if (oReader != null)
{
bool bIsRead = oReader.Read();
if (bIsRead)
{
tempPayment.PaymentID = Int64.Parse(oReader[0].ToString());
}
oReader.Close();
}
return tempPayment;
}
//Changed
public CPayment InsertPayment(CPayment inPayment)
{
CPayment tempPayment = inPayment;
try
{
DateTime dtPayment = DateTime.Now;
dtPayment = new DateTime(dtPayment.Year, dtPayment.Month, dtPayment.Day, dtPayment.Hour, dtPayment.Minute, 0);
Int64 dateTime = dtPayment.Ticks;
CCommonConstants oConstant = ConfigManager.GetConfig<CCommonConstants>();
CUserInfo objUserInfo = oConstant.UserInfo;
this.OpenConnectionWithTransection();
string sSql = string.Format(SqlQueries.GetQuery(Query.PaymentInsert),
inPayment.OrderID,inPayment.PcID,inPayment.TotalAmount,inPayment.CashAmount,
inPayment.EFTAmount,inPayment.ChequeAmount,inPayment.VoucherAmount, inPayment.ServiceAmount,
inPayment.Discount, inPayment.AccountPay, inPayment.DepositID, inPayment.DepositAmount, "'" + objUserInfo.UserName + "'", dateTime);
this.ExecuteNonQuery(sSql);
sSql = SqlQueries.GetQuery(Query.ScopeIdentity);
IDataReader oReader = this.ExecuteReader(sSql);
if (oReader != null)
{
bool bIsRead = oReader.Read();
if (bIsRead)
{
tempPayment.PaymentID = Int64.Parse(oReader[0].ToString());
}
oReader.Close();
}
sSql = String.Format(SqlQueries.GetQuery(Query.GetOrderIDFromBillPrintTime), inPayment.OrderID);
oReader = this.ExecuteReader(sSql);
if (oReader != null)
{
bool bIsRead2 = oReader.Read();
if (bIsRead2)
{
oReader.Close();
//sSql = String.Format(SqlQueries.GetQuery(Query.UpdateBillPrintTime), inPayment.BillPrintTime, inPayment.PaymentTime, inPayment.OrderID);
sSql = String.Format(SqlQueries.GetQuery(Query.UpdateBillPrintTime), inPayment.BillPrintTime.Ticks, inPayment.PaymentTime.Ticks, inPayment.OrderID);
this.ExecuteNonQuery(sSql);
}
else
{
oReader.Close();
//sSql = String.Format(SqlQueries.GetQuery(Query.InsertBillPrintTime), inPayment.OrderID, inPayment.BillPrintTime, inPayment.PaymentTime);
sSql = String.Format(SqlQueries.GetQuery(Query.InsertBillPrintTime), inPayment.OrderID, inPayment.BillPrintTime.Ticks, inPayment.PaymentTime.Ticks);
this.ExecuteNonQuery(sSql);
}
}
this.CommitTransection();
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in InsertPayment()", LogLevel.Error, "Database");
// throw new Exception("Exception occure at InsertPayment()", ex);
this.RollBackTransection();
}
finally
{
this.CloseConnection();
}
return tempPayment;
}
public string UpdatePaymentForDueBill(CPayment aPayment, PaymentDueBill aPaymentDueBill)
{
string result = "";
try
{
this.OpenConnection();
string sSql = string.Format(SqlQueries.GetQuery(Query.UpdatePaymentForDueBill), aPayment.OrderID, aPayment.CashAmount, aPayment.EFTAmount, aPayment.ChequeAmount);
this.ExecuteNonQuery(sSql);
result = "Due Bill Payment Successfully";
int billid = CheckExistsDueBill(aPaymentDueBill);
if (billid > 0)
{
aPaymentDueBill.BillId = billid;
sSql = string.Format(SqlQueries.GetQuery(Query.UpdateTotalDueBillPayment), aPaymentDueBill.BillId, aPaymentDueBill.CashAmount, aPaymentDueBill.CardAmount, aPaymentDueBill.Cheque);
this.ExecuteNonQuery(sSql);
}
else
{
sSql = string.Format(SqlQueries.GetQuery(Query.InsertTotalDueBillPayment), aPaymentDueBill.CashAmount, aPaymentDueBill.CardAmount, aPaymentDueBill.Cheque, DateTime.Now.Date);
this.ExecuteNonQuery(sSql);
}
}
catch (Exception ex)
{
result = "Sorry Please Try again";
Logger.Write("Exception : " + ex + " in UpdatePaymentVatStat()", LogLevel.Error, "Database");
}
finally
{
this.CloseConnection();
}
return result;
}
private void UpdateCalculation(int paymentMethodIndex)
{
try
{
Double tempTotalPaid = 0.0;
Debug.WriteLine("UpdateCalc 1");
tempTotalPaid += Double.Parse(g_CashLabel.Text.Substring(Program.currency.Length)) + Double.Parse(g_EFTLabel.Text.Substring(Program.currency.Length)) + Double.Parse(g_ChequeLabel.Text.Substring(Program.currency.Length))
+ Double.Parse(g_AccountLabel.Text.Substring(Program.currency.Length)) + Double.Parse(complementorylabel.Text.Substring(Program.currency.Length));
Debug.WriteLine("UpdateCalc 2");
Double tempBillTotal = m_dTotalAmount + Convert.ToDouble("0" + g_ServiceChargeLabel.Text.Substring(Program.currency.Length));
Debug.WriteLine("UpdateCalc 3");
Double tempDifference = tempBillTotal - tempTotalPaid;
Debug.WriteLine("UpdateCalc 4");
if (tempDifference > 0)
{
m_dBalance = tempDifference;
g_BalaceLabel.Text = String.Format("Balance Due {0}" + m_dBalance.ToString("F02"), Program.currency);
Debug.WriteLine("UpdateCalc 5");
}
else
{
if (CurrentPaymentMethod.Equals("Cash"))
{
if (m_isAddServiceCharge == false)
{
g_CashLabel.Text = Program.currency + m_dBalance.ToString("F02");
}
}
else if (CurrentPaymentMethod.Equals("EFT"))
{
if (m_isAddServiceCharge == false)
{
g_EFTLabel.Text = Program.currency + m_dBalance.ToString("F02");
}
}
else if (CurrentPaymentMethod.Equals("Due"))
{
if (m_isAddServiceCharge == false)
{
g_ChequeLabel.Text = Program.currency + m_dBalance.ToString("F02");
}
}
else if (CurrentPaymentMethod.Equals("Voucher"))
{
if (m_isAddServiceCharge == false)
{
g_VoucherLabel.Text = Program.currency + m_dBalance.ToString("F02");
}
}
else if (CurrentPaymentMethod.Equals("Account"))
{
if (m_isAddServiceCharge == false)
{
g_AccountLabel.Text = Program.currency + m_dBalance.ToString("F02");
}
}
else if (CurrentPaymentMethod.Equals("Discount"))
{
g_DiscountLabel.Text = Program.currency + m_dBalance.ToString("F02");
}
else if (CurrentPaymentMethod.Equals("Deposit"))
{
g_DepositUsedLabel.Text = Program.currency + m_dBalance.ToString("F02");
}
else if (CurrentPaymentMethod.Equals("Complementory"))
{
if (m_isAddServiceCharge == false)
{
complementorylabel.Text = Program.currency + m_dBalance.ToString("F02");
}
}
Debug.WriteLine("UpdateCalc 6");
m_dBalance = -tempDifference;
g_BalaceLabel.Text = "Pay Back " + Program.currency + (m_dBalance-tipsamount).ToString("F02");
Debug.WriteLine("UpdateCalc 7");
CPaymentManager tempPaymentManager = new CPaymentManager();
/***********************/
/********New Print******/
/***********************/
if (isCheatManuallyhandled())
{
DialogResult dresult = MessageBox.Show("Make It Open?", "Message", MessageBoxButtons.YesNo);
if (dresult == DialogResult.Yes)
{
makeOpen = true;
}
if (dresult == DialogResult.No)
{
makeOpen = false;
}
}
DataSet tempDataSet = new DataSet();
tempDataSet.ReadXml("Config/Print_Config.xml");
if (tempDataSet.Tables[0].Rows[0]["PrintPaymentBill"].ToString().ToLower().Equals("true"))
{
Debug.WriteLine("UpdateCalc 17");
PrintPaymentBill(paymentMethodIndex);//Payment method index .Cash=1,EFT=2,Cheque=3
}
COrderManager temmpOrderManager = new COrderManager();
COrderDiscount tempOrderDiscount = new COrderDiscount();
CResult ooResult = temmpOrderManager.OrderDiscountGetByOrderID(m_iOrderID);
double itemDiscount = 0;
if (ooResult.IsSuccess && ooResult.Data != null)
{
tempOrderDiscount = (COrderDiscount) ooResult.Data;
itemDiscount = tempOrderDiscount.TotalItemDiscount;
}
//Check whether payment data exists
if (m_cPayment == null)
{
Debug.WriteLine("UpdateCalc 8");
///insert into payment table
CPayment tempPayment = new CPayment();
tempPayment.OrderID = m_iOrderID;
//get pc id from pc ip
CPcInfoManager tempPcInfoManager = new CPcInfoManager();
IPHostEntry ipEntry = System.Net.Dns.GetHostByName(Dns.GetHostName());
CPcInfo tempPcInfo = (CPcInfo)tempPcInfoManager.PcInfoByPcIP(ipEntry.AddressList[0].ToString()).Data;
tempPayment.PcID = tempPcInfo.PcID;
Debug.WriteLine("UpdateCalc 9");
tempPayment.TotalAmount = m_dTotalAmount;
tempPayment.CashAmount = Double.Parse(g_CashLabel.Text.Substring(Program.currency.Length));
tempPayment.EFTAmount = Double.Parse(g_EFTLabel.Text.Substring(Program.currency.Length));
tempPayment.ChequeAmount = Double.Parse(g_ChequeLabel.Text.Substring(Program.currency.Length));
tempPayment.ServiceAmount = m_serviceCharge_cash + m_serviceCharge_voucher + m_serviceCharge_eft + m_serviceCharge_cheque + m_serviceCharge_accounts - tipsamount; //Double.Parse(g_ServiceChargeLabel.Text.Substring(Program.currency.Length));
tempPayment.VoucherAmount = Double.Parse(complementorylabel.Text.Substring(Program.currency.Length));
tempPayment.Discount = Double.Parse(g_DiscountLabel.Text.Substring(Program.currency.Length));
tempPayment.AccountPay = Double.Parse(g_AccountLabel.Text.Substring(Program.currency.Length));
tempPayment.DepositID = m_oDeposit.DepositID;
tempPayment.DepositAmount = Double.Parse(g_DepositUsedLabel.Text.Substring(Program.currency.Length));
tempPayment.PaymentTime = System.DateTime.Now;
tempPayment.ServiceChargeCash = m_serviceCharge_cash;
tempPayment.ServiceChargeCheque = m_serviceCharge_cheque;
tempPayment.ServiceChargeEft = m_serviceCharge_eft;
tempPayment.ServiceChargeVoucher = m_serviceCharge_voucher;
tempPayment.ServiceChargeAcc = m_serviceCharge_accounts;
tempPayment.DueMessage = dueMessage;
tempPayment.ComplementoryMessage = complementoryMessage;
double totalCost = GetTotalCost(m_iOrderID);
tempPayment.TotalCost = totalCost;
tempPayment.TipsAmount = tipsamount;
tempPayment.VatImposed = Program.vat.ToString();
tempPayment.membershipDiscount = (double)membershipdiscount;
tempPayment.ItemDiscount = itemDiscount;
//tempPayment.VatImposed = Program.vat.ToString();
tempPayment.GuestBill = gusetBillStr;
COrderWaiterDao orderWaiterDao = new COrderWaiterDao(); // Change by Mithu
COrderwaiter orderWaiter = orderWaiterDao.GetOrderwaiterByOrderID(m_iOrderID); // Change by Mithu
try
{
tempPayment.Waiter = orderWaiter.WaiterName;
}
catch (Exception)
{
}
if (makeOpen)
tempPayment.Vat_stat = true;
else
tempPayment.Vat_stat = false;
tempPayment.PaymentPerson = RMSGlobal.LoginUserName;
DataSet tempStockDataSet = new DataSet();
tempStockDataSet.ReadXml("Config/StockSetting.xml");
bool isAllowedToOrder = Convert.ToBoolean(tempStockDataSet.Tables[0].Rows[0]["AllowedtoOrder"].ToString());
if (!isAllowedToOrder)
{
COrderDetailsDAO aDao = new COrderDetailsDAO();
List<COrderDetails> aList = new List<COrderDetails>();
double cost = 0.0;
try
{
aList = aDao.OrderDetailsGetAll();
var check = from list in aList where list.OrderID == tempPayment.OrderID select list;
SaleReportDAO aSaleReportDao = new SaleReportDAO();
aSaleReportDao.InsertOrUpdateSaleRawmaterialsReport(check);
}
catch
{
}
}
CResult oResult = tempPaymentManager.InsertPayment(tempPayment);
if (oResult.IsSuccess && oResult.Data != null)
{
tempPayment = (CPayment)oResult.Data;
m_cPayment = tempPayment;
Debug.WriteLine("UpdateCalc 10");
}
}
else
{
Debug.WriteLine("UpdateCalc 11");
//update payment table
CPayment tempPayment = new CPayment();
tempPayment.PaymentID = m_cPayment.PaymentID;
tempPayment.OrderID = m_iOrderID;
tempPayment.TotalAmount = m_dTotalAmount;
tempPayment.CashAmount = Double.Parse(g_CashLabel.Text.Substring(Program.currency.Length));
tempPayment.EFTAmount = Double.Parse(g_EFTLabel.Text.Substring(Program.currency.Length));
tempPayment.ChequeAmount = Double.Parse(g_ChequeLabel.Text.Substring(Program.currency.Length));
tempPayment.ServiceAmount = m_serviceCharge_cash + m_serviceCharge_voucher + m_serviceCharge_eft + m_serviceCharge_cheque + m_serviceCharge_accounts - tipsamount; //Double.Parse(g_ServiceChargeLabel.Text.Substring(Program.currency.Length));
tempPayment.VoucherAmount = Double.Parse(complementorylabel.Text.Substring(Program.currency.Length));
tempPayment.Discount = Double.Parse(g_DiscountLabel.Text.Substring(Program.currency.Length));
tempPayment.AccountPay = Double.Parse(g_AccountLabel.Text.Substring(Program.currency.Length));
tempPayment.DepositID = m_oDeposit.DepositID;
tempPayment.DepositAmount = Double.Parse(g_DepositUsedLabel.Text.Substring(Program.currency.Length));
tempPayment.PaymentTime = System.DateTime.Now;
tempPayment.ServiceChargeCash = m_serviceCharge_cash;
tempPayment.ServiceChargeCheque = m_serviceCharge_cheque;
tempPayment.ServiceChargeEft = m_serviceCharge_eft;
tempPayment.ServiceChargeVoucher = m_serviceCharge_voucher;
tempPayment.ServiceChargeAcc = m_serviceCharge_accounts;
tempPayment.VatImposed = Program.vat.ToString();
tempPayment.TipsAmount = tipsamount;
tempPayment.GuestBill = gusetBillStr;
tempPayment.membershipDiscount = (double)membershipdiscount;
tempPayment.ItemDiscount = itemDiscount;
//tempPayment.DueMessage = dueMessage;
//tempPayment.ComplementoryMessage = complementoryMessage;
if (isCheatManuallyhandled())
{
DialogResult dresult = MessageBox.Show("Make It Open?", "Message", MessageBoxButtons.YesNo);
if (dresult == DialogResult.Yes)
{
makeOpen = true;
}
if (dresult == DialogResult.No)
{
makeOpen = false;
}
}
if (makeOpen)
tempPayment.Vat_stat = true;
else
tempPayment.Vat_stat = false;
tempPayment.PaymentPerson = RMSGlobal.LoginUserName;
tempPaymentManager.UpdatePayment(tempPayment);
m_cPayment = tempPayment;
Debug.WriteLine("UpdateCalc 12");
}
//Update Deposit
CDepositManager tempDepositManager = new CDepositManager();
tempDepositManager.UpdateDeposit(m_oDeposit);
//opening cash drawer
try
{
CPrintMethods tempPrintMethods = new CPrintMethods();
tempPrintMethods.OpenDrawer();
#region "Tracking Area"
CCommonConstants m_oCommonConstants;
//Drawer Opening log
DateTime dtPayment = DateTime.Now;
dtPayment = new DateTime(dtPayment.Year, dtPayment.Month, dtPayment.Day, dtPayment.Hour, dtPayment.Minute, dtPayment.Second);
Int64 dateTime = dtPayment.Ticks;
m_oCommonConstants = ConfigManager.GetConfig<CCommonConstants>();
CUserInfo objUserInfo = m_oCommonConstants.UserInfo;
tempPaymentManager.SaveDrawerLogs(RMSGlobal.Terminal_Id, objUserInfo.UserName, dateTime);
#endregion
Debug.WriteLine("UpdateCalc 18");
}
catch (Exception eee)
{
Debug.WriteLine("UpdateCalc 19");
Debug.WriteLine(eee.ToString());
}
///Print Payment Bill
///
/* DataSet tempDataSet = new DataSet();
tempDataSet.ReadXml("Config/Print_Config.xml");
if (tempDataSet.Tables[0].Rows[0]["PrintPaymentBill"].ToString().ToLower().Equals("true"))
{
Debug.WriteLine("UpdateCalc 17");
PrintPaymentBill(paymentMethodIndex);//Payment method index .Cash=1,EFT=2,Cheque=3
}
*/
COrderManager tempOrderManager = new COrderManager();
COrderInfo tempOrderInfo = null;
if (m_orderUserName.Replace(" ", "").ToUpper() != "Web User".Replace(" ", "").ToUpper()) //If local orders are processed
{
tempOrderInfo = (COrderInfo)tempOrderManager.OrderInfoByOrderID(m_iOrderID).Data;
tempOrderManager.UpdateOrderInfo(tempOrderInfo);
Debug.WriteLine("UpdateCalc 13");
tempOrderManager.InsertOrderArchive(tempOrderInfo);
Debug.WriteLine("UpdateCalc 14");
tempOrderManager.InsertOrderDetailsArchive(tempOrderInfo);
Debug.WriteLine("UpdateCalc 15");
}
else //If online orders are processed
{
tempOrderInfo = (COrderInfo)tempOrderManager.OrderInfoByOrderID(m_iOrderID).Data;
tempOrderManager.InsertOnlineOrderArchive(tempOrderInfo);
Debug.WriteLine("Online orders archiving");
}
tempOrderManager.DeleteTableInfo(tempOrderInfo.TableNumber, m_sTableType);
Debug.WriteLine("UpdateCalc 16");
//insert voucher
tempOrderManager.InsertOrderVoucher(m_oOrderVoucher);
///back to main screen
///
CFormManager.Forms.Pop();
Form tempForm = CFormManager.Forms.Pop();
tempForm.Show();
this.Close();
}
g_BalaceLabel.ForeColor = Color.Red;
}
catch (Exception eee)
{
//MessageBox.Show(eee.ToString());
Debug.WriteLine("UpdateCalc catch");
Debug.WriteLine(eee.ToString());
}
}
// Change by Mithu
private void PrintA5GuestBillReport()
{
int papersize = 70;
StringPrintFormater strPrintFormatter = new StringPrintFormater(70);
string Cat1ID = String.Empty;
try
{
CPrintMethodsEXT tempPrintMethods = new CPrintMethodsEXT();
//CPrintMethods tempPrintMethods = new CPrintMethods();
int categoryID = 0;
//serial print
//string serialHeader = "IBACS RMS";
string serialHeader = "";
//string serialFooter = "Please Come Again";
string serialFooter = "";
List<CSerialPrintContent> serialBody = new List<CSerialPrintContent>();
CSerialPrintContent tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CenterTextWithWhiteSpace("GUEST BILL");
tempSerialPrintContent.Bold = true;
serialBody.Add(tempSerialPrintContent);
COrderManager tempOrderManager = new COrderManager();
COrderInfo tempOrderInfo = (COrderInfo)tempOrderManager.OrderInfoByOrderID(orderID).Data;
//string s=tempOrderInfo.
if (m_iType == m_cCommonConstants.TableType)
{
//Order ID line remove from report for requisting user
// Sajib Vai gathered user requirement
//Date : 13-02-2012
//tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "\r\n\nOrder ID:" + orderID.ToString();
//serialBody.Add(tempSerialPrintContent);
//tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "\r\n\nTable Number:" + tempOrderInfo.TableNumber.ToString();
//serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.ItemLabeledText("Table No: " + m_iTableNumber.ToString(), "") + "\r\n";
tempSerialPrintContent.Bold = true;
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = strPrintFormatter.ItemLabeledText("Guest No: " + tempOrderInfo.GuestCount.ToString(), "") + "\r\n";
tempSerialPrintContent.Bold = true;
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Print Date: " + System.DateTime.Now.ToString("dd/MM/yy hh:mm tt") + "\r\n";
serialBody.Add(tempSerialPrintContent);
//tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "Covers: " + tempOrderInfo.GuestCount.ToString() + "\r\n";
//tempSerialPrintContent.Bold = true;
//serialBody.Add(tempSerialPrintContent);
COrderWaiterDao orderWaiterDao = new COrderWaiterDao();
COrderwaiter orderWaiter = orderWaiterDao.GetOrderwaiterByOrderID(orderID);
if (orderWaiter != null && orderWaiter.WaiterID > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Waiter Name: " + orderWaiter.WaiterName + "\r\n";
//tempSerialPrintContent.Bold = true;
serialBody.Add(tempSerialPrintContent);
}
} // Change by Mithu
//private void PrintA5GuestBillReport() // Change by Mithu
//{
// int papersize = 70;
// StringPrintFormater strPrintFormatter = new StringPrintFormater(70);
// string Cat1ID = String.Empty;
// try
// {
// CPrintMethodsEXT tempPrintMethods = new CPrintMethodsEXT();
// //CPrintMethods tempPrintMethods = new CPrintMethods();
// int categoryID = 0;
// //serial print
// //string serialHeader = "IBACS RMS";
// string serialHeader = "";
// //string serialFooter = "Please Come Again";
// string serialFooter = "";
// List<CSerialPrintContent> serialBody = new List<CSerialPrintContent>();
// CSerialPrintContent tempSerialPrintContent = new CSerialPrintContent();
// //tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CenterTextWithWhiteSpace("Guest Bill");
// tempSerialPrintContent.Bold = true;
// serialBody.Add(tempSerialPrintContent);
// COrderManager tempOrderManager = new COrderManager();
// COrderInfo tempOrderInfo = (COrderInfo)tempOrderManager.OrderInfoByOrderID(orderID).Data;
// //string s=tempOrderInfo.
// if (m_iType == m_cCommonConstants.TableType)
// {
// tempSerialPrintContent = new CSerialPrintContent();
// //tempSerialPrintContent.StringLine = "\r\n\nOrder ID:" + orderID.ToString();
// serialBody.Add(tempSerialPrintContent);
// //tempSerialPrintContent = new CSerialPrintContent();
// //tempSerialPrintContent.StringLine = "\r\n\nTable Number:" + tempOrderInfo.TableNumber.ToString();
// //serialBody.Add(tempSerialPrintContent);
// tempSerialPrintContent = new CSerialPrintContent();
// //tempSerialPrintContent.StringLine = "\r\nPrint Date: " + System.DateTime.Now.ToString("dd/MM/yy hh:mm tt");
// serialBody.Add(tempSerialPrintContent);
// tempSerialPrintContent = new CSerialPrintContent();
// //tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.ItemLabeledText("Table No: " + m_iTableNumber.ToString(), "Covers: " + tempOrderInfo.GuestCount.ToString()) + "\r\n";
// tempSerialPrintContent.Bold = true;
// serialBody.Add(tempSerialPrintContent);
// //tempSerialPrintContent = new CSerialPrintContent();
// //tempSerialPrintContent.StringLine = "Covers: " + tempOrderInfo.GuestCount.ToString() + "\r\n";
// //tempSerialPrintContent.Bold = true;
// //serialBody.Add(tempSerialPrintContent);
// COrderWaiterDao orderWaiterDao = new COrderWaiterDao();
// COrderwaiter orderWaiter = orderWaiterDao.GetOrderwaiterByOrderID(orderID);
// if (orderWaiter != null && orderWaiter.WaiterID > 0)
// {
// tempSerialPrintContent = new CSerialPrintContent();
// tempSerialPrintContent.StringLine = "Waiter Name: " + orderWaiter.WaiterName + "\r\n";
// //tempSerialPrintContent.Bold = true;
// serialBody.Add(tempSerialPrintContent);
// }
// } // Change by Mithu
else if (m_iType == m_cCommonConstants.TakeAwayType)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nOrder Date: " + tempOrderInfo.OrderTime.ToString("dd/MM/yy hh:mm tt");
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nPrint Date: " + System.DateTime.Now.ToString("dd/MM/yy hh:mm tt");
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Type: " + tempOrderInfo.Status;
serialBody.Add(tempSerialPrintContent);
CCustomerManager tempCustomerManager = new CCustomerManager();
CCustomerInfo tempCustomerInfo = (CCustomerInfo)tempCustomerManager.CustomerInfoGetByCustomerID(tempOrderInfo.CustomerID).Data;
if (tempCustomerInfo.CustomerName.Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nCustomer Name: " + tempCustomerInfo.CustomerName;
serialBody.Add(tempSerialPrintContent);
}
if (tempCustomerInfo.CustomerPhone.Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nPhone:" + tempCustomerInfo.CustomerPhone;
serialBody.Add(tempSerialPrintContent);
}
if (tempOrderInfo.Status.Equals("Delivery"))
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nAddress:";
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
if (tempCustomerInfo.FloorAptNumber.Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Floor or Apartment:" + tempCustomerInfo.FloorAptNumber;
serialBody.Add(tempSerialPrintContent);
}
if (tempCustomerInfo.BuildingName.Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Building Name:" + tempCustomerInfo.BuildingName;
serialBody.Add(tempSerialPrintContent);
}
if (tempCustomerInfo.HouseNumber.Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "House Number:" + tempCustomerInfo.HouseNumber;
serialBody.Add(tempSerialPrintContent);
}
string[] street = new string[0];
street = tempCustomerInfo.StreetName.Split('-');
if (street.Length > 1)
{
if (street[0].ToString().Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Street:" + street[0].ToString();
serialBody.Add(tempSerialPrintContent);
}
if (street[1].ToString().Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = street[1].ToString();
serialBody.Add(tempSerialPrintContent);
}
}
else if (street.Length > 0 && street.Length < 2)
{
if (street[0].ToString().Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Street:" + street[0].ToString();
serialBody.Add(tempSerialPrintContent);
}
}
if (tempCustomerInfo.CustomerPostalCode.Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Postal Code:" + tempCustomerInfo.CustomerPostalCode;
serialBody.Add(tempSerialPrintContent);
}
if (tempCustomerInfo.CustomerTown.Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Town:" + tempCustomerInfo.CustomerTown;
serialBody.Add(tempSerialPrintContent);
}
//tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "Country:" + tempCustomerInfo.CustomerCountry;
//serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
//
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
CDelivery objDelivery = new CDelivery();
objDelivery.DeliveryOrderID = orderID;
CResult objDeliveryInfo = tempOrderManager.GetDeliveryInfo(objDelivery);
objDelivery = (CDelivery)objDeliveryInfo.Data;
if (objDelivery != null)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nDelivery Time:" + objDelivery.DeliveryTime;
serialBody.Add(tempSerialPrintContent);
}
}
}
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CenterTextWithWhiteSpace("Order Information");
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.ItemLabeledText("Item", "Qnty Unit Price Price(" + Program.currency + ")");
serialBody.Add(tempSerialPrintContent);
//Line after above line
//tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "----------------------------------------";
//serialBody.Add(tempSerialPrintContent);
#region Populate List
if (m_orderUserName.Replace(" ", "").ToUpper() != "Web User".Replace(" ", "").ToUpper())
{
Hashtable htOrderedItems = new Hashtable();
SortedList slorderedItems = null;
string categoryOrder = String.Empty;
int internalCategoryID = 0;
//Modification By Baruri at 04/08/2008
for (int rowIndex = 0; rowIndex < g_FoodDataGridView.Rows.Count; rowIndex++)
{
internalCategoryID = 0;
string cat3ID = String.Empty;
string cat2ID = String.Empty;
string cat1ID = String.Empty;
DataGridViewRow tempRow = g_FoodDataGridView.Rows[rowIndex];
categoryOrder = String.Empty;
if (!tempRow.Cells[0].Value.ToString().Equals(""))
{
#region "Parent Category"
if (Convert.ToInt32("0" + tempRow.Cells[4].Value.ToString()) == 3)//Item from Category 3
{
internalCategoryID = Convert.ToInt32("0" + tempRow.Cells[3].Value.ToString());
DataRow[] dtRow = dsCategory3.Tables[0].Select("cat3_id = " + internalCategoryID);
if (dtRow.Length > 0)
{
cat2ID = dtRow[0]["cat2_id"].ToString();
DataRow[] dtRowCat2 = dsCategory2.Tables[0].Select("cat2_id = " + cat2ID);//new
cat1ID = dtRowCat2[0]["cat1_id"].ToString();
}
}
else if (Convert.ToInt32("0" + tempRow.Cells[4].Value.ToString()) == 0)
{
cat1ID = "0";
cat2ID = "0";
}
else
{
internalCategoryID = Convert.ToInt32("0" + tempRow.Cells[3].Value.ToString());
DataRow[] dtRow = dsCategory4.Tables[0].Select("cat4_id = " + internalCategoryID);
if (dtRow.Length > 0)
{
cat3ID = dtRow[0]["cat3_id"].ToString();
if (cat3ID != "" || cat3ID != null)
{
dtRow = dsCategory3.Tables[0].Select("cat3_id = " + cat3ID);
}
else
{
dtRow = null;
}
}
if (dtRow.Length > 0)
{
cat2ID = dtRow[0]["cat2_id"].ToString();
DataRow[] dtRowCat2 = dsCategory2.Tables[0].Select("cat2_id = " + cat2ID);//new
cat1ID = dtRowCat2[0]["cat1_id"].ToString();
}
}
#endregion
clsOrderReport objOrderedItems = new clsOrderReport();
objOrderedItems.Quantity = Convert.ToInt32("0" + tempRow.Cells[1].Value.ToString());
objOrderedItems.ItemName = tempRow.Cells[0].Value.ToString();
objOrderedItems.Price = Convert.ToDouble("0" + tempRow.Cells[2].Value.ToString());
objOrderedItems.ItemUnitPrice = Convert.ToDouble("0" + tempRow.Cells[8].Value.ToString());
//htOrderedItems.Add(cat2ID + "-" + objOrderedItems.ItemName, objOrderedItems);//Showing the products according to categpry 2
Int64 rankNumber = Int64.Parse(tempRow.Cells[5].Value.ToString());
Int32 category1OrderNumber = this.GetCategory1OrderNumber(Convert.ToInt32(cat1ID));
htOrderedItems.Add(category1OrderNumber + "-" + rankNumber + "-" + objOrderedItems.ItemName, objOrderedItems);//Category 1 wise separator
}
}
#endregion
NumericComparer nc = new NumericComparer();
slorderedItems = new SortedList(htOrderedItems, nc);
int keyIndex = 0;
string[] valueSplitter = new string[0];
SortedList slMiscellaneousItems = new SortedList(); //Only for miscellenious category
PrintUtility printUtility = new PrintUtility();
foreach (clsOrderReport objReport in slorderedItems.Values)
{
string keyValue = slorderedItems.GetKey(keyIndex).ToString();
valueSplitter = keyValue.Split('-');
string priceString = printUtility.PupulateRightString(objReport.Quantity, objReport.ItemUnitPrice, objReport.Price);//objReport.Quantity.ToString() + " " + objReport.ItemUnitPrice.ToString("f2") + " " + objReport.Price.ToString("F02");
if ((categoryID != Convert.ToInt32("0" + valueSplitter[0].ToString())) && Convert.ToInt32("0" + valueSplitter[0].ToString()) != 0)//Insert separator
{
categoryID = Convert.ToInt32("0" + valueSplitter[0].ToString());
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine() + "\r\n";
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine +=
// strPrintFormatter.ItemLabeledText(objReport.Quantity.ToString() + " " +
// printUtility.MultipleLine(objReport.ItemName.ToString(), papersize - 10, objReport.Price.ToString("F02"), papersize - 5), "");
tempSerialPrintContent.StringLine +=
strPrintFormatter.ItemLabeledText(
printUtility.MultipleLine(objReport.ItemName.ToString(), papersize - 32, priceString, papersize ), "");
serialBody.Add(tempSerialPrintContent);
}
else if (valueSplitter[0].ToString() == "0") //Used for miscellenious items. i.e these items have no parent category.
{
tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine +=
// strPrintFormatter.ItemLabeledText(objReport.Quantity.ToString() + " " +
// printUtility.MultipleLine(objReport.ItemName.ToString(), papersize - 10, objReport.Price.ToString("F02"), papersize - 5), "");
tempSerialPrintContent.StringLine +=
strPrintFormatter.ItemLabeledText(
printUtility.MultipleLine(objReport.ItemName.ToString(), papersize - 32, priceString, papersize ), "");
slMiscellaneousItems.Add(slMiscellaneousItems.Count, tempSerialPrintContent);
}
else
{
tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine +=
// strPrintFormatter.ItemLabeledText(objReport.Quantity.ToString() + " " +
// printUtility.MultipleLine(objReport.ItemName.ToString(), papersize - 10, objReport.Price.ToString("F02"), papersize - 5), "");
tempSerialPrintContent.StringLine +=
strPrintFormatter.ItemLabeledText(
printUtility.MultipleLine(objReport.ItemName.ToString(), papersize - 32, priceString, papersize), "");
serialBody.Add(tempSerialPrintContent);
}
keyIndex++;
}
//Add the miscellaneous items with the separator
if (slMiscellaneousItems.Count > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CenterTextWithDashed("Miscellaneous") + "\r\n";
serialBody.Add(tempSerialPrintContent);
foreach (CSerialPrintContent tempSerialContent in slMiscellaneousItems.Values)
{
serialBody.Add(tempSerialContent);
}
}
for (int rowIndex = 0; rowIndex < g_BeverageDataGridView.Rows.Count; rowIndex++)
{
DataGridViewRow tempRow = g_BeverageDataGridView.Rows[rowIndex];
if (rowIndex == 0 && (!tempRow.Cells[0].Value.ToString().Equals("")))
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CenterTextWithDashed("Drinks") + "\r\n";
serialBody.Add(tempSerialPrintContent);
}
if (!tempRow.Cells[0].Value.ToString().Equals(""))
{
tempSerialPrintContent = new CSerialPrintContent();
// string priceString1 = tempRow.Cells[1].Value.ToString() + " " + tempRow.Cells[8].Value.ToString() + " " + tempRow.Cells[2].Value.ToString();
string priceString = printUtility.PupulateRightString(Convert.ToInt32("0" + tempRow.Cells[1].Value.ToString()), Convert.ToDouble("0"+tempRow.Cells[8].Value.ToString()), Convert.ToDouble("0"+tempRow.Cells[2].Value.ToString()));//objReport.Quantity.ToString() + " " + objReport.ItemUnitPrice.ToString("f2") + " " + objReport.Price.ToString("F02");
// string priceString = tempRow.Cells[1].Value.ToString() + " " + tempRow.Cells[8].Value.ToString() + " " + tempRow.Cells[2].Value.ToString();
//tempSerialPrintContent.StringLine +=
// strPrintFormatter.ItemLabeledText(tempRow.Cells[1].Value.ToString() + " " +
// printUtility.MultipleLine(tempRow.Cells[0].Value.ToString(), papersize - 10, tempRow.Cells[2].Value.ToString(), papersize - 5), "");
tempSerialPrintContent.StringLine +=
strPrintFormatter.ItemLabeledText(
printUtility.MultipleLine(tempRow.Cells[0].Value.ToString(), papersize - 32, priceString, papersize ), "");
serialBody.Add(tempSerialPrintContent);
}
}
}
else
{
//For online orders
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
for (int rowIndex = 0; rowIndex < g_FoodDataGridView.RowCount; rowIndex++)
{
if (Convert.ToInt32("0" + g_FoodDataGridView.Rows[rowIndex].Cells[1].Value) > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine += "\r\n" + strPrintFormatter.ItemLabeledText(g_FoodDataGridView.Rows[rowIndex].Cells[1].Value.ToString() + " " +
(g_FoodDataGridView.Rows[rowIndex].Cells[0].Value.ToString()), (Convert.ToDouble("0" + g_FoodDataGridView.Rows[rowIndex].Cells[2].Value).ToString("F02")));
serialBody.Add(tempSerialPrintContent);
}
}
for (int rowIndex = 0; rowIndex < g_BeverageDataGridView.RowCount; rowIndex++)
{
if (Convert.ToInt32("0" + g_BeverageDataGridView.Rows[rowIndex].Cells[1].Value) > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine += strPrintFormatter.ItemLabeledText(g_BeverageDataGridView.Rows[rowIndex].Cells[1].Value.ToString() + " " +
(g_BeverageDataGridView.Rows[rowIndex].Cells[0].Value.ToString()), (Convert.ToDouble("0" + g_BeverageDataGridView.Rows[rowIndex].Cells[2].Value).ToString("F02")));
serialBody.Add(tempSerialPrintContent);
}
}
}
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
decimal discountAmount = decimal.Parse(g_DiscountLabel.Text);
Decimal totalAmount = Decimal.Parse(g_AmountLabel.Text);
Decimal billTotal = discountAmount + totalAmount;
//New at 02.03.2009
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.SumupLabeledText("Order Total: ", GetOrderTotal().ToString("F02"));
serialBody.Add(tempSerialPrintContent);
if (discountAmount > 0)
{
decimal itemCost = this.GetOrderTotal();
tempSerialPrintContent = new CSerialPrintContent();
decimal discountPercent = 100 * discountAmount / (itemCost); //Discount is based on the total item cost
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.SumupLabeledText("Discount:(" + discountPercent.ToString("F02") + "%) ", Convert.ToDecimal(g_DiscountLabel.Text).ToString("F02"));
serialBody.Add(tempSerialPrintContent);
}
if (Convert.ToDouble("0" + g_serviceCharge.Text) > 0) //If service charge is assigned
{
CResult cResult = tempOrderManager.OrderServiceChargeGetByOrderID(orderID);
ServiceCharge serviceCharge = cResult.Data as ServiceCharge;
tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = " Service Charge: " + Convert.ToDecimal("0" + g_serviceCharge.Text).ToString("F02");
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.SumupLabeledText("Service Charge(" + serviceCharge.ServicechargeRate.ToString() + "%): ", Convert.ToDecimal("0" + g_serviceCharge.Text).ToString("F02"));
serialBody.Add(tempSerialPrintContent);
}
if (isVatEnabled) //If vat is assigned
{
tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = " Vat("+vat.ToString()+"%): " + Convert.ToDecimal("0" + lblVat.Text).ToString("F02");
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.SumupLabeledText("Vat(" + vat.ToString() + "%): ", Convert.ToDecimal("0" + lblVat.Text).ToString("F02"));
serialBody.Add(tempSerialPrintContent);
}
tempSerialPrintContent = new CSerialPrintContent();
// tempSerialPrintContent.StringLine = "----------------------------------------";
tempSerialPrintContent.StringLine += "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
decimal payableAmount = Convert.ToDecimal(Convert.ToDecimal("0" + g_serviceCharge.Text).ToString("F02")) + Convert.ToDecimal(this.GetOrderTotal()) - Convert.ToDecimal(Convert.ToDecimal("0" + g_DiscountLabel.Text).ToString("F02"));
payableAmount = Convert.ToDecimal(Convert.ToDouble(payableAmount) * (1 + vat / 100));
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.SumupLabeledText("Total Payable: ", Convert.ToDecimal("0" + g_AmountLabel.Text).ToString("F02"));
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
// tempSerialPrintContent.StringLine = "----------------------------------------";
tempSerialPrintContent.StringLine += "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
//New at 22.08.2008
tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "You've Served by :" + m_OperatorName;
tempSerialPrintContent.StringLine = "\r\nYou've Served by:" + m_OperatorName;
serialBody.Add(tempSerialPrintContent);
//Terminal Name and Serial No line remove from report for requisting user
// Sajib Vai gathered user requirement
//Date : 13-02-2012
//tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "\r\n" + m_TerminalName.Trim();
//serialBody.Add(tempSerialPrintContent);
////------------------------
//tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "\r\nS/N: " + tempOrderInfo.SerialNo.ToString() + "\n";
//serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "----------------------------------------";
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
//tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "\r\nDeveloped By: www.ibacs.co.uk";
//serialBody.Add(tempSerialPrintContent);
#region "Testing printing area"
string printingObject = "";
for (int arrayIndex = 0; arrayIndex < serialBody.Count; arrayIndex++)
{
printingObject += serialBody[arrayIndex].StringLine.ToString();
}
this.WriteString(printingObject);///Write to a file when print command is executed
#endregion
// tempPrintMethods.SerialPrint(PRINTER_TYPES.NORMAL_PRINTER, serialHeader, serialBody, serialFooter, tempOrderInfo.SerialNo.ToString());
tempPrintMethods.USBPrintA5Report(printingObject, PrintDestiNation.CLIENT, true, papersize);
///Update status
///
if (tempOrderInfo.OrderType.Equals("Table"))
{
tempOrderInfo.Status = "Billed";
tempOrderInfo.OrderTime = System.DateTime.Now;
tempOrderManager.UpdateOrderInfo(tempOrderInfo);
CPaymentManager tempPaymentManager = new CPaymentManager();
CPayment tempPayment = new CPayment();
tempPayment.OrderID = tempOrderInfo.OrderID;
tempPayment.BillPrintTime = DateTime.Now;
tempPaymentManager.InsertBillPrintTime(tempPayment);
}
this.ChangeGuestBillPrintStatus();
}
catch (Exception exp)
{
MessageBox.Show(exp.Message, RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void duebillPaymentButton_Click(object sender, EventArgs e)
{
if (tempSearchOrderInfo.DueBill > 0)
{
DueBillPaymentForm aDueBillPaymentForm = new DueBillPaymentForm();
aDueBillPaymentForm.ShowDialog();
double amount = 0.0;
if (DueBillPaymentForm.inputResult.Equals("Cancel"))
return;
string amt = DueBillPaymentForm.inputResult.Substring(Program.currency.Length);
if (Convert.ToDouble(amt) == 0.00)
{
CMessageBox tempMessageBox = new CMessageBox("Error!", "Price cannot be zero.");
tempMessageBox.ShowDialog();
return;
}
amount = Convert.ToDouble(amt);
string paymentmethod = "";
string cardName = "";
PaymentMethod aPaymentMethod = new PaymentMethod();
aPaymentMethod.ShowDialog();
paymentmethod = PaymentMethod.inputResult;
if (paymentmethod == "Card")
{
EFTOptionForm eFTOptionForm = new EFTOptionForm();
DialogResult dr = eFTOptionForm.ShowDialog();
if (dr == DialogResult.Cancel)
return;
saveEFTCardAgainsOrderid(EFTOptionForm.seletedEFTCard);
}
PaymentDueBill aPaymentDueBill = new PaymentDueBill();
CPayment aPayment = new CPayment();
aPayment.OrderID = orderID;
double tempamount = 0;
if (amount - tempSearchOrderInfo.DueBill >= 0)
{
tempamount = tempSearchOrderInfo.DueBill;
}
else if (tempSearchOrderInfo.DueBill - amount > 0)
{
tempamount = amount;
}
if (paymentmethod == "Cash")
{
aPayment.CashAmount = tempamount;
aPayment.EFTAmount = 0;
aPaymentDueBill.CashAmount = tempamount;
}
else if (paymentmethod == "Card")
{
aPayment.EFTAmount = tempamount;
aPayment.CashAmount = 0;
aPaymentDueBill.CardAmount = tempamount;
}
aPayment.ChequeAmount = tempSearchOrderInfo.DueBill - tempamount;
aPaymentDueBill.PaymentDate = DateTime.Now;
CPaymentDAO aPaymentDao = new CPaymentDAO();
string sr = aPaymentDao.UpdatePaymentForDueBill(aPayment, aPaymentDueBill);
MessageBox.Show(sr);
this.Close();
}
else
{
MessageBox.Show("Due Bill Must be greater than zero");
}
}
private void g_PrintGuestBillButton_Click(object sender, EventArgs e)
{
try
{
/*if (m_dtItemList.Rows.Count > 0)
{
//PrintBill(m_dtItemList);
}*/
if (m_dtItemList != null)
{
if (m_dtSecondList.Rows.Count > 0)
{
PrintBill(m_dtSecondList);
g_PrintBill2ListBox.Items.Clear();
SecondSpiltItems.Clear();
return ;
}
}
///Update status
///
COrderManager tempOrderManager = new COrderManager();
COrderInfo tempOrderInfo = (COrderInfo)tempOrderManager.OrderInfoByOrderID(m_iOrderID).Data;
if (tempOrderInfo.OrderType.Equals("Table"))
{
tempOrderInfo.Status = "Billed";
tempOrderInfo.OrderTime = System.DateTime.Now;
tempOrderManager.UpdateOrderInfo(tempOrderInfo);
CPaymentManager tempPaymentManager = new CPaymentManager();
CPayment tempPayment = new CPayment();
tempPayment.OrderID = tempOrderInfo.OrderID;
tempPayment.BillPrintTime = DateTime.Now;
tempPaymentManager.InsertBillPrintTime(tempPayment);
}
}
catch (Exception exp)
{
throw exp;
}
}
private void g_CashButton_Click(object sender, EventArgs e)
{
try
{
Double tempTotal = Double.Parse(g_BalanceLabel.Text);
Double tempInput = Double.Parse(g_InputTextBox.Text.Substring(1));
if (tempTotal > tempInput)
{
CMessageBox tempMessageBox = new CMessageBox("Error", "Paid Amount less than Balance Amount.");
tempMessageBox.ShowDialog();
return;
}
CPaymentManager tempPaymentManager = new CPaymentManager();
///insert into payment table
CPayment tempPayment = new CPayment();
tempPayment.OrderID = orderID;
//get pc id from pc ip
CPcInfoManager tempPcInfoManager = new CPcInfoManager();
IPHostEntry ipEntry = System.Net.Dns.GetHostByName(Dns.GetHostName());
CResult oResult = tempPcInfoManager.PcInfoByPcIP(ipEntry.AddressList[0].ToString());
CPcInfo tempPcInfo = new CPcInfo();
if (oResult.IsSuccess && oResult.Data != null)
{
tempPcInfo = (CPcInfo)oResult.Data;
}
tempPayment.PcID = tempPcInfo.PcID;
tempPayment.TotalAmount = Double.Parse(g_BalanceLabel.Text);
tempPayment.CashAmount = tempPayment.TotalAmount;
tempPayment.PaymentTime = System.DateTime.Now;
oResult = tempPaymentManager.InsertPayment(tempPayment);
if (oResult.IsSuccess && oResult.Data != null)
{
tempPayment = (CPayment)oResult.Data;
}
////update order info status
COrderManager tempOrderManager = new COrderManager();
COrderInfo tempOrderInfo = (COrderInfo)tempOrderManager.OrderInfoByOrderID(orderID).Data;
//tempOrderInfo.Status = "Paid";
//tempOrderManager.UpdateOrderInfo(tempOrderInfo);
//opening cash drawer
try
{
CPrintMethods tempPrintMethods = new CPrintMethods();
tempPrintMethods.OpenDrawer();
}
catch (Exception eee)
{
}
//archiving
tempOrderManager.InsertOrderArchive(tempOrderInfo);
tempOrderManager.InsertOrderDetailsArchive(tempOrderInfo);
tempOrderManager.DeleteTableInfo(tempOrderInfo.TableNumber, "Tabs");
Reload();
}
catch (Exception eee)
{
}
}
/***************************Print Guest Bill*********************/
private void g_PrintGuestBillButton_Click(object sender, EventArgs e)
{
bool isPrintA5GuestBill = false;
if (isPrintA5GuestBill)
{
PrintA5GuestBillReport(1);
}
else
{
StringPrintFormater strPrintFormatter = new StringPrintFormater(37);
int printsize = 37;
Hashtable htOrderedItems = new Hashtable();
SortedList slOrderedItems = null;
string cat1ID = String.Empty;
try
{
CPrintMethodsEXT tempPrintMethods = new CPrintMethodsEXT();
//string serialHeader = "IBACS RMS";
string serialHeader = "";
//string serialFooter = "Please Come Again";
string serialFooter = "";
string serialBody = "";
//serialBody += "\r\n Guest Bill";
serialBody += strPrintFormatter.CenterTextWithWhiteSpace("Bill Payment");
COrderManager tempOrderManager = new COrderManager();
COrderInfo tempOrderInfo = (COrderInfo)tempOrderManager.OrderInfoByOrderID(m_iOrderID).Data;
if (m_sTableType.Equals("Table"))
{
serialBody += "\r\n\nTable Number:" + tempOrderInfo.TableNumber.ToString();
serialBody += "\r\n\nCovers:" + tempOrderInfo.GuestCount.ToString();
serialBody += "\r\nDate: " + System.DateTime.Now.ToString("dd/MM/yy hh:mm tt");
COrderWaiterDao orderWaiterDao = new COrderWaiterDao();
COrderwaiter orderWaiter = orderWaiterDao.GetOrderwaiterByOrderID(m_iOrderID);
if (orderWaiter != null && orderWaiter.WaiterID > 0)
{
serialBody += "\r\nWaiter Name: " + orderWaiter.WaiterName + "\r\n";
}
}
else if (m_sTableType.Equals("TakeAway"))
{
serialBody += "\r\n\nTake Away" + " Date: " + System.DateTime.Now.ToString("dd/MM/yy");
CCustomerManager tempCustomerManager = new CCustomerManager();
CCustomerInfo tempCustomerInfo = (CCustomerInfo)tempCustomerManager.CustomerInfoGetByCustomerID(tempOrderInfo.CustomerID).Data;
COrderWaiterDao orderWaiterDao = new COrderWaiterDao();
COrderwaiter orderWaiter = orderWaiterDao.GetOrderwaiterByOrderID(m_iOrderID);
if (orderWaiter != null && orderWaiter.WaiterID > 0)
{
serialBody += "\r\nWaiter Name: " + orderWaiter.WaiterName + "\r\n";
}
if (tempCustomerInfo.CustomerName.Length > 0)
{
serialBody += "\r\nCustomer Name: " + tempCustomerInfo.CustomerName;
}
if (tempCustomerInfo.CustomerPhone.Length > 0)
{
serialBody += "\r\nPhone:" + tempCustomerInfo.CustomerPhone;
}
serialBody += "\r\nType: " + tempOrderInfo.Status;
if (tempOrderInfo.Status.Equals("Delivery"))
{
serialBody += "\r\nAddress:";
//serialBody += "\r\n----------------------------------------";
serialBody += "\r\n" + strPrintFormatter.CreateDashedLine();
if (tempCustomerInfo.FloorAptNumber.Length > 0)
{
serialBody += "\r\nFloor or Apartment:" + tempCustomerInfo.FloorAptNumber;
}
if (tempCustomerInfo.BuildingName.Length > 0)
{
serialBody += "\r\nBuilding Name:" + tempCustomerInfo.BuildingName;
}
if (tempCustomerInfo.HouseNumber.Length > 0)
{
serialBody += "\r\nHouse Number:" + tempCustomerInfo.HouseNumber;
}
string[] street = new string[0];
street = tempCustomerInfo.StreetName.Split('-');
if (street.Length > 1)
{
if (street[0].ToString().Length > 0)
{
serialBody += "\r\nStreet:" + street[0].ToString();
}
if (street[1].ToString().Length > 0)
{
serialBody += "\r\n" + street[1].ToString();
}
}
else if (street.Length > 0 && street.Length < 2)
{
if (street[0].ToString().Length > 0)
{
serialBody += "\r\nStreet:" + street[0].ToString();
}
}
if (tempCustomerInfo.CustomerPostalCode.Length > 0)
{
serialBody += "\r\nPostal Code:" + tempCustomerInfo.CustomerPostalCode;
}
if (tempCustomerInfo.CustomerTown.Length > 0)
{
serialBody += "\r\nTown:" + tempCustomerInfo.CustomerTown;
}
//serialBody += "\r\n----------------------------------------";
serialBody += "\r\n" + strPrintFormatter.CreateDashedLine();
CDelivery objDelivery = new CDelivery();
objDelivery.DeliveryOrderID = m_iOrderID;
CResult objDeliveryInfo = tempOrderManager.GetDeliveryInfo(objDelivery);
objDelivery = (CDelivery)objDeliveryInfo.Data;
serialBody += "\r\nDelivery Time:" + objDelivery.DeliveryTime;
}
}
else if (m_sTableType.Equals("Tabs"))
{
serialBody += "\r\n\nBar Service" + " Date: " + System.DateTime.Now.ToString("dd/MM/yy");
if (tempOrderInfo.TableNumber != 0)
{
serialBody += "\r\nTab Number: " + tempOrderInfo.TableNumber.ToString();
serialBody += "\r\nGuest Number: " + tempOrderInfo.GuestCount.ToString();
}
}
serialBody += "\r\n\nOrder Information";
serialBody += "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody += "\r\n" + strPrintFormatter.ItemLabeledText("Qty Item", "Price(" + Program.currency + ")");
#region "Local Orders"
if (m_orderUserName.Replace(" ", "").ToUpper() != "Web User".Replace(" ", "").ToUpper())
{
string cat2ID = "";
string cat3ID = "";
Int32 internalCategoryID = 0;
Int32 categoryID = 0;
m_itemCost = 0.0;
string categoryOrder = String.Empty;
for (int rowIndex = 0; rowIndex < m_dtItemList.Rows.Count; rowIndex++)
{
#region "Parent Category"
DataRow tempRow = m_dtItemList.Rows[rowIndex];
categoryOrder = String.Empty;
if (Convert.ToInt32("0" + tempRow["Catlevel"].ToString()) == 3)//Item from Category 3
{
internalCategoryID = Convert.ToInt32("0" + tempRow["Catid"].ToString());
DataRow[] dtRow = dsCategory3.Tables[0].Select("cat3_id = " + internalCategoryID);
if (dtRow.Length > 0)
{
cat2ID = dtRow[0]["cat2_id"].ToString();
DataRow[] dtRowCat2 = dsCategory2.Tables[0].Select("cat2_id = " + cat2ID);//new
cat1ID = dtRowCat2[0]["cat1_id"].ToString();
}
}
else if (Convert.ToInt32("0" + tempRow["Catlevel"].ToString()) == 0) //If miscellenious items are added
{
cat1ID = "0";
cat2ID = "0";
}
else
{
internalCategoryID = Convert.ToInt32("0" + tempRow["Catid"].ToString());
DataRow[] dtRow = dsCategory4.Tables[0].Select("cat4_id = " + internalCategoryID);
if (dtRow.Length > 0)
{
cat3ID = dtRow[0]["cat3_id"].ToString();
if (cat3ID != "" || cat3ID != null)
{
dtRow = dsCategory3.Tables[0].Select("cat3_id = " + cat3ID);
}
else
{
dtRow = null;
}
}
if (dtRow.Length > 0)
{
cat2ID = dtRow[0]["cat2_id"].ToString();
DataRow[] dtRowCat2 = dsCategory2.Tables[0].Select("cat2_id = " + cat2ID);//new
cat1ID = dtRowCat2[0]["cat1_id"].ToString();
}
}
#endregion
clsOrderReport objOrderedReport = new clsOrderReport();
objOrderedReport.Quantity = Convert.ToInt32("0" + tempRow["Qty"].ToString());
objOrderedReport.ItemName = tempRow["Item"].ToString();
objOrderedReport.Price = Convert.ToDouble("0" + tempRow["Price"].ToString());
int drinkValue = Convert.ToInt32("0" + tempRow["isdrink"].ToString());
if (drinkValue > 0)
{
objOrderedReport.DrinkStatus = true;
}
else
{
objOrderedReport.DrinkStatus = false;
}
Int64 rankNumber = Int64.Parse(tempRow["rank"].ToString());
Int32 category1OrderNumber = this.GetCategory1OrderNumber(Convert.ToInt32(cat1ID));
htOrderedItems.Add(category1OrderNumber + "-" + rankNumber + "-" + objOrderedReport.ItemName, objOrderedReport);
m_itemCost += Convert.ToDouble("0" + tempRow["Price"].ToString());
}
NumericComparer nc = new NumericComparer();
slOrderedItems = new SortedList(htOrderedItems, nc);
int keyIndex = 0;
string[] valueSplitter = new string[0];
SortedList slDrinkItems = new SortedList();
SortedList slMiscellaneousItems = new SortedList();
PrintUtility printUtility = new PrintUtility();
foreach (clsOrderReport objOrderedItems in slOrderedItems.Values)
{
string keyValue = slOrderedItems.GetKey(keyIndex).ToString();
valueSplitter = keyValue.Split('-');
if (objOrderedItems.DrinkStatus == true) //To make all drink items consecutively
{
slDrinkItems.Add(slDrinkItems.Count, objOrderedItems);
}
else if ((categoryID != Convert.ToInt32("0" + valueSplitter[0].ToString())) && (Convert.ToInt32("0" + valueSplitter[0].ToString()) != 0)) //All the items except drinks.
{
categoryID = Convert.ToInt32("0" + valueSplitter[0].ToString());
serialBody += "\r\n" + strPrintFormatter.CreateDashedLine() + "\r\n"; //Add the separator.
serialBody += strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " " +
printUtility.MultipleLine(objOrderedItems.ItemName.ToString(), printsize - 7, objOrderedItems.Price.ToString("F02"), printsize - 3), "");
}
else if (valueSplitter[0].ToString() == "0")
{
slMiscellaneousItems.Add(slMiscellaneousItems.Count, objOrderedItems);//add miscellaneous items in the collection
}
else
{
serialBody += strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " " +
printUtility.MultipleLine(objOrderedItems.ItemName.ToString(), printsize - 10, objOrderedItems.Price.ToString("F02"), printsize - 5), "");
}
keyIndex++;
}
//Add miscellaneous items only
if (slMiscellaneousItems.Count > 0)
{
//serialBody += "\r\n--------------Miscellaneous-------------"; //Add the separator.
serialBody += "\r\n" + strPrintFormatter.CenterTextWithDashed("Miscellaneous");
serialBody += "\r\n" + strPrintFormatter.CreateDashedLine() + "\r\n";
foreach (clsOrderReport objOrderedItems in slMiscellaneousItems.Values)
{
/* serialBody += "\r\n" + objOrderedItems.Quantity.ToString() + " ";
serialBody += CPrintMethods.GetFixedString(objOrderedItems.ItemName.ToString(), 23);
serialBody += CPrintMethods.RightAlign(objOrderedItems.Price.ToString("F02"), 6);*/
serialBody += strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " " +
printUtility.MultipleLine(objOrderedItems.ItemName.ToString(), printsize - 10, objOrderedItems.Price.ToString("F02"), printsize - 5), "");
}
}
//Add drinks only
if (slDrinkItems.Count > 0)
{
// serialBody += "\r\n-----------------Drinks-----------------"; //Add the separator.
serialBody += "\r\n" + strPrintFormatter.CenterTextWithDashed("Drinks") + "\r\n";
foreach (clsOrderReport objOrderedItems in slDrinkItems.Values)
{
/*serialBody += "\r\n" + objOrderedItems.Quantity.ToString() + " ";
serialBody += CPrintMethods.GetFixedString(objOrderedItems.ItemName.ToString(), 23);
serialBody += CPrintMethods.RightAlign(objOrderedItems.Price.ToString("F02"), 6);*/
serialBody += strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " " +
printUtility.MultipleLine(objOrderedItems.ItemName.ToString(), printsize - 10, objOrderedItems.Price.ToString("F02"), printsize - 5), "");
}
}
//serialBody += "\r\n----------------------------------------";
serialBody += "\r\n" + strPrintFormatter.CreateDashedLine();
Double discountAmount = Convert.ToDouble(Double.Parse(g_DiscountLabel.Text.Substring(Program.currency.Length)).ToString("F02"));
//Double billTotal = (discountAmount + m_dTotalAmount);
//serialBody += "\r\n Order Total: " + CPrintMethods.RightAlign(billTotal.ToString("F02"), 6);
//serialBody += "\r\n Order Total: " + CPrintMethods.RightAlign(m_itemCost.ToString("F02"), 6);//Item cost of the ordered products
serialBody += "\r\n" + strPrintFormatter.SumupLabeledText("Order Total: ", m_itemCost.ToString("F02"));
//if (discountAmount > 0)
//{
// Double totalAmount = m_dTotalAmount;
// Double discountPercent = 100 * discountAmount / (discountAmount + totalAmount);
// serialBody += "\r\n Discount:(" + discountPercent.ToString("F02") + "%) " + CPrintMethods.RightAlign(g_DiscountLabel.Text.Substring(Program.currency.Length), 6);
//}
if (discountAmount > 0)
{
Double totalAmount = m_dTotalAmount;
Double discountPercent = 100 * discountAmount / (m_itemCost); //Discount percentage of the selected products
// serialBody += "\r\n Discount:(" + discountPercent.ToString("F02") + "%) " + CPrintMethods.RightAlign(Convert.ToDouble(g_DiscountLabel.Text.Substring(Program.currency.Length)).ToString("F02"), 6);
serialBody += "\r\n" + strPrintFormatter.SumupLabeledText("Discount:(" + discountPercent.ToString("F02") + "%) ", Convert.ToDouble(g_DiscountLabel.Text.Substring(Program.currency.Length)).ToString("F02"));
}
if (Convert.ToDouble("0" + g_ServiceChargeLabel.Text.Substring(Program.currency.Length)) > 0) //If service charge is assigned
{
string tempstring = Convert.ToDouble("0" + g_ServiceChargeLabel.Text.Substring(Program.currency.Length)).ToString("F02");
serialBody += "\r\n" + strPrintFormatter.SumupLabeledText("Service Charge: ", tempstring);
}
//double payableAmount = Convert.ToDouble(Convert.ToDouble("0" + g_ServiceChargeLabel.Text.Substring(Program.currency.Length)).ToString("F02")) + m_dTotalAmount;
double payableAmount = Convert.ToDouble(Convert.ToDouble("0" + g_ServiceChargeLabel.Text.Substring(Program.currency.Length)).ToString("F02")) + (m_itemCost - discountAmount);
//double pvat = (payableAmount * (vat / 100));
payableAmount = payableAmount + Convert.ToDouble("0" + lblVat.Text.Substring(Program.currency.Length));
if (isVatEnabled) //If service charge is assigned
{
//serialBody += "\r\n Vat("+vat.ToString()+"%): " + CPrintMethods.RightAlign(pvat.ToString("F02"), 6);
// serialBody += "\r\n" + strPrintFormatter.SumupLabeledText("Vat(" + vat + "%): ", pvat.ToString("F02"));
serialBody += "\r\n" + strPrintFormatter.SumupLabeledText("Vat(" + vat + "%): ", Convert.ToDouble("0" + lblVat.Text.Substring(Program.currency.Length)).ToString("F02"));
}
serialBody += "\r\n" + strPrintFormatter.CreateDashedLine();
//serialBody += "\r\n Total Payable: " + CPrintMethods.RightAlign(payableAmount.ToString("F02"), 6);
serialBody += "\r\n" + strPrintFormatter.SumupLabeledText("Total Payable: ", payableAmount.ToString("F02"));
//if (Convert.ToDouble("0" + g_ServiceChargeLabel.Text.Substring(Program.currency.Length)) == 0) //If service charge is not assigned
//{
// //serialBody += "\r\n Tips/Service Charge: ______";
// serialBody += "\r\n" + strPrintFormatter.SumupLabeledText("Service Charge:", " ______");
//}
//serialBody += "\r\n----------------------------------------";
serialBody += "\r\n" + strPrintFormatter.CreateDashedLine();
if (m_bEqualSplit)
{
serialBody += "\r\n" + g_SplitAmountLabel.Text;
}
serialBody += "\r\nYou've Served by:" + m_OperatorName;
serialBody += "\r\n" + m_TerminalName.Trim();
serialBody += "\r\nS/N: " + tempOrderInfo.SerialNo.ToString() + "\n";
serialBody += strPrintFormatter.CreateDashedLine();
// serialBody += "\r\nDeveloped By: www.ibacs.co.uk";
this.WriteString(serialBody);
//tempPrintMethods.SerialPrint(PRINTER_TYPES.NORMAL_PRINTER, serialHeader, serialBody, serialFooter, tempOrderInfo.SerialNo.ToString());
tempPrintMethods.USBPrint(serialBody, PrintDestiNation.CLIENT, true);
///Update status
///
if (tempOrderInfo.OrderType.Equals("Table"))
{
tempOrderInfo.Status = "Billed";
tempOrderInfo.OrderTime = System.DateTime.Now;
tempOrderManager.UpdateOrderInfo(tempOrderInfo);
CPaymentManager tempPaymentManager = new CPaymentManager();
CPayment tempPayment = new CPayment();
tempPayment.OrderID = tempOrderInfo.OrderID;
tempPayment.BillPrintTime = DateTime.Now;
tempPaymentManager.InsertBillPrintTime(tempPayment);
}
// tempPrintMethods.SerialPrint(PRINTER_TYPES.NORMAL_PRINTER, serialHeader, serialBody, serialFooter, tempOrderInfo.SerialNo.ToString());
if (m_bEqualSplit)
{
tempPrintMethods.SerialPrint(PRINTER_TYPES.NORMAL_PRINTER, serialHeader, serialBody, serialFooter, tempOrderInfo.SerialNo.ToString());
}
}
#endregion
#region "Online orders"
else //For online order information .Added by Baruri
{
serialBody += "\r\n----------------------------------------";
for (int rowIndex = 0; rowIndex < m_dtItemList.Rows.Count; rowIndex++)
{
DataRow tempRow = m_dtItemList.Rows[rowIndex];
serialBody += "\r\n" + Convert.ToInt32("0" + tempRow["Qty"]).ToString() + " ";
serialBody += CPrintMethods.GetFixedString(tempRow["Item"].ToString(), 23);
serialBody += CPrintMethods.RightAlign(Convert.ToDouble("0" + tempRow["Price"]).ToString("F02"), 6);
}
serialBody += "\r\n----------------------------------------";
Double discountAmount = Convert.ToDouble(Double.Parse(g_DiscountLabel.Text.Substring(Program.currency.Length)).ToString("F02"));
Double billTotal = (discountAmount + m_dTotalAmount);
serialBody += "\r\n Order Total: " + CPrintMethods.RightAlign(billTotal.ToString("F02"), 6);
if (discountAmount > 0)
{
Double totalAmount = m_dTotalAmount;
Double discountPercent = 100 * discountAmount / (discountAmount + totalAmount);
serialBody += "\r\n Discount:(" + discountPercent.ToString("F02") + "%) " + CPrintMethods.RightAlign(discountAmount.ToString(), 6);
}
if (Convert.ToDouble("0" + g_ServiceChargeLabel.Text.Substring(Program.currency.Length)) > 0) //If service charge is assigned
{
serialBody += "\r\n Service Charge: " + CPrintMethods.RightAlign(Convert.ToDouble("0" + g_ServiceChargeLabel.Text.Substring(Program.currency.Length)).ToString("F02"), 6);
}
double payableAmount = Convert.ToDouble(Convert.ToDouble("0" + g_ServiceChargeLabel.Text.Substring(Program.currency.Length)).ToString("F02")) + (m_itemCost - discountAmount);
double pvat = (payableAmount * (vat / 100)) / (1 + (vat / 100));
if (isVatEnabled) //If service charge is assigned
{
serialBody += "\r\n Vat: " + CPrintMethods.RightAlign(pvat.ToString("F02"), 6);
}
serialBody += "\r\n Total Payable: " + CPrintMethods.RightAlign(payableAmount.ToString("F02"), 6);
if (Convert.ToDouble("0" + g_ServiceChargeLabel.Text.Substring(Program.currency.Length)) == 0) //If service charge is assigned
{
serialBody += "\r\n Service Charge: ______";
}
serialBody += "\r\n----------------------------------------";
if (m_bEqualSplit)
{
serialBody += "\r\n" + g_SplitAmountLabel.Text;
}
serialBody += "\r\nYou've Served by:" + m_OperatorName;
serialBody += "\r\n" + m_TerminalName.Trim();
serialBody += "\r\n S/N: " + tempOrderInfo.SerialNo.ToString();
serialBody += "\r\nDeveloped By: www.ibacs.co.uk";
this.WriteString(serialBody);
tempPrintMethods.SerialPrint(PRINTER_TYPES.NORMAL_PRINTER, serialHeader, serialBody, serialFooter, tempOrderInfo.SerialNo.ToString());
}
#endregion
}
catch (Exception exp)
{
throw exp;
}
}
}
private CPayment ReaderToPayment(IDataReader inReader,bool isExists)
{
CPayment tempPayment = new CPayment();
if (inReader["pc_id"] != null)
{
tempPayment.PcID = int.Parse(inReader["pc_id"].ToString());
}
if (inReader["userid"] != null)
{
tempPayment.UserID = Convert.ToString(inReader["userid"].ToString());
}
if (inReader["paymentdate"] != null)
{
Int64 dateTime = Convert.ToInt64(inReader["paymentdate"].ToString());
tempPayment.PaymentTime = new DateTime(dateTime);// Convert.ToDateTime(dateTime);
}
if (inReader["total_amount"] != null)
{
tempPayment.TotalAmount = Double.Parse(inReader["total_amount"].ToString());
}
return tempPayment;
}
public CPayment SaveDrawerLogs(Int32 terminal_id,string user_id,Int64 dateTime)
{
CPayment tempPayment = new CPayment();
try
{
tempPayment = Database.Instance.Payment.SaveDrawerLogs(terminal_id,user_id,dateTime);
m_oResult.IsSuccess = true;
m_oResult.Message = "Data Read Successfully";
}
catch (Exception ex)
{
System.Console.WriteLine("Exception occuer at GetPaymentByOrderID() : " + ex.Message);
Logger.Write("Exception : " + ex + " in GetPaymentByOrderID()", LogLevel.Error, "COrderManager");
}
return tempPayment;
}
public CResult GetPaymentLogDetails(Int64 startTime, Int64 endTime)
{
CResult tempcResult = new CResult();
List<CPayment> paymentdetails = new List<CPayment>();
string sqlCommand = String.Format(SqlQueries.GetQuery(Query.LogRegisterForPayment), startTime,endTime);
IDataReader oReader = this.ExecuteReader(sqlCommand);
if (oReader != null)
{
while (oReader.Read())
{
CPayment tempPayment = new CPayment();
tempPayment = ReaderToPayment(oReader,true);
paymentdetails.Add(tempPayment);
}
}
tempcResult.Data = paymentdetails;
return tempcResult;
}
private void PrintA5GuestBillReport(int printType)
{
int papersize = 70;
StringPrintFormater strPrintFormatter = new StringPrintFormater(70);
Hashtable htOrderedItems = new Hashtable();
SortedList slOrderedItems = null;
string cat1ID = String.Empty;
try
{
CPrintMethodsEXT tempPrintMethods = new CPrintMethodsEXT();
//CPrintMethods tempPrintMethods = new CPrintMethods();
int categoryID = 0;
//serial print
//string serialHeader = "IBACS RMS";
string serialHeader = "";
//string serialFooter = "Please Come Again";
string serialFooter = "";
List<CSerialPrintContent> serialBody = new List<CSerialPrintContent>();
CSerialPrintContent tempSerialPrintContent;
if (printType == 2)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CenterTextWithWhiteSpace("BILL PAYMENT") + "\r\n";
tempSerialPrintContent.Bold = true;
serialBody.Add(tempSerialPrintContent);
}
else
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CenterTextWithWhiteSpace("GUEST BILL") + "\r\n" ;
tempSerialPrintContent.Bold = true;
serialBody.Add(tempSerialPrintContent);
}
COrderManager tempOrderManager = new COrderManager();
COrderInfo tempOrderInfo = (COrderInfo)tempOrderManager.OrderInfoByOrderID(m_iOrderID).Data;
//string s=tempOrderInfo.
if (m_sTableType.Equals("Table"))
{
if (printType == 1)
{
//Order ID line remove from report for requisting user
// Sajib Vai gathered user requirement
//Date : 13-02-2012
//tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "\r\n\nOrder ID:" + m_iOrderID.ToString();
//serialBody.Add(tempSerialPrintContent);
}
//tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "\r\n\nTable Number:" + tempOrderInfo.TableNumber.ToString();
//serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nPrint Date: " + System.DateTime.Now.ToString("dd/MM/yy hh:mm tt");
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.ItemLabeledText("Table No: " + tempOrderInfo.TableNumber.ToString(), "") ;
tempSerialPrintContent.Bold = true;
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.ItemLabeledText("Guest No: " + tempOrderInfo.GuestCount.ToString(),"") + "\r\n";
tempSerialPrintContent.Bold = true;
serialBody.Add(tempSerialPrintContent);
//tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "Covers: " + tempOrderInfo.GuestCount.ToString() + "\r\n";
//tempSerialPrintContent.Bold = true;
//serialBody.Add(tempSerialPrintContent);
COrderWaiterDao orderWaiterDao = new COrderWaiterDao();
COrderwaiter orderWaiter = orderWaiterDao.GetOrderwaiterByOrderID(m_iOrderID);
if (orderWaiter != null && orderWaiter.WaiterID > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Waiter Name: " + orderWaiter.WaiterName + "\r\n";
//tempSerialPrintContent.Bold = true;
serialBody.Add(tempSerialPrintContent);
}
}
else if (m_sTableType.Equals("TakeAway"))
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nOrder Date: " + tempOrderInfo.OrderTime.ToString("dd/MM/yy hh:mm tt");
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nPrint Date: " + System.DateTime.Now.ToString("dd/MM/yy hh:mm tt");
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Type: " + tempOrderInfo.Status;
serialBody.Add(tempSerialPrintContent);
CCustomerManager tempCustomerManager = new CCustomerManager();
CCustomerInfo tempCustomerInfo = (CCustomerInfo)tempCustomerManager.CustomerInfoGetByCustomerID(tempOrderInfo.CustomerID).Data;
if (tempCustomerInfo.CustomerName.Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nCustomer Name: " + tempCustomerInfo.CustomerName;
serialBody.Add(tempSerialPrintContent);
}
if (tempCustomerInfo.CustomerPhone.Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nPhone:" + tempCustomerInfo.CustomerPhone;
serialBody.Add(tempSerialPrintContent);
}
if (tempOrderInfo.Status.Equals("Delivery"))
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nAddress:";
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
if (tempCustomerInfo.FloorAptNumber.Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Floor or Apartment:" + tempCustomerInfo.FloorAptNumber;
serialBody.Add(tempSerialPrintContent);
}
if (tempCustomerInfo.BuildingName.Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Building Name:" + tempCustomerInfo.BuildingName;
serialBody.Add(tempSerialPrintContent);
}
if (tempCustomerInfo.HouseNumber.Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "House Number:" + tempCustomerInfo.HouseNumber;
serialBody.Add(tempSerialPrintContent);
}
string[] street = new string[0];
street = tempCustomerInfo.StreetName.Split('-');
if (street.Length > 1)
{
if (street[0].ToString().Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Street:" + street[0].ToString();
serialBody.Add(tempSerialPrintContent);
}
if (street[1].ToString().Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = street[1].ToString();
serialBody.Add(tempSerialPrintContent);
}
}
else if (street.Length > 0 && street.Length < 2)
{
if (street[0].ToString().Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Street:" + street[0].ToString();
serialBody.Add(tempSerialPrintContent);
}
}
if (tempCustomerInfo.CustomerPostalCode.Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Postal Code:" + tempCustomerInfo.CustomerPostalCode;
serialBody.Add(tempSerialPrintContent);
}
if (tempCustomerInfo.CustomerTown.Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Town:" + tempCustomerInfo.CustomerTown;
serialBody.Add(tempSerialPrintContent);
}
//tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "Country:" + tempCustomerInfo.CustomerCountry;
//serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
//
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
CDelivery objDelivery = new CDelivery();
objDelivery.DeliveryOrderID = m_iOrderID;
CResult objDeliveryInfo = tempOrderManager.GetDeliveryInfo(objDelivery);
objDelivery = (CDelivery)objDeliveryInfo.Data;
if (objDelivery != null)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nDelivery Time:" + objDelivery.DeliveryTime;
serialBody.Add(tempSerialPrintContent);
}
}
}
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CenterTextWithDashed("Order Information");
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.ItemLabeledText("Item", "Qnty Unit Price Price(" + Program.currency + ")");
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
//
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine() + "\r\n";
serialBody.Add(tempSerialPrintContent);
//Line after above line
//tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "----------------------------------------";
//serialBody.Add(tempSerialPrintContent);
if (m_orderUserName.Replace(" ", "").ToUpper() != "Web User".Replace(" ", "").ToUpper())
{
string cat2ID = "";
string cat3ID = "";
Int32 internalCategoryID = 0;
// Int32 categoryID = 0;
m_itemCost = 0.0;
string categoryOrder = String.Empty;
for (int rowIndex = 0; rowIndex < m_dtItemList.Rows.Count; rowIndex++)
{
#region "Parent Category"
DataRow tempRow = m_dtItemList.Rows[rowIndex];
categoryOrder = String.Empty;
if (Convert.ToInt32("0" + tempRow["Catlevel"].ToString()) == 3)//Item from Category 3
{
internalCategoryID = Convert.ToInt32("0" + tempRow["Catid"].ToString());
DataRow[] dtRow = dsCategory3.Tables[0].Select("cat3_id = " + internalCategoryID);
if (dtRow.Length > 0)
{
cat2ID = dtRow[0]["cat2_id"].ToString();
DataRow[] dtRowCat2 = dsCategory2.Tables[0].Select("cat2_id = " + cat2ID);//new
cat1ID = dtRowCat2[0]["cat1_id"].ToString();
}
}
else if (Convert.ToInt32("0" + tempRow["Catlevel"].ToString()) == 0) //If miscellenious items are added
{
cat1ID = "0";
cat2ID = "0";
}
else
{
internalCategoryID = Convert.ToInt32("0" + tempRow["Catid"].ToString());
DataRow[] dtRow = dsCategory4.Tables[0].Select("cat4_id = " + internalCategoryID);
if (dtRow.Length > 0)
{
cat3ID = dtRow[0]["cat3_id"].ToString();
if (cat3ID != "" || cat3ID != null)
{
dtRow = dsCategory3.Tables[0].Select("cat3_id = " + cat3ID);
}
else
{
dtRow = null;
}
}
if (dtRow.Length > 0)
{
cat2ID = dtRow[0]["cat2_id"].ToString();
DataRow[] dtRowCat2 = dsCategory2.Tables[0].Select("cat2_id = " + cat2ID);//new
cat1ID = dtRowCat2[0]["cat1_id"].ToString();
}
}
#endregion
clsOrderReport objOrderedReport = new clsOrderReport();
objOrderedReport.Quantity = Convert.ToInt32("0" + tempRow["Qty"].ToString());
objOrderedReport.ItemName = tempRow["Item"].ToString();
objOrderedReport.Price = Convert.ToDouble("0" + tempRow["Price"].ToString());
int drinkValue = Convert.ToInt32("0" + tempRow["isdrink"].ToString());
if (drinkValue > 0)
{
objOrderedReport.DrinkStatus = true;
}
else
{
objOrderedReport.DrinkStatus = false;
}
Int64 rankNumber = Int64.Parse(tempRow["rank"].ToString());
objOrderedReport.ItemUnitPrice = Convert.ToDouble(tempRow["unitPrice"].ToString());
Int32 category1OrderNumber = this.GetCategory1OrderNumber(Convert.ToInt32(cat1ID));
htOrderedItems.Add(category1OrderNumber + "-" + rankNumber + "-" + objOrderedReport.ItemName, objOrderedReport);
m_itemCost += Convert.ToDouble("0" + tempRow["Price"].ToString());
}
NumericComparer nc = new NumericComparer();
slOrderedItems = new SortedList(htOrderedItems, nc);
int keyIndex = 0;
string[] valueSplitter = new string[0];
SortedList slDrinkItems = new SortedList();
SortedList slMiscellaneousItems = new SortedList();
PrintUtility printUtility = new PrintUtility();
foreach (clsOrderReport objOrderedItems in slOrderedItems.Values)
{
string priceString = printUtility.PupulateRightString(objOrderedItems.Quantity, objOrderedItems.ItemUnitPrice, objOrderedItems.Price);
string keyValue = slOrderedItems.GetKey(keyIndex).ToString();
valueSplitter = keyValue.Split('-');
if (objOrderedItems.DrinkStatus == true) //To make all drink items consecutively
{
slDrinkItems.Add(slDrinkItems.Count, objOrderedItems);
}
else if ((categoryID != Convert.ToInt32("0" + valueSplitter[0].ToString())) && (Convert.ToInt32("0" + valueSplitter[0].ToString()) != 0)) //All the items except drinks.
{
categoryID = Convert.ToInt32("0" + valueSplitter[0].ToString());
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine +=
strPrintFormatter.ItemLabeledText(
printUtility.MultipleLine(objOrderedItems.ItemName.ToString(), papersize - 32, priceString, papersize), "");
serialBody.Add(tempSerialPrintContent);
}
else if (valueSplitter[0].ToString() == "0")
{
slMiscellaneousItems.Add(slMiscellaneousItems.Count, objOrderedItems);//add miscellaneous items in the collection
}
else
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine +=
strPrintFormatter.ItemLabeledText(
printUtility.MultipleLine(objOrderedItems.ItemName.ToString(), papersize - 32, priceString, papersize), "");
serialBody.Add(tempSerialPrintContent);
}
keyIndex++;
}
//Add miscellaneous items only
if (slMiscellaneousItems.Count > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CenterTextWithDashed("Miscellaneous") + "\r\n";
serialBody.Add(tempSerialPrintContent);
foreach (clsOrderReport objOrderedItems in slMiscellaneousItems.Values)
{
string priceString = printUtility.PupulateRightString(objOrderedItems.Quantity, objOrderedItems.ItemUnitPrice, objOrderedItems.Price);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine +=
strPrintFormatter.ItemLabeledText(
printUtility.MultipleLine(objOrderedItems.ItemName.ToString(), papersize - 32, priceString, papersize), "");
serialBody.Add(tempSerialPrintContent);
}
}
//Add drinks only
if (slDrinkItems.Count > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CenterTextWithDashed("Drinks") + "\r\n";
serialBody.Add(tempSerialPrintContent);
foreach (clsOrderReport objOrderedItems in slDrinkItems.Values)
{
string priceString = printUtility.PupulateRightString(objOrderedItems.Quantity, objOrderedItems.ItemUnitPrice, objOrderedItems.Price);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine +=
strPrintFormatter.ItemLabeledText(
printUtility.MultipleLine(objOrderedItems.ItemName.ToString(), papersize - 32, priceString, papersize), "");
serialBody.Add(tempSerialPrintContent);
}
}
}
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
// strPrintFormatter.SumupLabeledText
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.SumupLabeledText("Order Total: ", m_itemCost.ToString("F02"));
serialBody.Add(tempSerialPrintContent);
Double discountAmount = Convert.ToDouble(Double.Parse(g_DiscountLabel.Text.Substring(Program.currency.Length)).ToString("F02"));
if (discountAmount > 0)
{
Double totalAmount = m_dTotalAmount;
Double discountPercent = 100 * discountAmount / (m_itemCost); //Discount percentage of the selected products
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.SumupLabeledText("Discount:(" + discountPercent.ToString("F02") + "%) ", Convert.ToDouble(g_DiscountLabel.Text.Substring(Program.currency.Length)).ToString("F02"));
serialBody.Add(tempSerialPrintContent);
}
if (Convert.ToDouble("0" + g_ServiceChargeLabel.Text.Substring(Program.currency.Length)) > 0) //If service charge is assigned
{
CResult cResult = tempOrderManager.OrderServiceChargeGetByOrderID(m_iOrderID);
ServiceCharge serviceCharge = cResult.Data as ServiceCharge;
string tempstring = Convert.ToDouble("0" + g_ServiceChargeLabel.Text.Substring(Program.currency.Length)).ToString("F02");
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.SumupLabeledText("Service Charge(" + serviceCharge .ServicechargeRate.ToString()+ "%): ", tempstring);
serialBody.Add(tempSerialPrintContent);
}
double payableAmount = Convert.ToDouble(Convert.ToDouble("0" + g_ServiceChargeLabel.Text.Substring(Program.currency.Length)).ToString("F02")) + (m_itemCost - discountAmount);
payableAmount = payableAmount + Convert.ToDouble("0" + lblVat.Text.Substring(Program.currency.Length));
if (isVatEnabled) //If service charge is assigned
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.SumupLabeledText("Vat(" + vat + "%): ", Convert.ToDouble("0" + lblVat.Text.Substring(Program.currency.Length)).ToString("F02"));
serialBody.Add(tempSerialPrintContent);
}
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
if (printType == 2)
{
if ((m_serviceCharge_accounts + m_serviceCharge_cash + m_serviceCharge_cheque + m_serviceCharge_eft + m_serviceCharge_voucher) > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.SumupLabeledText("Total Payable: ", (m_dTotalAmount + (m_serviceCharge_accounts + m_serviceCharge_cash + m_serviceCharge_cheque + m_serviceCharge_eft + m_serviceCharge_voucher)).ToString("F02"));
serialBody.Add(tempSerialPrintContent);
}
else
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.SumupLabeledText("Total Payable: ", m_dTotalAmount.ToString("F02"));
serialBody.Add(tempSerialPrintContent);
}
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nPayment:";
serialBody.Add(tempSerialPrintContent);
if (!g_InputTextBox.Text.Substring(Program.currency.Length).Equals("0.00"))
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nReceived :" + g_InputTextBox.Text.Substring(Program.currency.Length);
serialBody.Add(tempSerialPrintContent);
}
if (!g_CashLabel.Text.Substring(Program.currency.Length).Equals("0.00"))
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nCash:" + g_CashLabel.Text.Substring(Program.currency.Length);
serialBody.Add(tempSerialPrintContent);
}
if (!g_EFTLabel.Text.Substring(Program.currency.Length).Equals("0.00"))
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nCard - " + EFTOptionForm.seletedEFTCard.CardName + " :" + g_EFTLabel.Text.Substring(Program.currency.Length);
serialBody.Add(tempSerialPrintContent);
}
if (!g_ChequeLabel.Text.Substring(Program.currency.Length).Equals("0.00"))
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nDue:" + g_ChequeLabel.Text.Substring(Program.currency.Length);
serialBody.Add(tempSerialPrintContent);
}
if (!g_VoucherLabel.Text.Substring(Program.currency.Length).Equals("0.00"))
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nVoucher:" + g_VoucherLabel.Text.Substring(Program.currency.Length);
serialBody.Add(tempSerialPrintContent);
}
if (!g_AccountLabel.Text.Substring(Program.currency.Length).Equals("0.00"))
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nAccounts:" + g_AccountLabel.Text.Substring(Program.currency.Length);
serialBody.Add(tempSerialPrintContent);
}
if (m_isAddServiceCharge == false)
{
if (Convert.ToDouble("0" + g_BalaceLabel.Text.Substring(9 + Program.currency.Length)) > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nPay Back: " + g_BalaceLabel.Text.Substring(9 + Program.currency.Length) + "\n";
serialBody.Add(tempSerialPrintContent);
}
}
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
// Serial No line remove from report for requisting user
// Sajib Vai gathered user requirement
//Date : 13-02-2012
//tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "\r\nS/N: " + tempOrderInfo.SerialNo.ToString();
//serialBody.Add(tempSerialPrintContent);
if (Program.vatRegDes != "")
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\nVat Reg. No: " + Program.vatRegDes;
serialBody.Add(tempSerialPrintContent);
}
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
}
else if(printType ==1)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.SumupLabeledText("Total Payable: ", payableAmount.ToString("F02"));
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + "You've Served by:" + m_OperatorName;
serialBody.Add(tempSerialPrintContent);
//Terminal Name and Serial No line remove from report for requisting user
// Sajib Vai gathered user requirement
//Date : 13-02-2012
//if (m_TerminalName.Length > 0)
//{
// tempSerialPrintContent = new CSerialPrintContent();
// tempSerialPrintContent.StringLine = "\r\n" + m_TerminalName;
// serialBody.Add(tempSerialPrintContent);
//}
//if (tempOrderInfo.SerialNo.ToString().Length > 0)
//{
// tempSerialPrintContent = new CSerialPrintContent();
// tempSerialPrintContent.StringLine = "\r\n" + "S/N: " + tempOrderInfo.SerialNo.ToString();
// serialBody.Add(tempSerialPrintContent);
//}
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
if (tempOrderInfo.OrderType.Equals("Table"))
{
tempOrderInfo.Status = "Billed";
tempOrderInfo.OrderTime = System.DateTime.Now;
tempOrderManager.UpdateOrderInfo(tempOrderInfo);
CPaymentManager tempPaymentManager = new CPaymentManager();
CPayment tempPayment = new CPayment();
tempPayment.OrderID = tempOrderInfo.OrderID;
tempPayment.BillPrintTime = DateTime.Now;
tempPaymentManager.InsertBillPrintTime(tempPayment);
}
// tempPrintMethods.SerialPrint(PRINTER_TYPES.NORMAL_PRINTER, serialHeader, serialBody, serialFooter, tempOrderInfo.SerialNo.ToString());
//if (m_bEqualSplit)
//{
// tempPrintMethods.SerialPrint(PRINTER_TYPES.NORMAL_PRINTER, serialHeader, serialBody, serialFooter, tempOrderInfo.SerialNo.ToString());
//}
}
#region "Testing printing area"
string printingObject = "";
for (int arrayIndex = 0; arrayIndex < serialBody.Count; arrayIndex++)
{
printingObject += serialBody[arrayIndex].StringLine.ToString();
}
this.WriteString(printingObject);///Write to a file when print command is executed
gusetBillStr = printingObject;
#endregion
tempPrintMethods.USBPrintA5Report(printingObject, PrintDestiNation.CLIENT, true, papersize);
}
catch (Exception exp)
{
MessageBox.Show(exp.Message, RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public CResult InsertBillPrintTime(CPayment inPayment)
{
CPayment tempPayment = new CPayment();
try
{
Database.Instance.Payment.InsertBillPrintTime(inPayment);
m_oResult.IsSuccess = true;
m_oResult.Message = "Data Inserted Successfully";
}
catch (Exception ex)
{
System.Console.WriteLine("Exception occuer at InsertBillPrintTime() : " + ex.Message);
m_oResult.IsException = true;
m_oResult.Action = EERRORNAME.EXCEPTION_OCCURE;
//m_oResult.SetParams(ex.Message);
m_oResult.Message = ex.Message;
Logger.Write("Exception : " + ex + " in InsertBillPrintTime()", LogLevel.Error, "CPaymentManager");
}
return m_oResult;
}
public double GetSortedPayment(DateTime inTime)
{
double MaxAmount = 0.0;
GetTimeSpan(inTime);
try
{
this.OpenConnection();
string sSql = string.Format(SqlQueries.GetQuery(Query.GetSortedPayment),m_oStartTime,m_oEndTime);
IDataReader oReader = this.ExecuteReader(sSql);
CPayment tempPayment = new CPayment();
if (oReader != null)
{
while (oReader.Read())
{
Double.TryParse(oReader.GetValue(0).ToString(), out MaxAmount);
}
}
}
catch (Exception ex)
{
Console.Write("###" + ex + "###");
Logger.Write("Exception : " + ex + " in GetSortedPayment()", LogLevel.Error, "Database");
if (ex.GetType().Equals(typeof(SqlException)))
{
SqlException oSQLEx = ex as SqlException;
if (oSQLEx.Number != 7619)
throw new Exception("Exception occure at GetSortedPayment()", ex);
}
else
{
throw new Exception("Exception occure at GetPaymentByOrderID()", ex);
}
}
finally
{
this.CloseConnection();
}
return MaxAmount;
}
//Changed
public void InsertBillPrintTime(CPayment inPayment)
{
try
{
this.OpenConnection();
//string sSql = String.Format(SqlQueries.GetQuery(Query.InsertBillPrintTime), inPayment.OrderID, inPayment.BillPrintTime, inPayment.PaymentTime);
string sSql = String.Format(SqlQueries.GetQuery(Query.InsertBillPrintTime), inPayment.OrderID, inPayment.BillPrintTime.Ticks, inPayment.PaymentTime.Ticks);
this.ExecuteNonQuery(sSql);
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in InsertBillPrintTime()", LogLevel.Error, "Database");
throw new Exception("Exception occure at InsertBillPrintTime()", ex);
}
finally
{
this.CloseConnection();
}
}
/// <summary>
/// Collecting the printed copy of the respective order .added by Baruri at 13.12.2008
/// </summary>
private void GetPrintedCopy(Int64 orderID, List<COrderDetails> tempOrderDetailsList)
{
string Cat1ID = String.Empty;
try
{
CPrintMethods tempPrintMethods = new CPrintMethods();
int categoryID = 0;
string serialHeader = "IBACS RMS";
string serialFooter = "Please Come Again";
string serialBody = "";
CSerialPrintContent tempSerialPrintContent = new CSerialPrintContent();
serialBody = " KITCHEN COPY\r\n";
COrderManager tempOrderManager = new COrderManager();
COrderInfo tempOrderInfo = (COrderInfo)tempOrderManager.OrderInfoByOrderID(orderID).Data;//order information for online orders
serialBody += "\r\nOrder Date: " + tempOrderInfo.OrderTime.ToString("dd/MM/yy hh:mm tt");
serialBody += "\r\nPrint Date: " + System.DateTime.Now.ToString("dd/MM/yy hh:mm tt");
serialBody += "\r\nType: " + tempOrderInfo.Status;
CCustomerManager tempCustomerManager = new CCustomerManager();
CCustomerInfo tempCustomerInfo = (CCustomerInfo)tempCustomerManager.CustomerInfoGetByCustomerID(tempOrderInfo.CustomerID).Data;
serialBody += "\r\nCustomer Name: " + tempCustomerInfo.CustomerName;
serialBody += "\r\nPhone: " + tempCustomerInfo.CustomerPhone;
if (tempOrderInfo.Status.Equals("Delivery"))
{
serialBody += "\r\nAddress:";
serialBody += "\r\n----------------------------------------";
serialBody += "\r\nFloor or Apartment:" + tempCustomerInfo.FloorAptNumber;
serialBody += "\r\nBuilding Name:" + tempCustomerInfo.BuildingName;
serialBody += "\r\nHouse Number:" + tempCustomerInfo.HouseNumber;
serialBody += "\r\nPhone:" + tempCustomerInfo.CustomerPhone;
serialBody += "\r\nPostal Code:" + tempCustomerInfo.CustomerPostalCode;
serialBody += "\r\nTown:" + tempCustomerInfo.CustomerTown;
serialBody += "\r\nCountry:" + tempCustomerInfo.CustomerCountry;
serialBody += "\r\n----------------------------------------";
}
serialBody += "\r\nOrder Information";
serialBody += "\r\n----------------------------------------";
serialBody += "\r\nQty Item Price ";
serialBody += "\r\n----------------------------------------";
if (tempOrderDetailsList.Count > 0)
{
for (int counter = 0; counter < tempOrderDetailsList.Count; counter++)
{
serialBody += "\r\n" + tempOrderDetailsList[counter].OrderQuantity.ToString() + " ";
serialBody += CPrintMethods.GetFixedString(tempOrderDetailsList[counter].ItemName.ToString(), 30)+" ";
serialBody += CPrintMethods.RightAlign(tempOrderDetailsList[counter].OrderAmount.ToString(), 6);
// billTotal += Convert.ToDouble("0" + tempOrderDetailsList[j].OrderAmount);
}
}
serialBody += "\r\n----------------------------------------";
//serialBody += "\r\n Order Total: " + billTotal.ToString("F02");
//serialBody += "\r\n Total Payable: " + billTotal.ToString("F02");
//serialBody += "\r\n----------------------------------------";
//serialBody += "\r\n S/N: " + tempOrderInfo.SerialNo.ToString();
//serialBody += "\r\nDeveloped by:ibacs limited.";
serialBody += "\r\nThis is an online order.";
serialBody += "\r\n [END] ";
CCommonConstants oConstant = ConfigManager.GetConfig<CCommonConstants>();
CPrintingFormat tempPrintingFormat = new CPrintingFormat();
tempPrintingFormat.Header = serialHeader;
tempPrintingFormat.Body = serialBody.ToUpper();
tempPrintingFormat.Footer = serialFooter;
tempPrintingFormat.OrderID = orderID;
tempPrintingFormat.PrintType = (int)PRINTER_TYPES.Serial;
CLogin oLogin = new CLogin();
oLogin = (RmsRemote.CLogin)Activator.GetObject(typeof(RmsRemote.CLogin), oConstant.RemoteURL);
oLogin.PostPrintingRequest(tempPrintingFormat);
///Update status
///
if (tempOrderInfo.OrderType.Equals("Table"))
{
tempOrderInfo.Status = "Billed";
tempOrderInfo.OrderTime = System.DateTime.Now;
tempOrderManager.UpdateOrderInfo(tempOrderInfo);
CPaymentManager tempPaymentManager = new CPaymentManager();
CPayment tempPayment = new CPayment();
tempPayment.OrderID = tempOrderInfo.OrderID;
tempPayment.BillPrintTime = DateTime.Now;
tempPaymentManager.InsertBillPrintTime(tempPayment);
}
}
catch (Exception exp)
{
}
}
