public static CBE.CustomerAppointmentCBE GetCustomerAppointmentById(CBE.CustomerAppointmentCBE customerQueue)
{
CBE.CustomerAppointmentCollection customerQueues = new CBE.CustomerAppointmentCollection();
try
{
string spName = Constants.oraclePackagePrefix + "CUSTOMER_APPOINTMENT_GETBYID";
DbCommand command = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.GetStoredProcCommand(spName);
command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_TMS_ID", DbType.Int32, customerQueue.TmsId, ParameterDirection.Input));
command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_CUSTOMER_APPOINTMENT_ID", DbType.Int32, customerQueue.CustomerAppointmentId, ParameterDirection.Input));
customerQueues = ConvertDataTableToCollection(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.LoadDataSet(command, tableName).Tables[tableName]);
return(customerQueues[0]);
}
catch (Exception ex)
{
throw ex;
}
}
public static CBE.CustomerAppointmentCollection GetCustomerAppointmentByAccountId(CBE.CustomerAppointmentCBE CustomerAppointment)
{
VaaaN.MLFF.Libraries.CommonLibrary.CBE.CustomerAppointmentCollection CustomerAppointmentQueues = new VaaaN.MLFF.Libraries.CommonLibrary.CBE.CustomerAppointmentCollection();
try
{
string spName = Constants.oraclePackagePrefix + "CUSTAPPOINTMENT_GETACC_ID";
DbCommand command = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.GetStoredProcCommand(spName);
command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_TMS_ID", DbType.Int32, CustomerAppointment.TmsId, ParameterDirection.Input));
command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_ACCOUNT_ID", DbType.Int32, CustomerAppointment.AccountId, ParameterDirection.Input));
DataSet ds = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.LoadDataSet(command, tableName);
DataTable dt = ds.Tables[tableName];
return(CustomerAppointmentQueues = ConvertDataTableToCollection(dt));
}
catch (Exception ex)
{
throw ex;
}
}