private void Calculate_Click(object sender, RoutedEventArgs e)
{
try
{
var repository = GetDataProvider();
var maintable = repository.GetMainTable();
var values = new Dictionary <string, double[]>();
foreach (var item in maintable)
{
var stockValues = repository.Get(item.Symbol, dtFirst.GetSelectedValue(), dtLast.GetSelectedValue());
values.Add(item.Symbol, stockValues.Select(i => (double)i.Price).ToArray());
}
var rc = new RiskCalculation(values, index.Text, tradeVolume.GetDouble(), risk.GetDouble(), commission.GetDouble());
rc.Initialize();
FillDataGrid(rc.RiskParameters);
}
catch (Exception ex)
{
this.Display(ex.Message);
}
}
public static void EditRiskCalculation(int oid, int flag, int section)
{
try
{
RiskCalculation risk = new RiskCalculation();
risk.EditRiskCalculation(oid, section, flag);
}
catch (Exception ex)
{ }
}
public static int InsertRiskCalculation(string RiskName,int aoid, int userid)
{
try
{
//User user=(User)Session["CurrentUser"];
RiskCalculation risk=new RiskCalculation();
risk.AssessmentOID = aoid;//Convert.ToInt32(Session["aid"].ToString());
risk.RiskName = RiskName;
risk.NumFlag = 0;
risk.NumSection = 0;
risk.CreatedBy = userid;//user.UserOID;
risk.AddRiskCalculation();
return risk.RiskOID;
}
catch (Exception ex)
{ }
return 0;
}
public void InitializeTest()
{
var historicalPrices = CsvUtils.ReadAllDataFrom(HISTORICAL_PRICES_PATH, 4, false);
string indexSymbol = "SP500";
Assert.AreEqual(true, historicalPrices.ContainsKey(indexSymbol));
RiskCalculation rc = new RiskCalculation(historicalPrices, indexSymbol, 100000.00, 0.5, 0.15);
rc.Initialize(0);
Assert.AreEqual(21, rc.RiskParameters.Count);
RiskParameters jpm = rc.RiskParameters["JPM"];
Assert.AreEqual(70.8198, jpm.Regression.Beta, 0.0001);
Assert.AreEqual(0.8506, jpm.Regression.R, 0.0001);
Assert.AreEqual(0.0094, jpm.Weight, 0.0001);
}
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
try
{
if((string.IsNullOrEmpty(TextBoxLatestAction.Value)) || (string.IsNullOrEmpty(TextBoxLatestContact.Value)))
{
LabelStatus.Text = "Please Enter Action and Contact Date";
return;
}
int studentid = 0;
bool isNew = false;
int roid = Convert.ToInt32(ViewState["riskOID"].ToString());
RiskCalculation rcal = new RiskCalculation();
Interventions interventions = new Interventions();
interventions = interventions.GetInterventionByRiskOID(roid);
rcal = rcal.GetAssessmentOIDByRiskOID(roid);
if (interventions == null)
{
isNew = true;
interventions = new Interventions();
}
int aoid = rcal.AssessmentOID;
interventions.AssessmentOID = aoid;
int strInterventionOID = interventions.GetInterventionOIDByInterventionName(DropDownListIntervention.SelectedItem.ToString());
interventions.InterventionOID = strInterventionOID;
Domain domain = new Domain();
int DomainIOD = domain.GetDomainOIDByDomainName(DropDownListDomain.SelectedItem.ToString());
interventions.DomainOID = DomainIOD;
User user = new User();
int UserIOD = user.GetUserOIDByUserName(DropDownListAdvocate.SelectedItem.ToString());
//int UserIOD = 1;
interventions.UserOID = UserIOD;
interventions.RiskOID = roid;
//Student student = new Student();
//int StudentOID = student.GetStudentOIDByStudentBannerID(studentid);
interventions.StudentOID = studentid;
interventions.LatestActionDate = TextBoxLatestAction.Value.ToString();
interventions.LatestContact = TextBoxLatestContact.Value.ToString();
interventions.CreatedBy = (Session["CurrentUser"] != null) ? ((User)Session["CurrentUser"]).UserOID : 0;
if (CheckBoxListLeft.Items[0].Selected)
{
interventions.Urgent = 1;
}
else
{
interventions.Urgent = 0;
}
if (CheckBoxListLeft.Items[1].Selected)
{
interventions.Internal = 1;
}
else
{
interventions.Internal = 0;
}
if (CheckBoxListLeft.Items[2].Selected)
{
interventions.Prescribed = 1;
}
else
{
interventions.Prescribed = 0;
}
if (CheckBoxListLeft.Items[3].Selected)
{
interventions.Participating = 1;
}
else
{
interventions.Participating = 0;
}
if (CheckBoxListLeft.Items[4].Selected)
{
interventions.Completed = 1;
}
else
{
interventions.Completed = 0;
}
if (CheckBoxListRight.Items[0].Selected)
{
interventions.Email = 1;
}
else
{
interventions.Email = 0;
}
if (CheckBoxListRight.Items[1].Selected)
{
interventions.Telephone = 1;
}
else
{
interventions.Telephone = 0;
}
if (CheckBoxListRight.Items[2].Selected)
{
interventions.InPerson = 1;
}
else
{
interventions.InPerson = 0;
}
if (CheckBoxListRight.Items[3].Selected)
{
interventions.HandOff = 1;
}
else
{
interventions.HandOff = 0;
}
if (CheckBoxTesting.Checked == true)
{
interventions.Testing = 1;
}
else
{
interventions.Testing = 0;
}
interventions.Comment = TextBoxContactNotes.Text.Trim();
if (isNew)
{
if (interventions.AddInterventions() > 0)
{
LabelStatus.Text = "Saved Successfully.";
}
else
{
LabelStatus.Text = "Save Failed.";
}
}
else
{
if (interventions.UpdateInterventions())
{
LabelStatus.Text = "Update Successfully.";
}
else
{
LabelStatus.Text = "Update Failed.";
}
}
}
catch (Exception ex)
{
LabelStatus.Text = "Not Saved";
}
}
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
try
{
//CheckValueNonScore();
//CheckValueForScore();
bool ChNonScore = CheckValueNonScore();
if (!ChNonScore)
{
Alert.Show("Please Answer All Non Score Questions");
// Label1.Text = "<b>Check All Non Score</b>";
return ;
}
bool ChScore = CheckValueForScore();
if (!ChScore)
{
Alert.Show("Please Answer All Score Questions");
// Label1.Text = "<b>Check All Score Question</b>";
return ;
}
else
{
int answerOID = GetValueNonScore();
GetValueForScore(answerOID);
Student student = (Student)(Session["currentStd"]);
int aoid = Convert.ToInt32(Session["aoid"].ToString());
try
{
if (student != null)
{
RiskCalculation riskCalculation = new RiskCalculation().GetRiskCalculationByAOIDAndSOID(aoid, student.StudentOID);
if (riskCalculation != null)
{
Interventions intervention = new Interventions().GetInterventionByRiskOID(riskCalculation.RiskOID);
if (intervention != null)
{
intervention.StudentOID = student.StudentOID;
intervention.AddInterventions();
}
}
}
}
catch (Exception ex)
{ }
try
{
PrintIntervention(aoid, student.StudentID,student .EmailAddress);
UpdateTestingDate(lblStudentID.Text);
//Response.Redirect("FinishExam.aspx?aoid=" + aoid + "");
Response.Redirect("../../FinishExam.aspx");
}
catch (Exception ex)
{
lblValidation.Text = ex.ToString();
}
// Response.Redirect("FinishExam.aspx?aoid=" + aoid + "&bannerid='" + lblStudentID.Text + "'");
}
}
catch (Exception )
{
}
}
public void PrintIntervention(int aid, int rlst,string riskName)
{
try
{
Assessment ass = new Assessment();
ass = ass.GetAssessmentByOID(aid);
ResultLetterDetail letterDetail = null;
ResultLetter resultLetter = new ResultLetter();
resultLetter = resultLetter.GetResultLetterByAOID(aid);
Collection<Answer> answers = new Answer().GetAnswerByAOIDAndRLST_ForPrintResultLetter(aid, rlst);
//Collection<Student> studentList = new Student().GetAllStudentByResultLetterSentTimes(rlst);
Collection<Student> studentList = new Collection<Student>();// new Student().GetAllStudentByResultLetterSentTimes(rlst);
foreach (Answer answer in answers)
{
//Student student = new Student();
Student student = new Student().GetStudentByStudentOID(answer.BannerID.ToString());
RiskCalculation riskCalculation = new RiskCalculation();
if (student != null)
{
riskCalculation = riskCalculation.GetRiskCalculationByAOIDAndSOIDAndRiskName(aid, student.StudentOID,riskName);
}
// if (student.StudentOID == 0) break ;
bool isContain = false;
foreach (Student std in studentList)
{
if (student.StudentOID == std.StudentOID)
{
isContain = true;
}
}
if (!isContain && riskCalculation != null && student != null)
//if (!isContain && riskCalculation != null)
{
answer.UpdateAnswer_ForNumberofPrinted(aid, rlst, Convert.ToInt32(student.StudentOID));
answer.UpdateScoreDetailsTable_ForNumberofPrinted(aid, rlst, Convert.ToInt32(student.StudentOID));
studentList.Add(student);
}
}
// bool updateStatus = new Student().UpdateAllStudentByResultLetterSentTimes(rlst);
List<ScoreDetailTable> scoreDetailTableList = new ScoreDetailTable().GetScoreDetailTableByAOID(ass.AssessmentOID);
//List<ScoreDetailTable> scoreDetailTableList = new List<ScoreDetailTable>();
StringBuilder sb = new StringBuilder();
string dateStr = System.DateTime.Today.ToLongDateString();
foreach (Student student in studentList)
{
//sb.Append("<table cellpadding='0' cellspacing='0' style='page-break-after:always; width:90%; margin:0px 0px 0px 0px;' >");
#region Header
sb.Append("<table cellpadding='0' cellspacing='0' style='width:100%; margin:10px 10px 5px 10px;font-size:12px; page-break-after:always; height:100%'>");
sb.Append("<tr>");
sb.Append("<td> " + dateStr + "</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td> <br/>" + student.FullName + "</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td> " + student.AddressOne + "</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td> ");
sb.Append("<table cellpadding='0' cellspacing='0' style='width:100%;'>");
sb.Append("<tr>");
sb.Append("<td align='left' style='font-size:12px'>");
if (!string.IsNullOrEmpty(student.City))
{
sb.Append(student.City);
}
if (!string.IsNullOrEmpty(student.State))
{
sb.Append(", " + student.State);
}
if (!string.IsNullOrEmpty(student.ZIPCode))
{
sb.Append(", " + student.ZIPCode);
}
sb.Append("</td> ");
sb.Append("<td align='right'> Student ID: " + student.StudentID + "</td>");
sb.Append("<tr>");
sb.Append("</table>");
sb.Append("</td>");
sb.Append("</tr>");
#endregion
#region StudentName
string studentFirstName = student.FullName;
if (!string.IsNullOrEmpty(studentFirstName))
{
try
{
if (studentFirstName.Contains(','))
{
studentFirstName = studentFirstName.Split(',')[1];
}
}
catch
{ }
}
#endregion
sb.Append("<tr>");
sb.Append("<td><br/>Dear " + studentFirstName + ":</td>");
sb.Append("</tr>");
// sb.Append("</br><div id='Header' style='height:150px;position: relative;vertical-align:top;border:1px solid red'>");
if (resultLetter != null)
{
sb.Append("<tr>");
sb.Append("<td style='font-size:12px;border:1px''>" + resultLetter.Header + "</td>");
sb.Append("</tr>");
}
// sb.Append("</div>");
sb.Append("<tr>");
sb.Append("<td><br/>");
sb.Append("<table cellpadding='0' cellspacing='0' style='width:98%;'>");
sb.Append("<tr>");
sb.Append("<td style='background:#d7d7d7; width:29%; border: thin solid #999; padding:8px;font-family:Calibri;font-size:10px;'><b>CATEGORY</b></td>");
sb.Append("<td style='background:#d7d7d7; width:69%; border: thin solid #999; padding:8px;font-family:Calibri;font-size:10px;'><b>DEFINITION</b></td>");
sb.Append("</tr>");
//Collection<StudentRank> studentRankList_ = new StudentRank().GetStudentRankBySOIDandAOID(student.StudentOID, ass.AssessmentOID);
#region SectionList
foreach (Section s in ass.SectionList)
{
if (s.SectionName == "NoScore") continue;
string definition = "", starValue = "";
if (resultLetter != null)
{
if (resultLetter.LetterDetail != null)
{
var tmp = from detail in resultLetter.LetterDetail
where detail.SectionOID == s.SectionOID
select detail;
letterDetail = tmp != null ? tmp.First() : null;
}
}
#endregion
sb.Append("<tr>");
#region unused
//foreach (StudentRank SR in studentRankList)
//{
// if (SR.SectionOID == s.SectionOID)
// {
// if (SR.Rank < s.Flag)
// {
// starValue = " *";
// break;
// }
// else
// { starValue = ""; }
// }
//}
//scoreDetailTableList
#endregion
#region Star
foreach (ScoreDetailTable SR in scoreDetailTableList)
{
if ((SR.StudentOID == student.StudentOID) && (SR.SectionOID == s.SectionOID))
{
//if ((SR.Score*s.TotalQuestion) < s.Flag)
if ((SR.Rank) < s.Flag)
{
starValue = " *";
break;
}
else
{
starValue = "";
break;
}
}
}
#endregion
sb.Append("<td style='width:29%; border: thin solid #999; padding:8px;font-family:Calibri;font-size:10px;'><b>" + s.SectionName + starValue + "</b></td>");
definition = (letterDetail != null) ? letterDetail.SectionDefinition : "";
sb.Append("<td style='width:69%; border: thin solid #999; padding:8px; text-align:left; font-family:Calibri;font-size:10px;'>" + definition + "</td>");
}
sb.Append("</table>");
//sb.Append("<div id='Footer' style='height:150px;position: relative;vertical-align:top;border:1px solid red'>");
if (resultLetter != null)
{
sb.Append("<tr>");
sb.Append("<td style='valign:top;font-size:12px;border:1px''><br/>" + resultLetter.ShowAboveResult + "</td>");
sb.Append("</tr>");
}
//sb.Append("</div>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("</table>");
sb.Append("</table>");
}
////print_div1.InnerHtml = sb.ToString();
Response.Write(sb.ToString());
return;
}
catch (Exception ex)
{
}
}
private void Initialize(int aid)
{
try
{
Assessment ass = new Assessment();
//Get Assessment by OID
ass = ass.GetAssessmentByOID(aid);
//Assign it
LabelAssessmentName.Text = ass.AssessmentName;
LabelSection.Text = ass.TotalSection.ToString();
//LabelFlaggedPoint.Text = ass.TotalFlagPoint.ToString();
//LabelTotalFlagged.Text = ass.TotalFlag.ToString();
LabelTotalQuestion.Text = ass.TotalQuestion.ToString();
//Section Detail
LabelSectionDetails.Text = "";
string sectionDetails = "";
if (ass.SectionList.Count > 0)
{
foreach (Section s in ass.SectionList)
{
sectionDetails += "<br/>";
sectionDetails += "<br/>";
sectionDetails += "\t" + "<span style='font-weight:bold;font-size:medium;'>" + s.SectionName + "</span>";
sectionDetails += "<br/>";
sectionDetails += "Total Question : " + s.TotalQuestion.ToString();
sectionDetails += "<br/>";
if (s.SectionName == "NoScore") continue;
sectionDetails += "Total Points : " + s.FlagPointTotal.ToString();
}
}
LabelSectionDetails.Text = sectionDetails;
//Add Existing RiskCalculation//style='border-style: solid; border-width: thin'
string str = "<table id='tblRisk' > <tr><td style='font-weight:bold;font-size:medium;'>At Risk Calculation</td></tr> <tr><td>Current Calculation(s): <input id='ButtonAddRisk' type='button' value='+' /> <span id='AddRiskSpan' style='display:none;'>Name <input id='TextRiskName' type='text' /> <input id='ButtonSaveRisk' type='button' value='Save' /></span></td></tr>";
RiskCalculation risk = new RiskCalculation();
System.Collections.ObjectModel.Collection<RiskCalculation> list;
list = risk.GetRiskCalulationByAOID(aid);
foreach (RiskCalculation r in list)
{
///
str += "<tr id='" + r.RiskOID + "'><td><span>" + r.RiskName + "</span><span id='SpanMain" + r.RiskOID + "'> :" + r.NumFlag + " Flagged Point " + " </span><input id='ButtonEdit' type='button' value='Edit' /> <input id='ButtonPrescription' type='button' value='Prescription' /> <span id='SpanInner" + r.RiskOID + "' style='display:none;' > Flagged Point <input id='Flagged" + r.RiskOID + "' style='width:20px' type='text' /> <input id='ButtonSave' type='button' value='Save' /> </span></td></tr>";
}
//str+= "<tr id='1' style='display:none;'><td><span id='SpanMain1'>At Risk : 4pts flagged + 2 Section Failed </span><input id='ButtonEdit' type='button' value='Edit' /> <input id='ButtonPrescription' type='button' value='Prescription' /> <span id='SpanInner1' style='display:none;'> Flagged <input id='Flagged1' style='width:20px' type='text' /> Section Failed <input id='SectionFailed1' type='text' style='width:20px' /><input id='ButtonSave' type='button' value='Save' /> </span></td></tr>";
str += " <tr id='RowLast'><td> </td></tr>";
str+="</table>";
LabelRisk.Text = str;
}
catch (Exception ex)
{ }
}
private void BindRiskCalculation(int AOID, int SOID)
{
RiskCalculation riskCalculation = new RiskCalculation().GetRiskCalculationByAOIDAndSOID(AOID, SOID);
if (riskCalculation == null)
{
LabelRisk.Text = "";
}
else
{
LabelRisk.Text = riskCalculation.RiskName.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
connectionString = System.Web.Configuration.WebConfigurationManager.AppSettings["ConnectionString"].ToString();
if (!Page.IsPostBack)
{
string strID = null;
if (Request.QueryString["id"] != null)
{
strID = Request.QueryString["id"].ToString();
ViewState["STDOID"] = strID;
Session["STUOID"] = strID;
}
populateDropdownList();
Student stu = new Student();
string strOID = stu.GetStudentIDByStudentBannerOID(Convert.ToInt32(strID));
Populate(strOID);
populateDropdownList();
PopulateSection(ddlAssesment.Text, strOID);
PopulateSectionNoScore(ddlAssesment.Text, strOID);
PopulateCourseByStudentID();
int AOID = 0;
if (ddlAssesment.Text != null && ddlAssesment.Text != "")
{
AOID = new Sections().GetAssessmentOIDByAssessmentName(ddlAssesment.Text);
}
if (!string.IsNullOrEmpty(strID))
{
this.BindRiskCalculation(AOID, Convert.ToInt32(strID));
}
int RiskOID = 0;
if (LabelRisk.Text != "")
{
RiskOID = new RiskCalculation().GetRiskOIDByAOIDAndName(AOID, LabelRisk.Text);
}
ViewState["ROID"] = RiskOID;
HiddenRiskOID.Value = RiskOID.ToString();
PopulateGridIntervention(RiskOID);
rowID = stu.GetStudentRowIDByBannerID(lblID.Text.Trim());
ViewState["RowID"] = rowID;
}
}
public Collection<RiskCalculation> GetRiskCalulationByAOID(int aoid)
{
Collection<RiskCalculation> list = new Collection<RiskCalculation>();
RiskCalculation risk = null;
try
{
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
using (OdbcCommand command = new OdbcCommand())
{
command.Connection = connection;
command.CommandText = "{CALL Risk_GetByAOID(?)}";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@AOID", aoid);
connection.Open();
using (OdbcDataReader dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{//this = new Assessment();
risk = new RiskCalculation();
risk.RiskOID = Convert.ToInt32(dataReader["RiskOID"]);
risk.NumFlag = Convert.ToInt32(dataReader["NumFlag"]);
risk.NumSection = Convert.ToInt32(dataReader["NumSection"]);
risk.AssessmentOID = Convert.ToInt32(dataReader["AssessmentOID"]);
risk.CreatedBy = Convert.ToInt32(dataReader["CreatedBy"]);
risk.CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]);
risk.RiskName = Convert.ToString(dataReader["RiskName"]);
list.Add(risk);
}
}
}
}
}
catch (Exception ex)
{ }
return list;
}
public RiskCalculation GetRiskCalculationByAOIDAndSOIDAndRiskName(int AOID, int SOID,string riskName)
{
RiskCalculation riskCalculation = null;
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
using (OdbcCommand command = new OdbcCommand())
{
command.Connection = connection;
command.CommandText = "{CALL GetRiskCalculationByAOIDANDSOIDANDRISKNAME(?,?,?)}";
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 600;
//Set Parameter Value
command.Parameters.AddWithValue("@AOID", AOID);
command.Parameters.AddWithValue("@SOID", SOID);
command.Parameters.AddWithValue("@RISK_NAME", riskName);
//Open connection
connection.Open();
//Read using reader
using (OdbcDataReader dataReader = command.ExecuteReader())
{
if (dataReader.Read())
{
riskCalculation = new RiskCalculation();
riskCalculation.RiskOID = Convert.ToInt32(dataReader["RiskOID"]);
riskCalculation.RiskName = dataReader["RiskName"].ToString();
riskCalculation.AssessmentOID = Convert.ToInt32(dataReader["AssessmentOID"]);
riskCalculation.NumSection = Convert.ToInt32(dataReader["NumSection"]);
riskCalculation.NumFlag = Convert.ToInt32(dataReader["NumFlag"]);
riskCalculation.CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]);
riskCalculation.CreatedBy = Convert.ToInt32(dataReader["CreatedBy"]);
}
}
}
}
return riskCalculation;
}
private void GetRisks(int aoid)
{
RiskCalculation rsk = new RiskCalculation();
Collection<RiskCalculation> RisksList = new Collection<RiskCalculation>();
RisksList = rsk.GetRiskCalulationByAOID(aoid);
if (RisksList.Count != 0)
{
foreach (RiskCalculation r in RisksList)
{
ddlRisk.Items.Add(r.RiskName);
}
}
}
