void SendMail()
{
try
{
//send mail
MailMessage Msg = new MailMessage();
Msg.From = new MailAddress(from.Text);
Msg.To.Add(recepient.Text);
Msg.Subject = subject.Text;
Msg.Body = message.Text;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.Credentials = new System.Net.NetworkCredential(from.Text, password.Text);
smtp.EnableSsl = true;
smtp.Send(Msg);
//save the record in db
DateTime d = DateTime.Now;
string add = "INSERT INTO `MailMaster`(`To`, `From`, `Date`, `Subject`, `Message`, `Attachments`) VALUES ('" + recepient.Text + "','" + from.Text + "','" + d.ToString() + "','" + subject.Text + "','" + message.Text + "','" + listBox1.Items.Count + "')";
HorsePower.ExecuteSQL(add);
MessageBox.Show("Email Sent and Saved", "Mail Master", MessageBoxButtons.OK, MessageBoxIcon.Information);
loadMails();
}
catch (SmtpException ex)
{
MessageBox.Show("Cannot Send E-Mail : " + ex);
}
}
private void button1_Click(object sender, EventArgs e)
{
//check if there is an existing shift
try
{
DataGridViewRow row = this.dataGridView1.SelectedRows[0];
String number = row.Cells[0].Value.ToString();
String firstname = row.Cells[1].Value.ToString();
String lastname = row.Cells[2].Value.ToString();
DateTime d = DateTime.Now;
String Time = d.ToString("t");
if (check(number, dateTimePicker1.Text))
{
MessageBox.Show("Sorry But : " + firstname + lastname + " Has Already Started Shift", "Hotel POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
//insert to db
String QSL = "INSERT INTO `shift`(`IDNumber`,`FullNames`, `Date`,`StartTime`) VALUES ('" + number + "','" + firstname + lastname + "','" + dateTimePicker1.Text + "','" + Time + "')";
HorsePower.ExecuteSQL(QSL);
//get shifts
getShifts();
}
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || textBox4.Text == "" || textBox5.Text == "" || comboBox1.Text == "")
{
MessageBox.Show("Please Fill Account Details", "Invalid Account", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
//check if account exists
MySqlCommand cmd = HorsePower.OpenConnection().CreateCommand();
cmd.CommandText = "Select * From `account` WHERE `AccountNumber` = '" + textBox1.Text + "'";
MySqlDataReader read = cmd.ExecuteReader();
if (read.Read())
{
MessageBox.Show("Duplicate Account Exists", "Account", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
//create account
String SQLQUERY = "INSERT INTO `account`(`AccountNumber`, `AccountName`, `Bank`, `DateOpened`, `Signitory`, `Accounttype`, `Amount`) VALUES ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + dateTimePicker1.Text + "','" + textBox4.Text + "','" + comboBox1.Text + "','" + textBox5.Text + "')";
HorsePower.ExecuteSQL(SQLQUERY);
MessageBox.Show("Account Information Saved", "Account", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
DateTime date = DateTime.Now;
DialogResult res = MessageBox.Show("Be Sure Because This Will Reduce Stock", "Stock", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (res == DialogResult.Yes)
{
//REDECE STOCK
ReduceQty(textBox1.Text, textBox2.Text);
//ADD TO LIST
ListViewItem lv = new ListViewItem(new String[] { textBox1.Text, textBox2.Text });
listView1.Items.Add(lv);
Reload();
HorsePower.ExecuteSQL("INSERT INTO `StockOut`(`Code`, `Name`, `Date`, `QuantityOut`, `Notes`) VALUES ('" + code.Text + "','" + textBox1.Text + "','" + date + "','" + textBox2.Text + "','" + textBox3.Text + "')");
}
else
{
}
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void button3_Click(object sender, EventArgs e)
{
try
{
//delete item now
DialogResult res = MessageBox.Show("ARE YOU SURE YOU WANT TO DELETE ITEM : " + itemname.Text + " COMPLETELY", "SYSTEM CONFIRMATION", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (res == DialogResult.Yes)
{
HorsePower.ExecuteSQL("DELETE FROM `stock` WHERE `ItemName`='" + itemname.Text + "' AND `Code` = '" + code.Text + "'");
MessageBox.Show("Item Deleted/Removed From Current Stock DB", "Green Care POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
itemname.Text = "";
code.Text = "";
quantity.Text = "";
categories.Text = "";
units.Text = "";
bp.Text = "";
supplier.Text = "";
button1.Visible = true;
button2.Visible = false;
button3.Visible = false;
button4.Visible = false;
get();
}
else
{
}
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
//check user account
String AS = "SELECT `Username`, `Role`, `Password` FROM `login2` WHERE `Username` = '" + comboBox2.Text + "' AND `Role` = 'Admin' AND `Password` = '" + textBox1.Text + "'";
// V2MySqlServer v2 = new V2MySqlServer(Server.getIP(), "root", "", "hotel");
MySqlCommand cmd = HorsePower.OpenConnection().CreateCommand();
cmd.CommandText = AS;
MySqlDataReader read = cmd.ExecuteReader();
if (read.Read())
{
if (!comboBox1.Text.Equals(""))
{
//proceed to transfer money
int total = int.Parse(amount.Text) + int.Parse(tobank.Text);
//confirm from user
DialogResult res = MessageBox.Show("AMOUNT KSH:" + tobank.Text + " \n WILL BE TRANSFERED TO : " + bankname.Text + " \n ON : " + dateTimePicker1.Text + " \n BY : " + comboBox2.Text, "CONFIRM", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (res == DialogResult.Yes)
{
textBox1.Text = "";
textBox1.Visible = false;
label11.Visible = false;
//proceed
HorsePower.ExecuteSQL("UPDATE `account` SET `Amount`='" + total.ToString() + "' WHERE `AccountNumber` ='" + accountnumber.Text + "' AND `AccountName` = '" + accountname.Text + "'");
//save transaction trail
TransactionTrail();
//clear everything
accountname.Text = "";
accountnumber.Text = "";
bankname.Text = "";
signitory.Text = "";
amount.Text = "";
tobank.Text = "";
source.Text = "";
//refresh the account balance
RefreshAccount(comboBox1.Text);
}
else
{
MessageBox.Show("Oooh No ! You Have Not Selected Bank Account", "Invalid Parameters", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
}
//do nothing
}
else
{
//do not do anything
MessageBox.Show("Sorry You Do Not Have Sufficient To Complete This Operation", "Invalid Account", MessageBoxButtons.OK, MessageBoxIcon.Hand);
textBox1.Text = "";
textBox1.Visible = false;
label11.Visible = false;
}
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void button1_Click(object sender, EventArgs e)
{
String SQL = "UPDATE `itemsmenu` SET `Price`='" + newprice.Text + "' WHERE `Name`= '" + name.Text + "'";
HorsePower.ExecuteSQL(SQL);
newprice.Text = "";
ReloadGrid();
}
private void button4_Click(object sender, EventArgs e)
{
int total = int.Parse(textBox2.Text) - int.Parse(add.Text);
//update the db
HorsePower.ExecuteSQL("UPDATE `openingbalance` SET `Amount`='" + total.ToString() + "' WHERE `FullNames`='" + textBox1.Text + "' AND `Date` = '" + dateTimePicker1.Text + "'");
//reload the datagrid
LoadStuff();
//hide me
groupBox1.Visible = false;
}
void RemoveShift(string id, string date)
{
try
{
HorsePower.ExecuteSQL("DELETE FROM `shift` WHERE `IDNumber`='" + id + "' AND `Date` = '" + date + "'");
getShifts();
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void SaveSale(string on, string waiter)
{
//loop through the order
MySqlCommand cmd = new MySqlCommand("SELECT `ItemName`, `Quantity`, `Price`, `Total` FROM `orderinfor` WHERE `OrderNumber` = '" + on + "'", HorsePower.OpenConnection());
MySqlDataReader read = cmd.ExecuteReader();
while (read.Read())
{
//insert the sales table
HorsePower.ExecuteSQL("INSERT INTO `sales`(`Worker`,`Date`,`ItemName`,`Quantity`, `Price`,`Total`) VALUES ('" + waiter + "','" + dateTimePicker1.Text + "','" + read.GetString(0) + "','" + read.GetString(1) + "','" + read.GetString(2) + "','" + read.GetString(3) + "')");
}
MessageBox.Show("Hotel Sale Information Saved Successfully ", "Sale Sucess", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void button3_Click(object sender, EventArgs e)
{
try
{
String Update = "DELETE FROM `suppliers` WHERE `FullNames` ='" + NAMES + "'";
HorsePower.ExecuteSQL(Update);
get();
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
String Update = "UPDATE `suppliers` SET `Company`='" + company.Text + "',`Location`='" + location.Text + "',`FullNames`='" + fullnames.Text + "',`OfficeTel`='" + office.Text + "',`Mobile`='" + mobile.Text + "' WHERE `FullNames` = '" + NAMES + "'";
HorsePower.ExecuteSQL(Update);
// MessageBox.Show("Successfully Updated Supplier Information", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
get();
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void seenToolStripMenuItem_Click(object sender, EventArgs e)
{
DataGridViewRow row = this.dataGridView1.SelectedRows[0];
DialogResult res = MessageBox.Show("ARE YOU SURE YOU WANT TO MARK ORDER : " + row.Cells[0].Value.ToString() + " AS SEEN", "Order", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (res == DialogResult.Yes)
{
String on = row.Cells[0].Value.ToString();
String waiter = row.Cells[3].Value.ToString();
String Query = "UPDATE `orders` SET `OrderStatus`='Seen' WHERE `OrderNumber`='" + on + "' ";
HorsePower.ExecuteSQL(Query);
}
LoadOrders();
}
private void clearFloatToolStripMenuItem_Click(object sender, EventArgs e)
{
DataGridViewRow row = this.dataGridView2.SelectedRows[0];
String name = row.Cells[0].Value.ToString();
DialogResult res = MessageBox.Show("ARE YOU SURE YOU WANT TO CLEAR FLOAT FOR : " + row.Cells[0].Value.ToString() + "\n This Means That He/She Has Returned Total Float", "FLOAT", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (res == DialogResult.Yes)
{
//set status to cleared
HorsePower.ExecuteSQL("UPDATE `openingbalance` SET `Status`='Cleared' WHERE `FullNames`='" + name + "' AND `Date` = '" + dateTimePicker1.Text + "'");
LoadStuff();
}
}
private void button6_Click(object sender, EventArgs e)
{
try
{
foreach (ListViewItem item in this.listView1.Items)
{
HorsePower.ExecuteSQL("INSERT INTO `sales`(`Worker`,`Date`,`ItemName`,`Quantity`, `Price`,`Total`) VALUES ('" + textBox3.Text + "','" + saledate.Text + "','" + item.SubItems[0].Text + "','" + item.SubItems[1].Text + "','" + item.SubItems[2].Text + "','" + item.SubItems[3].Text + "')");
}
MessageBox.Show("Hotel Sale Information Saved Successfully ", "Sale Sucess", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
Console.Write(ex);
}
}
public void DeleteOrders(String q1, String q2)
{
try
{
//delete orders
HorsePower.ExecuteSQL(q1);
//delete order infor
HorsePower.ExecuteSQL(q2);
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void closeOrderToolStripMenuItem_Click(object sender, EventArgs e)
{
DataGridViewRow row = this.dataGridView1.SelectedRows[0];
DialogResult res = MessageBox.Show("ARE YOU SURE YOU WANT TO MARK : " + row.Cells[0].Value.ToString() + " AS COOKED", "STATUS", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (res == DialogResult.Yes)
{
String on = row.Cells[0].Value.ToString();
String Query = "UPDATE `itemsmenu` SET `Status`='Cooked' WHERE `Name`='" + on + "' ";
HorsePower.ExecuteSQL(Query);
LoadStatus();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (firstname.Text == "" || lastname.Text == "" || idnumber.Text == "" || phone.Text == "" || residence.Text == "")
{
MessageBox.Show("Some Important Details Missing", "GreenCafe", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
String QSL = "INSERT INTO `workers`(`FirstName`, `LastName`, `IDNumber`, `Gender`, `Telephone`, `Residence`, `WorkPosition`, `Salary`, `PaymentMode`, `WorkingDuration`) VALUES ('" + firstname.Text + "','" + lastname.Text + "','" + idnumber.Text + "','" + gender.Text + "','" + phone.Text + "','" + residence.Text + "','" + position.Text + "','" + salary.Text + "','" + mode.Text + "','" + duration.Text + "')";
HorsePower.ExecuteSQL(QSL);
//reload the grid
LoadAllWorkers();
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
if (textBox2.Text == "")
{
MessageBox.Show("Some Information Missing", "Point Of Sale", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
HorsePower.ExecuteSQL("INSERT INTO `Units`(`UnitName`)VALUES ('" + textBox2.Text + "')");
getUnits();
}
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void button3_Click(object sender, EventArgs e)
{
try
{
if (ItemName.Text == "")
{
MessageBox.Show("Some Information Missing", "Point Of Sale", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
HorsePower.ExecuteSQL("INSERT INTO `ItemCategories`(`ItemName`,`Image`)VALUES ('" + ItemName.Text + "','" + pictureBox1.Image + "')");
Loads();
}
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (textBox1.Text == "" || textBox2.Text == "")
{
MessageBox.Show("Some Information Missing", "Point Of Sale", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
HorsePower.ExecuteSQL("INSERT INTO `Table`(`TableNumber`,`TableName`)VALUES ('" + textBox1.Text + "','" + textBox2.Text + "')");
//MessageBox.Show("Successfully Added Table", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
gettable();
}
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (firstname.Text == "" || lastname.Text == "" || amount.Text == "")
{
MessageBox.Show("Please Select Worker", "GreenCare", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
try
{
String sql = "INSERT INTO `OpeningBalance`(`FullNames`, `Date`, `Amount`,`Status`) VALUES ('" + firstname.Text + lastname.Text + "','" + dateTimePicker1.Text + "','" + amount.Text + "','Pending')";
HorsePower.ExecuteSQL(sql);
LoadStuff();
}
catch (Exception ex)
{
Console.Write(ex);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (username.Text == "" || comboBox2.Text == "" || password.Text == "")
{
MessageBox.Show("Incomplete Information ", "Warning");
}
else
{
string add = "INSERT INTO `login2`(`username`,`Role`, `Password`) VALUES ('" + username.Text + "','" + comboBox2.Text + "','" + password.Text + "')";
HorsePower.ExecuteSQL(add);
MessageBox.Show("New Account Created ", "Transaction Succeeded", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (company.Text == "" || location.Text == "" || fullnames.Text == "" || mobile.Text == "")
{
MessageBox.Show("Some Supplier Information Missing", "GreenCafe", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
String SQL = "INSERT INTO `suppliers`(`Company`, `Location`, `FullNames`, `OfficeTel`, `Mobile`, `Date`) VALUES ('" + company.Text + "','" + location.Text + "','" + fullnames.Text + "','" + office.Text + "','" + mobile.Text + "','" + dateTimePicker1.Text + "')";
HorsePower.ExecuteSQL(SQL);
MessageBox.Show("Successfully Saved Supplier Information", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
get();
}
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (itemname.Text == "" || quantity.Text == "" || bp.Text == "" || categories.Text == "" || units.Text == "" || supplier.Text == "" || date.Text == "")
{
MessageBox.Show("Some Information Missing", "Point Of Sale", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
try
{
HorsePower.ExecuteSQL("INSERT INTO `Stock`(`Code`, `ItemName`, `Quantity`, `Categories`, `Units`, `BuyingPrice`, `Supplier`, `PurchaseDate`)VALUES ('" + code.Text + "','" + itemname.Text + "','" + quantity.Text + "','" + categories.Text + "','" + units.Text + "','" + bp.Text + "','" + supplier.Text + "','" + date.Text + "')");
//insert purchase record
int total = int.Parse(bp.Text) * int.Parse(quantity.Text);
HorsePower.ExecuteSQL("INSERT INTO `purchase_log`(`Date`, `Name`, `Quantity`, `Price`, `Total`) VALUES ('" + date.Text + "','" + itemname.Text + "','" + quantity.Text + "','" + bp.Text + "','" + total.ToString() + "')");
MessageBox.Show("Successfully Added New Stock", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
itemname.Text = "";
code.Text = "";
quantity.Text = "";
categories.Text = "";
units.Text = "";
bp.Text = "";
supplier.Text = "";
get();
}
catch (Exception ex)
{
Console.Write(ex);
}
}
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
DataGridViewRow row = this.dataGridView1.SelectedRows[0];
String number = row.Cells[0].Value.ToString();
String firstname = row.Cells[1].Value.ToString();
String lastname = row.Cells[2].Value.ToString();
String Names = firstname + lastname;
DateTime d = DateTime.Now;
String Time = d.ToString("t");
String SQL = "UPDATE `shift` SET `StopTime`='" + Time + "' WHERE `FullNames`='" + Names + "'";
HorsePower.ExecuteSQL(SQL);
//get shifts
getShifts();
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (newitem.Text.Equals("") || newqty.Text.Equals("") || newbp.Text.Equals(""))
{
MessageBox.Show("Please Search item First", "Green Care POS", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
int totqty = int.Parse(quantity.Text) + int.Parse(newqty.Text);
HorsePower.ExecuteSQL("UPDATE `stock` SET `ItemName`='" + newitem.Text + "',`Quantity`='" + totqty.ToString() + "',`Units`='" + newunits.Text + "',`BuyingPrice`='" + newbp.Text + "',`Supplier`='" + newsupplier.Text + "',`PurchaseDate`='" + pdate.Text + "' WHERE `ItemName`='" + itemname.Text + "' AND `Code` = '" + code.Text + "'");
MessageBox.Show("Successfully Updated " + newitem.Text, "Green Care POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
//save purchase log
int total = int.Parse(newbp.Text) * int.Parse(newqty.Text);
HorsePower.ExecuteSQL("INSERT INTO `purchase_log`(`Date`, `Name`, `Quantity`, `Price`, `Total`) VALUES ('" + pdate.Text + "','" + newitem.Text + "','" + newqty.Text + "','" + newbp.Text + "','" + total.ToString() + "')");
}
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void ReduceQty(string name, string qty)
{
try
{
int q = 0;
//fetch the quantity
MySqlCommand cmd = new MySqlCommand("SELECT `Quantity` FROM `stock` WHERE `ItemName` = '" + name + "'", HorsePower.OpenConnection());
MySqlDataReader read = cmd.ExecuteReader();
if (read.Read())
{
q = int.Parse(read.GetString(0));
}
//now reduce the stock by subtratcting
int total = q - int.Parse(qty);
//now update the new stock qty
HorsePower.ExecuteSQL("UPDATE `stock` SET `Quantity`='" + total + "' WHERE `ItemName` = '" + name + "'");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void button1_Click(object sender, EventArgs e)
{
panel2.Visible = false;
try
{
DataGridViewRow row = this.dataGridView1.SelectedRows[0];
DialogResult res = MessageBox.Show("ARE YOU SURE YOU WANT TO CLOSE THIS ORDER : " + row.Cells[0].Value.ToString(), "Order", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (res == DialogResult.Yes)
{
String on = row.Cells[0].Value.ToString();
String waiter1 = row.Cells[3].Value.ToString();
String Query = "UPDATE `orders` SET `Status`='Closed' WHERE `OrderNumber`='" + on + "' ";
HorsePower.ExecuteSQL(Query);
LoadOrders();
//save the sale
SaveSale(on, waiter1);
//save statement
HorsePower.ExecuteSQL(" INSERT INTO `finance_statement` (`name`, `type`, `date`, `debit`, `credit`, `balance` ) VALUES ('Income', 'Income', '" + DateTime.Now.ToShortDateString() + "', '0', '" + paid.Text + "', '0' );");
panel2.Visible = false;
string GS = Convert.ToString((char)29);
string ESC = Convert.ToString((char)27);
Random rno = new Random();
string receipt = rno.Next(0, 100).ToString();
string COMMAND = "";
COMMAND = ESC + "@";
COMMAND += GS + "V" + (char)1;
DateTime D = DateTime.Now;
// int i = 0;
StringBuilder sb = new StringBuilder();
sb.Append(" DYKAAN HOTEL \n");
sb.Append("KIAMBUU TWIGA BUILDING SECOND FLOOR \n");
sb.Append("P.O. Box \n");
//sb.Append("KIAMBUU \n");
// sb.Append(" BILLING RECEIPT \n");
sb.Append("DATE :" + D.ToString() + " \n");
sb.Append("TELL NO : 0723156900 \n");
sb.Append("TILL NO : 83359 \n");
sb.Append("ADDRESS : 01000 - 152 THIKA \n");
sb.Append("RECEIPTNO : " + receipt.ToString() + " \n");
// sb.Append("WAITER : " + comboBox3.Text + " \n");
sb.Append(" CASH SALE RECEIPT \n");
sb.Append("_______________________________________________\n");
// sb.Append("No Name Quantity Price Total\n");
sb.Append("_______________________________________________\n");
sb.Append(" Customer Bill List \n");
sb.Append("_______________________________________________\n");
int j = 0;
for (int i = 0; i < dataGridView2.Rows.Count; i++)
{
j = j + 1;
sb.Append(j.ToString() + "." + " " + dataGridView2.Rows[i].Cells[0].Value + " " + dataGridView2.Rows[i].Cells[1].Value + " X " + dataGridView2.Rows[i].Cells[2].Value + " \n");
}
/* for (int i = 0; i < dataGridView2.Rows.Count; i++)
* {
* j = j + 1;
* sb.Append(" " + dataGridView2.Rows[i].Cells[1].Value + " x " + dataGridView2.Rows[i].Cells[2].Value + " "+ dataGridView2.Rows[i].Cells[0].Value + " \n");
* }*/
sb.Append("______________________________________________ \n");
sb.Append("Serverd By : " + waiter.Text + " \n");
// sb.Append("Table Number : " + comboBox2.Text + " \n");
sb.Append("_______________________________________________\n");
sb.Append(" Total Items : " + dataGridView2.Rows.Count.ToString() + "\n");
sb.Append(" Total Bill : " + total.Text + "\n");
// sb.Append(" Paid Amount : " + paid.Text + "\n");
// sb.Append(" Change : " + change.Text + "\n");
sb.Append(" Mode : Cash \n");
sb.Append("_______________________________________________\n");
sb.Append(" Come in as Guest Leave As Family \n");
sb.Append(" THANK YOU \n");
sb.Append(" \n");
sb.Append(" \n");
sb.Append(" \n");
sb.Append(" \n");
sb.Append(" \n");
sb.Append(" \n");
sb.Append(" \n");
sb.Append(" \n");
sb.Append(" \n");
sb.Append(" \n");
string s = sb.ToString();
// device-dependent string, need a FormFeed?
//
// Allow the user to select a printer.
PrintDialog pd = new PrintDialog();
pd.PrinterSettings = new PrinterSettings();
// Send a printer-specific to the printer.
RawPrinterHelper.SendStringToPrinter(pd.PrinterSettings.PrinterName, s + COMMAND);
total.Text = "";
paid.Text = "";
waiter.Text = "";
change.Text = "";
}
}
catch (Exception ex)
{
Console.Write(ex);
}
}
void PrintOrder()
{
try
{
//panel2.Visible = false;
DataGridViewRow row = this.dataGridView1.SelectedRows[0];
String on = row.Cells[0].Value.ToString();
String waiter1 = row.Cells[3].Value.ToString();
String Query = "UPDATE `orders` SET `Status`='Closed' WHERE `OrderNumber`='" + on + "' ";
HorsePower.ExecuteSQL(Query);
LoadOrders();
SaveSale(on, waiter1);
panel2.Visible = false;
string GS = Convert.ToString((char)29);
string ESC = Convert.ToString((char)27);
Random rno = new Random();
string receipt = rno.Next(0, 100).ToString();
string COMMAND = "";
COMMAND = ESC + "@";
COMMAND += GS + "V" + (char)1;
DateTime D = DateTime.Now;
// int i = 0;
StringBuilder sb = new StringBuilder();
sb.Append(" DYKAAN HOTEL \n");
sb.Append("KIAMBUU TWIGA BUILDING SECOND FLOOR \n");
sb.Append("P.O. Box \n");
//sb.Append("KIAMBUU \n");
// sb.Append(" BILLING RECEIPT \n");
sb.Append("DATE :" + D.ToString() + " \n");
sb.Append("TELL NO : 0723156900 \n");
sb.Append("TILL NO : 83359 \n");
sb.Append("ADDRESS : 01000 - 152 THIKA \n");
sb.Append("RECEIPTNO : " + receipt.ToString() + " \n");
// sb.Append("WAITER : " + comboBox3.Text + " \n");
sb.Append(" CASH SALE RECEIPT \n");
sb.Append("_______________________________________________\n");
// sb.Append("No Name Quantity Price Total\n");
sb.Append("_______________________________________________\n");
sb.Append(" Customer Bill List \n");
sb.Append("_______________________________________________\n");
int j = 0;
for (int i = 0; i < dataGridView2.Rows.Count; i++)
{
j = j + 1;
sb.Append(j.ToString() + "." + " " + dataGridView2.Rows[i].Cells[0].Value + " " + dataGridView2.Rows[i].Cells[1].Value + " X " + dataGridView2.Rows[i].Cells[2].Value + " \n");
}
/* for (int i = 0; i < dataGridView2.Rows.Count; i++)
* {
* j = j + 1;
* sb.Append(" " + dataGridView2.Rows[i].Cells[1].Value + " x " + dataGridView2.Rows[i].Cells[2].Value + " "+ dataGridView2.Rows[i].Cells[0].Value + " \n");
* }*/
sb.Append("______________________________________________ \n");
sb.Append("Serverd By : " + waiter.Text + " \n");
// sb.Append("Table Number : " + comboBox2.Text + " \n");
sb.Append("_______________________________________________\n");
sb.Append(" Total Items : " + dataGridView2.Rows.Count.ToString() + "\n");
sb.Append(" Total Bill : " + total.Text + "\n");
// sb.Append(" Paid Amount : " + paid.Text + "\n");
// sb.Append(" Change : " + change.Text + "\n");
sb.Append(" Mode : Cash \n");
sb.Append("_______________________________________________\n");
sb.Append(" Come in as Guest Leave As Family \n");
sb.Append(" THANK YOU \n");
sb.Append(" \n");
sb.Append(" \n");
sb.Append(" \n");
sb.Append(" \n");
sb.Append(" \n");
sb.Append(" \n");
sb.Append(" \n");
sb.Append(" \n");
sb.Append(" \n");
sb.Append(" \n");
string s = sb.ToString();
// device-dependent string, need a FormFeed?
//
// Allow the user to select a printer.
PrintDialog pd = new PrintDialog();
pd.PrinterSettings = new PrinterSettings();
// Send a printer-specific to the printer.
RawPrinterHelper.SendStringToPrinter(pd.PrinterSettings.PrinterName, s + COMMAND);
total.Text = "";
paid.Text = "";
waiter.Text = "";
change.Text = "";
}
catch (Exception ex)
{
}
}