public JsonResult FetchMenuStyles()
{
List <DropdownClass> dropdownList = new List <DropdownClass>();
DataTable dt = new DataTable();
try
{
using (MsqlConnection mc = new MsqlConnection())
{
using (SqlCommand cmd = new SqlCommand("GetMenuStyles", mc.msqlConnection))
{
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
mc.open();
cmd.CommandType = CommandType.StoredProcedure;
sda.Fill(dt);
mc.close();
}
}
}
}
catch (Exception ex) { }
for (int i = 0; i < dt.Rows.Count; i++)
{
DropdownClass dropdownClass = new DropdownClass();
dropdownClass.Value = Convert.ToInt32(dt.Rows[i][0]);
dropdownClass.Text = dt.Rows[i][1].ToString();
dropdownList.Add(dropdownClass);
}
return(Json(dropdownList, JsonRequestBehavior.AllowGet));
}
public JsonResult FetchDispItems(int length)
{
List <DropdownClass> dropdownList = new List <DropdownClass>();
for (int i = 1; i <= length; i++)
{
DropdownClass dropdownClass = new DropdownClass();
dropdownClass.Value = i;
dropdownClass.Text = i.ToString();
dropdownList.Add(dropdownClass);
}
return(Json(dropdownList, JsonRequestBehavior.AllowGet));
}
