Beispiel #1
0
        /// <summary>
        /// To GetPaymentRequestByHHID details
        /// </summary>
        /// <param name="ProjectId"></param>
        /// <param name="HHID"></param>
        /// <returns></returns>
        public BatchList GetPaymentRequestByHHID(int ProjectId, int HHID)
        {
            OracleConnection cnn = new OracleConnection(con);
            OracleCommand    cmd;

            string proc = "USP_TRN_GET_PAPS_BY_HHID";

            cmd             = new OracleCommand(proc, cnn);
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("HHID_", HHID);
            cmd.Parameters.Add("ProjectId_", ProjectId);
            cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;

            cmd.Connection.Open();
            OracleDataReader dr         = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            BatchBO          oBatchBO   = null;
            BatchList        oBatchList = new BatchList();

            while (dr.Read())
            {
                oBatchBO = new BatchBO();
                oBatchBO = MapData(dr);
                oBatchList.Add(oBatchBO);
            }

            dr.Close();

            return(oBatchList);
        }
Beispiel #2
0
 //Add  multiple items to the BatchList.
 public void Add(IList lines)
 {
     foreach (var line in lines)
     {
         BatchList.Add(line);
     }
 }
Beispiel #3
0
        /// <summary>
        /// To Get Payment Pending Batch details
        /// </summary>
        /// <param name="projectID"></param>
        /// <param name="BatchNo"></param>
        /// <returns></returns>
        public BatchList GetPaymentPendingBatch(int projectID, int BatchNo)
        {
            OracleConnection cnn = new OracleConnection(con);
            OracleCommand    cmd;

            string proc = "USP_TRN_GET_PENDING_BATCH_BYID";

            cmd             = new OracleCommand(proc, cnn);
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("PROJECTID_", projectID);
            cmd.Parameters.Add("cmp_batchno_", BatchNo);
            cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;

            cmd.Connection.Open();
            OracleDataReader dr         = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            BatchBO          objBatchBO = null;
            BatchList        oBatchList = new BatchList();

            while (dr.Read())
            {
                objBatchBO = new BatchBO();
                objBatchBO = MapData(dr);

                oBatchList.Add(objBatchBO);
            }

            dr.Close();

            return(oBatchList);
        }
Beispiel #4
0
        /// <summary>
        /// To Get Batches from database
        /// </summary>
        /// <param name="projectID"></param>
        /// <returns></returns>
        public BatchList GetBatches(int projectID)
        {
            OracleConnection cnn = new OracleConnection(con);
            OracleCommand    cmd;

            string proc = "USP_TRN_CMP_GET_BATCH";

            cmd             = new OracleCommand(proc, cnn);
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("PROJECTID_", projectID);

            cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;

            cmd.Connection.Open();
            OracleDataReader dr         = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            BatchBO          objBatchBO = null;
            BatchList        Batches    = new BatchList();

            while (dr.Read())
            {
                objBatchBO = new BatchBO();

                if (!dr.IsDBNull(dr.GetOrdinal("CMP_BATCHNO")))
                {
                    objBatchBO.CMP_BatchNo = dr.GetString(dr.GetOrdinal("CMP_BATCHNO"));
                }
                if (!dr.IsDBNull(dr.GetOrdinal("BATCHCREATEDDATE")))
                {
                    objBatchBO.BatchCreatedDate = dr.GetDateTime(dr.GetOrdinal("BATCHCREATEDDATE")).ToString(UtilBO.DateFormat);
                }
                if (!dr.IsDBNull(dr.GetOrdinal("BATCHSTATUS")))
                {
                    objBatchBO.BatchStatus = dr.GetString(dr.GetOrdinal("BATCHSTATUS"));
                }

                Batches.Add(objBatchBO);
            }

            dr.Close();

            return(Batches);
        }
Beispiel #5
0
 //Add line to BatchList.
 public void Add(LightLine line)
 {
     BatchList.Add(line);
 }
Beispiel #6
0
 public void Add(LightText text)
 {
     BatchList.Add(text);
 }
Beispiel #7
0
 //Add a LightText object to the BatchList.
 public void Add(IList <LightText> text)
 {
     BatchList.Add(text);
 }
Beispiel #8
0
        /// <summary>
        /// To Get Payment Batches from database
        /// </summary>
        /// <param name="projectID"></param>
        /// <param name="BatchNO"></param>
        /// <param name="ToDate"></param>
        /// <param name="FromData"></param>
        /// <returns></returns>
        public BatchList GetPaymentBatches(int projectID, string BatchNO, string ToDate, string FromData)
        {
            OracleConnection cnn = new OracleConnection(con);
            OracleCommand    cmd;

            string proc = "USP_TRN_GET_PAYMENTBATCHES";

            cmd             = new OracleCommand(proc, cnn);
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("PROJECTID_", projectID);
            if (BatchNO.Trim().Length > 0)
            {
                cmd.Parameters.Add("CMP_BATCHNO_", BatchNO);
            }
            else
            {
                cmd.Parameters.Add("CMP_BATCHNO_", DBNull.Value);
            }
            if (FromData.Trim().Length > 0)
            {
                cmd.Parameters.Add("BATCHFROMDATE_", FromData);
            }
            else
            {
                cmd.Parameters.Add("BATCHFROMDATE_", DBNull.Value);
            }
            if (ToDate.Trim().Length > 0)
            {
                cmd.Parameters.Add("BATCHTODATE_", ToDate);
            }
            else
            {
                cmd.Parameters.Add("BATCHTODATE_", DBNull.Value);
            }

            cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;

            cmd.Connection.Open();
            OracleDataReader dr         = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            BatchBO          objBatchBO = null;
            BatchList        Batches    = new BatchList();

            while (dr.Read())
            {
                objBatchBO = new BatchBO();

                if (!dr.IsDBNull(dr.GetOrdinal("CMP_BATCHNO")))
                {
                    objBatchBO.CMP_BatchNo = dr.GetString(dr.GetOrdinal("CMP_BATCHNO"));
                }
                if (!dr.IsDBNull(dr.GetOrdinal("BATCHCREATEDDATE")))
                {
                    objBatchBO.BatchCreatedDate = dr.GetDateTime(dr.GetOrdinal("BATCHCREATEDDATE")).ToString(UtilBO.DateFormatFull);
                }
                if (!dr.IsDBNull(dr.GetOrdinal("BATCHSTATUS")))
                {
                    objBatchBO.BatchStatus = dr.GetString(dr.GetOrdinal("BATCHSTATUS"));
                }
                if (ColumnExists(dr, "HHID") && !dr.IsDBNull(dr.GetOrdinal("HHID")))
                {
                    objBatchBO.HHID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("HHID")));
                }
                if (!dr.IsDBNull(dr.GetOrdinal("Total")))
                {
                    objBatchBO.TOTALCount = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Total")));
                }
                if (!dr.IsDBNull(dr.GetOrdinal("Approved")))
                {
                    objBatchBO.TOTALApproved = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Approved")));
                }
                if (!dr.IsDBNull(dr.GetOrdinal("Declined")))
                {
                    objBatchBO.TOTALDeclined = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Declined")));
                }
                if (!dr.IsDBNull(dr.GetOrdinal("Pending")))
                {
                    objBatchBO.TOTALPending = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Pending")));
                }
                Batches.Add(objBatchBO);
            }

            dr.Close();

            return(Batches);
        }
Beispiel #9
0
        /// <summary>
        /// To GetPaymentRequestByHHID details
        /// </summary>
        /// <param name="ProjectId"></param>
        /// <param name="HHID"></param>
        /// <param name="ElementId"></param>
        /// <param name="Status"></param>
        /// <param name="ApprovalLevel"></param>
        /// <returns></returns>
        public BatchList GetPaymentRequestByHHID(int ProjectId, int HHID, int ElementId, string Status, int ApprovalLevel)
        {
            OracleConnection cnn = new OracleConnection(con);
            OracleCommand    cmd;

            string proc = "USP_TRN_GET_BATCH_HHID_TRAKID";// USP_TRN_GET_BATCH_HHID_TRAKID

            cmd             = new OracleCommand(proc, cnn);
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("HHID_", HHID);
            cmd.Parameters.Add("ProjectId_", ProjectId);
            cmd.Parameters.Add("ElementId_", ElementId);
            cmd.Parameters.Add("Status_", Status);
            cmd.Parameters.Add("ApprovalLevel_", ApprovalLevel);

            cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;

            cmd.Connection.Open();
            OracleDataReader dr         = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            BatchBO          oBatchBO   = null;
            BatchList        oBatchList = new BatchList();

            while (dr.Read())
            {
                //oBatchBO = new BatchBO();
                //oBatchBO = MapData(dr);
                //oBatchList.Add(oBatchBO);
                oBatchBO = new BatchBO();

                if (ColumnExists(dr, "payt_requestid") && !dr.IsDBNull(dr.GetOrdinal("payt_requestid")))
                {
                    oBatchBO.Payt_RequestID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("payt_requestid")));
                }

                if (ColumnExists(dr, "HHID") && !dr.IsDBNull(dr.GetOrdinal("HHID")))
                {
                    oBatchBO.HHID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("HHID")));
                }

                if (ColumnExists(dr, "HHID_DISP") && !dr.IsDBNull(dr.GetOrdinal("HHID_DISP")))
                {
                    oBatchBO.HHID_DISP = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("HHID_DISP")));
                }

                if (ColumnExists(dr, "requeststatus") && !dr.IsDBNull(dr.GetOrdinal("requeststatus")))
                {
                    oBatchBO.RequestStatus = dr.GetString(dr.GetOrdinal("requeststatus"));
                }

                if (ColumnExists(dr, "RequestStatusShow") && !dr.IsDBNull(dr.GetOrdinal("RequestStatusShow")))
                {
                    oBatchBO.RequestStatusShow = dr.GetString(dr.GetOrdinal("RequestStatusShow"));
                }

                if (ColumnExists(dr, "amt_requested") && !dr.IsDBNull(dr.GetOrdinal("amt_requested")))
                {
                    oBatchBO.Amt_Requested = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("amt_requested")));
                }

                if (ColumnExists(dr, "TOTAL_AMOUNT") && !dr.IsDBNull(dr.GetOrdinal("TOTAL_AMOUNT")))
                {
                    oBatchBO.TotalAmount = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("TOTAL_AMOUNT")));
                }

                if (ColumnExists(dr, "PAYT_DESCRIPTION") && !dr.IsDBNull(dr.GetOrdinal("PAYT_DESCRIPTION")))
                {
                    oBatchBO.Payt_Description = dr.GetString(dr.GetOrdinal("PAYT_DESCRIPTION"));
                }

                if (ColumnExists(dr, "payt_requestdate") && !dr.IsDBNull(dr.GetOrdinal("payt_requestdate")))
                {
                    oBatchBO.Payt_RequestDate = dr.GetDateTime(dr.GetOrdinal("payt_requestdate")).ToString();
                }

                if (ColumnExists(dr, "papname") && !dr.IsDBNull(dr.GetOrdinal("papname")))
                {
                    oBatchBO.PAPName = dr.GetString(dr.GetOrdinal("papname"));
                }

                if (ColumnExists(dr, "cmp_batchno") && !dr.IsDBNull(dr.GetOrdinal("cmp_batchno")))
                {
                    oBatchBO.CMP_BatchNo = dr.GetString(dr.GetOrdinal("cmp_batchno"));
                }

                if (ColumnExists(dr, "comments") && !dr.IsDBNull(dr.GetOrdinal("comments")))
                {
                    oBatchBO.Comments = dr.GetString(dr.GetOrdinal("comments"));
                }

                if (ColumnExists(dr, "statuslevel") && !dr.IsDBNull(dr.GetOrdinal("statuslevel")))
                {
                    oBatchBO.StausLevel = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("statuslevel")));
                }

                oBatchList.Add(oBatchBO);
            }

            dr.Close();

            return(oBatchList);
        }