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);
}
public void Update(tblCompanyClaim obj, List <EntityinsuranceClaimDetails> lst)
{
try
{
tblCompanyClaim objcurrent = (from tbl in objData.tblCompanyClaims
where tbl.ComClaimId == obj.ComClaimId
select tbl).FirstOrDefault();
if (objcurrent != null)
{
objcurrent.AdmitId = obj.AdmitId;
objcurrent.CompanyId = obj.CompanyId;
objcurrent.ClaimDate = obj.ClaimDate;
objcurrent.Total = obj.Total;
}
foreach (EntityinsuranceClaimDetails item in lst)
{
tblCompanyClaimDetail objsal = new tblCompanyClaimDetail();
objsal = (from tbl in objData.tblCompanyClaimDetails
where tbl.ComClaimDetailId == item.ComClaimDetailId &&
tbl.IsDelete == false
select tbl).FirstOrDefault();
if (objsal != null)
{
objsal.BillNo = item.BillNo;
objsal.BillType = item.BillType;
objsal.BillDate = item.BillDate;
objsal.BillAmount = item.BillAmount;
objsal.ComClaimId = item.ComClaimId;
objsal.IsDelete = item.IsDelete;
}
else
{
objsal = new tblCompanyClaimDetail()
{
BillNo = item.BillNo, BillAmount = item.BillAmount, BillType = item.BillType, BillDate = item.BillDate, IsOtherBill = item.IsOtherBill, ComClaimId = Convert.ToInt32(obj.ComClaimId)
};
objData.tblCompanyClaimDetails.InsertOnSubmit(objsal);
}
}
objData.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public bool ValidateAllocation(tblCompanyClaim sal)
{
try
{
var res = (from tbl in objData.tblCompanyClaims
where tbl.AdmitId == sal.AdmitId
select tbl).FirstOrDefault();
if (res != null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
public int?Save(tblCompanyClaim tblins, List <EntityinsuranceClaimDetails> lst)
{
int?ComClaimId = 0;
try
{
objData.STP_Insert_tblCompanyClaim(Convert.ToInt32(tblins.AdmitId), Convert.ToInt32(tblins.CompanyId), Convert.ToDateTime(tblins.ClaimDate), Convert.ToDecimal(tblins.Total), tblins.IsApproved, ref ComClaimId);
foreach (EntityinsuranceClaimDetails item in lst)
{
tblCompanyClaimDetail tbl = new tblCompanyClaimDetail()
{
BillNo = item.BillNo, BillAmount = item.BillAmount, BillType = item.BillType, BillDate = item.BillDate, IsOtherBill = item.IsOtherBill, ComClaimId = Convert.ToInt32(ComClaimId)
};
objData.tblCompanyClaimDetails.InsertOnSubmit(tbl);
}
objData.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
return(ComClaimId);
}
public void InsertData(tblCompanyClaim tblins, EntityCustomerTransaction objPatient, EntityCustomerTransaction objBank, bool IsCash, bool IsNeft, bool IsCheque)
{
try
{
tblCompanyClaim objcurrent = (from tbl in objData.tblCompanyClaims
where tbl.ComClaimId == tblins.ComClaimId
select tbl).FirstOrDefault();
if (objcurrent != null)
{
objcurrent.ApprovedAmount = tblins.ApprovedAmount;
objcurrent.ApprovedDate = tblins.ApprovedDate;
objcurrent.IsApproved = tblins.IsApproved;
int TransactionId = new PatientInvoiceBLL().GetTransactionId();
if (IsCash)
{
tblCustomerTransaction tblcust = new tblCustomerTransaction()
{
TransactionId = TransactionId,
IsCash = true,
ISCheque = false,
TransactionDocNo = objPatient.TransactionDocNo,
TransactionType = "CompanyClaim",
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 = "CompanyClaim",
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 = "CompanyClaim",
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 = "CompanyClaim",
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 = "CompanyClaim",
BillAmount = objBank.BillAmount,
PayAmount = 0,
PatientId = 0,
IsDelete = false,
ReceiptDate = objBank.ReceiptDate,
BankName = objBank.BankName,
BankId = objBank.BankId,
ChequeDate = objBank.ChequeDate,
ChequeNo = objBank.ChequeNo
};
objData.tblCustomerTransactions.InsertOnSubmit(tblcustnew);
}
}
objData.SubmitChanges();
}
catch (Exception)
{
throw;
}
}
