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() + ")");
}
}
