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); }