public ActionResult ConfigDB(ConfigDBModel data)
{
DataTable dt_dbName = new DataTable();
SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance;
DataTable table = instance.GetDataSources();
string ServerName = Environment.MachineName;
List <SelectListItem> ServerNameList = new List <SelectListItem>();
foreach (DataRow row in table.Rows)
{
ServerNameList.Add(new SelectListItem
{
Text = ServerName + "\\" + row["InstanceName"].ToString(),
Value = ServerName + "\\" + row["InstanceName"].ToString()
});
}
ViewData["ServerNameList"] = ServerNameList;
//if (!ModelState.IsValid)
//{
// return View(data);
//}
try
{
List <SelectListItem> dataBaseName = new List <SelectListItem>();
dt_dbName = dbConfig.GetdataBaseName(data.servernameSelect, data.user, data.password);
if (dt_dbName.Rows.Count > 0)
{
foreach (DataRow row in dt_dbName.Rows)
{
foreach (var item in row.ItemArray)
{
dataBaseName.Add(new SelectListItem
{
Text = item.ToString(),
Value = item.ToString()
});
}
ViewData["dataBaseNameList"] = dataBaseName;
}
if (data.database_name != null)
{
this.dbConfig.SetWebConfig(data.servernameSelect, data.user, data.password, data.database_name);
}
}
return(View(data));
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.Message);
return(View(data));
}
}
public ActionResult ConfigDB()
{
ConfigDBModel model = new ConfigDBModel();
SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance;
DataTable table = instance.GetDataSources();
string ServerName = Environment.MachineName;
List <SelectListItem> ServerNameList = new List <SelectListItem>();
foreach (DataRow row in table.Rows)
{
ServerNameList.Add(new SelectListItem
{
Text = ServerName + "\\" + row["InstanceName"].ToString(),
Value = ServerName + "\\" + row["InstanceName"].ToString()
});
}
// ViewBag.ServerNameList = new SelectList(ServerNameList, "kaizen_type_id", "kaizen_type");
ViewData["ServerNameList"] = ServerNameList;
return(View(model));
}
