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