// CUSTOMER protected void Page_Load(object sender, EventArgs e) { if (Session["OrderNum"] != null && !IsPostBack) { lblONum.Text = Session["OrderNum"].ToString(); orderNum = lblONum.Text; CsReceipt recept = new CsReceipt(orderNum, reTable, toTable); ConnectionClass.DisplayReceipt(recept); GridView1.DataSource = recept.ReceiptTable; GridView1.DataBind(); lblTQty.Text = recept.TotalTable.Rows[0][0].ToString(); lblTAmt.Text = recept.TotalTable.Rows[0][1].ToString(); lblTTax.Text = recept.TotalTable.Rows[0][2].ToString(); lblGTotal.Text = recept.TotalTable.Rows[0][3].ToString(); CsReceiptInfo info = new CsReceiptInfo(orderNum, ceTable); ConnectionClass.ViewCustomer(info); lblCInfo.Text = info.CustomerInfo.Rows[0][2].ToString() + " " + info.CustomerInfo.Rows[0][3].ToString(); lblDate.Text = info.CustomerInfo.Rows[0][1].ToString(); } }
public static void ViewCustomer(CsReceiptInfo vinfo) { string iQuery = string.Format(@" SELECT TOP 1 O.ORDERCUSTOMERNO AS CUSTOMERNO, CONVERT(VARCHAR(11),CONVERT(DATE,O.ORDERDATE)) AS ORDERDATE, (C.FNAME + ' ' + C.LNAME) AS NAME, C.Email AS EMAIL FROM TBLORDER O JOIN TBLORDERITEM OI ON O.ORDERNO = OI.ORDERID JOIN TBLCUSTOMER C ON O.ORDERCUSTOMERNO = C.CUSTOMERID WHERE O.ORDERNO = ('{0}')", vinfo.OrderNum); cmdString = new SqlCommand(iQuery, cntString); try { cntString.Open(); SqlDataAdapter da = new SqlDataAdapter(cmdString); DataSet ds = new DataSet(); da.Fill(ds); vinfo.CustomerInfo = ds.Tables[0]; } catch { } finally { cntString.Close(); } }