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