public List <RW_RISK_TARGET> getDataSource()
{
List <RW_RISK_TARGET> list = new List <RW_RISK_TARGET>();
RW_RISK_TARGET obj = null;
SqlConnection conn = MSSQLDBUtils.GetDBConnection();
conn.Open();
String sql = "USE [rbi] " +
"SELECT [ID]" +
",[RiskTarget_A]" +
",[RiskTarget_B]" +
",[RiskTarget_C]" +
",[RiskTarget_D]" +
",[RiskTarget_E]" +
",[RiskTarget_CA]" +
",[RiskTarget_FC]" +
" FROM [rbi].[dbo].[RW_RISK_TARGET] ";
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_RISK_TARGET();
obj.ID = reader.GetInt32(0);
obj.RiskTarget_A = reader.GetFloat(1);
obj.RiskTarget_B = reader.GetFloat(2);
obj.RiskTarget_C = reader.GetFloat(3);
obj.RiskTarget_D = reader.GetFloat(4);
obj.RiskTarget_E = reader.GetFloat(5);
obj.RiskTarget_CA = reader.GetFloat(6);
obj.RiskTarget_FC = reader.GetFloat(7);
list.Add(obj);
}
}
}
}
catch
{
}
finally
{
conn.Close();
conn.Dispose();
}
return(list);
}
public void delete(RW_RISK_TARGET obj)
{
DAL.delete(obj.ID);
}
public void edit(RW_RISK_TARGET obj)
{
DAL.edit(obj.ID, obj.RiskTarget_A, obj.RiskTarget_B, obj.RiskTarget_C, obj.RiskTarget_E, obj.RiskTarget_D, obj.RiskTarget_CA, obj.RiskTarget_FC);
}
