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();
}
}
public ActionResult moreInfo(int bidItemId)
{
int maxBid;
int bidCount = (from b in db.Bids where b.bidItemID == bidItemId select b.bidAmount).Count();
if (bidCount > 0)
{
maxBid = (from b in db.Bids where b.bidItemID == bidItemId select b.bidAmount).Max();
}
else
{
maxBid = 0;
}
if (maxBid == 0)
{
Session["maxBid"] = "No Bid has been made yet";
}
else
{
Session["maxBid"] = maxBid;
}
Session["bidItemId"] = bidItemId;
BidItem selectedItem = (from b in db.BidItems where b.bidItemID == bidItemId select b).FirstOrDefault();
Session["auctionStart"] = selectedItem.auctionStart;
Session["auctionEnd"] = selectedItem.auctionEnd;
Session["bidItemName"] = selectedItem.itemName;
return(View(selectedItem));
}
protected void Page_Load(object sender, System.EventArgs e)
{
FormsAuthenticationHelper.AuthenticateUserWithReturnUrl();
connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString());
if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.VENDOR)
{
Response.Redirect("../unauthorizedaccess.aspx");
}
if (!(IsPostBack))
{
if (Session[Constant.SESSION_USERID] != null)
{
ViewState[Constant.SESSION_USERID] = Session[Constant.SESSION_USERID].ToString().Trim();
// Get bid general details
if (Session[Constant.SESSION_BIDREFNO] != null)
{
ViewState[Constant.SESSION_BIDREFNO] = Session[Constant.SESSION_BIDREFNO].ToString().Trim();
}
CategoryTransaction catTrans = new CategoryTransaction();
BidItem bidItem = BidItemTransaction.GetBidDetailsByRefNo(ViewState[Constant.SESSION_BIDREFNO].ToString().Trim());
lblPRNumber.Text = bidItem.PRRefNo.ToString();
lblBidReferenceNumber.Text = bidItem.BidRefNo.ToString();
lblCategory.Text = catTrans.GetCategoryByID(bidItem.Category).CategoryName;
lblBidSubmissionDeadline.Text = bidItem.Deadline;
lblDeliveryDate.Text = bidItem.DeliveryDate;
lblBidItemDescription.Text = bidItem.ItemDescription;
ShowBidTenders();
}
}
}
public ActionResult DeleteConfirmed(int id)
{
BidItem bidItem = db.BidItems.Find(id);
db.BidItems.Remove(bidItem);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult writeReview(int bidItemId)
{
BidItem selectedItem = (from b in db.BidItems where b.bidItemID == bidItemId select b).FirstOrDefault();
Session["itemName"] = selectedItem.itemName;
Session["itemId"] = selectedItem.bidItemID;
return(View());
}
protected void Page_Load(object sender, EventArgs e)
{
FormsAuthenticationHelper.AuthenticateUserWithReturnUrl();
connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString());
if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.BUYER)
{
Response.Redirect("../unauthorizedaccess.aspx");
}
if (Request.QueryString["brn"] != null)
{
Session[Constant.SESSION_BIDREFNO] = Request.QueryString["brn"].ToString();
}
if (!(Page.IsPostBack))
{
if (Request.QueryString[Constant.SESSION_BIDREFNO] != null)
{
Session[Constant.SESSION_BIDREFNO] = Request.QueryString[Constant.SESSION_BIDREFNO].ToString().Trim();
}
if (Session["ORDERBY"] == null)
{
Session["ORDERBY"] = "DESC";
}
BidItem bid = BidItemTransaction.QueryBidItemInfo(connstring, Session[Constant.SESSION_BIDREFNO].ToString());
BuyerTransaction buyer = new BuyerTransaction();
CategoryTransaction category = new CategoryTransaction();
GroupDeptSecTransaction grp = new GroupDeptSecTransaction();
CompanyTransaction cmp = new CompanyTransaction();
VendorTransaction vnd = new VendorTransaction();
IncotermTransaction inc = new IncotermTransaction();
OtherTransaction obj = new OtherTransaction();
lblBidReferenceNumber.Text = bid.BidRefNo.ToString().Trim();
lblCompany.Text = cmp.GetCompanyName(connstring, bid.CompanyId.ToString().Trim());
lblRequestor.Text = bid.Requestor.ToString().Trim();
lblPRNumber.Text = bid.PRRefNo.ToString().Trim();
lblPRDate.Text = bid.PRDate.ToString().Trim();
lblGroup.Text = grp.GetGroupDeptSecNameById(connstring, bid.GroupDeptSec.ToString().Trim());
lblBidRefNo.Text = bid.BidRefNo.ToString().Trim();
lblSubCategory.Text = category.GetCategoryNameById(connstring, bid.Category.ToString().Trim());
lblBidSubmissionDeadline.Text = bid.Deadline.ToString().Trim();
lblBidItemDesc.Text = bid.ItemDescription.ToString().Trim();
lblDeliverTo.Text = bid.DeliverTo.ToString().Trim();
lblIncoterm.Text = inc.GetIncotermName(connstring, bid.Incoterm.ToString().Trim());
DisplayDetails();
Bind();
}
}
private void ShowBidInfo()
{
CategoryTransaction catTrans = new CategoryTransaction();
BidItem bid = new BidItem();
bid = BidItemTransaction.QueryFactsAboutABidItemByBidRefNo(ViewState[Constant.SESSION_BIDREFNO].ToString().Trim());
lblBidReferenceNumber.Text = bid.BidRefNo.ToString();
lblCategory.Text = ((Category)catTrans.GetCategoryByID(bid.Category)).CategoryName;
lblBidSubmissionDeadline.Text = bid.Deadline;
lblDeliveryDate.Text = bid.DeliveryDate;
lblDeliverTo.Text = bid.DeliverTo;
}
public ActionResult Edit([Bind(Include = "itemCategory,itemName,itemLink,itemLocation,itemDescription,UserID,isDigital,bidItemID,auctionStatus,auctionStart,auctionEnd,image")] BidItem bidItem)
{
if (ModelState.IsValid)
{
db.Entry(bidItem).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.bidItemID = new SelectList(db.Bids, "bidItemID", "bidItemID", bidItem.bidItemID);
// ViewBag.UserID = new SelectList(db.Users, "userID", "password", bidItem.UserID);
return(View(bidItem));
}
// GET: BidItems/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BidItem bidItem = db.BidItems.Find(id);
if (bidItem == null)
{
return(HttpNotFound());
}
return(View(bidItem));
}
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);
}
// GET: BidItems/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BidItem bidItem = db.BidItems.Find(id);
if (bidItem == null)
{
return(HttpNotFound());
}
ViewBag.bidItemID = new SelectList(db.Bids, "bidItemID", "bidItemID", bidItem.bidItemID);
//ViewBag.UserID = new SelectList(db.Users, "userID", "password", bidItem.UserID);
return(View(bidItem));
}
internal static List <BidItem> getBidItems(string projectId)
{
var resultSet = SqlHelper.ExecuteDataset(_myConnection, CommandType.Text,
"select BidItemHeaderId, BidItemName,ProjectHeaderId from BID01_BidItemHeader where ProjectHeaderId = @PRJID",
new SqlParameter("@PRJID", projectId));
var biditemList = new List <BidItem>();
if (resultSet.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in resultSet.Tables[0].Rows)
{
var bidItem = new BidItem();
bidItem.BidItemHeaderId = Convert.ToString(row["BidItemHeaderId"]);
bidItem.BidItemName = Convert.ToString(row["BidItemName"]);
biditemList.Add(bidItem);
}
}
return(biditemList);
}
public ActionResult submitBid(Bid bid, int bidItemID, string userEmail)
{
Bid newBid = new Models.Bid();
newBid.bidAmount = bid.bidAmount;
newBid.bidTime = DateTime.Now;
User bidingUser = (from u in db.Users where u.email == userEmail select u).FirstOrDefault();
newBid.userID = bidingUser.userID;
newBid.bidItemID = bidItemID;
Random rand = new Random();
newBid.bidID = rand.Next();
BidItem bidItem = (from u in db.BidItems where u.bidItemID == bidItemID select u).FirstOrDefault();
int maxBid;
int bidCount = (from b in db.Bids where b.bidItemID == bidItemID select b.bidAmount).Count();
if (bidCount > 0)
{
maxBid = (from b in db.Bids where b.bidItemID == bidItemID select b.bidAmount).Max();
}
else
{
maxBid = 0;
}
int currentMax = maxBid;
if (bid.bidAmount < currentMax || newBid.bidTime > bidItem.auctionEnd)
{
return(RedirectToAction("bidErrorPage"));
}
else
{
db.Bids.Add(newBid);
db.SaveChanges();
return(RedirectToAction("moreinfo", new { bidItemId = bidItemID }));
}
return(null);
}
private void UpdateBidForAuctionStatus(int vStatus)
{
// Convert the bid item first before the tenders
// get bid item
BidItem bidItem = BidItemTransaction.QueryBidInfo(connstring, Session[Constant.SESSION_BIDREFNO].ToString());
if (vStatus == Constant.BID_STATUS_APPROVED_FOR_AUCTION)
{
BidItemTransaction.UpdateBidForAuctionStatus(connstring, bidItem.BidRefNo.ToString(), vStatus);
string dummyVar = Constant.BLANK;
// save a copy to tblAuctionItem
string vAuctionRefNo = "";
AuctionTransaction auctionTransaction = new AuctionTransaction();
auctionTransaction.InsertAuctionItem(connstring,
bidItem.PRRefNo.ToString(),
bidItem.Requestor,
bidItem.ItemDescription,
bidItem.BuyerId.ToString(),
bidItem.GroupDeptSec.ToString(),
bidItem.Category.ToString(),
Constant.BLANK,
Constant.AUCTION_STATUS_DRAFT.ToString(),
bidItem.DeliveryDate.ToString(),
bidItem.CompanyId.ToString(),
Constant.AUCTION_TYPE_REVERSE.ToString(),
Constant.BLANK,
Constant.BLANK,
Constant.BLANK,
Constant.BLANK,
bidItem.BidRefNo.ToString(),
bidItem.PRDate.ToString().Trim(),
//Constant.BLANK,
//Constant.BLANK,
ref vAuctionRefNo);
}
// convert and create a copy of the bid tender to auction tenders
// start here
}
private void UpdateBidForAuctionStatus(int vStatus)
{
// get bid item
BidItem bidItem = BidItemTransaction.QueryBidInfo(connstring, Session[Constant.SESSION_BIDREFNO].ToString());
if (vStatus == Constant.BID_STATUS_APPROVED_FOR_AUCTION)
{
BidItemTransaction.UpdateBidForAuctionStatus(connstring, bidItem.BidRefNo.ToString(), vStatus);
string dummyVar = Constant.BLANK;
// save a copy to tblAuctionItem
string vAuctionRefNo = "";
AuctionTransaction auctionTransaction = new AuctionTransaction();
auctionTransaction.InsertAuctionItem(connstring,
bidItem.PRRefNo.ToString(),
bidItem.Requestor,
bidItem.ItemDescription,
bidItem.BuyerId.ToString(),
bidItem.GroupDeptSec.ToString(),
bidItem.Category.ToString(),
bidItem.SubCategory.ToString(),
Constant.AUCTION_STATUS_APPROVED.ToString(),
bidItem.DeliveryDate.ToString(),
bidItem.CompanyId.ToString(),
Constant.AUCTION_TYPE_REVERSE.ToString(),
Constant.BLANK,
Constant.BLANK,
Constant.BLANK,
bidItem.BidCurrency.ToString(),
bidItem.BidRefNo.ToString(),
bidItem.PRDate.ToString().Trim(),
//Constant.BLANK,
//Constant.BLANK,
ref vAuctionRefNo);
// copy the bid item details to auction item details
BidItemDetailTransaction detailTransaction = new BidItemDetailTransaction();
ArrayList arrBidItemDetails = detailTransaction.GetBidDetails(connstring, Session[Constant.SESSION_BIDREFNO].ToString());
foreach (BidItemDetail bidDetail in arrBidItemDetails)
{
string vAuctionDetailNo = "";
// insert auction detail to database
auctionTransaction.InsertAuctionItemDetails(
connstring,
bidDetail.Item,
bidDetail.DetailDesc,
bidDetail.Qty.ToString(),
bidDetail.UnitOfMeasure,
Constant.AUCTION_STATUS_APPROVED.ToString(),
vAuctionRefNo,
bidItem.Category.ToString(),
bidItem.SubCategory.ToString(),
"",
"",
"0",
"0",
ref vAuctionDetailNo);
}
}
Response.Redirect("bidsforconversion.aspx");
}
public void ProcessBidSheet(ExcelWorkbook workbook)
{
ExcelWorksheet worksheet = workbook.Worksheets[0];
string Address = worksheet.Cells[6, 2].Value as string;
string ProgjectManager = worksheet.Cells[7, 2].Value as string;
Job job = FindCreateJob(ProgjectManager, Address);
if (job.BidSheet == null)
{
BidSheet BidSheet = new BidSheet();
job.BidSheet = BidSheet;
BidSheet.Date = worksheet.Cells[9, 2].Value is DateTime ? (DateTime)worksheet.Cells[9, 2].Value : DateTime.Parse(worksheet.Cells[9, 2].Value.ToString());
BidSheet.SquareFoot = worksheet.Cells[10, 2].Value.ToString();
BidSheet.BedBath = worksheet.Cells[11, 2].Value as string;
BidSheet.LockBox = worksheet.Cells[12, 2].Value?.ToString();
BidSheet.Year = worksheet.Cells[13, 2].Value?.ToString();
BidSheet.RenoTotal = (decimal)((double)worksheet.Cells[11, 6].Value);
int rowCount = worksheet.Cells.Rows;
BidArea area = null;
BidItem item;
for (int row = 17; row <= rowCount; row++)
{
if ((worksheet.Cells[row, 2] != null && worksheet.Cells[row, 2].Value != null) &&
(worksheet.Cells[row, 5].Value == null || worksheet.Cells[row, 5].Value is string) &&
worksheet.Cells[row, 1].Style.Fill.BackgroundColor.Rgb != null)
{
string color = worksheet.Cells[row, 1].Style.Fill.BackgroundColor.Rgb;
area = new BidArea();
BidSheet.Areas.Add(area);
area.Name = worksheet.Cells[row, 2].Value as string;
area.Description = worksheet.Cells[row, 3].Value as string;
}
else if (worksheet.Cells[row, 5].Value != null && worksheet.Cells[row, 5].Value is double)
{
item = new BidItem();
item.Category = worksheet.Cells[row, 1].Value?.ToString();
item.Sub = worksheet.Cells[row, 2].Value as string;
item.Description = worksheet.Cells[row, 3].Value as string;
item.Quantity = (decimal)(((double?)worksheet.Cells[row, 4].Value) ?? 0.0);
item.UnitCost = (decimal)((double)worksheet.Cells[row, 5].Value);
if (item.Sub != null && item.Sub.Contains("paint", StringComparison.OrdinalIgnoreCase))
{
item.Category = "Paint";
}
if (item.Category != null && item.Category == "Paint")
{
if (item.Description != null && (item.Description.Contains("cabinet", StringComparison.OrdinalIgnoreCase) ||
item.Description.Contains("garage", StringComparison.OrdinalIgnoreCase) ||
item.Description.Contains("primer", StringComparison.OrdinalIgnoreCase)))
{
item.Sub = "Interior Paint";
}
else if (item.Description != null && item.Description.Contains("exterior", StringComparison.OrdinalIgnoreCase))
{
item.Sub = "Exterior Paint";
}
}
if (item.Description != null &&
(item.Description.Contains("primer", StringComparison.OrdinalIgnoreCase) ||
(item.Description.Contains("paint", StringComparison.OrdinalIgnoreCase) && item.Description.Contains("cabin", StringComparison.OrdinalIgnoreCase)) ||
(item.Description.Contains("paint", StringComparison.OrdinalIgnoreCase) && item.Description.Contains("vanity", StringComparison.OrdinalIgnoreCase))
))
{
item.Category = "Paint";
item.Sub = "Interior Paint";
}
if (item.Description != null && item.Description.Contains("shoe", StringComparison.OrdinalIgnoreCase))
{
item.Category = "Flooring";
item.Sub = "Trim";
}
if (item.Description != null || item.Quantity != 0.0m || item.UnitCost != 0.0m)
{
area.Items.Add(item);
}
}
}
int x = context.SaveChanges();
}
}
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, 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");
}
}
}
