private void loadGrid()
{
DataSet ds = new DataSet();
if (ddlShowStaus.SelectedValue == "All")
{
ds = MedicationTimeManager.GetAllMedicationTimesByResident(int.Parse(Request.QueryString["ResidentID"]));
}
else
{
ds = MedicationTimeManager.GetAllMedicationTimesByResidentByStatus(int.Parse(Request.QueryString["ResidentID"]), ddlShowStaus.SelectedValue);
}
gvMedicaiton.DataSource = ds.Tables[0];
gvMedicaiton.DataBind();
}
private void loadList()
{
DateTime startDate = DateTime.Parse(ddlYears.SelectedValue + "-" + ddlMonths.SelectedValue + "-1");
DateTime endDate = startDate.AddMonths(1).AddMinutes(-1);
string html = "";
//Initial
html += "<table border='0' class='reportTable'><tr>";
html += "<tr><td colspan='4'></td>";
int totalDayOfthisMonth = 0;
for (int i = 0; startDate.AddDays(i) <= endDate; i++)
{
html += "<td style='text-align:center'>" + startDate.AddDays(i).ToString("dd") + "<br/>" + startDate.AddDays(i).DayOfWeek.ToString().Substring(0, 1) + "</td>";
totalDayOfthisMonth = i;
}
html += "</tr>";
DataSet ds = MedicationTimeManager.GetAllMedicationTimesByResident(int.Parse(Request.QueryString["ResidentID"]), ddlMedicationList.SelectedValue);
//DataSet ds = MedicationTimeManager.GetAllMedicationTimesByResident(int.Parse(Request.QueryString["ResidentID"]));
DataSet dsAllData = MedicineTimenDateManager.GetMedicationTimenDateByResidentIDWithDateRange(int.Parse(Request.QueryString["ResidentID"]), startDate, endDate);
List <Login> allUser = LoginManager.GetAllLogins();
string CareGiverList = "";
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (ddlShowStaus.SelectedValue != "All")
{
if (ddlShowStaus.SelectedValue != dr["ExtraField6"].ToString())
{
continue;
}
}
html += "<tr><td>" + dr["TakingTime"].ToString() + "</td><td>" + dr["MedicineName"].ToString() + "</td><td>" + dr["Quality"].ToString() + "</td><td>" + dr["Quantity"].ToString() + "</td>";
//html += "</tr>" + "<tr><td>" + dr["MedicineName"] + "</td><td colspan='" + (totalDayOfthisMonth + 1).ToString() + "'>Report will goes here</td>";
for (int i = 0; startDate.AddDays(i) <= endDate; i++)
{
bool isFount = false;
foreach (DataRow drAllData in dsAllData.Tables[0].Rows)
{
if (dr["MedicationTimeID"].ToString() == drAllData["MedicationTimeID"].ToString() && startDate.AddDays(i).ToString("yyyy-MM-dd") == DateTime.Parse(drAllData["MedicineDate"].ToString()).ToString("yyyy-MM-dd"))
{
isFount = true;
html += "<td style='background-color:#DDDDDD;color:Black;'>" + drAllData["ExtraField3"].ToString() + "</td>";
foreach (Login item in allUser)
{
if (item.ExtraField4 == drAllData["ExtraField3"].ToString() && !CareGiverList.Contains("(" + item.ExtraField4 + ")"))
{
CareGiverList += (CareGiverList == ""?"":", ") + item.FirstName + " " + item.LastName + "(" + item.ExtraField4 + ")";
break;
}
}
break;
}
}
if (!isFount)
{
html += "<td></td>";
}
}
html += "</tr>";
}
lblCareGiver.Text = CareGiverList;
html += "</table>";
lblMonthlyPrint.Text = html;
}