/// <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); }
//Add multiple items to the BatchList. public void Add(IList lines) { foreach (var line in lines) { BatchList.Add(line); } }
/// <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); }
/// <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); }
//Add line to BatchList. public void Add(LightLine line) { BatchList.Add(line); }
public void Add(LightText text) { BatchList.Add(text); }
//Add a LightText object to the BatchList. public void Add(IList <LightText> text) { BatchList.Add(text); }
/// <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); }
/// <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); }