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