private void btn_period_Click(object sender, RoutedEventArgs e)
{
wsModelItem mitem = dg_Models.SelectedItem as wsModelItem;
wc.ws_ins_upd_PeriodAsync(mitem.ModelID, mitem.CalibrationPeriod);
}
public List <wsModelItem> selectModels()
{
List <wsModelItem> l = new List <wsModelItem>();
using (SqlConnection conn = new SqlConnection(Configuration.ConnectionString))
{
SqlCommand cmd = new SqlCommand("SELECT * FROM ModelList");
conn.Open();
cmd.Connection = conn;
SqlDataReader Reader = cmd.ExecuteReader();
while (Reader.Read())
{
wsModelItem t = new wsModelItem();
if (!Reader.IsDBNull(Reader.GetOrdinal("Model_ID")))
{
t.ModelID = (int)Reader["Model_ID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Model")))
{
t.ModelName = (string)Reader["Model"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Submodel")))
{
t.SubModelName = (string)Reader["Submodel"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Modification")))
{
t.SubSubModelName = (string)Reader["Modification"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("CalibrationPeriod")))
{
t.CalibrationPeriod = (int)Reader["CalibrationPeriod"];
}
l.Add(t);
}
Reader.Close();
conn.Close();
}
return(l);
}
