protected void Page_Load(object sender, EventArgs e) { //Response.Write(Session["UserID"].ToString()); String oid = Request.QueryString["oid"] == null ? "" : Request.QueryString["oid"].ToString(); //string uid = "6"; //Session["StoreID"] = storeid;//the session set caused problem! //Session["UserID"] = uid; if (oid != "") { randb objrandb = new randb(); randbXmpie objXmpie = new randbXmpie(); DataSet exopid = objXmpie.CierantRandBGetOrderProductIDsfromOrder(Convert.ToInt32(oid)); DataTable tblopid = exopid.Tables[0]; int userid = uStore.Common.BLL.CustomerInfo.Current.UserID; decimal total = 0; string availablebudget = ""; string store_id = Session["StoreID"].ToString(); if (tblopid.Rows.Count > 0) { for (int o = 0; o < tblopid.Rows.Count; o++) { decimal dstartingbudget = 0; decimal dremaining = 0; decimal davailbudget = 0; string staringdatetime = ""; string startingbudget = ""; DataRow opRow = tblopid.Rows[o]; string opid = opRow["OrderProductID"] == null ? "" : opRow["OrderProductID"].ToString(); string EncryptedOrderId = opRow["EncryptedOrderId"] == null ? "" : opRow["EncryptedOrderId"].ToString(); string orderid = opRow["OrderID"] == null ? "" : opRow["OrderID"].ToString(); string CostCenter = opRow["CostCenter"] == null ? "" : opRow["CostCenter"].ToString(); string TotalPrice = opRow["TotalPrice"] == null ? "" : opRow["TotalPrice"].ToString(); decimal subtotal = Decimal.Parse(TotalPrice); DataSet dsstaringbudget = objrandb.RandBGetStartingBudget(CostCenter); DataTable tblstaringbudget = dsstaringbudget.Tables[0]; if (tblstaringbudget.Rows.Count > 0) { DataRow startingbudgetRow = tblstaringbudget.Rows[0]; startingbudget = startingbudgetRow["startingbudget"] == null ? "" : startingbudgetRow["startingbudget"].ToString(); if (startingbudget != "" && startingbudget != "0.00" && startingbudget != "0") dstartingbudget = Math.Round(Convert.ToDecimal(startingbudget), 2); staringdatetime = startingbudgetRow["staringdatetime"] == null ? "" : startingbudgetRow["staringdatetime"].ToString(); Response.Write(staringdatetime); } DataSet dsab = objrandb.RandBGetAvailableBudgetCheckOut(CostCenter, dstartingbudget, staringdatetime, Convert.ToInt32(store_id), Convert.ToInt32(orderid)); DataTable tblab = dsab.Tables[0]; if (tblab.Rows.Count > 0) { DataRow ABRow = tblab.Rows[0]; availablebudget = ABRow["availablebudget"] == null ? "" : ABRow["availablebudget"].ToString(); if (availablebudget != "" && availablebudget != "0.00" && availablebudget != "0") davailbudget = Math.Round(Convert.ToDecimal(availablebudget), 2); Response.Write(orderid + "," + davailbudget.ToString() + "," ); //Response.Write(availablebudget + ";" + davailbudget); } total = total + subtotal; //dremaining = davailbudget - total; dremaining = davailbudget - total; Response.Write(opid + "," + dremaining.ToString() + "," + oid + ",total:" + total); objrandb.RandBUpdateOrderProduct(Convert.ToInt32(opid), dremaining, Convert.ToInt32(oid));//different from ooh because this time the ordercost already calculated by RandBGetAvailableBudget } } } }
protected void Page_Load(object sender, EventArgs e) { randb objOoh = new randb(); randbXmpie objOohustore = new randbXmpie(); int Uid = Convert.ToInt32(uStore.Common.BLL.CustomerInfo.Current.UserID.ToString()); retailername.Text = "All"; hiduserid.Value = Uid.ToString(); string lastupdatedate = ""; string startingbudget = ""; string startingbudgetdate = ""; decimal dstartingbudget = 0; DataSet dsearliestdate = objOoh.RandBGetEarliestStartingBudget(Uid); DataTable tblearliestdate = dsearliestdate.Tables[0]; if (tblearliestdate.Rows.Count > 0) { DataRow EarliestRow = tblearliestdate.Rows[0]; string startdate = EarliestRow["earliestdate"] == null ? "" : EarliestRow["earliestdate"].ToString(); if (startdate != "") { string[] words = startdate.Split(' '); startingbudgetdate = words[0]; } } DataSet dslastupdate = objOoh.RandBGetLastUpdate("", Uid); DataTable tbllastupdate = dslastupdate.Tables[0]; if (tbllastupdate.Rows.Count > 0) { DataRow LastupdateRow = tbllastupdate.Rows[0]; lastupdatedate = LastupdateRow["lastupdate"] == null ? "" : LastupdateRow["lastupdate"].ToString(); } lastupdate.Text = lastupdatedate; //annualbudget.Text = dstartingbudget.ToString(); //Response.Write(Uid.ToString()); DataSet dsdistributor = objOoh.RandBGetAllRetailer(Uid); DataTable tbldistributor = dsdistributor.Tables[0]; string htmldistributor = "<select id='ddldistributor' onchange='changeretailer(this.value);'><option value='0'>All</option>"; int count = tbldistributor.Rows.Count; if (count > 0) { for (int c = 0; c < count; c++) { DataRow DistributorRow = tbldistributor.Rows[c]; string retailer = DistributorRow["CostCenter"] == null ? "" : DistributorRow["CostCenter"].ToString(); string retailerid = DistributorRow["CostCenterID"] == null ? "" : DistributorRow["CostCenterID"].ToString(); htmldistributor = htmldistributor + "<option value='" + retailerid + "'>" + retailer + "</option>"; } } htmldistributor = htmldistributor + "</select>"; lbdistributor.Text = htmldistributor; var today = DateTime.Today.ToString("MM/dd/yyyy"); var startdateformat = ""; var previousDate = ""; if (startingbudgetdate != "") { DateTime myDateTime = DateTime.Parse(startingbudgetdate); startdateformat = myDateTime.ToString("MM/dd/yyyy"); StartDate.Value = startdateformat; previousDate = startdateformat; } else { DateTime.Now.Year.ToString(); startdateformat = "01/01/" + DateTime.Now.Year.ToString(); StartDate.Value = startdateformat; previousDate = startdateformat; } DataSet dsbudgetinfo = objOoh.RandBGetProductBudgetInfo("", "all", previousDate, today, Uid); DataTable tblbudgetinfo = dsbudgetinfo.Tables[0]; int budgetcountrow = tblbudgetinfo.Rows.Count; string infohtml = "<table id='data' class='simpletable nopad'><thead><tr><th>Date</th><th>Retailer</th><th>Ordered by</th><th>Transaction</th><th>Order #</th><th>Item #</th><th>Description</th><th>Amount</th><th>Available Balance</th></tr></thead><tbody>"; //Response.Write(budgetcountrow.ToString() + "," + previousDate + "," + today + "," + Uid); if (budgetcountrow > 0) { for (int b = 0; b < budgetcountrow; b++) { DataRow BudgetInfoRow = tblbudgetinfo.Rows[b]; string orderedby = ""; string costcentername = BudgetInfoRow["RetailerName"] == null ? "" : BudgetInfoRow["RetailerName"].ToString(); string FirstName = BudgetInfoRow["FirstName"] == null ? "" : BudgetInfoRow["FirstName"].ToString(); string LastName = BudgetInfoRow["LastName"] == null ? "" : BudgetInfoRow["LastName"].ToString(); string amount = BudgetInfoRow["amount"] == null ? "" : BudgetInfoRow["amount"].ToString(); string Transaction = BudgetInfoRow["Transaction"] == null ? "" : BudgetInfoRow["Transaction"].ToString(); string Description = BudgetInfoRow["Description"] == null ? "" : BudgetInfoRow["Description"].ToString(); string TransactionDate = BudgetInfoRow["TransactionDate"] == null ? "" : BudgetInfoRow["TransactionDate"].ToString(); string OrderId = BudgetInfoRow["EncryptedOrderId"] == null ? "" : BudgetInfoRow["EncryptedOrderId"].ToString(); string view = ""; if (OrderId == "0") OrderId = "-"; string OrderProductID = BudgetInfoRow["OrderProductID"] == null ? "" : BudgetInfoRow["OrderProductID"].ToString(); if (OrderProductID == "0") OrderProductID = "-"; else view = "<a href='#' onclick=\"window.parent.location='../../OrderHistory' \">View</a>"; decimal damount = 0; decimal dAvailableBudget = 0; string amountmoney = ""; string AvailableBudgetmoney = ""; string amountstyle = ""; string AvailableBudgetstyle = ""; if (amount != "0" && amount != "0.00" && amount != "" && amount != "0.00000") damount = Math.Round(Convert.ToDecimal(amount), 2); if (damount < 0) { amountmoney = "-$" + (damount * -1).ToString(); amountstyle = "style='color:red'"; } else amountmoney = "$" + damount.ToString(); string AvailableBudget = BudgetInfoRow["AvailableBudget"] == null ? "" : BudgetInfoRow["AvailableBudget"].ToString(); if (AvailableBudget != "0" && AvailableBudget != "0.00" && AvailableBudget != "") dAvailableBudget = Math.Round(Convert.ToDecimal(AvailableBudget), 2); if (dAvailableBudget < 0) { AvailableBudgetmoney = "-$" + (dAvailableBudget * -1).ToString(); AvailableBudgetstyle = "style='color:red'"; } else AvailableBudgetmoney = "$" + dAvailableBudget.ToString(); if (Transaction == "Order") orderedby = FirstName + " " + LastName; infohtml = infohtml + "<tr><td>" + TransactionDate + "</td><td>" + costcentername + "</td><td>" + orderedby + "</td><td>" + Transaction + "</td><td>" + OrderId + "</td><td>" + OrderProductID + "</td><td>" + Description + "</td>" + "<td " + amountstyle + ">" + amountmoney + "</td><td " + AvailableBudgetstyle + ">" + AvailableBudgetmoney + "</td>"; } } infohtml = infohtml + "</tbody></table>"; tblbudget.InnerHtml = infohtml; }