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 (Session[Constant.SESSION_BIDREFNO] == null) { Response.Redirect("bidsforeval.aspx"); } PageTitle.InnerText = String.Format(Constant.TITLEFORMAT, "Bid Item Details"); if (!IsPostBack) { lnkSave2.Visible = false; LinkButton3.Visible = false; fillGrid(); //lnkComparison.NavigateUrl = "javascript://"; //lnkComparison.Attributes.Add("onclick", "javascript:__doPostBack('lnkSave',''); window.open('../reports/eventtenderscanvass.aspx?brn=' + " + Session[Constant.SESSION_BIDREFNO].ToString() + " , 'x', 'toolbar=no, menubar=no, width=950; height=790, top=80, left=80, resizable=yes, scrollbars=yes'); "); int bidrefno = 0; rvBidEventTendersComparisons.LocalReport.ReportPath = Request.PhysicalApplicationPath + @"web\reports\eventtenderscanvass.rdlc"; rvBidEventTendersComparisons.ShowReportBody = false; if (!string.IsNullOrEmpty(Session["BidRefNo"].ToString())) { if (int.TryParse(Session["BidRefNo"].ToString(), out bidrefno)) { ReportParameter[] RequestorParameter = new ReportParameter[1]; RequestorParameter[0] = new ReportParameter("BidRefNo", bidrefno.ToString()); //RequestorParameter[1] = new ReportParameter("UseAlias", "2410"); rvBidEventTendersComparisons.LocalReport.SetParameters(RequestorParameter); } rvBidEventTendersComparisons.ShowReportBody = false; } rvBidTendersForPOFileImport.ProcessingMode = ProcessingMode.Local; rvBidTendersForPOFileImport.LocalReport.ReportPath = Request.PhysicalApplicationPath + @"web\reports\bidtendersforpofileimport.rdlc"; rvBidTendersForPOFileImport.ShowReportBody = false; if (!string.IsNullOrEmpty(Session["BidRefNo"].ToString())) { if (int.TryParse(Session["BidRefNo"].ToString(), out bidrefno)) { ReportParameter[] RequestorParameter2 = new ReportParameter[1]; RequestorParameter2[0] = new ReportParameter("BidRefNo", bidrefno.ToString()); rvBidTendersForPOFileImport.LocalReport.SetParameters(RequestorParameter2); } rvBidTendersForPOFileImport.ShowReportBody = true; } } else { //GvTendersAddedCosts.DataBind(); fillGrid(); GvTenders.DataBind(); //int bidrefno = 0; //rvBidTendersForPOFileImport.ProcessingMode = ProcessingMode.Local; //rvBidTendersForPOFileImport.LocalReport.ReportPath = Request.PhysicalApplicationPath + @"web\reports\bidtendersforpofileimport.rdlc"; //rvBidTendersForPOFileImport.ShowReportBody = false; //if (!string.IsNullOrEmpty(Session["BidRefNo"].ToString())) //{ // if (int.TryParse(Session["BidRefNo"].ToString(), out bidrefno)) // { // ReportParameter[] RequestorParameter2 = new ReportParameter[1]; // RequestorParameter2[0] = new ReportParameter("BidRefNo", bidrefno.ToString()); // rvBidTendersForPOFileImport.LocalReport.SetParameters(RequestorParameter2); // } // rvBidTendersForPOFileImport.ShowReportBody = true; //} } lnkComparison.Enabled = !isEnabledComparison(); if (Session["EndorsementMessage"] != null) { lblMessage.Text = Session["EndorsementMessage"].ToString().Trim(); Session["EndorsementMessage"] = null; } }
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 (Session[Constant.SESSION_BIDREFNO] == null) { Response.Redirect("bidsforeval.aspx"); } PageTitle.InnerText = String.Format(Constant.TITLEFORMAT, "Bid Item Details"); if (!IsPostBack) { //Response.Write("not postback"); int bidrefno = 0; rvBidEventTendersComparisons.LocalReport.ReportPath = Request.PhysicalApplicationPath + @"web\reports\eventtenderscanvass.rdlc"; rvBidEventTendersComparisons.ShowReportBody = false; if (!string.IsNullOrEmpty(Session["BidRefNo"].ToString())) { if (int.TryParse(Session["BidRefNo"].ToString(), out bidrefno)) { ReportParameter[] RequestorParameter = new ReportParameter[1]; RequestorParameter[0] = new ReportParameter("BidRefNo", bidrefno.ToString()); //RequestorParameter[1] = new ReportParameter("UseAlias", "0"); rvBidEventTendersComparisons.LocalReport.SetParameters(RequestorParameter); } rvBidEventTendersComparisons.ShowReportBody = true; } //rvBidTendersForPOFileImport.ProcessingMode = ProcessingMode.Local; //rvBidTendersForPOFileImport.LocalReport.ReportPath = Request.PhysicalApplicationPath + @"web\reports\bidtendersforpofileimport.rdlc"; //rvBidTendersForPOFileImport.ShowReportBody = false; //if (!string.IsNullOrEmpty(Session["BidRefNo"].ToString())) //{ // if (int.TryParse(Session["BidRefNo"].ToString(), out bidrefno)) // { // ReportParameter[] RequestorParameter2 = new ReportParameter[1]; // RequestorParameter2[0] = new ReportParameter("BidRefNo", bidrefno.ToString()); // rvBidTendersForPOFileImport.LocalReport.SetParameters(RequestorParameter2); // } // rvBidTendersForPOFileImport.ShowReportBody = true; //} } else { GvTenders.DataBind(); } //lnkComparison.Enabled = !isEnabledComparison(); if (Session["EndorsementMessage"] != null) { lblMessage.Text = Session["EndorsementMessage"].ToString().Trim(); Session["EndorsementMessage"] = null; } }
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)) { if (Session["VendorId"] != null) { ViewState["VendorId"] = Session["VendorId"].ToString().Trim(); SupplierTransaction st = new SupplierTransaction(); Supplier s = st.QuerySuppliers(connstring, ViewState["VendorId"].ToString().Trim()); lblCompanyName.Text = s.VendorName.Trim(); lblAddressHeadOffice.Text = s.VendorAddress.Trim() + " " + s.VendorAddress1.Trim(); lblTelephone.Text = s.TelephoneNumber.Trim(); lblFax.Text = s.Fax.Trim(); lblExtension.Text = s.Extension.Trim(); lblAddressBranch.Text = s.VendorAddress2.Trim() + " " + s.VendorAddress3.Trim(); lblTelephone1.Text = s.BranchTelephoneNo.Trim(); lblFax1.Text = s.BranchFax.Trim(); lblExtension1.Text = s.BranchExtension.Trim(); lblVatRegNo.Text = s.VatRegNo.Trim(); lblTin.Text = s.TIN.Trim(); lblPOBox.Text = s.POBOX.Trim(); lblPostalCode.Text = s.PostalCode.Trim(); lblEmail.Text = s.VendorEmail.Trim(); lblStandardTerms.Text = s.TermsOfPayment.Trim(); lblSpecialTerms.Text = s.SpecialTerms.Trim(); lblMinimumOrderValue.Text = s.MinOrderValue.Trim(); lblSalesPerson.Text = s.ContactPerson.Trim(); lblTelephone2.Text = s.SalesPersonTelNo.Trim(); lblTypeOfBusinessOrganization.Text = s.OrgTypeId; lblFilipino.Text = s.OwnershipFilipino.Trim(); lblOtherNationality.Text = s.OwnershipOther.Trim(); lblCompanyClassification.Text = ""; lblSoleSupplier.Text = s.SoleSupplier1.Trim() + " " + s.SoleSupplier2.Trim(); lblSpecialization.Text = s.Specialization.Trim(); SupplierType sut = new SupplierType(); lblSupplierType.Text = sut.GetSupplierType(connstring, s.Accredited.Trim()); PCABClassTransaction pcab = new PCABClassTransaction(); lblPCABClass.Text = pcab.GetPCABClasName(connstring, s.PCABClass.Trim()); switch (s.ISOStandard.Trim()) { case "01": lblISOStandard.Text = "ISO 9002"; break; case "10": lblISOStandard.Text = "ISO 9001"; break; case "11": lblISOStandard.Text = "ISO 9001<br />ISO 9002"; break; } DataSet ds = st.QueryCategoryAndSubCategory(connstring, ViewState["VendorId"].ToString().Trim()); string strcategory = ""; string strsubcategory = ""; if (ds.Tables.Count > 0) { if (ds.Tables[0] != null) { DataTable dtCategory = ds.Tables[0]; if (dtCategory.Rows.Count > 0) { for (int i = 0; i < dtCategory.Rows.Count; i++) { strcategory = (strcategory == "" ? dtCategory.Rows[i]["CategoryName"].ToString() : strcategory + "<br />" + dtCategory.Rows[i]["CategoryName"].ToString()); } } } if (ds.Tables[1] != null) { DataTable dtSubCategory = ds.Tables[1]; if (dtSubCategory.Rows.Count > 0) { for (int i = 0; i < dtSubCategory.Rows.Count; i++) { strsubcategory = (strsubcategory == "" ? dtSubCategory.Rows[i]["CompleteName"].ToString() : strsubcategory + "<br />" + dtSubCategory.Rows[i]["CompleteName"].ToString()); } } } } lblCategory.Text = strcategory; lblSubCategory.Text = strsubcategory; gvKeyPersonnel.DataSource = CreateKeyPersonell(s.KeyPersonnel.Trim(), s.KeyPosition.Trim()); gvKeyPersonnel.DataBind(); gvPresentServices.DataSource = st.QueryPresentServices(connstring, ViewState["VendorId"].ToString().Trim()); gvPresentServices.DataBind(); DataTable dt = st.QueryMajorCustomers(connstring, ViewState["VendorId"].ToString().Trim()); if (dt.Rows.Count == 0) { dt = CreateEmptyMajorCustomers(); } gvMajorCustomers.DataSource = dt; gvMajorCustomers.DataBind(); dt = st.QueryBanks(connstring, ViewState["VendorId"].ToString().Trim()); if (dt.Rows.Count == 0) { dt = CreateEmptyBanks(); } gvBanks.DataSource = dt; gvBanks.DataBind(); dt = st.QueryAffiliatedCompanies(connstring, ViewState["VendorId"].ToString().Trim()); if (dt.Rows.Count == 0) { dt = CreateEmptyAffiliatedCompanies(); } gvAffiliatedCompanies.DataSource = dt; gvAffiliatedCompanies.DataBind(); dt = st.QueryExternalAuditors(connstring, ViewState["VendorId"].ToString().Trim()); if (dt.Rows.Count == 0) { dt = CreateEmptyExternalAuditor(); } gvExternalAuditors.DataSource = dt; gvExternalAuditors.DataBind(); dt = st.QueryEquipment(connstring, ViewState["VendorId"].ToString().Trim()); if (dt.Rows.Count == 0) { dt = CreateEmptyEquipment(); } gvEquipment.DataSource = dt; gvEquipment.DataBind(); dt = st.QueryRelatives(connstring, ViewState["VendorId"].ToString().Trim()); if (dt.Rows.Count == 0) { dt = CreateEmptyRelativesTable(); } gvRelatives.DataSource = dt; gvRelatives.DataBind(); DataTable dtBrands = st.QueryBrandsByVendorId(connstring, Session["VendorId"].ToString().Trim()); gvBrands.DataSource = dtBrands; gvBrands.DataBind(); DataTable dtItems = st.QueryItemsCarriedByVendorId(connstring, Session["VendorId"].ToString().Trim()); gvItems.DataSource = dtItems; gvItems.DataBind(); DataTable dtLocations = st.QueryLocationsByVendorId(connstring, Session["VendorId"].ToString().Trim()); gvLocations.DataSource = dtLocations; gvLocations.DataBind(); DataTable dtServices = st.QueryServicesByVendorId(connstring, Session["VendorId"].ToString().Trim()); gvServices.DataSource = dtServices; gvServices.DataBind(); } else { Response.Redirect("suppliers.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 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)) { if (Request.QueryString["AuctionRefNo"] != null) { Session["AuctionRefNo"] = Request.QueryString["AuctionRefNo"].ToString().Trim(); } if (Session["AuctionRefNo"] != null) { hdnAuctionRefNo.Value = Session["AuctionRefNo"].ToString().Trim(); } if (hdnAuctionRefNo.Value.Trim() != "") { AuctionTransaction au = new AuctionTransaction(); AuctionItem ai = au.GetAuctionByAuctionRefNo(connstring, hdnAuctionRefNo.Value.Trim()); CompanyTransaction cmp = new CompanyTransaction(); GroupDeptSecTransaction grp = new GroupDeptSecTransaction(); CategoryTransaction cat = new CategoryTransaction(); OtherTransaction oth = new OtherTransaction(); lblCompany.Text = cmp.GetCompanyName(connstring, ai.CompanyId.ToString().Trim()); lblRequestor.Text = ai.Requestor.ToString().Trim(); lblPRNumber.Text = ai.PRRefNo.ToString().Trim(); lblPRDate.Text = ai.PRDate.ToString().Trim(); lblGroup.Text = grp.GetGroupDeptSecNameById(connstring, ai.GroupDeptSec.ToString().Trim()); lblSubCategory.Text = cat.GetCategoryNameById(connstring, ai.Category.ToString().Trim()); lblDeadline.Text = ai.AuctionDeadline.ToString().Trim(); lblDeliveryDate.Text = ai.DeliveryDate.ToString().Trim(); lblItemDescription.Text = ai.ItemDescription.ToString().Trim(); lblReferenceNumber.Text = hdnAuctionRefNo.Value.Trim(); lblAuctionType.Text = au.GetAuctionTypeNameById(connstring, ai.AuctionType.ToString().Trim()); lblAuctionConfirmationDeadline.Text = ai.AuctionDeadline.ToString().Trim(); lblAuctionEventDate.Text = ai.AuctionStartDate.ToString().Trim(); lblAuctionStartTime.Text = ai.AuctionStartTimeHour.ToString().Trim() + ":" + ai.AuctionStartTimeMin.ToString().Trim() + ":" + ai.AuctionStartTimeSec.ToString().Trim() + " " + ai.AuctionStartTimeAMPM.ToString().Trim(); lblAuctionEndTime.Text = ai.AuctionEndTimeHour.ToString().Trim() + ":" + ai.AuctionEndTimeMin.ToString().Trim() + ":" + ai.AuctionEndTimeSec.ToString().Trim() + " " + ai.AuctionEndTimeAMPM.ToString().Trim(); lblBidCurrency.Text = oth.GetBidCurrency(ai.BidCurrency.ToString().Trim()); btnAwarded.Text = oth.GetAuctionStatus(ai.AuctionStatus); ShowSuppliers(); ShowFiles(ai.FileAttachments.ToString().Trim()); ShowAuctionItems(); } } }
protected void Page_Load(object sender, EventArgs e) { string connstring = HttpContext.Current.Session["ConnectionString"].ToString(); string sCommand; SqlDataReader oReader; sCommand = "SELECT t1.BacRefNo, t1.BidRefNo, t1.ItemDesc, t1.ApprovedDt_0, t1.ApprovedDt_1, t1.ApprovedDt_2, t1.ApprovedDt_3, t1.ApprovedDt_4, t1.ApprovedDt_5, t1.ApprovedDt_6, t1.ApprovedDt_7, t1.ApprovedDt_8, t1.ApprovedDt_9, t1.Approver_1, t1.Approver_2, t1.Approver_3, t1.Approver_4, t1.Approver_5, t1.Approver_6, t1.Approver_7, t1.Approver_8, t1.Approver_9, t1.Approver_10 from tblBacBidItems t1 where (t1.Approver_1=" + Session["UserId"] + " OR t1.Approver_2=" + Session["UserId"] + " OR t1.Approver_3=" + Session["UserId"] + " OR t1.Approver_4=" + Session["UserId"] + " OR t1.Approver_5=" + Session["UserId"] + " OR t1.Approver_6=" + Session["UserId"] + " OR t1.Approver_7=" + Session["UserId"] + " OR t1.Approver_8=" + Session["UserId"] + " OR t1.Approver_9=" + Session["UserId"] + " OR t1.Approver_10=" + Session["UserId"] + ") ORDER BY t1.BacRefNo DESC"; oReader = SqlHelper.ExecuteReader(connstring, CommandType.Text, sCommand); Hashtable ApproverList = new Hashtable(); while (oReader.Read()) { //string i = oReader["ItemDesc"].ToString(); if (oReader["ApprovedDt_0"].ToString() != "") { ApproverList.Add("1_" + oReader["BidRefNo"].ToString(), oReader["Approver_1"].ToString()); } if (oReader["ApprovedDt_1"].ToString() != "") { ApproverList.Add("2_" + oReader["BidRefNo"].ToString(), oReader["Approver_2"].ToString()); } if (oReader["ApprovedDt_2"].ToString() != "") { ApproverList.Add("3_" + oReader["BidRefNo"].ToString(), oReader["Approver_3"].ToString()); } if (oReader["ApprovedDt_3"].ToString() != "") { ApproverList.Add("4_" + oReader["BidRefNo"].ToString(), oReader["Approver_4"].ToString()); } if (oReader["ApprovedDt_4"].ToString() != "") { ApproverList.Add("5_" + oReader["BidRefNo"].ToString(), oReader["Approver_5"].ToString()); } if (oReader["ApprovedDt_5"].ToString() != "") { ApproverList.Add("6_" + oReader["BidRefNo"].ToString(), oReader["Approver_6"].ToString()); } if (oReader["ApprovedDt_6"].ToString() != "") { ApproverList.Add("7_" + oReader["BidRefNo"].ToString(), oReader["Approver_7"].ToString()); } if (oReader["ApprovedDt_7"].ToString() != "") { ApproverList.Add("8_" + oReader["BidRefNo"].ToString(), oReader["Approver_8"].ToString()); } if (oReader["ApprovedDt_8"].ToString() != "") { ApproverList.Add("9_" + oReader["BidRefNo"].ToString(), oReader["Approver_9"].ToString()); } if (oReader["ApprovedDt_9"].ToString() != "") { ApproverList.Add("10_" + oReader["BidRefNo"].ToString(), oReader["Approver_10"].ToString()); } } foreach (DictionaryEntry Item in ApproverList) { //Response.Write(Item.Key.ToString() + ": " + Item.Value.ToString() + "<br/>"); } //string str = null; //foreach (string key in HttpContext.Current.Session.Keys) //{ // str += string.Format("{0}: {1}<br />", key, HttpContext.Current.Session[key].ToString()); //} //Response.Write(str); //Response.Write(Session["UserId"]); FormsAuthenticationHelper.AuthenticateUserWithReturnUrl(); if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.BIDAWARDINGCOMMITTEE) { Response.Redirect("../unauthorizedaccess.aspx"); } Session[Constant.SESSION_LASTPAGE] = Request.AppRelativeCurrentExecutionFilePath; if (!(Page.IsPostBack)) { } if (Session[Constant.SESSION_USERID] == null) { Session.Abandon(); Session.Clear(); FormsAuthentication.SignOut(); string returnUrl = string.Empty; if (Request.RawUrl.Trim() != "") { returnUrl = "?ReturnUrl=" + Request.RawUrl.Trim().Replace("~/", ""); } Response.Redirect(FormsAuthentication.LoginUrl + returnUrl); } PageTitle.InnerText = String.Format(Constant.TITLEFORMAT, "BAC Approved by Purchasing"); }
protected void Page_Load(object sender, EventArgs e) { FormsAuthenticationHelper.AuthenticateUserWithReturnUrl(); }
protected void Page_Load(object sender, EventArgs e) { FormsAuthenticationHelper.AuthenticateUserWithReturnUrl(); connstring = HttpContext.Current.Session["ConnectionString"].ToString(); if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.ADMINISTRATOR) { Response.Redirect("../unauthorizedaccess.aspx"); } if (!(Page.IsPostBack)) { if (Session["SKU"] != null) { ViewState["SKU"] = Session["SKU"].ToString().Trim(); } BrandsTransaction brand = new BrandsTransaction(); ServicesTransaction serv = new ServicesTransaction(); SubCategory sub = new SubCategory(); CategoryTransaction c = new CategoryTransaction(); ServicesTransaction s = new ServicesTransaction(); UnitOfMeasurementTransaction u = new UnitOfMeasurementTransaction(); ddlUnitOfMeasure.DataSource = u.GetAllUnitsOfMeasurement(connstring); ddlUnitOfMeasure.DataTextField = "UnitOfMeasureName"; ddlUnitOfMeasure.DataValueField = "UnitOfMeasureID"; ddlUnitOfMeasure.DataBind(); ddlUnitOfMeasure.Items.Insert(0, ""); ddlCategory.DataSource = c.GetAllCategories(connstring); ddlCategory.DataTextField = "CategoryName"; ddlCategory.DataValueField = "CategoryId"; ddlCategory.DataBind(); ddlCategory.Items.Insert(0, ""); ddlSubCategory.DataSource = sub.GetAllSubCategories(connstring); ddlSubCategory.DataTextField = "SubCategoryName"; ddlSubCategory.DataValueField = "SubCategoryId"; ddlSubCategory.DataBind(); ddlSubCategory.Items.Insert(0, ""); ddlBrand.DataSource = brand.GetAllBrands(connstring); ddlBrand.DataTextField = "BrandName"; ddlBrand.DataValueField = "BrandId"; ddlBrand.DataBind(); ddlBrand.Items.Insert(0, ""); ddlServiceType.DataSource = s.GetAllServices(connstring); ddlServiceType.DataTextField = "ServiceName"; ddlServiceType.DataValueField = "ServiceId"; ddlServiceType.DataBind(); ddlServiceType.Items.Insert(0, ""); if (ViewState["SKU"] != null) { ProductsTransaction p = new ProductsTransaction(); Product po = new Product(); po = p.QueryProductBySKU(ViewState["SKU"].ToString().Trim(), connstring); txtSKU.Enabled = false; txtSKU.Text = po.SKU.Trim(); txtItemName.Text = po.ItemName.Trim(); txtProductDescription.Text = po.ProductDescription.Trim(); ddlUnitOfMeasure.SelectedIndex = ddlUnitOfMeasure.Items.IndexOf(ddlUnitOfMeasure.Items.FindByValue(po.UnitOfMeasure.Trim())); ddlCategory.SelectedIndex = ddlCategory.Items.IndexOf(ddlCategory.Items.FindByValue(po.Category.Trim())); ddlSubCategory.SelectedIndex = ddlSubCategory.Items.IndexOf(ddlSubCategory.Items.FindByValue(po.SubCategory.Trim())); ddlBrand.SelectedIndex = ddlBrand.Items.IndexOf(ddlBrand.Items.FindByValue(po.Brand.Trim())); ddlServiceType.SelectedIndex = ddlServiceType.Items.IndexOf(ddlServiceType.Items.FindByValue(po.ServiceType.Trim())); btnDelete.Visible = true; } } }
protected void Page_Load(object sender, EventArgs e) { FormsAuthenticationHelper.AuthenticateUserWithReturnUrl(); 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_BIDREFNO] = Session[Constant.SESSION_BIDREFNO].ToString().Trim(); // lblBidRefNo.Text = ViewState[Constant.SESSION_BIDREFNO].ToString().Trim(); // BidItemTransaction biditem = new BidItemTransaction(); // DataTable dt = new DataTable(); // DataColumn dcol = new DataColumn("Item", typeof(System.String)); // dt.Columns.Add(dcol); // SupplierTransaction sup = new SupplierTransaction(); // DataTable dtvendors = new DataTable(); // //dtvendors = sup.GetVendorsWithSubmittedTenders(connstring, Session["BidRefNo"].ToString().Trim()); // dtvendors = sup.GetVendorsWithEndorsedTenders(connstring, ViewState[Constant.SESSION_BIDREFNO].ToString().Trim()); // for (int j = 0; j < dtvendors.Rows.Count; j++) // { // string strSupplierName = sup.GetVendorNameById(dtvendors.Rows[j]["vendorid"].ToString().Trim()); // dcol = new DataColumn(strSupplierName, typeof(System.String)); // dt.Columns.Add(dcol); // dcol = new DataColumn("BidTenderNo" + j.ToString().Trim(), typeof(System.String)); // dt.Columns.Add(dcol); // } // //---create rows // BidTenderTransaction bidtender = new BidTenderTransaction(); // BidItemDetailTransaction biditemdetail = new BidItemDetailTransaction(); // DataTable dtitems = biditemdetail.QueryBidItemDetail_Items_ByBidRefNo(connstring, ViewState[Constant.SESSION_BIDREFNO].ToString().Trim()); // //DataRow ItemRow = dt.NewRow(); // //write biditems and amount // for (int i = 0; i < dtitems.Rows.Count; i++) // { // DataRow ItemRow = dt.NewRow(); // ItemRow["Item"] = dtitems.Rows[i]["Item"].ToString().Trim(); // for (int j = 0; j < dtvendors.Rows.Count; j++) // { // BidTender bt = new BidTender(); // bt = bidtender.QueryBidTenderAmount(dtitems.Rows[i]["BidDetailNo"].ToString().Trim(), dtvendors.Rows[j]["vendorid"].ToString().Trim()); // double dblAmount = bt.Amount; // string strAmount = dblAmount.ToString("N2"); // string strSupplierName = sup.GetVendorNameById(dtvendors.Rows[j]["vendorid"].ToString().Trim()); // //CheckBox chk = new CheckBox(); // //chk.Text = j.ToString().Trim() + "|Item" + "|true" + "|" + bt.BidTenderNo; // //ItemRow["Checkbox|" + j.ToString().Trim()] = chk; // if (j == dtvendors.Rows.Count - 1) // { // ItemRow[strSupplierName] = "Last|" + strAmount; // } // else // { // ItemRow[strSupplierName] = "Item|" + strAmount; // } // ItemRow["BidTenderNo" + j.ToString().Trim()] = bt.BidTenderNo; // } // dt.Rows.Add(ItemRow); // } // //write discount // DataRow DiscountRow = dt.NewRow(); // DiscountRow["Item"] = "Discount"; // for (int j = 0; j < dtvendors.Rows.Count; j++) // { // double dblDiscount = bidtender.GetDiscount(ViewState[Constant.SESSION_BIDREFNO].ToString().Trim(), dtvendors.Rows[j]["vendorid"].ToString().Trim()); // string strDiscount = dblDiscount.ToString("N2"); // string strSupplierName = sup.GetVendorNameById(dtvendors.Rows[j]["vendorid"].ToString().Trim()); // //CheckBox chk = new CheckBox(); // //chk.Text = j.ToString().Trim() + "|Discount" + "|false|"; // //DiscountRow["Checkbox|" + j.ToString().Trim()] = chk; // DiscountRow[strSupplierName] = "Discount|" + strDiscount; // DiscountRow["BidTenderNo" + j.ToString().Trim()] = ""; // } // dt.Rows.Add(DiscountRow); // //write total cost // DataRow TotalCostRow = dt.NewRow(); // TotalCostRow["Item"] = "Total Cost"; // for (int j = 0; j < dtvendors.Rows.Count; j++) // { // double dblTotalCost = bidtender.GetTotalCost(ViewState[Constant.SESSION_BIDREFNO].ToString().Trim(), dtvendors.Rows[j]["vendorid"].ToString().Trim()); // string strTotalCost = dblTotalCost.ToString("N2"); // string strSupplierName = sup.GetVendorNameById(dtvendors.Rows[j]["vendorid"].ToString().Trim()); // //CheckBox chk = new CheckBox(); // //chk.Text = j.ToString().Trim() + "|TotalCost" + "|false|"; // //TotalCostRow["Checkbox|" + j.ToString().Trim()] = chk; // TotalCostRow[strSupplierName] = "TotalCost|" + strTotalCost; // TotalCostRow["BidTenderNo" + j.ToString().Trim()] = ""; // } // dt.Rows.Add(TotalCostRow); // //write delivery cost // DataRow DeliveryCostRow = dt.NewRow(); // DeliveryCostRow["Item"] = "Delivery Cost"; // for (int j = 0; j < dtvendors.Rows.Count; j++) // { // double dblDeliveryCost = bidtender.GetDeliveryCost(ViewState[Constant.SESSION_BIDREFNO].ToString().Trim(), dtvendors.Rows[j]["vendorid"].ToString().Trim()); // string strDeliveryCost = dblDeliveryCost.ToString("N2"); // string strSupplierName = sup.GetVendorNameById(dtvendors.Rows[j]["vendorid"].ToString().Trim()); // //CheckBox chk = new CheckBox(); // //chk.Text = j.ToString().Trim() + "|DeliveryCost" + "|false|"; // //DeliveryCostRow["Checkbox|" + j.ToString().Trim()] = chk; // DeliveryCostRow[strSupplierName] = "DeliveryCost|" + strDeliveryCost; // DeliveryCostRow["BidTenderNo" + j.ToString().Trim()] = ""; // } // dt.Rows.Add(DeliveryCostRow); // //write total extended cost // DataRow TotalExtendedCostRow = dt.NewRow(); // TotalExtendedCostRow["Item"] = "Total Extended Cost"; // for (int j = 0; j < dtvendors.Rows.Count; j++) // { // double dblTotalExtendedCost = bidtender.GetTotalExtendedCost(ViewState[Constant.SESSION_BIDREFNO].ToString().Trim(), dtvendors.Rows[j]["vendorid"].ToString().Trim()); // string strTotalExtendedCost = dblTotalExtendedCost.ToString("N2"); // string strSupplierName = sup.GetVendorNameById(dtvendors.Rows[j]["vendorid"].ToString().Trim()); // //CheckBox chk = new CheckBox(); // //chk.Text = j.ToString().Trim() + "|TotalExtendedCost" + "|false|"; // //TotalExtendedCostRow["Checkbox|" + j.ToString().Trim()] = chk; // TotalExtendedCostRow[strSupplierName] = "TotalExtendedCost|" + strTotalExtendedCost; // TotalExtendedCostRow["BidTenderNo" + j.ToString().Trim()] = ""; // } // dt.Rows.Add(TotalExtendedCostRow); // //write incoterm // DataRow IncotermRow = dt.NewRow(); // IncotermRow["Item"] = "Incoterm"; // for (int j = 0; j < dtvendors.Rows.Count; j++) // { // IncotermTransaction inc = new IncotermTransaction(); // string strIncoTerm = inc.GetIncotermName(bidtender.GetIncoterm(connstring, ViewState[Constant.SESSION_BIDREFNO].ToString().Trim(), dtvendors.Rows[j]["vendorid"].ToString().Trim())); // string strSupplierName = sup.GetVendorNameById(dtvendors.Rows[j]["vendorid"].ToString().Trim()); // //CheckBox chk = new CheckBox(); // //chk.Text = j.ToString().Trim() + "|Incoterm" + "|false|"; // //IncotermRow["Checkbox|" + j.ToString().Trim()] = chk; // IncotermRow[strSupplierName] = "Incoterm|" + strIncoTerm; // IncotermRow["BidTenderNo" + j.ToString().Trim()] = ""; // } // dt.Rows.Add(IncotermRow); // //write payment terms // DataRow PaymentTermsRow = dt.NewRow(); // PaymentTermsRow["Item"] = "Payment Terms"; // for (int j = 0; j < dtvendors.Rows.Count; j++) // { // string strPaymentTerms = bidtender.GetPaymentTerms(ViewState[Constant.SESSION_BIDREFNO].ToString().Trim(), dtvendors.Rows[j]["vendorid"].ToString().Trim()); // string strSupplierName = sup.GetVendorNameById(dtvendors.Rows[j]["vendorid"].ToString().Trim()); // //CheckBox chk = new CheckBox(); // //chk.Text = j.ToString().Trim() + "|PaymentTerms" + "|false|"; // //PaymentTermsRow["Checkbox|" + j.ToString().Trim()] = chk; // PaymentTermsRow[strSupplierName] = "PaymentTerms|" + strPaymentTerms; // PaymentTermsRow["BidTenderNo" + j.ToString().Trim()] = ""; // } // dt.Rows.Add(PaymentTermsRow); // //write warranty // DataRow WarrantyRow = dt.NewRow(); // WarrantyRow["Item"] = "Warranty"; // for (int j = 0; j < dtvendors.Rows.Count; j++) // { // string strWarranty = bidtender.GetWarranty(ViewState[Constant.SESSION_BIDREFNO].ToString().Trim(), dtvendors.Rows[j]["vendorid"].ToString().Trim()); // string strSupplierName = sup.GetVendorNameById(dtvendors.Rows[j]["vendorid"].ToString().Trim()); // //CheckBox chk = new CheckBox(); // //chk.Text = j.ToString().Trim() + "|Warranty" + "|false|"; // //WarrantyRow["Checkbox|" + j.ToString().Trim()] = chk; // WarrantyRow[strSupplierName] = "Warranty|" + strWarranty; // WarrantyRow["BidTenderNo" + j.ToString().Trim()] = ""; // } // dt.Rows.Add(WarrantyRow); // //write remarks // DataRow RemarksRow = dt.NewRow(); // RemarksRow["Item"] = "Remarks"; // for (int j = 0; j < dtvendors.Rows.Count; j++) // { // string strRemarks = bidtender.GetRemarks(ViewState[Constant.SESSION_BIDREFNO].ToString().Trim(), dtvendors.Rows[j]["vendorid"].ToString().Trim()); // string strSupplierName = sup.GetVendorNameById(dtvendors.Rows[j]["vendorid"].ToString().Trim()); // //CheckBox chk = new CheckBox(); // //chk.Text = j.ToString().Trim() + "|Remarks" + "|false|"; // //RemarksRow["Checkbox|" + j.ToString().Trim()] = chk; // RemarksRow[strSupplierName] = "Remarks|" + strRemarks; // RemarksRow["BidTenderNo" + j.ToString().Trim()] = ""; // } // dt.Rows.Add(RemarksRow); // foreach (DataColumn col in dt.Columns) // { // CustomBoundField bfield1 = new CustomBoundField(); // string colname = col.ColumnName.ToUpper().Trim(); // if (colname.IndexOf("BIDTENDERNO") > -1) // { // //Initalize the DataField value. // bfield1.DataField = col.ColumnName; // bfield1.ItemStyle.CssClass = "value"; // //Initialize the HeaderText field value. // bfield1.HeaderText = col.ColumnName; // bfield1.HeaderType = Constant.HEADER_TYPE_LABEL.ToString().Trim(); // bfield1.HeaderStyle.CssClass = "itemDetails_th"; // bfield1.Editable = false; // //bfield1.ShowCheckBox = false; // bfield1.Date = false; // bfield1.Label3 = false; // bfield1.Visible = false; // GridView1.Columns.Add(bfield1); // } // else if (colname.IndexOf("ITEM") > -1) // { // bfield1.DataField = col.ColumnName; // bfield1.ItemStyle.CssClass = "itemDetails_td"; // bfield1.Label3 = false; // bfield1.HeaderText = col.ColumnName; // bfield1.HeaderType = Constant.HEADER_TYPE_LABEL.ToString().Trim(); // bfield1.HeaderStyle.CssClass = "itemDetails_th"; // bfield1.Editable = false; // //bfield1.ShowCheckBox = false; // bfield1.Date = false; // GridView1.Columns.Add(bfield1); // } // else // { // bfield1.DataField = col.ColumnName; // bfield1.ItemStyle.CssClass = "value"; // bfield1.Label3 = true; // bfield1.HeaderText = col.ColumnName; // bfield1.HeaderType = Constant.HEADER_TYPE_LABEL.ToString().Trim(); // bfield1.HeaderStyle.CssClass = "itemDetails_th"; // bfield1.Editable = false; // //bfield1.ShowCheckBox = false; // bfield1.Date = false; // GridView1.Columns.Add(bfield1); // } // } // GridView1.DataSource = dt; // GridView1.DataBind(); // } // } //} }
protected void Page_Load(object sender, EventArgs e) { if (HttpContext.Current.Session["clientid"] != null) { connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString()); } else { Response.Redirect("../../login.aspx"); } FormsAuthenticationHelper.AuthenticateUserWithReturnUrl(); if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.BUYER) { Response.Redirect("../unauthorizedaccess.aspx"); } if (Request.QueryString["brn"] != null) { Session["BidRefNo"] = Request.QueryString["brn"].ToString().Trim(); } if (Session[Constant.SESSION_BIDREFNO] == null) { Response.Redirect("approvedbidevents.aspx"); } if (!IsPostBack) { PageTitle.InnerText = String.Format(Constant.TITLEFORMAT, "Approved Bid Details"); InitializeControls(); if (Session["MESSAGE"] != null) { lblMessage.Text = Session["MESSAGE"].ToString(); Session["MESSAGE"] = null; } } if (QueryCountEndorsedBidTenders() != "0") { lnkShowHideChangeDeadline.Enabled = false; } SqlDataReader oReader; string query; SqlCommand cmd; SqlConnection conn; query = "SELECT * FROM tblBidItems WHERE BidRefno= " + Session["BidRefno"].ToString(); //##storedProcedure using (conn = new SqlConnection(connstring)) { using (cmd = new SqlCommand(query, conn)) { //cmd.Parameters.AddWithValue("@BidRefNo", Convert.ToInt32(Session["BidRefno"].ToString())); conn.Open(); oReader = cmd.ExecuteReader(); if (oReader.HasRows) { while (oReader.Read()) { if (oReader["Status"].ToString() == "4") { lnkShowHideChangeDeadline.Visible = true; } else { lnkShowHideChangeDeadline.Visible = false; } } } } } }
protected void Page_Load(object sender, EventArgs e) { FormsAuthenticationHelper.AuthenticateUserWithReturnUrl(); connstring = HttpContext.Current.Session["ConnectionString"].ToString(); }
protected void Page_Load(object sender, EventArgs e) { FormsAuthenticationHelper.AuthenticateUserWithReturnUrl(); if ((Session[Constant.SESSION_USERTYPE] != null) && (Session[Constant.SESSION_USERTYPE].ToString() != "")) { btnSearch.Attributes.Add("OnClick", "ShowResults(" + Session[Constant.SESSION_USERTYPE].ToString().Trim() + ")"); //Response.Write(Session[Constant.SESSION_USERTYPE].ToString().Trim()); if (Session[Constant.SESSION_USERTYPE].ToString().Trim() == "1") //BUYER { //ddlSearchOpt.Items[0].Enabled = false; //ddlSearchOpt.Items[1].Enabled = false; //ddlSearchOpt.Items[2].Enabled = false; //ddlSearchOpt.Items[3].Enabled = false; //ddlSearchOpt.Items[4].Enabled = false; //ddlSearchOpt.Items[5].Enabled = false; //ddlSearchOpt.Items[6].Enabled = false; //ddlSearchOpt.Items[7].Enabled = false; } if (Session[Constant.SESSION_USERTYPE].ToString().Trim() == "2") //VENDOR { //ddlSearchOpt.Items[0].Enabled = false; //ddlSearchOpt.Items[1].Enabled = false; //ddlSearchOpt.Items[2].Enabled = false; //ddlSearchOpt.Items[3].Enabled = false; //ddlSearchOpt.Items[4].Enabled = false; //ddlSearchOpt.Items[5].Enabled = false; //ddlSearchOpt.Items[6].Enabled = false; ddlSearchOpt.Items[7].Enabled = false; } if (Session[Constant.SESSION_USERTYPE].ToString().Trim() == "3") //PURCHASING { //ddlSearchOpt.Items[0].Enabled = false; //ddlSearchOpt.Items[1].Enabled = false; //ddlSearchOpt.Items[2].Enabled = false; //ddlSearchOpt.Items[3].Enabled = false; //ddlSearchOpt.Items[4].Enabled = false; //ddlSearchOpt.Items[5].Enabled = false; //ddlSearchOpt.Items[6].Enabled = false; //ddlSearchOpt.Items[7].Enabled = false; } if (Session[Constant.SESSION_USERTYPE].ToString().Trim() == "5") //BOC { //ddlSearchOpt.Items[0].Enabled = false; //ddlSearchOpt.Items[1].Enabled = false; //ddlSearchOpt.Items[2].Enabled = false; ddlSearchOpt.Items[3].Enabled = false; ddlSearchOpt.Items[4].Enabled = false; ddlSearchOpt.Items[5].Enabled = false; //ddlSearchOpt.Items[6].Enabled = false; ddlSearchOpt.Items[7].Enabled = false; } if (Session[Constant.SESSION_USERTYPE].ToString().Trim() == "6") //BAC { //ddlSearchOpt.Items[0].Enabled = false; //ddlSearchOpt.Items[1].Enabled = false; //ddlSearchOpt.Items[2].Enabled = false; ddlSearchOpt.Items[3].Enabled = false; ddlSearchOpt.Items[4].Enabled = false; ddlSearchOpt.Items[5].Enabled = false; //ddlSearchOpt.Items[6].Enabled = false; ddlSearchOpt.Items[7].Enabled = false; } } else { HttpCookie cookie = Request.Cookies["tempCookie"]; Session[Constant.SESSION_USERTYPE] = cookie.Values[Constant.SESSION_USERTYPE]; btnSearch.Attributes.Add("OnClick", "ShowResults(" + Session[Constant.SESSION_USERTYPE].ToString().Trim() + ")"); } }