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