private static void Init()
{
ConfigManager.Init();
ConfigManager.ReloadConfig();
CCommonConstants oTempConstant = ConfigManager.GetConfig<CCommonConstants>();
CDalConfig oTempDal = ConfigManager.GetConfig<CDalConfig>();
CLogin oLogin = new CLogin();
oLogin = (RmsRemote.CLogin)Activator.GetObject(typeof(RmsRemote.CLogin), oTempConstant.RemoteURL);
CResult oResult = oLogin.GetInitialDBStr();
if (oResult.IsSuccess && oResult.Data != null)
{
DataSet dsRecords = new DataSet();
String oTempStr = (String)oResult.Data;
oTempConstant.DBConnection = oTempStr;
RMSGlobal.m_serverConnectionString = oTempConstant.DBConnection;
CReportManager objReportMgnr = new CReportManager();
CResult objFoodType = objReportMgnr.GetFoodTypesRecords();
dsRecords = (DataSet)objFoodType.Data;
m_foodTypeRecords=dsRecords.Tables[0];
objFoodType = objReportMgnr.GetFoodCategoryRecords();
dsRecords = (DataSet)objFoodType.Data;
m_categoryRecords= dsRecords.Tables[0];
objFoodType = objReportMgnr.GetFoodItemRecords();
dsRecords = (DataSet)objFoodType.Data;
m_foodItemRecords= dsRecords.Tables[0];
objFoodType = objReportMgnr.GetSelectionofItemsRecords();
dsRecords = (DataSet)objFoodType.Data;
m_selectionItemRecords=dsRecords.Tables[0];
//m_initDataSet.Relations.Add("category1_to_category2",
// m_foodTypeRecords.Columns["cat1_id"],
// m_categoryRecords.Columns["cat1_id"], false);
}
}
private static void Init()
{
//Starting sub version
try
{
startScreen.loadingtext.Text = "Loading configuration...";
ConfigurationClass obj = new ConfigurationClass();
initDataSet = new DataSet();
ConfigManager.Init();
ConfigManager.ReloadConfig();
CCommonConstants oTempConstant = ConfigManager.GetConfig<CCommonConstants>();
CDalConfig oTempDal = ConfigManager.GetConfig<CDalConfig>();
startScreen.loadingtext.Text = "Connecting remote objects...";
CLogin oLogin = new CLogin();
oLogin = (RmsRemote.CLogin)Activator.GetObject(typeof(RmsRemote.CLogin), oTempConstant.RemoteURL);
startScreen.loadingtext.Text = "Loading inistal dataset...";
CResult oResult = oLogin.GetInitialDBStr();
if (oResult.IsSuccess && oResult.Data != null)
{
String oTempStr = (String)oResult.Data;
oTempConstant.DBConnection = oTempStr;
oTempDal.ConnectionString = oTempStr;
String ConnectionString = oTempConstant.DBConnection;
SqlDataAdapter tempSqlDataAdapter = new SqlDataAdapter(SqlQueries.GetQuery(Query.ButtonAccessGetAll), ConnectionString);
tempSqlDataAdapter.Fill(initDataSet, "ButtonAccess");
tempSqlDataAdapter.Dispose();
SqlDataAdapter tempSqlDataAdapter2 = new SqlDataAdapter(SqlQueries.GetQuery(Query.ButtonColorGetAll), ConnectionString);
tempSqlDataAdapter2.Fill(initDataSet, "ButtonColor");
tempSqlDataAdapter2.Dispose();
SqlDataAdapter tempSqlDataAdapter3 = new SqlDataAdapter(SqlQueries.GetQuery(Query.ParentCategoryGetAll), ConnectionString);
tempSqlDataAdapter3.Fill(initDataSet, "ParentCategory");
tempSqlDataAdapter3.Dispose();
SqlDataAdapter tempSqlDataAdapter4 = new SqlDataAdapter(SqlQueries.GetQuery(Query.Category1GetAll), ConnectionString);
tempSqlDataAdapter4.Fill(initDataSet, "Category1");
tempSqlDataAdapter4.Dispose();
SqlDataAdapter tempSqlDataAdapter5 = new SqlDataAdapter(SqlQueries.GetQuery(Query.Category2GetAll), ConnectionString);
tempSqlDataAdapter5.Fill(initDataSet, "Category2");
tempSqlDataAdapter5.Dispose();
SqlDataAdapter tempSqlDataAdapter6 = new SqlDataAdapter(SqlQueries.GetQuery(Query.Category3GetAll), ConnectionString);
tempSqlDataAdapter6.Fill(initDataSet, "Category3");
tempSqlDataAdapter6.Dispose();
SqlDataAdapter tempSqlDataAdapter7 = new SqlDataAdapter(SqlQueries.GetQuery(Query.Category4GetAll), ConnectionString);
tempSqlDataAdapter7.Fill(initDataSet, "Category4");
tempSqlDataAdapter7.Dispose();
SqlDataAdapter tempSqlDataAdapter8 = new SqlDataAdapter(SqlQueries.GetQuery(Query.GetGeneralSetting), ConnectionString);
tempSqlDataAdapter8.Fill(initDataSet, "GeneralSettings");
tempSqlDataAdapter8.Dispose();
vat = Convert.ToDouble(initDataSet.Tables["GeneralSettings"].Rows[0]["vat_amount"].ToString());
isVatEnabled = Convert.ToBoolean(Program.initDataSet.Tables["GeneralSettings"].Rows[0]["vat_enabled"].ToString());
currency =initDataSet.Tables["GeneralSettings"].Rows[0]["currency"].ToString();
initDataSet.Relations.Add("parent_category_to_category1",
initDataSet.Tables["ParentCategory"].Columns["parent_cat_id"],
initDataSet.Tables["Category1"].Columns["parent_cat_id"], false);
initDataSet.Relations.Add("category1_to_category2",
initDataSet.Tables["Category1"].Columns["cat1_id"],
initDataSet.Tables["Category2"].Columns["cat1_id"], false);
initDataSet.Relations.Add("category2_to_category3",
initDataSet.Tables["Category2"].Columns["cat2_id"],
initDataSet.Tables["Category3"].Columns["cat2_id"], false);
initDataSet.Relations.Add("category3_to_category4",
initDataSet.Tables["Category3"].Columns["cat3_id"],
initDataSet.Tables["Category4"].Columns["cat3_id"], false);
initDataSet.Relations.Add("button_color_to_button_access",
initDataSet.Tables["ButtonColor"].Columns["button_id"],
initDataSet.Tables["ButtonAccess"].Columns["button_id"], false);
GetPrinterCommands();
}
else
{
MessageBox.Show("Could not login.", RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message, RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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);
}
}