public ActionResult GetDropdownValues(DropdownCategory catId) { Dictionary<string, object> dict = new Dictionary<string, object>(); try { dict["DropdownValues"] = service.GetDropdownValues(catId.Id); dict["success"] = true; } catch { dict["success"] = false; } return Json(dict); }
public DropdownValue() { _id = -1; _category = new DropdownCategory(); }
public void UpdateDropdownCategory(DropdownCategory cat) { using (SqlConnection conn = new SqlConnection(connString)) { string sql = @"UPDATE dbo.Dropdown_Categories SET ShortName = @ShortName, LongName = @LongName WHERE Id = @Id"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add("@Id", SqlDbType.Int).Value = cat.Id; cmd.Parameters.Add("@ShortName", SqlDbType.NVarChar).Value = cat.ShortName; cmd.Parameters.Add("@LongName", SqlDbType.NVarChar).Value = cat.LongName; try { conn.Open(); cmd.ExecuteNonQuery(); } catch (Exception e) { throw e; } finally { conn.Close(); } } }
public void CreateDropdownCategory(DropdownCategory cat) { using (SqlConnection conn = new SqlConnection(connString)) { string sql = @"INSERT INTO dbo.Dropdown_Categories ( ShortName, LongName ) VALUES ( @ShortName, @LongName )"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add("@ShortName", SqlDbType.NVarChar).Value = cat.ShortName; cmd.Parameters.Add("@LongName", SqlDbType.NVarChar).Value = cat.LongName; try { conn.Open(); cmd.ExecuteNonQuery(); } catch (Exception e) { throw e; } finally { conn.Close(); } } }
public void DeleteDropdownCategory(DropdownCategory cat) { using (SqlConnection conn = new SqlConnection(connString)) { string sql = @"DELETE FROM dbo.Dropdown_Categories WHERE Id = @Id"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add("@Id", SqlDbType.Int).Value = cat.Id; try { conn.Open(); cmd.ExecuteNonQuery(); } catch (Exception e) { throw e; } finally { conn.Close(); } } }