protected void btnUpdate_Click(object sender, EventArgs e)
{
MedicationTime medicationTime = new MedicationTime();
medicationTime = MedicationTimeManager.GetMedicationTimeByID(Int32.Parse(Request.QueryString["medicationTimeID"]));
MedicationTime tempMedicationTime = new MedicationTime();
tempMedicationTime.MedicationTimeID = medicationTime.MedicationTimeID;
tempMedicationTime.TakingTime = txtTakingTime.Text;
tempMedicationTime.MedicineID = Int32.Parse(ddlMedicine.SelectedValue);
tempMedicationTime.ResidentID = Int32.Parse(ddlResident.SelectedValue);
tempMedicationTime.Quantity = txtQuantity.Text;
tempMedicationTime.Quality = txtQuality.Text;
tempMedicationTime.Frequency = txtFrequency.Text;
tempMedicationTime.ExtraField1 = txtExtraField1.Text;
tempMedicationTime.ExtraField2 = txtExtraField2.Text;
tempMedicationTime.AddedBy = Int32.Parse(txtAddedBy.Text);
tempMedicationTime.AddedDate = DateTime.Now;
tempMedicationTime.UpdateBy = Int32.Parse(txtUpdateBy.Text);
tempMedicationTime.UpdateDate = txtUpdateDate.Text;
bool result = MedicationTimeManager.UpdateMedicationTime(tempMedicationTime);
Response.Redirect("AdminMedicationTimeDisplay.aspx");
}
private void loadGrid()
{
DataSet ds = MedicationTimeManager.GetAllMedicationTimesByResidentForPrint(int.Parse(Request.QueryString["ResidentID"]), int.Parse(Request.QueryString["PrintOption"]));
gvMedicaiton.DataSource = ds.Tables[0];
gvMedicaiton.DataBind();
}
protected void lbDelete_Click(object sender, EventArgs e)
{
LinkButton linkButton = new LinkButton();
linkButton = (LinkButton)sender;
bool result = MedicationTimeManager.DeleteMedicationTime(Convert.ToInt32(linkButton.CommandArgument));
showMedicationTimeGrid();
}
protected void lbDelete_Click(object sender, EventArgs e)
{
ImageButton linkButton = new ImageButton();
linkButton = (ImageButton)sender;
int id;
id = Convert.ToInt32(linkButton.CommandArgument);
MedicationTimeManager.DeleteMedicationTime(id);
loadGrid();
}
private void loadMedicationTime()
{
ListItem li = new ListItem("Select MedicationTime...", "0");
ddlMedicationTime.Items.Add(li);
List <MedicationTime> medicationTimes = new List <MedicationTime>();
medicationTimes = MedicationTimeManager.GetAllMedicationTimes();
foreach (MedicationTime medicationTime in medicationTimes)
{
ListItem item = new ListItem(medicationTime.MedicationTimeName.ToString(), medicationTime.MedicationTimeID.ToString());
ddlMedicationTime.Items.Add(item);
}
}
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 showMedicationTimeData()
{
MedicationTime medicationTime = new MedicationTime();
medicationTime = MedicationTimeManager.GetMedicationTimeByID(Int32.Parse(Request.QueryString["medicationTimeID"]));
txtTakingTime.Text = medicationTime.TakingTime;
ddlMedicine.SelectedValue = medicationTime.MedicineID.ToString();
ddlResident.SelectedValue = medicationTime.ResidentID.ToString();
txtQuantity.Text = medicationTime.Quantity;
txtQuality.Text = medicationTime.Quality;
txtFrequency.Text = medicationTime.Frequency;
txtExtraField1.Text = medicationTime.ExtraField1;
txtExtraField2.Text = medicationTime.ExtraField2;
txtAddedBy.Text = medicationTime.AddedBy.ToString();
txtUpdateBy.Text = medicationTime.UpdateBy.ToString();
txtUpdateDate.Text = medicationTime.UpdateDate;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
MedicationTime medicationTime = new MedicationTime();
medicationTime.TakingTime = txtTakingTime.Text;
medicationTime.MedicineID = Int32.Parse(ddlMedicine.SelectedValue);
medicationTime.ResidentID = Int32.Parse(ddlResident.SelectedValue);
medicationTime.Quantity = txtQuantity.Text;
medicationTime.Quality = txtQuality.Text;
medicationTime.Frequency = txtFrequency.Text;
medicationTime.ExtraField1 = txtExtraField1.Text;
medicationTime.ExtraField2 = txtExtraField2.Text;
medicationTime.AddedBy = Int32.Parse(txtAddedBy.Text);
medicationTime.AddedDate = DateTime.Now;
medicationTime.UpdateBy = Int32.Parse(txtUpdateBy.Text);
medicationTime.UpdateDate = txtUpdateDate.Text;
int resutl = MedicationTimeManager.InsertMedicationTime(medicationTime);
Response.Redirect("AdminMedicationTimeDisplay.aspx");
}
protected void lbEdit_Click(object sender, EventArgs e)
{
ImageButton linkButton = new ImageButton();
linkButton = (ImageButton)sender;
int id;
id = Convert.ToInt32(linkButton.CommandArgument);
MedicationTime medicationTime = MedicationTimeManager.GetMedicationTimeByID(id);
hfMedicationTimeID.Value = medicationTime.MedicationTimeID.ToString();
txtTakingTime.Text = medicationTime.TakingTime == "PRN" ? "" : medicationTime.TakingTime;
chkPRN.Checked = medicationTime.TakingTime == "PRN" ? true : false;
string medicationName = MedicineManager.GetMedicineByID(medicationTime.MedicineID).MedicineName;
int medicaitonID = 0;
foreach (ListItem item in ddlMedicine.Items)
{
if (item.Text == medicationName)
{
medicaitonID = int.Parse(item.Value);
}
}
ddlMedicine.SelectedValue = medicaitonID.ToString();
txtQuantity.Text = medicationTime.Quantity;
txtQuality.Text = medicationTime.Quality;
txtFrequency.Text = medicationTime.Frequency;
txtEXNo.Text = medicationTime.ExtraField1;
ddlRouteOfAdmin.SelectedValue = medicationTime.ExtraField2;
txtAmount.Text = medicationTime.ExtraField3;
txtpharmacyName.Text = medicationTime.ExtraField4;
ddlStatus.SelectedValue = medicationTime.ExtraField6 != null ? medicationTime.ExtraField6 : "Active";
//chkAddDischargeRecord.Checked=bool.Parse(medicationTime.ExtraField5);
}
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;
}
private void showMedicationTimeGrid()
{
gvMedicationTime.DataSource = MedicationTimeManager.GetAllMedicationTimes();
gvMedicationTime.DataBind();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (txtNewMedicine.Text != "")
{
Medicine medicine = new Medicine();
medicine.MedicineName = txtNewMedicine.Text;
medicine.MedicineID = MedicineManager.InsertMedicine(medicine);
loadMedicine();
ddlMedicine.SelectedValue = medicine.MedicineID.ToString();
}
if (hfMedicationTimeID.Value == "0")
{
//if (!txtTakingTime.Text.Contains(","))
//{
// txtTakingTime.Text = txtTakingTime.Text + ",";
//}
//foreach (string item in txtTakingTime.Text.Split(','))
//{
// if (item != "")
// {
MedicationTime medicationTime = new MedicationTime();
medicationTime.TakingTime = chkPRN.Checked ? "PRN" : txtTakingTime.Text;
medicationTime.MedicineID = Int32.Parse(ddlMedicine.SelectedValue);
medicationTime.ResidentID = Int32.Parse(Request.QueryString["ResidentID"]);
medicationTime.Quantity = txtQuantity.Text;
medicationTime.Quality = txtQuality.Text;
medicationTime.Frequency = txtFrequency.Text;
medicationTime.ExtraField1 = txtEXNo.Text;
medicationTime.ExtraField2 = ddlRouteOfAdmin.SelectedValue;
medicationTime.ExtraField3 = txtAmount.Text;
medicationTime.ExtraField4 = txtpharmacyName.Text;
medicationTime.ExtraField5 = chkAddDischargeRecord.Checked.ToString();
medicationTime.ExtraField6 = ddlStatus.SelectedValue;
medicationTime.ExtraField7 = "";
medicationTime.ExtraField8 = "";
medicationTime.ExtraField9 = "";
medicationTime.ExtraField10 = "";
medicationTime.AddedBy = getLogin().LoginID;
medicationTime.AddedDate = DateTime.Now;
medicationTime.UpdateBy = getLogin().LoginID;
medicationTime.UpdateDate = DateTime.Now;
int resutl = MedicationTimeManager.InsertMedicationTime(medicationTime);
lblNewMedicationAddedSuccessfully.Text = "Added Successfully";
// }
//}
}
else
{
MedicationTime medicationTime = new MedicationTime();
medicationTime.MedicationTimeID = int.Parse(hfMedicationTimeID.Value);
medicationTime.TakingTime = chkPRN.Checked ? "PRN" : txtTakingTime.Text;
medicationTime.MedicineID = Int32.Parse(ddlMedicine.SelectedValue);
medicationTime.ResidentID = Int32.Parse(Request.QueryString["ResidentID"]);
medicationTime.Quantity = txtQuantity.Text;
medicationTime.Quality = txtQuality.Text;
medicationTime.Frequency = txtFrequency.Text;
medicationTime.ExtraField1 = txtEXNo.Text;
medicationTime.ExtraField2 = ddlRouteOfAdmin.SelectedValue;
medicationTime.ExtraField3 = txtAmount.Text;
medicationTime.ExtraField4 = txtpharmacyName.Text;
medicationTime.ExtraField5 = chkAddDischargeRecord.Checked.ToString();
medicationTime.ExtraField6 = ddlStatus.SelectedValue;
medicationTime.ExtraField7 = "";
medicationTime.ExtraField8 = "";
medicationTime.ExtraField9 = "";
medicationTime.ExtraField10 = "";
medicationTime.AddedBy = getLogin().LoginID;
medicationTime.AddedDate = DateTime.Now;
medicationTime.UpdateBy = getLogin().LoginID;
medicationTime.UpdateDate = DateTime.Now;
MedicationTimeManager.UpdateMedicationTime(medicationTime);
hfMedicationTimeID.Value = "0";
lblNewMedicationAddedSuccessfully.Text = "Update Successfully";
}
lblMsg.Visible = false;
lblNewMedicationAddedSuccessfully.Visible = true;
//ddlMedicine.SelectedValue = "0";
//txtTakingTime.Text = "";
//txtQuality.Text = "";
//txtQuantity.Text = "";
//txtFrequency.Text = "";
loadGrid();
}
