public void delete(RW_FULL_COF_INPUT obj) { DAL.delete(obj.ID); }
///get datasource /// public List <RW_FULL_COF_INPUT> getDataSource() { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); List <RW_FULL_COF_INPUT> list = new List <RW_FULL_COF_INPUT>(); RW_FULL_COF_INPUT obj = null; String sql = " Use[rbi] Select[ID]" + ",[Mitigation]" + ",[DetectionType]" + ",[IsolationType]" + ",[mass_comp]" + ",[mass_inv]" + "From [dbo].[RW_FULL_COF_INPUT] "; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.HasRows) { obj = new RW_FULL_COF_INPUT(); obj.ID = reader.GetInt32(0); if (!reader.IsDBNull(1)) { obj.Mitigation = reader.GetString(1); } if (!reader.IsDBNull(2)) { obj.DetectionType = reader.GetString(2); } if (!reader.IsDBNull(3)) { obj.IsolationType = reader.GetString(3); } if (!reader.IsDBNull(4)) { obj.mass_comp = reader.GetFloat(4); } if (!reader.IsDBNull(5)) { obj.mass_inv = reader.GetFloat(5); } list.Add(obj); } } } } catch (Exception e) { MessageBox.Show(e.ToString(), "GET DATA FAIL"); } finally { conn.Close(); } return(list); }
public void edit(RW_FULL_COF_INPUT obj) { DAL.edit(obj.ID, obj.Mitigation, obj.DetectionType, obj.IsolationType, obj.mass_comp, obj.mass_inv); }