public JsonResult AddPictureProduct(string title, string bigImg, string smallImg, int subCatId, string subCatName, int mainCatId, string mainCatName)
{
int orderId;
int id = DataProvider.AddProductPicture(title, smallImg, bigImg, subCatId, subCatName, mainCatId, mainCatName, out orderId);
PictureProduct p = new PictureProduct()
{
Id = id,
ImageName = bigImg,
IsActive = true,
MainCategoryId = mainCatId,
MainCategoryName = mainCatName,
OrderId = orderId,
SmallImageName = smallImg,
SubCategoryId = subCatId,
SubCategoryName = subCatName,
Title = title
};
string html = this.RenderPartialToString("Partials/_ProductPicRow", p);
return Json(new { success = true, html = html });
}
public static List<PictureProduct> GetPictureProducts(int? category = null, string term = null)
{
List<PictureProduct> products = new List<PictureProduct>();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[CONNECTION_STRING].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("GetProductsFromManagement", conn))
{
if (category.HasValue && category.Value > 0)
cmd.Parameters.Add(new SqlParameter("@Cat", category.Value));
if (!string.IsNullOrWhiteSpace(term))
cmd.Parameters.Add(new SqlParameter("@Term", term));
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
using (IDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
PictureProduct p = new PictureProduct();
p.Id = reader.GetInt32(0);
p.ImageName = reader.IsDBNull(1) ? string.Empty : reader.GetString(1);
p.SubCategoryId = reader.GetInt32(2);
p.Title = reader.IsDBNull(3) ? string.Empty : reader.GetString(3);
p.SubCategoryName = reader.IsDBNull(4) ? string.Empty : reader.GetString(4);
p.SmallImageName = reader.IsDBNull(5) ? string.Empty : reader.GetString(5);
p.MainCategoryId = reader.IsDBNull(6) ? 0 : reader.GetInt32(6);
p.MainCategoryName = reader.IsDBNull(7) ? string.Empty : reader.GetString(7);
p.OrderId = reader.IsDBNull(8) ? 0 : reader.GetInt32(8);
p.IsActive = reader.GetBoolean(9);
products.Add(p);
}
}
conn.Close();
}
}
return products;
}