protected void Page_Load(object sender, EventArgs e) { FormsAuthenticationHelper.AuthenticateUserWithReturnUrl(); connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString()); if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.PURCHASING) Response.Redirect("../unauthorizedaccess.aspx"); if(!IsPostBack) { if (Session[Constant.SESSION_USERID] != null) { if (Session[Constant.SESSION_BIDREFNO] != null) { ViewState[Constant.SESSION_BIDTENDERNOS] = Session["BidTenderNos"].ToString().Trim(); ViewState[Constant.SESSION_BIDREFNO] = Session[Constant.SESSION_BIDREFNO].ToString().Trim(); ViewState[Constant.SESSION_USERTYPE] = Session[Constant.SESSION_USERTYPE].ToString().Trim(); ViewState[Constant.SESSION_USERID] = Session[Constant.SESSION_USERID].ToString().Trim(); InitializeHiddenFields(); string bidTenderNos = ViewState[Constant.SESSION_BIDTENDERNOS].ToString().Trim(); string bidRefNo = ViewState[Constant.SESSION_BIDREFNO].ToString().Trim(); lblBidRefNo.Text = bidRefNo; DataTable dtEndorsed = PurchasingTransaction.QuerySelectedEndorsedItems(connstring, bidRefNo, bidTenderNos); DataView dvEndorsed = new DataView(dtEndorsed); gvEndorsedItems.DataSource = dvEndorsed; gvEndorsedItems.DataBind(); } } } }
protected void Page_Load(object sender, EventArgs e) { FormsAuthenticationHelper.AuthenticateUserWithReturnUrl(); connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString()); if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.PURCHASING) { Response.Redirect("../unauthorizedaccess.aspx"); } if (!(Page.IsPostBack)) { if (Session[Constant.SESSION_USERID] != null) { if (Session[Constant.SESSION_BIDREFNO] != null) { ViewState[Constant.SESSION_BIDREFNO] = Session[Constant.SESSION_BIDREFNO].ToString().Trim(); lnkBidItem.Text = "Bid Item " + ViewState[Constant.SESSION_BIDREFNO].ToString().Trim(); PurchasingTransaction bid = new PurchasingTransaction(); DataTable dtAwardedItems = bid.QueryAwardedItemsbyBidRefNo(connstring, ViewState[Constant.SESSION_BIDREFNO].ToString().Trim()); DataView dvAwardedItems = new DataView(dtAwardedItems); gvAwardedItems.DataSource = dvAwardedItems; gvAwardedItems.DataBind(); } } } }
protected void Submit_Click(object sender, EventArgs e) { if (ViewState["BidTenderNos"] != null) { string bidTenderNos = ViewState["BidTenderNos"].ToString().Trim(); PurchasingTransaction tender = new PurchasingTransaction(); tender.UpdateBidTenderStatus(connstring, bidTenderNos, Constant.BID_TENDER_STATUS_AWARD.ToString().Trim()); Response.Redirect("bidsforeval.aspx"); } }
protected void PurchTableDataGet() { PurchasingTransaction bid = new PurchasingTransaction(); if (ViewState[Constant.SESSION_USERID] != null) { DataTable dt = bid.QueryPurchasingTable(connstring, ViewState[Constant.SESSION_USERID].ToString().Trim()); DataView dv = new DataView(dt); Gv1.DataSource = dv; Gv1.DataBind(); } }
protected void BidForOpenDataGet() { PurchasingTransaction bid = new PurchasingTransaction(); //Response.Write(Session["AuthDepID"].ToString()); try { DataTable dt = bid.QuerySingleBidTenderStatus(connstring, ViewState["AuthDepID"].ToString()); DataView dv = new DataView(dt); GridView1.DataSource = dv; GridView1.DataBind(); } catch (System.NullReferenceException) { Response.Redirect("bidsforopening.aspx"); } }
private bool CheckIfPosted() { bool isPosted = false; try { if ((hdnIsPosted.Value.Trim() != "") && (Int32.Parse(hdnIsPosted.Value.Trim()) == 1)) { PurchasingTransaction purch = new PurchasingTransaction(); // TODO : Fix mail //SMTPEmail mail = new SMTPEmail(); string emailAdd = purch.QueryBuyerEmailAddViaBidRefNo(connstring, ViewState[Constant.SESSION_BIDREFNO].ToString().Trim(), false); if (ViewState["STATUS"] != null) { BidItemTransaction.UpdateBidStatus(connstring, ViewState[Constant.SESSION_BIDREFNO].ToString().Trim(), ViewState["STATUS"].ToString().Trim()); switch (Int32.Parse(ViewState["STATUS"].ToString().Trim())) { case 2: //mail.SendEmail(emailAdd, "*****@*****.**", "", "", "Bid Event Rejected", "Your Bid Event has been rejected please check comment for further reasons.", ""); break; case 3: //mail.SendEmail(emailAdd, "*****@*****.**", "", "", "Bid Event For Re-Edit", "Please Re-edit your Bid Event, please check comment for further reasons.", ""); break; case 4: //mail.SendEmail(emailAdd, "*****@*****.**", "", "", "Bid Event Approved", "Congratulations, your Bid Event has been approved!", ""); break; } Session.Remove("STATUS"); Session.Remove(Constant.SESSION_BIDREFNO); isPosted = true; } } } catch { isPosted = false; } return(isPosted); }
protected void Page_Load(object sender, System.EventArgs e) { PageTitle.InnerText = String.Format(Constant.TITLEFORMAT, "Home"); FormsAuthenticationHelper.AuthenticateUserWithReturnUrl(); connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString()); if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.PURCHASING) { Response.Redirect("../unauthorizedaccess.aspx"); } if (!(Page.IsPostBack)) { if ((Session[Constant.SESSION_USERID] != null) && (Session[Constant.SESSION_USERTYPE] != null)) { lblName.Text = String.Format("Welcome {0}!", Session[Constant.SESSION_USERFULLNAME].ToString()); int[] purchasing_values = PurchasingTransaction.QueryCountAll(connstring, Convert.ToInt32(Session[Constant.SESSION_USERID].ToString())); lblBidEventsForApproval.Text = "(" + purchasing_values[0].ToString() + ")"; lblApprovedBidEvents.Text = "(" + purchasing_values[1].ToString() + ")"; lblConvertedBidItems.Text = "(" + purchasing_values[11].ToString() + ")"; lblAwardedBidItems.Text = "(" + purchasing_values[4].ToString() + ")"; lblWithdrawnItems.Text = "(" + purchasing_values[13].ToString() + ")"; lblRecievedEndorsements.Text = "(" + purchasing_values[3].ToString() + ")"; lblBidTendersForRenegotiation.Text = "(" + purchasing_values[2].ToString() + ")"; lblAuctionEventsForApproval.Text = "(" + purchasing_values[5].ToString() + ")"; //lblConfirmedAuctionInvitations.Text = "(" + purchasing_values[6].ToString() + ")"; lblAwardedAuctionItems.Text = "(" + purchasing_values[7].ToString() + ")"; lblEndorsedAuctionItems.Text = "(" + purchasing_values[12].ToString() + ")"; lblOngoingAuctionEvents.Text = "(" + purchasing_values[8].ToString() + ")"; lblUpcomingAuctionEvents.Text = "(" + purchasing_values[9].ToString() + ")"; lblFinishedAuctionEvents.Text = "(" + purchasing_values[10].ToString() + ")"; } } }
private void CheckIfPosted() { string isPosted = hdnIsPosted.Value.Trim(); if (isPosted == "1") { if (ViewState["BidTenderNos"] != null) { string bidTenderNos = ViewState["BidTenderNos"].ToString().Trim(); PurchasingTransaction tender = new PurchasingTransaction(); tender.UpdateBidTenderStatus(connstring, bidTenderNos, Constant.BID_TENDER_STATUS_WAIT_FOR_RE_NEGOTIATE.ToString().Trim()); Session.Remove(Constant.SESSION_BIDREFNO); Session.Remove("BidTenderNos"); hdnIsPosted.Value = "0"; Response.Redirect("bidsforeval.aspx"); } } }
protected void Unlock_Btn_Click(object sender, EventArgs e) { string dept = null; string bidTenderGenNo = ViewState["AuthDepID"].ToString(); foreach (GridViewRow gvr in Gv1.Rows) { dept = ((Label)gvr.FindControl("lblDeptID")).Text; } if (CheckPassword()) { PurchasingTransaction bid = new PurchasingTransaction(); bid.UpdateAuthTable(connstring, dept, bidTenderGenNo); Response.Redirect("bidunlockingpage.aspx"); } else { Session["message"] = "Incorrect Password, Please Try Again."; Response.Redirect("bidunlockingpage.aspx", true); } }