protected void btn_mLogin_Click(object sender, EventArgs e) { string id = txt_mId.Text; string pwd = CLASS.PasswordEncryption.EncryptIt(txt_mPwd.Text); try { InterfacesBS.InterfacesBL.IUser checkmerchant = new BusinessLogicBS.UserClasses.UserItems(); DataTable mdt = checkmerchant.checkMerchant(id, pwd); if (mdt != null) { this.Session["MId"] = mdt; Response.Redirect("../Merchant/profilepage.aspx"); } else { lbl_mStatus.Text = HardCodedValues.BuddaResource.LoginFail; } } catch (Exception ex) { lbl_mStatus.Text = HardCodedValues.BuddaResource.CatchBlockError + ex.Message; throw ex; } }
protected void itemGrid_RowUpdating(object sender, GridViewUpdateEventArgs e) { int itemid = Convert.ToInt32(itemGrid.DataKeys[e.RowIndex].Value.ToString()); float itemBR = float.Parse(((TextBox)itemGrid.Rows[e.RowIndex].FindControl("txt_editBR")).Text); int itemQty = Int32.Parse(((TextBox)itemGrid.Rows[e.RowIndex].FindControl("txt_editQty")).Text); float itemNR = float.Parse(((TextBox)itemGrid.Rows[e.RowIndex].FindControl("txt_editNR")).Text); try { InterfacesBS.InterfacesBL.IUser updateItems = new BusinessLogicBS.UserClasses.UserItems(); bool isupdated = updateItems.updateMerchantItems(itemid, itemBR, itemQty, itemNR); if (isupdated == true) { lbl_itemSts.Text = HardCodedValues.BuddaResource.UpdateSuccess; ClearCache(); itemGrid.EditIndex = -1; getMerchantItems(); BindLowItems(); } else { lbl_itemSts.Text = HardCodedValues.BuddaResource.UpdateFail; } } catch (Exception ex) { lbl_itemSts.Text = HardCodedValues.BuddaResource.CatchBlockError + ex.Message; throw ex; } }
protected void getOrders() { DataTable dt = (DataTable)this.Session["currentuser"]; string userid = dt.Rows[0]["Uid"].ToString(); try { BusinessLogicBS.UserClasses.UserItems getOrders = new BusinessLogicBS.UserClasses.UserItems(); DataTable orderDT = getOrders.getUserOrders(userid); if (orderDT != null) { orderGrid.DataSource = orderDT; orderGrid.DataBind(); } else { //grpMsgLbl.Text = "No Data for items! change the catagory"; orderGrid.DataSource = null; orderGrid.DataBind(); } } catch (Exception iExp) { throw iExp; } }
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 getOrders() { try { BusinessLogicBS.UserClasses.UserItems getOrders = new BusinessLogicBS.UserClasses.UserItems(); DataTable orderDT = getOrders.getOrders(); if (orderDT != null) { orderGrid.DataSource = orderDT; orderGrid.DataBind(); } else { //grpMsgLbl.Text = "No Data for items! change the catagory"; orderGrid.DataSource = null; orderGrid.DataBind(); } } catch (Exception iExp) { throw iExp; } }
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 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"); } }