/// <summary>
/// TO Get Compensation Payment By Id
/// </summary>
/// <param name="CompensationPaymentID"></param>
/// <returns></returns>
public PaymentBO.CompensationPayementBO getCompensationPaymentById(int CompensationPaymentID)
{
OracleConnection cnn = new OracleConnection(con);
OracleCommand cmd;
string proc = "USP_TRN_GET_CMP_PAYMENTBYID";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("cmp_paymentid_", CompensationPaymentID);
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
PaymentBO.CompensationPayementBO objCompensationPayementBO = null;
lstCompensationPayement = new CompensationPayementList();
objCompensationPayementBO = new PaymentBO.CompensationPayementBO();
while (dr.Read())
{
objCompensationPayementBO = MapData_CompPayment(dr);
//lstCompensationPayement.Add(objCompensationPayementBO);
}
dr.Close();
return(objCompensationPayementBO);
}
/// <summary>
/// To Map Data Compensation Payment
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
private PaymentBO.CompensationPayementBO MapData_CompPayment(IDataReader reader)
{
PaymentBO.CompensationPayementBO oCompPaymentBO = new PaymentBO.CompensationPayementBO();
if (ColumnExists(reader, "cmp_paymentid") && !reader.IsDBNull(reader.GetOrdinal("cmp_paymentid")))
{
oCompPaymentBO.CompPaymentId = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("cmp_paymentid")));
}
if (ColumnExists(reader, "compensationtype") && !reader.IsDBNull(reader.GetOrdinal("compensationtype")))
{
oCompPaymentBO.CompensationType = reader.GetString(reader.GetOrdinal("compensationtype"));
}
if (ColumnExists(reader, "modeofpaymentid") && !reader.IsDBNull(reader.GetOrdinal("modeofpaymentid")))
{
oCompPaymentBO.ModeOfPaymentId = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("modeofpaymentid")));
}
if (ColumnExists(reader, "modeofpayment") && !reader.IsDBNull(reader.GetOrdinal("modeofpayment")))
{
oCompPaymentBO.ModeOfPayment = reader.GetString(reader.GetOrdinal("modeofpayment"));
}
if (ColumnExists(reader, "compensationamount") && !reader.IsDBNull(reader.GetOrdinal("compensationamount")))
{
oCompPaymentBO.CompensationAmount = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("compensationamount")));
}
if (ColumnExists(reader, "deliveredtostakeholder") && !reader.IsDBNull(reader.GetOrdinal("deliveredtostakeholder")))
{
oCompPaymentBO.DeliveredToStakeHolder = reader.GetString(reader.GetOrdinal("deliveredtostakeholder"));
}
if (ColumnExists(reader, "delivereddate") && !reader.IsDBNull(reader.GetOrdinal("delivereddate")))
{
oCompPaymentBO.DeliveredDate = (reader.GetDateTime(reader.GetOrdinal("delivereddate"))).ToString(UtilBO.DateFormat);
}
if (!reader.IsDBNull(reader.GetOrdinal("BANKID")))
{
oCompPaymentBO.BankID = reader.GetInt32(reader.GetOrdinal("BANKID"));
}
if (!reader.IsDBNull(reader.GetOrdinal("BRANCHID")))
{
oCompPaymentBO.BranchID = reader.GetInt32(reader.GetOrdinal("BRANCHID"));
}
if (!reader.IsDBNull(reader.GetOrdinal("BANKREFERENCE")))
{
oCompPaymentBO.BankReference = reader.GetString(reader.GetOrdinal("BANKREFERENCE"));
}
if (ColumnExists(reader, "bankname") && !reader.IsDBNull(reader.GetOrdinal("bankname")))
{
oCompPaymentBO.BankName = reader.GetString(reader.GetOrdinal("bankname"));
}
if (ColumnExists(reader, "branchname") && !reader.IsDBNull(reader.GetOrdinal("branchname")))
{
oCompPaymentBO.BranchName = reader.GetString(reader.GetOrdinal("branchname"));
}
if (ColumnExists(reader, "IsDeleted") && !reader.IsDBNull(reader.GetOrdinal("IsDeleted")))
{
oCompPaymentBO.IsDeleted = reader.GetString(reader.GetOrdinal("IsDeleted"));
}
if (ColumnExists(reader, "FUNDREQSTATUS") && !reader.IsDBNull(reader.GetOrdinal("FUNDREQSTATUS")))
{
oCompPaymentBO.FundReqStatus = reader.GetValue(reader.GetOrdinal("FUNDREQSTATUS")).ToString();
}
//new
if (ColumnExists(reader, "BankCode") && !reader.IsDBNull(reader.GetOrdinal("BankCode")))
{
oCompPaymentBO.BankCode = reader.GetValue(reader.GetOrdinal("BankCode")).ToString();
}
if (ColumnExists(reader, "FIXEDCOSTCENTRE") && !reader.IsDBNull(reader.GetOrdinal("FIXEDCOSTCENTRE")))
{
oCompPaymentBO.FixedCostCentre = reader.GetValue(reader.GetOrdinal("FIXEDCOSTCENTRE")).ToString();
}
if (ColumnExists(reader, "FIXEDCOSTCENTREID") && !reader.IsDBNull(reader.GetOrdinal("FIXEDCOSTCENTREID")))
{
oCompPaymentBO.FixedCostCentreID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("FIXEDCOSTCENTREID")).ToString());
}
if (ColumnExists(reader, "CMP_BATCHNO") && !reader.IsDBNull(reader.GetOrdinal("CMP_BATCHNO")))
{
oCompPaymentBO.BatchNos = reader.GetString(reader.GetOrdinal("CMP_BATCHNO")).Trim().Replace(" ", ", ");
}
return(oCompPaymentBO);
}
/// <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);
}
/// <summary>
/// To Update Composition Payment
/// </summary>
/// <param name="oCompPayementBO"></param>
/// <returns></returns>
public string UpdateCompositionPayment(PaymentBO.CompensationPayementBO oCompPayementBO)
{
oPaymentDAL = new PaymentDAL();
return(oPaymentDAL.UpdateCompositionPayment(oCompPayementBO));
}
/// <summary>
/// To Add Compnesation Payment
/// </summary>
/// <param name="oCompensationPayementBO"></param>
/// <returns></returns>
public string[] AddCompnesationPayment(PaymentBO.CompensationPayementBO oCompensationPayementBO)
{
oPaymentDAL = new PaymentDAL();
return(oPaymentDAL.AddCompensationPayment(oCompensationPayementBO));
}
