public IEnumerable <EvaluationReport> getEvaluationreport(int EID)
{
using (ClubDBEntities club = new ClubDBEntities())
{
var re = (from o in club.Evaluations
where o.ID == EID
select o).First();
EvaluationReport report = new EvaluationReport();
report.Assessment = re.Assessment;
report.Diagnosis = re.Diagnosis;
report.DOB = re.Client.DOB.ToString();
report.EmpName = re.Employee.Name;
report.FileID = re.ClientID.ToString();
report.Goals = re.Goals;
report.History = re.History;
report.Nation = re.Client.Nationality;
report.Objective = re.Objective;
report.PatientName = re.Client.FullName();
report.Phone = re.Client.Phone.ToString();
report.Date = re.Date.ToString("dd/MM/yyyy");
report.Treatment = re.Treatment;
List <EvaluationReport> ll = new List <EvaluationReport>();
ll.Add(report);
return(ll.AsEnumerable());
}
}
public IEnumerable <EvaluationReport> Evaluations(int periodid, string type)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@EvaluationSeason", periodid);
cmd.Parameters.AddWithValue("@Type", type);
cmd.Parameters.AddWithValue("@QueryType", 1);
DataTable dt = SCObjects.ExecGetData(cmd, UserConnectionString);
List <EvaluationReport> items = new List <EvaluationReport>();
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
var item = new EvaluationReport
{
Id = int.Parse(dr["Id"].ToString()),
Name = dr["Name"].ToString(),
Rater = dr["Rater"].ToString(),
Period = dr["Period"].ToString(),
Type = dr["Type"].ToString(),
Status = dr["Status"].ToString(),
DateCreated = dr["DateCreated"].ToString()
};
items.Add(item);
}
}
return(items);
}
