public API_COMPONENT_TYPE getData1() { API_COMPONENT_TYPE api = new API_COMPONENT_TYPE(); api.APIComponentTypeName = cbAPIComponentType.Text; return(api); }
public void edit(API_COMPONENT_TYPE obj) { DAL.edit(obj.APIComponentTypeID, obj.APIComponentTypeName, obj.GFFSmall, obj.GFFMedium, obj.GFFLarge, obj.GFFRupture, obj.GFFTotal, obj.HoleCostSmall, obj.HoleCostMedium, obj.HoleCostLarge, obj.HoleCostRupture, obj.OutageSmall, obj.OutageMedium, obj.OutageLarge, obj.OutageRupture); }
public List <API_COMPONENT_TYPE> getDataSource() { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); List <API_COMPONENT_TYPE> list = new List <API_COMPONENT_TYPE>(); API_COMPONENT_TYPE obj = null; String sql = " Use [rbi] Select [APIComponentTypeID]" + ",[APIComponentTypeName]" + ",[GFFSmall]" + ",[GFFMedium]" + ",[GFFLarge]" + ",[GFFRupture]" + ",[GFFTotal]" + ",[HoleCostSmall]" + ",[HoleCostMedium]" + ",[HoleCostLarge]" + ",[HoleCostRupture]" + ",[OutageSmall]" + ",[OutageMedium]" + ",[OutageLarge]" + ",[OutageRupture]" + "From [dbo].[API_COMPONENT_TYPE]"; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.HasRows) { obj = new API_COMPONENT_TYPE(); obj.APIComponentTypeID = reader.GetInt32(0); obj.APIComponentTypeName = reader.GetString(1); obj.GFFSmall = (float)reader.GetDouble(2); obj.GFFMedium = (float)reader.GetDouble(3); obj.GFFLarge = (float)reader.GetDouble(4); obj.GFFRupture = (float)reader.GetDouble(5); obj.GFFTotal = (float)reader.GetDouble(6); obj.HoleCostSmall = (float)reader.GetDouble(7); obj.HoleCostMedium = (float)reader.GetDouble(8); obj.HoleCostLarge = (float)reader.GetDouble(9); obj.HoleCostRupture = (float)reader.GetDouble(10); obj.OutageSmall = (float)reader.GetDouble(11); obj.OutageMedium = (float)reader.GetDouble(12); obj.OutageLarge = (float)reader.GetDouble(13); obj.OutageRupture = (float)reader.GetDouble(14); list.Add(obj); } } } } catch (Exception e) { MessageBox.Show(e.ToString(), "GET DATA FAIL!"); } finally { conn.Close(); } return(list); }
public void delete(API_COMPONENT_TYPE obj) { DAL.delete(obj.APIComponentTypeID); }