private void AddItemVoidReport()
{
COrderManager tempOrderManager = new COrderManager();
CResult oResult = tempOrderManager.OrderInfoByOrderID(m_orderID);
COrderInfo tempOrderInfo = new COrderInfo();
if (oResult.IsSuccess && oResult.Data != null)
{
tempOrderInfo = (COrderInfo)oResult.Data;
}
ItemVoid aItemVoid=new ItemVoid();
aItemVoid.OrderId = (int)m_orderID;
aItemVoid.Creator_Id = tempOrderInfo.UserID;
aItemVoid.RemoverId = RMS.RMSGlobal.m_iLoginUserID;
ReasonForm aReasonForm = new ReasonForm();
aReasonForm.ShowDialog();
aItemVoid.Reason = aReasonForm.reason;
aItemVoid.VoidDate = DateTime.Now;
foreach (ListViewItem lsvItem in lsvRemovable.Items)
{
try
{
aItemVoid.Quantity = Convert.ToDouble(lsvItem.SubItems[1].Text);
aItemVoid.ItemName = lsvItem.SubItems[0].Text;
int id = Convert.ToInt32(lsvItem.SubItems[3].Text);
CCategory3 aCategory3 = new CCategory3();
CCategory3DAO aCategory3Dao = new CCategory3DAO();
aCategory3 = aCategory3Dao.GetAllCategory3ByCategory3ID(id);
aItemVoid.Amount = aItemVoid.Quantity * aCategory3.Category3TablePrice;
OrderVoidDAO aOrderVoidDao = new OrderVoidDAO();
aOrderVoidDao.InsertItemForVoid(aItemVoid);
}
catch (Exception)
{
}
}
}
private void exportToCSVfile(string fileOut)
{
// SqlConnection conn = new SqlConnection(DBForm.sqlConnString);
// string sqlQuery = "select * from " + this.lbxTables.SelectedItem.ToString();
// SqlCommand command = new SqlCommand(sqlQuery, conn);
// conn.Open();
// productsTable.d
// SqlDataReader dr = command.ExecuteReader();
// DataTable dtSchema = dr.GetSchemaTable();
StreamWriter sw = new StreamWriter(fileOut, false, Encoding.Unicode);
// string strRow;
// if (this.chkFirstRowColumnNames.Checked)
// {
// sw.WriteLine(columnNames(dtSchema, this.separator));
// }
string strRow = "";
string separator = "\t";
//strRow += "cat1 ";
//strRow += separator;
//strRow += "cat2 ";
//strRow += separator;
strRow += "Item ID";
strRow += separator;
strRow += "Product Name";
strRow += separator;
strRow += "Retail Price";
strRow += separator;
strRow += "Whole Price";
strRow += separator;
strRow += "Last Purchase Price";
strRow += separator;
strRow += "Vat Included";
strRow += separator;
strRow += "Non Tax ableGood";
strRow += separator;
strRow += "Qnty Per S.U.";
strRow += separator;
strRow += "Qnty Per P U";
strRow += separator;
strRow += "Stock";
strRow += separator;
sw.WriteLine(strRow);
foreach (DataGridViewRow row in dgvFoodItem.Rows)
{
int itemID = Convert.ToInt32(row.Cells["cat3_id"].Value);
// CCategoryManager oManager = new CCategoryManager();
CCategory3DAO cCategory3Dao = new CCategory3DAO();
CCategory3 objFoodItemUpdate = cCategory3Dao.GetAllCategory3ByCategory3ID(itemID);
// CCategory3 objFoodItemUpdate = (CCategory3)oResult.Data;
// foreach (DataRow row in productsTable.Rows)
// {
strRow = "";
//Category Name
//try
//{
// strRow += Convert.ToString(row.Cells["cat1"].Value);
//}
//catch (Exception ex) { strRow += ""; }
//strRow += separator;
////Category2_Name
//try { strRow += Convert.ToString(row.Cells["cat2"].Value); }
//catch (Exception ex) { strRow += ""; }
//strRow += separator;
//Item ID
// int itemID = 0;
try
{
strRow += Convert.ToString(itemID);
}
catch (Exception ex) { strRow += ""; }
strRow += separator;
//Product Name
try { strRow += objFoodItemUpdate.Category3Name; }
catch (Exception ex) { strRow += " "; }
strRow += separator;
//Retail Sale Price
// try { strRow += objFoodItemUpdate.MRetailPrice.ToString("F2"); }
try { strRow += objFoodItemUpdate.Category3TablePrice.ToString("F2"); }
catch (Exception ex) { strRow += " "; }
strRow += separator;
//WholeSalePrice
// try { strRow += Convert.ToString(objFoodItemUpdate.MWholeSalePrice.ToString("F2")); }
try { strRow += Convert.ToString(objFoodItemUpdate.Category3TakeAwayPrice.ToString("F2")); }
catch (Exception ex) { strRow += " "; }
strRow += separator;
//LastPurchasePrice
// try { strRow += Convert.ToString(objFoodItemUpdate.MLastPurchasePrice.ToString("F2")); }
try { strRow += Convert.ToString(objFoodItemUpdate.Category3BarPrice.ToString("F2")); }
catch (Exception ex) { strRow += " "; }
strRow += separator;
//VatIncluded
try
{
strRow += objFoodItemUpdate.MVatIncluded.ToString();
}
catch (Exception ex) { strRow += " "; }
strRow += separator;
//NonTaxableGood
try
{
strRow += objFoodItemUpdate.MNonTaxableGood.ToString();
}
catch (Exception ex) { strRow += " "; }
strRow += separator;
//QTYPerSaleUint
try
{
strRow += objFoodItemUpdate.MQtyPerSaleUint.ToString();
}
catch (Exception ex) { strRow += " "; }
strRow += separator;
//QTYPerPurchaseUnit
try
{
strRow += objFoodItemUpdate.MQtyPerPurchaseUnit.ToString();
}
catch (Exception ex) { strRow += " "; }
strRow += separator;
//Stock
try
{
strRow += objFoodItemUpdate.MUnitsInStock.ToString();
}
catch (Exception ex) { strRow += " "; }
strRow += separator;
sw.WriteLine(strRow);
}
sw.Close();
MessageBox.Show("CSV file Created Successful");
}
private void PrintNewBeverage()
{
int papersize = 29;
StringPrintFormater strPrintFormatter = new StringPrintFormater(29);
string Cat1ID = String.Empty;
bool blnToBePrinted = false;
try
{
CPrintMethodsEXT tempPrintMethods = new CPrintMethodsEXT();
//string serialHeader = "IBACS RMS";
string serialHeader = "";
string serialFooter = "";
List<CSerialPrintContent> serialBody = new List<CSerialPrintContent>();
List<CSerialPrintContent> serialBody2 = new List<CSerialPrintContent>();
CSerialPrintContent tempSerialPrintContent = new CSerialPrintContent();
COrderManager tempOrderManager = new COrderManager();
COrderInfo tempOrderInfo = (COrderInfo)tempOrderManager.OrderInfoByOrderID(orderID).Data;
//tempSerialPrintContent.StringLine = " Beverages/Non-Food\n";
if (m_iType == m_cCommonConstants.TableType)
{
tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = " Table No:" + m_iTableNumber.ToString();
tempSerialPrintContent.StringLine = "Table No:\r\n" + m_iTableNumber.ToString();
tempSerialPrintContent.Bold = true;
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = " Guest No:" +tempOrderInfo.GuestCount.ToString() + "\r\n";
tempSerialPrintContent.StringLine = "Covers:" + tempOrderInfo.GuestCount.ToString();
tempSerialPrintContent.Bold = true;
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
}
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CenterTextWithWhiteSpace("Beverages/Non-Food");
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
//string s=tempOrderInfo.
if (m_iType == m_cCommonConstants.TableType)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Order ID:" + orderID.ToString();
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Order Date:" + tempOrderInfo.OrderTime.ToString("dd/MM/yy hh:mm tt");
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Print Date:" + System.DateTime.Now.ToString("dd/MM/yy hh:mm tt");
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
//tempSerialPrintContent = new CSerialPrintContent();
////tempSerialPrintContent.StringLine = " Table No:" + m_iTableNumber.ToString();
//tempSerialPrintContent.StringLine = "\r\n\nTable No:" + m_iTableNumber.ToString();
//tempSerialPrintContent.Bold = true;
//serialBody.Add(tempSerialPrintContent);
//serialBody2.Add(tempSerialPrintContent);
//tempSerialPrintContent = new CSerialPrintContent();
////tempSerialPrintContent.StringLine = " Guest No:" +tempOrderInfo.GuestCount.ToString() + "\r\n";
//tempSerialPrintContent.StringLine = "Covers:" + tempOrderInfo.GuestCount.ToString();
//tempSerialPrintContent.Bold = true;
//serialBody.Add(tempSerialPrintContent);
//serialBody2.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);
serialBody2.Add(tempSerialPrintContent);
}
}
else if (m_iType == m_cCommonConstants.TakeAwayType)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Order Date:" + tempOrderInfo.OrderTime.ToString("dd/MM/yy hh:mm tt");
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Print Date:" + System.DateTime.Now.ToString("dd/MM/yy hh:mm tt");
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Type:" + tempOrderInfo.Status;
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
CCustomerManager tempCustomerManager = new CCustomerManager();
CCustomerInfo tempCustomerInfo = (CCustomerInfo)tempCustomerManager.CustomerInfoGetByCustomerID(tempOrderInfo.CustomerID).Data;
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Customer Name:" + tempCustomerInfo.CustomerName;
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Phone:" + tempCustomerInfo.CustomerPhone;
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
if (tempOrderInfo.Status.Equals("Delivery"))
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Address:";
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "----------------------------------------";
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
if (tempCustomerInfo.FloorAptNumber.Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Floor or Apartment:" + tempCustomerInfo.FloorAptNumber;
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
}
if (tempCustomerInfo.BuildingName.Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Building Name:" + tempCustomerInfo.BuildingName;
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
}
if (tempCustomerInfo.HouseNumber.Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "House Number:" + tempCustomerInfo.HouseNumber;
serialBody.Add(tempSerialPrintContent);
serialBody2.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);
serialBody2.Add(tempSerialPrintContent);
}
if (street[1].ToString().Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = street[1].ToString();
serialBody.Add(tempSerialPrintContent);
serialBody2.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);
serialBody2.Add(tempSerialPrintContent);
}
}
if (tempCustomerInfo.CustomerPostalCode.Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Postal Code:" + tempCustomerInfo.CustomerPostalCode;
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
}
if (tempCustomerInfo.CustomerTown.Length > 0)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Town:" + tempCustomerInfo.CustomerTown;
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
}
tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "----------------------------------------";
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
serialBody2.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);
serialBody2.Add(tempSerialPrintContent);
}
}
}
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Order Information";
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "----------------------------------------";
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
if (m_isBarPriceAvailable == true)
{
//tempSerialPrintContent.StringLine = "Qty Item Price(" + Program.currency.ToString() + ")";
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.ItemLabeledText("Qty Item", "Price(" + Program.currency + ")");
}
else
{
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.ItemLabeledText("Qty Item", "");
}
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "----------------------------------------";
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
serialBody.Add(tempSerialPrintContent);
// serialBody2 = serialBody;
bool nonfood = false;
bool othernoonfood = false;
PrintUtility printUtility = new PrintUtility();
if (m_orderUserName.Replace(" ", "").ToUpper() != "Web User".Replace(" ", "").ToUpper())
{
Hashtable htOrderedItems = new Hashtable();
string categoryOrder = String.Empty;
for (int rowIndex = 0; rowIndex < g_BeverageDataGridView.Rows.Count; rowIndex++)
{
DataGridViewRow tempRow = g_BeverageDataGridView.Rows[rowIndex];
int totalItem = Convert.ToInt32("0" + tempRow.Cells[1].Value);
int printItem = Convert.ToInt32("0" + tempRow.Cells[8].Value); // Here index number was 7 and now change index number is 8 by mithu
if ((!tempRow.Cells[0].Value.ToString().Equals("")) && (totalItem > printItem))
{
blnToBePrinted = true;
tempSerialPrintContent = new CSerialPrintContent();
int productId = Convert.ToInt32(tempRow.Cells[4].Value.ToString());
CCategory3DAO aDao = new CCategory3DAO();
string printstatus = aDao.GetAllCategory3printareaByCategory3ID(productId);
double price = (Convert.ToDouble("0" + tempRow.Cells[3].Value.ToString()) / Convert.ToInt32("0" + tempRow.Cells[1].Value.ToString())) * (totalItem - printItem);//change for kitchen
//tempSerialPrintContent.StringLine += CPrintMethods.GetFixedString(tempRow.Cells[0].Value.ToString(), 30);
if (printstatus == "OtherNonfood")
{
othernoonfood = true;
tempSerialPrintContent = new CSerialPrintContent();
if (m_isBarPriceAvailable == true) //Is bar price available or not for online order
{
// tempSerialPrintContent.StringLine += strPrintFormatter.ItemLabeledText(Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[1].Value) + " " + Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[0].Value), Convert.ToDouble("0" + g_BeverageDataGridView.Rows[rowIndex].Cells[2].Value).ToString("F02"));
// tempSerialPrintContent.StringLine += strPrintFormatter.ItemLabeledText(Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[1].Value) + " " +
// printUtility.MultipleLine(Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[0].Value), papersize - 10, Convert.ToDouble("0" + g_BeverageDataGridView.Rows[rowIndex].Cells[2].Value).ToString("F02"), papersize-3), "");
tempSerialPrintContent.StringLine += strPrintFormatter.ItemLabeledText(Convert.ToString(totalItem-printItem) + " " +
printUtility.MultipleLine(Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[0].Value), papersize - 10, price.ToString("F02"), papersize - 3), ""); //change for kitchen
}
else
{
//tempSerialPrintContent.StringLine += strPrintFormatter.ItemLabeledText(Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[1].Value) + " " + Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[0].Value), "");
tempSerialPrintContent.StringLine += strPrintFormatter.ItemLabeledText(Convert.ToString(totalItem - printItem) + " " +
printUtility.MultipleLine(Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[0].Value), papersize - 5, "", papersize), "");
}
serialBody2.Add(tempSerialPrintContent);
}
else
{
tempSerialPrintContent = new CSerialPrintContent();
nonfood = true;
if (m_isBarPriceAvailable == true) //Is bar price available or not for online order
{
// tempSerialPrintContent.StringLine += strPrintFormatter.ItemLabeledText(Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[1].Value) + " " + Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[0].Value), Convert.ToDouble("0" + g_BeverageDataGridView.Rows[rowIndex].Cells[2].Value).ToString("F02"));
// tempSerialPrintContent.StringLine += strPrintFormatter.ItemLabeledText(Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[1].Value) + " " +
// printUtility.MultipleLine(Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[0].Value), papersize - 10, Convert.ToDouble("0" + g_BeverageDataGridView.Rows[rowIndex].Cells[2].Value).ToString("F02"), papersize-3), "");
tempSerialPrintContent.StringLine +=
strPrintFormatter.ItemLabeledText(
Convert.ToString(totalItem - printItem) +
" " +
printUtility.MultipleLine(
Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[0].Value),
papersize - 10, price.ToString("F02"), papersize - 3), ""); //change for kitchen
}
else
{
//tempSerialPrintContent.StringLine += strPrintFormatter.ItemLabeledText(Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[1].Value) + " " + Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[0].Value), "");
tempSerialPrintContent.StringLine +=
strPrintFormatter.ItemLabeledText(
Convert.ToString(totalItem - printItem) +
" " +
printUtility.MultipleLine(
Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[0].Value),
papersize - 5, "", papersize), "");
}
serialBody.Add(tempSerialPrintContent);
// itemAvailable = true;
}
}
}
}
else
{
//For online orders
//tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "----------------------------------------\r\n";
//serialBody.Add(tempSerialPrintContent);
for (int rowIndex = 0; rowIndex < g_BeverageDataGridView.RowCount; rowIndex++)
{
DataGridViewRow tempRow = g_BeverageDataGridView.Rows[rowIndex];
int totalItem = Convert.ToInt32("0" + tempRow.Cells[1].Value);
int printItem = Convert.ToInt32("0" + tempRow.Cells[7].Value);
if ((!tempRow.Cells[0].Value.ToString().Equals("")) && (totalItem > printItem))
{
tempSerialPrintContent = new CSerialPrintContent();
int productId = Convert.ToInt32(tempRow.Cells[4].Value.ToString());
CCategory3DAO aDao = new CCategory3DAO();
string printstatus = aDao.GetAllCategory3printareaByCategory3ID(productId);
double price = (Convert.ToDouble("0" + tempRow.Cells[3].Value.ToString()) / Convert.ToInt32("0" + tempRow.Cells[1].Value.ToString())) * (totalItem - printItem); //change for kitchen
//tempSerialPrintContent.StringLine += CPrintMethods.GetFixedString(tempRow.Cells[0].Value.ToString(), 30);
if (printstatus == "OtherNonfood")
{
othernoonfood = true;
tempSerialPrintContent = new CSerialPrintContent();
if (m_isBarPriceAvailable == true) //Is bar price available or not for online order
{
// tempSerialPrintContent.StringLine += strPrintFormatter.ItemLabeledText(Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[1].Value) + " " + Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[0].Value), Convert.ToDouble("0" + g_BeverageDataGridView.Rows[rowIndex].Cells[2].Value).ToString("F02"));
// tempSerialPrintContent.StringLine += strPrintFormatter.ItemLabeledText(Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[1].Value) + " " +
// printUtility.MultipleLine(Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[0].Value), papersize - 10, Convert.ToDouble("0" + g_BeverageDataGridView.Rows[rowIndex].Cells[2].Value).ToString("F02"), papersize-3), "");
tempSerialPrintContent.StringLine += strPrintFormatter.ItemLabeledText(Convert.ToString(totalItem - printItem) + " " +
printUtility.MultipleLine(Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[0].Value), papersize - 10, price.ToString("F02"), papersize - 3), "");//change for kitchen
}
else
{
//tempSerialPrintContent.StringLine += strPrintFormatter.ItemLabeledText(Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[1].Value) + " " + Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[0].Value), "");
tempSerialPrintContent.StringLine += strPrintFormatter.ItemLabeledText(Convert.ToString(totalItem - printItem) + " " +
printUtility.MultipleLine(Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[0].Value), papersize - 5, "", papersize), "");
}
serialBody2.Add(tempSerialPrintContent);
}
else
{
tempSerialPrintContent = new CSerialPrintContent();
nonfood = true;
if (m_isBarPriceAvailable == true) //Is bar price available or not for online order
{
// tempSerialPrintContent.StringLine += strPrintFormatter.ItemLabeledText(Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[1].Value) + " " + Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[0].Value), Convert.ToDouble("0" + g_BeverageDataGridView.Rows[rowIndex].Cells[2].Value).ToString("F02"));
// tempSerialPrintContent.StringLine += strPrintFormatter.ItemLabeledText(Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[1].Value) + " " +
// printUtility.MultipleLine(Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[0].Value), papersize - 10, Convert.ToDouble("0" + g_BeverageDataGridView.Rows[rowIndex].Cells[2].Value).ToString("F02"), papersize-3), "");
tempSerialPrintContent.StringLine +=
strPrintFormatter.ItemLabeledText(
Convert.ToString(totalItem - printItem) +
" " +
printUtility.MultipleLine(
Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[0].Value),
papersize - 10, price.ToString("F02"), papersize - 3), ""); ////change for kitchen
}
else
{
//tempSerialPrintContent.StringLine += strPrintFormatter.ItemLabeledText(Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[1].Value) + " " + Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[0].Value), "");
tempSerialPrintContent.StringLine +=
strPrintFormatter.ItemLabeledText(
Convert.ToString(totalItem - printItem) +
" " +
printUtility.MultipleLine(
Convert.ToString(g_BeverageDataGridView.Rows[rowIndex].Cells[0].Value),
papersize - 5, "", papersize), "");
}
serialBody.Add(tempSerialPrintContent);
//itemAvailable = true;
}
blnToBePrinted = true;
}
}
}
tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "----------------------------------------";
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
//New at 22.08.2008
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Order Prepared By:" + m_OperatorName;
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = m_TerminalName.Trim();
serialBody.Add(tempSerialPrintContent);
serialBody2.Add(tempSerialPrintContent);
#region "Testing printing area"
string printingObject = "";
string printingObject2 = "";
for (int arrayIndex = 0; arrayIndex < serialBody.Count; arrayIndex++)
{
printingObject += serialBody[arrayIndex].StringLine.ToString() + "\r\n";
}
for (int arrayIndex = 0; arrayIndex < serialBody2.Count; arrayIndex++)
{
printingObject2 += serialBody2[arrayIndex].StringLine.ToString() + "\r\n";
}
if (blnToBePrinted == true) //If there is new items
{
if (nonfood)
{
for (int printCopy = 0; printCopy < m_barCopyNumber; printCopy++)
{
//tempPrintMethods.SerialPrint(PRINTER_TYPES.NORMAL_PRINTER, serialHeader, serialBody, serialFooter, tempOrderInfo.SerialNo.ToString());
// tempPrintMethods.SerialPrint(PRINTER_TYPES.NORMAL_PRINTER, serialHeader, serialBody, serialFooter, tempOrderInfo.SerialNo.ToString(),true);
string fullPrintingText = serialHeader + "\r\n" + printingObject + "\r\n" + serialFooter;
tempPrintMethods.USBPrint(fullPrintingText, PrintDestiNation.BEVARAGE, false);
}
this.WriteString(printingObject); ///Write to a file when print command is executed
}
if (othernoonfood)
{
for (int printCopy = 0; printCopy < m_barCopyNumber; printCopy++)
{
//tempPrintMethods.SerialPrint(PRINTER_TYPES.NORMAL_PRINTER, serialHeader, serialBody, serialFooter, tempOrderInfo.SerialNo.ToString());
// tempPrintMethods.SerialPrint(PRINTER_TYPES.NORMAL_PRINTER, serialHeader, serialBody, serialFooter, tempOrderInfo.SerialNo.ToString(),true);
string fullPrintingText = serialHeader + "\r\n" + printingObject2 + "\r\n" + serialFooter;
tempPrintMethods.USBPrint(fullPrintingText, PrintDestiNation.OtherNonFood, false);
}
this.WriteString(printingObject); ///Write to a file when print command is executed
}
blnToBePrinted = false;
}
#endregion
}
catch (Exception exp)
{
MessageBox.Show(exp.Message, RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private bool CheckStockControl()
{
CCategory3DAO cCategory3Dao = new CCategory3DAO();
COrderManager tempOrderManager = new COrderManager();
List<COrderDetails> tempOrderDetailsList = new List<COrderDetails>();
CResult oResult = tempOrderManager.OrderDetailsByOrderID(orderID);
if (oResult.IsSuccess && oResult.Data != null)
tempOrderDetailsList = (List<COrderDetails>)oResult.Data;
string stockMessage = "Stock is unavailable ";
bool isStockAvailable = true;
foreach (COrderDetails orderDetail in tempOrderDetailsList)
{
CCategory3 cCategory3 = cCategory3Dao.GetAllCategory3ByCategory3ID(Convert.ToInt32(orderDetail.ProductID));
if ((orderDetail.OrderQuantity - orderDetail.KitchenQuantity) > cCategory3.MUnitsInStock && cCategory3.MNonStockable)
{
//stockMessage += "\n " + orderDetail.Product_Name + " " + (orderDetail.OrderQuantity - cCategory3.MUnitsInStock);
stockMessage += "\n " + cCategory3.Category3Name + ": Needed: " + (orderDetail.OrderQuantity - orderDetail.KitchenQuantity) + " But Have " + (cCategory3.MUnitsInStock);
isStockAvailable = false;
}
}
if (!isStockAvailable)
{
CUserInfoDAO aUserInfoDao = new CUserInfoDAO();
CUserInfo aUserInfo = new CUserInfo();
aUserInfo = aUserInfoDao.GetUserInfoByUsername(RMSGlobal.LoginUserName);
if (aUserInfo.Type == 0)
{
DialogResult dialogResult = MessageBox.Show("Do You Proceed", "Stock Alert", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
isStockAvailable = true;
}
else if (dialogResult == DialogResult.No)
{
}
}
}
if (!isStockAvailable || !CheckRawProduct(tempOrderDetailsList))
{
CMessageBox cMessageBox = new CMessageBox("Finished Product", stockMessage);
cMessageBox.ShowDialog();
//MessageBox.Show(stockMessage);
return false;
}
else
{
foreach (COrderDetails orderDetails in tempOrderDetailsList)
{
CCategory3 cCategory3 = cCategory3Dao.GetAllCategory3ByCategory3ID(Convert.ToInt32(orderDetails.ProductID));
if (!cCategory3.MNonStockable)
{
cCategory3Dao.UpdateStock(Convert.ToInt32(orderDetails.ProductID), orderDetails.OrderQuantity - orderDetails.KitchenQuantity);
COrderDetailsDAO cOrderDetailsDao = new COrderDetailsDAO();
cOrderDetailsDao.UpdateKitchenQuantity(orderDetails);
}
}
}
// parrentForm.scre
return true;
}
/// <summary>
/// Printing at the kitchen
/// </summary>
private void KitchenPrint()
{
int papersize = 29;
StringPrintFormater strPrintFormatter = new StringPrintFormater(29);
Hashtable htOrderedItems = new Hashtable();
SortedList slOrderedItems = null;
try
{
bool itemAvailable = false;
CPrintMethodsEXT tempPrintMethods = new CPrintMethodsEXT();
CCommonConstants oConstant = ConfigManager.GetConfig<CCommonConstants>();
COrderManager tempOrderManager = new COrderManager();
CResult oResult = tempOrderManager.OrderInfoByOrderID(orderID);
COrderInfo tempOrderInfo = new COrderInfo();
if (oResult.IsSuccess && oResult.Data != null)
{
tempOrderInfo = (COrderInfo)oResult.Data;
}
if (oConstant.KitchenPrintFlag == 1)
{
bool otherfoodprint = false;
bool foodprint = false;
string serialHeader = "";
string serialFooter = "";
string serialBody = "";
string serialBody2 = "";
if (m_iType == m_cCommonConstants.TableType)
{
//serialBody += "\r\n\r\n Table Number:" + m_iTableNumber.ToString();
serialBody += "Table Number:\r\n" + m_iTableNumber.ToString();
serialBody += "\r\nCovers:" + tempOrderInfo.GuestCount.ToString();
}
serialBody += "\n\r\n";
serialBody += strPrintFormatter.CenterTextWithWhiteSpace("Kitchen Copy");
if (!tempOrderInfo.Status.Equals("Seated") && m_iType == m_cCommonConstants.TableType)
{
//serialBody += "\r\nReprint";
serialBody += "\r\n" + strPrintFormatter.CenterTextWithWhiteSpace("Reprint");
}
serialBody += "\r\n\r\nOrder ID:" + orderID.ToString();
serialBody += "\r\n\r\nOrder Date:" + tempOrderInfo.OrderTime.ToString("dd/MM/yy hh:mm tt");
serialBody += "\r\nPrint Date:" + DateTime.Now.ToString("dd/MM/yy hh:mm tt");
if (m_iType == m_cCommonConstants.TableType)
{
//serialBody += "\r\n\r\n Table Number:" + m_iTableNumber.ToString();
//serialBody += "\r\n\n\r\nTable Number:" + m_iTableNumber.ToString();
//serialBody += "\r\nCovers:" + tempOrderInfo.GuestCount.ToString();
COrderWaiterDao orderWaiterDao = new COrderWaiterDao();
COrderwaiter orderWaiter = orderWaiterDao.GetOrderwaiterByOrderID(orderID);
if (orderWaiter != null && orderWaiter.WaiterID > 0)
{
serialBody += "\r\nWaiter Name: " + orderWaiter.WaiterName +"\r\n";
}
}
else if (m_iType == m_cCommonConstants.TakeAwayType)
{
//Waiter for Takeway
COrderWaiterDao orderWaiterDao = new COrderWaiterDao();
COrderwaiter orderWaiter = orderWaiterDao.GetOrderwaiterByOrderID(orderID);
if (orderWaiter != null && orderWaiter.WaiterID > 0)
{
serialBody += "\r\nWaiter Name: " + orderWaiter.WaiterName + "\r\n";
}
//serialBody += "\r\n\r\n Take Away";
serialBody += "\r\n" + strPrintFormatter.CenterTextWithWhiteSpace("Take Away");
serialBody += "\r\nType: " + tempOrderInfo.Status;
CCustomerManager tempCustomerManager = new CCustomerManager();
CCustomerInfo tempCustomerInfo = (CCustomerInfo)tempCustomerManager.CustomerInfoGetByCustomerID(tempOrderInfo.CustomerID).Data;
if (tempCustomerInfo.CustomerName.Length > 0) //If customer name is present
{
serialBody += "\r\nCustomer Name: " + tempCustomerInfo.CustomerName;
}
if (tempCustomerInfo.CustomerPhone.Length > 0) //If customer phone number is available
{
serialBody += "\r\nPhone:" + tempCustomerInfo.CustomerPhone;
}
if (tempOrderInfo.Status.Equals("Delivery"))
{
serialBody += "\r\nAddress:";
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 = orderID;
CResult objDeliveryInfo = tempOrderManager.GetDeliveryInfo(objDelivery);
objDelivery = (CDelivery)objDeliveryInfo.Data;
serialBody += "\r\nDelivery Time:" + objDelivery.DeliveryTime;
}
}
//serialBody += "\r\n\r\nOrder Information";
serialBody += "\r\n" + strPrintFormatter.CenterTextWithWhiteSpace("Order Information");
//serialBody += "\r\n---------------------------------";
serialBody += "\r\n" + strPrintFormatter.CreateDashedLine();
if (m_isKitchenPriceAvailable == true)
{
//serialBody += "\r\nQty Item Price(" + Program.currency.ToString() + ")";
serialBody += "\r\n" + strPrintFormatter.ItemLabeledText("Qty Item", "Price(" + Program.currency + ")");
}
else
{
serialBody += "\r\nQty Item";
}
serialBody2 = serialBody;
// serialBody += "\r\n---------------------------------";
if (m_orderUserName.Replace(" ", "").ToUpper() != "Web User".Replace(" ", "").ToUpper())
{
string cat1ID = String.Empty;
string cat2ID = String.Empty;
string cat3ID = String.Empty;
string separatorCatID = String.Empty;
string category2Order = String.Empty; //Printing order will be according to category2 order
for (int rowIndex = 0; rowIndex < g_FoodDataGridView.Rows.Count; rowIndex++)
{
DataGridViewRow tempRow = g_FoodDataGridView.Rows[rowIndex];
category2Order = String.Empty;
if (!tempRow.Cells[0].Value.ToString().Equals(""))
{
// Int64 productID = Int64.Parse(tempRow.Cells[3].Value.ToString());
// Int32 productLevel = Int32.Parse(tempRow.Cells[4].Value.ToString());
Int64 productID = Int64.Parse(tempRow.Cells[4].Value.ToString());
Int32 productLevel = Int32.Parse(tempRow.Cells[5].Value.ToString());
if (productLevel == 3)
{
DataRow[] dtRow = dsCategory3.Tables[0].Select("cat3_id = " + productID);
if (dtRow.Length > 0)
{
cat2ID = dtRow[0]["cat2_id"].ToString();
}
cat1ID = Program.initDataSet.Tables["Category2"].Select("cat2_id = " + cat2ID)[0].GetParentRow(Program.initDataSet.Relations["category1_to_category2"])["cat1_id"].ToString();
}
else if (productLevel == 4)
{
DataRow[] dtRow = dsCategory4.Tables[0].Select("cat4_id = " + productID);
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();
}
cat1ID = Program.initDataSet.Tables["Category2"].Select("cat2_id = " + cat2ID)[0].GetParentRow(Program.initDataSet.Relations["category1_to_category2"])["cat1_id"].ToString();//Not necessary
}
else if (productLevel == 0)// && inFoodType.Equals("Indian")) //If miscellenious foods.
{
cat1ID = "0";
cat2ID = "0";
}
#region "New "
CCategory3DAO aDao = new CCategory3DAO();
string printstatus = aDao.GetAllCategory3printareaByCategory3ID((int)productID);
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());
//For vat grid index
objOrderedItems.Quantity = Convert.ToInt32("0" + tempRow.Cells[1].Value.ToString());
objOrderedItems.ItemName = tempRow.Cells[0].Value.ToString();
objOrderedItems.Price = Convert.ToDouble("0" + tempRow.Cells[3].Value.ToString());
objOrderedItems.PrintArea = printstatus;
//htOrderedItems.Add(cat2ID + "-" + objOrderedItems.ItemName, objOrderedItems);
//Int64 rankNumber = Int64.Parse(tempRow.Cells[5].Value.ToString());
//For Vat
Int64 rankNumber = Int64.Parse(tempRow.Cells[6].Value.ToString());
Int32 category1OrderNumber = this.GetCategory1OrderNumber(Convert.ToInt32(cat1ID));
htOrderedItems.Add(category1OrderNumber + "-" + rankNumber.ToString() + "-" + objOrderedItems.ItemName, objOrderedItems);// Category 1 wise
#endregion
itemAvailable = true;//For drinks.When drinks is avalable then no separator is used.
}
}
NumericComparer ncomp = new NumericComparer();
slOrderedItems = new SortedList(htOrderedItems, ncomp);
int keyIndex = 0;
SortedList slMiscellaneousItems = new SortedList();
PrintUtility printUtility = new PrintUtility();
string[] valueSplitter = new string[0];
foreach (clsOrderReport objReport in slOrderedItems.Values)
{
string keyValue = slOrderedItems.GetKey(keyIndex).ToString();
valueSplitter = keyValue.Split('-');
if ((separatorCatID.Trim() != valueSplitter[0].ToString().Trim()) && (valueSplitter[0].ToString().Trim() != "0"))//Insert separator
{
////serialBody += "\r\n---------------------------------";
//serialBody += "\r\n" + strPrintFormatter.CreateDashedLine();
//separatorCatID = valueSplitter[0].ToString().Trim();
///*serialBody += "\r\n" + objReport.Quantity.ToString() + " ";
//serialBody += CPrintMethods.GetFixedString(objReport.ItemName, 20);*/
////serialBody += "\r\n" + strPrintFormatter.ItemLabeledText(objReport.Quantity.ToString().Trim(), objReport.ItemName.ToString());
//if (m_isKitchenPriceAvailable == true)
//{
// serialBody += "\r\n" + strPrintFormatter.ItemLabeledText(objReport.Quantity.ToString().Trim() + " " +
// printUtility.MultipleLine(objReport.ItemName.ToString(), papersize - 10, objReport.Price.ToString("F02"), papersize-3), "");
//}
//else
//{
// serialBody += "\r\n" + strPrintFormatter.ItemLabeledText(objReport.Quantity.ToString().Trim() + " " +
// printUtility.MultipleLine(objReport.ItemName.ToString(), papersize - 5, "", papersize), "");
//}
if (objReport.PrintArea == "Otherfood")
{
otherfoodprint = true;
serialBody2 += "\r\n" + strPrintFormatter.CreateDashedLine();
separatorCatID = valueSplitter[0].ToString().Trim();
//serialBody += "\r\n" + objReport.Quantity.ToString() + " ";
// serialBody += CPrintMethods.GetFixedString(objReport.ItemName, 20);
if (m_isKitchenPriceAvailable == true)
{
//serialBody += " " + CPrintMethods.RightAlign(objReport.Price.ToString("F02"), 6);
// serialBody += "\r\n" + strPrintFormatter.ItemLabeledText(objReport.Quantity.ToString() + " " + objReport.ItemName, objReport.Price.ToString("F02"));
serialBody2 += "\r\n" +
strPrintFormatter.ItemLabeledText(
objReport.Quantity.ToString() + " " +
printUtility.MultipleLine(objReport.ItemName, papersize - 10,
objReport.Price.ToString("F02"),
papersize - 3), "");
}
else
{
// serialBody += "\r\n" + strPrintFormatter.ItemLabeledText(objReport.Quantity.ToString() + " " + objReport.ItemName, "");
serialBody2 += "\r\n" +
strPrintFormatter.ItemLabeledText(
objReport.Quantity.ToString() + " " +
printUtility.MultipleLine(objReport.ItemName, papersize - 5, "",
papersize), "");
}
}
else
{
foodprint = true;
serialBody += "\r\n" + strPrintFormatter.CreateDashedLine();
separatorCatID = valueSplitter[0].ToString().Trim();
//serialBody += "\r\n" + objReport.Quantity.ToString() + " ";
// serialBody += CPrintMethods.GetFixedString(objReport.ItemName, 20);
if (m_isKitchenPriceAvailable == true)
{
//serialBody += " " + CPrintMethods.RightAlign(objReport.Price.ToString("F02"), 6);
// serialBody += "\r\n" + strPrintFormatter.ItemLabeledText(objReport.Quantity.ToString() + " " + objReport.ItemName, objReport.Price.ToString("F02"));
serialBody += "\r\n" +
strPrintFormatter.ItemLabeledText(
objReport.Quantity.ToString() + " " +
printUtility.MultipleLine(objReport.ItemName, papersize - 10,
objReport.Price.ToString("F02"),
papersize - 3), "");
}
else
{
// serialBody += "\r\n" + strPrintFormatter.ItemLabeledText(objReport.Quantity.ToString() + " " + objReport.ItemName, "");
serialBody += "\r\n" +
strPrintFormatter.ItemLabeledText(
objReport.Quantity.ToString() + " " +
printUtility.MultipleLine(objReport.ItemName, papersize - 5, "",
papersize), "");
}
}
}
else if (valueSplitter[0].ToString() == "0")
{
slMiscellaneousItems.Add(slMiscellaneousItems.Count, objReport);
}
else
{
///*serialBody += "\r\n" + objReport.Quantity.ToString() + " ";
//serialBody += CPrintMethods.GetFixedString(objReport.ItemName, 20);*/
//// serialBody += "\r\n" + strPrintFormatter.SumupLabeledText(objReport.Quantity.ToString() + " " + objReport.ItemName.ToString()," ");
//if (m_isKitchenPriceAvailable == true)
//{
// //serialBody += " " + CPrintMethods.RightAlign(objReport.Price.ToString("F02"), 6);
// // serialBody += "\r\n" + strPrintFormatter.ItemLabeledText(objReport.Quantity.ToString() + " " + objReport.ItemName.ToString(), objReport.Price.ToString("F02"));
// serialBody += "\r\n" + strPrintFormatter.ItemLabeledText(objReport.Quantity.ToString().Trim() + " " +
// printUtility.MultipleLine(objReport.ItemName.ToString(), papersize - 10, objReport.Price.ToString("F02"), papersize-3), "");
//}
//else
//{
// //serialBody += "\r\n" + strPrintFormatter.ItemLabeledText(objReport.Quantity.ToString() + " " + objReport.ItemName.ToString(), "");
// serialBody += "\r\n" + strPrintFormatter.ItemLabeledText(objReport.Quantity.ToString().Trim() + " " +
// printUtility.MultipleLine(objReport.ItemName.ToString(), papersize - 5, "", papersize), "");
//}
if (objReport.PrintArea == "Otherfood")
{
otherfoodprint = true;
//serialBody2 += "\r\n" + objReport.Quantity.ToString() + " ";
//serialBody2 += CPrintMethods.GetFixedString(objReport.ItemName, 20);
if (m_isKitchenPriceAvailable == true)
{
//serialBody += " " + CPrintMethods.RightAlign(objReport.Price.ToString("F02"), 6);
// serialBody += "\r\n" + strPrintFormatter.ItemLabeledText("\r\n" + objReport.Quantity.ToString() + " " + objReport.ItemName, objReport.Price.ToString("F02"));
serialBody2 += "\r\n" +
strPrintFormatter.ItemLabeledText(
objReport.Quantity.ToString() + " " +
printUtility.MultipleLine(objReport.ItemName, papersize - 10,
objReport.Price.ToString("F02"),
papersize - 3), "");
}
else {
serialBody2 += "\r\n" + objReport.Quantity.ToString() + " ";
serialBody2 += CPrintMethods.GetFixedString(objReport.ItemName, 20);
}
}
else
{
foodprint = true;
//serialBody += "\r\n" + objReport.Quantity.ToString() + " ";
//serialBody += CPrintMethods.GetFixedString(objReport.ItemName, 20);
if (m_isKitchenPriceAvailable == true)
{
//serialBody += " " + CPrintMethods.RightAlign(objReport.Price.ToString("F02"), 6);
// serialBody += "\r\n" + strPrintFormatter.ItemLabeledText("\r\n" + objReport.Quantity.ToString() + " " + objReport.ItemName, objReport.Price.ToString("F02"));
serialBody += "\r\n" +
strPrintFormatter.ItemLabeledText(
objReport.Quantity.ToString() + " " +
printUtility.MultipleLine(objReport.ItemName, papersize - 10,
objReport.Price.ToString("F02"),
papersize - 3), "");
}
else
{
serialBody += "\r\n" + objReport.Quantity.ToString() + " ";
serialBody += CPrintMethods.GetFixedString(objReport.ItemName, 20);
}
}
}
keyIndex++;
}
if (slMiscellaneousItems.Count > 0)
{
foodprint = true;
//serialBody += "\r\n----------Miscellaneous----------"; //separator for miscellaneous
serialBody += "\r\n" + strPrintFormatter.CenterTextWithDashed("Miscelaneous");
foreach (clsOrderReport objReport in slMiscellaneousItems.Values)
{
/*serialBody += "\r\n" + objReport.Quantity.ToString() + " ";
serialBody += CPrintMethods.GetFixedString(objReport.ItemName, 20);*/
// serialBody += "\r\n" + strPrintFormatter.SumupLabeledText(objReport.Quantity.ToString() + " " + objReport.ItemName.ToString(), "");
if (m_isKitchenPriceAvailable == true)
{
//serialBody += " " + CPrintMethods.RightAlign(objReport.Price.ToString("F02"), 6);
// serialBody += "\r\n" + strPrintFormatter.ItemLabeledText(objReport.Quantity.ToString() + " " + objReport.ItemName.ToString(), objReport.Price.ToString("F02"));
serialBody += "\r\n" + strPrintFormatter.ItemLabeledText(objReport.Quantity.ToString().Trim() + " " +
printUtility.MultipleLine(objReport.ItemName.ToString(), papersize - 10, objReport.Price.ToString("F02"), papersize-3), "");
}
else
{
// serialBody += "\r\n" + strPrintFormatter.ItemLabeledText(objReport.Quantity.ToString() + " " + objReport.ItemName.ToString(), "");
serialBody += "\r\n" + strPrintFormatter.ItemLabeledText(objReport.Quantity.ToString().Trim() + " " +
printUtility.MultipleLine(objReport.ItemName.ToString(), papersize - 5, "", papersize), "");
}
}
}
//string[] kitchenCommand = new string[0];
//kitchenCommand = tempOrderInfo.InitialKitchenText.Split(',');
//serialBody += "\r\n---------------------------------";
serialBody += "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody2 += "\r\n" + strPrintFormatter.CreateDashedLine();
CResult objKitchenText = tempOrderManager.GetKitchenTextByOrderID(orderID);
List<OrderLogInformation> tempOrderLogInfoList = new List<OrderLogInformation>();
tempOrderLogInfoList = (List<OrderLogInformation>)objKitchenText.Data;
if (tempOrderLogInfoList.Count > 0)
{
serialBody += "\r\nKT Txt:";
serialBody2 += "\r\nKT Txt:";
}
for (int recordCounter = 0; recordCounter < tempOrderLogInfoList.Count; recordCounter++)
{
if (tempOrderLogInfoList[recordCounter].KitchenTextPrintStatus < 1)
{
serialBody += "\r\n- " + tempOrderLogInfoList[recordCounter].KitchenText;
serialBody += "\r\n- " + tempOrderLogInfoList[recordCounter].KitchenText;
}
}
serialBody += "\r\nOrder Prepared By:" + m_OperatorName;
serialBody += "\r\n" + m_TerminalName;
serialBody += "\r\n\r\n" + strPrintFormatter.CenterTextWithWhiteSpace("[ E N D ]") + "\r\n\r\n";
serialBody2 += "\r\nOrder Prepared By:" + m_OperatorName;
serialBody2 += "\r\n" + m_TerminalName;
serialBody2 += "\r\n\r\n" + strPrintFormatter.CenterTextWithWhiteSpace("[ E N D ]") + "\r\n\r\n";
//tempPrintMethods.SerialPrint(PRINTER_TYPES.KITCHEN_PRINTER, serialHeader, serialBody, serialFooter);
// string fullKitchenPrinttext=serialHeader+"\r\n"+serialBody+"\r\n"+serialFooter;
// tempPrintMethods.USBPrint(fullKitchenPrinttext, PrintDestiNation.KITCHEN, false);
if (itemAvailable == true) //If there is available items
{
///Kitchen Print call
///
CPrintingFormat tempPrintingFormat = new CPrintingFormat();
tempPrintingFormat.Header = serialHeader;
tempPrintingFormat.Body = serialBody.ToUpper();
tempPrintingFormat.Footer = serialFooter;
tempPrintingFormat.OrderID = orderID;
tempPrintingFormat.PrintType = (int)PRINTER_TYPES.Serial;
CPrintingFormat tempPrintingFormat1 = new CPrintingFormat();
tempPrintingFormat1.Header = serialHeader;
tempPrintingFormat1.Body = serialBody2.ToUpper();
tempPrintingFormat1.Footer = serialFooter;
tempPrintingFormat1.OrderID = orderID;
tempPrintingFormat1.PrintType = (int)PRINTER_TYPES.Serial;
CPrintMethodsEXT cPrintMethods = new CPrintMethodsEXT();
CLogin oLogin = new CLogin();
oLogin = (RmsRemote.CLogin)Activator.GetObject(typeof(RmsRemote.CLogin), oConstant.RemoteURL);
for (int printCopy = 0; printCopy < m_printedCopy; printCopy++)
{
if (foodprint)
{
string fulltext = tempPrintingFormat.Header + "\r\n" + tempPrintingFormat.Body +
"\r\n" + tempPrintingFormat.Footer;
cPrintMethods.USBPrint(fulltext, PrintDestiNation.KITCHEN, false);
}
if (otherfoodprint)
{
string fulltext = tempPrintingFormat1.Header + "\r\n" + tempPrintingFormat1.Body + "\r\n" + tempPrintingFormat1.Footer;
cPrintMethods.USBPrint(fulltext, PrintDestiNation.Other, false);
}
}
if (tempOrderLogInfoList.Count > 0) //If kitchen command is available.
{
this.UpdateKitchenTextPrintStatus();
}
this.WriteString(serialBody);//Writing to the specified file
}
}
else //For online orders all items
{
bool isItemsAvailable = false;
foodprint = false;
otherfoodprint = false;
serialBody += "\r\n---------------------------------";
for (int rowIndex = 0; rowIndex < g_FoodDataGridView.RowCount; rowIndex++)
{
// Int64 productID = Int64.Parse(tempRow.Cells[4].Value.ToString());
if (g_FoodDataGridView.Rows[rowIndex].Cells[1].Value.ToString() != String.Empty)
{
Int64 productID = Int64.Parse(g_FoodDataGridView.Rows[rowIndex].Cells[1].Value.ToString());
CCategory3DAO aDao = new CCategory3DAO();
string printstatus = aDao.GetAllCategory3printareaByCategory3ID((int)productID);
if (printstatus == "Otherfood")
{
otherfoodprint = true;
serialBody2 += "\r\n" + g_FoodDataGridView.Rows[rowIndex].Cells[1].Value.ToString() +
" ";
serialBody2 +=
CPrintMethods.GetFixedString(
g_FoodDataGridView.Rows[rowIndex].Cells[0].Value.ToString(), 20);
if (m_isKitchenPriceAvailable == true)
{
serialBody2 += " " +
CPrintMethods.RightAlign(
Convert.ToDouble("0" +
g_FoodDataGridView.Rows[rowIndex].Cells[2].
Value).ToString("F02"), 6);
}
} else
{
foodprint = true;
serialBody += "\r\n" + g_FoodDataGridView.Rows[rowIndex].Cells[1].Value.ToString() +
" ";
serialBody +=
CPrintMethods.GetFixedString(
g_FoodDataGridView.Rows[rowIndex].Cells[0].Value.ToString(), 20);
if (m_isKitchenPriceAvailable == true)
{
serialBody += " " +
CPrintMethods.RightAlign(
Convert.ToDouble("0" +
g_FoodDataGridView.Rows[rowIndex].Cells[2].
Value).ToString("F02"), 6);
}
}
isItemsAvailable = true;
}
}
serialBody += "\r\n---------------------------------";
serialBody += "\r\nKT Txt:" + tempOrderInfo.InitialKitchenText;
serialBody += "\r\n---------------------------------";
serialBody += "\r\nOrder Prepared By:" + m_OperatorName;
serialBody += "\r\n\r\n [ E N D ]\r\n\r\n";
serialBody2 += "\r\n---------------------------------";
serialBody2 += "\r\nKT Txt:" + tempOrderInfo.InitialKitchenText;
serialBody2 += "\r\n---------------------------------";
serialBody2 += "\r\nOrder Prepared By:" + m_OperatorName;
serialBody2 += "\r\n\r\n [ E N D ]\r\n\r\n";
if (isItemsAvailable == false)//If there is no items in the datagrid view
{
return;
}
else
{
if (foodprint)
{
CPrintingFormat tempPrintingFormat = new CPrintingFormat();
CPrintMethodsEXT cPrintMethods = new CPrintMethodsEXT();
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);
string fulltext = tempPrintingFormat.Header + "\r\n" + tempPrintingFormat.Body + "\r\n" +
tempPrintingFormat.Footer;
cPrintMethods.USBPrint(fulltext, PrintDestiNation.KITCHEN, false);
this.WriteString(serialBody); //Writing to the specified file
}
if (otherfoodprint)
{
CPrintingFormat tempPrintingFormat = new CPrintingFormat();
CPrintMethodsEXT cPrintMethods = new CPrintMethodsEXT();
tempPrintingFormat.Header = serialHeader;
tempPrintingFormat.Body = serialBody2.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);
string fulltext = tempPrintingFormat.Header + "\r\n" + tempPrintingFormat.Body + "\r\n" +
tempPrintingFormat.Footer;
cPrintMethods.USBPrint(fulltext, PrintDestiNation.Other, false);
this.WriteString(serialBody); //Writing to the specified file
}
}
}
if (tempOrderInfo.Status.Equals("Seated") && tempOrderInfo.OrderType.Equals("Table"))
{
tempOrderInfo.Status = "Ordered";
tempOrderManager.UpdateOrderInfo(tempOrderInfo);
}
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message, RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void LoadItemMenu()
{
try
{
CCategory3DAO aCCategory3Dao = new CCategory3DAO();
List<CCategory3> aCategory3s = new List<CCategory3>();
if (Convert.ToInt32("0" + cmbsubcategory.SelectedValue) != 0)
{
aCategory3s =
aCCategory3Dao.GetCategory3ByCategory2ID(Convert.ToInt32("0" + cmbsubcategory.SelectedValue));
itemMenucomboBox.DataSource = aCategory3s;
itemMenucomboBox.DisplayMember = "Category3Name";
itemMenucomboBox.ValueMember = "Category3ID";
}
}
catch (Exception)
{
}
}
private bool CheckRawProduct(List<COrderDetails> tempOrderDetailsList)
{
CCategory3DAO cCategory3Dao = new CCategory3DAO();
FinishedRawProductListDAO finishedRawProductListDao = new FinishedRawProductListDAO();
string stockMessage = "Stock is unavailable ";
bool isStockAvailable = true;
KitchenStockDAO aKitchenStockDao = new KitchenStockDAO();
foreach (COrderDetails orderDetail in tempOrderDetailsList)
{
List<CFinishedRawProductList> finishedRawProductList = finishedRawProductListDao.GetFinishedRawProductListByProductID(Convert.ToInt32(orderDetail.ProductID));
foreach (CFinishedRawProductList finishedRawProduct in finishedRawProductList)
{
// CCategory3 cCategory3 = cCategory3Dao.GetAllCategory3ByCategory3ID(Convert.ToInt32(finishedRawProduct.RawProductID));
KitchenStock aKitchenStock = new KitchenStock();
// KitchenStockDAO aKitchenStockDao=new KitchenStockDAO();
aKitchenStock = aKitchenStockDao.GetStockByItemidFrominventory_kitchen_stock((int)finishedRawProduct.RawProductID);
//List<CCategory3> aList = cCategory3Dao.GetAllCategory3();
//var temp = from acategory in aList where acategory.Category2ID == cCategory3.Category2ID select acategory;
if (finishedRawProduct.Qnty * (orderDetail.OrderQuantity - orderDetail.KitchenQuantity) > aKitchenStock.Stocks)
{
stockMessage += "\n " + finishedRawProduct.RawProductName + ": Needed: " + finishedRawProduct.Qnty *
(orderDetail.OrderQuantity - orderDetail.KitchenQuantity) + "\n " + " But Have: " + (aKitchenStock.Stocks);
isStockAvailable = false;
}
}
}
if(!isStockAvailable)
{
CUserInfoDAO aUserInfoDao=new CUserInfoDAO();
CUserInfo aUserInfo=new CUserInfo();
aUserInfo = aUserInfoDao.GetUserInfoByUsername(RMSGlobal.LoginUserName);
if (aUserInfo.Type == 0)
{
DialogResult dialogResult = MessageBox.Show("Do You Proceed", "Stock Alert", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
isStockAvailable = true;
}
else if (dialogResult == DialogResult.No)
{
}
}
}
if (!isStockAvailable)
{
CMessageBox cMessageBox = new CMessageBox("Raw Product", stockMessage);
cMessageBox.ShowDialog();
return false;
}
else
{
foreach (COrderDetails orderDetails in tempOrderDetailsList)
{
List<CFinishedRawProductList> finishedRawProductList =
finishedRawProductListDao.GetFinishedRawProductListByProductID(
Convert.ToInt32(orderDetails.ProductID));
foreach (CFinishedRawProductList finishedRawProduct in finishedRawProductList)
{
aKitchenStockDao.UpdateStock(Convert.ToInt32(finishedRawProduct.RawProductID),
finishedRawProduct.Qnty * (orderDetails.OrderQuantity - orderDetails.KitchenQuantity));
}
COrderDetailsDAO cOrderDetailsDao = new COrderDetailsDAO();
cOrderDetailsDao.UpdateKitchenQuantity(orderDetails);
}
}
return true;
}
/// <summary>
/// Saving the food item.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
CResult objResult = ValidateForm();
if (objResult.IsSuccess)
{
CCategory3 objFoodItem = new CCategory3();
objFoodItem.Category2ID = Int32.Parse(cmbCategory.SelectedValue.ToString());
objFoodItem.Category3Name = txtProductName.Text.Trim();
objFoodItem.Category3Description = txtDescription.Text.Trim();
objFoodItem.PrintArea = printareacomboBox.Text;
if (chkTable.Checked)
{
objFoodItem.Category3ViewTable = 1;
}
if (chkBar.Checked)
{
objFoodItem.Category3ViewBar = 1;
}
if (chkTakeAway.Checked)
{
objFoodItem.Category3ViewTakeAway = 1;
}
if (!txtTablePrice.Text.Trim().Equals(String.Empty))
{
objFoodItem.Category3TablePrice = Double.Parse(txtTablePrice.Text.Trim());
}
if (!txtTakeawayPrice.Text.Trim().Equals(String.Empty))
{
objFoodItem.Category3TakeAwayPrice = Double.Parse(txtTakeawayPrice.Text.Trim());
}
if (!txtBarPrice.Text.Trim().Equals(String.Empty))
{
objFoodItem.Category3BarPrice = Double.Parse(txtBarPrice.Text.Trim());
}
//Add by mithu
if (!tblCost.Text.Trim().Equals(String.Empty))
{
objFoodItem.TableCost = Double.Parse(tblCost.Text.Trim());
}
if (!takeawayCost.Text.Trim().Equals(String.Empty))
{
objFoodItem.TakeAwayCost = Double.Parse(takeawayCost.Text.Trim());
}
if (!barCost.Text.Trim().Equals(String.Empty))
{
objFoodItem.BarCost = Double.Parse(barCost.Text.Trim());
}
if (rdoActive.Checked)
{
objFoodItem.Category3OrderStatus = 1;
}
else if (rdoInactive.Checked)
{
objFoodItem.Category3OrderStatus = 0;
}
if (chkUnlimited.Checked)
{
objFoodItem.InitialItemQuantity = 0;
objFoodItem.UnlimitStatus = 1;
}
else
{
objFoodItem.InitialItemQuantity = Convert.ToInt32("0"+txtInitialQuantity.Text);
objFoodItem.UnlimitStatus = 0;
}
objFoodItem.ItemSellingIn = cmbSellingIn.Text; //Whether the item sold in quantity or weight
try
{
objFoodItem.vatRate = Convert.ToDouble(txtVateRate.Text.ToString());
}
catch
{
objFoodItem.vatRate = 0.00;
}
if (chkVateIncluded.Checked)
{
objFoodItem.vatIncluded = true;
}
else
{
objFoodItem.vatIncluded = false;
}
objFoodItem.ProductType = ProductType;
// if(ProductType=="")
try
{
objFoodItem.UoM = cmbSellingIn.Text;
}
catch { }
CCategoryManager oManager = new CCategoryManager();
CResult oResult2 = oManager.AddCategory3(objFoodItem);
if (oResult2.IsSuccess)
{
if (ProductType == "RawMaterial")
{
CCategory3DAO aCategory3Dao=new CCategory3DAO();
objFoodItem.Category3ID = Convert.ToInt32(categorycomboBox.SelectedValue);
aCategory3Dao.AddPurchaseStore(objFoodItem,categorycomboBox.Text);
}
lblSaveStatus.Text = " The product has been saved successfully.";
lblSaveStatus.Visible = true;
}
else
{
lblSaveStatus.Text = "The product can not be added. Please try again. ";
lblSaveStatus.Visible = true;
}
}
else
{
lblSaveStatus.Text = objResult.Message;
lblSaveStatus.Visible = true;
}
}
private double GetTotalCost(long mIOrderId)
{
COrderDetailsDAO aDetailsDao=new COrderDetailsDAO();
List<COrderDetails> aDetailses=new List<COrderDetails>();
aDetailses = (List<COrderDetails>)aDetailsDao.OrderDetailsGetByOrderID(mIOrderId).Data;
CCategory3DAO aCCategory3Dao=new CCategory3DAO();
List<CCategory3> aCCategory3s=new List<CCategory3>();
aCCategory3s = aCCategory3Dao.GetAllCategory3();
double totalcost = 0;
foreach (COrderDetails order in aDetailses)
{
foreach (CCategory3 category3 in aCCategory3s)
{
if(category3.Category3ID==order.ProductID)
{
totalcost += (category3.TableCost*order.OrderQuantity);
}
}
}
return totalcost;
}
private void LoadRawProduct()
{
try
{
cCategory3sList = new List<CCategory3>();
int cat2ID = Convert.ToInt32(cmbRawCategory2.SelectedValue);
cmbProductName.Items.Clear();
CCategory3DAO cCategory3Dao = new CCategory3DAO();
cCategory3sList = cCategory3Dao.GetCategory3ByCategory2ID(cat2ID);
if (cCategory3sList != null && cCategory3sList.Count > 0)
{
foreach (CCategory3 cCategory3 in cCategory3sList)
{
cmbProductName.Items.Add(cCategory3.Category3Name);
}
}
if (cmbProductName.Items.Count > 0)
{
cmbProductName.SelectedIndex = 0;
}
}
catch (Exception ex)
{
}
}
/// <summary>
/// Saving the food item.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
try
{
CResult objResult = ValidateForm();
if (objResult.IsSuccess)
{
CCategory3 productItem = new CCategory3();
productItem = objFoodItemUpdate;
// productItem.Category2ID = Int32.Parse(cmbCategory.SelectedValue.ToString());
// productItem.Category3Name = txtProductName.Text.Trim();
// productItem.Category3Description = txtDescription.Text.Trim();
//productItem.Category3TablePrice = objFoodItemUpdate.Category3TablePrice;
//productItem.Category3TakeAwayPrice = objFoodItemUpdate.Category3TakeAwayPrice;
//productItem.Category3BarPrice = objFoodItemUpdate.Category3BarPrice;
/* start: price */
if (!txtRetailPrice.Text.Trim().Equals(String.Empty))
{
// productItem.MRetailPrice = Double.Parse(txtRetailPrice.Text.Trim());
productItem.Category3TablePrice = Double.Parse(txtRetailPrice.Text.Trim());
}
if (!txtWholeSalePrice.Text.Trim().Equals(String.Empty))
{
//productItem.MWholeSalePrice = Double.Parse(txtWholeSalePrice.Text.Trim());
productItem.Category3TakeAwayPrice = Double.Parse(txtWholeSalePrice.Text.Trim());
}
if (!txtLastPurchasePrice.Text.Trim().Equals(String.Empty))
{
// productItem.MLastPurchasePrice = Double.Parse(txtLastPurchasePrice.Text.Trim());
productItem.Category3BarPrice = Double.Parse(txtLastPurchasePrice.Text.Trim());
}
// is input price vat inluded
// if (chbVatIncluded.Checked)
if (cmbboxVatIncluded.SelectedIndex == 0)
{
// double vat = Program.vat / 100;
/* productItem.Category3TablePrice = Convert.ToDouble( (productItem.Category3TablePrice/(1+vat)).ToString("F02"));
productItem.RetailPrice = Convert.ToDouble((productItem.RetailPrice / (1 + vat)).ToString("F02"));
productItem.Category3TakeAwayPrice = Convert.ToDouble((productItem.Category3TakeAwayPrice/(1+vat)).ToString("F02"));
productItem.WholeSalePrice =Convert.ToDouble(( productItem.WholeSalePrice / (1 + vat)).ToString("F02"));
productItem.Category3BarPrice =Convert.ToDouble(( productItem.Category3BarPrice / (1 + vat)).ToString("F02"));
productItem.LastPurchasePrice = Convert.ToDouble((productItem.LastPurchasePrice / (1 + vat)).ToString("F02"));
*/
#if VATFIXED
// int i = 0;
#else
//productItem.Category3TablePrice = (Double)Convert.ToDecimal((productItem.Category3TablePrice / (1 + vat)));
//productItem.MRetailPrice = (Double)Convert.ToDecimal((productItem.MRetailPrice / (1 + vat)));
//productItem.Category3TakeAwayPrice = (Double)Convert.ToDecimal((productItem.Category3TakeAwayPrice / (1 + vat)));
//productItem.MWholeSalePrice = (Double)Convert.ToDecimal((productItem.MWholeSalePrice / (1 + vat)));
//productItem.Category3BarPrice = (Double)Convert.ToDecimal((productItem.Category3BarPrice / (1 + vat)));
//productItem.MLastPurchasePrice = (Double)Convert.ToDecimal((productItem.MLastPurchasePrice / (1 + vat)));
#endif
//productItem.Category3TablePrice = (Double) Convert.ToDecimal((productItem.Category3TablePrice / (1 + vat)));
//productItem.RetailPrice = (Double)Convert.ToDecimal((productItem.RetailPrice / (1 + vat)));
//productItem.Category3TakeAwayPrice = (Double)Convert.ToDecimal((productItem.Category3TakeAwayPrice / (1 + vat)));
//productItem.WholeSalePrice = (Double)Convert.ToDecimal((productItem.WholeSalePrice / (1 + vat)));
//productItem.Category3BarPrice = (Double)Convert.ToDecimal((productItem.Category3BarPrice / (1 + vat)));
//productItem.LastPurchasePrice = (Double)Convert.ToDecimal((productItem.LastPurchasePrice / (1 + vat)));
}
/* end: price */
// active or inactive
//if (rdoActive.Checked)
//{
// productItem.Category3OrderStatus = 1;
//}
//else if (rdoInactive.Checked)
//{
// productItem.Category3OrderStatus = 0;
//}
// stockable
if (chkunstockable.Checked)
{
productItem.MInitialQuantity = 0;
productItem.MUnlimitStatus = 1;
}
else
{
if (cmbSellingIn.SelectedItem.ToString() == "Per Piece" || cmbSellingIn.SelectedItem.ToString() == "")
{
productItem.MInitialQuantity = Convert.ToInt32("0" + txtInitialQuantity.Text);
}
else
{
productItem.MInitialQuantity = Convert.ToInt32("0" + txtInitialQuantity.Text);
}
productItem.MUnlimitStatus = 0;
}
// Item selling : "Per Piece" - Whether the item sold in quantity or weight
productItem.ItemSellingIn = cmbSellingIn.SelectedItem.ToString();
productItem.MBarCode = txtBoxBarcode.Text;
productItem.MUnitsInStock = int.Parse(txtInitialQuantity.Text);
if (cmbSellingIn.SelectedItem.ToString() == "Per Piece" || cmbSellingIn.SelectedItem.ToString() == "")
{
productItem.MUnitsInStock = Convert.ToInt32("0" + txtInitialQuantity.Text);
}
else
{
productItem.MUnitsInStock = Convert.ToInt32("0" + txtInitialQuantity.Text);
}
//non stocablke
productItem.MNonStockable = chkunstockable.Checked;
productItem.MNonTaxableGood = chkNontaxable.Checked;
productItem.MReorderLevel = int.Parse(txtReorderLevel.Text);
//start: UoM
//if (!cmbStanUoM.SelectedValue.ToString().Equals(string.Empty))
//{
// productItem.MStandardUoM = cmbStanUoM.SelectedValue.ToString();
//}
//if (!cmbSalesUoM.SelectedValue.ToString().Equals(string.Empty))
//{
// productItem.MSalesUoM = cmbSalesUoM.SelectedValue.ToString();
// productItem.MQtyPerSaleUint = int.Parse(txtBoxUnitPerSaleUnit.Text);
//}
//else
//{
// productItem.MSalesUoM = cmbStanUoM.SelectedValue.ToString();
// productItem.MQtyPerSaleUint = 1;
//}
//if (!cmbPurUoM.SelectedValue.ToString().Equals(string.Empty))
//{
// productItem.MPurchaseUoM = cmbPurUoM.SelectedValue.ToString();
// productItem.MQtyPerPurchaseUnit = int.Parse(txtBoxUnitPerPurchaseUnit.Text);
//}
//else
//{
// productItem.MPurchaseUoM = cmbStanUoM.SelectedValue.ToString();
// productItem.MQtyPerPurchaseUnit = 1;
//}
if (cmbboxVatIncluded.Visible)
{
productItem.MVatIncluded = !Convert.ToBoolean(cmbboxVatIncluded.SelectedIndex);
}
else
{
productItem.MVatIncluded = false;
}
if (rdbRaw.Checked)
{
productItem.MProductType = rdbRaw.Text;
}
else if (rdbFinished.Checked)
{
productItem.MProductType = rdbFinished.Text;
}
CCategory3DAO cCategory3Dao = new CCategory3DAO();
CResult oResult2 = new CResult();
if (m_iCat3ID > 0)
{
// update new category3
productItem.Category3ID = m_iCat3ID;
oResult2 = cCategory3Dao.Category3Update(productItem, 0);
}
else
{
// add new category3
oResult2 = cCategory3Dao.Category3Insert(productItem);
}
// end: add/update cat3
if (oResult2.IsSuccess)
{
lblSaveStatus.Text = " The product has been Updated successfully.";
lblSaveStatus.Visible = true;
currentStock = Convert.ToDouble(txtInitialQuantity.Text);
}
else
{
lblSaveStatus.Text = "The product can not be Updated. Please try again. ";
lblSaveStatus.Visible = true;
}
}
else
{
lblSaveStatus.Text = objResult.Message;
lblSaveStatus.Visible = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Show existing Data
/// </summary>
private void showExistingData()
{
CCategory3DAO cCategory3Dao = new CCategory3DAO();
objFoodItemUpdate = new CCategory3();
objFoodItemUpdate = cCategory3Dao.GetAllCategory3ByCategory3ID(m_iCat3ID);
CCategoryAncestorDAO cCategoryAncestorDao = new CCategoryAncestorDAO();
CResult oResult = cCategoryAncestorDao.GetCategoryAnchestors(m_iCat3ID, 3);
CCategoryAncestor oCatAnc = (CCategoryAncestor)oResult.Data;
//if (oResult.IsSuccess && oResult.Data != null)
//{
if (objFoodItemUpdate != null)
{
//objFoodItemUpdate = (CCategory3)oResult.Data;
txtProductName.Text = objFoodItemUpdate.Category3Name;
//txtBoxBarcode.Text = objFoodItemUpdate.MBarCode;
txtInitialQuantity.Text = objFoodItemUpdate.MInitialQuantity.ToString();
if (objFoodItemUpdate.MUnlimitStatus == 1)
{
//txtInitialQuantity.Clear();
chkunstockable.Checked = true;
}
else
{
chkunstockable.Checked = false;
//txtInitialQuantity.Text = objFoodItem.InitialItemQuantity.ToString();
}
txtReorderLevel.Text = objFoodItemUpdate.MReorderLevel.ToString();
// txtRetailPrice.Text = objFoodItemUpdate.MRetailPrice.ToString("F02");
txtRetailPrice.Text = objFoodItemUpdate.Category3TablePrice.ToString("F02");
txtDescription.Text = objFoodItemUpdate.Category3Description;
txtInitialQuantity.Text = objFoodItemUpdate.MUnitsInStock.ToString();
currentStock = objFoodItemUpdate.MUnitsInStock;
chkNontaxable.Checked = objFoodItemUpdate.MNonTaxableGood;
if (objFoodItemUpdate.MVatIncluded)
{
#if VATFIXED
cmbboxVatIncluded.SelectedIndex = 0;
txtRetailPrice.Text = objFoodItemUpdate.RetailPrice.ToString("F02");
txtLastPurchasePrice.Text = objFoodItemUpdate.LastPurchasePrice.ToString("F02");
txtWholeSalePrice.Text = objFoodItemUpdate.WholeSalePrice.ToString("F02");
#else
// chbVatIncluded.Checked = true;
// double vat = 1 + Program.vat / 100;
//txtRetailPrice.Text = (objFoodItemUpdate.MRetailPrice * vat).ToString("F02");
//txtLastPurchasePrice.Text = (objFoodItemUpdate.MLastPurchasePrice * vat).ToString("F02");
//txtWholeSalePrice.Text = (objFoodItemUpdate.MWholeSalePrice * vat).ToString("F02");
//txtRetailPrice.Text = (objFoodItemUpdate.Category3TablePrice * vat).ToString("F02");
//txtLastPurchasePrice.Text = (objFoodItemUpdate.Category3TakeAwayPrice * vat).ToString("F02");
//txtWholeSalePrice.Text = (objFoodItemUpdate.Category3BarPrice * vat).ToString("F02");
txtRetailPrice.Text = objFoodItemUpdate.Category3TablePrice.ToString("F02");
txtLastPurchasePrice.Text = objFoodItemUpdate.Category3TakeAwayPrice.ToString("F02");
txtWholeSalePrice.Text = objFoodItemUpdate.Category3BarPrice.ToString("F02");
cmbboxVatIncluded.SelectedIndex = 0;
#endif
}
else
{
// chbVatIncluded.Checked = false;
//txtRetailPrice.Text = objFoodItemUpdate.MRetailPrice.ToString("F02");
//txtLastPurchasePrice.Text = objFoodItemUpdate.MLastPurchasePrice.ToString("F02");
//txtWholeSalePrice.Text = objFoodItemUpdate.MWholeSalePrice.ToString("F02");
txtRetailPrice.Text = objFoodItemUpdate.Category3TablePrice.ToString("F02");
txtLastPurchasePrice.Text = objFoodItemUpdate.Category3TakeAwayPrice.ToString("F02");
txtWholeSalePrice.Text = objFoodItemUpdate.Category3BarPrice.ToString("F02");
cmbboxVatIncluded.SelectedIndex = 1;
}
if (objFoodItemUpdate.Category3OrderStatus > 0) rdoActive.Checked = true;
else rdoInactive.Checked = true;
//if (objFoodItem.ItemSellingIn == "Per Piece") cmbSellingIn.SelectedText = "Per Piece";
//else if (objFoodItem.ItemSellingIn == "Per Weight") cmbSellingIn.SelectedText = "Per Weight";
try
{
cmbSellingIn.SelectedIndex = cmbSellingIn.FindString(objFoodItemUpdate.ItemSellingIn);
cmbStanUoM.SelectedIndex = cmbStanUoM.FindString(objFoodItemUpdate.MStandardUoM);
cmbSalesUoM.SelectedIndex = cmbSalesUoM.FindString(objFoodItemUpdate.MSalesUoM);
cmbPurUoM.SelectedIndex = cmbPurUoM.FindString(objFoodItemUpdate.MPurchaseUoM);
//cmbParent.SelectedValue = oCatAnc.ParentCategoryID;
//cmbFoodType.SelectedValue = oCatAnc.Category2ID;
//cmbCategory.SelectedValue = objFoodItemUpdate.Category3ID;
}
catch (Exception ex)
{
}
}
if (oResult.IsSuccess && oResult.Data != null)
{
int tmpCat3ID = oCatAnc.Category3ID;
int tmpCat2ID = oCatAnc.Category2ID;
int tmpCat1ID = oCatAnc.Category1ID;
int tmpParentCatID = oCatAnc.ParentCategoryID;
if (objFoodItemUpdate.Category3OrderStatus == 1)
{
//m_activeStatus = true;
rdoActive.Checked = true;
}
else if (objFoodItemUpdate.Category3OrderStatus == 0)
{
//rdoInActive.Checked = true;
//m_activeStatus = false;
}
// cmbParent.SelectedValue = tmpParentCatID;
// cmbFoodType.SelectedValue = tmpCat2ID;
// cmbCategory.SelectedValue = tmpCat3ID;
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
StringPrintFormater strPrintFormatter = new StringPrintFormater(40);
DataSet dsSalesRecords = new DataSet();
CResult objResult = new CResult();
SystemManager objSystemMgnr = new SystemManager();
m_htFoods = new Hashtable();
m_htNonFoods = new Hashtable();
DateTime dtStart = new DateTime(dtpStart.Value.Year, dtpStart.Value.Month, dtpStart.Value.Day, 0, 0, 0);
DateTime dtEnd = new DateTime(dtpEnd.Value.Year, dtpEnd.Value.Month, dtpEnd.Value.Day, 23, 59, 59);
//if (chkFromTime.Checked)
//{
dtStart = new DateTime(dtpStart.Value.Year, dtpStart.Value.Month, dtpStart.Value.Day, 7, 0, 0);
dtEnd = new DateTime(dtpEnd.Value.Year, dtpEnd.Value.Month, dtpEnd.Value.Day, 6, 59, 59);
// }
dtEnd = dtEnd.AddDays(1);
objResult = objSystemMgnr.GetSalesRecords(dtStart.Ticks, dtEnd.Ticks);
dsSalesRecords = (DataSet)objResult.Data;
if (dsSalesRecords.Tables.Count > 0 && dsSalesRecords.Tables[0].Rows.Count > 0)
{
Int32 guestCounter = Convert.ToInt32(dsSalesRecords.Tables[0].Rows[0]["guest_count"]);
CPrintMethods tempPrintMethods = new CPrintMethods();
string serialHeader = RMSClientController.CollectHeader();
string serialFooter = RMSClientController.CollectFooter();
List<CSerialPrintContent> serialBody = new List<CSerialPrintContent>();
CSerialPrintContent tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CenterTextWithWhiteSpace("Inventory Sales Report");
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = strPrintFormatter.CenterTextWithWhiteSpace("Date of Consumption of Items");
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = strPrintFormatter.CenterTextWithWhiteSpace("From " + dtpStart.Value.Date.ToString("dd/MM/yyyy") + " To " + dtpEnd.Value.Date.ToString("dd/MM/yyyy"));
serialBody.Add(tempSerialPrintContent);
//tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "No. of Covers:" + guestCounter.ToString() + "\n";
//serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Qty Item Price(£)";
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
SortedList slorderedFoodItems = new SortedList();
SortedList slorderedNonFoodItems = new SortedList();
PrintUtility printUtility = new PrintUtility();
CCategory3DAO category3DAO = new CCategory3DAO();
foreach (DataRow dtRrow in dsSalesRecords.Tables[0].Rows)
{
clsOrderReport objOrderedItems = new clsOrderReport();
string[] returnedValue = GetProductName(dtRrow).Split(':');
// string productName = Convert.ToString(returnedValue[0]);
string cat1ID = Convert.ToString(returnedValue[1]);
objOrderedItems.Quantity = Convert.ToInt32("0" + dtRrow["quantity"].ToString());
// objOrderedItems.ItemName = productName;
string productName = "";
CCategory3 cat3 = category3DAO.GetAllCategory3ByCategory3ID(Convert.ToInt32(dtRrow["product_id"].ToString()));
if (cat3 != null && cat3.Category3Name.Length>0)
{
productName = cat3.Category3Name.Trim();
}
else
{
productName = Convert.ToString(dtRrow["product_Name"].ToString()); // @hafiz
}
objOrderedItems.ItemName = productName; //Convert.ToString(dtRrow["product_Name"].ToString()); //@Hafiz
objOrderedItems.Price = Convert.ToDouble(dtRrow["amount"]);
objOrderedItems.FoodTypeName = Convert.ToString(returnedValue[2]);
Int32 category1OrderNumber = this.GetCategory1OrderNumber(Convert.ToInt32("0" + cat1ID));
objOrderedItems.OrderNumber = category1OrderNumber;
string keyCode = category1OrderNumber + "-" + objOrderedItems.Quantity.ToString() + "-" + objOrderedItems.ItemName;
string tempKey = 99999 + "-" + objOrderedItems.Quantity.ToString() + "-" + objOrderedItems.ItemName; ;
if (Convert.ToString(dtRrow["food_type"]).Equals("Food") && Convert.ToInt16(dtRrow["product_id"]) != 0) //Separate food/nonfoods
{
if (!m_htFoods.ContainsKey(keyCode))
{
m_htFoods.Add(keyCode, objOrderedItems);
}
else
{
clsOrderReport orderReport = m_htFoods[keyCode] as clsOrderReport;
objOrderedItems.Quantity = objOrderedItems.Quantity + orderReport.Quantity;
m_htFoods[keyCode] = objOrderedItems;
}
}
else if (Convert.ToString(dtRrow["product_id"]).Equals("0")) //Separate food/nonfoods
{
// m_htFoods.Add(tempKey, objOrderedItems);
if (!m_htFoods.ContainsKey(tempKey))
{
m_htFoods.Add(tempKey, objOrderedItems);
}
else
{
clsOrderReport orderReport = m_htFoods[tempKey] as clsOrderReport;
objOrderedItems.Quantity = objOrderedItems.Quantity + orderReport.Quantity;
m_htFoods[tempKey] = objOrderedItems;
}
}
else
{
//m_htNonFoods.Add(keyCode, objOrderedItems);
if (!m_htNonFoods.ContainsKey(keyCode))
{
m_htNonFoods.Add(keyCode, objOrderedItems);
}
else
{
clsOrderReport orderReport = m_htNonFoods[keyCode] as clsOrderReport;
objOrderedItems.Quantity = objOrderedItems.Quantity + orderReport.Quantity;
m_htNonFoods[keyCode] = objOrderedItems;
}
}
}
int separatorNumber = -1;
NumericComparer nc = new NumericComparer();
slorderedFoodItems = new SortedList(m_htFoods, nc); //Creating the sorted list from the hash table.
slorderedNonFoodItems = new SortedList(m_htNonFoods, nc);
SortedList slMaster1 = new SortedList();
ArrayList arrListItems = null;
foreach (DictionaryEntry objOrderedItems in slorderedFoodItems)
{
clsOrderReport objItem = (clsOrderReport)objOrderedItems.Value;
string keyValue = objOrderedItems.Key.ToString();
string[] splitter = new string[0];
splitter = keyValue.Split('-');
if (separatorNumber != Convert.ToInt32(splitter[0]))
{
separatorNumber = Convert.ToInt32(splitter[0]);
arrListItems = new ArrayList();
arrListItems.Add(objItem);
slMaster1.Add(separatorNumber, arrListItems);
}
else
{
arrListItems.Add(objItem);
separatorNumber = Convert.ToInt32(splitter[0]);
}
}
ArrayList alReverseOrderedItem;
foreach (DictionaryEntry deReverseOrderedItem in slMaster1)
{
alReverseOrderedItem = (ArrayList)deReverseOrderedItem.Value;
alReverseOrderedItem.Reverse();//Reversing the current item order.
foreach (clsOrderReport objOrderedItems in alReverseOrderedItem)
{
if (separatorNumber != objOrderedItems.OrderNumber)
{
//tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "----------------------------------------";
//serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = objOrderedItems.FoodTypeName + ":";
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine += objOrderedItems.Quantity.ToString() + " ";
tempSerialPrintContent.ISAlredyNewLine = true;
// tempSerialPrintContent.StringLine += CPrintMethods.GetFixedString(objOrderedItems.ItemName, 30);
// tempSerialPrintContent.StringLine += CPrintMethods.RightAlign(objOrderedItems.Price.ToString("F02"), 6);
tempSerialPrintContent.StringLine += printUtility.MultipleLine(objOrderedItems.ItemName, 30,
objOrderedItems.Price.ToString("F02"), 37);
serialBody.Add(tempSerialPrintContent);
separatorNumber = objOrderedItems.OrderNumber;
}
else
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine += objOrderedItems.Quantity.ToString() + " ";
// tempSerialPrintContent.StringLine += CPrintMethods.GetFixedString(objOrderedItems.ItemName, 30);
// tempSerialPrintContent.StringLine += CPrintMethods.RightAlign(objOrderedItems.Price.ToString("F02"), 6);
tempSerialPrintContent.StringLine += printUtility.MultipleLine(objOrderedItems.ItemName, 30,
objOrderedItems.Price.ToString("F02"), 37);
tempSerialPrintContent.ISAlredyNewLine = true;
serialBody.Add(tempSerialPrintContent);
}
}
}
#region "Non food items"
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "-----------------Drinks-----------------";
serialBody.Add(tempSerialPrintContent);
SortedList slMaster2 = new SortedList();
ArrayList arrListItemsNonFood = new ArrayList();
separatorNumber = -1;
foreach (DictionaryEntry objOrderedNonFood in slorderedNonFoodItems)
{
clsOrderReport objItem = (clsOrderReport)objOrderedNonFood.Value;
string keyValue = objOrderedNonFood.Key.ToString();
string[] splitter = new string[0];
splitter = keyValue.Split('-');
if (separatorNumber != Convert.ToInt32(splitter[0]))
{
separatorNumber = Convert.ToInt32(splitter[0]);
arrListItemsNonFood = new ArrayList();
arrListItemsNonFood.Add(objItem);
slMaster2.Add(separatorNumber, arrListItemsNonFood);
}
else
{
arrListItemsNonFood.Add(objItem);
separatorNumber = Convert.ToInt32(splitter[0]);
}
}
separatorNumber = -1;
foreach (DictionaryEntry objNonFood in slMaster2)
{
ArrayList alNonFoods = (ArrayList)objNonFood.Value;
alNonFoods.Reverse();
foreach (clsOrderReport objNonFoodItem in alNonFoods)
{
if (separatorNumber != objNonFoodItem.OrderNumber)
{
//tempSerialPrintContent = new CSerialPrintContent();
//// tempSerialPrintContent.StringLine = "----------------------------------------";
//serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine += objNonFoodItem.Quantity.ToString() + " ";
// tempSerialPrintContent.StringLine += CPrintMethods.GetFixedString(objNonFoodItem.ItemName, 30);
// tempSerialPrintContent.StringLine += CPrintMethods.RightAlign(objNonFoodItem.Price.ToString("F02"), 6);
tempSerialPrintContent.StringLine += printUtility.MultipleLine(objNonFoodItem.ItemName, 30,
objNonFoodItem.Price.ToString("F02"), 37);
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent.ISAlredyNewLine = true;
separatorNumber = objNonFoodItem.OrderNumber;
}
else
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine += objNonFoodItem.Quantity.ToString() + " ";
// tempSerialPrintContent.StringLine += CPrintMethods.GetFixedString(objNonFoodItem.ItemName, 30);
// tempSerialPrintContent.StringLine += CPrintMethods.RightAlign(objNonFoodItem.Price.ToString("F02"), 6);
tempSerialPrintContent.StringLine += printUtility.MultipleLine(objNonFoodItem.ItemName, 30,
objNonFoodItem.Price.ToString("F02"), 37);
tempSerialPrintContent.ISAlredyNewLine = true;
serialBody.Add(tempSerialPrintContent);
}
}
}
#endregion
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = strPrintFormatter.CreateDashedLine();// "----------------------------------------";
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Total No Of Item: " + lblNoOfItemsSold.Text;
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Total Qty: " + lblTotalQty.Text;
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Total Item Amount: " + lblTotalAmount.Text;
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = strPrintFormatter.CreateDashedLine();
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = strPrintFormatter.CenterTextWithWhiteSpace("Developed By: www.ibacs.co.uk") + "\r\n\n";
serialBody.Add(tempSerialPrintContent);
#region "Testing printing area"
string printingObject = "";
for (int arrayIndex = 0; arrayIndex < serialBody.Count; arrayIndex++)
{
if (serialBody[arrayIndex].ISAlredyNewLine)
{
printingObject += serialBody[arrayIndex].StringLine.ToString() ;
}
else
{
printingObject += serialBody[arrayIndex].StringLine.ToString() + "\r\n";
}
}
this.WriteString(printingObject);///Write to a file when print command is executed
#endregion
A4Text = printingObject;
CPrintMethodsEXT tempPrintMethods1 = new CPrintMethodsEXT();
DataSet tempDataSet = new DataSet();
tempDataSet.ReadXml("Config/Print_Config.xml");
if (dataGridView1.Rows.Count > 0)
if (Convert.ToBoolean(tempDataSet.Tables[0].Rows[0]["IsGuestBillPrinterSerial"]) == true)
{
// tempPrintMethods.SerialPrint(PRINTER_TYPES.NORMAL_PRINTER, serialHeader, serialBody, serialFooter, "SN".ToString());
tempPrintMethods.SerialPrint(PRINTER_TYPES.NORMAL_PRINTER, serialHeader, printingObject, serialFooter, "SN".ToString());
}
else
{
tempPrintMethods1.USBPrint(printingObject, PrintDestiNation.CLIENT, true);
}
else
{
MessageBox.Show("There is no record", RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("There is no record", RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnPrintSummary_Click(object sender, EventArgs e)
{
m_htFoods = new Hashtable();
m_htNonFoods = new Hashtable();
// FormatDataTime();
DataSet dsSalesRecords = new DataSet();
CResult objResult = new CResult();
SystemManager objSystemMgnr = new SystemManager();
DateTime dtNow = DateTime.Now;
DateTime dtStart = new DateTime(dtNow.Year, dtNow.Month, dtNow.Day, 0, 0, 0);
DateTime dtEnd = new DateTime(dtNow.Year, dtNow.Month, dtNow.Day, 23, 59, 59);
//if (chkFromTime.Checked)
//{
dtStart = new DateTime(dtStart.Year, dtStart.Month, dtStart.Day, 7, 0, 0);
dtEnd = new DateTime(dtEnd.Year, dtEnd.Month, dtEnd.Day, 6, 59, 59);
// }
dtEnd = dtEnd.AddDays(1);
objResult = objSystemMgnr.GetSalesRecordsForINV(dtStart.Ticks, dtEnd.Ticks);
StringPrintFormater strPrintFormatter = new StringPrintFormater(40);
DataTable dt = (DataTable)objResult.Data;
tableReport = new DataTable();
tableReport.Columns.Add("product_id", typeof(int));
tableReport.Columns.Add("product_Name", typeof(string));
tableReport.Columns.Add("amount", typeof(string));
tableReport.Columns.Add("quantity", typeof(string));
tableReport.Columns.Add("TotalAmount", typeof(string));
tableReport.Columns.Add("guest_count", typeof(int));
tableReport.Columns.Add("cat_level", typeof(int));
tableReport.Columns.Add("food_type", typeof(string));
if (dt != null || dt.Rows.Count > 0)
for (int i = 0; i < dt.Rows.Count; i++)
{
tableReport.Rows.Add(Convert.ToInt16(dt.Rows[i]["product_id"]), Convert.ToString(dt.Rows[i]["product_Name"]), dt.Rows[i]["amount"].ToString(), dt.Rows[i]["quantity"].ToString(), dt.Rows[i]["TotalAmount"].ToString(), Convert.ToInt16(dt.Rows[i]["guest_count"]), Convert.ToInt16(dt.Rows[i]["cat_level"]), dt.Rows[i]["food_type"].ToString());
}
if (dataGridView1.Rows.Count > 0)
if (tableReport.Rows.Count > 0)
{
// Int32 guestCounter = Convert.ToInt32(dsSalesRecords.Tables[0].Rows[0]["guest_count"]);
Int32 guestCounter = Convert.ToInt32(tableReport.Rows[0]["guest_count"]);
CPrintMethods tempPrintMethods = new CPrintMethods();
string serialHeader = RMSClientController.CollectHeader();
string serialFooter = RMSClientController.CollectFooter();
List<CSerialPrintContent> serialBody = new List<CSerialPrintContent>();
CSerialPrintContent tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "\r\n" + strPrintFormatter.CenterTextWithWhiteSpace("Inventory Sales Report") + "\r\n";
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = strPrintFormatter.CenterTextWithWhiteSpace("Date of Consumption of Items:" + DateTime.Now.ToString("dd/MM/yyyy")) + "\r\n";
serialBody.Add(tempSerialPrintContent);
//tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = "No. of Covers:" + guestCounter.ToString() + "\n";
//serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = strPrintFormatter.CreateDashedLine() +"\r\n";
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Qty Item Price(£)"+"\r\n";
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = strPrintFormatter.CreateDashedLine() + "\r\n";
serialBody.Add(tempSerialPrintContent);
CCategory3DAO category3DAO = new CCategory3DAO();
SortedList slorderedFoodItems = new SortedList();
SortedList slorderedNonFoodItems = new SortedList();
//if (dsSalesRecords.Tables[0].Rows.Count > 0)
if (tableReport.Rows.Count > 0)
{
// foreach (DataRow dtRrow in dsSalesRecords.Tables[0].Rows)
foreach (DataRow dtRrow in tableReport.Rows)
{
clsOrderReport objOrderedItems = new clsOrderReport();
string[] returnedValue = GetProductName(dtRrow).Split(':');
// string productName = Convert.ToString(returnedValue[0]);
string productName = "";
CCategory3 cat3 = category3DAO.GetAllCategory3ByCategory3ID(Convert.ToInt32(dtRrow["product_id"].ToString()));
if (cat3 != null && cat3.Category3Name.Length>0)
{
productName = cat3.Category3Name;
}
else
{
productName = Convert.ToString(dtRrow["product_Name"].ToString()); // @hafiz
}
string cat1ID = Convert.ToString(returnedValue[1]);
objOrderedItems.Quantity = Convert.ToInt32("0" + dtRrow["quantity"].ToString());
objOrderedItems.ItemName = productName;
objOrderedItems.Price = Convert.ToDouble(dtRrow["TotalAmount"]);
objOrderedItems.FoodTypeName = Convert.ToString(returnedValue[2]);
Int32 category1OrderNumber = 0;
if (cat1ID != "")
{
category1OrderNumber = this.GetCategory1OrderNumber(Convert.ToInt32(cat1ID));
objOrderedItems.OrderNumber = category1OrderNumber;
string keyCode = category1OrderNumber + "-" + objOrderedItems.Quantity.ToString() + "-" + objOrderedItems.ItemName;
if (Convert.ToString(dtRrow["food_type"]).Equals("Food")) //Separate food/nonfoods
{
m_htFoods.Add(keyCode, objOrderedItems);
}
else
{
m_htNonFoods.Add(keyCode, objOrderedItems);
}
}
else
{
category1OrderNumber = maxOrder + 1;
objOrderedItems.OrderNumber = category1OrderNumber;
string keyCode = category1OrderNumber + "-" + objOrderedItems.Quantity.ToString() + "-" + objOrderedItems.ItemName;
if (Convert.ToString(dtRrow["food_type"]).Equals("Food")) //Separate food/nonfoods
{
m_htFoods.Add(keyCode, objOrderedItems);
}
else
{
m_htNonFoods.Add(keyCode, objOrderedItems);
}
}
}
int separatorNumber = -1;
NumericComparer nc = new NumericComparer();
slorderedFoodItems = new SortedList(m_htFoods, nc); //Creating the sorted list from the hash table.
slorderedNonFoodItems = new SortedList(m_htNonFoods, nc);
SortedList slMaster1 = new SortedList();
ArrayList arrListItems = null;
foreach (DictionaryEntry objOrderedItems in slorderedFoodItems)
{
clsOrderReport objItem = (clsOrderReport)objOrderedItems.Value;
string keyValue = objOrderedItems.Key.ToString();
string[] splitter = new string[0];
splitter = keyValue.Split('-');
if (separatorNumber != Convert.ToInt32(splitter[0]))
{
separatorNumber = Convert.ToInt32(splitter[0]);
arrListItems = new ArrayList();
arrListItems.Add(objItem);
slMaster1.Add(separatorNumber, arrListItems);
}
else
{
arrListItems.Add(objItem);
separatorNumber = Convert.ToInt32(splitter[0]);
}
}
PrintUtility printUtility = new PrintUtility();
ArrayList alReverseOrderedItem;
foreach (DictionaryEntry deReverseOrderedItem in slMaster1)
{
alReverseOrderedItem = (ArrayList)deReverseOrderedItem.Value;
alReverseOrderedItem.Reverse();//Reversing the current item order.
foreach (clsOrderReport objOrderedItems in alReverseOrderedItem)
{
if (separatorNumber != objOrderedItems.OrderNumber)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = objOrderedItems.FoodTypeName + ":" +"\r\n";
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine += objOrderedItems.Quantity.ToString() + " ";
//tempSerialPrintContent.StringLine += CPrintMethods.GetFixedString(objOrderedItems.ItemName, 30);
//tempSerialPrintContent.StringLine += CPrintMethods.RightAlign(objOrderedItems.Price.ToString("F02"), 6);
tempSerialPrintContent.StringLine = strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " " +
printUtility.MultipleLine(objOrderedItems.ItemName, 32,
objOrderedItems.Price.ToString("F02"), 37), "");
serialBody.Add(tempSerialPrintContent);
separatorNumber = objOrderedItems.OrderNumber;
}
else
{
tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine += objOrderedItems.Quantity.ToString() + " ";
//tempSerialPrintContent.StringLine += CPrintMethods.GetFixedString(objOrderedItems.ItemName, 30);
//tempSerialPrintContent.StringLine += CPrintMethods.RightAlign(objOrderedItems.Price.ToString("F02"), 6);
tempSerialPrintContent.StringLine = strPrintFormatter.ItemLabeledText(objOrderedItems.Quantity.ToString() + " " +
printUtility.MultipleLine(objOrderedItems.ItemName, 32,
objOrderedItems.Price.ToString("F02"), 37), "");
serialBody.Add(tempSerialPrintContent);
}
}
}
#region "Non food items"
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = strPrintFormatter.CenterTextWithDashed("Drinks") + "\r\n";
// tempSerialPrintContent.StringLine = "-----------------Drinks-----------------" + "\r\n";
serialBody.Add(tempSerialPrintContent);
SortedList slMaster2 = new SortedList();
ArrayList arrListItemsNonFood = new ArrayList();
separatorNumber = -1;
foreach (DictionaryEntry objOrderedNonFood in slorderedNonFoodItems)
{
clsOrderReport objItem = (clsOrderReport)objOrderedNonFood.Value;
string keyValue = objOrderedNonFood.Key.ToString();
string[] splitter = new string[0];
splitter = keyValue.Split('-');
if (separatorNumber != Convert.ToInt32(splitter[0]))
{
separatorNumber = Convert.ToInt32(splitter[0]);
arrListItemsNonFood = new ArrayList();
arrListItemsNonFood.Add(objItem);
slMaster2.Add(separatorNumber, arrListItemsNonFood);
}
else
{
arrListItemsNonFood.Add(objItem);
separatorNumber = Convert.ToInt32(splitter[0]);
}
}
separatorNumber = -1;
bool istrue = false;
foreach (DictionaryEntry objNonFood in slMaster2)
{
ArrayList alNonFoods = (ArrayList)objNonFood.Value;
alNonFoods.Reverse();
foreach (clsOrderReport objNonFoodItem in alNonFoods)
{
if (separatorNumber != objNonFoodItem.OrderNumber)
{
tempSerialPrintContent = new CSerialPrintContent();
// tempSerialPrintContent.StringLine = "----------------------------------------";
serialBody.Add(tempSerialPrintContent);
if (tempSerialPrintContent != null && tempSerialPrintContent.StringLine.Equals("") && !istrue)
{
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = objNonFoodItem.FoodTypeName + ":" +"\r\n";
serialBody.Add(tempSerialPrintContent);
}
tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine += objNonFoodItem.Quantity.ToString() + " ";
//tempSerialPrintContent.StringLine += CPrintMethods.GetFixedString(objNonFoodItem.ItemName, 30);
//tempSerialPrintContent.StringLine += CPrintMethods.RightAlign(objNonFoodItem.Price.ToString("F02"), 6);
tempSerialPrintContent.StringLine = strPrintFormatter.ItemLabeledText(objNonFoodItem.Quantity.ToString() + " " +
printUtility.MultipleLine(objNonFoodItem.ItemName, 32,
objNonFoodItem.Price.ToString("F02"), 37), "");
serialBody.Add(tempSerialPrintContent);
separatorNumber = objNonFoodItem.OrderNumber;
istrue = true;
}
else
{
tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine += objNonFoodItem.Quantity.ToString() + " ";
//tempSerialPrintContent.StringLine += CPrintMethods.GetFixedString(objNonFoodItem.ItemName, 30);
//tempSerialPrintContent.StringLine += CPrintMethods.RightAlign(objNonFoodItem.Price.ToString("F02"), 6);
tempSerialPrintContent.StringLine = strPrintFormatter.ItemLabeledText(objNonFoodItem.Quantity.ToString() + " " +
printUtility.MultipleLine(objNonFoodItem.ItemName, 32,
objNonFoodItem.Price.ToString("F02"), 37), "");
serialBody.Add(tempSerialPrintContent);
}
}
}
#endregion
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "----------------------------------------\r\n";
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Total No Of Item: " + lblNoOfItemsSold.Text + "\r\n";
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Total Qty: " + lblTotalQty.Text + "\r\n";
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = "Total Item Amount: " + lblTotalAmount.Text + "\r\n";
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
tempSerialPrintContent.StringLine = strPrintFormatter.CreateDashedLine() + "\r\n";
serialBody.Add(tempSerialPrintContent);
tempSerialPrintContent = new CSerialPrintContent();
//tempSerialPrintContent.StringLine = strPrintFormatter.CenterTextWithWhiteSpace("Developed By: www.ibacs.co.uk") + "\r\n\n";
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
//@aamr Remote Print
CCommonConstants m_oCommonConstants;
m_oCommonConstants = ConfigManager.GetConfig<CCommonConstants>();
CLogin oLogin = new CLogin();
oLogin = (RmsRemote.CLogin)Activator.GetObject(typeof(RmsRemote.CLogin), m_oCommonConstants.RemoteURL);
CResult oResult = oLogin.GetInitialDBStr();
Object o = oLogin.GetType();
CPrintingFormat inPrintRequest = new CPrintingFormat();
inPrintRequest.Header = "Header";
inPrintRequest.Footer = "Footer";
inPrintRequest.Body = "Hello Remote Printing...";
try
{
oLogin.PostPrintingRequest(inPrintRequest);
PostPrintingRequest1(inPrintRequest);
}
catch (Exception ex)
{
}
CPrintMethodsEXT tempPrintMethods1 = new CPrintMethodsEXT();
DataSet tempDataSet = new DataSet();
tempDataSet.ReadXml("Config/Print_Config.xml");
if (Convert.ToBoolean(tempDataSet.Tables[0].Rows[0]["IsGuestBillPrinterSerial"]) == true)
{
// tempPrintMethods.SerialPrint(PRINTER_TYPES.NORMAL_PRINTER, serialHeader, serialBody, serialFooter, "SN".ToString());
tempPrintMethods.SerialPrint(PRINTER_TYPES.NORMAL_PRINTER, serialHeader, printingObject, serialFooter, "SN".ToString());
}
else
{
tempPrintMethods1.USBPrint(printingObject, PrintDestiNation.CLIENT, true);
}
}
}
else
{
MessageBox.Show("There is no record", RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
