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