public JsonResult AddSubProductProperty(string propName, int subCatId) { int propId = DataProvider.AddSubProductProperty(subCatId, propName); SubProductProperty prop = new SubProductProperty() { Id = propId, Name = propName }; string html = this.RenderPartialToString("Partials/_SubProductPropRow", prop); return Json(new { html = html }); }
public static List<SubProductProperty> GetSubProductProperties(int subCatId) { List<SubProductProperty> props = new List<SubProductProperty>(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[CONNECTION_STRING].ConnectionString)) { using (SqlCommand cmd = new SqlCommand("GetProductProperties", conn)) { cmd.Parameters.Add(new SqlParameter("@SubProductId", subCatId)); cmd.CommandType = CommandType.StoredProcedure; conn.Open(); using (IDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { SubProductProperty p = new SubProductProperty(); p.Id = reader.GetInt32(1); p.Name = reader.GetString(0); props.Add(p); } } conn.Close(); } } return props; }