// POS PAGE
public static void CreateOrder(CsOrder neworder)
{
string aQuery = string.Format(@"INSERT INTO tblOrder(orderNO, orderCustomerNO, orderDate)
VALUES (NEXT VALUE FOR SQOrderNum,'{0}',getdate());", neworder.CustomerNumber);
string bQuery = string.Format(@"SELECT current_value FROM sys.sequences WHERE name = 'SQOrderNum'; ");
cmdStringA = new SqlCommand(aQuery, cntString);
cmdStringB = new SqlCommand(bQuery, cntString);
try
{
// ORDER INSERT
cntString.Open();
cmdStringA.ExecuteNonQuery();
// GET ORDERNUMBER (CURVAL)
SqlDataAdapter da = new SqlDataAdapter(cmdStringB);
DataTable dt = new DataTable();
DataSet ds = new DataSet();
da.Fill(dt);
ds.Tables.Add(dt);
neworder.OrderNumber = dt.Rows[0]["current_value"].ToString();
}
finally
{
cntString.Close();
}
}
protected void CheckOut(object sender, EventArgs e)
{
if (subTotal.Text == "0" && lblCustomerNumber.Text == "-")
{
ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('Please Choose Item and Customer');</script>");
}
else if (lblCustomerNumber.Text == "-" && subTotal.Text != "0")
{
ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('Please Select Customer (Use Search box above)');</script>");
}
else if (lblCustomerNumber.Text != "-" && subTotal.Text == "0")
{
ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('Please Add Items to Cart');</script>");
}
else
{
// CUSTOMER NUMBER FROM SEARCH WINDOW
CustomerNum = lblCustomerNumber.Text;
try
{
CsOrder newOrder = new CsOrder(OrderNum, CustomerNum, OrderDate);
// INSERT ORDER + GET ORDER NUMBER
ConnectionClass.CreateOrder(newOrder);
// INSERT ORDER NUMBER INTO ORDERITEM TABLE (ITABLE)
for (int a = 0; a < iTable.Rows.Count; a++)
{
iTable.Rows[a]["orderno"] = newOrder.OrderNumber;
}
// REBUILD GRIDVIEW
//GridView1.DataSource = iTable;
//GridView1.DataBind();
// UPLOAD ORDERITEM TABLE (ITABLE)
ConnectionClass.UploadOrderItem(iTable);
// PASS SESSION VALUE (ORDER NUMBER)
Session["ONUM"] = newOrder.OrderNumber;
Session["CNAME"] = lblCustomerName.Text;
Session["CNUM"] = lblCustomerNumber.Text;
// EMPTY ITABLE
//Session["iTable"] = null;
iTable.Clear();
//subTotal.Text = "0";
//grandTotal.Text = "0";
//GridView1.DataSource = iTable;
//GridView1.DataBind();
//lblCustomerName.Text = " ";
//lblCustomerNumber.Text = "-";
//SUCCESS MESSAGE
ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('Order Confirmed');</script>");
ClientScript.RegisterStartupScript(this.Page.GetType(), "", "window.open('012pos_seeOrderReceipt.aspx','window','toolbar=0,scrollbars=0,location=0,statusbar=0,menubar=0,resizable=0,height=350,width=700,left=130,top=220');", true);
Page.ClientScript.RegisterStartupScript(this.GetType(), "refresh", "window.location.href=window.location;", true);
}
catch
{
ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('Error Occured,Please try again later. ');</script>");
}
finally
{
}
}
}