private void getMerchantItems() { DataTable mdt = (DataTable)this.Session["MId"]; int mId = Convert.ToInt32(mdt.Rows[0]["MId"].ToString()); DataSet itemData = new DataSet(); if (System.Web.HttpContext.Current.Cache["CacheItemsObj"] == null) { CLASS.CallCache getcache = new budhashop.CLASS.CallCache(); itemData = getcache.getCache(); } else { itemData = (DataSet)System.Web.HttpContext.Current.Cache["CacheItemsObj"]; } DataTable dt = itemData.Tables[0]; DataRow[] merchantItems = dt.Select("MId = '" + mId + "'"); DataTable merchantItemsDt = null; if (merchantItems.Length > 0) { merchantItemsDt = merchantItems.CopyToDataTable(); } itemGrid.DataSource = merchantItemsDt; itemGrid.DataBind(); }
internal List <SearchAll> GetItemsList(int mId) { List <SearchAll> list = new List <SearchAll>(); DataSet itemData = new DataSet(); if (System.Web.HttpContext.Current.Cache["CacheItemsObj"] == null) { CLASS.CallCache getcache = new budhashop.CLASS.CallCache(); itemData = getcache.getCache(); } else { itemData = (DataSet)System.Web.HttpContext.Current.Cache["CacheItemsObj"]; } DataRow[] dr = itemData.Tables[0].Select("MId = '" + mId + "'"); if (dr.Length > 0) { foreach (DataRow dtr in dr) { SearchAll prj = new SearchAll(); prj.ItemId = Convert.ToInt32(dtr["ItemId"].ToString()); prj.value = dtr["ItemName"].ToString(); list.Add(prj); } } return(list.ToList()); }
internal List<SearchAll> GetItemsList(int mId) { List<SearchAll> list = new List<SearchAll>(); DataSet itemData = new DataSet(); if (System.Web.HttpContext.Current.Cache["CacheItemsObj"] == null) { CLASS.CallCache getcache = new budhashop.CLASS.CallCache(); itemData = getcache.getCache(); } else { itemData = (DataSet)System.Web.HttpContext.Current.Cache["CacheItemsObj"]; } DataRow[] dr = itemData.Tables[0].Select("MId = '" + mId + "'"); if (dr.Length > 0) { foreach (DataRow dtr in dr) { SearchAll prj = new SearchAll(); prj.ItemId = Convert.ToInt32(dtr["ItemId"].ToString()); prj.value = dtr["ItemName"].ToString(); list.Add(prj); } } return list.ToList(); }
internal List <SearchAll> GetSearchList() { DataTable dt = new DataTable(); DataTable dtg = new DataTable(); //InterfacesBS.InterfacesBL.InterfaceItems allData = new BusinessLogicBS.BusinessClasses.ItemsClass(); budhashop.CLASS.CallCache callCache = new budhashop.CLASS.CallCache(); DataSet allDataDS = callCache.getCache(); dt = allDataDS.Tables[0]; dtg = allDataDS.Tables[1]; List <SearchAll> list = new List <SearchAll>(); int cnt = dt.Rows.Count; for (int i = 0; i < cnt; i++) { // ProjectActivity prj = new ProjectActivity(); SearchAll prj = new SearchAll(); int id = int.Parse(dt.Rows[i]["ItemId"].ToString()); int grp = int.Parse(dt.Rows[i]["CategoryId"].ToString()); prj.value = dt.Rows[i]["ItemName"].ToString(); prj.ItemLink = "../fulldetails.aspx?id=" + id + "&grp=" + grp; //prj.ActualHours = int.Parse(dt.Rows[i]["ActualHours"].ToString()); list.Add(prj); } int cnt2 = dtg.Rows.Count; for (int i = 0; i < cnt2; i++) { SearchAll prj2 = new SearchAll(); int idg = int.Parse(dtg.Rows[i]["GroupId"].ToString()); int grpg = 1; prj2.value = dtg.Rows[i]["GroupName"].ToString(); prj2.ItemLink = "../fulldetails.aspx?id=" + idg + "&grp=" + grpg; list.Add(prj2); } return(list.ToList()); }
private void searchOrders() { DataTable mdt = (DataTable)this.Session["MId"]; int mId = Convert.ToInt32(mdt.Rows[0]["MId"].ToString()); string startDate = txt_datepick1.Text; string endDate = txt_datepick2.Text; int itemIdSearched = Convert.ToInt32(hdn_itemId.Value); try { InterfacesBS.InterfacesBL.IUser searchOrders = new BusinessLogicBS.UserClasses.UserItems(); DataTable merchantOrderDt = searchOrders.searchMerchantOrders(mId, itemIdSearched, startDate, endDate); if (merchantOrderDt != null) { merchantOrderDt.Columns.Add("ItemName"); merchantOrderDt.Columns.Add("ImagePath"); foreach (DataRow dr in merchantOrderDt.Rows) { int itemId = Convert.ToInt32(dr["ItemId"]); DataSet itemData = new DataSet(); if (System.Web.HttpContext.Current.Cache["CacheItemsObj"] == null) { CLASS.CallCache getcache = new budhashop.CLASS.CallCache(); itemData = getcache.getCache(); } else { itemData = (DataSet)System.Web.HttpContext.Current.Cache["CacheItemsObj"]; } var itemDetails = itemData.Tables[0].AsEnumerable().First(p => p.Field <long>("ItemId") == itemId); dr["ItemName"] = itemDetails["ItemName"].ToString(); dr["ImagePath"] = itemDetails["ImagePath"].ToString(); } searchDiv.Visible = true; btn_refresh.Visible = true; } gv_MerchantOrders.Visible = false; gv_MerchantOrdersSearch.DataSource = merchantOrderDt; gv_MerchantOrdersSearch.DataBind(); hdn_itemId.Value = "0"; } catch (Exception ex) { lbl_search.Text = HardCodedValues.BuddaResource.CatchBlockError + ex.Message; } }
internal List<SearchAll> GetSearchList() { DataTable dt = new DataTable(); DataTable dtg = new DataTable(); //InterfacesBS.InterfacesBL.InterfaceItems allData = new BusinessLogicBS.BusinessClasses.ItemsClass(); budhashop.CLASS.CallCache callCache = new budhashop.CLASS.CallCache(); DataSet allDataDS = callCache.getCache(); dt = allDataDS.Tables[0]; dtg = allDataDS.Tables[1]; List<SearchAll> list = new List<SearchAll>(); int cnt = dt.Rows.Count; for (int i = 0; i < cnt; i++) { // ProjectActivity prj = new ProjectActivity(); SearchAll prj = new SearchAll(); int id = int.Parse(dt.Rows[i]["ItemId"].ToString()); int grp = int.Parse(dt.Rows[i]["CategoryId"].ToString()); prj.value = dt.Rows[i]["ItemName"].ToString(); prj.ItemLink = "../fulldetails.aspx?id=" + id + "&grp=" + grp; //prj.ActualHours = int.Parse(dt.Rows[i]["ActualHours"].ToString()); list.Add(prj); } int cnt2 = dtg.Rows.Count; for (int i = 0; i < cnt2; i++) { SearchAll prj2 = new SearchAll(); int idg = int.Parse(dtg.Rows[i]["GroupId"].ToString()); int grpg = 1; prj2.value = dtg.Rows[i]["GroupName"].ToString(); prj2.ItemLink = "../fulldetails.aspx?id=" + idg + "&grp=" + grpg; list.Add(prj2); } return list.ToList(); }
private void LoadItems(List <CartItems> Cartinfo) { DataTable CartDT = new DataTable();//data to be bound to cart datalist DataColumn dcId = new DataColumn("ItemId", typeof(long)); CartDT.Columns.Add(dcId); DataColumn dcPath = new DataColumn("ImagePath", typeof(string)); CartDT.Columns.Add(dcPath); DataColumn dcNme = new DataColumn("ItemName", typeof(string)); CartDT.Columns.Add(dcNme); DataColumn dcQy = new DataColumn("Qty", typeof(int)); CartDT.Columns.Add(dcQy); DataColumn dcBr = new DataColumn("BilledRate", typeof(float)); CartDT.Columns.Add(dcBr); DataColumn dcTr = new DataColumn("TotalRate", typeof(float)); CartDT.Columns.Add(dcTr); DataColumn dcSz = new DataColumn("Size", typeof(string)); CartDT.Columns.Add(dcSz); DataSet ds = new DataSet(); DataTable dtv = new DataTable(); DataTable dtg = new DataTable(); //InterfacesBS.InterfacesBL.InterfaceItems callCache = new ItemsClass(); budhashop.CLASS.CallCache callCache = new budhashop.CLASS.CallCache(); ds = callCache.getCache(); dtv = ds.Tables[0]; dtg = ds.Tables[1]; //create cache for group items and store here and loop throuh groups if groupChk is true in session list float totalPrice = 0; foreach (object cartObj in Cartinfo) { CartItems item = cartObj as CartItems; int cid = item.ItemId; int qty = item.Qty; string Size = ""; if (item.TypeCheck != "undefined") { Size = "Size : " + item.TypeCheck; } bool grpId = item.GrpChk; // finding the data item if (grpId) { var itemDetails = dtg.AsEnumerable().First(p => p.Field <long>("GroupId") == cid); if (itemDetails != null) { DataRow dr = CartDT.NewRow(); dr[0] = itemDetails["GroupId"]; dr[1] = itemDetails["ImagePath"];//change this to actual image path when done dr[2] = itemDetails["GroupName"]; dr[3] = qty; dr[4] = float.Parse(itemDetails["BilledRate"].ToString()); float totRate = qty * (float.Parse(itemDetails["BilledRate"].ToString())); dr[5] = totRate; dr[6] = Size; totalPrice += totRate; CartDT.Rows.Add(dr); } } else { var itemDetails = dtv.AsEnumerable().First(p => p.Field <long>("ItemId") == cid); if (itemDetails != null) { DataRow dr = CartDT.NewRow(); dr[0] = itemDetails["ItemId"]; dr[1] = itemDetails["ImagePath"]; dr[2] = itemDetails["ItemName"]; dr[3] = qty; dr[4] = float.Parse(itemDetails["BilledRate"].ToString()); float totRate = qty * (float.Parse(itemDetails["BilledRate"].ToString())); dr[5] = totRate; dr[6] = Size; totalPrice += totRate; CartDT.Rows.Add(dr); } } // updating the data row from the itemDetails object. } if (CartDT != null) { DataView dv = new DataView(); PagedDataSource pagedData = new PagedDataSource(); int rowCnt = CartDT.Rows.Count; noOfItemsLbl2.Text = rowCnt.ToString(); totalLbl2.Text = totalPrice.ToString(); dv = CartDT.DefaultView; pagedData.DataSource = dv; //pagedData.AllowPaging = true; //pagedData.PageSize = 4; pagedData.CurrentPageIndex = 0; itemCartDL.DataSource = pagedData; itemCartDL.DataBind(); } else { itemCartDL.DataSource = ""; itemCartDL.DataBind(); } }
private void LoadItems(List<CartItems> Cartinfo) { DataTable CartDT = new DataTable();//data to be bound to cart datalist DataColumn dcId = new DataColumn("ItemId", typeof(long)); CartDT.Columns.Add(dcId); DataColumn dcPath = new DataColumn("ImagePath", typeof(string)); CartDT.Columns.Add(dcPath); DataColumn dcNme = new DataColumn("ItemName", typeof(string)); CartDT.Columns.Add(dcNme); DataColumn dcQy = new DataColumn("Qty", typeof(int)); CartDT.Columns.Add(dcQy); DataColumn dcBr = new DataColumn("BilledRate", typeof(float)); CartDT.Columns.Add(dcBr); DataColumn dcTr = new DataColumn("TotalRate", typeof(float)); CartDT.Columns.Add(dcTr); DataColumn dcSz = new DataColumn("Size", typeof(string)); CartDT.Columns.Add(dcSz); DataSet ds = new DataSet(); DataTable dtv = new DataTable(); DataTable dtg = new DataTable(); //InterfacesBS.InterfacesBL.InterfaceItems callCache = new ItemsClass(); budhashop.CLASS.CallCache callCache = new budhashop.CLASS.CallCache(); ds = callCache.getCache(); dtv = ds.Tables[0]; dtg = ds.Tables[1]; //create cache for group items and store here and loop throuh groups if groupChk is true in session list float totalPrice = 0; foreach (object cartObj in Cartinfo) { CartItems item = cartObj as CartItems; int cid = item.ItemId; int qty = item.Qty; string Size = ""; if (item.TypeCheck != "undefined") { Size = "Size : " + item.TypeCheck; } bool grpId = item.GrpChk; var cartItems = (List<CartItems>)Session["CartPicks"]; var cartItem = cartItems.First(p => p.ItemId == cid && p.TypeCheck == item.TypeCheck); // finding the data item if (grpId) { var itemDetails = dtg.AsEnumerable().First(p => p.Field<long>("GroupId") == cid); if (itemDetails != null) { DataRow dr = CartDT.NewRow(); dr[0] = itemDetails["GroupId"]; dr[1] = itemDetails["ImagePath"]; //change this to actual image path when done dr[2] = itemDetails["GroupName"]; dr[3] = qty; float blrte = float.Parse(itemDetails["BilledRate"].ToString()); dr[4] = blrte; //float ntrte = float.Parse(itemDetails["NetRate"].ToString()); //cartItem.totalNet = ntrte; float totRate = qty * blrte; cartItem.TotalBill = totRate; dr[5] = totRate; dr[6] = Size; totalPrice += totRate; CartDT.Rows.Add(dr); } } else { var itemDetails = dtv.AsEnumerable().First(p => p.Field<long>("ItemId") == cid); if (itemDetails != null) { DataRow dr = CartDT.NewRow(); dr[0] = itemDetails["ItemId"]; dr[1] = itemDetails["ImagePath"]; dr[2] = itemDetails["ItemName"]; dr[3] = qty; float blrte = float.Parse(itemDetails["BilledRate"].ToString()); dr[4] = blrte; //float ntrte = float.Parse(itemDetails["NetRate"].ToString()); //cartItem.totalNet = ntrte; float totRate = qty * blrte; cartItem.TotalBill = totRate; dr[5] = totRate; dr[6] = Size; totalPrice += totRate; CartDT.Rows.Add(dr); } } Session["CartPicks"] = cartItems; // updating the data row from the itemDetails object. } if (CartDT != null) { DataView dv = new DataView(); PagedDataSource pagedData = new PagedDataSource(); int rowCnt = CartDT.Rows.Count; noOfItemsLbl.Text = rowCnt.ToString(); totitems.Text = rowCnt.ToString(); if (rowCnt > 0) { orderBtn1.Enabled = true; errorMsg.Text = ""; } else { orderBtn1.Enabled = false; errorMsg.Text = "No products added"; } totalLbl.Text = totalPrice.ToString(); Session["itemCheck"] = totitems.Text; // old values will be store in below sessions. Session["totCheck"] = totalLbl.Text; dv = CartDT.DefaultView; pagedData.DataSource = dv; //pagedData.AllowPaging = true; //pagedData.PageSize = 4; pagedData.CurrentPageIndex = 0; itemCartDL.DataSource = pagedData; itemCartDL.DataBind(); } else { itemCartDL.DataSource = ""; itemCartDL.DataBind(); orderBtn1.Enabled = false; } }
protected void orderGrid_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("show")) { int index = Convert.ToInt32(e.CommandArgument.ToString()); string PurchaseId = orderGrid.DataKeys[index].Value.ToString(); string UserId = orderGrid.DataKeys[index]["Uid"].ToString(); string ItemQty = orderGrid.DataKeys[index]["NoItems"].ToString(); string totalBill = orderGrid.DataKeys[index]["TotalBilledRate"].ToString(); string purchaseDate = orderGrid.DataKeys[index]["PurchaseDate"].ToString();//ItemString bool isDelivered = bool.Parse(orderGrid.DataKeys[index]["DeliveredFlag"].ToString()); string itemString = orderGrid.DataKeys[index]["ItemString"].ToString(); string addrString = orderGrid.DataKeys[index]["ShippingAddress"].ToString(); string TypeString = orderGrid.DataKeys[index]["TypeItem"].ToString(); //string itemString = (HiddenField)row.Cells[index].FindControl("HiddenItemStr")).Value; //string addrString = ((HiddenField)e.Row.FindControl("HiddenAddrStr")).Value; budhashop.CLASS.CallCache callCache = new budhashop.CLASS.CallCache(); DataSet itemData = new DataSet(); itemData = callCache.getCache(); DataTable dt = itemData.Tables[0]; DataTable dtg = itemData.Tables[1]; //List<string[]> arrays = new List<string[]>(); var primeArray = addrString.Split(';'); string name = primeArray[0]; string phone = primeArray[1]; string address = primeArray[2]; NameA.Text = name; PhnA.Text = phone; AdrA.Text = address; itemsDiv.Visible = true; DataTable CartDT = new DataTable(); //data to be bound to cart datalist DataColumn dcId = new DataColumn("ItemId", typeof(long)); CartDT.Columns.Add(dcId); DataColumn dcPath = new DataColumn("ImagePath", typeof(string)); CartDT.Columns.Add(dcPath); DataColumn dcNme = new DataColumn("ItemName", typeof(string)); CartDT.Columns.Add(dcNme); DataColumn dcQy = new DataColumn("Qty", typeof(int)); CartDT.Columns.Add(dcQy); DataColumn dcBr = new DataColumn("BilledRate", typeof(float)); CartDT.Columns.Add(dcBr); DataColumn dcTr = new DataColumn("TotalRate", typeof(float)); CartDT.Columns.Add(dcTr); DataColumn dcSz = new DataColumn("Size", typeof(string)); CartDT.Columns.Add(dcSz); //itemString.Remove(itemString.Length); var itemsArray = itemString.Split(';'); var sizeArray = TypeString.Split(';'); for (var i = 0; i < itemsArray.Length - 1; i++) { var items = itemsArray[i].Split(','); int itemId = int.Parse(items[0].ToString()); int qty = int.Parse(items[1].ToString()); var itemDetails = dt.AsEnumerable().First(p => p.Field <long>("ItemId") == itemId); if (itemDetails == null) { itemDetails = dtg.AsEnumerable().First(p => p.Field <long>("ItemId") == itemId); } if (itemDetails != null) { DataRow dr = CartDT.NewRow(); dr[0] = itemDetails["ItemId"]; dr[1] = itemDetails["ImagePath"]; dr[2] = itemDetails["ItemName"]; dr[3] = qty; float blrte = float.Parse(itemDetails["BilledRate"].ToString()); dr[4] = blrte; //cartItem.TotalBill = blrte; //float ntrte = float.Parse(itemDetails["NetRate"].ToString()); //cartItem.totalNet = ntrte; float totRate = qty * (float.Parse(itemDetails["BilledRate"].ToString())); dr[5] = totRate; dr[6] = sizeArray[i]; CartDT.Rows.Add(dr); } } SelectedOrderGrid.DataSource = CartDT; SelectedOrderGrid.DataBind(); itemsDiv.Visible = true; } }
private void retrieveMerchant() { DataTable mdt = (DataTable)this.Session["MId"]; int areaId = Convert.ToInt32(mdt.Rows[0]["AREA_ID"].ToString()); int mId = Convert.ToInt32(mdt.Rows[0]["MId"].ToString()); InterfacesBS.InterfacesBL.IUser getmerchant = new BusinessLogicBS.UserClasses.UserItems(); DataSet merchantDS = getmerchant.getMerchant(mId, areaId); DataTable dt = merchantDS.Tables[0]; if (dt != null) { txt_mName.Text = dt.Rows[0]["MName"].ToString(); txt_mType.Text = dt.Rows[0]["MType"].ToString(); txt_mAddress.Text = dt.Rows[0]["MAddress"].ToString(); txt_mPhno.Text = dt.Rows[0]["MPhNo"].ToString(); string catID = dt.Rows[0]["CatId"].ToString(); DataTable merchantOrderDt = merchantDS.Tables[1]; //merchantOrderDt.DefaultView.Sort = "Date Desc"; if (merchantOrderDt != null) { merchantOrderDt.Columns.Add("ItemName"); merchantOrderDt.Columns.Add("ImagePath"); foreach (DataRow dr in merchantOrderDt.Rows) { int itemId = Convert.ToInt32(dr["ItemId"]); DataSet itemData = new DataSet(); if (System.Web.HttpContext.Current.Cache["CacheItemsObj"] == null) { CLASS.CallCache getcache = new budhashop.CLASS.CallCache(); itemData = getcache.getCache(); } else { itemData = (DataSet)System.Web.HttpContext.Current.Cache["CacheItemsObj"]; } var itemDetails = itemData.Tables[0].AsEnumerable().First(p => p.Field <long>("ItemId") == itemId); dr["ItemName"] = itemDetails["ItemName"].ToString(); dr["ImagePath"] = itemDetails["ImagePath"].ToString(); } } gv_MerchantOrders.DataSource = merchantOrderDt; gv_MerchantOrders.DataBind(); DataTable merchantOrderDtArea = merchantDS.Tables[2]; //DataTable ordersAreDt; //ordersAreDt.Columns.Add("ItemId"); //ordersAreDt.Columns.Add("Qty"); //ordersAreDt.Columns.Add("Date"); //ordersAreDt.Columns.Add("ItemName"); //ordersAreDt.Columns.Add("ImagePath"); //merchantOrderDt.DefaultView.Sort = "Date Desc"; if (merchantOrderDtArea != null) { merchantOrderDtArea.Columns.Add("ItemName"); merchantOrderDtArea.Columns.Add("ImagePath"); foreach (DataRow dr in merchantOrderDtArea.Rows) { int itemId = Convert.ToInt32(dr["ItemId"]); DataSet itemData = new DataSet(); if (System.Web.HttpContext.Current.Cache["CacheItemsObj"] == null) { CLASS.CallCache getcache = new budhashop.CLASS.CallCache(); itemData = getcache.getCache(); } else { itemData = (DataSet)System.Web.HttpContext.Current.Cache["CacheItemsObj"]; } var itemDetails = itemData.Tables[0].AsEnumerable().First(p => p.Field <long>("ItemId") == itemId); if (catID == itemDetails["CategoryId"].ToString()) { dr["ItemName"] = itemDetails["ItemName"].ToString(); dr["ImagePath"] = itemDetails["ImagePath"].ToString(); } else { dr.Delete(); } } } GridViewOrderArea.DataSource = merchantOrderDtArea; GridViewOrderArea.DataBind(); } else { Response.Redirect("../Merchant/login.aspx"); } }
//List<CartItems> Cartinfo) private void LoadItemsFinal() { if (HttpContext.Current.Session["CartPicks"] != null) { List<CartItems> CartDetails2 = new List<CartItems>(); CartDetails2 = (List<CartItems>)HttpContext.Current.Session["CartPicks"]; DataTable CartDT = new DataTable();//data to be bound to cart datalist DataColumn dcId = new DataColumn("ItemId", typeof(long)); CartDT.Columns.Add(dcId); //DataColumn dcPath = new DataColumn("ImagePath", typeof(string)); //CartDT.Columns.Add(dcPath); DataColumn dcNme = new DataColumn("ItemName", typeof(string)); CartDT.Columns.Add(dcNme); DataColumn dcQy = new DataColumn("Qty", typeof(int)); CartDT.Columns.Add(dcQy); DataColumn dcBr = new DataColumn("BilledRate", typeof(float)); CartDT.Columns.Add(dcBr); DataColumn dcTr = new DataColumn("TotalRate", typeof(float)); CartDT.Columns.Add(dcTr); DataColumn dcSz = new DataColumn("Size", typeof(string)); CartDT.Columns.Add(dcSz); DataSet ds = new DataSet(); DataTable dtv = new DataTable(); DataTable dtg = new DataTable(); //InterfacesBS.InterfacesBL.InterfaceItems callCache = new ItemsClass(); budhashop.CLASS.CallCache callCache = new budhashop.CLASS.CallCache(); ds = callCache.getCache(); dtv = ds.Tables[0]; dtg = ds.Tables[1]; //create cache for group items and store here and loop throuh groups if groupChk is true in session list float totalPrice = 0; foreach (object cartObj in CartDetails2) { CartItems item = cartObj as CartItems; int cid = item.ItemId; int qty = item.Qty; string size = item.TypeCheck; bool grpId = item.GrpChk; // finding the data item if (grpId) { var itemDetails = dtg.AsEnumerable().First(p => p.Field<long>("GroupId") == cid); if (itemDetails != null) { DataRow dr = CartDT.NewRow(); dr[0] = itemDetails["GroupId"]; //dr[1] = itemDetails["ImagePath"];//change this to actual image path when done dr[1] = itemDetails["GroupName"]; dr[2] = qty; dr[3] = float.Parse(itemDetails["BilledRate"].ToString()); float totRate = qty * (float.Parse(itemDetails["BilledRate"].ToString())); dr[4] = totRate; if (size != "") { dr[5] = size; } totalPrice += totRate; CartDT.Rows.Add(dr); } } else { var itemDetails = dtv.AsEnumerable().First(p => p.Field<long>("ItemId") == cid); if (itemDetails != null) { DataRow dr = CartDT.NewRow(); dr[0] = itemDetails["ItemId"]; //dr[1] = itemDetails["ImagePath"]; dr[1] = itemDetails["ItemName"]; dr[2] = qty; dr[3] = float.Parse(itemDetails["BilledRate"].ToString()); float totRate = qty * (float.Parse(itemDetails["BilledRate"].ToString())); dr[4] = totRate; if (size != "") { dr[5] = size; } totalPrice += totRate; CartDT.Rows.Add(dr); } } // updating the data row from the itemDetails object. } if (CartDT != null) { DataView dv = new DataView(); PagedDataSource pagedData = new PagedDataSource(); int rowCnt = CartDT.Rows.Count; //noOfItemsLbl.Text = rowCnt.ToString(); //totalLbl.Text = totalPrice.ToString(); dv = CartDT.DefaultView; pagedData.DataSource = dv; //pagedData.AllowPaging = true; //pagedData.PageSize = 4; pagedData.CurrentPageIndex = 0; cartDataGV.DataSource = pagedData; cartDataGV.DataBind(); } else { cartDataGV.DataSource = ""; cartDataGV.DataBind(); } } else { Response.Redirect("../homepage.aspx"); } }
protected void orderGrid_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("show")) { int index = Convert.ToInt32(e.CommandArgument.ToString()); string PurchaseId = orderGrid.DataKeys[index].Value.ToString(); string UserId = orderGrid.DataKeys[index]["Uid"].ToString(); string ItemQty = orderGrid.DataKeys[index]["NoItems"].ToString(); string totalBill = orderGrid.DataKeys[index]["TotalBilledRate"].ToString(); string purchaseDate = orderGrid.DataKeys[index]["PurchaseDate"].ToString();//ItemString bool isDelivered = bool.Parse(orderGrid.DataKeys[index]["DeliveredFlag"].ToString()); string itemString = orderGrid.DataKeys[index]["ItemString"].ToString(); string addrString = orderGrid.DataKeys[index]["ShippingAddress"].ToString(); string TypeString = orderGrid.DataKeys[index]["TypeItem"].ToString(); //string itemString = (HiddenField)row.Cells[index].FindControl("HiddenItemStr")).Value; //string addrString = ((HiddenField)e.Row.FindControl("HiddenAddrStr")).Value; budhashop.CLASS.CallCache callCache = new budhashop.CLASS.CallCache(); DataSet itemData = new DataSet(); itemData = callCache.getCache(); DataTable dt = itemData.Tables[0]; DataTable dtg = itemData.Tables[1]; //List<string[]> arrays = new List<string[]>(); var primeArray = addrString.Split(';'); string name = primeArray[0]; string phone = primeArray[1]; string address = primeArray[2]; NameA.Text = name; PhnA.Text = phone; AdrA.Text = address; itemsDiv.Visible = true; DataTable CartDT = new DataTable();//data to be bound to cart datalist DataColumn dcId = new DataColumn("ItemId", typeof(long)); CartDT.Columns.Add(dcId); DataColumn dcPath = new DataColumn("ImagePath", typeof(string)); CartDT.Columns.Add(dcPath); DataColumn dcNme = new DataColumn("ItemName", typeof(string)); CartDT.Columns.Add(dcNme); DataColumn dcQy = new DataColumn("Qty", typeof(int)); CartDT.Columns.Add(dcQy); DataColumn dcBr = new DataColumn("BilledRate", typeof(float)); CartDT.Columns.Add(dcBr); DataColumn dcTr = new DataColumn("TotalRate", typeof(float)); CartDT.Columns.Add(dcTr); DataColumn dcSz = new DataColumn("Size", typeof(string)); CartDT.Columns.Add(dcSz); //itemString.Remove(itemString.Length); var itemsArray = itemString.Split(';'); var sizeArray = TypeString.Split(';'); for (var i = 0; i < itemsArray.Length-1; i++) { var items = itemsArray[i].Split(','); int itemId = int.Parse(items[0].ToString()); int qty = int.Parse(items[1].ToString()); var itemDetails = dt.AsEnumerable().First(p => p.Field<long>("ItemId") == itemId); if (itemDetails == null) { itemDetails = dtg.AsEnumerable().First(p => p.Field<long>("ItemId") == itemId); } if (itemDetails != null) { DataRow dr = CartDT.NewRow(); dr[0] = itemDetails["ItemId"]; dr[1] = itemDetails["ImagePath"]; dr[2] = itemDetails["ItemName"]; dr[3] = qty; float blrte = float.Parse(itemDetails["BilledRate"].ToString()); dr[4] = blrte; //cartItem.TotalBill = blrte; //float ntrte = float.Parse(itemDetails["NetRate"].ToString()); //cartItem.totalNet = ntrte; float totRate = qty * (float.Parse(itemDetails["BilledRate"].ToString())); dr[5] = totRate; dr[6] = sizeArray[i]; CartDT.Rows.Add(dr); } } SelectedOrderGrid.DataSource = CartDT; SelectedOrderGrid.DataBind(); itemsDiv.Visible = true; } }
private void searchOrders() { DataTable mdt = (DataTable)this.Session["MId"]; int mId = Convert.ToInt32(mdt.Rows[0]["MId"].ToString()); string startDate = txt_datepick1.Text; string endDate = txt_datepick2.Text; int itemIdSearched = Convert.ToInt32(hdn_itemId.Value); try { InterfacesBS.InterfacesBL.IUser searchOrders = new BusinessLogicBS.UserClasses.UserItems(); DataTable merchantOrderDt = searchOrders.searchMerchantOrders(mId, itemIdSearched, startDate, endDate); if (merchantOrderDt != null) { merchantOrderDt.Columns.Add("ItemName"); merchantOrderDt.Columns.Add("ImagePath"); foreach (DataRow dr in merchantOrderDt.Rows) { int itemId = Convert.ToInt32(dr["ItemId"]); DataSet itemData = new DataSet(); if (System.Web.HttpContext.Current.Cache["CacheItemsObj"] == null) { CLASS.CallCache getcache = new budhashop.CLASS.CallCache(); itemData = getcache.getCache(); } else { itemData = (DataSet)System.Web.HttpContext.Current.Cache["CacheItemsObj"]; } var itemDetails = itemData.Tables[0].AsEnumerable().First(p => p.Field<long>("ItemId") == itemId); dr["ItemName"] = itemDetails["ItemName"].ToString(); dr["ImagePath"] = itemDetails["ImagePath"].ToString(); } searchDiv.Visible = true; btn_refresh.Visible = true; } gv_MerchantOrders.Visible = false; gv_MerchantOrdersSearch.DataSource = merchantOrderDt; gv_MerchantOrdersSearch.DataBind(); hdn_itemId.Value = "0"; } catch (Exception ex) { lbl_search.Text = HardCodedValues.BuddaResource.CatchBlockError + ex.Message; } }
private void retrieveMerchant() { DataTable mdt = (DataTable)this.Session["MId"]; int areaId = Convert.ToInt32(mdt.Rows[0]["AREA_ID"].ToString()); int mId = Convert.ToInt32(mdt.Rows[0]["MId"].ToString()); InterfacesBS.InterfacesBL.IUser getmerchant = new BusinessLogicBS.UserClasses.UserItems(); DataSet merchantDS = getmerchant.getMerchant(mId,areaId); DataTable dt = merchantDS.Tables[0]; if (dt != null) { txt_mName.Text = dt.Rows[0]["MName"].ToString(); txt_mType.Text = dt.Rows[0]["MType"].ToString(); txt_mAddress.Text = dt.Rows[0]["MAddress"].ToString(); txt_mPhno.Text = dt.Rows[0]["MPhNo"].ToString(); string catID = dt.Rows[0]["CatId"].ToString(); DataTable merchantOrderDt = merchantDS.Tables[1]; //merchantOrderDt.DefaultView.Sort = "Date Desc"; if (merchantOrderDt != null) { merchantOrderDt.Columns.Add("ItemName"); merchantOrderDt.Columns.Add("ImagePath"); foreach (DataRow dr in merchantOrderDt.Rows) { int itemId = Convert.ToInt32(dr["ItemId"]); DataSet itemData = new DataSet(); if (System.Web.HttpContext.Current.Cache["CacheItemsObj"] == null) { CLASS.CallCache getcache = new budhashop.CLASS.CallCache(); itemData = getcache.getCache(); } else { itemData = (DataSet)System.Web.HttpContext.Current.Cache["CacheItemsObj"]; } var itemDetails = itemData.Tables[0].AsEnumerable().First(p => p.Field<long>("ItemId") == itemId); dr["ItemName"] = itemDetails["ItemName"].ToString(); dr["ImagePath"] = itemDetails["ImagePath"].ToString(); } } gv_MerchantOrders.DataSource = merchantOrderDt; gv_MerchantOrders.DataBind(); DataTable merchantOrderDtArea = merchantDS.Tables[2]; //DataTable ordersAreDt; //ordersAreDt.Columns.Add("ItemId"); //ordersAreDt.Columns.Add("Qty"); //ordersAreDt.Columns.Add("Date"); //ordersAreDt.Columns.Add("ItemName"); //ordersAreDt.Columns.Add("ImagePath"); //merchantOrderDt.DefaultView.Sort = "Date Desc"; if (merchantOrderDtArea != null) { merchantOrderDtArea.Columns.Add("ItemName"); merchantOrderDtArea.Columns.Add("ImagePath"); foreach (DataRow dr in merchantOrderDtArea.Rows) { int itemId = Convert.ToInt32(dr["ItemId"]); DataSet itemData = new DataSet(); if (System.Web.HttpContext.Current.Cache["CacheItemsObj"] == null) { CLASS.CallCache getcache = new budhashop.CLASS.CallCache(); itemData = getcache.getCache(); } else { itemData = (DataSet)System.Web.HttpContext.Current.Cache["CacheItemsObj"]; } var itemDetails = itemData.Tables[0].AsEnumerable().First(p => p.Field<long>("ItemId") == itemId); if (catID == itemDetails["CategoryId"].ToString()) { dr["ItemName"] = itemDetails["ItemName"].ToString(); dr["ImagePath"] = itemDetails["ImagePath"].ToString(); } else { dr.Delete(); } } } GridViewOrderArea.DataSource = merchantOrderDtArea; GridViewOrderArea.DataBind(); } else { Response.Redirect("../Merchant/login.aspx"); } }