public IActionResult Settings()
{
DataLayer dl = new DataLayer();
DataTable st = dl.getAllSettings();
SettingsListModel SettingsListModel = new SettingsListModel();
List <SettingsModel> listOfSettingsModels = new List <SettingsModel>();
DataTable dt = dl.getAllSettings();
for (int i = 0; i < dt.Rows.Count; i++)
{
SettingsModel SettingsModel = new SettingsModel();
SettingsModel.settingID = int.Parse(dt.Rows[i]["settingID"].ToString());
SettingsModel.settingText = dt.Rows[i]["settingText"].ToString();
if (dt.Rows[i]["settingActive"].ToString() == "N")
{
SettingsModel.settingsSelected = false;
}
else
{
SettingsModel.settingsSelected = true;
}
listOfSettingsModels.Add(SettingsModel);
SettingsListModel.listOfSettings = listOfSettingsModels;
}
return(View("Settings", SettingsListModel));
}
public void SaveSettings(SettingsListModel settingsListModel)
{
string connetionString = null;
SqlConnection cnn;
connetionString = "Data Source=DESKTOP-9A0CTF1\\SQLEXPRESS;Initial Catalog=PrototypeDB;Integrated Security=SSPI;";
cnn = new SqlConnection(connetionString);
try
{
cnn.Open();
for (int i = 0; i < settingsListModel.listOfSettings.Count(); i++)
{
using (var command = new SqlCommand("UPDATE Settings SET settingActive = @settingActive WHERE settingID = @settingID", cnn))
{
command.Parameters.AddWithValue("@settingID", settingsListModel.listOfSettings.ElementAt(i).settingID);
if (settingsListModel.listOfSettings.ElementAt(i).settingsSelected)
{
command.Parameters.AddWithValue("@settingActive", "Y");
}
else
{
command.Parameters.AddWithValue("@settingActive", "N");
}
command.ExecuteNonQuery();
}
}
cnn.Close();
}
catch (Exception ex)
{
//MessageBox.Show("Can not open connection ! ");
}
}
public IActionResult SaveSettings(SettingsListModel SettingsModel)
{
DataLayer dl = new DataLayer();
dl.SaveSettings(SettingsModel);
SettingsModel.errorFree = "no error";
return(View("Settings", SettingsModel));
}
public ActionResult List(SettingsListModel model)
{
if (model == null)
{
model = new SettingsListModel();
}
if (Request.IsAjaxRequest())
{
IList <SettingValue> values = _settingService.SelectSettingValues(model.Ordering, model.SettingDefId.Value).
Where(value => value.IsHiddenFromUser == false).ToList();
SettingDefinition settingDef = _settingService.GetSettingDefinitionById(model.SettingDefId.Value);
foreach (SettingValue settingVal in values)
{
for (int i = 1; i <= 15; i++)
{
FormInputType type = (FormInputType)typeof(SettingDefinition).GetProperty("FieldInputType" + i.ToString()).GetValue(settingDef, null);
if (type == FormInputType.Password)
{
typeof(SettingValue).GetProperty("Field" + i.ToString()).SetValue(settingVal, "******");
}
}
}
return(DataTableResult(values as IList));
}
else
{
IEnumerable <SettingDefinition> settingDefList = _settingService.SelectAllSettingDefinitions();
//Some settings has their own maangement page
model.SettingDefinitionSelectList = settingDefList
.Where(p => p.Name != AvailableSettings.EMailSetting &&
p.Name != AvailableSettings.HTMLTemplate &&
p.Name != AvailableSettings.MembershipSetting &&
p.Name != AvailableSettings.AppSetting)
.Select(p => new SelectListItem
{
Value = p.Id.ToString(),
Text = p.Name + " (" + p.Description + ")"
}).ToList();
model.SettingDefinitions = settingDefList;
return(View(model));
}
}
public ActionResult ListTemplates(SettingsListModel model)
{
if (model == null)
{
return(View(new SettingsListModel()));
}
if (Request.IsAjaxRequest())
{
SettingDefinition settingDef = _settingService.GetSettingDefinitionByName("HTMLTemplate");
List <HTMLTemplateModel> modelList = new List <HTMLTemplateModel>();
foreach (SettingValue settingVal in _settingService.SelectSettingValues(model.Ordering, settingDef.Id))
{
modelList.Add((HTMLTemplateModel)settingVal);
}
return(DataTableResult(modelList));
}
return(View(model));
}
public ActionResult ListEMailSettings(SettingsListModel model)
{
if (model == null)
{
return(View(new SettingsListModel()));
}
if (Request.IsAjaxRequest())
{
SettingDefinition settingDef = _settingService.GetSettingDefinitionByName("EMailSetting");
List <EMailSettingModel> modelList = new List <EMailSettingModel>();
foreach (SettingValue settingVal in _settingService.SelectSettingValues(model.Ordering, settingDef.Id))
{
EMailSettingModel modelItem = (EMailSettingModel)settingVal;
modelItem.UserName = RegexHelper.MaskEmailAddress(modelItem.UserName);
modelItem.Password = RegexHelper.Mask(modelItem.Password);
modelList.Add(modelItem);
}
return(DataTableResult(modelList));
}
return(View(model));
}
