public void SubmitNewDecision(DecisionDocument decisionDocument)
{
var decisionDocumentID = decisionMakingDataAccess.SubmitNewDecision(decisionDocument);
decisionDocument.ID = decisionDocumentID;
foreach (var option in decisionDocument.DecisionOptions)
{
option.DecisionID = decisionDocument.ID;
var newOptionID = SaveOptionsToDecision(option);
option.ID = newOptionID;
foreach (var advantage in option.OptionAdvantages)
{
advantage.OptionID = option.ID;
SaveAdvantageToOption(advantage);
}
foreach (var risk in option.OptionRisks)
{
risk.OptionID = option.ID;
SaveRiskToOption(risk);
}
}
foreach (var nextStep in decisionDocument.NextSteps)
{
nextStep.DecisionID = decisionDocumentID;
AddNextStepToDecision(nextStep);
}
}
public IEnumerable <string> GetUserDetails()
{
List <string> displaynames = new List <string>();
using (OracleConnection cn = new OracleConnection(ConfigurationManager.ConnectionStrings["OracleDatabase"].ConnectionString))
{
cn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = cn;
cmd.InitialLONGFetchSize = 1000;
cmd.CommandText = "select Distinct t.displayname from users_details_new t";
cmd.CommandType = CommandType.Text;
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var newElement = new DecisionDocument();
string displayname = Convert.ToString(reader["displayname"]);
displaynames.Add(displayname);
}
cn.Close();
}
return(displaynames);
}
public JsonResult SubmitNewDecision(SubmitNewDecisionPostModel PostModel)
{
var decisionDocument = new DecisionDocument();
decisionDocument = PostModel.DecisionDocument;
decisionMakingBLL.SubmitNewDecision(decisionDocument);
Object result = new { Message = "OK" };
var jsonResult = Json(result, JsonRequestBehavior.AllowGet);
return(jsonResult);
}
public List <DecisionDocument> GetDecisionDocumentsList()
{
List <DecisionDocument> data = new List <DecisionDocument>();
using (OracleConnection cn = new OracleConnection(ConfigurationManager.ConnectionStrings["OracleDatabase"].ConnectionString))
{
cn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = cn;
cmd.InitialLONGFetchSize = 1000;
cmd.CommandText = "select * from dm_decision_document t";
cmd.CommandType = CommandType.Text;
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var newElement = new DecisionDocument();
newElement.ID = Convert.ToInt32(reader["id"]);
newElement.openeddate = Convert.ToString(reader["openeddate"]);
newElement.Department = Convert.ToString(reader["department"]);
newElement.Subject = Convert.ToString(reader["subject"]);
newElement.Requireddecision = Convert.ToString(reader["requireddecision"]);
newElement.Currentstatedesc = Convert.ToString(reader["currentstatedesc"]);
newElement.Recandreason = Convert.ToString(reader["recandreason"]);
newElement.Decision = Convert.ToString(reader["decision"]);
newElement.Comments = Convert.ToString(reader["comments"]);
newElement.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(newElement);
}
cn.Close();
}
return(data);
}
public int SubmitNewDecision(DecisionDocument decisionDocument)
{
DateTime openeddate;
CultureInfo provider = new CultureInfo("he-IL");
try
{
openeddate = decisionDocument.openeddate != null?DateTime.ParseExact(decisionDocument.openeddate, "dd/MM/yyyy", provider) : DateTime.MinValue;
}
catch (Exception e)
{
throw new Exception("##Error to convert dates ##: " + e.Message);
}
int newDecisionID;
using (OracleConnection cn = new OracleConnection(ConfigurationManager.ConnectionStrings["OracleDatabase"].ConnectionString))
{
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_decision_document ( openeddate, department, subject, requireddecision, currentstatedesc, recandreason, decision, comments)"
+ " VALUES (TO_DATE('{0}','dd/mm/yyyy HH24:MI:SS') ,'{1}','{2}','{3}','{4}','{5}','{6}','{7}') returning id into :myOutputParameter",
decisionDocument.openeddate,
decisionDocument.Department,
decisionDocument.Subject,
decisionDocument.Requireddecision,
decisionDocument.Currentstatedesc,
decisionDocument.Recandreason,
decisionDocument.Decision,
decisionDocument.Comments);
cmd.Connection.Open();
cmd.Parameters.Add("myOutputParameter", OracleDbType.Decimal, ParameterDirection.ReturnValue);
try
{
cmd.ExecuteNonQuery();
var result = ((OracleDecimal)cmd.Parameters["myOutputParameter"].Value);
newDecisionID = Convert.ToInt32(result.Value);
}
catch (Exception)
{
throw new Exception("##Error save to DB## : " + cmd.CommandText);
}
cmd.Connection.Close();
return(newDecisionID);
}
return(-1);
}
public DecisionDocument GetDecisionDocument(int documentDecisionID)
{
DecisionDocument result = new DecisionDocument();
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_decision_document t WHERE id = '{0}'", documentDecisionID);
cmd.CommandType = CommandType.Text;
var reader = cmd.ExecuteReader();
if (reader.Read())
{
result.ID = Convert.ToInt32(reader["id"]);
result.openeddate = Convert.ToString(reader["openeddate"]);
result.Department = Convert.ToString(reader["department"]);
result.Subject = Convert.ToString(reader["subject"]);
result.Requireddecision = Convert.ToString(reader["requireddecision"]);
result.Currentstatedesc = Convert.ToString(reader["currentstatedesc"]);
result.Recandreason = Convert.ToString(reader["recandreason"]);
result.Decision = Convert.ToString(reader["decision"]);
result.Comments = Convert.ToString(reader["comments"]);
result.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
}
else
{
throw new Exception("No result");
}
cn.Close();
}
return(result);
}
public DecisionDocument GetDecisionDocument(int documentDecisionID)
{
DecisionDocument result = decisionMakingDataAccess.GetDecisionDocument(documentDecisionID);
result.DecisionOptions = decisionMakingDataAccess.GetDesicionOptions(documentDecisionID);
result.NextSteps = decisionMakingDataAccess.GetNextSteps(documentDecisionID);
foreach (var option in result.DecisionOptions)
{
option.OptionAdvantages = decisionMakingDataAccess.GetOptionAdvantages(option.ID);
option.OptionRisks = decisionMakingDataAccess.GetOptionRisks(option.ID);
}
return(result);
}
