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.PURCHASING)
Response.Redirect("../unauthorizedaccess.aspx");
if(!IsPostBack)
{
if (Session[Constant.SESSION_USERID] != null)
{
if (Session[Constant.SESSION_BIDREFNO] != null)
{
ViewState[Constant.SESSION_BIDTENDERNOS] = Session["BidTenderNos"].ToString().Trim();
ViewState[Constant.SESSION_BIDREFNO] = Session[Constant.SESSION_BIDREFNO].ToString().Trim();
ViewState[Constant.SESSION_USERTYPE] = Session[Constant.SESSION_USERTYPE].ToString().Trim();
ViewState[Constant.SESSION_USERID] = Session[Constant.SESSION_USERID].ToString().Trim();
InitializeHiddenFields();
string bidTenderNos = ViewState[Constant.SESSION_BIDTENDERNOS].ToString().Trim();
string bidRefNo = ViewState[Constant.SESSION_BIDREFNO].ToString().Trim();
lblBidRefNo.Text = bidRefNo;
DataTable dtEndorsed = PurchasingTransaction.QuerySelectedEndorsedItems(connstring, bidRefNo, bidTenderNos);
DataView dvEndorsed = new DataView(dtEndorsed);
gvEndorsedItems.DataSource = dvEndorsed;
gvEndorsedItems.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.PURCHASING)
{
Response.Redirect("../unauthorizedaccess.aspx");
}
if (!(Page.IsPostBack))
{
if (Session[Constant.SESSION_USERID] != null)
{
if (Session[Constant.SESSION_BIDREFNO] != null)
{
ViewState[Constant.SESSION_BIDREFNO] = Session[Constant.SESSION_BIDREFNO].ToString().Trim();
lnkBidItem.Text = "Bid Item " + ViewState[Constant.SESSION_BIDREFNO].ToString().Trim();
PurchasingTransaction bid = new PurchasingTransaction();
DataTable dtAwardedItems = bid.QueryAwardedItemsbyBidRefNo(connstring, ViewState[Constant.SESSION_BIDREFNO].ToString().Trim());
DataView dvAwardedItems = new DataView(dtAwardedItems);
gvAwardedItems.DataSource = dvAwardedItems;
gvAwardedItems.DataBind();
}
}
}
}
protected void Submit_Click(object sender, EventArgs e)
{
if (ViewState["BidTenderNos"] != null)
{
string bidTenderNos = ViewState["BidTenderNos"].ToString().Trim();
PurchasingTransaction tender = new PurchasingTransaction();
tender.UpdateBidTenderStatus(connstring, bidTenderNos, Constant.BID_TENDER_STATUS_AWARD.ToString().Trim());
Response.Redirect("bidsforeval.aspx");
}
}
protected void PurchTableDataGet()
{
PurchasingTransaction bid = new PurchasingTransaction();
if (ViewState[Constant.SESSION_USERID] != null)
{
DataTable dt = bid.QueryPurchasingTable(connstring, ViewState[Constant.SESSION_USERID].ToString().Trim());
DataView dv = new DataView(dt);
Gv1.DataSource = dv;
Gv1.DataBind();
}
}
protected void BidForOpenDataGet()
{
PurchasingTransaction bid = new PurchasingTransaction();
//Response.Write(Session["AuthDepID"].ToString());
try
{
DataTable dt = bid.QuerySingleBidTenderStatus(connstring, ViewState["AuthDepID"].ToString());
DataView dv = new DataView(dt);
GridView1.DataSource = dv;
GridView1.DataBind();
}
catch (System.NullReferenceException)
{
Response.Redirect("bidsforopening.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)
{
PageTitle.InnerText = String.Format(Constant.TITLEFORMAT, "Home");
FormsAuthenticationHelper.AuthenticateUserWithReturnUrl();
connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString());
if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.PURCHASING)
{
Response.Redirect("../unauthorizedaccess.aspx");
}
if (!(Page.IsPostBack))
{
if ((Session[Constant.SESSION_USERID] != null) && (Session[Constant.SESSION_USERTYPE] != null))
{
lblName.Text = String.Format("Welcome {0}!", Session[Constant.SESSION_USERFULLNAME].ToString());
int[] purchasing_values = PurchasingTransaction.QueryCountAll(connstring, Convert.ToInt32(Session[Constant.SESSION_USERID].ToString()));
lblBidEventsForApproval.Text = "(" + purchasing_values[0].ToString() + ")";
lblApprovedBidEvents.Text = "(" + purchasing_values[1].ToString() + ")";
lblConvertedBidItems.Text = "(" + purchasing_values[11].ToString() + ")";
lblAwardedBidItems.Text = "(" + purchasing_values[4].ToString() + ")";
lblWithdrawnItems.Text = "(" + purchasing_values[13].ToString() + ")";
lblRecievedEndorsements.Text = "(" + purchasing_values[3].ToString() + ")";
lblBidTendersForRenegotiation.Text = "(" + purchasing_values[2].ToString() + ")";
lblAuctionEventsForApproval.Text = "(" + purchasing_values[5].ToString() + ")";
//lblConfirmedAuctionInvitations.Text = "(" + purchasing_values[6].ToString() + ")";
lblAwardedAuctionItems.Text = "(" + purchasing_values[7].ToString() + ")";
lblEndorsedAuctionItems.Text = "(" + purchasing_values[12].ToString() + ")";
lblOngoingAuctionEvents.Text = "(" + purchasing_values[8].ToString() + ")";
lblUpcomingAuctionEvents.Text = "(" + purchasing_values[9].ToString() + ")";
lblFinishedAuctionEvents.Text = "(" + purchasing_values[10].ToString() + ")";
}
}
}
private void CheckIfPosted()
{
string isPosted = hdnIsPosted.Value.Trim();
if (isPosted == "1")
{
if (ViewState["BidTenderNos"] != null)
{
string bidTenderNos = ViewState["BidTenderNos"].ToString().Trim();
PurchasingTransaction tender = new PurchasingTransaction();
tender.UpdateBidTenderStatus(connstring, bidTenderNos, Constant.BID_TENDER_STATUS_WAIT_FOR_RE_NEGOTIATE.ToString().Trim());
Session.Remove(Constant.SESSION_BIDREFNO);
Session.Remove("BidTenderNos");
hdnIsPosted.Value = "0";
Response.Redirect("bidsforeval.aspx");
}
}
}
protected void Unlock_Btn_Click(object sender, EventArgs e)
{
string dept = null;
string bidTenderGenNo = ViewState["AuthDepID"].ToString();
foreach (GridViewRow gvr in Gv1.Rows)
{
dept = ((Label)gvr.FindControl("lblDeptID")).Text;
}
if (CheckPassword())
{
PurchasingTransaction bid = new PurchasingTransaction();
bid.UpdateAuthTable(connstring, dept, bidTenderGenNo);
Response.Redirect("bidunlockingpage.aspx");
}
else
{
Session["message"] = "Incorrect Password, Please Try Again.";
Response.Redirect("bidunlockingpage.aspx", true);
}
}
