private ListModel GetListModel(string listName, string laboratoryBookName)
{
var connectionString = ConfigurationManager.ConnectionStrings["cs_login"].ConnectionString;
var connection = new MySqlConnection(connectionString);
var sqlCommand = new MySqlCommand()
{
Connection = connection,
CommandText = $"SELECT `{listName}` FROM `{listName}s_{laboratoryBookName}`;"
};
connection.Open();
var dbReader = sqlCommand.ExecuteReader();
var dataTable = new DataTable();
dataTable.Load(dbReader);
var listModel = new ListModel();
foreach (DataRow row in dataTable.Rows)
{
var value = new ListValueModel()
{
ListValue = (string)row[$"{listName}"],
OldListValue = (string)row[$"{listName}"]
};
listModel.Values.Add(value);
}
listModel.ListName = listName;
if (listModel.Values.Any())
{
listModel.SelectedValue = listModel.Values.First();
}
connection.Close();
sqlCommand?.Dispose();
return(listModel);
}
public ListModel()
{
this.Values = new ObservableCollection <ListValueModel>();
this.ListName = String.Empty;
this.SelectedValue = new ListValueModel();
}