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