private void DisplayReferences()
{
CompanyTransaction companyDetails = new CompanyTransaction();
DataTable vendorRef;
string refTypeName, refTypeExtra;
vendorRef = companyDetails.QueryVendorReferences(connstring, ViewState[Constant.SESSION_USERID].ToString().Trim(), Constant.REF_MAIN_CUSTOMERS);
refTypeName = companyDetails.GetReferenceTypeName(connstring, Constant.REF_MAIN_CUSTOMERS.ToString());
refTypeExtra = companyDetails.GetReferenceTypeExtra(connstring, Constant.REF_MAIN_CUSTOMERS.ToString());
FillReferenceTable(vendorRef, "AveMonthlySales", refTypeName, refTypeExtra);
vendorRef = companyDetails.QueryVendorReferences(connstring, ViewState[Constant.SESSION_USERID].ToString().Trim(), Constant.REF_BANKS);
refTypeName = companyDetails.GetReferenceTypeName(connstring, Constant.REF_BANKS.ToString());
refTypeExtra = companyDetails.GetReferenceTypeExtra(connstring, Constant.REF_BANKS.ToString());
FillReferenceTable(vendorRef, "CreditLine", refTypeName, refTypeExtra);
vendorRef = companyDetails.QueryVendorReferences(connstring, ViewState[Constant.SESSION_USERID].ToString().Trim(), Constant.REF_AFFILIATE);
refTypeName = companyDetails.GetReferenceTypeName(connstring, Constant.REF_AFFILIATE.ToString());
refTypeExtra = companyDetails.GetReferenceTypeExtra(connstring, Constant.REF_AFFILIATE.ToString());
FillReferenceTable(vendorRef, "KindOfBusiness", refTypeName, refTypeExtra);
vendorRef = companyDetails.QueryVendorReferences(connstring, ViewState[Constant.SESSION_USERID].ToString().Trim(), Constant.REF_EXTERN_AUDITOR);
refTypeName = companyDetails.GetReferenceTypeName(connstring, Constant.REF_EXTERN_AUDITOR.ToString());
refTypeExtra = companyDetails.GetReferenceTypeExtra(connstring, Constant.REF_EXTERN_AUDITOR.ToString());
FillReferenceTable(vendorRef, "LegalCounsel", refTypeName, refTypeExtra);
}
private void DisplayRelatives()
{
CompanyTransaction companyDetails = new CompanyTransaction();
DataTable equipments = companyDetails.QueryVendorRelatives(connstring, ViewState[Constant.SESSION_USERID].ToString().Trim());
HtmlTableRow htmlRow = new HtmlTableRow();
HtmlTableCell[] cell = new HtmlTableCell[3];
if (equipments.Rows.Count > 0)
{
itemDetailsV.Visible = true;
int i = 1;
foreach (DataRow row in equipments.Rows)
{
htmlRow = new HtmlTableRow();
cell[0] = new HtmlTableCell();
cell[0].Attributes.Add("class", ((i % 2 == 0) ? "evenCells" : "value"));
cell[0].Controls.Add(new LiteralControl(row["VendorRelative"].ToString()));
htmlRow.Cells.Add(cell[0]);
cell[1] = new HtmlTableCell();
cell[1].Attributes.Add("class", ((i % 2 == 0) ? "evenCells" : "value"));
cell[1].Controls.Add(new LiteralControl(row["Title"].ToString()));
htmlRow.Cells.Add(cell[1]);
cell[2] = new HtmlTableCell();
cell[2].Attributes.Add("class", ((i % 2 == 0) ? "evenCells" : "value"));
cell[2].Controls.Add(new LiteralControl(row["Relationship"].ToString()));
htmlRow.Cells.Add(cell[2]);
itemDetailsV.Rows.Add(htmlRow);
i++;
}
}
}
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();
}
}
private void DisplayPresentServices()
{
CompanyTransaction companyDetails = new CompanyTransaction();
DataTable presentsvc = companyDetails.QueryPresentServices(connstring, ViewState[Constant.SESSION_USERID].ToString().Trim());
HtmlTableRow htmlRow = new HtmlTableRow();
HtmlTableCell[] cell = new HtmlTableCell[3];
if (presentsvc.Rows.Count > 0)
{
int i = 1;
foreach (DataRow row in presentsvc.Rows)
{
htmlRow = new HtmlTableRow();
cell[0] = new HtmlTableCell();
cell[0].Attributes.Add("class", ((i % 2 == 0) ? "evenCells" : "value"));
cell[0].Controls.Add(new LiteralControl(row["PlanName"].ToString()));
htmlRow.Cells.Add(cell[0]);
cell[1] = new HtmlTableCell();
cell[1].Attributes.Add("class", ((i % 2 == 0) ? "evenCells" : "value"));
cell[1].Controls.Add(new LiteralControl(row["AccountNo"].ToString()));
htmlRow.Cells.Add(cell[1]);
cell[2] = new HtmlTableCell();
cell[2].Attributes.Add("class", ((i % 2 == 0) ? "evenCells" : "value"));
cell[2].Controls.Add(new LiteralControl(row["CreditLimit"].ToString()));
htmlRow.Cells.Add(cell[2]);
itemDetails2.Rows.Add(htmlRow);
i++;
}
}
}
private void DisplayEquipments()
{
CompanyTransaction companyDetails = new CompanyTransaction();
DataTable equipments = companyDetails.QueryVendorEquipments(connstring, ViewState["VendorID"].ToString().Trim());
HtmlTableRow htmlRow = new HtmlTableRow();
HtmlTableCell[] cell = new HtmlTableCell[3];
if (equipments.Rows.Count > 0)
{
int i = 1;
foreach (DataRow row in equipments.Rows)
{
htmlRow = new HtmlTableRow();
cell[0] = new HtmlTableCell();
cell[0].Attributes.Add("class", ((i % 2 == 0) ? "evenCells" : "value"));
cell[0].Controls.Add(new LiteralControl(row["EquipmentType"].ToString()));
htmlRow.Cells.Add(cell[0]);
cell[1] = new HtmlTableCell();
cell[1].Attributes.Add("class", ((i % 2 == 0) ? "evenCells" : "value"));
cell[1].Controls.Add(new LiteralControl(row["Units"].ToString()));
htmlRow.Cells.Add(cell[1]);
cell[2] = new HtmlTableCell();
cell[2].Attributes.Add("class", ((i % 2 == 0) ? "evenCells" : "value"));
cell[2].Controls.Add(new LiteralControl(row["Remarks"].ToString()));
htmlRow.Cells.Add(cell[2]);
itemDetails4.Rows.Add(htmlRow);
i++;
}
}
}
private void DisplayDetails()
{
AuctionItem auctionItem = AuctionItemTransaction.QueryAuctionItemInfo(ViewState[Constant.SESSION_AUCTIONREFNO].ToString().Trim());
CategoryTransaction category = new CategoryTransaction();
GroupDeptSecTransaction grp = new GroupDeptSecTransaction();
CompanyTransaction cmp = new CompanyTransaction();
OtherTransaction dte = new OtherTransaction();
lblCompany.Text = cmp.GetCompanyName(connstring, auctionItem.CompanyId.ToString().Trim());
lblRequestor.Text = auctionItem.Requestor.ToString().Trim();
lblPRNumber.Text = auctionItem.PRRefNo.ToString().Trim();
lblPRDate.Text = auctionItem.PRDate.ToString().Trim();
lblGroup.Text = grp.GetGroupDeptSecNameById(connstring, auctionItem.GroupDeptSec.ToString().Trim());
lblAuctionReferenceNumber.Text = auctionItem.AuctionRefNo.ToString().Trim();
lblSubCategory.Text = category.GetCategoryNameById(connstring, auctionItem.Category.ToString().Trim());
// lblDeadline.Text = auctionItem.Deadline.ToString().Trim();
lblDeliveryDate.Text = auctionItem.DeliveryDate.ToString().Trim();
lblItemDesc.Text = auctionItem.ItemDescription.ToString().Trim();
lblAuctionType.Text = AuctionItemTransaction.GetAuctionTypeById(auctionItem.AuctionType.ToString().Trim());
lblAuctionDeadline.Text = auctionItem.AuctionDeadline.ToString().Trim();
lblAuctionDate.Text = auctionItem.AuctionStartDate.ToString().Trim();
lblAuctionStartTime.Text = auctionItem.AuctionStartTime.ToString().Trim();
lblAuctionEndTime.Text = auctionItem.AuctionEndTime.ToString().Trim();
lblBidCurrency.Text = AuctionItemTransaction.getBidCurrency(auctionItem.BidCurrency.ToString().Trim());
}
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))
{
Session[Constant.SESSION_COMMENT_TYPE] = "1";
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());
ShowSuppliers();
ShowFiles(ai.FileAttachments.ToString().Trim());
ShowAuctionItems();
}
}
}
private void DisplayCompanyInfo()
{
CompanyTransaction companyDetails = new CompanyTransaction();
CompanyDetails companyInfo = companyDetails.QueryCompanyDetails(ViewState["VendorID"].ToString().Trim());
lblCompanyName.Text = companyInfo.CompanyName;
lblHeadOfficeAddress.Text = companyInfo.Address + " " + companyInfo.Address1;
lblTelephone.Text = companyInfo.HeadTelephone;
lblFax.Text = companyInfo.HeadFax;
lblExtension.Text = companyInfo.HeadExtension;
lblBranchAddress.Text = companyInfo.Address2 + " " + companyInfo.Address3;
lblBranchPhone.Text = companyInfo.BranchTelephone;
lblBranchFax.Text = companyInfo.BranchFax;
lblBranchExtension.Text = companyInfo.BranchExtension;
lblVatRegNo.Text = companyInfo.VatRegNo;
lblTin.Text = companyInfo.TIN;
lblPOBox.Text = companyInfo.POBox;
lblPostalCode.Text = companyInfo.PostalCode;
lblEmail.Text = companyInfo.CompanyEmail;
lblTermsofPayment.Text = companyInfo.TermsofPayment;
lblSpecialTerms.Text = companyInfo.SpecialTerms + " %PPD";
lblMinOrderValue.Text = companyInfo.MinOrderValue;
lblSalesPerson.Text = companyInfo.SalesPerson;
lblSalesPersonPhone.Text = companyInfo.SalesPersonPhone;
lblOrgType.Text = companyDetails.GetOrganizationType(companyInfo.OrganizationType.ToString().Trim());
lblOwnershipFilipino.Text = companyInfo.OwnershipFilipino + "%";
lblOwnershipOther.Text = companyInfo.OwnershipOther + "%";
lblClassification.Text = companyDetails.GetClassificationName(companyInfo.Classification.ToString().Trim());
lblSoleSupplier.Text = companyInfo.SoleSupplier + ((companyInfo.SoleSupplier1 != null) ? ", " + companyInfo.SoleSupplier1 : "");
lblSpecialization.Text = companyInfo.Specialization;
lblKeyPersonnel.Text = companyInfo.KeyPersonnel;
lblKpPosition.Text = companyInfo.KpPosition;
}
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 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);
}
public ActionResult Edit(Company company, HttpPostedFileBase logo)
{
ViewBag.Message = "Successfully Updated";
// need to handle the file size
if (logo != null && logo.ContentLength > 0 && logo.ContentType.Contains("image"))
{
using (Stream inputStream = logo.InputStream)
{
MemoryStream memoryStream = inputStream as MemoryStream;
if (memoryStream == null)
{
memoryStream = new MemoryStream();
inputStream.CopyTo(memoryStream);
}
company.LogoUrl = logo.FileName;
company.LogoBinary = memoryStream.ToArray();
}
}
CompanyTransaction transaction = _companyService.Update(company);
if (transaction == CompanyTransaction.Success)
{
return(Redirect(Url.Action("Details", "Company", new { id = company.Id })));
}
switch (transaction)
{
case CompanyTransaction.DuplicateName:
ModelState.AddModelError(nameof(company.Name), "is duplicate");
break;
case CompanyTransaction.Error:
break;
case CompanyTransaction.WrongImageType:
ModelState.AddModelError(nameof(company.LogoBinary), "Wrong image");
break;
}
return(View("_Edit", company));
}
private void DisplayCompanyInfo()
{
CompanyTransaction companyDetails = new CompanyTransaction();
CompanyDetails companyInfo = companyDetails.QueryCompanyDetails(connstring, ViewState["VendorID"].ToString().Trim());
lblCompanyName.Text = companyInfo.CompanyName;
if (companyInfo.IsBlackListed == 1)
{
lblIsBlacklisted.Visible = true;
btBlackList.Text = "Remove Blacklist";
hdBlacklisted.Value = "1";
}
else
{
lblIsBlacklisted.Visible = false;
btBlackList.Text = "Blacklist Supplier";
hdBlacklisted.Value = "0";
}
lblHeadOfficeAddress.Text = companyInfo.Address + " " + companyInfo.Address1;
lblTelephone.Text = companyInfo.HeadTelephone;
lblFax.Text = companyInfo.HeadFax;
lblExtension.Text = companyInfo.HeadExtension;
lblBranchAddress.Text = companyInfo.Address2 + " " + companyInfo.Address3;
lblBranchPhone.Text = companyInfo.BranchTelephone;
lblBranchFax.Text = companyInfo.BranchFax;
lblBranchExtension.Text = companyInfo.BranchExtension;
lblVatRegNo.Text = companyInfo.VatRegNo;
lblTin.Text = companyInfo.TIN;
lblPOBox.Text = companyInfo.POBox;
lblPostalCode.Text = companyInfo.PostalCode;
lblEmail.Text = companyInfo.CompanyEmail;
lblTermsofPayment.Text = companyInfo.TermsofPayment;
lblSpecialTerms.Text = companyInfo.SpecialTerms + " %PPD";
lblMinOrderValue.Text = companyInfo.MinOrderValue;
lblSalesPerson.Text = companyInfo.SalesPerson;
lblSalesPersonPhone.Text = companyInfo.SalesPersonPhone;
lblOrgType.Text = companyDetails.GetOrganizationType(connstring, companyInfo.OrganizationType.ToString().Trim());
lblOwnershipFilipino.Text = companyInfo.OwnershipFilipino + "%";
lblOwnershipOther.Text = companyInfo.OwnershipOther + "%";
lblClassification.Text = companyDetails.GetClassificationName(connstring, companyInfo.Classification.ToString().Trim());
lblSoleSupplier.Text = companyInfo.SoleSupplier + ((companyInfo.SoleSupplier1 != null) ? ", " + companyInfo.SoleSupplier1 : "");
lblSpecialization.Text = companyInfo.Specialization;
lblKeyPersonnel.Text = companyInfo.KeyPersonnel;
lblKpPosition.Text = companyInfo.KpPosition;
switch (companyInfo.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;
}
}
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 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 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();
}
}
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.";
}
}
}
}
}