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