protected DataSet involvementSelect() { poDll.PurchaseOrder selectInv = new poDll.PurchaseOrder(); DataSet ds = new DataSet(); ds = selectInv.INVOLVEMENT_Select((string)Session["StarID"]); return(ds); }
protected DataSet studentSelect() { poDll.PurchaseOrder dsStudent = new poDll.PurchaseOrder(); DataSet ds = new DataSet(); ds = dsStudent.STUDENT_Select("ab1234cd", "password"); return(ds); }
protected DataSet purchase() { DataSet ds = new DataSet(); poDll.PurchaseOrder dll = new poDll.PurchaseOrder(); ds = dll.PURCHASE_Select((string)Session["StarID"]); return(ds); }
protected void Page_Load(object sender, EventArgs e) { if ((string)Session["StarID"] == null) { Response.Redirect("Login.aspx"); } poDll.PurchaseOrder dll = new poDll.PurchaseOrder(); lblPoNumber.Text = dll.PURCHASE_GetNextPoNum(); btnSummate.Text = "Sum Totals"; btnSubmit.Visible = false; }
protected void btnViewPurchase_Click(object sender, EventArgs e) { poDll.PurchaseOrder selectInv = new poDll.PurchaseOrder(); DataSet ds = new DataSet(); int poNum = Int32.Parse(dlPurchases.Text); ds = selectInv.PURCHASE_Select(poNum); GridView3.DataSource = ds; GridView3.DataBind(); btnDownload.Visible = true; }
protected void btnAddClub_Click(object sender, EventArgs e) { poDll.PurchaseOrder add = new poDll.PurchaseOrder(); string club = dlClubs.Text.Trim(); int totalRows; string starID = (string)Session["StarID"].ToString(); if (starID == "") { lblAddError.Text = "Something went wrong, please logout and login then try again"; } else { totalRows = add.INVOLVEMENT_Add(starID, club); lblAddSuccess.Text = "Sucessfully added " + club + " to your Involvement list"; } }
protected void btnDownload_Click(object sender, EventArgs e) { poDll.PurchaseOrder selectInv = new poDll.PurchaseOrder(); DataSet ds = new DataSet(); int poNum = Int32.Parse(dlPurchases.Text); ds = selectInv.PURCHASE_Select(poNum); if (ds.Tables[0].Rows.Count < 1) { lblError.Text = "No results. Could not download."; } else { Download(ds); } }
protected void btnRmClub_Click(object sender, EventArgs e) { poDll.PurchaseOrder add = new poDll.PurchaseOrder(); string club = dlClubs2.Text.Trim(); int totalRows; string starID = (string)Session["StarID"].ToString(); if (starID == "") { lblRmError.Text = "Something went wrong, please logout and login then try again"; } else { totalRows = add.INVOLVEMENT_Remove(starID, club); lblRmSuccess.Text = "Sucessfully removed " + club + " from your Involvement list"; Response.Redirect(Request.Url.AbsoluteUri); } }
protected void btnSummate_Click(object sender, EventArgs e) { poDll.PurchaseOrder dll = new poDll.PurchaseOrder(); if (btnSummate.Text == "Sum Totals" && tbUnitPrice1.Text != "") { float up1 = float.Parse(tbUnitPrice1.Text, CultureInfo.InvariantCulture); int q1 = Int32.Parse(tbQuantity1.Text); tbFinalAmount1.Text = (up1 * q1).ToString(); if (tbItem2.Text != "") { float up2 = float.Parse(tbUnitPrice2.Text, CultureInfo.InvariantCulture); int q2 = Int32.Parse(tbQuantity2.Text); tbFinalAmount2.Text = (up2 * q2).ToString(); } if (tbItem3.Text != "") { float up3 = float.Parse(tbUnitPrice3.Text, CultureInfo.InvariantCulture); int q3 = Int32.Parse(tbQuantity3.Text); tbFinalAmount3.Text = (up3 * q3).ToString(); } if (tbItem4.Text != "") { float up4 = float.Parse(tbUnitPrice4.Text, CultureInfo.InvariantCulture); int q4 = Int32.Parse(tbQuantity4.Text); tbFinalAmount4.Text = (up4 * q4).ToString(); } if (tbItem5.Text != "") { float up5 = float.Parse(tbUnitPrice5.Text, CultureInfo.InvariantCulture); int q5 = Int32.Parse(tbQuantity5.Text); tbFinalAmount5.Text = (up5 * q5).ToString(); } btnSummate.Visible = false; btnSubmit.Visible = true; btnSubmit.Text = "Submit Purchase Order"; } }
protected void btnSubmit_Click(object sender, EventArgs e) { poDll.PurchaseOrder dll = new poDll.PurchaseOrder(); if (tbItem1.Text != "") { string orderBy = Session["StarID"].ToString(); string vendor = dlVendor.Text; int oNum = Int32.Parse(lblPoNumber.Text); int lNum = Int32.Parse(lblLine1.Text); string item = tbItem1.Text; int qty = Int32.Parse(tbQuantity1.Text); float uPrice = float.Parse(tbUnitPrice1.Text, CultureInfo.InvariantCulture); float fPrice = float.Parse(tbFinalAmount1.Text, CultureInfo.InvariantCulture); int iTotalRows; iTotalRows = dll.PURCHASE_Insert(oNum, lNum, item, qty, uPrice, fPrice, orderBy, vendor); if (iTotalRows > 0) { lblMessage.Text = "Your Order was recieved Succesfully"; } } if (tbItem2.Text != "") { string orderBy = Session["StarID"].ToString(); string vendor = dlVendor.Text; int oNum = Int32.Parse(lblPoNumber.Text); int lNum = Int32.Parse(lblLine2.Text); string item = tbItem1.Text; int qty = Int32.Parse(tbQuantity2.Text); float uPrice = float.Parse(tbUnitPrice2.Text, CultureInfo.InvariantCulture); float fPrice = float.Parse(tbFinalAmount2.Text, CultureInfo.InvariantCulture); int iTotalRows; iTotalRows = dll.PURCHASE_Insert(oNum, lNum, item, qty, uPrice, fPrice, orderBy, vendor); if (iTotalRows > 0) { lblMessage.Text = "Your Order was recieved Succesfully"; } } if (tbItem3.Text != "") { string orderBy = Session["StarID"].ToString(); string vendor = dlVendor.Text; int oNum = Int32.Parse(lblPoNumber.Text); int lNum = Int32.Parse(lblLine3.Text); string item = tbItem1.Text; int qty = Int32.Parse(tbQuantity3.Text); float uPrice = float.Parse(tbUnitPrice3.Text, CultureInfo.InvariantCulture); float fPrice = float.Parse(tbFinalAmount3.Text, CultureInfo.InvariantCulture); int iTotalRows; iTotalRows = dll.PURCHASE_Insert(oNum, lNum, item, qty, uPrice, fPrice, orderBy, vendor); if (iTotalRows > 0) { lblMessage.Text = "Your Order was recieved Succesfully"; } } if (tbItem4.Text != "") { string orderBy = Session["StarID"].ToString(); string vendor = dlVendor.Text; int oNum = Int32.Parse(lblPoNumber.Text); int lNum = Int32.Parse(lblLine4.Text); string item = tbItem1.Text; int qty = Int32.Parse(tbQuantity4.Text); float uPrice = float.Parse(tbUnitPrice4.Text, CultureInfo.InvariantCulture); float fPrice = float.Parse(tbFinalAmount4.Text, CultureInfo.InvariantCulture); int iTotalRows; iTotalRows = dll.PURCHASE_Insert(oNum, lNum, item, qty, uPrice, fPrice, orderBy, vendor); if (iTotalRows > 0) { lblMessage.Text = "Your Order was recieved Succesfully"; } } if (tbItem5.Text != "") { string orderBy = Session["StarID"].ToString(); string vendor = dlVendor.Text; int oNum = Int32.Parse(lblPoNumber.Text); int lNum = Int32.Parse(lblLine5.Text); string item = tbItem1.Text; int qty = Int32.Parse(tbQuantity5.Text); float uPrice = float.Parse(tbUnitPrice5.Text, CultureInfo.InvariantCulture); float fPrice = float.Parse(tbFinalAmount5.Text, CultureInfo.InvariantCulture); int iTotalRows; iTotalRows = dll.PURCHASE_Insert(oNum, lNum, item, qty, uPrice, fPrice, orderBy, vendor); if (iTotalRows > 0) { lblMessage.Text = "Your Order was recieved Succesfully"; } } }