protected void lbDelete_Click(object sender, EventArgs e)
{
LinkButton linkButton = new LinkButton();
linkButton = (LinkButton)sender;
bool result = ADLHeaderDetailnDateTimeManager.DeleteADLHeaderDetailnDateTime(Convert.ToInt32(linkButton.CommandArgument));
showADLHeaderDetailnDateTimeGrid();
}
private void showADLHeaderDetailnDateTimeData()
{
ADLHeaderDetailnDateTime aDLHeaderDetailnDateTime = new ADLHeaderDetailnDateTime();
aDLHeaderDetailnDateTime = ADLHeaderDetailnDateTimeManager.GetADLHeaderDetailnDateTimeByID(Int32.Parse(Request.QueryString["aDLHeaderDetailnDateTimeID"]));
ddlADLDateTime.SelectedValue = aDLHeaderDetailnDateTime.ADLDateTimeID.ToString();
ddlADLHeaderDetail.SelectedValue = aDLHeaderDetailnDateTime.ADLHeaderDetailID.ToString();
ddlADLHeaderDetail.SelectedValue = aDLHeaderDetailnDateTime.ADLHeaderDetailID.ToString();
txtExtraField1.Text = aDLHeaderDetailnDateTime.ExtraField1;
txtExtraField2.Text = aDLHeaderDetailnDateTime.ExtraField2;
txtExtraField3.Text = aDLHeaderDetailnDateTime.ExtraField3;
txtExtraField4.Text = aDLHeaderDetailnDateTime.ExtraField4;
txtExtraField5.Text = aDLHeaderDetailnDateTime.ExtraField5;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
ADLHeaderDetailnDateTime aDLHeaderDetailnDateTime = new ADLHeaderDetailnDateTime();
aDLHeaderDetailnDateTime.ADLDateTimeID = Int32.Parse(ddlADLDateTime.SelectedValue);
aDLHeaderDetailnDateTime.ADLHeaderDetailID = Int32.Parse(ddlADLHeaderDetail.SelectedValue);
aDLHeaderDetailnDateTime.ADLHeaderDetailID = Int32.Parse(ddlADLHeaderDetail.SelectedValue);
aDLHeaderDetailnDateTime.ExtraField1 = txtExtraField1.Text;
aDLHeaderDetailnDateTime.ExtraField2 = txtExtraField2.Text;
aDLHeaderDetailnDateTime.ExtraField3 = txtExtraField3.Text;
aDLHeaderDetailnDateTime.ExtraField4 = txtExtraField4.Text;
aDLHeaderDetailnDateTime.ExtraField5 = txtExtraField5.Text;
int resutl = ADLHeaderDetailnDateTimeManager.InsertADLHeaderDetailnDateTime(aDLHeaderDetailnDateTime);
Response.Redirect("AdminADLHeaderDetailnDateTimeDisplay.aspx");
}
private void loadMedicineTimenDateDate()
{
ddlExistingRecord.Items.Clear();
ListItem li = new ListItem("New Record", "0");
ddlExistingRecord.Items.Add(li);
DataSet ds = ADLHeaderDetailnDateTimeManager.GetAllADLHeaderDetailnDateTimeByResidentID(int.Parse(Request.QueryString["ResidentID"]));
foreach (DataRow assessmentnCareDate in ds.Tables[0].Rows)
{
ListItem item = new ListItem(DateTime.Parse(assessmentnCareDate["ADLDateTime"].ToString()).ToString("yyyy-MM-dd hh:mm tt"), assessmentnCareDate["ADLDateTimeID"].ToString());
ddlExistingRecord.Items.Add(item);
}
ddlExistingRecord_SelectedIndexChanged(this, new EventArgs());
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
ADLHeaderDetailnDateTime aDLHeaderDetailnDateTime = new ADLHeaderDetailnDateTime();
aDLHeaderDetailnDateTime = ADLHeaderDetailnDateTimeManager.GetADLHeaderDetailnDateTimeByID(Int32.Parse(Request.QueryString["aDLHeaderDetailnDateTimeID"]));
ADLHeaderDetailnDateTime tempADLHeaderDetailnDateTime = new ADLHeaderDetailnDateTime();
tempADLHeaderDetailnDateTime.ADLHeaderDetailnDateTimeID = aDLHeaderDetailnDateTime.ADLHeaderDetailnDateTimeID;
tempADLHeaderDetailnDateTime.ADLDateTimeID = Int32.Parse(ddlADLDateTime.SelectedValue);
tempADLHeaderDetailnDateTime.ADLHeaderDetailID = Int32.Parse(ddlADLHeaderDetail.SelectedValue);
tempADLHeaderDetailnDateTime.ADLHeaderDetailID = Int32.Parse(ddlADLHeaderDetail.SelectedValue);
tempADLHeaderDetailnDateTime.ExtraField1 = txtExtraField1.Text;
tempADLHeaderDetailnDateTime.ExtraField2 = txtExtraField2.Text;
tempADLHeaderDetailnDateTime.ExtraField3 = txtExtraField3.Text;
tempADLHeaderDetailnDateTime.ExtraField4 = txtExtraField4.Text;
tempADLHeaderDetailnDateTime.ExtraField5 = txtExtraField5.Text;
bool result = ADLHeaderDetailnDateTimeManager.UpdateADLHeaderDetailnDateTime(tempADLHeaderDetailnDateTime);
Response.Redirect("AdminADLHeaderDetailnDateTimeDisplay.aspx");
}
private void loadSelectData()
{
if (ddlExistingRecord.SelectedIndex != 0)
{
DataSet ds = ADLHeaderDetailnDateTimeManager.GetAllADLHeaderDetailnDateTimeByADLDateTimeID(int.Parse(ddlExistingRecord.SelectedValue));
foreach (GridViewRow gvr in gvHeader.Rows)
{
HiddenField hfADLHeaderID = (HiddenField)gvr.FindControl("hfADLHeaderID");
GridView gvDetail = (GridView)gvr.FindControl("gvDetail");
foreach (GridViewRow gvrDetail in gvDetail.Rows)
{
HiddenField hfADLHeaderDetialID = (HiddenField)gvrDetail.FindControl("hfADLHeaderDetialID");
TextBox txtNewStatus = (TextBox)gvrDetail.FindControl("txtNewStatus");
TextBox txtRemark = (TextBox)gvrDetail.FindControl("txtRemark");
DropDownList ddlADLStatusInGrid = (DropDownList)gvrDetail.FindControl("ddlADLStatusInGrid");
RadioButtonList rbtnlADLStatusInGrid = (RadioButtonList)gvrDetail.FindControl("rbtnlADLStatusInGrid");
Label lblSavedBy = (Label)gvrDetail.FindControl("lblSavedBy");
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["ADLHeaderDetailID"].ToString() == hfADLHeaderDetialID.Value)
{
bool isExitInDdl = false;
foreach (ListItem item in ddlADLStatusInGrid.Items)
{
if (item.Value == dr["ExtraField1"].ToString())
{
isExitInDdl = true;
rbtnlADLStatusInGrid.SelectedValue = dr["ExtraField1"].ToString();
break;
}
}
if (!isExitInDdl)
{
rbtnlADLStatusInGrid.SelectedIndex = -1;
txtNewStatus.Text = dr["ExtraField1"].ToString();
}
txtRemark.Text = dr["ExtraField3"].ToString();
if (dr["ExtraField1"].ToString() == "")
{
lblSavedBy.Text = "";
}
else
{
lblSavedBy.Text = dr["ExtraField2"].ToString();
}
break;
}
}
}
}
}
else
{
foreach (GridViewRow gvr in gvHeader.Rows)
{
HiddenField hfADLHeaderID = (HiddenField)gvr.FindControl("hfADLHeaderID");
GridView gvDetail = (GridView)gvr.FindControl("gvDetail");
foreach (GridViewRow gvrDetail in gvDetail.Rows)
{
HiddenField hfADLHeaderDetialID = (HiddenField)gvrDetail.FindControl("hfADLHeaderDetialID");
TextBox txtNewStatus = (TextBox)gvrDetail.FindControl("txtNewStatus");
DropDownList ddlADLStatusInGrid = (DropDownList)gvrDetail.FindControl("ddlADLStatusInGrid");
txtNewStatus.Text = "";
ddlADLStatusInGrid.SelectedIndex = 0;
}
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
lblMsg.Visible = true;
int ADLDateTimeID = 0;
if (ddlExistingRecord.SelectedValue == "0")
{
ADLDateTime aDLDateTime = new ADLDateTime();
aDLDateTime.ADLDateTimeValue = DateTime.Now;
ADLDateTimeID = ADLDateTimeManager.InsertADLDateTime(aDLDateTime);
}
else
{
ADLDateTimeID = int.Parse(ddlExistingRecord.SelectedValue);
ADLHeaderDetailnDateTimeManager.DeleteADLHeaderDetailnDateTimeByADLDateTimeID(ADLDateTimeID);
}
foreach (GridViewRow gvr in gvHeader.Rows)
{
HiddenField hfADLHeaderID = (HiddenField)gvr.FindControl("hfADLHeaderID");
GridView gvDetail = (GridView)gvr.FindControl("gvDetail");
foreach (GridViewRow gvrDetail in gvDetail.Rows)
{
HiddenField hfADLHeaderDetialID = (HiddenField)gvrDetail.FindControl("hfADLHeaderDetialID");
TextBox txtNewStatus = (TextBox)gvrDetail.FindControl("txtNewStatus");
TextBox txtRemark = (TextBox)gvrDetail.FindControl("txtRemark");
DropDownList ddlADLStatusInGrid = (DropDownList)gvrDetail.FindControl("ddlADLStatusInGrid");
RadioButtonList rbtnlADLStatusInGrid = (RadioButtonList)gvrDetail.FindControl("rbtnlADLStatusInGrid");
//if (txtNewStatus.Text != "" || ddlADLStatusInGrid.SelectedValue != "0")
try
{
ADLHeaderDetailnDateTime aDLHeaderDetailnDateTime = new ADLHeaderDetailnDateTime();
aDLHeaderDetailnDateTime.ADLDateTimeID = ADLDateTimeID;
aDLHeaderDetailnDateTime.ADLHeaderDetailID = Int32.Parse(hfADLHeaderDetialID.Value);
aDLHeaderDetailnDateTime.ExtraField1 = (txtNewStatus.Text == "" ? rbtnlADLStatusInGrid.SelectedValue : txtNewStatus.Text);
aDLHeaderDetailnDateTime.ExtraField2 = getLogin().ExtraField4;
aDLHeaderDetailnDateTime.ExtraField3 = txtRemark.Text;
aDLHeaderDetailnDateTime.ExtraField4 = getLogin().LoginID.ToString();
aDLHeaderDetailnDateTime.ExtraField5 = "";
int resutl = ADLHeaderDetailnDateTimeManager.InsertADLHeaderDetailnDateTime(aDLHeaderDetailnDateTime);
}
catch (Exception ex)
{ }
}
}
loadMedicineTimenDateDate();
foreach (GridViewRow gvr in gvHeader.Rows)
{
HiddenField hfADLHeaderID = (HiddenField)gvr.FindControl("hfADLHeaderID");
GridView gvDetail = (GridView)gvr.FindControl("gvDetail");
foreach (GridViewRow gvrDetail in gvDetail.Rows)
{
HiddenField hfADLHeaderDetialID = (HiddenField)gvrDetail.FindControl("hfADLHeaderDetialID");
TextBox txtNewStatus = (TextBox)gvrDetail.FindControl("txtNewStatus");
TextBox txtRemark = (TextBox)gvrDetail.FindControl("txtRemark");
DropDownList ddlADLStatusInGrid = (DropDownList)gvrDetail.FindControl("ddlADLStatusInGrid");
RadioButtonList rbtnlADLStatusInGrid = (RadioButtonList)gvrDetail.FindControl("rbtnlADLStatusInGrid");
txtRemark.Text = "";
rbtnlADLStatusInGrid.SelectedIndex = -1;
}
}
}
private void loadList()
{
DateTime startDate = DateTime.Parse(ddlYears.SelectedValue + "-" + ddlMonths.SelectedValue + "-1");
DateTime endDate = startDate.AddMonths(1).AddDays(-1);
string html = "";
//Initial
html += "<table border='0' class='reportTable'><tr>";
html += "<tr><td colspan='2'></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>";
List <ADLHeaderDetail> aDLHeaderDetailByResident = ADLHeaderDetailManager.GetAllADLHeaderDetailsByResidentID(int.Parse(Request.QueryString["ResidentID"]));
if (aDLHeaderDetailByResident.Count == 0)
{
aDLHeaderDetailByResident = ADLHeaderDetailManager.GetDefaultAfterInsertADLHeaderDetails(int.Parse(Request.QueryString["ResidentID"]));
}
//DataSet ds = MedicationTimeManager.GetAllMedicationTimesByResident(int.Parse(Request.QueryString["ResidentID"]));
//DataSet dsAllData = MedicineTimenDateManager.GetMedicationTimenDateByResidentID(int.Parse(Request.QueryString["ResidentID"]));
DataSet dsAllData = ADLHeaderDetailnDateTimeManager.GetAllADLHeaderDetailnDateTimeByResidentIDWithDateRange(int.Parse(Request.QueryString["ResidentID"]), startDate, endDate);
foreach (ADLHeaderDetail headerDetail in aDLHeaderDetailByResident)
{
html += "<tr><td>" + headerDetail.ExtraField1 + "</td><td>" + headerDetail.ExtraField2 + "</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 (headerDetail.ADLHeaderDetailID.ToString() == drAllData["ADLHeaderDetailID"].ToString() && startDate.AddDays(i).ToString("yyyy-MM-dd") == DateTime.Parse(drAllData["ADLDateTime"].ToString()).ToString("yyyy-MM-dd"))
{
isFount = true;
if (drAllData["ExtraField1"].ToString() == "")
{
html += "<td></td>";
break;
}
else
{
html += "<td style='background-color:#DDDDDD;color:Black;'>" + drAllData["ExtraField1"].ToString() + "<br/>[" + drAllData["ExtraField2"].ToString() + "]</td>";
break;
}
}
}
if (!isFount)
{
html += "<td></td>";
}
}
html += "</tr>";
}
html += "</table>";
lblMonthlyPrint.Text = html;
}
private void showADLHeaderDetailnDateTimeGrid()
{
gvADLHeaderDetailnDateTime.DataSource = ADLHeaderDetailnDateTimeManager.GetAllADLHeaderDetailnDateTimes();
gvADLHeaderDetailnDateTime.DataBind();
}
