public static IEnumerable<DirectDebitWrokFlowDetails> DetailsByDirectDebitWorkFlowRecordList(String DirectDebitID, String DueDate)
{
IEnumerable<DirectDebitWrokFlowDetails> List = null;
using (var context = new SycousCon())
{
try
{
var parDirectDebit = new SqlParameter
{
ParameterName = "DirectDebitID",
Value = Convert.ToInt32(DirectDebitID),
Direction = ParameterDirection.Input
};
var parDueDate = new SqlParameter
{
ParameterName = "DueDate",
Value = Commmon.DateGB(DueDate.ToString()),
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<DirectDebitWrokFlowDetails>("exec SYCOUS.GetDetailsByDirectDebit @DirectDebitID,@DueDate", parDirectDebit, parDueDate).ToList();
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}//using
return List;
}
public static IEnumerable<DirectDebitWrokFlow> DirectDebitWorkFlowRecordList(String ProcessingDate)
{
IEnumerable<DirectDebitWrokFlow> List = null;
using (var context = new SycousCon())
{
try
{
var parDate = new SqlParameter
{
ParameterName = "ProcessingDate",
Value = Commmon.DateGB(ProcessingDate.ToString()),
Direction = ParameterDirection.Input
};
// List = context.ExecuteStoreQuery<DirectDebitWrokFlow>("exec SYCOUS.GenerateDirectDebitWorkFlow @ProcessingDate", parDate).ToList();
List = context.ExecuteStoreQuery<DirectDebitWrokFlow>("exec SYCOUS.GenerateDirectDebitWorkFlow @ProcessingDate", parDate).ToList();
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}//using
return List;
}
public static IEnumerable<ConsumerSearchList> GetContactConsumerList()
{
IEnumerable<ConsumerSearchList> List = null;
try
{
using (var context = new SycousCon())
{
try
{
var parmode = new SqlParameter
{
ParameterName = "mode",
Value = 1,
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<ConsumerSearchList>("exec [SYCOUS].[GetConsumerContactList] @mode", parmode).ToList();
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}//using
}
catch (Exception ex)
{
throw;
}
return List;
}
public static IEnumerable<FundamentalList> PendingNotificationRecordList(String Field, String value)
{
IEnumerable<FundamentalList> List = null;
using (var context = new SycousCon())
{
try
{
var parmode = new SqlParameter
{
ParameterName = "mode",
Value = 3,
Direction = ParameterDirection.Input
};
var pField = new SqlParameter
{
ParameterName = "Field",
Value = Field,
Direction = ParameterDirection.Input
};
var pFieldValue = new SqlParameter
{
ParameterName = "FieldValue",
Value = value,
Direction = ParameterDirection.Input
};
var pTodate = new SqlParameter
{
ParameterName = "Todate",
Value = "",
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<FundamentalList>("exec SYCOUS.GetFundamentalAllReadingValidationPendingList @mode,@Field ,@FieldValue,@Todate", parmode, pField, pFieldValue, pTodate).ToList();
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}//using
return List;
}
public static IEnumerable<MeterList>ConsumerMeterRecordList()
{
IEnumerable<MeterList> List = null;
try
{
using (var context = new SycousCon())
{
var parmode = new SqlParameter
{
ParameterName = "mode",
Value = "1",
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<MeterList>("exec SYCOUS.MeterListConsumerWise @mode", parmode).ToList();
}
}
catch (Exception ex)
{
throw;
}
return List;
}
public static IEnumerable<GenerateEstimatedBilling> GenerateEstimatedBillingRecordList(String DeviceID, DateTime ProcessingDate)
{
IEnumerable<GenerateEstimatedBilling> List = null;
try
{
using (var context = new SycousCon())
{
try
{
var parDeviceID = new SqlParameter
{
ParameterName = "DeviceID",
Value = DeviceID,
Direction = ParameterDirection.Input
};
var parProcessingDate = new SqlParameter
{
ParameterName = "ProcessingDate",
Value = ProcessingDate,
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<GenerateEstimatedBilling>("exec [SYCOUS].[GenerateEstimatedBillingByProcessDate] @DeviceID,@ProcessingDate", parDeviceID, parProcessingDate).ToList();
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}//using
}
catch (Exception ex)
{
throw;
}
return List;
}
public static IEnumerable<PropertyExcelList> PropertyExeclList(String UserType, String UserID, String RoleName)
{
IEnumerable<PropertyExcelList> List = null;
using (var context = new SycousCon())
{
try
{
var pUserType = new SqlParameter
{
ParameterName = "UserType",
Value = UserType,
Direction = ParameterDirection.Input
};
var pUserID = new SqlParameter
{
ParameterName = "UserID",
Value = UserID,
Direction = ParameterDirection.Input
};
var pRoleName = new SqlParameter
{
ParameterName = "RoleName",
Value = RoleName,
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<PropertyExcelList>("exec [SYCOUS].[GetPropertyExeclList] @UserType,@UserID,@RoleName", pUserType, pUserID, pRoleName).ToList();
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
return List;
}
public static IEnumerable<FundamentalDaily> FundamentalDailyRecordList()
{
IEnumerable<FundamentalDaily> List = null;
using (var context = new SycousCon())
{
try
{
var parmode = new SqlParameter
{
ParameterName = "mode",
Value = 1,
Direction = ParameterDirection.Input
};
context.CommandTimeout = 180;
List = context.ExecuteStoreQuery<FundamentalDaily>("exec [SYCOUS].[GetFundamentalDailyWorkFlow] @mode", parmode).ToList();
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}//using
return List;
}
public static IEnumerable<PaymentList> PaymentDetailsRecordList()
{
IEnumerable<PaymentList> List = null;
using (var context = new SycousCon())
{
try
{
var parMode = new SqlParameter
{
ParameterName = "Mode",
Value = 1,
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<PaymentList>("exec SYCOUS.GetPaymentDetails @Mode", parMode).ToList();
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}//using
return List;
}
public static PropertyBandList ViewPropertyBand(Int32 BandID)
{
PropertyBandList List = new PropertyBandList();
using (var context = new SycousCon())
{
try
{
var parmode = new SqlParameter
{
ParameterName = "mode",
Value = "3",
Direction = ParameterDirection.Input
};
var parField = new SqlParameter
{
ParameterName = "Field",
Value = "",
Direction = ParameterDirection.Input
};
var parFieldValue = new SqlParameter
{
ParameterName = "FieldValue",
Value = "",
Direction = ParameterDirection.Input
};
var parBandID = new SqlParameter
{
ParameterName = "BandID",
Value = BandID,
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<PropertyBandList>("exec SYCOUS.GetPropertyBand @mode,@Field,@FieldValue,@BandID ", parmode, parField, parFieldValue, parBandID).FirstOrDefault();
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
return List;
}
public static IEnumerable<DirectDebitList> DirectDebitRecordList(String PropertyID, String OwnerID, String ConsumerID)
{
IEnumerable<DirectDebitList> List = null;
using (var context = new SycousCon())
{
try
{
var pPropertyID = new SqlParameter
{
ParameterName = "PropertyID",
Value = PropertyID,
Direction = ParameterDirection.Input
};
var pOwnerID = new SqlParameter
{
ParameterName = "OwnerID",
Value = OwnerID,
Direction = ParameterDirection.Input
};
var pConsumerID = new SqlParameter
{
ParameterName = "ConsumerID",
Value = ConsumerID,
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<DirectDebitList>("exec [SYCOUS].[GetSearchDirectDebitStatus] @PropertyID ,@OwnerID,@ConsumerID", pPropertyID, pOwnerID, pConsumerID).ToList();
return List;
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
}
public static IEnumerable<PropertyList> UnOccupyPropertyList()
{
IEnumerable<PropertyList> List = null;
using (var context = new SycousCon())
{
try
{
var parmodelNo = new SqlParameter
{
ParameterName = "mode",
Value = 2,
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<PropertyList>("exec [Sycous].[UnOccupyPropertyList] @mode", parmodelNo).ToList();
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
return List;
}
public static IEnumerable<PropertyBandList> PropertyBandList(String Field, String value)
{
IEnumerable<PropertyBandList> List = null;
try
{
using (var context = new SycousCon())
{
var parmode = new SqlParameter
{
ParameterName = "mode",
Value = "2",
Direction = ParameterDirection.Input
};
var parField = new SqlParameter
{
ParameterName = "Field",
Value = Field,
Direction = ParameterDirection.Input
};
var parFieldValue = new SqlParameter
{
ParameterName = "FieldValue",
Value = value,
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<PropertyBandList>("exec SYCOUS.GetPropertyBand @mode,@Field,@FieldValue ", parmode, parField, parFieldValue).ToList();
}
}
catch (Exception ex)
{
throw;
}
return List;
}
public static IEnumerable<AccountList> AccountRecordList(String Field, String Fieldvalue, String EndDate)
{
IEnumerable<AccountList> List = null;
using (var context = new SycousCon())
{
try
{
var parmode = new SqlParameter
{
ParameterName = "mode",
Value = 2,
Direction = ParameterDirection.Input
};
var parFieldName = new SqlParameter
{
ParameterName = "FieldName",
Value = Field,
Direction = ParameterDirection.Input
};
if (Field == "StartDate")
{
var parFieldValue = new SqlParameter
{
ParameterName = "FieldValue",
Value = Fieldvalue != "" ? Commmon.SqlFormatDate(Fieldvalue) : Fieldvalue,
Direction = ParameterDirection.Input
};
var parEnddate = new SqlParameter
{
ParameterName = "Enddate",
Value = EndDate != "" ? Commmon.SqlFormatDate(EndDate) : EndDate,
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<AccountList>("exec SYCOUS.GetAllAccountDetails @mode,@FieldName,@FieldValue,@Enddate", parmode, parFieldName, parFieldValue, parEnddate).ToList();
}//start Date
else
{
var parFieldValue = new SqlParameter
{
ParameterName = "FieldValue",
Value = Fieldvalue,
Direction = ParameterDirection.Input
};
var parEnddate = new SqlParameter
{
ParameterName = "Enddate",
Value ="",
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<AccountList>("exec SYCOUS.GetAllAccountDetails @mode,@FieldName,@FieldValue,@Enddate", parmode, parFieldName, parFieldValue, parEnddate).ToList();
}
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}//using
return List;
}
public static new IEnumerable<MeterSearchList> MeterSearchRecordList(String PropertyID)
{
IEnumerable<MeterSearchList> List = null;
using (var context = new SycousCon())
{
try
{
var pPropertyID = new SqlParameter
{
ParameterName = "PropertyID",
Value = PropertyID,
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<MeterSearchList>("exec [SYCOUS].[GetMeterListByProperty] @PropertyID", pPropertyID).ToList();
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}//using
return List;
}
public static TemperatureDifferenceList TemperatureDifferenceView(String DisConnectedID)
{
TemperatureDifferenceList List = new TemperatureDifferenceList();
using (var context = new SycousCon())
{
try
{
var parmode = new SqlParameter
{
ParameterName = "mode",
Value = 3,
Direction = ParameterDirection.Input
};
var pField = new SqlParameter
{
ParameterName = "Field",
Value = "",
Direction = ParameterDirection.Input
};
var pFieldValue = new SqlParameter
{
ParameterName = "FieldValue",
Value = "",
Direction = ParameterDirection.Input
};
var pID = new SqlParameter
{
ParameterName = "ID",
Value = DisConnectedID,
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<TemperatureDifferenceList>("exec [SYCOUS].[GetTemperatureDifference] @mode,@Field,@FieldValue,@ID", parmode, pField, pFieldValue, pID).FirstOrDefault();
return List;
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
}
public static IEnumerable<DirectDebitConsumerDropdown> DirectDebitConsumerDropdownList(String ConsumerType,String ClientID)
{
IEnumerable<DirectDebitConsumerDropdown> List = null;
try
{
using (var context = new SycousCon())
{
var pConsumerType = new SqlParameter
{
ParameterName = "ConsumerType",
Value = ConsumerType,
Direction = ParameterDirection.Input
};
var pClientID = new SqlParameter
{
ParameterName = "ClientID",
Value = ClientID,
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<DirectDebitConsumerDropdown>("exec SYCOUS.GetDirectDebitConsumerList @ConsumerType,@ClientID", pConsumerType, pClientID).ToList();
}
}
catch (Exception ex)
{
throw;
}
return List;
}
public static MeterSearchList MeterSearchRecordView(String PropertyID, String MeterID)
{
MeterSearchList List = new MeterSearchList();
using (var context = new SycousCon())
{
try
{
var pPropertyID = new SqlParameter
{
ParameterName = "PropertyID ",
Value = PropertyID,
Direction = ParameterDirection.Input
};
var pMeterID = new SqlParameter
{
ParameterName = "MeterID",
Value = MeterID,
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<MeterSearchList>("exec [SYCOUS].[GetMeterSearchDetails] @PropertyID,@MeterID", pPropertyID, pMeterID).FirstOrDefault();
return List;
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
}
public static IEnumerable<MeterSearchList> MeterSearchList(String SearchValue)
{
IEnumerable<MeterSearchList> List = null;
using (var context = new SycousCon())
{
try
{
var pSearchValue = new SqlParameter
{
ParameterName = "SearchValue",
Value = SearchValue,
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<MeterSearchList>("exec [SYCOUS].[GetMeterSearch] @SearchValue", pSearchValue).ToList();
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}//using
return List;
}
public static BulkMeterMappingList ViewBulkMeterRecordListByID(String Mode ,String BulkMeterMapID)
{
BulkMeterMappingList Bulk = new BulkMeterMappingList();
try
{
using (var context = new SycousCon())
{
var pmode = new SqlParameter
{
ParameterName = "mode",
Value = "2",
Direction = ParameterDirection.Input
};
var pBulkMeterID = new SqlParameter
{
ParameterName = "BulkMeterID",
Value = "",
Direction = ParameterDirection.Input
};
var pBulkMeterMapID = new SqlParameter
{
ParameterName = "BulkMeterMapID",
Value = BulkMeterMapID,
Direction = ParameterDirection.Input
};
Bulk = context.ExecuteStoreQuery<BulkMeterMappingList>("exec [SYCOUS].[GetBulkMeterInPropertyByID] @mode,@BulkMeterID,@BulkMeterMapID", pmode, pBulkMeterID, pBulkMeterMapID).FirstOrDefault();
}
}
catch (Exception ex)
{
throw;
}
return Bulk;
}
public static BulkMeterList ViewBulkMeterRecord(String MeterID)
{
BulkMeterList objmeter = new BulkMeterList();
using (var context = new SycousCon())
{
try
{
var parmode = new SqlParameter
{
ParameterName = "mode",
Value = "3",
Direction = ParameterDirection.Input
};
var parField = new SqlParameter
{
ParameterName = "Field",
Value = "",
Direction = ParameterDirection.Input
};
var parFieldValue = new SqlParameter
{
ParameterName = "FieldValue",
Value = "",
Direction = ParameterDirection.Input
};
var parMeter = new SqlParameter
{
ParameterName = "BulkID",
Value = MeterID,
Direction = ParameterDirection.Input
};
objmeter = context.ExecuteStoreQuery<BulkMeterList>("exec SYCOUS.BulkMeterList @mode,@Field,@FieldValue ,@BulkID", parmode, parField, parFieldValue, parMeter).FirstOrDefault();
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
return objmeter;
}
public static IEnumerable<BulkMeterMappingList> BulkMeterMappingRecordList(String UserType, String UserID, String RoleName)
{
IEnumerable<BulkMeterMappingList> Bulk = null;
try
{
using (var context = new SycousCon())
{
var parUserType = new SqlParameter
{
ParameterName = "UserType",
Value = UserType,
Direction = ParameterDirection.Input
};
var parUserID = new SqlParameter
{
ParameterName = "UserID",
Value = UserID,
Direction = ParameterDirection.Input
};
var parRoleName = new SqlParameter
{
ParameterName = "RoleName",
Value = RoleName,
Direction = ParameterDirection.Input
};
Bulk = context.ExecuteStoreQuery<BulkMeterMappingList>("exec [SYCOUS].[GetAllBulkMeterInProperty] @UserType,@UserID,@RoleName", parUserType, parUserID, parRoleName).ToList();
}
}
catch (Exception ex)
{
throw;
}
return Bulk;
}
public static DirectDebitList ViewDirectDebit(String ID)
{
try
{
DirectDebitList objview = new DirectDebitList();
using (var context = new SycousCon())
{
var parmode = new SqlParameter
{
ParameterName = "Mode",
Value = "3",
Direction = ParameterDirection.Input
};
var parID = new SqlParameter
{
ParameterName = "ID",
Value = ID,
Direction = ParameterDirection.Input
};
objview = context.ExecuteStoreQuery<DirectDebitList>("exec SYCOUS.GetDirectDebitList @Mode,@ID", parmode, parID).FirstOrDefault();
}
return objview;
}
catch (Exception ex)
{
throw;
}
}
public static IEnumerable<PropertyBandInTariffList> PropertyBandInTariffList(int Mode , String BandID)
{
IEnumerable<PropertyBandInTariffList> MappingList = null;
try
{
using (var context = new SycousCon())
{
var parmode = new SqlParameter
{
ParameterName = "mode",
Value = 3,
Direction = ParameterDirection.Input
};
var parBandID = new SqlParameter
{
ParameterName = "BandID",
Value = BandID,
Direction = ParameterDirection.Input
};
MappingList = context.ExecuteStoreQuery<PropertyBandInTariffList>("exec PropertyBandInTariffMap @mode,@BandID", parmode, parBandID).ToList();
}
}
catch (Exception ex)
{
throw;
}
return MappingList;
}
public static new IEnumerable<DirectDebitList> DirectDebitRecordList()
{
IEnumerable<DirectDebitList> List = null;
try
{
using (var context = new SycousCon())
{
var parmode = new SqlParameter
{
ParameterName = "Mode",
Value = "4",
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<DirectDebitList>("exec SYCOUS.GetDirectDebitList @Mode", parmode).ToList();
}
}
catch (Exception ex)
{
throw;
}
return List;
}
public static IEnumerable<TariffList> TariffRecordList(String Field, String value)
{
IEnumerable<TariffList> List = null;
using (var context = new SycousCon())
{
try
{
var parmode = new SqlParameter
{
ParameterName = "mode",
Value = "2",
Direction = ParameterDirection.Input
};
var parField = new SqlParameter
{
ParameterName = "Field",
Value = Field,
Direction = ParameterDirection.Input
};
var parFieldValue = new SqlParameter
{
ParameterName = "FieldValue",
Value = value,
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<TariffList>("exec SYCOUS.TariffList @mode,@Field,@FieldValue", parmode, parField, parFieldValue).ToList();
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
return List;
}
public static IEnumerable<AccountList> AccountRecordList(String Field, String value)
{
IEnumerable<AccountList> List = null;
using (var context = new SycousCon())
{
try
{
var parmode = new SqlParameter
{
ParameterName = "mode",
Value = 2,
Direction = ParameterDirection.Input
};
var parFieldName = new SqlParameter
{
ParameterName = "FieldName",
Value = Field,
Direction = ParameterDirection.Input
};
var parFieldValue = new SqlParameter
{
ParameterName = "FieldValue",
Value = value,
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<AccountList>("exec SYCOUS.GetAllAccountDetails @mode,@FieldName,@FieldValue", parmode, parFieldName, parFieldValue).ToList();
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}//using
return List;
}
public static TariffList ViewTariffRecord(Int32 TariffID)
{
TariffList objtariff = new TariffList();
using (var context = new SycousCon())
{
try
{
var parmode = new SqlParameter
{
ParameterName = "mode",
Value = "3",
Direction = ParameterDirection.Input
};
var parField = new SqlParameter
{
ParameterName = "Field",
Value = "",
Direction = ParameterDirection.Input
};
var parFieldValue = new SqlParameter
{
ParameterName = "FieldValue",
Value = "",
Direction = ParameterDirection.Input
};
var PTariffID = new SqlParameter
{
ParameterName = "TariffID",
Value = TariffID.ToString(),
Direction = ParameterDirection.Input
};
objtariff = context.ExecuteStoreQuery<TariffList>("exec SYCOUS.TariffList @mode,@Field,@FieldValue ,@TariffID", parmode, parField, parFieldValue, PTariffID).FirstOrDefault();
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
return objtariff;
}
public static IEnumerable<AccountList> ConsumerAccountRecordList(String ConsumerID, String ConsumerType)
{
IEnumerable<AccountList> List = null;
using (var context = new SycousCon())
{
try
{
var parmode = new SqlParameter
{
ParameterName = "mode",
Value = 3,
Direction = ParameterDirection.Input
};
var parFieldName = new SqlParameter
{
ParameterName = "FieldName",
Value = "",
Direction = ParameterDirection.Input
};
var parFieldValue = new SqlParameter
{
ParameterName = "FieldValue",
Value = "",
Direction = ParameterDirection.Input
};
var parEnddate = new SqlParameter
{
ParameterName = "Enddate",
Value = "",
Direction = ParameterDirection.Input
};
var parConsumerID = new SqlParameter
{
ParameterName = "ConsumerID",
Value = ConsumerID,
Direction = ParameterDirection.Input
};
var parConsumerType = new SqlParameter
{
ParameterName = "ConsumerType",
Value = ConsumerType,
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<AccountList>("exec SYCOUS.GetAllAccountDetails @mode,@FieldName,@FieldValue,@Enddate,@ConsumerID,@ConsumerType", parmode, parFieldName, parFieldValue, parEnddate, parConsumerID, parConsumerType).ToList();
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}//using
return List;
}
public static UserConsumerDetails UserConsumerDetails(String UserID)
{
UserConsumerDetails Consumer = new UserConsumerDetails ();
using (var context = new SycousCon())
{
try
{
var pUserID = new SqlParameter
{
ParameterName = "UserID",
Value = UserID,
Direction = ParameterDirection.Input
};
Consumer = context.ExecuteStoreQuery<UserConsumerDetails>("exec [SYCOUS].[GetConsumerSearchInfo] @UserID", pUserID).FirstOrDefault();
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}//using
return Consumer;
}