public JsonResult AddSubProductTable(string tableName, int picId, int? subCatId)
{
int id = DataProvider.AddSubProductTable(subCatId, picId, tableName);
ProductTable table = new ProductTable()
{
Id = id,
PictureId = picId,
Title = tableName,
PictureName = Session["PicTitle"].ToString()
};
string html = this.RenderPartialToString("Partials/_ProductTableRow", table);
return Json(new { html = html });
}
public static List<ProductTable> GetProductTables(int picId, string term = null)
{
List<ProductTable> tables = new List<ProductTable>();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[CONNECTION_STRING].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("GetProductTables", conn))
{
cmd.Parameters.Add(new SqlParameter("@PicId", picId));
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())
{
ProductTable p = new ProductTable();
p.Id = reader.GetInt32(0);
p.Title = reader.IsDBNull(1) ? string.Empty : reader.GetString(1);
p.PictureId = reader.IsDBNull(2) ? 0 : reader.GetInt32(2);
p.PictureName = reader.IsDBNull(3) ? string.Empty : reader.GetString(3);
p.SubCategoryId = reader.IsDBNull(4) ? 0 : reader.GetInt32(4);
p.SubCategoryName = 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);
tables.Add(p);
}
}
conn.Close();
}
}
return tables;
}
