private void buttonFormInvestFlow_Click(object sender, RoutedEventArgs e)
{
txtCoeffInvest.Text = EvaluationClass.getCoefficientRentabilnosti(InvestmentRows).ToString();
txtProcessRang.Text = EvaluationClass.getRang(getInt(txtExpectedProfit.Text),
getDouble(txtProbabilityOfSuccess.Text),
getInt(txtExpenseSZI.Text)).ToString();
// txtPresentValue.Text = EvaluationClass.getCost(getDouble(txtCoefficient.Text),
}
public List <EvaluationClass> GetEvaluationClassesByTeacherAndExam(int tid, int eid)
{
using (var classConnection = SqlConnectionManager.GetConnection())
using (var classCommand = new NpgsqlCommand())
{
classCommand.Connection = classConnection;
classCommand.CommandText = "select * from getClassesByTeacherAndExam(@tid, @eid)";
classCommand.Parameters.AddWithValue("@tid", tid);
classCommand.Parameters.AddWithValue("@eid", eid);
var classReader = classCommand.ExecuteReader();
var classes = new List <EvaluationClass>();
while (classReader.Read())
{
var e = new EvaluationClass();
var c = new Class()
{
Id = int.Parse(classReader["id"].ToString()),
Branch = classReader["branch"].ToString(),
Year = int.Parse(classReader["year"].ToString()),
SectionFrom = int.Parse(classReader["sec_from"].ToString()),
SectionTo = int.Parse(classReader["sec_to"].ToString())
};
e.TeacherClass = c;
using (var statusConnection = SqlConnectionManager.GetConnection())
using (var statusCommand = new NpgsqlCommand())
{
statusCommand.Connection = statusConnection;
statusCommand.CommandText = "select * from getClassEvaluationStatus(@cid, @eid)";
statusCommand.Parameters.AddWithValue("@cid", c.Id);
statusCommand.Parameters.AddWithValue("@eid", eid);
var statusReader = statusCommand.ExecuteReader();
if (statusReader.Read())
{
e.EvaluationStatus = statusReader.GetBoolean(0);
}
else
{
e.EvaluationStatus = false;
}
}
classes.Add(e);
}
return(classes);
}
}
