public static VaaaN.MLFF.Libraries.CommonLibrary.CBE.SMSCommunicationHistoryCollection GetAllSendSMSPendindStatus() { VaaaN.MLFF.Libraries.CommonLibrary.CBE.SMSCommunicationHistoryCollection smses = new VaaaN.MLFF.Libraries.CommonLibrary.CBE.SMSCommunicationHistoryCollection(); try { //Stored procedure must have cur_out parameter. //There is no need to add ref cursor for oracle in code. string spName = VaaaN.MLFF.Libraries.CommonLibrary.Constants.oraclePackagePrefix + "SMS_HISTORY_PENDIND_STATUS"; DbCommand command = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.GetStoredProcCommand(spName); DataSet ds = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.LoadDataSet(command, tableName); DataTable dt = ds.Tables[tableName]; smses = ConvertDataTableToCollection(dt); } catch (Exception ex) { throw ex; } return(smses); }
public static VaaaN.MLFF.Libraries.CommonLibrary.CBE.SMSCommunicationHistoryCollection GetFilteredRecords(string filter) { VaaaN.MLFF.Libraries.CommonLibrary.CBE.SMSCommunicationHistoryCollection smses = new VaaaN.MLFF.Libraries.CommonLibrary.CBE.SMSCommunicationHistoryCollection(); try { //Stored procedure must have cur_out parameter. //There is no need to add ref cursor for oracle in code. string spName = VaaaN.MLFF.Libraries.CommonLibrary.Constants.oraclePackagePrefix + "SMS_HISTORY_GETFILTERED"; DbCommand command = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.GetStoredProcCommand(spName); command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "p_filter", DbType.String, filter, ParameterDirection.Input)); DataSet ds = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.LoadDataSet(command, tableName); DataTable dt = ds.Tables[tableName]; smses = ConvertDataTableToCollection(dt); } catch (Exception ex) { throw ex; } return(smses); }
/// <summary> /// Get next value for the primary key /// </summary> /// <returns></returns> #endregion #region Helper Methods private static VaaaN.MLFF.Libraries.CommonLibrary.CBE.SMSCommunicationHistoryCollection ConvertDataTableToCollection(DataTable dt) { try { VaaaN.MLFF.Libraries.CommonLibrary.CBE.SMSCommunicationHistoryCollection smses = new VaaaN.MLFF.Libraries.CommonLibrary.CBE.SMSCommunicationHistoryCollection(); for (int i = 0; i < dt.Rows.Count; i++) { VaaaN.MLFF.Libraries.CommonLibrary.CBE.SMSCommunicationHistoryCBE sms = new VaaaN.MLFF.Libraries.CommonLibrary.CBE.SMSCommunicationHistoryCBE(); if (dt.Rows[i]["ENTRY_ID"] != DBNull.Value) { sms.EntryId = Convert.ToInt32(dt.Rows[i]["ENTRY_ID"]); } if (dt.Rows[i]["TMS_ID"] != DBNull.Value) { sms.TmsId = Convert.ToInt32(dt.Rows[i]["TMS_ID"]); } if (dt.Rows[i]["CUSTOMER_ACCOUNT_ID"] != DBNull.Value) { sms.CustomerAccountId = Convert.ToInt32(dt.Rows[i]["CUSTOMER_ACCOUNT_ID"]); } if (dt.Rows[i]["CUSTOMER_NAME"] != DBNull.Value) { sms.CustomerName = Convert.ToString(dt.Rows[i]["CUSTOMER_NAME"]); } if (dt.Rows[i]["MOBILE_NUMBER"] != DBNull.Value) { sms.MobileNumber = Convert.ToString(dt.Rows[i]["MOBILE_NUMBER"]); } if (dt.Rows[i]["MESSAGE_DIRECTION"] != DBNull.Value) { sms.MessageDirection = Convert.ToInt32(dt.Rows[i]["MESSAGE_DIRECTION"]); } if (dt.Rows[i]["MESSAGE_BODY"] != DBNull.Value) { sms.MessageBody = Convert.ToString(dt.Rows[i]["MESSAGE_BODY"]); } if (dt.Rows[i]["SENT_STATUS"] != DBNull.Value) { sms.SentStatus = Convert.ToInt32(dt.Rows[i]["SENT_STATUS"]); } if (dt.Rows[i]["RECEIVED_PROCESS_STATUS"] != DBNull.Value) { sms.ReceivedProcessStatus = Convert.ToInt32(dt.Rows[i]["RECEIVED_PROCESS_STATUS"]); } if (dt.Rows[i]["MESSAGE_SEND_TIME"] != DBNull.Value) { sms.MessageSendDateTime = Convert.ToDateTime(dt.Rows[i]["MESSAGE_SEND_TIME"]); } if (dt.Rows[i]["MESSAGE_RECEIVE_TIME"] != DBNull.Value) { sms.MessageReceiveTime = Convert.ToDateTime(dt.Rows[i]["MESSAGE_RECEIVE_TIME"]); } if (dt.Rows[i]["MESSAGE_DELIVERY_STATUS"] != DBNull.Value) { sms.MessageDeliveryStatus = Convert.ToInt32(dt.Rows[i]["MESSAGE_DELIVERY_STATUS"]); } if (dt.Rows[i]["ATTEMPT_COUNT"] != DBNull.Value) { sms.AttemptCount = Convert.ToInt32(dt.Rows[i]["ATTEMPT_COUNT"]); } if (dt.Rows[i]["CREATION_DATE"] != DBNull.Value) { sms.CreationDate = Convert.ToDateTime(dt.Rows[i]["CREATION_DATE"]); } if (dt.Rows[i]["MODIFICATION_DATE"] != DBNull.Value) { sms.ModificationDate = Convert.ToDateTime(dt.Rows[i]["MODIFICATION_DATE"]); } if (dt.Rows[i]["MODIFIED_BY"] != DBNull.Value) { sms.ModifiedBy = Convert.ToInt32(dt.Rows[i]["MODIFIED_BY"]); } if (dt.Rows[i]["GATEWAY_RESPONSE_CODE"] != DBNull.Value) { sms.ResponseCode = Convert.ToInt32(dt.Rows[i]["GATEWAY_RESPONSE_CODE"]); } if (dt.Rows[i]["OPERATOR_RESPONSE_CODE"] != DBNull.Value) { sms.OperatorResponseCode = Convert.ToInt32(dt.Rows[i]["OPERATOR_RESPONSE_CODE"]); } if (dt.Rows[i]["TRANSACTION_TYPE"] != DBNull.Value) { sms.TransactionType = Convert.ToInt32(dt.Rows[i]["TRANSACTION_TYPE"]); } if (dt.Rows[i]["TRANSACTION_SUBJECT"] != DBNull.Value) { sms.Subject = Convert.ToString(dt.Rows[i]["TRANSACTION_SUBJECT"]); } if (dt.Rows[i]["EMAIL_ID"] != DBNull.Value) { sms.EmailId = Convert.ToString(dt.Rows[i]["EMAIL_ID"]); } if (dt.Rows[i]["TRANSACTION_ID"] != DBNull.Value) { sms.TransactionId = Convert.ToString(dt.Rows[i]["TRANSACTION_ID"]); } if (dt.Rows[i]["VEHICLE_RC_NO"] != DBNull.Value) { sms.VehicleRCNumber = Convert.ToString(dt.Rows[i]["VEHICLE_RC_NO"]); } smses.Add(sms); } return(smses); } catch (Exception ex) { throw ex; } }