private void SelectBedConsumtion()
{
try
{
BedConsumtionBLL consume = new BedConsumtionBLL();
List <STP_AdmitedPatientListReportResult> lst = consume.AdmitedPatientListReport(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text));
if (lst != null)
{
lbl.Text = "Admited Patient List Report";
lblFrom.Text = txtBillDate.Text;
lblTo.Text = txtToDate.Text;
DataTable dt = ListConverter.ToDataTable(lst);
dt.Columns.Add("colSrNo");
DataColumn dcol = new DataColumn();
if (dt.Rows.Count > 0)
{
int count = 1;
foreach (DataRow dr in dt.Rows)
{
dr["colSrNo"] = count;
count++;
}
}
dgvTestParameter.DataSource = dt;
dgvTestParameter.DataBind();
Session["BedConsump"] = dt;
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
private void SelectBedConsumtion()
{
try
{
BedConsumtionBLL consume = new BedConsumtionBLL();
//if (ddlEmployee.SelectedIndex > 0)
//{
lbl.Text = "Summarized Report";
//IPD Sale(Discharge Patient) :-
decimal invCash = consume.GetCashInvoiceDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text));
decimal RecCash = consume.GetRecCashDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text));
txtCash.Text = string.Format("{0:0.00}", invCash + RecCash);
txtCheque.Text = string.Format("{0:0.00}", consume.GetRecChequeDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtCard.Text = string.Format("{0:0.00}", consume.GetRecCardDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtRTGS.Text = string.Format("{0:0.00}", consume.GetRecRTGSDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtTotal.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtCash.Text) + Convert.ToDecimal(txtCheque.Text) + Convert.ToDecimal(txtCard.Text) + Convert.ToDecimal(txtRTGS.Text));
txtDiscountIPD.Text = string.Format("{0:0.00}", consume.GetIPDDiscountInvoiceDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
//OPD Sale(Consulting/Treatments/Daycare) :-
decimal invCash1 = consume.GetOPDCashInvoiceDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text));
decimal RecCash1 = consume.GetOPDRecCashDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text));
txtCash1.Text = string.Format("{0:0.00}", invCash1 + RecCash1);
txtCheque1.Text = string.Format("{0:0.00}", consume.GetOPDRecChequeDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtCard1.Text = string.Format("{0:0.00}", consume.GetOPDRecCardDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtRTGS1.Text = string.Format("{0:0.00}", consume.GetOPDRecRTGSDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtTotal1.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtCash1.Text) + Convert.ToDecimal(txtCheque1.Text) + Convert.ToDecimal(txtCard1.Text) + Convert.ToDecimal(txtRTGS1.Text));
txtDiscountOPD.Text = string.Format("{0:0.00}", consume.GetOPDDiscountInvoiceDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
//IPD Advanced Received :-
txtCash2.Text = string.Format("{0:0.00}", consume.GetIPDAdvanceRecCashDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtCheque2.Text = string.Format("{0:0.00}", consume.GetIPDAdvanceRecChequeDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtCard2.Text = string.Format("{0:0.00}", consume.GetIPDAdvanceRecCardDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtRTGs2.Text = string.Format("{0:0.00}", consume.GetIPDAdvanceRecRTGSDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtTotal2.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtCash2.Text) + Convert.ToDecimal(txtCheque2.Text) + Convert.ToDecimal(txtCard2.Text) + Convert.ToDecimal(txtRTGs2.Text));
//IPD OPD Registration Fees :-
txtRegFeeIPD.Text = string.Format("{0:0.00}", consume.GetIPDRegFeeInvoiceDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtRegFeeOPD.Text = string.Format("{0:0.00}", consume.GetOPDRegFeeInvoiceDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtTotalReg.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtRegFeeIPD.Text) + Convert.ToDecimal(txtRegFeeOPD.Text));
//IPD Refund Amount :-
txtIPDCashRefund.Text = string.Format("{0:0.00}", consume.GetIPDCashRefundDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtIPDChequeRefund.Text = string.Format("{0:0.00}", consume.GetIPDChequeRefundDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtIPDCardRefund.Text = string.Format("{0:0.00}", consume.GetIPDCardRefundDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtIPDRTGSRefund.Text = string.Format("{0:0.00}", consume.GetIPDRTGSRefundDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtIPDTotalRefund.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtIPDCashRefund.Text) + Convert.ToDecimal(txtIPDChequeRefund.Text) + Convert.ToDecimal(txtIPDCardRefund.Text) + Convert.ToDecimal(txtIPDRTGSRefund.Text));
//OPD Refund Amount :-
txtOPDCashRefund.Text = string.Format("{0:0.00}", consume.GetOPDCashRefundDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtOPDChequeRefund.Text = string.Format("{0:0.00}", consume.GetOPDChequeRefundDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtOPDCardRefund.Text = string.Format("{0:0.00}", consume.GetOPDCardRefundDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtOPDRTGSRefund.Text = string.Format("{0:0.00}", consume.GetOPDRTGSRefundDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtOPDTotalRefund.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtOPDCashRefund.Text) + Convert.ToDecimal(txtOPDChequeRefund.Text) + Convert.ToDecimal(txtOPDCardRefund.Text) + Convert.ToDecimal(txtOPDRTGSRefund.Text));
//Credit (Bill Pending)Amount :-
txtCreditAmt.Text = string.Format("{0:0.00}", consume.GetCreditAmtDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
//Total Collection IPD OPD
txtTotalCash.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtCash.Text) + Convert.ToDecimal(txtCash1.Text) + Convert.ToDecimal(txtCash2.Text));
txtTotalCheque.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtCheque.Text) + Convert.ToDecimal(txtCheque1.Text) + Convert.ToDecimal(txtCheque2.Text));
txtTotalCard.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtCard.Text) + Convert.ToDecimal(txtCard1.Text) + Convert.ToDecimal(txtCard2.Text));
txtTotalRTGS.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtRTGS.Text) + Convert.ToDecimal(txtRTGS1.Text) + Convert.ToDecimal(txtRTGs2.Text));
txtTotalAmt.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtTotalCash.Text) + Convert.ToDecimal(txtTotalCheque.Text) + Convert.ToDecimal(txtTotalCard.Text) + Convert.ToDecimal(txtTotalRTGS.Text));
// Insurance Claim Approval Amount
txtCashInsurance.Text = string.Format("{0:0.00}", consume.GetInsuranceCashClaimDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtChequeInsurance.Text = string.Format("{0:0.00}", consume.GetInsuranceChequeClaimDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtCardInsurance.Text = string.Format("{0:0.00}", consume.GetInsuranceCardClaimDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtRTGSInsurance.Text = string.Format("{0:0.00}", consume.GetInsuranceRTGSClaimDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtInsuranceTotal.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtCashInsurance.Text) + Convert.ToDecimal(txtChequeInsurance.Text) + Convert.ToDecimal(txtCardInsurance.Text) + Convert.ToDecimal(txtRTGSInsurance.Text));
// Company Claim Approval Amount
txtCashCompany.Text = string.Format("{0:0.00}", consume.GetCompanyCashClaimDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtChequeCompany.Text = string.Format("{0:0.00}", consume.GetCompanyChequeClaimDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtCardCompany.Text = string.Format("{0:0.00}", consume.GetCompanyCardClaimDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtRTGSCompany.Text = string.Format("{0:0.00}", consume.GetCompanyRTGSClaimDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)));
txtCompanyTotal.Text = string.Format("{0:0.00}", Convert.ToDecimal(txtCashCompany.Text) + Convert.ToDecimal(txtChequeCompany.Text) + Convert.ToDecimal(txtCardCompany.Text) + Convert.ToDecimal(txtRTGSCompany.Text));
//}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
private void SelectBedConsumtion()
{
try
{
BedConsumtionBLL consume = new BedConsumtionBLL();
if (ddlServices.SelectedIndex == 0 && ddlEmployee.SelectedIndex == 0)
{
List <STP_ServiceswiseReportAllResult> lst = consume.NewAllServices(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text));
if (lst != null)
{
lbl.Text = "New Services Datewise Report";
lblFrom.Text = txtBillDate.Text;
lblTo.Text = txtToDate.Text;
DataTable dt = ListConverter.ToDataTable(lst);
dt.Columns.Add("colSrNo");
DataColumn dcol = new DataColumn();
if (dt.Rows.Count > 0)
{
int count = 1;
foreach (DataRow dr in dt.Rows)
{
dr["colSrNo"] = count;
count++;
}
}
dgvTestParameter.DataSource = dt;
dgvTestParameter.DataBind();
Session["BedConsump"] = dt;
lblamount.Visible = true;
txtamount.Visible = true;
decimal amt = 0;
foreach (GridViewRow item in dgvTestParameter.Rows)
{
if (item.Cells[7].Text == " ")
{
item.Cells[7].Text = Convert.ToString(0);
amt = amt + Convert.ToDecimal(item.Cells[7].Text);
}
else
{
amt = amt + Convert.ToDecimal(item.Cells[7].Text);
}
}
txtamount.Text = Convert.ToString(amt);
//txtBillDate.Text = string.Empty;
//txtToDate.Text = string.Empty;
}
}
if (ddlEmployee.SelectedIndex == 0 && ddlServices.SelectedIndex != 0)
{
List <STP_ServiceswiseReportResult> lst = consume.SearchServicewiseReport(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToString(ddlServices.SelectedItem.Text));
if (lst != null)
{
lbl.Text = "New Serviceswise Report";
lblFrom.Text = txtBillDate.Text;
lblTo.Text = txtToDate.Text;
DataTable dt = ListConverter.ToDataTable(lst);
dt.Columns.Add("colSrNo");
DataColumn dcol = new DataColumn();
if (dt.Rows.Count > 0)
{
int count = 1;
foreach (DataRow dr in dt.Rows)
{
dr["colSrNo"] = count;
count++;
}
}
dgvTestParameter.DataSource = dt;
dgvTestParameter.DataBind();
Session["BedConsump"] = dt;
lblamount.Visible = true;
txtamount.Visible = true;
decimal amt = 0;
foreach (GridViewRow item in dgvTestParameter.Rows)
{
if (item.Cells[7].Text == " ")
{
item.Cells[7].Text = Convert.ToString(0);
amt = amt + Convert.ToDecimal(item.Cells[7].Text);
}
else
{
amt = amt + Convert.ToDecimal(item.Cells[7].Text);
}
}
txtamount.Text = Convert.ToString(amt);
//txtBillDate.Text = string.Empty;
//txtToDate.Text = string.Empty;
}
}
if (ddlEmployee.SelectedIndex != 0 && ddlServices.SelectedIndex == 0)
{
List <STP_ServiceswiseReportUserResult> lst = consume.SearchServicewiseReportUser(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToString(ddlEmployee.SelectedItem.Text));
if (lst != null)
{
lbl.Text = "New Services Userwise Report";
lblFrom.Text = txtBillDate.Text;
lblTo.Text = txtToDate.Text;
DataTable dt = ListConverter.ToDataTable(lst);
dt.Columns.Add("colSrNo");
DataColumn dcol = new DataColumn();
if (dt.Rows.Count > 0)
{
int count = 1;
foreach (DataRow dr in dt.Rows)
{
dr["colSrNo"] = count;
count++;
}
}
dgvTestParameter.DataSource = dt;
dgvTestParameter.DataBind();
Session["BedConsump"] = dt;
lblamount.Visible = true;
txtamount.Visible = true;
decimal amt = 0;
foreach (GridViewRow item in dgvTestParameter.Rows)
{
if (item.Cells[7].Text == " ")
{
item.Cells[7].Text = Convert.ToString(0);
amt = amt + Convert.ToDecimal(item.Cells[7].Text);
}
else
{
amt = amt + Convert.ToDecimal(item.Cells[7].Text);
}
}
txtamount.Text = Convert.ToString(amt);
//txtBillDate.Text = string.Empty;
//txtToDate.Text = string.Empty;
}
}
if (ddlEmployee.SelectedIndex != 0 && ddlServices.SelectedIndex != 0)
{
List <STP_ServiceswiseReportUserSerResult> lst = consume.SearchServicewiseReportUserSer(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text),
Convert.ToString(ddlEmployee.SelectedItem.Text), Convert.ToString(ddlServices.SelectedItem.Text));
if (lst != null)
{
lbl.Text = "New Services Userwise Report";
lblFrom.Text = txtBillDate.Text;
lblTo.Text = txtToDate.Text;
DataTable dt = ListConverter.ToDataTable(lst);
dt.Columns.Add("colSrNo");
DataColumn dcol = new DataColumn();
if (dt.Rows.Count > 0)
{
int count = 1;
foreach (DataRow dr in dt.Rows)
{
dr["colSrNo"] = count;
count++;
}
}
dgvTestParameter.DataSource = dt;
dgvTestParameter.DataBind();
Session["BedConsump"] = dt;
lblamount.Visible = true;
txtamount.Visible = true;
decimal amt = 0;
foreach (GridViewRow item in dgvTestParameter.Rows)
{
if (item.Cells[7].Text == " ")
{
item.Cells[7].Text = Convert.ToString(0);
amt = amt + Convert.ToDecimal(item.Cells[7].Text);
}
else
{
amt = amt + Convert.ToDecimal(item.Cells[7].Text);
}
}
txtamount.Text = Convert.ToString(amt);
//txtBillDate.Text = string.Empty;
//txtToDate.Text = string.Empty;
}
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
private void SelectBedConsumtion()
{
try
{
BedConsumtionBLL consume = new BedConsumtionBLL();
if (ddlDepartment.SelectedIndex == 0)
{
List <STP_DailyNursingChartResult> lst = consume.SearchDailyChart(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text));
if (lst != null)
{
lbl.Text = "Daily Nursing Chart Report";
lblFrom.Text = txtBillDate.Text;
lblTo.Text = txtToDate.Text;
DataTable dt = ListConverter.ToDataTable(lst);
dt.Columns.Add("colSrNo");
DataColumn dcol = new DataColumn();
if (dt.Rows.Count > 0)
{
int count = 1;
foreach (DataRow dr in dt.Rows)
{
dr["colSrNo"] = count;
count++;
}
}
dgvTestParameter.DataSource = dt;
dgvTestParameter.DataBind();
Session["BedConsump"] = dt;
//txtBillDate.Text = string.Empty;
//txtToDate.Text = string.Empty;
}
}
else
{
List <STP_DailyDepartmentwiseNursingChartResult> lst = consume.SearchDepartmentwiseDailyChart(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToString(ddlDepartment.SelectedItem.Text));
if (lst != null)
{
lbl.Text = "Daily Nursing Chart Report";
lblFrom.Text = txtBillDate.Text;
lblTo.Text = txtToDate.Text;
DataTable dt = ListConverter.ToDataTable(lst);
dt.Columns.Add("colSrNo");
DataColumn dcol = new DataColumn();
if (dt.Rows.Count > 0)
{
int count = 1;
foreach (DataRow dr in dt.Rows)
{
dr["colSrNo"] = count;
count++;
}
}
dgvTestParameter.DataSource = dt;
dgvTestParameter.DataBind();
Session["BedConsump"] = dt;
//txtBillDate.Text = string.Empty;
//txtToDate.Text = string.Empty;
}
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
private void SelectBedConsumtion()
{
try
{
BedConsumtionBLL consume = new BedConsumtionBLL();
if (ddlDeptCategory.SelectedIndex != 0 && ddlDeptDoctor.SelectedIndex == 0 && ddlPatientType.SelectedIndex == 0)
{
List <STP_DeptCategorywisePatientDetailsResult> lst = consume.DeptCategorywisePatientDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToInt32(ddlDeptCategory.SelectedValue));
if (lst != null)
{
lbl.Text = "Patient Details Report";
lblFrom.Text = txtBillDate.Text;
lblTo.Text = txtToDate.Text;
DataTable dt = ListConverter.ToDataTable(lst);
dt.Columns.Add("colSrNo");
DataColumn dcol = new DataColumn();
if (dt.Rows.Count > 0)
{
int count = 1;
foreach (DataRow dr in dt.Rows)
{
dr["colSrNo"] = count;
count++;
}
}
dgvTestParameter.DataSource = dt;
dgvTestParameter.DataBind();
Session["BedConsump"] = dt;
}
}
if (ddlDeptCategory.SelectedIndex != 0 && ddlDeptDoctor.SelectedIndex != 0 && ddlPatientType.SelectedIndex != 0)
{
List <STP_DepartmentwisePatientDetailsResult> lst = consume.SearchDepartmentwise(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToInt32(ddlDeptCategory.SelectedValue), Convert.ToInt32(ddlDeptDoctor.SelectedValue), Convert.ToString(ddlPatientType.SelectedItem.Text));
if (lst != null)
{
lbl.Text = "Patient Details Report";
lblFrom.Text = txtBillDate.Text;
lblTo.Text = txtToDate.Text;
DataTable dt = ListConverter.ToDataTable(lst);
dt.Columns.Add("colSrNo");
DataColumn dcol = new DataColumn();
if (dt.Rows.Count > 0)
{
int count = 1;
foreach (DataRow dr in dt.Rows)
{
dr["colSrNo"] = count;
count++;
}
}
dgvTestParameter.DataSource = dt;
dgvTestParameter.DataBind();
Session["BedConsump"] = dt;
}
}
if (ddlDeptCategory.SelectedIndex != 0 && ddlDeptDoctor.SelectedIndex != 0 && ddlPatientType.SelectedIndex == 0)
{
List <STP_DeptCatDoctorwisePatientDetailsResult> lst = consume.DeptCatDoctorwisePatientDetails(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToInt32(ddlDeptCategory.SelectedValue), Convert.ToInt32(ddlDeptDoctor.SelectedValue));
if (lst != null)
{
lbl.Text = "Patient Details Report";
lblFrom.Text = txtBillDate.Text;
lblTo.Text = txtToDate.Text;
DataTable dt = ListConverter.ToDataTable(lst);
dt.Columns.Add("colSrNo");
DataColumn dcol = new DataColumn();
if (dt.Rows.Count > 0)
{
int count = 1;
foreach (DataRow dr in dt.Rows)
{
dr["colSrNo"] = count;
count++;
}
}
dgvTestParameter.DataSource = dt;
dgvTestParameter.DataBind();
Session["BedConsump"] = dt;
}
}
if (ddlPatientType.SelectedIndex != 0 && ddlDeptCategory.SelectedIndex == 0)
{
List <STP_PatientTypewisePatientDetailsResult> lst = consume.SearchDepartmentwise(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToString(ddlPatientType.SelectedItem.Text));
if (lst != null)
{
lbl.Text = "Departmentwise Patient Details Report";
lblFrom.Text = txtBillDate.Text;
lblTo.Text = txtToDate.Text;
DataTable dt = ListConverter.ToDataTable(lst);
dt.Columns.Add("colSrNo");
DataColumn dcol = new DataColumn();
if (dt.Rows.Count > 0)
{
int count = 1;
foreach (DataRow dr in dt.Rows)
{
dr["colSrNo"] = count;
count++;
}
}
dgvTestParameter.DataSource = dt;
dgvTestParameter.DataBind();
Session["BedConsump"] = dt;
}
}
if (ddlWardCategory.SelectedIndex != 0 && ddlDeptCategory.SelectedIndex == 0 && ddlDeptDoctor.SelectedIndex <= 0 && ddlPatientType.SelectedIndex == 0)
{
List <STP_WardwisePatientDetailsResult> lst = consume.SearchWardwise(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToString(ddlWardCategory.SelectedItem.Text));
if (lst != null)
{
lbl.Text = " Ward Category Wise Patient Details Report";
lblFrom.Text = txtBillDate.Text;
lblTo.Text = txtToDate.Text;
DataTable dt = ListConverter.ToDataTable(lst);
dt.Columns.Add("colSrNo");
DataColumn dcol = new DataColumn();
if (dt.Rows.Count > 0)
{
int count = 1;
foreach (DataRow dr in dt.Rows)
{
dr["colSrNo"] = count;
count++;
}
}
dgvTestParameter.DataSource = dt;
dgvTestParameter.DataBind();
Session["BedConsump"] = dt;
}
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
