//INSERT ORDER DETAILS
private void gridviewDataIntoDb()
{
db con = new db();
DataTable shift;
//get shift
string queryshift = "SELECT shift.id,shift.users_id,users.username,shift.shift_no FROM `shift` JOIN users ON users.id = shift.users_id WHERE shift.shift_end IS NULL ORDER BY shift.id DESC LIMIT 1";
con.MysqlQuery(queryshift);
shift = con.QueryEx();
for (int i = 0; i < dataGridView_cart.Rows.Count; i++)
{
//inset only new items
if (dataGridView_cart.Rows[i].Cells["newitem"].Value.Equals(1))
{
con.MysqlQuery("INSERT INTO order_details (order_id,product_id,size,qty,unit_price,kot_status,subtotal,item_type,shift_id,shift_no) VALUES('" + SessionData.newOrderId + "','" + dataGridView_cart.Rows[i].Cells["itemcode"].Value.ToString() + "','" + dataGridView_cart.Rows[i].Cells["size"].Value.ToString() + "','" + dataGridView_cart.Rows[i].Cells["qty"].Value.ToString() + "','" + double.Parse(dataGridView_cart.Rows[i].Cells["price"].Value.ToString()) + "','" + 0 + "','" + double.Parse(dataGridView_cart.Rows[i].Cells["subtotal"].Value.ToString()) + "','" + dataGridView_cart.Rows[i].Cells["item_type"].Value.ToString() + "','" + SessionData.shiftId + "','" + SessionData.shiftno + "');");
con.NonQueryEx();
}
}
con.conClose();
//update tabel details
updateGuestTabelDetails();
updateOrderDiscount();
}
private void label16_Click(object sender, EventArgs e)
{
SessionData.SetNewOrderId(long.Parse(txt_selected_orderid.Text));
Form_auth frmauth = new Form_auth();
frmauth.ShowDialog();
if (managerPassword)
{
//canceled order
db con = new db();
string query = "";
query = "UPDATE `orders` SET `online`='0' WHERE id = '" + SessionData.newOrderId + "'";
con.MysqlQuery(query);
con.NonQueryEx();
con.conClose();
dataGridView2.Rows.Clear();
dataGridView2.Refresh();
loadOrderDetails();
}
else
{
MessageBox.Show("Authentication Faild!");
}
}
//create new order
private void createOrder(int orderType)
{
int orderstatus;
if (orderType.Equals(1))
{
orderstatus = 0;
}
else
{
if (paymentDone)
{
orderstatus = 1;
}
else
{
orderstatus = 0;
}
}
DateTime localDate = DateTime.Now;
int noOfGuest = SessionData.guest;
double cartPrice = SessionData.cartTotal;
con = new db();
string q = "insert into orders (created,guest,order_type,discount,service_charge,active,user_id) values('" + localDate + "','" + noOfGuest + "','Default','" + SessionData.discount + "','" + SessionData.serviceCharge + "','" + orderstatus + "','" + SessionData.userid + "')";
con.MysqlQuery(q);
con.NonQueryEx();
//SET ORDER ID
SessionData.SetNewOrderId(con.cmd.LastInsertedId);
con.conClose();
}
private void button1_Click(object sender, EventArgs e)
{
SessionData.SetTabelDetails(comboBox1.Text);
db con = new db();
DataTable activeTables;
con.MysqlQuery("SELECT COUNT(orders.id) AS activeOrders FROM `orders` WHERE orders.active =1 and orders.tabel = '" + comboBox1.Text + "' AND date(orders.created) = CURDATE()");
activeTables = con.QueryEx();
if (int.Parse(activeTables.Rows[0][0].ToString()) != 0)
{
//error message table not available
string msg = "Table " + comboBox1.Text + " is not available. please close the order first! or select another table.";
FormMessage frmmsg = new FormMessage(msg);
frmmsg.ShowDialog();
}
else
{
string query = "";
query = "UPDATE `orders` SET `tabel`= '" + SessionData.tabel + "' WHERE id = '" + _orderid + "'";
con.MysqlQuery(query);
con.NonQueryEx();
}
con.conClose();
this.Close();
}
void saveCardDetails()
{
db con = new db();
con.MysqlQuery("INSERT INTO paymentdetails (cardname,cardno,cardtype,amount,orders_id) VALUES('" + SessionData.cardname + "','" + SessionData.cardlastdigits + "','" + SessionData.cardtype + "','" + SessionData.lastbillamout + "','" + SessionData.newOrderId + "');");
con.NonQueryEx();
con.conClose();
}
//create login log
void userLog(string user, string user_event)
{
con = new db();
string q = "insert into user_log (user_id,event) values('" + user + "','" + user_event + "')";
con.MysqlQuery(q);
con.NonQueryEx();
con.conClose();
}
void updateOrderPrintStatus(int id)
{
db con = new db();
string query = "";
query = "UPDATE `order_details` SET `print_status`= '1' WHERE order_id = '" + id + "' AND print_status = 0";
con.MysqlQuery(query);
con.NonQueryEx();
con.conClose();
}
private void updateGuestTabelDetails()
{
db con = new db();
string query = "";
query = "UPDATE `orders` SET `tabel`='" + SessionData.tabel + "' WHERE id = '" + SessionData.newOrderId + "'";
con.MysqlQuery(query);
con.NonQueryEx();
con.conClose();
}
private void updateOrderDiscount()
{
db con = new db();
string query = "";
query = "UPDATE `orders` SET `discount`='" + SessionData.discount + "' WHERE id = '" + SessionData.newOrderId + "'";
con.MysqlQuery(query);
con.NonQueryEx();
con.conClose();
}
void voidOrderItems(int itemid)
{
// MessageBox.Show(itemid.ToString());
db con = new db();
string query = "";
query = "UPDATE `order_details` SET `online`='0' WHERE id = '" + itemid + "'";
con.MysqlQuery(query);
con.NonQueryEx();
con.conClose();
reOpenOrder();
}
void createShift()
{
con = new db();
string shiftend = "";
DataTable result;
int shifNo = 0;
//find shif end or not
string queryForCheckShift = "select id,shift_end,shift_start from shift where shift_date = '" + DateTime.Now.ToString("yyyy-M-d") + "'";
con.MysqlQuery(queryForCheckShift);
result = con.QueryEx();
if (result.Rows.Count > 0)
{
for (int i = 0; i < result.Rows.Count; i++)
{
DataRow dr = result.Rows[i];
shiftend = dr["shift_end"].ToString();
}
}
if (result.Rows.Count == 0 || shiftend != "")
{
//set shift No
if (shiftend != "")
{
shifNo = result.Rows.Count + 1;
}
else
{
shifNo = 1;
}
//create a new shift
string q = "insert into shift (users_id,shift_date,shift_start,shift_no) values('" + SessionData.userid + "','" + DateTime.Now.ToString("yyyy-M-d") + "','" + DateTime.Now.ToString("yyyyMMddHHmmss") + "','" + shifNo + "')";
con.MysqlQuery(q);
long shiftid = con.NonQueryEx();
SessionData.SetUserShiftId(int.Parse(shiftid.ToString()));
DataTable shiftno;
string queryshiftno = "SELECT shift.shift_no FROM shift WHERE shift.id ='" + SessionData.shiftId + "' ";
con.MysqlQuery(queryshiftno);
shiftno = con.QueryEx();
SessionData.SetUserShiftNo(int.Parse(shiftno.Rows[0][0].ToString()));
}
con.conClose();
}
void closeShift(int shiftid)
{
con = new db();
string q = "UPDATE shift SET shift_end = '" + DateTime.Now.ToString("yyyyMMddHHmmss") + "' WHERE shift.id = '" + shiftid + "'";
con.MysqlQuery(q);
con.NonQueryEx();
con.conClose();
Form_display.logoutStatus = true;
panel1.Visible = true;
Thread.Sleep(5000);
// set login form to switch user
Form_login.switcheUser = true;
this.Close();
}
private void updateOrder()
{
db con = new db();
string query = "";
if (paymentDone)
{
query = "UPDATE `orders` SET `paid`='" + SessionData.payamount + "',`active`='0' WHERE id = '" + SessionData.newOrderId + "'";
}
else
{
query = "UPDATE `orders` SET `paid`='" + SessionData.payamount + "',`active`='1' WHERE id = '" + SessionData.newOrderId + "'";
}
con.MysqlQuery(query);
con.NonQueryEx();
con.conClose();
}
//void ORDER
private void btn_void_Click(object sender, EventArgs e)
{
string orid = "";
if (dataGridView_cart.SelectedCells.Count > 0)
{
Form_auth frmauth = new Form_auth();
frmauth.ShowDialog();
if (authproceed)
{
if (managerPassword)
{
//canceled order
db con = new db();
string query = "";
query = "UPDATE `order_details` SET `online`='0' WHERE order_id = '" + SessionData.newOrderId + "'";
con.MysqlQuery(query);
con.NonQueryEx();
con.conClose();
userLog(authid, "void order: " + SessionData.newOrderId);
dataGridView2.Rows.Clear();
dataGridView2.Refresh();
loadOrderDetails();
resetAll();
dataGridView_cart.Rows.Clear();
dataGridView_cart.Refresh();
printVoidReceipt();
}
else
{
MessageBox.Show("Authentication Faild!");
}
}
}
else
{
MessageBox.Show("Empty Cart!");
}
}
