public UserCartCommon GroceriesData(string ProductReferenceId, string User)
{
var data = new UserCartCommon();
var sql = "Exec Proc_UserCart ";
sql += " @flag= " + dao.FilterString("GroceriesInfo");
sql += " ,@ProductReferenceId =" + dao.FilterString(ProductReferenceId);
sql += " ,@User ="******"CartId"].ToString();
data.ProductReferenceId = item["ProductReferenceId"].ToString();
data.ProductDistinctId = item["ProductDistinctId"].ToString();
data.CreatedBy = item["CreatedBy"].ToString();
//data.DocName = item["DocName"].ToString();
//data.ProductColor = item["ProductColor"].ToString();
data.ProductName = item["ProductName"].ToString();
data.ProductPrice = item["ProductPrice"].ToString();
data.ProductQuantity = item["ProductQuantity"].ToString();
//data.ProductSize = item["ProductSize"].ToString();
data.ProductStatus = item["ProductStatus"].ToString();
data.DocName = item["DocName"].ToString();
}
}
return(data);
}
public ActionResult ComputerCart(UserCartCommon Common)
{
Common.User = StaticData.GetUser();
Common.ProductLink = "/ProductDetail/ComputerDetail?ProductReferenceId=" + Common.ProductReferenceId;
var response = buss.manage(Common);
if (response.ErrorCode == 0)
{
DbResponse resp = new DbResponse();
resp.ErrorCode = response.ErrorCode;
resp.Message = response.Message;
StaticData.SetMessageInSession(resp);
}
return(RedirectToAction("Index", "Home"));
}
public DbResponse manage(UserCartCommon common)
{
var sql = "Exec Proc_UserCart @flag= 'I' ";
sql += ", @ProductReferenceId=" + dao.FilterString(common.ProductReferenceId == null ? "" : common.ProductReferenceId);
sql += ", @ProductDistinctId=" + dao.FilterString(common.ProductDistinctId == null ? "" : common.ProductDistinctId);
sql += ", @CartId=" + dao.FilterString(common.CartId == null ? "" : common.CartId);
sql += ", @ProductName=" + dao.FilterString(common.ProductName == null ? "" : common.ProductName);
sql += ", @ProductStatus=" + dao.FilterString(common.ProductStatus == null ? "" : common.ProductStatus);
sql += ", @ProductQuantity=" + dao.FilterString(common.ProductQuantity == null ? "" : common.ProductQuantity);
sql += ", @ProductSize=" + dao.FilterString(common.ProductSize == null ? "" : common.ProductSize);
sql += ", @ProductColor=" + dao.FilterString(common.ProductColor == null ? "" : common.ProductColor);
sql += ", @ProductPrice=" + dao.FilterString(common.ProductPrice == null ? "" : common.ProductPrice);
sql += ", @ProductCartStatus=" + dao.FilterString(common.ProductCartStatus == null ? "" : common.ProductCartStatus);
sql += ", @ProductLink=" + dao.FilterString(common.ProductLink == null ? "" : common.ProductLink);
sql += ", @User="******"" : common.User);
var response = dao.ParseDbResponse(sql);
return(response);
}
public List <UserCartCommon> showAll(string User)
{
var list = new List <UserCartCommon>();
var sql = "Exec Proc_UserCart ";
sql += " @flag= " + dao.FilterString("showAll");
sql += " ,@User ="******"RowId"]),
ProductReferenceId = item["ProductReferenceId"].ToString(),
ProductDistinctId = item["ProductDistinctId"].ToString(),
ProductName = item["ProductName"].ToString(),
ProductStatus = item["ProductStatus"].ToString(),
ProductQuantity = item["ProductQuantity"].ToString(),
ProductSize = item["ProductSize"].ToString(),
ProductColor = item["ProductColor"].ToString(),
ProductPrice = item["ProductPrice"].ToString(),
ProductCartStatus = item["ProductCartStatus"].ToString(),
ProductLink = item["ProductLink"].ToString(),
CreatedBy = item["CreatedBy"].ToString(),
CreatedDate = item["CreatedDate"].ToString()
};
sn++;
list.Add(common);
}
}
return(list);
}
public DbResponse manage(UserCartCommon common)
{
return(repo.manage(common));
}
