public JsonResult UpdateDropDown(UpdateDropDownModel model, FormCollection form)
{
DataTable @default = Helper.getData(string.Format("select top 1 COLUMN_NAME,DATA_TYPE from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='{0}' and DATA_TYPE='nvarchar'", model.Table), db);
if (@default.Rows.Count == 0)
{
@default = Helper.getData(string.Format("select COLUMN_NAME,DATA_TYPE from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='{0}' and COLUMN_NAME='name'", model.Table), db);
}
string orderRichBy = "";
if (@default.Rows.Count > 0)
{
orderRichBy = " order by " + @default.Rows[0][0].ToString();
}
DataTable data = Helper.getData(string.Format("SELECT {0} as value, {1} as text {4} from {2} {3} {6} {5}", model.Value, model.Text, model.Table, model.Where
,
!string.IsNullOrEmpty(model.Groupby) ? " ," + model.Groupby + " as groupby " : "",
!string.IsNullOrEmpty(model.Groupby) ? " order by " + model.Groupby : "",
string.IsNullOrEmpty(model.Groupby) ? orderRichBy : ""), db);
List <DropDownListJson> json = new List <DropDownListJson>();
if (!string.IsNullOrEmpty(model.OptionLabel))
{
json.Add(new DropDownListJson()
{
Value = "0", Text = (model.OptionLabel)
});
}
foreach (DataRow item in data.Rows)
{
bool selected = false;
if (model.Selected != null)
{
selected = model.Selected.Contains(item["value"].ToString());
}
if (!string.IsNullOrEmpty(model.Groupby))
{
json.Add(new DropDownListJson()
{
Value = item["value"].ToString(), Text = item["text"].ToString(), Group = item["groupby"].ToString(), Selected = selected
});
}
else
{
json.Add(new DropDownListJson()
{
Value = item["value"].ToString(), Text = item["text"].ToString(), Selected = selected
});
}
}
return(Json(json, JsonRequestBehavior.AllowGet));
}
public string UpdateRadioButton(UpdateDropDownModel model, FormCollection form)
{
DataTable data = Helper.getData(string.Format("SELECT {0} as value, {1} as text from {2} {3}", model.Value, model.Text, model.Table, model.Where), db);
int col = 12 / (model.Col > 4 ? 4 : model.Col);
StringBuilder html = new StringBuilder();
int index = 1;
bool wasClose = true;
foreach (DataRow item in data.Rows)
{
if (index == 1 && wasClose)
{
html.AppendFormat(" <div class=\"col col-{0}\">", col);
wasClose = false;
}
bool toggle = (!string.IsNullOrEmpty(model.ToggleOff) && !string.IsNullOrEmpty(model.ToggleON));
html.AppendFormat("<label class=\"{0}\">", toggle ? "toggle" : model.Type);
bool selected = model.Selected.Contains(item["value"].ToString());
html.AppendFormat("<input type=\"{3}\" {0} name=\"{1}\" value=\"{2}\" >", selected ? "checked=\"checked\"" : "", model.Name, item["value"].ToString(), model.Type);
if (!string.IsNullOrEmpty(model.ToggleOff) && !string.IsNullOrEmpty(model.ToggleON))
{
html.AppendFormat("<i data-swchoff-text=\"{0}\" data-swchon-text=\"{1}\"></i>", (model.ToggleOff), (model.ToggleON));
}
else
{
html.AppendFormat("<i></i>");
}
html.AppendFormat("{0}</label>", item["text"]);
if (index % model.Row == 0)
{
html.AppendFormat("</div>");
wasClose = true;
}
}
return(html.ToString());
}
