protected void ddlPatientName_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlPatientName.SelectedIndex > 0)
{
tblPatientMaster obj = new PatientMasterBLL().GetPatientbyId(Convert.ToInt32(ddlPatientName.SelectedValue));
if (Convert.ToBoolean(obj.IsDeath))
{
lblMsg.Text = "This patient can not be re-admitted. This patient is already passed away.";
ddlPatientName.SelectedIndex = 0;
}
else
{
if (obj.BirthDate != null)
{
lblDOB.Text = obj.BirthDate.Value.ToShortDateString();
txtAge.Text = Convert.ToString(DateTime.Now.Date.Year - obj.BirthDate.Value.Year);
ddlAge.Text = obj.AgeIn;
txtWeight.Text = Convert.ToString(obj.Weight);
}
else
{
txtAge.Text = Convert.ToString(obj.Age);
ddlAge.Text = obj.AgeIn;
txtWeight.Text = Convert.ToString(obj.Weight);
//lblDOB.Text = obj.BirthDate.Value.ToShortDateString();
}
}
}
}
protected void ddlPatient_SelectedIndexChanged(object sender, EventArgs e)
{
int Val = Convert.ToInt32(ddlPatient.SelectedValue);
EntityPatientMaster objTxt = new PatientMasterBLL().GetDischargeOnDiadnosis(Val);
txtDiagnosis.Text = objTxt.Dignosys;
}
protected void ddlCategoryName_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
PatientMasterBLL mobjPatient = new PatientMasterBLL();
int linReligionId = Convert.ToInt32(ddlCategoryName.SelectedValue);
DataTable ldt = new DataTable();
ldt = mobjPatient.GetDeptVisitDoctors(linReligionId);
if (ldt.Rows.Count > 0 && ldt != null)
{
ddlConsultDoctor.DataSource = ldt;
ddlConsultDoctor.DataValueField = "DocAllocId";
ddlConsultDoctor.DataTextField = "EmpName";
ddlConsultDoctor.DataBind();
FillDeptDoctorCast();
//ddlDeptDoctor.Enabled = true;
}
else
{
//ddlDeptDoctor.Enabled = false;
}
}
catch (Exception ex)
{
//lblMsg.Text = ex.Message;
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
lbl.Text = "Patient Ledger";
lblFrom.Text = ddlPatient.SelectedItem.Text;
lblTo.Text = string.Format("{0:dd-MMM-yyyy}", DateTime.Now);
lblMessage.Text = string.Empty;
List<tblCustomerTransaction> lst = new CustomerTransactionBLL().GetPatientTransByPatientId(Convert.ToInt32(ddlPatient.SelectedValue));
EntityPatientMaster objPatient = new PatientMasterBLL().GetPatientDetailsByPatientId(Convert.ToInt32(ddlPatient.SelectedValue));
if (objPatient != null)
{
lblAge.Text = Convert.ToString(objPatient.Age);
MRN.Text = Convert.ToString(objPatient.PatientCode);
lblSex.Text = Convert.ToString(objPatient.GenderDesc);
lblBloodGroup.Text = Convert.ToString(objPatient.BloodGroup);
}
tblCustomerTransaction obj = new tblCustomerTransaction() { };
lst.Add(obj);
tblCustomerTransaction objBills = new tblCustomerTransaction()
{
TransactionType = "Total Invoices Amt",
BillAmount = Convert.ToDecimal(lst.Sum(p => p.BillAmount))
};
lst.Add(objBills);
tblCustomerTransaction objReceived = new tblCustomerTransaction()
{
TransactionType = "Total Received",
PayAmount = Convert.ToDecimal(lst.Sum(p => p.PayAmount)) + Convert.ToDecimal(lst.Sum(p => p.AdvanceAmount))
};
lst.Add(objReceived);
tblCustomerTransaction objFinal = new tblCustomerTransaction()
{
TransactionType = "Balance(+)/Refund(-) Amt",
BillAmount = objBills.BillAmount - objReceived.PayAmount
};
lst.Add(objFinal);
dgvTestParameter.DataSource = lst;
dgvTestParameter.DataBind();
Session["PatientLedg"] = ListConverter.ToDataTable(lst);
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
protected void BtnEdit_Click(object sender, EventArgs e)
{
int lintCnt = 0;
try
{
EntityBedAllocToPatient entDept = new EntityBedAllocToPatient();
entDept.BedId = Convert.ToInt32(Session["Bed_Id"]);
entDept.FloorId = Convert.ToInt32(Session["Floor_Id"]);
entDept.RoomId = Convert.ToInt32(Session["Room_Id"]);
entDept.PatientId = Convert.ToInt32(Session["Pat_Id"]);
if (!string.IsNullOrEmpty(txtAllocDate.Text))
{
entDept.AllocationDate = Convert.ToDateTime(txtAllocDate.Text);
}
else
{
entDept.AllocationDate = null;
}
PatientMasterBLL mobjPatient = new PatientMasterBLL();
EntityPatientAdmit entAdmit = new EntityPatientAdmit()
{
PatientId = Convert.ToInt32(ddlPatientName.SelectedValue)
};
bool Status = mobjPatient.CheckPatientAlreadyAllocated(entAdmit);
if (!Status)
{
lintCnt = mobjDeptBLL.InsertAllocBed(entDept);
if (lintCnt > 0)
{
lblMessage.Text = "Record Updated Successfully";
}
else
{
lblMessage.Text = "Record Not Updated";
}
}
else
{
lblMessage.Text = "This Patient Already Allocated to Another Bed";
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
GetBedAlloc();
MultiView1.SetActiveView(View1);
}
protected void ddlDeptCategory_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
int linCategoryId = Convert.ToInt32(ddlDeptCategory.SelectedValue);
EntityPatientMaster objTxt = new PatientMasterBLL().GetDeptDoctor(Convert.ToInt32(ddlDeptCategory.SelectedValue));
txtDeptCat.Text = objTxt.FullName;
BindPatientList(linCategoryId);
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
ImageButton imgEdit = (ImageButton)sender;
GridViewRow cnt = (GridViewRow)imgEdit.NamingContainer;
DataTable dt = new PatientMasterBLL().GetPatientDetail(cnt.Cells[0].Text);
Session["Patient_Details"] = dt;
Session["EDIT"] = true;
Response.Redirect("~/frmOPDPatient.aspx");
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
private void SelectPatientHistory()
{
try
{
PatientMasterBLL PatHist = new PatientMasterBLL();
List <EntityInvoiceDetails> lst = PatHist.ShowPatientHistory();
if (lst != null)
{
dgvTestParameter.DataSource = lst;
dgvTestParameter.DataBind();
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
private void SearchPatientHistory(string Prefix)
{
try
{
PatientMasterBLL objOPDPatient = new PatientMasterBLL();
List <EntityInvoiceDetails> lst = objOPDPatient.SearchForPatientHistory(Prefix);
if (lst != null)
{
dgvTestParameter.DataSource = lst;
dgvTestParameter.DataBind();
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
//public void BindPatientList()
//{
// try
// {
// List<EntityPatientAdmit> lst = MobjClaim.GetPatientList();
// ddlPatient.DataSource = lst;
// lst.Insert(0, new EntityPatientAdmit() { AdmitId = 0, PatientFirstName = "--Select--" });
// ddlPatient.DataValueField = "AdmitId";
// ddlPatient.DataTextField = "PatientFirstName";
// ddlPatient.DataBind();
// }
// catch (Exception ex)
// {
// lblMessage.Text = ex.Message;
// }
//}
//protected void ddlPatient_SelectedIndexChanged(object sender, EventArgs e)
//{
// if (ddlPatient.SelectedIndex>0)
// {
// EntityPatientAlloc objTxt = new PatientAllocDocBLL().GetPatientType(Convert.ToInt32(ddlPatient.SelectedValue));
// CalDate.StartDate = objTxt.AdmitDate;
// }
//}
protected void ddlNurseName_SelectedIndexChanged(object sender, EventArgs e)
{
PatientMasterBLL mobjPatient = new PatientMasterBLL();
string dept = string.Empty;
if (ddlNurseName.SelectedIndex > 0)
{
txtDepartment.Text = Convert.ToString(MobjClaim.GetConsultCharge(Convert.ToInt32(ddlNurseName.SelectedValue)));
dept = txtDepartment.Text;
List <EntityPatientAdmit> lst = MobjClaim.GetPatientList(dept);
ddlPatient.DataSource = lst;
lst.Insert(0, new EntityPatientAdmit()
{
AdmitId = 0, PatientFirstName = "--Select--"
});
ddlPatient.DataValueField = "AdmitId";
ddlPatient.DataTextField = "PatientFirstName";
ddlPatient.DataBind();
}
}
public void GetDeptCategory()
{
try
{
PatientMasterBLL mobjPatient = new PatientMasterBLL();
DataTable ldt = new DataTable();
ldt = mobjPatient.GetDeptCategory();
ddlDeptCategory.DataSource = ldt;
ddlDeptCategory.DataValueField = "CategoryId";
ddlDeptCategory.DataTextField = "CategoryName";
ddlDeptCategory.DataBind();
ListItem li = new ListItem();
li.Text = "--Select DeptCategory--";
li.Value = "0";
ddlDeptCategory.Items.Insert(0, li);
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
protected void dgvPatientList_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
DataTable ldt = new DataTable();
GridViewRow gvr = (GridViewRow)((Control)e.CommandSource).NamingContainer;
if (e.CommandName == "DownloadEndoscopy")
{
ImageButton imgEdit = (ImageButton)sender;
GridViewRow cnt = (GridViewRow)imgEdit.NamingContainer;
DataTable dt = new PatientMasterBLL().GetPatientDetail(cnt.Cells[0].Text);
string lintPKId = dt.Rows[0]["PatientCode"].ToString();
ldt = new PatientMasterBLL().GetPatientDetail(lintPKId);
if (ldt.Rows.Count > 0 && ldt != null)
{
Response.Clear();
Byte[] sBytes = (Byte[])ldt.Rows[0]["EndoscopyFile"];
MemoryStream ms = new MemoryStream(sBytes);
Response.Charset = "";
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=Endoscopy.pdf");
Response.Buffer = true;
ms.WriteTo(Response.OutputStream);
Response.BinaryWrite(sBytes);
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.End();
}
}
if (e.CommandName == "DownloadAudiometry")
{
ImageButton imgEdit = (ImageButton)sender;
GridViewRow cnt = (GridViewRow)imgEdit.NamingContainer;
DataTable dt = new PatientMasterBLL().GetPatientDetail(cnt.Cells[0].Text);
string lintPKId = dt.Rows[0]["PatientCode"].ToString();
ldt = new PatientMasterBLL().GetPatientDetail(lintPKId);
if (ldt.Rows.Count > 0 && ldt != null)
{
Response.Clear();
Byte[] sBytes = (Byte[])ldt.Rows[0]["AudiometryFile"];
MemoryStream ms = new MemoryStream(sBytes);
Response.Charset = "";
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=Audiometry.pdf");
Response.Buffer = true;
ms.WriteTo(Response.OutputStream);
Response.BinaryWrite(sBytes);
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.End();
}
}
}
catch (System.Threading.ThreadAbortException)
{
}
}
protected void IsCash_CheckedChanged(object sender, EventArgs e)
{
if (IsCash.Checked)
{
CheckList(false);
}
if (IsCheque.Checked && ddlPatientCategory.SelectedItem.Text == "Self")
{
CheckList(true);
ddlCompany.Visible = false;
lblCompanyName.Visible = false;
lblBankRefNo.Visible = false;
txtBankRefNo.Visible = false;
}
else if (IsCheque.Checked && ddlPatientCategory.SelectedItem.Text == "Company")
{
PatientMasterBLL mobjPatient = new PatientMasterBLL();
CheckList(true);
lblBankRefNo.Visible = false;
txtBankRefNo.Visible = false;
DataTable ldt = new DataTable();
ldt = mobjPatient.GetCompaniesId();
ddlCompany.DataSource = ldt;
ddlCompany.DataValueField = "PKId";
ddlCompany.DataTextField = "CompanyName";
ddlCompany.DataBind();
ListItem li = new ListItem();
li.Text = "--Select Company--";
li.Value = "0";
ddlCompany.Items.Insert(0, li);
}
else if (IsCheque.Checked && ddlPatientCategory.SelectedItem.Text == "Insurance")
{
PatientMasterBLL mobjPatient = new PatientMasterBLL();
CheckList(true);
lblBankRefNo.Visible = false;
txtBankRefNo.Visible = false;
DataTable ldt = new DataTable();
ldt = mobjPatient.GetInsuranceCompaniesId();
ddlCompany.DataSource = ldt;
ddlCompany.DataValueField = "PKId";
ddlCompany.DataTextField = "InsuranceDesc";
ddlCompany.DataBind();
ListItem li = new ListItem();
li.Text = "--Select Company--";
li.Value = "0";
ddlCompany.Items.Insert(0, li);
}
if (IsCard.Checked && ddlPatientCategory.SelectedItem.Text == "Self")
{
CheckList(true);
lblChequeDate.Visible = false;
lblchequeNo.Visible = false;
lblBankName.Visible = false;
txtChequeDate.Visible = false;
txtChequeNo.Visible = false;
txtBankName.Visible = false;
ddlCompany.Visible = false;
lblCompanyName.Visible = false;
}
else if (IsCard.Checked && ddlPatientCategory.SelectedItem.Text == "Company")
{
PatientMasterBLL mobjPatient = new PatientMasterBLL();
CheckList(true);
lblChequeDate.Visible = false;
lblchequeNo.Visible = false;
lblBankName.Visible = false;
txtChequeDate.Visible = false;
txtChequeNo.Visible = false;
txtBankName.Visible = false;
DataTable ldt = new DataTable();
ldt = mobjPatient.GetCompaniesId();
ddlCompany.DataSource = ldt;
ddlCompany.DataValueField = "PKId";
ddlCompany.DataTextField = "CompanyName";
ddlCompany.DataBind();
ListItem li = new ListItem();
li.Text = "--Select Company--";
li.Value = "0";
ddlCompany.Items.Insert(0, li);
}
else if (IsCard.Checked && ddlPatientCategory.SelectedItem.Text == "Insurance")
{
PatientMasterBLL mobjPatient = new PatientMasterBLL();
CheckList(true);
lblChequeDate.Visible = false;
lblchequeNo.Visible = false;
lblBankName.Visible = false;
txtChequeDate.Visible = false;
txtChequeNo.Visible = false;
txtBankName.Visible = false;
DataTable ldt = new DataTable();
ldt = mobjPatient.GetInsuranceCompaniesId();
ddlCompany.DataSource = ldt;
ddlCompany.DataValueField = "PKId";
ddlCompany.DataTextField = "InsuranceDesc";
ddlCompany.DataBind();
ListItem li = new ListItem();
li.Text = "--Select Company--";
li.Value = "0";
ddlCompany.Items.Insert(0, li);
}
if (IsRTGS.Checked && ddlPatientCategory.SelectedItem.Text == "Self")
{
CheckList(true);
lblChequeDate.Visible = false;
lblchequeNo.Visible = false;
lblBankName.Visible = false;
txtChequeDate.Visible = false;
txtChequeNo.Visible = false;
txtBankName.Visible = false;
ddlCompany.Visible = false;
lblCompanyName.Visible = false;
}
else if (IsRTGS.Checked && ddlPatientCategory.SelectedItem.Text == "Company")
{
PatientMasterBLL mobjPatient = new PatientMasterBLL();
CheckList(true);
lblChequeDate.Visible = false;
lblchequeNo.Visible = false;
lblBankName.Visible = false;
txtChequeDate.Visible = false;
txtChequeNo.Visible = false;
txtBankName.Visible = false;
DataTable ldt = new DataTable();
ldt = mobjPatient.GetCompaniesId();
ddlCompany.DataSource = ldt;
ddlCompany.DataValueField = "PKId";
ddlCompany.DataTextField = "CompanyName";
ddlCompany.DataBind();
ListItem li = new ListItem();
li.Text = "--Select Company--";
li.Value = "0";
ddlCompany.Items.Insert(0, li);
}
else if (IsRTGS.Checked && ddlPatientCategory.SelectedItem.Text == "Insurance")
{
PatientMasterBLL mobjPatient = new PatientMasterBLL();
CheckList(true);
lblChequeDate.Visible = false;
lblchequeNo.Visible = false;
lblBankName.Visible = false;
txtChequeDate.Visible = false;
txtChequeNo.Visible = false;
txtBankName.Visible = false;
DataTable ldt = new DataTable();
ldt = mobjPatient.GetInsuranceCompaniesId();
ddlCompany.DataSource = ldt;
ddlCompany.DataValueField = "PKId";
ddlCompany.DataTextField = "InsuranceDesc";
ddlCompany.DataBind();
ListItem li = new ListItem();
li.Text = "--Select Company--";
li.Value = "0";
ddlCompany.Items.Insert(0, li);
}
}
