protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
Session["Status"] = "Edit";
lblMessage.Text = string.Empty;
ImageButton imgEdit = (ImageButton)sender;
GridViewRow cnt = (GridViewRow)imgEdit.NamingContainer;
Session["TestInvoiceId"] = Convert.ToInt32(cnt.Cells[0].Text);
EntityPatientAdmit entPat = mobjDeptBLL.ChechDischargeDone(Convert.ToInt32(cnt.Cells[0].Text));
if (entPat != null)
{
List <TestAllocation> lst = new clsTestAllocation().GetTestInvoiceDetails(Convert.ToInt32(cnt.Cells[0].Text));
if (cnt != null)
{
ListItem item = ddlPatient.Items.FindByText(Convert.ToString(cnt.Cells[2].Text));
ddlPatient.SelectedValue = item.Value;
txtAllocDate.Text = string.Format("{0:MM/dd/yyyy}", Convert.ToDateTime(cnt.Cells[1].Text));
txtNetAmount.Text = Convert.ToString(cnt.Cells[4].Text);
if (lst.Count > 0)
{
txtDiscountAmt.Text = Convert.ToString(lst[0].DiscountAmount);
txtTotal.Text = Convert.ToString(Convert.ToDecimal(txtNetAmount.Text) + Convert.ToDecimal(txtDiscountAmt.Text));
txtDiscount.Text = string.Format("{0:}", Convert.ToDecimal(txtDiscountAmt.Text) / Convert.ToDecimal(txtTotal.Text) * 100);
}
EntityCustomerTransaction transactionStatus = mobjDeptBLL.GetTransactionStatus(Convert.ToInt32(Session["TestInvoiceId"]));
if (transactionStatus != null)
{
chkIsCash.Checked = Convert.ToBoolean(transactionStatus.IsCash);
}
foreach (TestAllocation objTest in lst)
{
foreach (GridViewRow row in dgvAllTests.Rows)
{
if (Convert.ToInt32(dgvAllTests.DataKeys[row.RowIndex].Value) == objTest.TestId)
{
CheckBox chk = (CheckBox)row.FindControl("chkSelect");
chk.Checked = true;
break;
}
}
}
}
BtnUpdate.Visible = true;
BtnSave.Visible = false;
MultiView1.SetActiveView(View1);
}
else
{
lblMsg.Text = "Patient Is Already Discharged";
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
tblCompanyClaim tblins = new tblCompanyClaim();
tblins.ComClaimId = Convert.ToInt32(Session["ClaimId"]);
tblins.ApprovedAmount = Convert.ToDecimal(txtRecAmount.Text);
tblins.ApprovedDate = Convert.ToDateTime(txtApprovedate.Text);
tblins.TDS = Convert.ToInt32(txtTds.Text);
tblins.BadDebts = Convert.ToDecimal(txtBadDebts.Text);
tblins.CoPayment = Convert.ToDecimal(txtCoPayment.Text);
tblins.TDSAmt = Convert.ToDecimal(txtApprovedamt.Text) * Convert.ToDecimal(txtTds.Text) / 100;
tblins.IsApproved = true;
tblins.AdmitId = Convert.ToInt32(Session["AdmitId"]);
EntityCustomerTransaction objPatient = new EntityCustomerTransaction();
objPatient.PatientId = Convert.ToInt32(Session["AdmitId"]);
objPatient.PayAmount = Convert.ToDecimal(txtRecAmount.Text);
objPatient.BillAmount = Convert.ToDecimal(txtRecAmount.Text);
objPatient.ReceiptDate = Convert.ToDateTime(txtApprovedate.Text);
objPatient.TDSAmt = Convert.ToDecimal(txtApprovedamt.Text) * Convert.ToDecimal(txtTds.Text) / 100;
objPatient.TransactionDocNo = Convert.ToInt32(Session["ClaimId"]);
EntityCustomerTransaction objBank = null;
if (IsNeft.Checked || IsCheque.Checked)
{
objBank = new EntityCustomerTransaction();
objBank.TransactionDocNo = Convert.ToInt32(Session["ClaimId"]);
objBank.BankRefNo = Convert.ToString(txtBankRefNo.Text);
objBank.PatientId = 0;
objBank.ChequeDate = Convert.ToDateTime(txtApprovedate.Text);
objBank.BillAmount = Convert.ToDecimal(txtRecAmount.Text);
objBank.PayAmount = Convert.ToDecimal(txtRecAmount.Text);
objBank.TDSAmt = Convert.ToDecimal(txtApprovedamt.Text) * Convert.ToDecimal(txtTds.Text) / 100;
objBank.ReceiptDate = Convert.ToDateTime(txtApprovedate.Text);
if (IsCheque.Checked)
{
objBank.BankName = txtBankName.Text;
objBank.ChequeNo = txtCheckNo.Text;
}
}
MobjApprove.InsertData(tblins, objPatient, objBank, IsCash.Checked, IsNeft.Checked, IsCheque.Checked);
BindInsuranceClaim();
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
MultiView1.SetActiveView(View1);
}
protected void BtnEdit_Click(object sender, EventArgs e)
{
try
{
tblCustomerTransaction entcust = new tblCustomerTransaction();
entcust.PayAmount = Convert.ToDecimal(txtPayAmount.Text);
entcust.ReceiptNo = Convert.ToInt32(Session["ReceiptNo"]);
entcust.BillAmount = 0;
entcust.IsCash = true;
entcust.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text);
entcust.SupplierId = Convert.ToInt32(ddlSupplier.SelectedValue);
EntityCustomerTransaction transact = null;
if (IsCheque.Checked)
{
entcust.IsCash = false;
entcust.ISCheque = true;
entcust.ReceiptDate = Convert.ToDateTime(txtChequeDate.Text);
entcust.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
entcust.ChequeNo = Convert.ToString(txtChequeNo.Text);
entcust.BankName = Convert.ToString(txtBankName.Text);
transact = new EntityCustomerTransaction();
transact.BankId = Convert.ToInt32(ddlBank.SelectedValue);
transact.ReceiptDate = Convert.ToDateTime(txtChequeDate.Text);
transact.PayAmount = Convert.ToDecimal(txtPayAmount.Text);
transact.ISCheque = true;
transact.BillAmount = 0;
transact.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
transact.ChequeNo = Convert.ToString(txtChequeNo.Text);
transact.BankName = Convert.ToString(txtBankName.Text);
}
else if (RdoCard.Checked)
{
entcust.IsCash = false;
entcust.ISCheque = false;
transact = new EntityCustomerTransaction();
transact.BankId = Convert.ToInt32(ddlBank.SelectedValue);
transact.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text);
transact.PayAmount = Convert.ToDecimal(txtPayAmount.Text);
transact.BillAmount = 0;
}
int i = new CustomerTransactionBLL().UpdateSupplierTransaction(entcust, transact, IsCash.Checked);
GetSupplierTransactionList();
MultiView1.SetActiveView(View2);
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
protected void btnPrint_Click(object sender, EventArgs e)
{
ImageButton imgEdit = (ImageButton)sender;
GridViewRow row = (GridViewRow)imgEdit.NamingContainer;
Session["ReceiptNo"] = Convert.ToInt32(dgvCustTransaction.DataKeys[row.RowIndex].Value);
EntityCustomerTransaction entCust = new EntityCustomerTransaction();
entCust.SupplierName = row.Cells[2].Text;
entCust.ReceiptDate = Convert.ToDateTime(row.Cells[1].Text);
entCust.Address = row.Cells[3].Text;
entCust.Amount = Convert.ToDecimal(row.Cells[4].Text);
Session["SupplierVoucher"] = entCust;
Session["ReportType"] = "SuppReceipt";
Response.Redirect("~/PathalogyReport/PathologyReport.aspx", false);
}
public int Save(EntityCustomerTransaction entCust, bool IsCash)
{
int TransactionId = new PatientInvoiceBLL().GetTransactionId();
int ReceiptNo = GetReceiptNo();
if (IsCash)
{
tblCustomerTransaction objDebit = new tblCustomerTransaction()
{
ReceiptDate = entCust.ReceiptDate,
PatientId = entCust.PatientId,
TransactionId = TransactionId,
TransactionType = "Refund",
TransactionDocNo = ReceiptNo,
IsCash = true,
BillAmount = entCust.BillAmount,
PayAmount = 0,
IsDelete = false,
};
objData.tblCustomerTransactions.InsertOnSubmit(objDebit);
}
else
{
tblCustomerTransaction objDebit = new tblCustomerTransaction()
{
ReceiptDate = entCust.ReceiptDate,
PatientId = entCust.PatientId,
TransactionId = TransactionId,
TransactionType = "Refund",
TransactionDocNo = ReceiptNo,
ISCheque = true,
BillAmount = entCust.BillAmount,
PayAmount = 0,
ChequeDate = entCust.ReceiptDate,
ChequeNo = entCust.ChequeNo,
BankName = entCust.BankName,
IsDelete = false,
};
objData.tblCustomerTransactions.InsertOnSubmit(objDebit);
}
objData.SubmitChanges();
return(1);
}
public EntityCustomerTransaction GetTransactionStatus(int InvoiceNo)
{
EntityCustomerTransaction transact = null;
try
{
transact = (from tbl in objData.tblCustomerTransactions
where tbl.TransactionDocNo == InvoiceNo &&
tbl.IsDelete == false &&
tbl.TransactionType.ToUpper().Equals("TestInvoice".ToUpper())
select new EntityCustomerTransaction {
}).FirstOrDefault();
}
catch (Exception ex)
{
throw ex;
}
return(transact);
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
if (ddlSupplier.SelectedIndex == 0)
{
lblMsg.Text = "Please Select Patient Name";
ddlSupplier.Focus();
return;
}
else
{
if (IsCheque.Checked)
{
if (string.IsNullOrEmpty(txtChequeNo.Text))
{
lblMsg.Text = "Please Enter Cheque Number";
txtChequeNo.Focus();
return;
}
else if (string.IsNullOrEmpty(txtChequeDate.Text))
{
lblMsg.Text = "Please Enter Cheque Date";
txtChequeDate.Focus();
return;
}
else
{
if (string.IsNullOrEmpty(txtBankName.Text))
{
lblMsg.Text = "Please Enter Bank Name";
txtBankName.Focus();
return;
}
}
}
EntityCustomerTransaction entcust = new EntityCustomerTransaction();
EntityCustomerTransaction transact = null;
entcust.SupplierId = Convert.ToInt32(ddlSupplier.SelectedValue);
entcust.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text);
entcust.BillAmount = 0;
entcust.PayAmount = Convert.ToDecimal(txtPayAmount.Text);
entcust.IsCash = true;
if (IsCheque.Checked)
{
entcust.IsCash = false;
entcust.ISCheque = true;
entcust.ReceiptDate = Convert.ToDateTime(txtChequeDate.Text);
entcust.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
entcust.ChequeNo = Convert.ToString(txtChequeNo.Text);
entcust.BankName = Convert.ToString(txtBankName.Text);
transact = new EntityCustomerTransaction();
transact.BankId = Convert.ToInt32(ddlBank.SelectedValue);
transact.ReceiptDate = Convert.ToDateTime(txtChequeDate.Text);
transact.PayAmount = Convert.ToDecimal(txtPayAmount.Text);
transact.ISCheque = true;
transact.BillAmount = 0;
transact.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
transact.ChequeNo = Convert.ToString(txtChequeNo.Text);
transact.BankName = Convert.ToString(txtBankName.Text);
}
else if (RdoCard.Checked)
{
entcust.IsCash = false;
entcust.ISCheque = false;
transact = new EntityCustomerTransaction();
transact.BankId = Convert.ToInt32(ddlBank.SelectedValue);
transact.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text);
transact.PayAmount = Convert.ToDecimal(txtPayAmount.Text);
transact.IsCash = false;
transact.ISCheque = false;
transact.BillAmount = 0;
}
int i = new CustomerTransactionBLL().SaveSupplierTransaction(entcust, transact, IsCash.Checked);
if (i > 0)
{
lblMessage.Text = "Record Saved Successfully";
}
else
{
lblMessage.Text = "Record Not Saved";
}
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
GetSupplierTransactionList();
MultiView1.SetActiveView(View2);
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
if (ddlPatient.SelectedIndex == 0)
{
lblMsg.Text = "Please Select Patient Name";
ddlPatient.Focus();
return;
}
else
{
if ((Convert.ToDecimal(txtPayAmount.Text).CompareTo(Convert.ToDecimal(txtTotal.Text)) == 1) || (Convert.ToDecimal(txtPayAmount.Text).CompareTo(Convert.ToDecimal(txtTotal.Text)) == -1))
{
lblMsg.Text = "Please Enter Proper Full Amount";
txtPayAmount.Text = string.Empty;
txtPayAmount.Focus();
return;
}
else
{
if (IsCheque.Checked)
{
if (string.IsNullOrEmpty(txtChequeNo.Text))
{
lblMsg.Text = "Please Enter Cheque Number";
txtChequeNo.Focus();
return;
}
else if (string.IsNullOrEmpty(txtChequeDate.Text))
{
lblMsg.Text = "Please Enter Cheque Date";
txtChequeDate.Focus();
return;
}
else
{
if (string.IsNullOrEmpty(txtBankName.Text))
{
lblMsg.Text = "Please Enter Bank Name";
txtBankName.Focus();
return;
}
}
}
else
{
List <EntityCustomerTransaction> lst = new List <EntityCustomerTransaction>();
EntityCustomerTransaction entcust = new EntityCustomerTransaction();
entcust.PatientId = Convert.ToInt32(ddlPatient.SelectedValue);
entcust.EmpName = Convert.ToString(Session["AdminName"]);
entcust.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text);
entcust.BillRefNo = Convert.ToString(txtBillRefNo.Text);
entcust.PayAmount = Convert.ToDecimal(0);
if (IsCash.Checked)
{
entcust.IsCash = true;
entcust.ISCheque = false;
entcust.IsCard = false;
entcust.IsRTGS = false;
entcust.BillAmount = Convert.ToDecimal(txtTotal.Text);
}
if (IsCheque.Checked)
{
entcust.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
entcust.ChequeNo = Convert.ToString(txtChequeNo.Text);
entcust.BankName = Convert.ToString(txtBankName.Text);
entcust.BillAmount = Convert.ToDecimal(txtTotal.Text);
}
if (IsCard.Checked)
{
entcust.IsCash = false;
entcust.ISCheque = false;
entcust.IsCard = true;
entcust.IsRTGS = false;
entcust.BankRefNo = Convert.ToString(txtBankRefNo.Text);
entcust.BillAmount = Convert.ToDecimal(txtTotal.Text);
}
if (IsRTGS.Checked)
{
entcust.IsCash = false;
entcust.ISCheque = false;
entcust.IsCard = false;
entcust.IsRTGS = true;
entcust.BankRefNo = Convert.ToString(txtBankRefNo.Text);
entcust.BillAmount = Convert.ToDecimal(txtTotal.Text);
}
int i = new AdvancePaymentBLL().Save(entcust, IsCash.Checked);
if (i > 0)
{
lblMessage.Text = "Record Saved Successfully";
}
else
{
lblMessage.Text = "Record Not Saved";
}
}
}
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
GetCustTransactionList();
MultiView1.SetActiveView(View2);
}
protected void BtnEdit_Click(object sender, EventArgs e)
{
try
{
tblCustomerTransaction entcust = new tblCustomerTransaction();
entcust.PayAmount = Convert.ToDecimal(txtPayAmount.Text);
entcust.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text);
entcust.ReceiptNo = Convert.ToInt32(Session["ReceiptNo"]);
entcust.BillAmount = 0;
entcust.IsCash = true;
entcust.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text);
entcust.PatientId = Convert.ToInt32(ddlPatient.SelectedValue);
entcust.PreparedByName = Convert.ToString(Session["AdminName"]);
EntityCustomerTransaction transact = null;
if (IsCheque.Checked && ddlPatientCategory.SelectedItem.Text == "Self")
{
entcust.IsCash = false;
entcust.ISCheque = true;
entcust.IsCard = false;
entcust.IsRTGS = false;
entcust.ReceiptDate = Convert.ToDateTime(txtChequeDate.Text);
entcust.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
entcust.ChequeNo = Convert.ToString(txtChequeNo.Text);
entcust.BankName = Convert.ToString(txtBankName.Text);
entcust.PatientCategory = Convert.ToString(ddlPatientCategory.SelectedItem.Text);
transact = new EntityCustomerTransaction();
transact.InsuranceId = 0;
transact.CompanyId = 0;
transact.CompanyName = "";
transact.InsuranceName = "";
transact.ReceiptDate = Convert.ToDateTime(txtChequeDate.Text);
transact.BillAmount = Convert.ToDecimal(txtPayAmount.Text);
transact.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text);
transact.ISCheque = true;
transact.PayAmount = 0;
transact.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
transact.ChequeNo = Convert.ToString(txtChequeNo.Text);
transact.BankName = Convert.ToString(txtBankName.Text);
}
else if (IsCheque.Checked && ddlPatientCategory.SelectedItem.Text == "Company")
{
entcust.IsCash = false;
entcust.ISCheque = true;
entcust.IsCard = false;
entcust.IsRTGS = false;
entcust.ReceiptDate = Convert.ToDateTime(txtChequeDate.Text);
entcust.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
entcust.ChequeNo = Convert.ToString(txtChequeNo.Text);
entcust.BankName = Convert.ToString(txtBankName.Text);
entcust.PatientCategory = Convert.ToString(ddlPatientCategory.SelectedItem.Text);
transact = new EntityCustomerTransaction();
transact.InsuranceId = 0;
transact.CompanyId = Convert.ToInt32(ddlCompany.SelectedValue);
transact.CompanyName = Convert.ToString(ddlCompany.SelectedItem.Text);
transact.InsuranceName = "";
transact.ReceiptDate = Convert.ToDateTime(txtChequeDate.Text);
transact.BillAmount = Convert.ToDecimal(txtPayAmount.Text);
transact.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text);
transact.ISCheque = true;
transact.PayAmount = 0;
transact.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
transact.ChequeNo = Convert.ToString(txtChequeNo.Text);
transact.BankName = Convert.ToString(txtBankName.Text);
}
else if (IsCheque.Checked && ddlPatientCategory.SelectedItem.Text == "Insurance")
{
entcust.IsCash = false;
entcust.ISCheque = false;
entcust.IsCard = false;
entcust.IsRTGS = false;
entcust.ReceiptDate = Convert.ToDateTime(txtChequeDate.Text);
entcust.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
entcust.ChequeNo = Convert.ToString(txtChequeNo.Text);
entcust.BankName = Convert.ToString(txtBankName.Text);
entcust.PatientCategory = Convert.ToString(ddlPatientCategory.SelectedItem.Text);
transact = new EntityCustomerTransaction();
transact.InsuranceId = Convert.ToInt32(ddlCompany.SelectedValue);
transact.CompanyId = 0;
transact.InsuranceName = Convert.ToString(ddlCompany.SelectedItem.Text);
transact.CompanyName = "";
transact.ReceiptDate = Convert.ToDateTime(txtChequeDate.Text);
transact.BillAmount = Convert.ToDecimal(txtPayAmount.Text);
transact.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text);
transact.ISCheque = true;
transact.PayAmount = 0;
transact.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
transact.ChequeNo = Convert.ToString(txtChequeNo.Text);
transact.BankName = Convert.ToString(txtBankName.Text);
}
int i = new CustomerTransactionBLL().Update(entcust, transact, IsCash.Checked);
GetCustTransactionList();
MultiView1.SetActiveView(View2);
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
if (ddlPatient.SelectedIndex == 0)
{
lblMsg.Text = "Please Select Patient Name";
ddlPatient.Focus();
return;
}
else
{
if (IsCheque.Checked)
{
if (string.IsNullOrEmpty(txtChequeNo.Text))
{
lblMsg.Text = "Please Enter Cheque Number";
txtChequeNo.Focus();
return;
}
else if (string.IsNullOrEmpty(txtChequeDate.Text))
{
lblMsg.Text = "Please Enter Cheque Date";
txtChequeDate.Focus();
return;
}
else
{
if (string.IsNullOrEmpty(txtBankName.Text))
{
lblMsg.Text = "Please Enter Bank Name";
txtBankName.Focus();
return;
}
}
}
EntityCustomerTransaction entcust = new EntityCustomerTransaction();
EntityCustomerTransaction transact = null;
entcust.PatientId = Convert.ToInt32(ddlPatient.SelectedValue);
entcust.EmpName = Convert.ToString(Session["AdminName"]);
entcust.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text);
entcust.BillRefNo = Convert.ToString(txtBillRefNo.Text);
entcust.BillAmount = 0;
entcust.PayAmount = Convert.ToDecimal(txtPayAmount.Text);
entcust.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text);
entcust.IsCash = true;
if (IsCheque.Checked && ddlPatientCategory.SelectedItem.Text == "Self")
{
entcust.IsCash = false;
entcust.ISCheque = true;
entcust.IsCard = false;
entcust.IsRTGS = false;
entcust.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text);
entcust.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
entcust.ChequeNo = Convert.ToString(txtChequeNo.Text);
entcust.BankName = Convert.ToString(txtBankName.Text);
entcust.BillRefNo = Convert.ToString(txtBillRefNo.Text);
entcust.PatientCategory = Convert.ToString(ddlPatientCategory.SelectedItem.Text);
transact = new EntityCustomerTransaction();
transact.InsuranceId = 0;
transact.CompanyId = 0;
transact.CompanyName = "";
transact.InsuranceName = "";
transact.ReceiptDate = Convert.ToDateTime(txtChequeDate.Text);
transact.BillAmount = Convert.ToDecimal(txtPayAmount.Text);
transact.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text);
transact.ISCheque = true;
transact.PayAmount = 0;
transact.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
transact.ChequeNo = Convert.ToString(txtChequeNo.Text);
transact.BankName = Convert.ToString(txtBankName.Text);
}
else if (IsCheque.Checked && ddlPatientCategory.SelectedItem.Text == "Company")
{
entcust.IsCash = false;
entcust.ISCheque = true;
entcust.IsCard = false;
entcust.IsRTGS = false;
entcust.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text);
entcust.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
entcust.ChequeNo = Convert.ToString(txtChequeNo.Text);
entcust.BankName = Convert.ToString(txtBankName.Text);
entcust.BillRefNo = Convert.ToString(txtBillRefNo.Text);
entcust.PatientCategory = Convert.ToString(ddlPatientCategory.SelectedItem.Text);
transact = new EntityCustomerTransaction();
transact.InsuranceId = 0;
transact.CompanyId = Convert.ToInt32(ddlCompany.SelectedValue);
transact.CompanyName = Convert.ToString(ddlCompany.SelectedItem.Text);
transact.InsuranceName = "";
transact.ReceiptDate = Convert.ToDateTime(txtChequeDate.Text);
transact.BillAmount = Convert.ToDecimal(txtPayAmount.Text);
transact.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text);
transact.ISCheque = true;
transact.PayAmount = 0;
transact.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
transact.ChequeNo = Convert.ToString(txtChequeNo.Text);
transact.BankName = Convert.ToString(txtBankName.Text);
}
else if (IsCheque.Checked && ddlPatientCategory.SelectedItem.Text == "Insurance")
{
entcust.IsCash = false;
entcust.ISCheque = false;
entcust.IsCard = false;
entcust.IsRTGS = true;
entcust.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text);
entcust.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
entcust.ChequeNo = Convert.ToString(txtChequeNo.Text);
entcust.BankName = Convert.ToString(txtBankName.Text);
entcust.BillRefNo = Convert.ToString(txtBillRefNo.Text);
entcust.PatientCategory = Convert.ToString(ddlPatientCategory.SelectedItem.Text);
transact = new EntityCustomerTransaction();
transact.InsuranceId = Convert.ToInt32(ddlCompany.SelectedValue);
transact.CompanyId = 0;
transact.InsuranceName = Convert.ToString(ddlCompany.SelectedItem.Text);
transact.CompanyName = "";
transact.ReceiptDate = Convert.ToDateTime(txtChequeDate.Text);
transact.BillAmount = Convert.ToDecimal(txtPayAmount.Text);
transact.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text);
transact.ISCheque = true;
transact.PayAmount = 0;
transact.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
transact.ChequeNo = Convert.ToString(txtChequeNo.Text);
transact.BankName = Convert.ToString(txtBankName.Text);
}
else if (IsCard.Checked && ddlPatientCategory.SelectedItem.Text == "Self")
{
entcust.IsCash = false;
entcust.ISCheque = false;
entcust.IsCard = true;
entcust.IsRTGS = false;
entcust.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text);
entcust.BankRefNo = Convert.ToString(txtBankRefNo.Text);
entcust.BillRefNo = Convert.ToString(txtBillRefNo.Text);
entcust.PatientCategory = Convert.ToString(ddlPatientCategory.SelectedItem.Text);
transact = new EntityCustomerTransaction();
transact.InsuranceId = 0;
transact.CompanyId = 0;
transact.CompanyName = "";
transact.InsuranceName = "";
transact.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text);
transact.BillAmount = Convert.ToDecimal(txtPayAmount.Text);
transact.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text);
transact.IsCard = true;
transact.PayAmount = 0;
transact.BankRefNo = Convert.ToString(txtBankRefNo.Text);
}
else if (IsCard.Checked && ddlPatientCategory.SelectedItem.Text == "Company")
{
entcust.IsCash = false;
entcust.ISCheque = false;
entcust.IsCard = true;
entcust.IsRTGS = false;
entcust.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text);
entcust.BankRefNo = Convert.ToString(txtBankRefNo.Text);
entcust.BillRefNo = Convert.ToString(txtBillRefNo.Text);
entcust.PatientCategory = Convert.ToString(ddlPatientCategory.SelectedItem.Text);
transact = new EntityCustomerTransaction();
transact.InsuranceId = 0;
transact.CompanyId = Convert.ToInt32(ddlCompany.SelectedValue);
transact.CompanyName = Convert.ToString(ddlCompany.SelectedItem.Text);
transact.InsuranceName = "";
transact.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text);
transact.BillAmount = Convert.ToDecimal(txtPayAmount.Text);
transact.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text);
transact.IsCard = true;
transact.PayAmount = 0;
transact.BankRefNo = Convert.ToString(txtBankRefNo.Text);
}
else if (IsCard.Checked && ddlPatientCategory.SelectedItem.Text == "Insurance")
{
entcust.IsCash = false;
entcust.ISCheque = false;
entcust.IsCard = true;
entcust.IsRTGS = false;
entcust.BankRefNo = Convert.ToString(txtBankRefNo.Text);
entcust.BillRefNo = Convert.ToString(txtBillRefNo.Text);
entcust.PatientCategory = Convert.ToString(ddlPatientCategory.SelectedItem.Text);
transact = new EntityCustomerTransaction();
transact.InsuranceId = Convert.ToInt32(ddlCompany.SelectedValue);
transact.CompanyId = 0;
transact.InsuranceName = Convert.ToString(ddlCompany.SelectedItem.Text);
transact.CompanyName = "";
transact.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text);
transact.BillAmount = Convert.ToDecimal(txtPayAmount.Text);
transact.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text);
transact.IsCard = true;
transact.PayAmount = 0;
transact.BankRefNo = Convert.ToString(txtBankRefNo.Text);
}
else if (IsRTGS.Checked && ddlPatientCategory.SelectedItem.Text == "Self")
{
entcust.IsCash = false;
entcust.ISCheque = false;
entcust.IsCard = false;
entcust.IsRTGS = true;
entcust.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text);
entcust.BankRefNo = Convert.ToString(txtBankRefNo.Text);
entcust.BillRefNo = Convert.ToString(txtBillRefNo.Text);
entcust.PatientCategory = Convert.ToString(ddlPatientCategory.SelectedItem.Text);
transact = new EntityCustomerTransaction();
transact.InsuranceId = 0;
transact.CompanyId = 0;
transact.CompanyName = "";
transact.InsuranceName = "";
transact.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text);
transact.BillAmount = Convert.ToDecimal(txtPayAmount.Text);
transact.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text);
transact.IsRTGS = true;
transact.PayAmount = 0;
transact.BankRefNo = Convert.ToString(txtBankRefNo.Text);
}
else if (IsRTGS.Checked && ddlPatientCategory.SelectedItem.Text == "Company")
{
entcust.IsCash = false;
entcust.ISCheque = false;
entcust.IsCard = false;
entcust.IsRTGS = true;
entcust.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text);
entcust.BankRefNo = Convert.ToString(txtBankRefNo.Text);
entcust.BillRefNo = Convert.ToString(txtBillRefNo.Text);
entcust.PatientCategory = Convert.ToString(ddlPatientCategory.SelectedItem.Text);
transact = new EntityCustomerTransaction();
transact.InsuranceId = 0;
transact.CompanyId = Convert.ToInt32(ddlCompany.SelectedValue);
transact.CompanyName = Convert.ToString(ddlCompany.SelectedItem.Text);
transact.InsuranceName = "";
transact.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text);
transact.BillAmount = Convert.ToDecimal(txtPayAmount.Text);
transact.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text);
transact.IsRTGS = true;
transact.PayAmount = 0;
transact.BankRefNo = Convert.ToString(txtBankRefNo.Text);
}
else if (IsRTGS.Checked && ddlPatientCategory.SelectedItem.Text == "Insurance")
{
entcust.IsCash = false;
entcust.ISCheque = false;
entcust.IsCard = false;
entcust.IsRTGS = true;
entcust.BankRefNo = Convert.ToString(txtBankRefNo.Text);
entcust.BillRefNo = Convert.ToString(txtBillRefNo.Text);
entcust.PatientCategory = Convert.ToString(ddlPatientCategory.SelectedItem.Text);
transact = new EntityCustomerTransaction();
transact.InsuranceId = Convert.ToInt32(ddlCompany.SelectedValue);
transact.CompanyId = 0;
transact.InsuranceName = Convert.ToString(ddlCompany.SelectedItem.Text);
transact.CompanyName = "";
transact.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text);
transact.BillAmount = Convert.ToDecimal(txtPayAmount.Text);
transact.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text);
transact.IsCard = true;
transact.PayAmount = 0;
transact.BankRefNo = Convert.ToString(txtBankRefNo.Text);
}
int i = new CustomerTransactionBLL().Save(entcust, transact, IsCash.Checked);
if (i > 0)
{
lblMessage.Text = "Record Saved Successfully";
}
else
{
lblMessage.Text = "Record Not Saved";
}
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
GetCustTransactionList();
MultiView1.SetActiveView(View2);
}
public void InsertData(tblInsuranceClaim tblins, EntityCustomerTransaction objPatient, EntityCustomerTransaction objBank, bool IsCash, bool IsNeft, bool IsCheque)
{
try
{
tblInsuranceClaim objcurrent = (from tbl in objData.tblInsuranceClaims
where tbl.ClaimId == tblins.ClaimId
select tbl).FirstOrDefault();
if (objcurrent != null)
{
objcurrent.ApprovedAmount = tblins.ApprovedAmount;
objcurrent.ApprovedDate = tblins.ApprovedDate;
objcurrent.IsApproved = tblins.IsApproved;
objcurrent.TDS = tblins.TDS;
//objcurrent.Discount = tblins.Discount;
int TransactionId = new PatientInvoiceBLL().GetTransactionId();
if (IsCash)
{
tblCustomerTransaction tblcust = new tblCustomerTransaction()
{
TransactionId = TransactionId,
IsCash = true,
ISCheque = false,
TransactionDocNo = objPatient.TransactionDocNo,
TransactionType = "Claim",
BillAmount = 0,
PayAmount = objPatient.PayAmount,
PatientId = objPatient.PatientId,
IsDelete = false,
ReceiptDate = objPatient.ReceiptDate,
};
objData.tblCustomerTransactions.InsertOnSubmit(tblcust);
}
else if (IsNeft)
{
tblCustomerTransaction tblcust = new tblCustomerTransaction()
{
TransactionId = TransactionId,
IsCash = false,
ISCheque = false,
TransactionDocNo = objPatient.TransactionDocNo,
TransactionType = "Claim",
BillAmount = 0,
PayAmount = objPatient.PayAmount,
PatientId = objPatient.PatientId,
IsDelete = false,
ReceiptDate = objPatient.ReceiptDate,
};
objData.tblCustomerTransactions.InsertOnSubmit(tblcust);
tblCustomerTransaction tblcustBank = new tblCustomerTransaction()
{
TransactionId = TransactionId,
IsCash = false,
ISCheque = false,
TransactionDocNo = objBank.TransactionDocNo,
TransactionType = "Claim",
BillAmount = objBank.BillAmount,
PayAmount = 0,
PatientId = 0,
IsDelete = false,
ReceiptDate = objBank.ReceiptDate,
BankId = objBank.BankId
};
objData.tblCustomerTransactions.InsertOnSubmit(tblcustBank);
}
else if (IsCheque)
{
tblCustomerTransaction tblcust = new tblCustomerTransaction()
{
TransactionId = TransactionId,
IsCash = false,
ISCheque = true,
TransactionDocNo = objPatient.TransactionDocNo,
TransactionType = "Claim",
BillAmount = 0,
PayAmount = objPatient.PayAmount,
PatientId = objPatient.PatientId,
IsDelete = false,
ReceiptDate = objPatient.ReceiptDate,
};
objData.tblCustomerTransactions.InsertOnSubmit(tblcust);
tblCustomerTransaction tblcustnew = new tblCustomerTransaction()
{
TransactionId = TransactionId,
IsCash = false,
ISCheque = true,
TransactionDocNo = objBank.TransactionDocNo,
TransactionType = "Claim",
BillAmount = objBank.BillAmount,
PayAmount = 0,
PatientId = 0,
IsDelete = false,
ReceiptDate = objBank.ReceiptDate,
BankName = objBank.BankName,
ChequeDate = objBank.ChequeDate,
ChequeNo = objBank.ChequeNo
};
objData.tblCustomerTransactions.InsertOnSubmit(tblcustnew);
}
}
objData.SubmitChanges();
}
catch (Exception)
{
throw;
}
}
