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 UpdateStock_Load(object sender, EventArgs e)
{
try
{
MySqlCommand cmd = HorsePower.OpenConnection().CreateCommand();
cmd.CommandText = "Select * From stock WHERE `ItemName` like '" + itemname.Text + "'";
MySqlDataReader read = cmd.ExecuteReader();
if (read.Read())
{
code.Text = read.GetString(0);
textBox1.Text = read.GetString(1);
quantity.Text = read.GetString(2);
units.Text = read.GetString(4);
bp.Text = read.GetString(5);
supplier.Text = read.GetString(6);
newitem.Text = read.GetString(1);
newunits.Text = read.GetString(4);
newsupplier.Text = read.GetString(6);
}
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void checkBox2_CheckedChanged(object sender, EventArgs e)
{
string itm = (String)listBox1.SelectedItem;
if (checkBox2.Checked == true)
{
checkBox2.Text = "Cooked";
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `Name`, `Price` FROM `itemsmenu` WHERE `Status` ='Cooked'");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
else
{
try
{
checkBox2.Text = "UnCooked";
dataGridView1.DataSource = HorsePower.Select("SELECT `Name`, `Price` FROM `itemsmenu` WHERE `Status` = 'UnCooked'");
}
catch (Exception ex)
{
Console.Write(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);
}
}
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 SalesReport_Load(object sender, EventArgs e)
{
treeView1.ExpandAll();
HorsePower.FillCombo(comboBox1, "SELECT `Name` FROM `itemsmenu` WHERE 1");
//HorsePower.FillCombo(comboBox2, "SELECT `Username` FROM `login2` WHERE 1");
HorsePower.FillCombo(comboBox2, "SELECT CONCAT(FirstName,LastName) FROM workers;");
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
MySqlCommand cmd = HorsePower.OpenConnection().CreateCommand();
cmd.CommandText = "Select `AccountNumber`, `AccountName`, `Bank`, `Signitory`, `Amount` From `account` WHERE `AccountName` = '" + comboBox1.Text + "'";
MySqlDataReader read = cmd.ExecuteReader();
if (read.Read())
{
accountnumber.Text = read.GetString(0);
accountname.Text = read.GetString(1);
bankname.Text = read.GetString(2);
signitory.Text = read.GetString(3);
amount.Text = read.GetString(4);
}
else
{
accountnumber.Text = "";
bankname.Text = "";
signitory.Text = "";
amount.Text = "";
}
}
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 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
{
//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 textBox2_TextChanged(object sender, EventArgs e)
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `OrderNumber`,`Status`, `Total`, `Waiter` FROM `orders` WHERE `Waiter` LIKE '" + textBox2.Text + "%'");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void OrdersApproval_Load(object sender, EventArgs e)
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `OrderNumber`,`Status`, `Total`, `Waiter` FROM `orders` WHERE `Status` = 'Open' AND `Date` = '" + dateTimePicker1.Text + "'");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
public void Loads()
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `ItemName` FROM `ItemCategories` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void ReloadGrid()
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `Name`, `Quantity`, `Price` FROM `itemsmenu` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
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;
}
public void get()
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `FirstName`, `LastName` FROM `workers` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
void LoadStatus()
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `Name`, `Price`, `Type`, `Details`, `Availability`,`Status` FROM `itemsmenu` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `OrderNumber`, `Date`, `Status`, `Total`, `Waiter`,`OrderStatus` FROM `Orders` WHERE `TableNumber`='" + comboBox2.Text + "'");
}
catch (Exception ex)
{
MessageBox.Show("Error Unable To Load data", "Error");
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `OrderNumber`,`Status`, `Total`, `Waiter` FROM `orders` WHERE `Status` = '" + comboBox1.Text + "' ");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void LoadAllWorkers()
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `FirstName`, `LastName`, `IDNumber`, `Gender`, `Telephone`, `Residence`, `WorkPosition`, `Salary`, `PaymentMode`, `WorkingDuration` FROM `workers` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void ItemStatus_Load(object sender, EventArgs e)
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `Name`, `Price`, `Type`, `Details`, `Availability`,`Status` FROM `itemsmenu` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
public void LoadStuff()
{
try
{
dataGridView2.DataSource = HorsePower.Select("SELECT `FullNames`, `Amount`,`Status` FROM `OpeningBalance` WHERE `Date` = '" + dateTimePicker1.Text + "'");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void LoadStatus2(string text)
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `Name`, `Price`, `Type`, `Details`, `Availability`,`Status` FROM `itemsmenu` WHERE `Status` = '" + comboBox1.Text + "'");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void gettable()
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT * FROM `Table` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void Suppliers_Load(object sender, EventArgs e)
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT * FROM `Suppliers` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
public void get()
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT * FROM `Suppliers` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `Name`, `Quantity`, `Price` FROM `itemsmenu` WHERE `Availability` = '" + comboBox1.Text + "'");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void getUnits()
{
try
{
dataGridView2.DataSource = HorsePower.Select("SELECT * FROM `Units` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void LoadCategories()
{
try
{
HorsePower.LoadList(listBox1);
}
catch (Exception ex)
{
Console.Write(ex);
}
}
