/// <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)); }