private void displayDetails() { if (ViewState[Constant.SESSION_BIDREFNO] != null) { BidItem biditem = BidItemTransaction.QueryBidItemInfo(connstring, ViewState[Constant.SESSION_BIDREFNO].ToString().Trim()); CategoryTransaction category = new CategoryTransaction(); GroupDeptSecTransaction grp = new GroupDeptSecTransaction(); CompanyTransaction cmp = new CompanyTransaction(); IncotermTransaction inc = new IncotermTransaction(); OtherTransaction dte = new OtherTransaction(); lblCompany.Text = cmp.GetCompanyName(connstring, biditem.CompanyId.ToString().Trim()); lblRequestor.Text = biditem.Requestor.ToString().Trim(); lblPRNumber.Text = biditem.PRRefNo.ToString().Trim(); lblPRDate.Text = biditem.PRDate.ToString().Trim(); lblGroup.Text = grp.GetGroupDeptSecNameById(connstring, biditem.GroupDeptSec.ToString().Trim()); lblBidReferenceNumber.Text = biditem.BidRefNo.ToString().Trim(); lblSubCategory.Text = category.GetCategoryNameById(connstring, biditem.Category.ToString().Trim()); lblBidSubmissionDeadline.Text = biditem.Deadline.ToString().Trim(); lblBidItemDescription.Text = biditem.ItemDescription; lblDeliverTo.Text = biditem.DeliverTo; lblIncoterm.Text = inc.GetIncotermName(connstring, biditem.Incoterm); hdBidEventType.Value = biditem.BidStatus.ToString().Trim(); displayItemDetails(); displaySuppliers(); } }
protected void Page_Load(object sender, System.EventArgs e) { FormsAuthenticationHelper.AuthenticateUserWithReturnUrl(); connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString()); if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.VENDOR) { Response.Redirect("../unauthorizedaccess.aspx"); } if (!(IsPostBack)) { if (Session[Constant.SESSION_USERID] != null) { ViewState[Constant.SESSION_USERID] = Session[Constant.SESSION_USERID].ToString().Trim(); // Get bid general details if (Session[Constant.SESSION_BIDREFNO] != null) { ViewState[Constant.SESSION_BIDREFNO] = Session[Constant.SESSION_BIDREFNO].ToString().Trim(); } CategoryTransaction catTrans = new CategoryTransaction(); BidItem bidItem = BidItemTransaction.GetBidDetailsByRefNo(ViewState[Constant.SESSION_BIDREFNO].ToString().Trim()); lblPRNumber.Text = bidItem.PRRefNo.ToString(); lblBidReferenceNumber.Text = bidItem.BidRefNo.ToString(); lblCategory.Text = catTrans.GetCategoryByID(bidItem.Category).CategoryName; lblBidSubmissionDeadline.Text = bidItem.Deadline; lblDeliveryDate.Text = bidItem.DeliveryDate; lblBidItemDescription.Text = bidItem.ItemDescription; ShowBidTenders(); } } }
protected void gvBids_RowCommand(object sender, GridViewCommandEventArgs e) { GridViewRow gvr = ((Control)e.CommandSource).NamingContainer as GridViewRow; switch (e.CommandName) { case "ViewBidEventDetails": { Session[Constant.SESSION_BIDREFNO] = e.CommandArgument.ToString(); Response.Redirect("biddetails.aspx"); } break; case "ViewBidItemDetails": { string[] args = e.CommandArgument.ToString().Split(new char[] { '|' }); Session[Constant.SESSION_BIDDETAILNO] = args[1]; Session[Constant.SESSION_BIDREFNO] = args[0]; Response.Redirect("withdrawnbiditemdetails.aspx"); } break; case "Approve": { int biddetailno = int.Parse(e.CommandArgument.ToString()); if (BidItemTransaction.WithdrawBidItem(connstring, biddetailno, Constant.BIDITEM_STATUS.WITHDRAWAL_STATUS.WITHDRAWNED)) { Response.Redirect("withdrawnedbiditems.aspx"); } } break; } }
public ArrayList GetSubmittedBidTendersByUserId(string connstring, int VendorId) { ArrayList arrBidItemTenders = new ArrayList(); SqlParameter[] sqlParams = new SqlParameter[2]; sqlParams[0] = new SqlParameter("@VendorId", SqlDbType.Int); sqlParams[0].Value = VendorId; sqlParams[1] = new SqlParameter("@BID_STATUS_SUBMITTED", SqlDbType.Int); sqlParams[1].Value = Constant.BID_TENDER_STATUS_SUBMITTED.ToString().Trim(); DataSet ds = SqlHelper.ExecuteDataset(connstring, CommandType.StoredProcedure, "[s3p_EBid_GetSubmittedBidTendersByUserId]", sqlParams); DataTable dt = new DataTable(); //BidItemTransaction bidItemTransaction = new BidItemTransaction(); if (ds.Tables.Count > 0) { dt = ds.Tables[0]; if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { arrBidItemTenders.Add(BidItemTransaction.GetBidDetailsByRefNo(connstring, row["BidRefNo"].ToString())); } } } return(arrBidItemTenders); }
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.BUYER) { Response.Redirect("../unauthorizedaccess.aspx"); } if (!(IsPostBack)) { string strBidTenderNos = Session["hdnBidTenderNos"].ToString().Trim(); strBidTenderNos = strBidTenderNos.Replace(Convert.ToChar("|"), Convert.ToChar(",")); DataTable dt = new DataTable(); if (strBidTenderNos.ToString().Trim() != "") { BidTenderTransaction bt = new BidTenderTransaction(); dt = bt.GetEndorsedBidTenders(connstring, strBidTenderNos); } gvBids.DataSource = dt; gvBids.DataBind(); lblBidName.Text = BidItemTransaction.GetBidName(connstring, Session["BidRefNo"].ToString().Trim()); } }
private void displaySuppliers() { //BidItemTransaction vnd = new BidItemTransaction(); gvInvitedSuppliers.DataSource = BidItemTransaction.GetSuppliers(connstring, ViewState[Constant.SESSION_BIDREFNO].ToString().Trim()); // gvInvitedSuppliers.DataSource = dtVendors; gvInvitedSuppliers.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.BUYER) { Response.Redirect("../unauthorizedaccess.aspx"); } if (Request.QueryString["brn"] != null) { Session[Constant.SESSION_BIDREFNO] = Request.QueryString["brn"].ToString(); } if (!(Page.IsPostBack)) { if (Request.QueryString[Constant.SESSION_BIDREFNO] != null) { Session[Constant.SESSION_BIDREFNO] = Request.QueryString[Constant.SESSION_BIDREFNO].ToString().Trim(); } if (Session["ORDERBY"] == null) { Session["ORDERBY"] = "DESC"; } BidItem bid = BidItemTransaction.QueryBidItemInfo(connstring, Session[Constant.SESSION_BIDREFNO].ToString()); BuyerTransaction buyer = new BuyerTransaction(); CategoryTransaction category = new CategoryTransaction(); GroupDeptSecTransaction grp = new GroupDeptSecTransaction(); CompanyTransaction cmp = new CompanyTransaction(); VendorTransaction vnd = new VendorTransaction(); IncotermTransaction inc = new IncotermTransaction(); OtherTransaction obj = new OtherTransaction(); lblBidReferenceNumber.Text = bid.BidRefNo.ToString().Trim(); lblCompany.Text = cmp.GetCompanyName(connstring, bid.CompanyId.ToString().Trim()); lblRequestor.Text = bid.Requestor.ToString().Trim(); lblPRNumber.Text = bid.PRRefNo.ToString().Trim(); lblPRDate.Text = bid.PRDate.ToString().Trim(); lblGroup.Text = grp.GetGroupDeptSecNameById(connstring, bid.GroupDeptSec.ToString().Trim()); lblBidRefNo.Text = bid.BidRefNo.ToString().Trim(); lblSubCategory.Text = category.GetCategoryNameById(connstring, bid.Category.ToString().Trim()); lblBidSubmissionDeadline.Text = bid.Deadline.ToString().Trim(); lblBidItemDesc.Text = bid.ItemDescription.ToString().Trim(); lblDeliverTo.Text = bid.DeliverTo.ToString().Trim(); lblIncoterm.Text = inc.GetIncotermName(connstring, bid.Incoterm.ToString().Trim()); DisplayDetails(); Bind(); } }
private void ShowBidInfo() { CategoryTransaction catTrans = new CategoryTransaction(); BidItem bid = new BidItem(); bid = BidItemTransaction.QueryFactsAboutABidItemByBidRefNo(ViewState[Constant.SESSION_BIDREFNO].ToString().Trim()); lblBidReferenceNumber.Text = bid.BidRefNo.ToString(); lblCategory.Text = ((Category)catTrans.GetCategoryByID(bid.Category)).CategoryName; lblBidSubmissionDeadline.Text = bid.Deadline; lblDeliveryDate.Text = bid.DeliveryDate; lblDeliverTo.Text = bid.DeliverTo; }
protected void btnSubmit_Click(object sender, EventArgs e) { BidTenderTransaction bt = new BidTenderTransaction(); string strBidTenderNos = Session["hdnBidTenderNos"].ToString().Trim(); string[] strBidTenderNos1 = strBidTenderNos.Split(Convert.ToChar("|")); for (int i = 0; i < strBidTenderNos1.Length; i++) { bt.EndorseBidTender(connstring, strBidTenderNos1[i].ToString().Trim()); } BidItemTransaction.UpdateBidStatusToEndorsed(connstring, Session["BidRefNo"].ToString().Trim()); Response.Redirect("endorsementconfirmation.aspx"); }
private void FillBidInfo() {// Get bid general details CategoryTransaction cat = new CategoryTransaction(); IncotermTransaction inc = new IncotermTransaction(); CompanyTransaction cmp = new CompanyTransaction(); BidItem bid = BidItemTransaction.GetBidDetailsByRefNo(hdnBidRefNo.Value.Trim()); lblCompany.Text = cmp.GetCompanyName(connstring, bid.CompanyId.ToString().Trim()); lblCategory.Text = cat.GetCategoryNameById(bid.Category.ToString().Trim()); lblBidReferenceNumber.Text = bid.BidRefNo.ToString(); lblBidSubmissionDeadline.Text = bid.Deadline; lblBidItemDescription.Text = bid.ItemDescription; lblDeliverTo.Text = bid.DeliverTo; lblPreferredIncoterm.Text = inc.GetIncotermName(connstring, bid.Incoterm); }
protected void lnkWithdraw_Click(object sender, EventArgs e) { if (Session[Constant.SESSION_BIDDETAILNO] != null) { int biddetailno = int.Parse(Session[Constant.SESSION_BIDDETAILNO].ToString()); if (BidItemTransaction.WithdrawBidItem(connstring, biddetailno, Constant.BIDITEM_STATUS.WITHDRAWAL_STATUS.APPROVED)) { GetAllVendorsInfoByBidRef(biddetailno); SendEmailToVendors(); Response.Redirect("withdrawnedbiditems.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) { FormsAuthenticationHelper.AuthenticateUserWithReturnUrl(); if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.VENDOR) { Response.Redirect("../unauthorizedaccess.aspx"); } PageTitle.InnerText = String.Format(Constant.TITLEFORMAT, "Confirmation"); if (!(Page.IsPostBack)) { if (Session[Constant.SESSION_USERID] != null) { lnkBidName.NavigateUrl = "BidDetailsSubmitted.aspx"; lnkBidName.Text = BidItemTransaction.GetBidName(Session[Constant.SESSION_BIDREFNO].ToString().Trim()); } } }
private void UpdateBidForAuctionStatus(int vStatus) { // Convert the bid item first before the tenders // get bid item BidItem bidItem = BidItemTransaction.QueryBidInfo(connstring, Session[Constant.SESSION_BIDREFNO].ToString()); if (vStatus == Constant.BID_STATUS_APPROVED_FOR_AUCTION) { BidItemTransaction.UpdateBidForAuctionStatus(connstring, bidItem.BidRefNo.ToString(), vStatus); string dummyVar = Constant.BLANK; // save a copy to tblAuctionItem string vAuctionRefNo = ""; AuctionTransaction auctionTransaction = new AuctionTransaction(); auctionTransaction.InsertAuctionItem(connstring, bidItem.PRRefNo.ToString(), bidItem.Requestor, bidItem.ItemDescription, bidItem.BuyerId.ToString(), bidItem.GroupDeptSec.ToString(), bidItem.Category.ToString(), Constant.BLANK, Constant.AUCTION_STATUS_DRAFT.ToString(), bidItem.DeliveryDate.ToString(), bidItem.CompanyId.ToString(), Constant.AUCTION_TYPE_REVERSE.ToString(), Constant.BLANK, Constant.BLANK, Constant.BLANK, Constant.BLANK, bidItem.BidRefNo.ToString(), bidItem.PRDate.ToString().Trim(), //Constant.BLANK, //Constant.BLANK, ref vAuctionRefNo); } // convert and create a copy of the bid tender to auction tenders // start here }
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.VENDOR) { Response.Redirect("../unauthorizedaccess.aspx"); } PageTitle.InnerText = String.Format(Constant.TITLEFORMAT, "Decline Bid Event"); if (!(IsPostBack)) { if (Session[Constant.SESSION_BIDREFNO] != null) { ViewState[Constant.SESSION_BIDREFNO] = Session[Constant.SESSION_BIDREFNO].ToString().Trim(); } lnkBidItemName.Text = BidItemTransaction.GetBidName(connstring, ViewState["BidRefNo"].ToString().Trim()); } }
protected void btnSubmit_Click(object sender, EventArgs e) { BidItemTransaction.UpdateBidStatus(connstring, ViewState["BidRefNo"].ToString().Trim(), Constant.BID_STATUS_SUBMITTED.ToString().Trim()); Session["BidRefNo"] = lblBidRefNum.Text; Response.Redirect("bidsubmit.aspx"); }
private void UpdateBidForAuctionStatus(int vStatus) { // get bid item BidItem bidItem = BidItemTransaction.QueryBidInfo(connstring, Session[Constant.SESSION_BIDREFNO].ToString()); if (vStatus == Constant.BID_STATUS_APPROVED_FOR_AUCTION) { BidItemTransaction.UpdateBidForAuctionStatus(connstring, bidItem.BidRefNo.ToString(), vStatus); string dummyVar = Constant.BLANK; // save a copy to tblAuctionItem string vAuctionRefNo = ""; AuctionTransaction auctionTransaction = new AuctionTransaction(); auctionTransaction.InsertAuctionItem(connstring, bidItem.PRRefNo.ToString(), bidItem.Requestor, bidItem.ItemDescription, bidItem.BuyerId.ToString(), bidItem.GroupDeptSec.ToString(), bidItem.Category.ToString(), bidItem.SubCategory.ToString(), Constant.AUCTION_STATUS_APPROVED.ToString(), bidItem.DeliveryDate.ToString(), bidItem.CompanyId.ToString(), Constant.AUCTION_TYPE_REVERSE.ToString(), Constant.BLANK, Constant.BLANK, Constant.BLANK, bidItem.BidCurrency.ToString(), bidItem.BidRefNo.ToString(), bidItem.PRDate.ToString().Trim(), //Constant.BLANK, //Constant.BLANK, ref vAuctionRefNo); // copy the bid item details to auction item details BidItemDetailTransaction detailTransaction = new BidItemDetailTransaction(); ArrayList arrBidItemDetails = detailTransaction.GetBidDetails(connstring, Session[Constant.SESSION_BIDREFNO].ToString()); foreach (BidItemDetail bidDetail in arrBidItemDetails) { string vAuctionDetailNo = ""; // insert auction detail to database auctionTransaction.InsertAuctionItemDetails( connstring, bidDetail.Item, bidDetail.DetailDesc, bidDetail.Qty.ToString(), bidDetail.UnitOfMeasure, Constant.AUCTION_STATUS_APPROVED.ToString(), vAuctionRefNo, bidItem.Category.ToString(), bidItem.SubCategory.ToString(), "", "", "0", "0", ref vAuctionDetailNo); } } Response.Redirect("bidsforconversion.aspx"); }
protected void Page_Load(object sender, System.EventArgs e) { FormsAuthenticationHelper.AuthenticateUserWithReturnUrl(); connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString()); if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.BUYER) { Response.Redirect("../unauthorizedaccess.aspx"); } if (!(Page.IsPostBack)) { if (Session["BidRefNo"] != null) { hdnBidRefNo.Value = Session["BidRefNo"].ToString().Trim(); BidItem bid = BidItemTransaction.QueryBidItemInfo(connstring, hdnBidRefNo.Value.Trim()); BuyerTransaction buyer = new BuyerTransaction(); CategoryTransaction category = new CategoryTransaction(); GroupDeptSecTransaction grp = new GroupDeptSecTransaction(); CompanyTransaction cmp = new CompanyTransaction(); SupplierTransaction vnd = new SupplierTransaction(); IncotermTransaction inc = new IncotermTransaction(); OtherTransaction dte = new OtherTransaction(); lblCompany.Text = cmp.GetCompanyName(connstring, bid.CompanyId.ToString().Trim()); lblRequestor.Text = bid.Requestor.ToString().Trim(); lblPRNumber.Text = bid.PRRefNo.ToString().Trim(); lblPRDate.Text = bid.PRDate.ToString().Trim(); lblGroup.Text = grp.GetGroupDeptSecNameById(connstring, bid.GroupDeptSec.ToString().Trim()); lblBidReferenceNo.Text = bid.BidRefNo.ToString().Trim(); lblSubCategory.Text = category.GetCategoryNameById(connstring, bid.Category.ToString().Trim()); lblBidSubmissionDeadline.Text = bid.Deadline.ToString().Trim(); lblBidItemDescription.Text = bid.ItemDescription.ToString().Trim(); lblDeliverTo.Text = bid.DeliverTo.ToString().Trim(); lblIncoterm.Text = inc.GetIncotermName(connstring, bid.Incoterm.ToString().Trim()); lblBidRefNo2.Text = bid.BidRefNo.ToString().Trim(); FillBidItemDetails(); //no checking because when bids are submitted they have suppliers gvSuppliers.DataSource = BidItemTransaction.GetSuppliers(connstring, hdnBidRefNo.Value.Trim()); gvSuppliers.DataBind(); //DataTable dtFileAttachment = new DataTable(); //DataColumn dcol1 = new DataColumn("FILES", typeof(System.String)); //dtFileAttachment.Columns.Add(dcol1); //string Files = bid.FileAttachments; //string[] Files1 = Files.Split(Convert.ToChar("|")); //for (int i = 0; i < Files1.Length; i++) //{ // //Create a new row // DataRow drow = dtFileAttachment.NewRow(); // drow["FILES"] = Files1[i]; // dtFileAttachment.Rows.Add(drow); //} //gvFileAttachments.DataSource = dtFileAttachment; //gvFileAttachments.DataBind(); } else { Response.Redirect("index.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { FormsAuthenticationHelper.AuthenticateUserWithReturnUrl(); connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString()); PageTitle.InnerText = String.Format(Constant.TITLEFORMAT, "Search Result"); if (!(IsPostBack)) { if ((Session[Constant.SESSION_USERID] != null) && (Session[Constant.SESSION_USERTYPE] != null)) { ViewState[Constant.SESSION_USERID] = Int32.Parse(Session[Constant.SESSION_USERID].ToString().Trim()); int userID = Int32.Parse(ViewState[Constant.SESSION_USERID].ToString().Trim()); int usertype = Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()); string searchstring = ""; int searchType = 1; if (Request.QueryString["searchstring"] != null) { searchstring = Request.QueryString["searchstring"].ToString().Trim(); } if (Request.QueryString["searchType"] != null) { searchType = Int32.Parse(Request.QueryString["searchType"].ToString().Trim()); } if ((searchType >= 1) && (searchType <= 6)) { if ((searchType >= 1) && (searchType <= 3)) { gvSearchResultForItems.Columns[0].HeaderText = "Bid Reference No."; gvSearchResultForItems.Columns[1].HeaderText = "Bid Items"; } else { gvSearchResultForItems.Columns[0].HeaderText = "Auction Reference No."; gvSearchResultForItems.Columns[1].HeaderText = "Auction Items"; } gvSearchResultForItems.Visible = true; // BidItemTransaction items = new BidItemTransaction(); DataTable dtItems = BidItemTransaction.QuerySearchedItemByItemDesc(connstring, searchType, searchstring, usertype, userID); if (dtItems.Rows.Count > 0) { DataView dvItems = new DataView(dtItems); gvSearchResultForItems.DataSource = dvItems; gvSearchResultForItems.DataBind(); } else { lblIsEmpty.Visible = true; lblIsEmpty.Text = "No matches for '" + searchstring + "' found."; } } else if (searchType == 7) { ProductsTransaction products = new ProductsTransaction(); DataTable dtProducts = products.QueryProductsViaName(connstring, searchstring); // DataView dvProducts = new DataView(dtProducts); if (dtProducts.Rows.Count > 0) { gvProducts.Visible = true; gvProducts.DataSource = dtProducts; gvProducts.DataBind(); } else { lblIsEmpty.Visible = true; lblIsEmpty.Text = "No matches for '" + searchstring + "' found."; } } else if (searchType == 8) { CompanyTransaction vendor = new CompanyTransaction(); DataTable dtVendor = vendor.QueryVendorSearch(connstring, searchstring); if (dtVendor.Rows.Count > 0) { DataView dvVendor = new DataView(dtVendor); gvSuppliers.Visible = true; gvSuppliers.DataSource = dvVendor; gvSuppliers.DataBind(); } else { lblIsEmpty.Visible = true; lblIsEmpty.Text = "No matches for '" + searchstring + "' found."; } } } } }
protected void gridView_PageIndexChanging(object sender, GridViewPageEventArgs e) { ViewState[Constant.SESSION_USERID] = Int32.Parse(Session[Constant.SESSION_USERID].ToString().Trim()); int userID = Int32.Parse(ViewState[Constant.SESSION_USERID].ToString().Trim()); string usertype = Session[Constant.SESSION_USERTYPE].ToString().Trim(); if (Request.QueryString["usertype"] != null) { usertype = Request.QueryString["usertype"].ToString().Trim(); } string searchstring = ""; if (Request.QueryString["searchstring"] != null) { searchstring = Request.QueryString["searchstring"].ToString().Trim(); } string searchType = "1"; if (Request.QueryString["searchType"] != null) { searchType = Request.QueryString["searchType"].ToString().Trim(); } if ((Int32.Parse(searchType) >= 1) && (Int32.Parse(searchType) <= 6)) { if ((Int32.Parse(searchType) >= 1) && (Int32.Parse(searchType) <= 3)) { gvSearchResultForItems.Columns[0].HeaderText = "Bid Reference No."; gvSearchResultForItems.Columns[1].HeaderText = "Bid Items"; } else { gvSearchResultForItems.Columns[0].HeaderText = "Auction Reference No."; gvSearchResultForItems.Columns[1].HeaderText = "Auction Items"; } gvSearchResultForItems.Visible = true; DataTable dtItems = BidItemTransaction.QuerySearchedItemByItemDesc(connstring, Int32.Parse(searchType), searchstring, Int32.Parse(usertype), userID); DataView dvItems = new DataView(dtItems); gvSearchResultForItems.DataSource = dvItems; gvSearchResultForItems.PageIndex = e.NewPageIndex; gvSearchResultForItems.DataBind(); } else if (Int32.Parse(searchType) == 7) { ProductsTransaction products = new ProductsTransaction(); DataTable dtProducts = products.QueryProductsViaName(connstring, searchstring); gvProducts.Visible = true; gvProducts.DataSource = dtProducts; gvProducts.PageIndex = e.NewPageIndex; gvProducts.DataBind(); } else if (Int32.Parse(searchType) == 8) { CompanyTransaction vendor = new CompanyTransaction(); DataTable dtVendor = vendor.QueryVendorSearch(connstring, searchstring); DataView dvVendor = new DataView(dtVendor); gvSuppliers.Visible = true; gvSuppliers.DataSource = dvVendor; gvSuppliers.PageIndex = e.NewPageIndex; gvSuppliers.DataBind(); } }
private DataTable CreateDataSource() { DataTable dtDrafts = BidItemTransaction.QueryAwardedSuppliers(connstring, Session[Constant.SESSION_USERID].ToString(), Session[Constant.SESSION_BIDREFNO].ToString(), Session["ORDERBY"].ToString()); return(dtDrafts); }
protected void gvBidItemDetails_RowCommand(object sender, GridViewCommandEventArgs e) { switch (e.CommandName) { case "withdraw": { GridViewRow row = ((Control)e.CommandSource).NamingContainer as GridViewRow; Panel tmp_pnlcommand = (Panel)row.FindControl("pnlLinks"); Panel tmp_pnlcomment = (Panel)row.FindControl("pnlComments"); tmp_pnlcommand.Visible = false; tmp_pnlcomment.Visible = true; } break; case "continuewithdraw": { if (BidItemTransaction.WithdrawBidItem(connstring, int.Parse(e.CommandArgument.ToString()), Constant.BIDITEM_STATUS.WITHDRAWAL_STATUS.WITHDRAWNED)) { GridViewRow row = ((Control)e.CommandSource).NamingContainer as GridViewRow; TextBox tmp_txtComment = (TextBox)row.FindControl("txtComment"); CheckBox tmp_chkBox = (CheckBox)row.FindControl("chkAlowVendorView"); InsertWithdrawnedItemComments(int.Parse(e.CommandArgument.ToString()), tmp_txtComment.Text.ToString().Trim(), Session[Constant.SESSION_USERID].ToString(), tmp_chkBox.Checked); GetAllVendorsInfoByBidRef(int.Parse(e.CommandArgument.ToString())); SendEmailToVendors(); #region Dev Richard - Send SMS Notification ArrayList recipients = GetSelectedSuppliers(); GridViewRow lblItemRow = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; Label lblItem = (Label)gvBidItemDetails.Rows[row.RowIndex].FindControl("lblItem"); for (int a = 0; a < recipients.Count; a++) { BidParticipant p = (BidParticipant)recipients[a]; String mobileNo = p.MobileNo; if (SMSHelper.AreValidMobileNumbers(mobileNo.Trim())) { String textMessage = "“We wish to inform you that '" + lblItem.Text + "' has been withdrawn. Kindly go to your portal account under Withdrawn bid Items for details.”"; try { SMSHelper.SendSMS(new SMSMessage(textMessage, mobileNo)); } catch { } } } #endregion Response.Redirect("withdrawnedbiditems.aspx"); } } break; case "cancelwithdraw": { GridViewRow row = ((Control)e.CommandSource).NamingContainer as GridViewRow; Panel tmp_pnlcommand = (Panel)row.FindControl("pnlLinks"); Panel tmp_pnlcomment = (Panel)row.FindControl("pnlComments"); TextBox tmp_txtComment = (TextBox)row.FindControl("txtComment"); tmp_pnlcommand.Visible = true; tmp_pnlcomment.Visible = false; tmp_txtComment.Text = ""; } break; } }
private void Display() { BidItem biditem = BidItemTransaction.QueryBidItemInfo(connstring, ViewState["BidRefNo"].ToString().Trim()); //BidItemInfo biditem = obj.Query("91000"); BuyerTransaction buyer = new BuyerTransaction(); CategoryTransaction category = new CategoryTransaction(); GroupDeptSecTransaction grp = new GroupDeptSecTransaction(); CompanyTransaction cmp = new CompanyTransaction(); IncotermTransaction inc = new IncotermTransaction(); OtherTransaction dte = new OtherTransaction(); lblCompany.Text = cmp.GetCompanyName(connstring, biditem.CompanyId.ToString().Trim()); lblRequestorName.Text = biditem.Requestor.ToString().Trim(); lblPRNumber.Text = biditem.PRRefNo.ToString().Trim(); lblPRDate.Text = biditem.PRDate.ToString().Trim(); lblGroupDeptSec.Text = grp.GetGroupDeptSecNameById(connstring, biditem.GroupDeptSec.ToString().Trim()); lblBidRefNum.Text = biditem.BidRefNo.ToString().Trim(); lblSubCategory.Text = category.GetCategoryNameById(connstring, biditem.Category.ToString().Trim()); lblBidSubmissionDeadline.Text = biditem.Deadline.ToString().Trim(); lblBidItemDescription.Text = biditem.ItemDescription; lblDeliverTo.Text = biditem.DeliverTo; lblIncoterm.Text = inc.GetIncotermName(connstring, biditem.Incoterm); DataTable dtSuppliers = new DataTable(); DataColumn dcol = new DataColumn("SUPPLIER", typeof(System.String)); dtSuppliers.Columns.Add(dcol); string suppliers = biditem.Suppliers; /* * if (suppliers != "") * btnSubmit.Enabled = true; */ string[] suppliers1 = suppliers.Split(Convert.ToChar(",")); for (int i = 0; i < suppliers1.Length; i++) { //Create a new row DataRow drow = dtSuppliers.NewRow(); drow["SUPPLIER"] = suppliers1[i]; dtSuppliers.Rows.Add(drow); } gvSuppliers.DataSource = dtSuppliers; gvSuppliers.DataBind(); DataTable dtFileAttachment = new DataTable(); DataColumn dcol1 = new DataColumn("FILES", typeof(System.String)); dtFileAttachment.Columns.Add(dcol1); string Files = biditem.FileAttachments; string[] Files1 = Files.Split(Convert.ToChar("|")); for (int i = 0; i < Files1.Length; i++) { //Create a new row DataRow drow = dtFileAttachment.NewRow(); drow["FILES"] = Files1[i]; dtFileAttachment.Rows.Add(drow); } gvFileAttachments.DataSource = dtFileAttachment; gvFileAttachments.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.BUYER) { Response.Redirect("../unauthorizedaccess.aspx"); } if (!(Page.IsPostBack)) { Session[Constant.SESSION_COMMENT_TYPE] = "0"; if (Request.QueryString["BidRefNo"] != null) { Session["BidRefNo"] = Request.QueryString["BidRefNo"].ToString().Trim(); } BidItem bid = BidItemTransaction.QueryBidItemInfo(connstring, Request.QueryString["BidRefNo"].ToString().Trim()); BuyerTransaction buyer = new BuyerTransaction(); CategoryTransaction category = new CategoryTransaction(); GroupDeptSecTransaction grp = new GroupDeptSecTransaction(); CompanyTransaction cmp = new CompanyTransaction(); VendorTransaction vnd = new VendorTransaction(); IncotermTransaction inc = new IncotermTransaction(); OtherTransaction obj = new OtherTransaction(); lblCompany.Text = cmp.GetCompanyName(connstring, bid.CompanyId.ToString().Trim()); lblRequestor.Text = bid.Requestor.ToString().Trim(); lblPRNumber.Text = bid.PRRefNo.ToString().Trim(); lblPRDate.Text = bid.PRDate.ToString().Trim(); lblGroup.Text = grp.GetGroupDeptSecNameById(connstring, bid.GroupDeptSec.ToString().Trim()); lblBidRefNo.Text = bid.BidRefNo.ToString().Trim(); lblSubCategory.Text = category.GetCategoryNameById(connstring, bid.Category.ToString().Trim()); lblBidSubmissionDeadline.Text = bid.Deadline.ToString().Trim(); lblBidItemDesc.Text = bid.ItemDescription.ToString().Trim(); lblDeliverTo.Text = bid.DeliverTo.ToString().Trim(); lblIncoterm.Text = inc.GetIncotermName(connstring, bid.Incoterm.ToString().Trim()); DataTable dtSuppliers = BidItemTransaction.GetSuppliers(connstring, Session["BidRefNo"].ToString().Trim()); gvSuppliers.DataSource = dtSuppliers; gvSuppliers.DataBind(); DataTable dtFileAttachment = new DataTable(); DataColumn dcol1 = new DataColumn("FILES", typeof(System.String)); dtFileAttachment.Columns.Add(dcol1); string Files = bid.FileAttachments; string[] Files1 = Files.Split(Convert.ToChar("|")); for (int i = 0; i < Files1.Length; i++) { //Create a new row DataRow drow = dtFileAttachment.NewRow(); drow["FILES"] = Files1[i]; dtFileAttachment.Rows.Add(drow); } gvFileAttachments.DataSource = dtFileAttachment; gvFileAttachments.DataBind(); } }
private DataTable CreateDataSource() { DataTable dtDrafts = BidItemTransaction.QueryRenegotiateBidItemsSent(connstring, Session[Constant.SESSION_USERID].ToString()); return(dtDrafts); }