public static void UpdateCompletedTransView()
{
int iIndex;
string sQuery;
OleDbCommand dbCmd;
OleDbDataReader drRecordSet;
/* SqlCommand dbCmd;
* SqlDataReader drRecordSet;*/
DB.TransStruct myTransStruct;
Debug.WriteLine("UPDATE COMPLETE TRANSACTIONS VIEW");
SQL_SERVER.Set_Sql_Server_Conn();
SQL_SERVER.Open_Sql_Server_Conn();
//sQuery = "SELECT COMPLETED_TIME, PIC, PUMP, DEPOSIT, PURCHASE, PRICE, CHANGE, GRADE, VOLUME, SHOW_TIME, TRAN_ID FROM TRANSACTIONS ORDER BY COMPLETED_TIME DESC";
sQuery = "SELECT COMPLETED_TIME, PIC, PUMP, DEPOSIT, PURCHASE, PRICE, GRADE, VOLUME, SHOW_TIME, TRAN_ID,CHANGE FROM TRANSACTIONS ORDER BY COMPLETED_TIME DESC;";
dbCmd = SQL_SERVER.Set_Sql_Server_Cmd(sQuery);
drRecordSet = dbCmd.ExecuteReader();
Debug.WriteLine(sQuery);
Debug.WriteLine(drRecordSet.HasRows);
iCount = 0;
DB.lCompletedTrans.Clear();
while (drRecordSet.Read())
{
myTransStruct.sPIC = drRecordSet["PIC"].ToString();
myTransStruct.sPump = drRecordSet["PUMP"].ToString();
myTransStruct.sDeposit = drRecordSet["DEPOSIT"].ToString();
myTransStruct.sPurchase = drRecordSet["PURCHASE"].ToString();
myTransStruct.sPrice = drRecordSet["PRICE"].ToString();
myTransStruct.sChange = drRecordSet["CHANGE"].ToString();
myTransStruct.sGrade = drRecordSet["GRADE"].ToString();
myTransStruct.sVolume = drRecordSet["VOLUME"].ToString();
myTransStruct.sShowTime = drRecordSet["SHOW_TIME"].ToString();
myTransStruct.sTranId = drRecordSet["TRAN_ID"].ToString();
DB.lCompletedTrans.Add(myTransStruct);
iCount++;
}
for (iIndex = 0; iIndex < 6; iIndex++)
{
if (iIndex < iCount)
{
tv.pump_no.Text = DB.lCompletedTrans[iIndex].sPump.ToString();
Transactions_View.Update_Transactions_ButtonText(iIndex + 1, "PUMP: " + DB.lCompletedTrans[iIndex].sPump + " @ " + DB.lCompletedTrans[iIndex].sShowTime + " PAID: $" + DB.lCompletedTrans[iIndex].sDeposit + " \nCHANGE: $" + DB.lCompletedTrans[iIndex].sChange);
}
}
dbCmd.Dispose();
drRecordSet.Dispose();
SQL_SERVER.Close_Sql_Sever_Conn();
}
private void SetTransactionsDetails(string transac_id)
{
IsPrintable = true;
OleDbCommand dbCmd;
OleDbDataReader drRecordSet;
SQL_SERVER.Set_Sql_Server_Conn();
SQL_SERVER.Open_Sql_Server_Conn();
//sQuery = "SELECT COMPLETED_TIME, PIC, PUMP, DEPOSIT, PURCHASE, PRICE, CHANGE, GRADE, VOLUME, SHOW_TIME, TRAN_ID FROM TRANSACTIONS ORDER BY COMPLETED_TIME DESC";
string sQuery = "SELECT PUMP, DEPOSIT,PURCHASE, VOLUME, SHOW_TIME, TRAN_ID,CHANGE FROM TRANSACTIONS WHERE TRAN_ID LIKE '%" + transac_id + "%' ORDER BY COMPLETED_TIME DESC;";
dbCmd = SQL_SERVER.Set_Sql_Server_Cmd(sQuery);
drRecordSet = dbCmd.ExecuteReader();
Debug.WriteLine(sQuery);
Debug.WriteLine(drRecordSet.HasRows);
if (drRecordSet.HasRows)
{
while (drRecordSet.Read())
{
pump_no.Text = drRecordSet["PUMP"].ToString();
deposit.Text = drRecordSet["DEPOSIT"].ToString() + "$";
change.Text = drRecordSet["CHANGE"].ToString() + "$";
gal.Text = drRecordSet["VOLUME"].ToString() + " gal";
date_time.Text = drRecordSet["SHOW_TIME"].ToString();
var cultureInfo = new System.Globalization.CultureInfo("en-US");
double purchage = Convert.ToDouble(drRecordSet["PURCHASE"].ToString(), cultureInfo);
double deposite = Convert.ToDouble(drRecordSet["DEPOSIT"].ToString(), cultureInfo);
total.Text = (deposite - purchage).ToString();
}
dbCmd.Dispose();
drRecordSet.Dispose();
SQL_SERVER.Close_Sql_Sever_Conn();
}
}
private void GetChooseTransations(string datetimeformate)
{
int iIndex;
string sQuery;
OleDbCommand dbCmd;
OleDbDataReader drRecordSet;
/* SqlCommand dbCmd;
* SqlDataReader drRecordSet;*/
DB.TransStruct myTransStruct;
Debug.WriteLine("UPDATE COMPLETE TRANSACTIONS VIEW");
SQL_SERVER.Set_Sql_Server_Conn();
SQL_SERVER.Open_Sql_Server_Conn();
//sQuery = "SELECT COMPLETED_TIME, PIC, PUMP, DEPOSIT, PURCHASE, PRICE, CHANGE, GRADE, VOLUME, SHOW_TIME, TRAN_ID FROM TRANSACTIONS ORDER BY COMPLETED_TIME DESC";
sQuery = "SELECT COMPLETED_TIME, PIC, PUMP, DEPOSIT, PURCHASE, PRICE, GRADE, VOLUME, SHOW_TIME, TRAN_ID,CHANGE FROM TRANSACTIONS WHERE SHOW_TIME LIKE '%" + datetimeformate + "%' ORDER BY COMPLETED_TIME DESC;";
dbCmd = SQL_SERVER.Set_Sql_Server_Cmd(sQuery);
drRecordSet = dbCmd.ExecuteReader();
Debug.WriteLine(sQuery);
Debug.WriteLine(drRecordSet.HasRows);
if (drRecordSet.HasRows)
{
iCount = 0;
DB.lCompletedTrans.Clear();
ClearButtonTexts();
ClearSelection();
ClearTransactionsDetails();
while (drRecordSet.Read())
{
myTransStruct.sPIC = drRecordSet["PIC"].ToString();
myTransStruct.sPump = drRecordSet["PUMP"].ToString();
myTransStruct.sDeposit = drRecordSet["DEPOSIT"].ToString();
myTransStruct.sPurchase = drRecordSet["PURCHASE"].ToString();
myTransStruct.sPrice = drRecordSet["PRICE"].ToString();
myTransStruct.sChange = drRecordSet["CHANGE"].ToString();
myTransStruct.sGrade = drRecordSet["GRADE"].ToString();
myTransStruct.sVolume = drRecordSet["VOLUME"].ToString();
myTransStruct.sShowTime = drRecordSet["SHOW_TIME"].ToString();
myTransStruct.sTranId = drRecordSet["TRAN_ID"].ToString();
DB.lCompletedTrans.Add(myTransStruct);
iCount++;
}
for (iIndex = 0; iIndex < 6; iIndex++)
{
if (iIndex < iCount)
{
Update_Transactions_ButtonText(iIndex + 1, "PUMP: " + DB.lCompletedTrans[iIndex].sPump + " @ " + DB.lCompletedTrans[iIndex].sShowTime + " PAID: $" + DB.lCompletedTrans[iIndex].sDeposit + "\nCHANGE: $" + DB.lCompletedTrans[iIndex].sChange);
}
}
iPage = 1;
if (DB.lCompletedTrans.Count <= 6 * iPage)
{
ButtonVisibility(next_btn, false);
}
if (DB.lCompletedTrans.Count >= 6 * iPage)
{
ButtonVisibility(next_btn, true);
}
}
else
{
Display.ShowMessageBox("Not Available Selected date Transations \n Showing All Available Transactions", 6);
}
dbCmd.Dispose();
drRecordSet.Dispose();
SQL_SERVER.Close_Sql_Sever_Conn();
}
private void Config_AutoEOD()
{
//throw new NotImplementedException();
//FileAccess.ReadSettings();
String QueryStr;
OleDbCommand cmd;
OleDbDataReader dbr;
try
{
QueryStr = "select *from Auto_EOD_Config";
SQL_SERVER.Set_Sql_Server_Conn();
SQL_SERVER.Open_Sql_Server_Conn();
cmd = SQL_SERVER.Set_Sql_Server_Cmd(QueryStr);
dbr = cmd.ExecuteReader();
if (dbr.HasRows)
{
while (dbr.Read())
{
EODStatus = dbr["AUTOEOD"].ToString();
HOURS = dbr["HOURS"].ToString();
MINUTES = dbr["MINUTES"].ToString();
INTERVAL = dbr["INTERVAL"].ToString();
}
cmd.Dispose();
dbr.Dispose();
SetDataTime.hours = HOURS;
SetDataTime.minutes = MINUTES;
SetDataTime.interval = INTERVAL;
}
else
{
Debug.WriteLine("Don't read data from Auto_EOD_Config table");
}
}
catch (Exception ex) {
Debug.WriteLine("Don't read data from Auto_EOD_Config table :" + ex);
}
/* sConfig = File.ReadAllText("E:/config.txt");
* EODStatus = sConfig.Substring(sConfig.IndexOf("<AUTOEOD>") + 9, (sConfig.IndexOf("</AUTOEOD>") - sConfig.IndexOf("<AUTOEOD>") - 9));
* HOURS = sConfig.Substring(sConfig.IndexOf("<HOURS>") + 7, (sConfig.IndexOf("</HOURS>") - sConfig.IndexOf("<HOURS>") - 7));
* MINUTES = sConfig.Substring(sConfig.IndexOf("<MINUTES>") + 9, (sConfig.IndexOf("</MINUTES>") - sConfig.IndexOf("<MINUTES>") - 9));
* INTERVAL = sConfig.Substring(sConfig.IndexOf("<INTERVAL>") + 10, (sConfig.IndexOf("</INTERVAL>") - sConfig.IndexOf("<INTERVAL>") - 10)) ;*/
// MessageBox.Show(EODStatus + "");
if (EODStatus == "ENABLE" && HOURS != "" && MINUTES != "" && INTERVAL != "")
{
//Auto_check.Checked = true;
on_off.Text = "ON";
on_off.ForeColor = Color.Green;
//this.Show();
}
}
private void PrintReceipt(string trnasc_id)
{
Debug.WriteLine("TRYING TO PRINT... STATUS + " + Printer.iStatus);
if (Printer.iStatus == 1)
{
string sPIC = "";
string sPump = "";
string sGrade = "";
string sVolume = "";
string sPurchase = "";
string sPrice = "";
string sDeposit = "";
string sChange = "";
string sShowTime = "";
string sTranId = "";
string sReceipt = "";
OleDbCommand dbCmd;
OleDbDataReader drRecordSet;
SQL_SERVER.Set_Sql_Server_Conn();
SQL_SERVER.Open_Sql_Server_Conn();
//sQuery = "SELECT COMPLETED_TIME, PIC, PUMP, DEPOSIT, PURCHASE, PRICE, CHANGE, GRADE, VOLUME, SHOW_TIME, TRAN_ID FROM TRANSACTIONS ORDER BY COMPLETED_TIME DESC";
string sQuery = "SELECT COMPLETED_TIME, PIC, PUMP, DEPOSIT, PURCHASE, PRICE, GRADE, VOLUME, SHOW_TIME, TRAN_ID,CHANGE FROM TRANSACTIONS WHERE TRAN_ID LIKE '%" + trnasc_id + "%' ORDER BY COMPLETED_TIME DESC;";
dbCmd = SQL_SERVER.Set_Sql_Server_Cmd(sQuery);
drRecordSet = dbCmd.ExecuteReader();
Debug.WriteLine(sQuery);
Debug.WriteLine(drRecordSet.HasRows);
if (drRecordSet.HasRows)
{
while (drRecordSet.Read())
{
sPIC = drRecordSet["PIC"].ToString();
sPump = drRecordSet["PUMP"].ToString();
sGrade = drRecordSet["GRADE"].ToString();
sVolume = drRecordSet["VOLUME"].ToString();
sPurchase = drRecordSet["PURCHASE"].ToString();
sPrice = drRecordSet["PRICE"].ToString();
sDeposit = drRecordSet["DEPOSIT"].ToString();
sChange = drRecordSet["CHANGE"].ToString();
sShowTime = drRecordSet["SHOW_TIME"].ToString();
sTranId = drRecordSet["TRAN_ID"].ToString();
}
sReceipt = sReceipt + Printer.sHeader;
sReceipt = sReceipt + "\n\n\n";
sReceipt = sReceipt + "Pump: " + sPump + "\n";
sReceipt = sReceipt + "Terminal: " + sPIC + "\n\n";
sReceipt = sReceipt + "Descr. qty amount" + "\n";
sReceipt = sReceipt + "------ --- ------" + "\n";
sReceipt = sReceipt + sGrade + " " + sVolume + " " + sPurchase + "\n";
sReceipt = sReceipt + " @ " + sPrice + "/G" + "\n";
sReceipt = sReceipt + " Prepay Fuel -" + sDeposit + ".00" + "\n";
sReceipt = sReceipt + " --------" + "\n";
sReceipt = sReceipt + " Subtotal -" + sChange + "\n";
sReceipt = sReceipt + " Tax 0.00" + "\n";
sReceipt = sReceipt + " TOTAL -" + sChange + "\n";
sReceipt = sReceipt + " CASH -" + sChange + "\n\n";
sReceipt = sReceipt + "TRAN# " + sTranId + "\n";
sReceipt = sReceipt + sShowTime + "\n\n";
sReceipt = sReceipt + Printer.sFooter + "\n\n\n\n\n\n\n\n\n\n\n\n\n";
Printer.sReceipt = sReceipt;
CenCom.bPrintRequest = true;
Debug.WriteLine(sReceipt);
//MessageBox.Show(sReceipt + "");
dbCmd.Dispose();
drRecordSet.Dispose();
SQL_SERVER.Close_Sql_Sever_Conn();
}
}
else
{
Display.ShowMessageBox("Printer Offline", 3);
}
}