public static DataTable RefreshOneStudent(int provNum)
{
DataTable table = new DataTable();
DataRow row;
//columns that start with lowercase are altered for display rather than being raw data.
table.Columns.Add("appointment");
table.Columns.Add("course");
table.Columns.Add("done");
table.Columns.Add("patient");
table.Columns.Add("ReqStudentNum");
table.Columns.Add("requirement");
string command = "SELECT AptDateTime,CourseID,reqStudent.Descript ReqDescript,"
+ "schoolcourse.Descript CourseDescript,reqstudent.DateCompleted, "
+ "patient.LName,patient.FName,patient.MiddleI,patient.Preferred,ProcDescript,reqstudent.ReqStudentNum "
+ "FROM reqstudent "
+ "LEFT JOIN schoolcourse ON reqstudent.SchoolCourseNum=schoolcourse.SchoolCourseNum "
+ "LEFT JOIN patient ON reqstudent.PatNum=patient.PatNum "
+ "LEFT JOIN appointment ON reqstudent.AptNum=appointment.AptNum "
+ "WHERE reqstudent.ProvNum=" + POut.PInt(provNum)
+ " ORDER BY CourseID,ReqDescript";
DataTable raw = General.GetTable(command);
DateTime AptDateTime;
DateTime dateCompleted;
for (int i = 0; i < raw.Rows.Count; i++)
{
row = table.NewRow();
AptDateTime = PIn.PDateT(raw.Rows[i]["AptDateTime"].ToString());
if (AptDateTime.Year > 1880)
{
row["appointment"] = AptDateTime.ToShortDateString() + " " + AptDateTime.ToShortTimeString()
+ " " + raw.Rows[i]["ProcDescript"].ToString();
}
row["course"] = raw.Rows[i]["CourseID"].ToString(); //+" "+raw.Rows[i]["CourseDescript"].ToString();
dateCompleted = PIn.PDate(raw.Rows[i]["DateCompleted"].ToString());
if (dateCompleted.Year > 1880)
{
row["done"] = "X";
}
row["patient"] = PatientB.GetNameLF(raw.Rows[i]["LName"].ToString(), raw.Rows[i]["FName"].ToString(),
raw.Rows[i]["Preferred"].ToString(), raw.Rows[i]["MiddleI"].ToString());
row["ReqStudentNum"] = raw.Rows[i]["ReqStudentNum"].ToString();
row["requirement"] = raw.Rows[i]["ReqDescript"].ToString();
table.Rows.Add(row);
}
return(table);
}
///<summary>Gets a filtered list of all labcases.</summary>
public static DataTable Refresh(DateTime aptStartDate, DateTime aptEndDate)
{
DataTable table = new DataTable();
DataRow row;
//columns that start with lowercase are altered for display rather than being raw data.
table.Columns.Add("aptDateTime");
table.Columns.Add("lab");
table.Columns.Add("LabCaseNum");
table.Columns.Add("patient");
table.Columns.Add("phone");
table.Columns.Add("ProcDescript");
table.Columns.Add("status");
string command = "SELECT AptDateTime,DateTimeChecked,DateTimeRecd,DateTimeSent,"
+ "LabCaseNum,laboratory.Description,LName,FName,Preferred,MiddleI,Phone,ProcDescript "
+ "FROM labcase,appointment,patient,laboratory "
+ "WHERE labcase.AptNum=appointment.AptNum "
+ "AND labcase.PatNum=patient.PatNum "
+ "AND labcase.LaboratoryNum=laboratory.LaboratoryNum "
+ "AND AptDateTime > " + POut.PDate(aptStartDate) + " "
+ "AND AptDateTime < " + POut.PDate(aptEndDate.AddDays(1)) + " "
+ "ORDER BY AptDateTime";
DataTable raw = General.GetTable(command);
DateTime AptDateTime;
DateTime date;
for (int i = 0; i < raw.Rows.Count; i++)
{
row = table.NewRow();
AptDateTime = PIn.PDateT(raw.Rows[i]["AptDateTime"].ToString());
row["aptDateTime"] = AptDateTime.ToShortDateString() + " " + AptDateTime.ToShortTimeString();
row["lab"] = raw.Rows[i]["Description"].ToString();
row["LabCaseNum"] = raw.Rows[i]["LabCaseNum"].ToString();
row["patient"] = PatientB.GetNameLF(raw.Rows[i]["LName"].ToString(), raw.Rows[i]["FName"].ToString(),
raw.Rows[i]["Preferred"].ToString(), raw.Rows[i]["MiddleI"].ToString());
row["phone"] = raw.Rows[i]["Phone"].ToString();
row["ProcDescript"] = raw.Rows[i]["ProcDescript"].ToString();
date = PIn.PDateT(raw.Rows[i]["DateTimeChecked"].ToString());
if (date.Year > 1880)
{
row["status"] = Lan.g("FormLabCases", "Quality Checked");
}
else
{
date = PIn.PDateT(raw.Rows[i]["DateTimeRecd"].ToString());
if (date.Year > 1880)
{
row["status"] = Lan.g("FormLabCases", "Received");
}
else
{
date = PIn.PDateT(raw.Rows[i]["DateTimeSent"].ToString());
if (date.Year > 1880)
{
row["status"] = Lan.g("FormLabCases", "Sent"); //sent but not received
}
else
{
row["status"] = Lan.g("FormLabCases", "Not Sent");
}
}
}
table.Rows.Add(row);
}
return(table);
}