public IEnumerable <OptionRisk> GetOptionRisks(int p)
{
List <OptionRisk> data = new List <OptionRisk>();
using (OracleConnection cn = new OracleConnection(ConfigurationManager.ConnectionStrings["OracleDatabase"].ConnectionString))
{
cn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = cn;
cmd.InitialLONGFetchSize = 1000;
cmd.CommandText = String.Format("select * from dm_option_risks t WHERE optionId = '{0}'", p);
cmd.CommandType = CommandType.Text;
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var option = new OptionRisk();
option.ID = Convert.ToInt32(reader["ID"]);
option.Description = Convert.ToString(reader["Description"]);
option.OptionID = Convert.ToInt32(reader["OptionId"]);
option.Status = Convert.ToString(reader["Status"]);
// newElement.MANDATORY = Convert.ToString(reader["MANDATORY"]);
// newElement.WEIGHT = Convert.ToString(reader["WEIGHT"]);
// newElement.expresion = Convert.ToString(reader["expresion"]);
// newElement.expresionfeild = Convert.ToString(reader["expresionfeild"]);
// newElement.expresion = "";//should be new implementation
// newElement.expresionfeild = ""; //should be new implementation
data.Add(option);
}
cn.Close();
}
return(data);
}
public void SaveRiskToOption(OptionRisk risk)
{
using (OracleConnection cn = new OracleConnection(ConfigurationManager.ConnectionStrings["OracleDatabase"].ConnectionString))
{
int result;
OracleDataAdapter da = new OracleDataAdapter();
OracleCommand cmd = new OracleCommand();
cmd.Connection = cn;
cmd.InitialLONGFetchSize = 1000;
cmd.CommandType = CommandType.Text;
cmd.CommandText = String.Format("INSERT INTO dm_option_risks (Description,OptionID) VALUES ('{0}','{1}')", risk.Description, risk.OptionID);
cmd.Connection.Open();
try
{
result = cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw new Exception("##Error save to DB## : " + cmd.CommandText);
}
cmd.Connection.Close();
}
}
private void SaveRiskToOption(OptionRisk risk)
{
decisionMakingDataAccess.SaveRiskToOption(risk);
}
