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