public void deletePaymentDetails(PaymentBO payBO)
{
PaymentBO paymBO = new PaymentBO();
paymBO.CashDetails = new CashBO();
paymBO.CreditDetails = new CreditCardBO();
paymBO.chequeDetails = new ChequeBO();
paymBO.InsuranceDetails = new InsuranceBO();
paymBO.SpecimenDetails = new SpecimenInfoBO();
try
{
using (SqlConnection connect = new SqlConnection(Constant.DBConnectionString))
{
using (SqlCommand command = new SqlCommand("delete from stblPayment where TenantID = @TenantID and SpecimenID = @SpecimenID", connect))
{
connect.Open();
command.Parameters.Add(new SqlParameter("@TenantID", payBO.SpecimenDetails.TenantID));
command.Parameters.Add(new SqlParameter("@SpecimenID", payBO.SpecimenDetails.SpecimenID));
command.CommandType = CommandType.Text;
SqlDataReader read = command.ExecuteReader();
}
}
}
catch (Exception e)
{
_strErrorMsg = e.Message;
throw;
}
}
//Method to get Payment Details, with payment business object as return type
public PaymentBO GetPayment(PaymentBO paymentBO)
{
try
{
using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString))
{
if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed)
{
objHmsDataContext.Connection.Open();
}
Payment payment = objHmsDataContext.Payments.SingleOrDefault(pymts => (pymts.Payment_ID == paymentBO.payment_ID));
PaymentBO payment_BO = ConvertPaymentToBO(payment);
return(payment_BO);
}
}
catch (Exception e)
{
PaymentBO payment_BO = new PaymentBO();
return(payment_BO);
}
}
// PUT: api/Payment/5
//Put action which accepts payment business object as input parameter and void return type
public void Put(int id, [FromBody] PaymentBO paymentBO)
{
//sample objects are created to check functionality
PaymentBO payment_BO = new PaymentBO();
payment_BO.patient_ID = 7002;
payment_BO.hospital_Fee = 1111.32;
payment_BO.medicines_Fee = 1111.21;
payment_BO.paid_Amount = 1111.21;
payment_BO.total_Amount = 1111.12;
PaymentBLLFactory paymentBLLFactory = new PaymentBLLFactory();
string updatedPayment = paymentBLLFactory.CreatePaymentBLL().UpdatePaymentBLL().CreatePaymentDAL().UpdatePayment(payment_BO);
//sample objects are created to check functionality
PaymentBO paymt_BO = new PaymentBO();
paymt_BO.patient_ID = 7002;
paymt_BO.hospital_Fee = 1234.32;
paymt_BO.medicines_Fee = 5646.21;
paymt_BO.paid_Amount = 1234.21;
paymt_BO.total_Amount = 4325.12;
PaymentBO paymnt_BO = paymentBLLFactory.CreatePaymentBLL().CreatePaymentBLL().CreatePaymentDAL().CreateNewPayment(paymt_BO);
}
public IEnumerable <PaymentBO> PatientPayPayments(PaymentBO paymentBO)
{
try
{
using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString))
{
if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed)
{
objHmsDataContext.Connection.Open();
}
var p = GetPatientPayments(paymentBO.patient_ID).Last().paid_Amount;
InsertPatientPayments(paymentBO);
//paymentBO.paid_Amount = paymentBO.paid_Amount + p;
var pp = GetPatientPayments(paymentBO.patient_ID);
var paidTotal = pp.Where(d => d.bill_ID == paymentBO.bill_ID).Select(h => h.paid_Amount).ToList().Sum();
AccountDAL acc = new AccountDAL();
AccountBO accBO = new AccountBO();
accBO.patient_ID = paymentBO.patient_ID;
accBO.bill_ID = paymentBO.bill_ID;
accBO.paid_Amount = paidTotal;
accBO.generatedDate_Time = DateTime.Now;
acc.UpdateAccountDetails_DAL(accBO);
return(pp);
}
}
catch (Exception e)
{
IEnumerable <PaymentBO> payment_BO = null;
return(payment_BO);
}
}
//Method to update Payment Record,with string return type
public string UpdatePayment(PaymentBO paymentBO)
{
try
{
using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString))
{
if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed)
{
objHmsDataContext.Connection.Open();
}
Payment payment = objHmsDataContext.Payments.SingleOrDefault(pymts => (pymts.Payment_ID == paymentBO.payment_ID));
Payment updatedPayment = ConvertBOToPayment(payment, paymentBO);
objHmsDataContext.SubmitChanges();
return("Succesfully changes submitted");
}
}
catch (Exception e)
{
return("Unable to submit changes please try again later");
}
}
//get all data in mst_Concern table using USP_MST_SELECTCONCERN-SP
/// <summary>
/// To Get Mode Of Payment
/// </summary>
/// <param name="TypeOfPayment"></param>
/// <returns></returns>
public PaymentList GetModeOfPayment(string TypeOfPayment)
{
OracleConnection cnn = new OracleConnection(con);
OracleCommand cmd;
string proc = "USP_MST_GET_MODEOFPAYMENT";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("TypeOfPayment_", TypeOfPayment);
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
PaymentBO objPaymentBO = null;
PaymentList oPaymentList = new PaymentList();
while (dr.Read())
{
objPaymentBO = new PaymentBO();
objPaymentBO = MapData(dr);
oPaymentList.Add(objPaymentBO);
}
dr.Close();
return(oPaymentList);
}
//Method to record new payment,with return type payment Business object
public PaymentBO CreateNewPayment(PaymentBO paymentBO)
{
try
{
using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString))
{
if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed)
{
objHmsDataContext.Connection.Open();
}
Payment payment = new Payment();
Payment updatedPayment = ConvertBOToPayment(payment, paymentBO);
objHmsDataContext.Payments.InsertOnSubmit(updatedPayment);
objHmsDataContext.SubmitChanges();
Payment newPayment = objHmsDataContext.Payments.SingleOrDefault(new_payment => (new_payment.Patient_ID == paymentBO.patient_ID || new_payment.Date_Time == paymentBO.date));
PaymentBO payment_BO = ConvertPaymentToBO(newPayment);
return(payment_BO);
}
}
catch (Exception e)
{
PaymentBO payment_BO = new PaymentBO();
return(payment_BO);
}
}
public void InsertPatientPayments(PaymentBO paymentBO)
{
try
{
using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString))
{
if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed)
{
objHmsDataContext.Connection.Open();
}
objHmsDataContext.Payments.InsertOnSubmit(new Payment
{
Patient_ID = paymentBO.patient_ID,
Total_Amount = Convert.ToDecimal(paymentBO.total_Amount),
Hospital_Fee = Convert.ToDecimal(paymentBO.hospital_Fee),
Medicines_Fee = Convert.ToDecimal(paymentBO.medicines_Fee),
Room_Fee = paymentBO.room_Fee != 0 ? Convert.ToDecimal(paymentBO.room_Fee) : 0,
Paid_Amount = Convert.ToDecimal(paymentBO.paid_Amount),
Date_Time = DateTime.Now,
Bill_ID = paymentBO.bill_ID
});
objHmsDataContext.SubmitChanges();
//return GetPatientPayments(paymentBO.patient_ID);
}
}
catch (Exception e)
{
// IEnumerable<PaymentBO> payment_BO = null;
//return payment_BO;
}
}
//Method to convert Payment to PaymentBO, with payment Business object as return type
public PaymentBO ConvertPaymentToBO(Payment payment)
{
PaymentBO paymentBO = new PaymentBO(payment.Patient_ID, payment.Date_Time, payment.Payment_ID,
(double)payment.Hospital_Fee, (double)payment.Medicines_Fee, (double)payment.Total_Amount, (double)payment.Paid_Amount, payment.Bill_ID, (double)payment.Room_Fee);
return(paymentBO);
}
internal DataSet getShopPaymentParam(PaymentBO paymentBO)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(paymentBO.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure);
command.CommandText = "getCustomerPaymentParam";
sqlHelper.AddParameter(command, "@ShopId", paymentBO.ShopId, ParameterDirection.Input);
return(sqlHelper.ExecuteDataSet(command));
}
internal void updateCustomerParam(PaymentBO paymentBO)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(paymentBO.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure);
command.CommandText = "uspUpdateCustomerParam";
sqlHelper.AddParameter(command, "@MMID", paymentBO.MMID, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@phoneNo", paymentBO.phoneNo, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@ShopId", paymentBO.ShopId, ParameterDirection.Input);
sqlHelper.ExecuteNonQuery(command);
}
// GET: api/Payment/5
//Get action which accepts int as parameter and payment business object as return type
public PaymentBO Get(int id)
{
PaymentBO paymentBO = new PaymentBO();
paymentBO.payment_ID = id;
PaymentBLLFactory paymentBLLFactory = new PaymentBLLFactory();
PaymentBO payment_BO = paymentBLLFactory.CreatePaymentBLL().GetPaymentBLL().CreatePaymentDAL().GetPayment(paymentBO);
return(payment_BO);
}
public IEnumerable <PaymentBO> PatientPayPayments(PaymentBO payment_BO)
{
PaymentBO paymentBO = new PaymentBO();
//paymentBO.payment_ID = id;
PaymentBLLFactory paymentBLLFactory = new PaymentBLLFactory();
IEnumerable <PaymentBO> paymt_BO = paymentBLLFactory.CreatePaymentBLL().GetPaymentBLL().CreatePaymentDAL().PatientPayPayments(payment_BO);
return(paymt_BO);
}
// DELETE: api/Payment/5
//Delete action which accepts int as input parameter and void as return type
public void Delete(int id)
{
PaymentBO paymt_BO = new PaymentBO();
paymt_BO.patient_ID = 7002;
paymt_BO.hospital_Fee = 1234.32;
paymt_BO.medicines_Fee = 5646.21;
paymt_BO.paid_Amount = 1234.21;
paymt_BO.total_Amount = 4325.12;
paymt_BO.payment_ID = id;
PaymentBLLFactory paymentBLLFactory = new PaymentBLLFactory();
string deletePayment = paymentBLLFactory.CreatePaymentBLL().DeletePaymentBLL().CreatePaymentDAL().DeletePayment(paymt_BO);
}
// POST: api/Payment
//Post action which accepts payment business object with void return type
public void Post([FromBody] PaymentBO paymentBO)
{
PaymentBLLFactory paymentBLLFactory = new PaymentBLLFactory();
PaymentBO payment_BO = new PaymentBO();
payment_BO.patient_ID = 7002;
payment_BO.hospital_Fee = 1234.32;
payment_BO.medicines_Fee = 5646.21;
payment_BO.paid_Amount = 1234.21;
payment_BO.total_Amount = 4325.12;
PaymentBO paymt_BO = paymentBLLFactory.CreatePaymentBLL().CreatePaymentBLL().CreatePaymentDAL().CreateNewPayment(payment_BO);
}
/// <summary>
/// To Get Pap Valuation
/// </summary>
/// <param name="HHID"></param>
/// <returns></returns>
public PaymentBO getPapValuation(int HHID)
{
//Reading Payement Status from the TRN_PAP_VALUATION_SUMMERY table
PaymentBO oPaymentBO = null;// = new PaymentBO();
OracleConnection cnn = new OracleConnection(con);
OracleCommand cmd;
string proc = "USP_TRN_GET_PAP_VAL_SUMMARY";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("hhid_", HHID);
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
oPaymentBO = new PaymentBO();
if (ColumnExists(dr, "PaymentStatus") && !dr.IsDBNull(dr.GetOrdinal("PaymentStatus")))
{
oPaymentBO.PaymentStatus = dr.GetString(dr.GetOrdinal("PaymentStatus"));
}
if (ColumnExists(dr, "grandtotal") && !dr.IsDBNull(dr.GetOrdinal("grandtotal")))
{
oPaymentBO.GrandTotal = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("grandtotal")));
}
if (ColumnExists(dr, "negotiatedamtapproved") && !dr.IsDBNull(dr.GetOrdinal("negotiatedamtapproved")))
{
oPaymentBO.NegotiatedAmountApproved = dr.GetString(dr.GetOrdinal("negotiatedamtapproved"));
}
if (ColumnExists(dr, "negotiatedamount") && !dr.IsDBNull(dr.GetOrdinal("negotiatedamount")))
{
oPaymentBO.NegotiatedAmount = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("negotiatedamount")));
}
}
dr.Close();
return(oPaymentBO);
}
/// <summary>
/// To Get File closing Comments
/// </summary>
/// <param name="HHID"></param>
/// <returns></returns>
public PaymentBO GetFileclosingComments(int HHID)
{
string proc = "USP_TRN_GET_FILECLOCOMMENTS";
OracleConnection cnn = new OracleConnection(con);
PaymentBO oPaymentBO = null;
OracleCommand cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("HHID_", HHID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
oPaymentBO = new PaymentBO();
if (!dr.IsDBNull(dr.GetOrdinal("FILECLOSINGCOMMENTS")))
{
oPaymentBO.FILECLOSINGCOMMENTS = dr.GetString((dr.GetOrdinal("FILECLOSINGCOMMENTS")));
}
if (!dr.IsDBNull(dr.GetOrdinal("GRIEVOVERRIDE")))
{
oPaymentBO.GRIEVOVERRIDE = dr.GetString(dr.GetOrdinal("GRIEVOVERRIDE"));
}
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(oPaymentBO);
}
/// <summary>
/// To Map Data
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
private PaymentBO MapData(IDataReader reader)
{
PaymentBO oPaymentBO = new PaymentBO();
if (ColumnExists(reader, "modeofpaymentid") && !reader.IsDBNull(reader.GetOrdinal("modeofpaymentid")))
{
oPaymentBO.ModeOfPaymentId = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("modeofpaymentid")));
}
if (ColumnExists(reader, "modeofpayment") && !reader.IsDBNull(reader.GetOrdinal("modeofpayment")))
{
oPaymentBO.ModeOfPayment = reader.GetString(reader.GetOrdinal("modeofpayment"));
}
if (ColumnExists(reader, "IsDeleted") && !reader.IsDBNull(reader.GetOrdinal("IsDeleted")))
{
oPaymentBO.IsDeleted = reader.GetString(reader.GetOrdinal("IsDeleted"));
}
return(oPaymentBO);
}
//Method to convert PaymentBO to Payment
public Payment ConvertBOToPayment(Payment payment, PaymentBO paymentBO)
{
if (paymentBO.payment_ID != 0)
{
payment.Payment_ID = paymentBO.payment_ID;
}
if (paymentBO.patient_ID != 0)
{
payment.Patient_ID = paymentBO.patient_ID;
}
if (paymentBO.hospital_Fee != 0)
{
payment.Hospital_Fee = (decimal)paymentBO.hospital_Fee;
}
if (paymentBO.medicines_Fee != 0)
{
payment.Medicines_Fee = (decimal)paymentBO.medicines_Fee;
}
if (paymentBO.total_Amount != 0)
{
payment.Total_Amount = (decimal)paymentBO.total_Amount;
}
if (paymentBO.paid_Amount != 0)
{
payment.Paid_Amount = (decimal)paymentBO.paid_Amount;
}
if (paymentBO.date != DateTime.MinValue)
{
payment.Date_Time = paymentBO.date;
}
return(payment);
}
/// <summary>
/// Get PAP Valuation Summery Negotiated Amount
/// </summary>
/// <param name="TotalValuation"></param>
/// <param name="NegotiatedAmount"></param>
private void GetPAPValuationSummery_NegotiatedAmount(decimal TotalValuation, decimal NegotiatedAmount)
{
PaymentBLL oPaymentBLL = new PaymentBLL();
PaymentBO oPaymentBO = new PaymentBO();
oPaymentBO = oPaymentBLL.getPapValuation(SessionHHID);
if (oPaymentBO != null && oPaymentBO.NegotiatedAmountApproved.ToUpper() == "Y")
{
trNegotiatedAmount.Visible = true;
hdnNegotiatedAmount.Value = "1";
trNegotiatedAmount.BgColor = "#E4e4e4";
txtTotalAmount.Text = UtilBO.CurrencyFormat(NegotiatedAmount);
}
else
{
trNegotiatedAmount.Visible = false;
hdnNegotiatedAmount.Value = "0";
//trNegotiatedAmount.Visible = true;
trNegotiatedAmount.BgColor = "#F0F8FF";
txtTotalAmount.Text = UtilBO.CurrencyFormat(TotalValuation);
}
}
internal String UpdatePaymentResponse(PaymentBO PaymentBO)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(PaymentBO.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure);
command.CommandText = "uspInsertPaymentResponse";
sqlHelper.AddParameter(command, "@ResponseCode", PaymentBO.ResponseCode, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@Response", PaymentBO.Response, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@MerRefNo", PaymentBO.MerRefNo, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@RRN", PaymentBO.RRN, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@TransactionDate", PaymentBO.TransactionDate, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@RemittorName", PaymentBO.RemittorName, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@CheckSum", PaymentBO.CheckSum, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@ShopId", PaymentBO.ShopId, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@USerId", PaymentBO.userId, ParameterDirection.Input);
SqlParameter outparam = command.Parameters.Add("@OutputMessage", SqlDbType.VarChar);
outparam.Size = 50;
outparam.Direction = ParameterDirection.Output;
sqlHelper.ExecuteNonQuery(command);
string result = command.Parameters["@OutputMessage"].Value.ToString();
return(result);
}
public PaymentBO getPaymentDetails(PaymentBO payBO)
{
PaymentBO paymBO = new PaymentBO();
paymBO.CashDetails = new CashBO();
paymBO.CreditDetails = new CreditCardBO();
paymBO.chequeDetails = new ChequeBO();
paymBO.InsuranceDetails = new InsuranceBO();
paymBO.SpecimenDetails = new SpecimenInfoBO();
try
{
using (SqlConnection connect = new SqlConnection(Constant.DBConnectionString))
{
using (SqlCommand command = new SqlCommand("select * from svwPayment where TenantID = @TenantID and SpecimenID = @SpecimenID", connect))
{
connect.Open();
command.Parameters.Add(new SqlParameter("@TenantID", payBO.SpecimenDetails.TenantID));
command.Parameters.Add(new SqlParameter("@SpecimenID", payBO.SpecimenDetails.SpecimenID));
command.CommandType = CommandType.Text;
SqlDataReader read = command.ExecuteReader();
if (read.HasRows)
{
while (read.Read())
{
paymBO.PaymentID = read["PaymentID"] == DBNull.Value ? 0 : Convert.ToInt32(read["PaymentID"]);
paymBO.PaymentMode = read["PaymentMode"] == DBNull.Value ? string.Empty : Convert.ToString(read["PaymentMode"]);
paymBO.PaymentStatus = read["PaymentStatus"] == DBNull.Value ? string.Empty : Convert.ToString(read["PaymentStatus"]);
paymBO.CashDetails.Cash = read["Cash"] == DBNull.Value ? 0 : Convert.ToDecimal(read["Cash"]);
paymBO.CashDetails.TransactionDate = read["TransactionDate"] == DBNull.Value ? string.Empty : Convert.ToString(read["TransactionDate"]);
paymBO.CashDetails.Currency = read["Currency"] == DBNull.Value ? string.Empty : Convert.ToString(read["Currency"]);
paymBO.CashDetails.Description = read["Description"] == DBNull.Value ? string.Empty : Convert.ToString(read["Description"]);
paymBO.CreditDetails.CardType = read["CardType"] == DBNull.Value ? string.Empty : Convert.ToString(read["CardType"]);
paymBO.CreditDetails.CardNumber = read["CardNumber"] == DBNull.Value ? string.Empty : Convert.ToString(read["CardNumber"]);
paymBO.CreditDetails.HolderName = read["HolderName"] == DBNull.Value ? string.Empty : Convert.ToString(read["HolderName"]);
paymBO.CreditDetails.CVVNumber = read["CVVNumber"] == DBNull.Value ? string.Empty : Convert.ToString(read["CVVNumber"]);
paymBO.CreditDetails.ExpireDate = read["ExpireDate"] == DBNull.Value ? string.Empty : Convert.ToString(read["ExpireDate"]);
paymBO.CreditDetails.CreditAmount = read["CreditAmount"] == DBNull.Value ? 0 : Convert.ToDecimal(read["CreditAmount"]);
paymBO.chequeDetails.BankName = read["BankName"] == DBNull.Value ? string.Empty : Convert.ToString(read["BankName"]);
paymBO.chequeDetails.BranchName = read["BranchName"] == DBNull.Value ? string.Empty : Convert.ToString(read["BranchName"]);
paymBO.chequeDetails.ChequeNumber = read["ChequeNumber"] == DBNull.Value ? 0 : Convert.ToInt32(read["ChequeNumber"]);
paymBO.chequeDetails.ChequeDate = read["ChequeDate"] == DBNull.Value ? string.Empty : Convert.ToString(read["ChequeDate"]);
paymBO.chequeDetails.ChequeAmount = read["ChequeAmount"] == DBNull.Value ? 0 : Convert.ToDecimal(read["ChequeAmount"]);
paymBO.chequeDetails.AccountNumber = read["AccountNumber"] == DBNull.Value ? string.Empty : Convert.ToString(read["AccountNumber"]);
paymBO.chequeDetails.RoutingNumber = read["RoutingNumber"] == DBNull.Value ? string.Empty : Convert.ToString(read["RoutingNumber"]);
paymBO.chequeDetails.MemoDescription = read["MemoDescription"] == DBNull.Value ? string.Empty : Convert.ToString(read["MemoDescription"]);
paymBO.chequeDetails.ChequeUpload = read["ChequeUpload"] == DBNull.Value ? false : Convert.ToBoolean(read["ChequeUpload"]);
paymBO.InsuranceDetails.InsuranceType = read["InsuranceType"] == DBNull.Value ? string.Empty : Convert.ToString(read["InsuranceType"]);
paymBO.InsuranceDetails.InsuranceCompany = read["InsuranceCompany"] == DBNull.Value ? string.Empty : Convert.ToString(read["InsuranceCompany"]);
paymBO.InsuranceDetails.InsuranceNumber = read["InsuranceNumber"] == DBNull.Value ? string.Empty : Convert.ToString(read["InsuranceNumber"]);
paymBO.InsuranceDetails.MemberName = read["MemberName"] == DBNull.Value ? string.Empty : Convert.ToString(read["MemberName"]);
paymBO.InsuranceDetails.MemberShipNumber = read["MemberShipNumber"] == DBNull.Value ? string.Empty : Convert.ToString(read["MemberShipNumber"]);
paymBO.InsuranceDetails.GroupNumber = read["GroupNumber"] == DBNull.Value ? string.Empty : Convert.ToString(read["GroupNumber"]);
paymBO.InsuranceDetails.PreAuthCode = read["PreAuthCode"] == DBNull.Value ? string.Empty : Convert.ToString(read["PreAuthCode"]);
}
}
read.Close();
connect.Close();
}
}
}
catch (Exception ex)
{
_strErrorMsg = ex.Message;
throw;
}
finally
{
if (sqlCon != null)
{
sqlCon.Dispose();
}
}
return(paymBO);
}
/// <summary>
/// To Update Composition Payment
/// </summary>
/// <param name="oCompPayementBO"></param>
/// <returns></returns>
public string UpdateCompositionPayment(PaymentBO.CompensationPayementBO oCompPayementBO)
{
string returnResult = string.Empty;
PaymentBO ooPaymentBO = new PaymentBO();//For Storing & Returning Result as Object
OracleConnection OCon = new OracleConnection(con);
OCon.Open();
OracleCommand oCmd = new OracleCommand("USP_TRN_UPD_CMP_PAYMENT", OCon);
oCmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(oCmd.CommandType);
try
{
oCmd.Parameters.Add("cmp_paymentid_", oCompPayementBO.CompPaymentId);
oCmd.Parameters.Add("hhid_", oCompPayementBO.HHID);
oCmd.Parameters.Add("compensationtype_", oCompPayementBO.CompensationType);
oCmd.Parameters.Add("modeofpaymentid_", oCompPayementBO.ModeOfPaymentId);
oCmd.Parameters.Add("compensationamount_", oCompPayementBO.CompensationAmount);
oCmd.Parameters.Add("BANKID_", oCompPayementBO.BankID);
oCmd.Parameters.Add("BRANCHID_", oCompPayementBO.BranchID);
oCmd.Parameters.Add("BANKREFERENCE_", oCompPayementBO.BankReference);
//oCmd.Parameters.Add("FIXEDCOSTCENTREID_", oCompPayementBO.FixedCostCentreID);
if (oCompPayementBO.FixedCostCentreID > 0)
{
oCmd.Parameters.Add("FIXEDCOSTCENTREID_", oCompPayementBO.FixedCostCentreID);
}
else
{
oCmd.Parameters.Add("FIXEDCOSTCENTREID_", DBNull.Value);
}
oCmd.Parameters.Add("deliveredtostakeholder_", oCompPayementBO.DeliveredToStakeHolder);
if (!string.IsNullOrEmpty(oCompPayementBO.DeliveredDate))// (oCompPayementBO.DeliveredDate != "" || oCompPayementBO.DeliveredDate != null)
{
oCmd.Parameters.Add("delivereddate_", oCompPayementBO.DeliveredDate);
}
else
{
oCmd.Parameters.Add("delivereddate_", DBNull.Value);
}
oCmd.Parameters.Add("isdeleted_", oCompPayementBO.IsDeleted);
oCmd.Parameters.Add("updatedby_", oCompPayementBO.UpdatedBy);
oCmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
oCmd.ExecuteNonQuery();
if (oCmd.Parameters["errorMessage_"].Value != null)
{
returnResult = oCmd.Parameters["errorMessage_"].Value.ToString();
}
else
{
returnResult = string.Empty;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
oCmd.Dispose();
OCon.Close();
OCon.Dispose();
}
return(returnResult);
}
public PaymentBO savePaymentDetails(PaymentBO payBO)
{
PaymentBO paymBO = new PaymentBO();
paymBO.CashDetails = new CashBO();
paymBO.CreditDetails = new CreditCardBO();
paymBO.chequeDetails = new ChequeBO();
paymBO.InsuranceDetails = new InsuranceBO();
paymBO.SpecimenDetails = new SpecimenInfoBO();
try
{
using (SqlConnection connect = new SqlConnection(Constant.DBConnectionString))
{
using (SqlCommand command = new SqlCommand("sspSavePayment", connect))
{
connect.Open();
command.Parameters.Add(new SqlParameter("@PaymentID", payBO.PaymentID));
command.Parameters.Add(new SqlParameter("@PaymentMode", payBO.PaymentMode));
command.Parameters.Add(new SqlParameter("@PaymentStatus", payBO.PaymentStatus));
command.Parameters.Add(new SqlParameter("@TenantID", payBO.SpecimenDetails.TenantID));
command.Parameters.Add(new SqlParameter("@SpecimenID", payBO.SpecimenDetails.SpecimenID));
command.Parameters.Add(new SqlParameter("@Cash", payBO.CashDetails.Cash));
command.Parameters.Add(new SqlParameter("@TransactionDate", payBO.CashDetails.TransactionDate));
command.Parameters.Add(new SqlParameter("@Currency", payBO.CashDetails.Currency));
command.Parameters.Add(new SqlParameter("@Description", payBO.CashDetails.Description));
command.Parameters.Add(new SqlParameter("@CardType", payBO.CreditDetails.CardType));
command.Parameters.Add(new SqlParameter("@CardNumber", payBO.CreditDetails.CardNumber));
command.Parameters.Add(new SqlParameter("@HolderName", payBO.CreditDetails.HolderName));
command.Parameters.Add(new SqlParameter("@CVVNumber", payBO.CreditDetails.CVVNumber));
command.Parameters.Add(new SqlParameter("@ExpireDate", payBO.CreditDetails.ExpireDate));
command.Parameters.Add(new SqlParameter("@CreditAmount", payBO.CreditDetails.CreditAmount));
command.Parameters.Add(new SqlParameter("@BankName", payBO.chequeDetails.BankName));
command.Parameters.Add(new SqlParameter("@BranchName", payBO.chequeDetails.BranchName));
command.Parameters.Add(new SqlParameter("@ChequeNumber", payBO.chequeDetails.ChequeNumber));
command.Parameters.Add(new SqlParameter("@ChequeDate", payBO.chequeDetails.ChequeDate));
command.Parameters.Add(new SqlParameter("@ChequeAmount", payBO.chequeDetails.ChequeAmount));
command.Parameters.Add(new SqlParameter("@AccountNumber", payBO.chequeDetails.AccountNumber));
command.Parameters.Add(new SqlParameter("@RoutingNumber", payBO.chequeDetails.RoutingNumber));
command.Parameters.Add(new SqlParameter("@MemoDescription", payBO.chequeDetails.MemoDescription));
command.Parameters.Add(new SqlParameter("@ChequeUpload", payBO.chequeDetails.ChequeUpload));
command.Parameters.Add(new SqlParameter("@InsuranceType", payBO.InsuranceDetails.InsuranceType));
command.Parameters.Add(new SqlParameter("@InsuranceCompany", payBO.InsuranceDetails.InsuranceCompany));
command.Parameters.Add(new SqlParameter("@InsuranceNumber", payBO.InsuranceDetails.InsuranceNumber));
command.Parameters.Add(new SqlParameter("@MemberName", payBO.InsuranceDetails.MemberName));
command.Parameters.Add(new SqlParameter("@MemberShipNumber", payBO.InsuranceDetails.MemberShipNumber));
command.Parameters.Add(new SqlParameter("@GroupNumber", payBO.InsuranceDetails.GroupNumber));
command.Parameters.Add(new SqlParameter("@PreAuthCode", payBO.InsuranceDetails.PreAuthCode));
command.Parameters.Add(new SqlParameter("@PreInsuranceNo", payBO.InsuranceDetails.PreInsuranceNo));
command.CommandType = CommandType.StoredProcedure;
SqlDataReader read = command.ExecuteReader();
if (read.HasRows)
{
while (read.Read())
{
paymBO.PaymentID = Convert.ToInt32(read[0]);
}
}
read.Close();
connect.Close();
}
}
}
catch (Exception ex)
{
_strErrorMsg = ex.Message;
throw;
}
finally
{
if (sqlCon != null)
{
sqlCon.Dispose();
}
}
return(paymBO);
}
