//public DataTable CartProducts()
//{
// BLL.BLL balobj = new BLL.BLL();
// DataSet ds = new DataSet();
// Cart cart = new Cart();
// DataTable dt = cart.itemTable();
// DataTable dtt = cart.ViewCartTable();
// DataTable dtt1 = cart.ViewCartTable();
// ds = balobj.Get_Products("");
// dt = HttpContext.Current.Session["Cart"] as DataTable;
// for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
// {
// dtt.Rows.Add(ds.Tables[0].Rows[i]["ProductID"].ToString(),
// ds.Tables[0].Rows[i]["Productname"].ToString(),
// GlobalVarables.Image_Url() + ds.Tables[0].Rows[i]["Product_ImgUrl"].ToString(),
// "0",
// ds.Tables[0].Rows[i]["DistributorPrice"].ToString(),
// ds.Tables[0].Rows[i]["DistributorPrice"].ToString());
// }
// if (dt != null & dtt != null)
// {
// if (dt.Rows.Count > 0 & dtt.Rows.Count > 0)
// {
// var result = from dataRows1 in dtt.AsEnumerable()
// join dataRows2 in dt.AsEnumerable()
// on dataRows1.Field<string>("ProductID") equals dataRows2.Field<string>("Productid")
// select dtt1.LoadDataRow(new object[]
// {
// dataRows1.Field<string>("ProductID"),
// dataRows1.Field<string>("Productname"),
// dataRows1.Field<string>("Product_ImgUrl"),
// dataRows2.Field<string>("Quantity"),
// dataRows1.Field<string>("Unitmrpprice"),
// (Convert.ToDouble(dataRows2.Field<string>("Quantity")) * Convert.ToDouble(dataRows1.Field<string>("Unitmrpprice"))).ToString(),
// dataRows2.Field<string>("Size"),
// dataRows2.Field<string>("Color")
// }, false);
// return result.CopyToDataTable();
// }
// else
// return dtt1;
// }
// else
// return dtt1;
//}
public DataTable CartProducts()
{
BLL.BLL balobj = new BLL.BLL();
DataSet ds = new DataSet();
Cart cart = new Cart();
DataTable dt = cart.itemTable();
DataTable dtt = cart.ViewCartTable();
DataTable dtt1 = cart.ViewCartTable();
ds = balobj.Get_Products("");
dt = HttpContext.Current.Session["Cart"] as DataTable;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
dtt.Rows.Add(ds.Tables[0].Rows[i]["ProductID"].ToString(),
ds.Tables[0].Rows[i]["Productname"].ToString(),
GlobalVarables.Image_Url() + ds.Tables[0].Rows[i]["Product_ImgUrl"].ToString(),
"0",
ds.Tables[0].Rows[i]["DistributorPrice"].ToString(),
ds.Tables[0].Rows[i]["DistributorPrice"].ToString());
}
if (dt != null & dtt != null)
{
if (dt.Rows.Count > 0 & dtt.Rows.Count > 0)
{
var result = from dataRows1 in dtt.AsEnumerable()
join dataRows2 in dt.AsEnumerable()
on dataRows1.Field <string>("ProductID") equals dataRows2.Field <string>("Productid")
select dtt1.LoadDataRow(new object[]
{
dataRows1.Field <string>("ProductID"),
dataRows1.Field <string>("Productname"),
dataRows1.Field <string>("Product_ImgUrl"),
dataRows2.Field <string>("Quantity"),
dataRows1.Field <string>("Unitmrpprice"),
(Convert.ToDouble(dataRows2.Field <string>("Quantity")) * Convert.ToDouble(dataRows1.Field <string>("Unitmrpprice"))).ToString()
}, false);
return(result.CopyToDataTable());
}
else
{
return(dtt1);
}
}
else
{
return(dtt1);
}
}
public static bool login(System.Web.SessionState.HttpSessionState session, string accno, string pwd)
{
DataSet loginds = new DataSet();
BLL.BLL balobj = new BLL.BLL();
loginds = balobj.Account_Login(accno, pwd);
if (GlobalVarables.chkdataset(loginds))
{
session["member"] = loginds.Tables[0].Rows[0]["AccountNo"].ToString();
return(true);
}
else
{
return(false);
}
}
public DataTable RemoveProd_Cart(string prodID)
{
DataTable dt_cart = new DataTable();
DataTable dt = HttpContext.Current.Session["Cart"] as DataTable;
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["Productid"].ToString() == prodID)
{
dt.Rows[i].Delete();
}
}
HttpContext.Current.Session["Cart"] = dt;
/*
* var result = dt.AsEnumerable().Where(r => r.Field<string>("Productid") == prodID);
* foreach (var row in result.ToList())
* row.Delete();
*/
dt_cart = new GlobalVarables().CartProducts();
return(dt_cart);
}
public DataTable Update_SessionCart(string prodID, string Qty)
{
DataTable dt_cart = new DataTable();
DataTable dt = new DataTable();
dt = HttpContext.Current.Session["Cart"] as DataTable;
foreach (DataRow dr in dt.Rows)
{
if (dr["Productid"].ToString() == prodID)
{
dr["Quantity"] = Qty;
}
}
HttpContext.Current.Session["Cart"] = dt;
/*
* var result = dt.AsEnumerable().Where(r => r.Field<string>("Productid") == prodID);
* foreach (var row in result)
* row.SetField("Quantity", Qty);
*/
dt_cart = new GlobalVarables().CartProducts();
return(dt_cart);
}