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; }