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