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