public static string ToSQLParameter(TransactionEventCoverShortDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case TransactionEventCoverShortDataModel.DataColumns.TransactionEventCoverShortId: if (data.TransactionEventCoverShortId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TransactionEventCoverShortDataModel.DataColumns.TransactionEventCoverShortId, data.TransactionEventCoverShortId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TransactionEventCoverShortDataModel.DataColumns.TransactionEventCoverShortId); } break; case TransactionEventCoverShortDataModel.DataColumns.TransactionEventDate: if (data.TransactionEventDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TransactionEventCoverShortDataModel.DataColumns.TransactionEventDate, data.TransactionEventDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TransactionEventCoverShortDataModel.DataColumns.TransactionEventDate); } break; case TransactionEventCoverShortDataModel.DataColumns.TransactionSettleDate: if (data.TransactionSettleDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TransactionEventCoverShortDataModel.DataColumns.TransactionSettleDate, data.TransactionSettleDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TransactionEventCoverShortDataModel.DataColumns.TransactionSettleDate); } break; case TransactionEventCoverShortDataModel.DataColumns.TransactionTypeId: if (data.TransactionTypeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TransactionEventCoverShortDataModel.DataColumns.TransactionTypeId, data.TransactionTypeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TransactionEventCoverShortDataModel.DataColumns.TransactionTypeId); } break; case TransactionEventCoverShortDataModel.DataColumns.TransactionType: if (!string.IsNullOrEmpty(data.TransactionType)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TransactionEventCoverShortDataModel.DataColumns.TransactionType, data.TransactionType); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TransactionEventCoverShortDataModel.DataColumns.TransactionType); } break; case TransactionEventCoverShortDataModel.DataColumns.CustodianId: if (data.CustodianId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TransactionEventCoverShortDataModel.DataColumns.CustodianId, data.CustodianId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TransactionEventCoverShortDataModel.DataColumns.CustodianId); } break; case TransactionEventCoverShortDataModel.DataColumns.Custodian: if (!string.IsNullOrEmpty(data.Custodian)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TransactionEventCoverShortDataModel.DataColumns.Custodian, data.Custodian); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TransactionEventCoverShortDataModel.DataColumns.Custodian); } break; case TransactionEventCoverShortDataModel.DataColumns.StrategyId: if (data.StrategyId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TransactionEventCoverShortDataModel.DataColumns.StrategyId, data.StrategyId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TransactionEventCoverShortDataModel.DataColumns.StrategyId); } break; case TransactionEventCoverShortDataModel.DataColumns.Strategy: if (!string.IsNullOrEmpty(data.Strategy)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TransactionEventCoverShortDataModel.DataColumns.Strategy, data.Strategy); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TransactionEventCoverShortDataModel.DataColumns.Strategy); } break; case TransactionEventCoverShortDataModel.DataColumns.AccountSpecificTypeId: if (data.AccountSpecificTypeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TransactionEventCoverShortDataModel.DataColumns.AccountSpecificTypeId, data.AccountSpecificTypeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TransactionEventCoverShortDataModel.DataColumns.AccountSpecificTypeId); } break; case TransactionEventCoverShortDataModel.DataColumns.AccountSpecificType: if (!string.IsNullOrEmpty(data.AccountSpecificType)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TransactionEventCoverShortDataModel.DataColumns.AccountSpecificType, data.AccountSpecificType); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TransactionEventCoverShortDataModel.DataColumns.AccountSpecificType); } break; case TransactionEventCoverShortDataModel.DataColumns.InvestmentTypeId: if (data.InvestmentTypeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TransactionEventCoverShortDataModel.DataColumns.InvestmentTypeId, data.InvestmentTypeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TransactionEventCoverShortDataModel.DataColumns.InvestmentTypeId); } break; case TransactionEventCoverShortDataModel.DataColumns.InvestmentType: if (!string.IsNullOrEmpty(data.InvestmentType)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TransactionEventCoverShortDataModel.DataColumns.InvestmentType, data.InvestmentType); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TransactionEventCoverShortDataModel.DataColumns.InvestmentType); } break; case TransactionEventCoverShortDataModel.DataColumns.Quantity: returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TransactionEventCoverShortDataModel.DataColumns.Quantity, data.Quantity); break; case TransactionEventCoverShortDataModel.DataColumns.Price: returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TransactionEventCoverShortDataModel.DataColumns.Price, data.Price); break; case TransactionEventCoverShortDataModel.DataColumns.Fees: returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TransactionEventCoverShortDataModel.DataColumns.Fees, data.Fees); break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(FieldConfigurationModeXApplicationRoleDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeXApplicationRoleId: if (data.FieldConfigurationModeXApplicationRoleId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeXApplicationRoleId, data.FieldConfigurationModeXApplicationRoleId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeXApplicationRoleId); } break; case FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeId: if (data.FieldConfigurationModeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeId, data.FieldConfigurationModeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeId); } break; case FieldConfigurationModeXApplicationRoleDataModel.DataColumns.ApplicationRoleId: if (data.ApplicationRoleId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.ApplicationRoleId, data.ApplicationRoleId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.ApplicationRoleId); } break; case FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeAccessModeId: if (data.FieldConfigurationModeAccessModeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeAccessModeId, data.FieldConfigurationModeAccessModeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeAccessModeId); } break; case FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationMode: if (!string.IsNullOrEmpty(data.FieldConfigurationMode)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationMode, data.FieldConfigurationMode); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationMode); } break; case FieldConfigurationModeXApplicationRoleDataModel.DataColumns.ApplicationRole: if (!string.IsNullOrEmpty(data.ApplicationRole)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.ApplicationRole, data.ApplicationRole); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.ApplicationRole); } break; case FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeAccessMode: if (!string.IsNullOrEmpty(data.FieldConfigurationModeAccessMode)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeAccessMode, data.FieldConfigurationModeAccessMode); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeAccessMode); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(TimeZoneXCountryDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case TimeZoneXCountryDataModel.DataColumns.TimeZoneXCountryId: if (data.TimeZoneXCountryId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TimeZoneXCountryDataModel.DataColumns.TimeZoneXCountryId, data.TimeZoneXCountryId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TimeZoneXCountryDataModel.DataColumns.TimeZoneXCountryId); } break; case TimeZoneXCountryDataModel.DataColumns.TimeZoneId: if (data.TimeZoneId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TimeZoneXCountryDataModel.DataColumns.TimeZoneId, data.TimeZoneId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TimeZoneXCountryDataModel.DataColumns.TimeZoneId); } break; case TimeZoneXCountryDataModel.DataColumns.CountryId: if (data.CountryId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TimeZoneXCountryDataModel.DataColumns.CountryId, data.CountryId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TimeZoneXCountryDataModel.DataColumns.CountryId); } break; case TimeZoneXCountryDataModel.DataColumns.TimeZone: if (!string.IsNullOrEmpty(data.TimeZone)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TimeZoneXCountryDataModel.DataColumns.TimeZone, data.TimeZone); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TimeZoneXCountryDataModel.DataColumns.TimeZone); } break; case TimeZoneXCountryDataModel.DataColumns.Country: if (!string.IsNullOrEmpty(data.Country)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TimeZoneXCountryDataModel.DataColumns.Country, data.Country); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TimeZoneXCountryDataModel.DataColumns.Country); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(TxOtherDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case TxOtherDataModel.DataColumns.TxOtherId: if (data.TxOtherId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TxOtherDataModel.DataColumns.TxOtherId, data.TxOtherId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxOtherDataModel.DataColumns.TxOtherId); } break; case TxOtherDataModel.DataColumns.TransactionEventId: if (data.TransactionEventId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TxOtherDataModel.DataColumns.TransactionEventId, data.TransactionEventId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxOtherDataModel.DataColumns.TransactionEventId); } break; case TxOtherDataModel.DataColumns.TransactionEvent: if (!string.IsNullOrEmpty(data.TransactionEvent)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TxOtherDataModel.DataColumns.TransactionEvent, data.TransactionEvent); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxOtherDataModel.DataColumns.TransactionEvent); } break; case TxOtherDataModel.DataColumns.FundStructureId: if (data.FundStructureId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TxOtherDataModel.DataColumns.FundStructureId, data.FundStructureId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxOtherDataModel.DataColumns.FundStructureId); } break; case TxOtherDataModel.DataColumns.CashSourceId: if (data.CashSourceId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TxOtherDataModel.DataColumns.CashSourceId, data.CashSourceId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxOtherDataModel.DataColumns.CashSourceId); } break; case TxOtherDataModel.DataColumns.StrategyId: if (data.StrategyId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TxOtherDataModel.DataColumns.StrategyId, data.StrategyId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxOtherDataModel.DataColumns.StrategyId); } break; case TxOtherDataModel.DataColumns.GenericLegId: if (data.GenericLegId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TxOtherDataModel.DataColumns.GenericLegId, data.GenericLegId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxOtherDataModel.DataColumns.GenericLegId); } break; case TxOtherDataModel.DataColumns.DistributionParentId: if (data.DistributionParentId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TxOtherDataModel.DataColumns.DistributionParentId, data.DistributionParentId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxOtherDataModel.DataColumns.DistributionParentId); } break; case TxOtherDataModel.DataColumns.SettlementTypeId: if (data.SettlementTypeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TxOtherDataModel.DataColumns.SettlementTypeId, data.SettlementTypeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxOtherDataModel.DataColumns.SettlementTypeId); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(ApplicationUserDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case ApplicationUserDataModel.DataColumns.ApplicationUserId: if (data.ApplicationUserId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ApplicationUserDataModel.DataColumns.ApplicationUserId, data.ApplicationUserId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationUserDataModel.DataColumns.ApplicationUserId); } break; case ApplicationUserDataModel.DataColumns.ApplicationUserName: if (!string.IsNullOrEmpty(data.ApplicationUserName)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ApplicationUserDataModel.DataColumns.ApplicationUserName, data.ApplicationUserName); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationUserDataModel.DataColumns.ApplicationUserName); } break; case ApplicationUserDataModel.DataColumns.EmailAddress: if (!string.IsNullOrEmpty(data.EmailAddress)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ApplicationUserDataModel.DataColumns.EmailAddress, data.EmailAddress); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationUserDataModel.DataColumns.EmailAddress); } break; case ApplicationUserDataModel.DataColumns.FirstName: if (!string.IsNullOrEmpty(data.FirstName)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ApplicationUserDataModel.DataColumns.FirstName, data.FirstName); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationUserDataModel.DataColumns.FirstName); } break; case ApplicationUserDataModel.DataColumns.LastName: if (!string.IsNullOrEmpty(data.LastName)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ApplicationUserDataModel.DataColumns.LastName, data.LastName); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationUserDataModel.DataColumns.LastName); } break; case ApplicationUserDataModel.DataColumns.MiddleName: if (!string.IsNullOrEmpty(data.MiddleName)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ApplicationUserDataModel.DataColumns.MiddleName, data.MiddleName); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationUserDataModel.DataColumns.MiddleName); } break; case ApplicationUserDataModel.DataColumns.FullName: if (!string.IsNullOrEmpty(data.FullName)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ApplicationUserDataModel.DataColumns.FullName, data.FullName); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationUserDataModel.DataColumns.FullName); } break; case ApplicationUserDataModel.DataColumns.ApplicationUserTitleId: if (data.ApplicationUserTitleId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ApplicationUserDataModel.DataColumns.ApplicationUserTitleId, data.ApplicationUserTitleId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationUserDataModel.DataColumns.ApplicationUserTitleId); } break; case ApplicationUserDataModel.DataColumns.ApplicationUserTitle: if (!string.IsNullOrEmpty(data.FullName)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ApplicationUserDataModel.DataColumns.ApplicationUserTitle, data.ApplicationUserTitle); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationUserDataModel.DataColumns.ApplicationUserTitle); } break; case ApplicationUserDataModel.DataColumns.Application: if (data.Application != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ApplicationUserDataModel.DataColumns.Application, data.Application); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationUserDataModel.DataColumns.Application); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(RegistrationDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case RegistrationDataModel.DataColumns.RegistrationId: if (data.RegistrationId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, RegistrationDataModel.DataColumns.RegistrationId, data.RegistrationId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, RegistrationDataModel.DataColumns.RegistrationId); } break; case RegistrationDataModel.DataColumns.CourseId: if (data.CourseId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, RegistrationDataModel.DataColumns.CourseId, data.CourseId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, RegistrationDataModel.DataColumns.CourseId); } break; case RegistrationDataModel.DataColumns.Course: if (!string.IsNullOrEmpty(data.Course)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, RegistrationDataModel.DataColumns.Course, data.Course); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, RegistrationDataModel.DataColumns.Course); } break; case RegistrationDataModel.DataColumns.StudentId: if (data.StudentId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, RegistrationDataModel.DataColumns.StudentId, data.StudentId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, RegistrationDataModel.DataColumns.StudentId); } break; case RegistrationDataModel.DataColumns.Student: if (!string.IsNullOrEmpty(data.Student)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, RegistrationDataModel.DataColumns.Student, data.Student); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, RegistrationDataModel.DataColumns.Student); } break; case RegistrationDataModel.DataColumns.EnrollmentDate: if (data.EnrollmentDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, RegistrationDataModel.DataColumns.EnrollmentDate, data.EnrollmentDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, RegistrationDataModel.DataColumns.EnrollmentDate); } break; case RegistrationDataModel.DataColumns.FromSearchEnrollmentDate: if (data.FromSearchEnrollmentDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, RegistrationDataModel.DataColumns.FromSearchEnrollmentDate, data.FromSearchEnrollmentDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, RegistrationDataModel.DataColumns.FromSearchEnrollmentDate); } break; case RegistrationDataModel.DataColumns.ToSearchEnrollmentDate: if (data.ToSearchEnrollmentDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, RegistrationDataModel.DataColumns.ToSearchEnrollmentDate, data.ToSearchEnrollmentDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, RegistrationDataModel.DataColumns.ToSearchEnrollmentDate); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(TxTradeAndSettleDatesDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case TxTradeAndSettleDatesDataModel.DataColumns.TxTradeAndSettleDatesId: returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TxTradeAndSettleDatesDataModel.DataColumns.TxTradeAndSettleDatesId, data.TxTradeAndSettleDatesId); break; case TxTradeAndSettleDatesDataModel.DataColumns.TransactionEventId: if (data.TransactionEventId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TxTradeAndSettleDatesDataModel.DataColumns.TransactionEventId, data.TransactionEventId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxTradeAndSettleDatesDataModel.DataColumns.TransactionEventId); } break; case TxTradeAndSettleDatesDataModel.DataColumns.TransactionEvent: if (!string.IsNullOrEmpty(data.TransactionEvent)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TxTradeAndSettleDatesDataModel.DataColumns.TransactionEvent, data.TransactionEvent); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxTradeAndSettleDatesDataModel.DataColumns.TransactionEvent); } break; case TxTradeAndSettleDatesDataModel.DataColumns.TradeDate: if (data.TradeDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TxTradeAndSettleDatesDataModel.DataColumns.TradeDate, data.TradeDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxTradeAndSettleDatesDataModel.DataColumns.TradeDate); } break; case TxTradeAndSettleDatesDataModel.DataColumns.FromSearchTradeDate: if (data.FromSearchTradeDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TxTradeAndSettleDatesDataModel.DataColumns.TradeDate, data.FromSearchTradeDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxTradeAndSettleDatesDataModel.DataColumns.FromSearchTradeDate); } break; case TxTradeAndSettleDatesDataModel.DataColumns.ToSearchTradeDate: if (data.ToSearchTradeDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TxTradeAndSettleDatesDataModel.DataColumns.TradeDate, data.ToSearchTradeDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxTradeAndSettleDatesDataModel.DataColumns.ToSearchTradeDate); } break; case TxTradeAndSettleDatesDataModel.DataColumns.ContractualDate: if (data.ContractualDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TxTradeAndSettleDatesDataModel.DataColumns.ContractualDate, data.ContractualDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxTradeAndSettleDatesDataModel.DataColumns.ContractualDate); } break; case TxTradeAndSettleDatesDataModel.DataColumns.FromSearchContractualDate: if (data.FromSearchContractualDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TxTradeAndSettleDatesDataModel.DataColumns.ContractualDate, data.FromSearchContractualDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxTradeAndSettleDatesDataModel.DataColumns.FromSearchContractualDate); } break; case TxTradeAndSettleDatesDataModel.DataColumns.ToSearchContractualDate: if (data.ToSearchContractualDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TxTradeAndSettleDatesDataModel.DataColumns.ContractualDate, data.ToSearchContractualDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxTradeAndSettleDatesDataModel.DataColumns.ToSearchContractualDate); } break; case TxTradeAndSettleDatesDataModel.DataColumns.ActualDate: if (data.ActualDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TxTradeAndSettleDatesDataModel.DataColumns.ActualDate, data.ActualDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxTradeAndSettleDatesDataModel.DataColumns.ActualDate); } break; case TxTradeAndSettleDatesDataModel.DataColumns.FromSearchActualDate: if (data.FromSearchActualDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TxTradeAndSettleDatesDataModel.DataColumns.ActualDate, data.FromSearchActualDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxTradeAndSettleDatesDataModel.DataColumns.FromSearchContractualDate); } break; case TxTradeAndSettleDatesDataModel.DataColumns.ToSearchActualDate: if (data.ToSearchActualDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TxTradeAndSettleDatesDataModel.DataColumns.ActualDate, data.ToSearchActualDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxTradeAndSettleDatesDataModel.DataColumns.ToSearchActualDate); } break; case TxTradeAndSettleDatesDataModel.DataColumns.SpotDate: if (data.SpotDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TxTradeAndSettleDatesDataModel.DataColumns.SpotDate, data.SpotDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxTradeAndSettleDatesDataModel.DataColumns.SpotDate); } break; case TxTradeAndSettleDatesDataModel.DataColumns.SettlementDate: if (data.SettlementDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TxTradeAndSettleDatesDataModel.DataColumns.SettlementDate, data.SettlementDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxTradeAndSettleDatesDataModel.DataColumns.SettlementDate); } break; case TxTradeAndSettleDatesDataModel.DataColumns.CreatedDate: break; case TxTradeAndSettleDatesDataModel.DataColumns.CreatedByAuditId: returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TxTradeAndSettleDatesDataModel.DataColumns.CreatedByAuditId, data.CreatedByAuditId); break; case TxTradeAndSettleDatesDataModel.DataColumns.UpdatedDate: break; case TxTradeAndSettleDatesDataModel.DataColumns.ModifiedByAuditId: returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TxTradeAndSettleDatesDataModel.DataColumns.ModifiedByAuditId, data.ModifiedByAuditId); break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static DataTable Search(FunctionalityEntityStatusDataModel data, RequestProfile requestProfile) { var mergeddt = new DataTable(); var procSql = string.Empty; var sql = string.Empty; if (data.FunctionalityActiveStatusId != null) { procSql = "EXEC dbo.FESModuleIntegratedSearch "; } else { procSql = "EXEC dbo.FunctionalityEntityStatusSearch "; } if (data.FunctionalityStatusIds != null && data.FunctionalityStatusIds.Length >= 1) { for (int i = 0; i < data.FunctionalityStatusIds.Length; i++) { sql = procSql + " " + BaseDataManager.SetCommonParametersForSearch(requestProfile.AuditId, requestProfile.ApplicationId, requestProfile.ApplicationModeId) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityEntityStatusId, data.FunctionalityEntityStatusId) + //", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.ApplicationId, data.ApplicationId) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.SystemEntityTypeId, data.SystemEntityTypeId) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityId, data.FunctionalityId) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityPriorityId, data.FunctionalityPriorityId) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityStatusId, data.FunctionalityStatusIds[i]) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityActiveStatusId, data.FunctionalityActiveStatusId) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.AssignedTo, data.AssignedTo) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.StartDate, data.StartDate) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.TargetDate, data.TargetDate) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.StartDate2, data.StartDateR2) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationMode, requestProfile.ApplicationModeId) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.TargetDate2, data.TargetDateR2); var oDT = new DBDataTable("FunctionalityEntityStatus.Search", sql, DataStoreKey); var dt = new DataTable(); dt = oDT.DBTable; if (mergeddt.Rows.Count == 0) { mergeddt = dt.Clone(); } foreach (DataRow row in dt.Rows) { mergeddt.ImportRow(row); } } return(mergeddt); } else { // formulate SQL sql = procSql + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.ApplicationId, data.ApplicationId) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityEntityStatusId, data.FunctionalityEntityStatusId) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.SystemEntityTypeId, data.SystemEntityTypeId) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityId, data.FunctionalityId) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityPriorityId, data.FunctionalityPriorityId) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityStatusId, data.FunctionalityStatusId) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.FunctionalityActiveStatusId, data.FunctionalityActiveStatusId) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.AssignedTo, data.AssignedTo) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.StartDate, data.StartDate) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.TargetDate, data.TargetDate) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.StartDate2, data.StartDateR2) + ", " + ToSQLParameter(data, FunctionalityEntityStatusDataModel.DataColumns.TargetDate2, data.TargetDateR2); var oDT = new DBDataTable("FunctionalityEntityStatus.Search", sql, DataStoreKey); return(oDT.DBTable); } }
public static string ToSQLParameter(QuickPaginationRunDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case QuickPaginationRunDataModel.DataColumns.QuickPaginationRunId: if (data.QuickPaginationRunId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, QuickPaginationRunDataModel.DataColumns.QuickPaginationRunId, data.QuickPaginationRunId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, QuickPaginationRunDataModel.DataColumns.QuickPaginationRunId); } break; case QuickPaginationRunDataModel.DataColumns.SortClause: if (!string.IsNullOrEmpty(data.SortClause)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, QuickPaginationRunDataModel.DataColumns.SortClause, data.SortClause.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, QuickPaginationRunDataModel.DataColumns.SortClause); } break; case QuickPaginationRunDataModel.DataColumns.WhereClause: if (!string.IsNullOrEmpty(data.WhereClause)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, QuickPaginationRunDataModel.DataColumns.WhereClause, data.WhereClause.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, QuickPaginationRunDataModel.DataColumns.WhereClause); } break; case QuickPaginationRunDataModel.DataColumns.SystemEntityType: if (!string.IsNullOrEmpty(data.SystemEntityType)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, QuickPaginationRunDataModel.DataColumns.SystemEntityType, data.SystemEntityType.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, QuickPaginationRunDataModel.DataColumns.SystemEntityType); } break; case QuickPaginationRunDataModel.DataColumns.ApplicationUserName: if (!string.IsNullOrEmpty(data.ApplicationUserName)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, QuickPaginationRunDataModel.DataColumns.ApplicationUserName, data.ApplicationUserName.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, QuickPaginationRunDataModel.DataColumns.ApplicationUserName); } break; case QuickPaginationRunDataModel.DataColumns.ApplicationUserId: if (data.ApplicationUserId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, QuickPaginationRunDataModel.DataColumns.ApplicationUserId, data.ApplicationUserId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, QuickPaginationRunDataModel.DataColumns.ApplicationUserId); } break; case QuickPaginationRunDataModel.DataColumns.SystemEntityTypeId: if (data.SystemEntityTypeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, QuickPaginationRunDataModel.DataColumns.SystemEntityTypeId, data.SystemEntityTypeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, QuickPaginationRunDataModel.DataColumns.SystemEntityTypeId); } break; case QuickPaginationRunDataModel.DataColumns.ExpirationTime: if (data.ExpirationTime != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, QuickPaginationRunDataModel.DataColumns.ExpirationTime, data.ExpirationTime); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, QuickPaginationRunDataModel.DataColumns.ExpirationTime); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(FundXPortfolioDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case FundXPortfolioDataModel.DataColumns.FundXPortfolioId: if (data.FundXPortfolioId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FundXPortfolioDataModel.DataColumns.FundXPortfolioId, data.FundXPortfolioId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FundXPortfolioDataModel.DataColumns.FundXPortfolioId); } break; case FundXPortfolioDataModel.DataColumns.FundId: if (data.FundId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FundXPortfolioDataModel.DataColumns.FundId, data.FundId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FundXPortfolioDataModel.DataColumns.FundId); } break; case FundXPortfolioDataModel.DataColumns.PortfolioId: if (data.PortfolioId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FundXPortfolioDataModel.DataColumns.PortfolioId, data.PortfolioId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FundXPortfolioDataModel.DataColumns.PortfolioId); } break; case FundXPortfolioDataModel.DataColumns.Fund: if (!string.IsNullOrEmpty(data.Fund)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FundXPortfolioDataModel.DataColumns.Fund, data.Fund); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FundXPortfolioDataModel.DataColumns.Fund); } break; case FundXPortfolioDataModel.DataColumns.Portfolio: if (!string.IsNullOrEmpty(data.Portfolio)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FundXPortfolioDataModel.DataColumns.Portfolio, data.Portfolio); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FundXPortfolioDataModel.DataColumns.Portfolio); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(DataModel.Framework.Core.ApplicationRouteParameterDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case DataModel.Framework.Core.ApplicationRouteParameterDataModel.DataColumns.ApplicationRouteParameterId: if (data.ApplicationRouteParameterId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DataModel.Framework.Core.ApplicationRouteParameterDataModel.DataColumns.ApplicationRouteParameterId, data.ApplicationRouteParameterId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.Framework.Core.ApplicationRouteParameterDataModel.DataColumns.ApplicationRouteParameterId); } break; case DataModel.Framework.Core.ApplicationRouteParameterDataModel.DataColumns.ApplicationRouteId: if (data.ApplicationRouteId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DataModel.Framework.Core.ApplicationRouteParameterDataModel.DataColumns.ApplicationRouteId, data.ApplicationRouteId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.Framework.Core.ApplicationRouteParameterDataModel.DataColumns.ApplicationRouteId); } break; case DataModel.Framework.Core.ApplicationRouteParameterDataModel.DataColumns.ApplicationRoute: if (!string.IsNullOrEmpty(data.ApplicationRoute)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DataModel.Framework.Core.ApplicationRouteParameterDataModel.DataColumns.ApplicationRoute, data.ApplicationRoute.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.Framework.Core.ApplicationRouteParameterDataModel.DataColumns.ApplicationRoute); } break; case DataModel.Framework.Core.ApplicationRouteParameterDataModel.DataColumns.ParameterName: if (!string.IsNullOrEmpty(data.ParameterName)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DataModel.Framework.Core.ApplicationRouteParameterDataModel.DataColumns.ParameterName, data.ParameterName.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.Framework.Core.ApplicationRouteParameterDataModel.DataColumns.ParameterName); } break; case DataModel.Framework.Core.ApplicationRouteParameterDataModel.DataColumns.ParameterValue: if (!string.IsNullOrEmpty(data.ParameterValue)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DataModel.Framework.Core.ApplicationRouteParameterDataModel.DataColumns.ParameterValue, data.ParameterValue.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.Framework.Core.ApplicationRouteParameterDataModel.DataColumns.ParameterValue); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(ConnectionStringDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case ConnectionStringDataModel.DataColumns.ConnectionStringId: if (data.ConnectionStringId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ConnectionStringDataModel.DataColumns.ConnectionStringId, data.ConnectionStringId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ConnectionStringDataModel.DataColumns.ConnectionStringId); } break; case ConnectionStringDataModel.DataColumns.Name: if (!string.IsNullOrEmpty(data.Name)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ConnectionStringDataModel.DataColumns.Name, data.Name.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ConnectionStringDataModel.DataColumns.Name); } break; case ConnectionStringDataModel.DataColumns.Description: if (!string.IsNullOrEmpty(data.Description)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ConnectionStringDataModel.DataColumns.Description, data.Description.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ConnectionStringDataModel.DataColumns.Description); } break; case ConnectionStringDataModel.DataColumns.DataSource: if (!string.IsNullOrEmpty(data.DataSource)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ConnectionStringDataModel.DataColumns.DataSource, data.DataSource.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ConnectionStringDataModel.DataColumns.DataSource); } break; case ConnectionStringDataModel.DataColumns.InitialCatalog: if (!string.IsNullOrEmpty(data.InitialCatalog)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ConnectionStringDataModel.DataColumns.InitialCatalog, data.InitialCatalog.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ConnectionStringDataModel.DataColumns.InitialCatalog); } break; case ConnectionStringDataModel.DataColumns.UserName: if (!string.IsNullOrEmpty(data.UserName)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ConnectionStringDataModel.DataColumns.UserName, data.UserName.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ConnectionStringDataModel.DataColumns.UserName); } break; case ConnectionStringDataModel.DataColumns.Password: if (!string.IsNullOrEmpty(data.Password)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ConnectionStringDataModel.DataColumns.Password, data.Password.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ConnectionStringDataModel.DataColumns.Password); } break; case ConnectionStringDataModel.DataColumns.ProviderName: if (!string.IsNullOrEmpty(data.ProviderName)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ConnectionStringDataModel.DataColumns.ProviderName, data.ProviderName.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ConnectionStringDataModel.DataColumns.ProviderName); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(ApplicationOperationDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case ApplicationOperationDataModel.DataColumns.ApplicationOperationId: if (data.ApplicationOperationId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ApplicationOperationDataModel.DataColumns.ApplicationOperationId, data.ApplicationOperationId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationOperationDataModel.DataColumns.ApplicationOperationId); } break; case BaseDataModel.BaseDataColumns.ApplicationId: if (data.ApplicationId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, BaseDataModel.BaseDataColumns.ApplicationId, data.ApplicationId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, BaseDataModel.BaseDataColumns.ApplicationId); } break; case ApplicationOperationDataModel.DataColumns.SystemEntityTypeId: if (data.SystemEntityTypeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ApplicationOperationDataModel.DataColumns.SystemEntityTypeId, data.SystemEntityTypeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationOperationDataModel.DataColumns.SystemEntityTypeId); } break; case ApplicationOperationDataModel.DataColumns.SystemEntityId: if (data.SystemEntityTypeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ApplicationOperationDataModel.DataColumns.SystemEntityId, data.SystemEntityTypeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationOperationDataModel.DataColumns.SystemEntityId); } break; case StandardDataModel.StandardDataColumns.SortOrder: if (data.SortOrder != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, StandardDataModel.StandardDataColumns.SortOrder, data.SortOrder); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, StandardDataModel.StandardDataColumns.SortOrder); } break; case ApplicationOperationDataModel.DataColumns.OperationValue: if (!string.IsNullOrEmpty(data.OperationValue)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ApplicationOperationDataModel.DataColumns.OperationValue, data.OperationValue); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationOperationDataModel.DataColumns.OperationValue); } break; case ApplicationOperationDataModel.DataColumns.Application: if (!string.IsNullOrEmpty(data.Application)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ApplicationOperationDataModel.DataColumns.Application, data.Application); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationOperationDataModel.DataColumns.Application); } break; case ApplicationOperationDataModel.DataColumns.SystemEntityType: if (!string.IsNullOrEmpty(data.SystemEntityType)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ApplicationOperationDataModel.DataColumns.SystemEntityType, data.SystemEntityType); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationOperationDataModel.DataColumns.SystemEntityType); } break; case StandardDataModel.StandardDataColumns.Name: if (!string.IsNullOrEmpty(data.Name)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, StandardDataModel.StandardDataColumns.Name, data.Name); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, StandardDataModel.StandardDataColumns.Name); } break; case StandardDataModel.StandardDataColumns.Description: if (!string.IsNullOrEmpty(data.Description)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, StandardDataModel.StandardDataColumns.Description, data.Description); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, StandardDataModel.StandardDataColumns.Description); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(FieldConfigurationBaseDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case FieldConfigurationBaseDataModel.DataColumns.FieldConfigurationBaseId: if (data.FieldConfigurationBaseId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FieldConfigurationBaseDataModel.DataColumns.FieldConfigurationBaseId, data.FieldConfigurationBaseId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationBaseDataModel.DataColumns.FieldConfigurationBaseId); } break; case FieldConfigurationBaseDataModel.DataColumns.Name: if (!string.IsNullOrEmpty(data.Name)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FieldConfigurationBaseDataModel.DataColumns.Name, data.Name); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationBaseDataModel.DataColumns.Name); } break; case FieldConfigurationBaseDataModel.DataColumns.Value: if (!string.IsNullOrEmpty(data.Value)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FieldConfigurationBaseDataModel.DataColumns.Value, data.Value); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationBaseDataModel.DataColumns.Value); } break; case FieldConfigurationBaseDataModel.DataColumns.ControlType: if (!string.IsNullOrEmpty(data.ControlType)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FieldConfigurationBaseDataModel.DataColumns.ControlType, data.ControlType); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationBaseDataModel.DataColumns.ControlType); } break; case FieldConfigurationBaseDataModel.DataColumns.Formatting: if (!string.IsNullOrEmpty(data.Formatting)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FieldConfigurationBaseDataModel.DataColumns.Formatting, data.Formatting); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationBaseDataModel.DataColumns.Formatting); } break; case FieldConfigurationBaseDataModel.DataColumns.Version: if (!string.IsNullOrEmpty(data.Version)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FieldConfigurationBaseDataModel.DataColumns.Version, data.Version); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationBaseDataModel.DataColumns.Version); } break; case FieldConfigurationBaseDataModel.DataColumns.Width: if (data.Width != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FieldConfigurationBaseDataModel.DataColumns.Width, data.Width); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationBaseDataModel.DataColumns.Width); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(AddressDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case AddressDataModel.DataColumns.AddressId: if (data.AddressId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, AddressDataModel.DataColumns.AddressId, data.AddressId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AddressDataModel.DataColumns.AddressId); } break; case AddressDataModel.DataColumns.CityId: if (data.CityId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, AddressDataModel.DataColumns.CityId, data.CityId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AddressDataModel.DataColumns.CityId); } break; case AddressDataModel.DataColumns.City: if (!string.IsNullOrEmpty(data.City)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, AddressDataModel.DataColumns.City, data.City); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AddressDataModel.DataColumns.City); } break; case AddressDataModel.DataColumns.StateId: if (data.StateId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, AddressDataModel.DataColumns.StateId, data.StateId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AddressDataModel.DataColumns.StateId); } break; case AddressDataModel.DataColumns.State: if (!string.IsNullOrEmpty(data.State)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, AddressDataModel.DataColumns.State, data.State); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AddressDataModel.DataColumns.State); } break; case AddressDataModel.DataColumns.CountryId: if (data.CountryId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, AddressDataModel.DataColumns.CountryId, data.CountryId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AddressDataModel.DataColumns.CountryId); } break; case AddressDataModel.DataColumns.Country: if (!string.IsNullOrEmpty(data.Country)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, AddressDataModel.DataColumns.Country, data.Country); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AddressDataModel.DataColumns.Country); } break; case AddressDataModel.DataColumns.Address1: if (!string.IsNullOrEmpty(data.Address1)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, AddressDataModel.DataColumns.Address1, data.Address1); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AddressDataModel.DataColumns.Address1); } break; case AddressDataModel.DataColumns.Address2: if (!string.IsNullOrEmpty(data.Address2)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, AddressDataModel.DataColumns.Address2, data.Address2); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AddressDataModel.DataColumns.Address2); } break; case AddressDataModel.DataColumns.PostalCode: if (!string.IsNullOrEmpty(data.PostalCode)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, AddressDataModel.DataColumns.PostalCode, data.PostalCode); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AddressDataModel.DataColumns.PostalCode); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(MSPAFileEventDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case MSPAFileEventDataModel.DataColumns.MSPAFileEventId: if (data.MSPAFileEventId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, MSPAFileEventDataModel.DataColumns.MSPAFileEventId, data.MSPAFileEventId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MSPAFileEventDataModel.DataColumns.MSPAFileEventId); } break; case MSPAFileEventDataModel.DataColumns.Description: if (!string.IsNullOrEmpty(data.Description)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, MSPAFileEventDataModel.DataColumns.Description, data.Description); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MSPAFileEventDataModel.DataColumns.Description); } break; case MSPAFileEventDataModel.DataColumns.CreatedBy: if (!string.IsNullOrEmpty(data.CreatedBy)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, MSPAFileEventDataModel.DataColumns.CreatedBy, data.CreatedBy); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MSPAFileEventDataModel.DataColumns.CreatedBy); } break; case MSPAFileEventDataModel.DataColumns.CreatedOn: if (data.CreatedOn != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, MSPAFileEventDataModel.DataColumns.CreatedOn, data.CreatedOn); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MSPAFileEventDataModel.DataColumns.CreatedOn); } break; case MSPAFileEventDataModel.DataColumns.MSPAFileId: if (data.MSPAFileId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, MSPAFileEventDataModel.DataColumns.MSPAFileId, data.MSPAFileId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MSPAFileEventDataModel.DataColumns.MSPAFileId); } break; case MSPAFileEventDataModel.DataColumns.MSPAFile: if (!string.IsNullOrEmpty(data.MSPAFile)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, MSPAFileEventDataModel.DataColumns.MSPAFile, data.MSPAFile); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MSPAFileEventDataModel.DataColumns.MSPAFile); } break; case MSPAFileEventDataModel.DataColumns.TradingEventTypeId: if (data.TradingEventTypeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, MSPAFileEventDataModel.DataColumns.TradingEventTypeId, data.TradingEventTypeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MSPAFileEventDataModel.DataColumns.TradingEventTypeId); } break; case MSPAFileEventDataModel.DataColumns.TradingEventType: if (!string.IsNullOrEmpty(data.TradingEventType)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, MSPAFileEventDataModel.DataColumns.TradingEventType, data.TradingEventType); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MSPAFileEventDataModel.DataColumns.TradingEventType); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(AccountAdministratorDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case AccountAdministratorDataModel.DataColumns.AccountAdministratorId: if (data.AccountAdministratorId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, AccountAdministratorDataModel.DataColumns.AccountAdministratorId, data.AccountAdministratorId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AccountAdministratorDataModel.DataColumns.AccountAdministratorId); } break; case AccountAdministratorDataModel.DataColumns.Url: if (!string.IsNullOrEmpty(data.Url)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, AccountAdministratorDataModel.DataColumns.Url, data.Url); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AccountAdministratorDataModel.DataColumns.Url); } break; case AccountAdministratorDataModel.DataColumns.Code: if (!string.IsNullOrEmpty(data.Code)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, AccountAdministratorDataModel.DataColumns.Code, data.Code); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AccountAdministratorDataModel.DataColumns.Code); } break; case AccountAdministratorDataModel.DataColumns.Name: if (!string.IsNullOrEmpty(data.Name)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, AccountAdministratorDataModel.DataColumns.Name, data.Name); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AccountAdministratorDataModel.DataColumns.Name); } break; case AccountAdministratorDataModel.DataColumns.Description: if (!string.IsNullOrEmpty(data.Description)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, AccountAdministratorDataModel.DataColumns.Description, data.Description); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AccountAdministratorDataModel.DataColumns.Description); } break; case AccountAdministratorDataModel.DataColumns.SortOrder: if (data.SortOrder != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, AccountAdministratorDataModel.DataColumns.SortOrder, data.SortOrder); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AccountAdministratorDataModel.DataColumns.SortOrder); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(CourseInstanceDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case CourseInstanceDataModel.DataColumns.CourseInstanceId: if (data.CourseInstanceId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, CourseInstanceDataModel.DataColumns.CourseInstanceId, data.CourseInstanceId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CourseInstanceDataModel.DataColumns.CourseInstanceId); } break; case CourseInstanceDataModel.DataColumns.Name: if (!string.IsNullOrEmpty(data.Name)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, CourseInstanceDataModel.DataColumns.Name, data.Name); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CourseInstanceDataModel.DataColumns.Name); } break; case CourseInstanceDataModel.DataColumns.CourseId: if (data.CourseId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, CourseInstanceDataModel.DataColumns.CourseId, data.CourseId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CourseInstanceDataModel.DataColumns.CourseId); } break; case CourseInstanceDataModel.DataColumns.Course: if (!string.IsNullOrEmpty(data.Course)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, CourseInstanceDataModel.DataColumns.Course, data.Course); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CourseInstanceDataModel.DataColumns.Course); } break; case CourseInstanceDataModel.DataColumns.DepartmentId: if (data.DepartmentId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, CourseInstanceDataModel.DataColumns.DepartmentId, data.DepartmentId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CourseInstanceDataModel.DataColumns.DepartmentId); } break; case CourseInstanceDataModel.DataColumns.Department: if (!string.IsNullOrEmpty(data.Department)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, CourseInstanceDataModel.DataColumns.Department, data.Department); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CourseInstanceDataModel.DataColumns.Department); } break; case CourseInstanceDataModel.DataColumns.TeacherId: if (data.TeacherId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, CourseInstanceDataModel.DataColumns.TeacherId, data.TeacherId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CourseInstanceDataModel.DataColumns.TeacherId); } break; case CourseInstanceDataModel.DataColumns.Teacher: if (!string.IsNullOrEmpty(data.Teacher)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, CourseInstanceDataModel.DataColumns.Teacher, data.Teacher); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CourseInstanceDataModel.DataColumns.Teacher); } break; case CourseInstanceDataModel.DataColumns.StartTime: if (data.StartTime != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, CourseInstanceDataModel.DataColumns.StartTime, data.StartTime); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CourseInstanceDataModel.DataColumns.StartTime); } break; case CourseInstanceDataModel.DataColumns.EndTime: if (data.EndTime != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, CourseInstanceDataModel.DataColumns.EndTime, data.EndTime); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CourseInstanceDataModel.DataColumns.EndTime); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(CommissionTypeDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case CommissionTypeDataModel.DataColumns.CommissionTypeId: if (data.CommissionTypeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, CommissionTypeDataModel.DataColumns.CommissionTypeId, data.CommissionTypeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CommissionTypeDataModel.DataColumns.CommissionTypeId); } break; case CommissionTypeDataModel.DataColumns.CommissionTypeDescription: if (!string.IsNullOrEmpty(data.CommissionTypeDescription)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, CommissionTypeDataModel.DataColumns.CommissionTypeDescription, data.CommissionTypeDescription); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CommissionTypeDataModel.DataColumns.CommissionTypeDescription); } break; case CommissionTypeDataModel.DataColumns.LastModifiedBy: if (!string.IsNullOrEmpty(data.LastModifiedBy)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, CommissionTypeDataModel.DataColumns.LastModifiedBy, data.LastModifiedBy); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CommissionTypeDataModel.DataColumns.LastModifiedBy); } break; case CommissionTypeDataModel.DataColumns.LastModifiedOn: if (data.LastModifiedOn != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, CommissionTypeDataModel.DataColumns.LastModifiedOn, data.LastModifiedOn); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CommissionTypeDataModel.DataColumns.LastModifiedOn); } break; case CommissionTypeDataModel.DataColumns.ShowInFilter: returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, CommissionTypeDataModel.DataColumns.ShowInFilter, data.ShowInFilter); break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(ProjectXUseCaseDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case ProjectXUseCaseDataModel.DataColumns.ProjectXUseCaseId: if (data.ProjectXUseCaseId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ProjectXUseCaseDataModel.DataColumns.ProjectXUseCaseId, data.ProjectXUseCaseId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ProjectXUseCaseDataModel.DataColumns.ProjectXUseCaseId); } break; case ProjectXUseCaseDataModel.DataColumns.ProjectId: if (data.ProjectId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ProjectXUseCaseDataModel.DataColumns.ProjectId, data.ProjectId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ProjectXUseCaseDataModel.DataColumns.ProjectId); } break; case ProjectXUseCaseDataModel.DataColumns.UseCaseId: if (data.UseCaseId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ProjectXUseCaseDataModel.DataColumns.UseCaseId, data.UseCaseId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ProjectXUseCaseDataModel.DataColumns.UseCaseId); } break; case ProjectXUseCaseDataModel.DataColumns.ProjectUseCaseStatusId: if (data.ProjectUseCaseStatusId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ProjectXUseCaseDataModel.DataColumns.ProjectUseCaseStatusId, data.ProjectUseCaseStatusId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ProjectXUseCaseDataModel.DataColumns.ProjectUseCaseStatusId); } break; case ProjectXUseCaseDataModel.DataColumns.Project: if (data.Project != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ProjectXUseCaseDataModel.DataColumns.Project, data.Project); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ProjectXUseCaseDataModel.DataColumns.Project); } break; case ProjectXUseCaseDataModel.DataColumns.UseCase: if (data.UseCase != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ProjectXUseCaseDataModel.DataColumns.UseCase, data.UseCase); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ProjectXUseCaseDataModel.DataColumns.UseCase); } break; case ProjectXUseCaseDataModel.DataColumns.ProjectUseCaseStatus: if (data.ProjectUseCaseStatus != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ProjectXUseCaseDataModel.DataColumns.ProjectUseCaseStatus, data.ProjectUseCaseStatus); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ProjectXUseCaseDataModel.DataColumns.ProjectUseCaseStatus); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(SecurityXPartyDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case SecurityXPartyDataModel.DataColumns.SecurityXPartyId: if (data.SecurityXPartyId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SecurityXPartyDataModel.DataColumns.SecurityXPartyId, data.SecurityXPartyId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SecurityXPartyDataModel.DataColumns.SecurityXPartyId); } break; case SecurityXPartyDataModel.DataColumns.ExchangeId: if (data.ExchangeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SecurityXPartyDataModel.DataColumns.ExchangeId, data.ExchangeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SecurityXPartyDataModel.DataColumns.ExchangeId); } break; case SecurityXPartyDataModel.DataColumns.Exchange: if (!string.IsNullOrEmpty(data.Exchange)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SecurityXPartyDataModel.DataColumns.Exchange, data.Exchange); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SecurityXPartyDataModel.DataColumns.Exchange); } break; case SecurityXPartyDataModel.DataColumns.IssuerId: if (data.IssuerId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SecurityXPartyDataModel.DataColumns.IssuerId, data.IssuerId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SecurityXPartyDataModel.DataColumns.IssuerId); } break; case SecurityXPartyDataModel.DataColumns.Issuer: if (!string.IsNullOrEmpty(data.Issuer)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SecurityXPartyDataModel.DataColumns.Issuer, data.Issuer); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SecurityXPartyDataModel.DataColumns.Issuer); } break; case SecurityXPartyDataModel.DataColumns.DeliveryAgentId: if (data.DeliveryAgentId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SecurityXPartyDataModel.DataColumns.DeliveryAgentId, data.DeliveryAgentId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SecurityXPartyDataModel.DataColumns.DeliveryAgentId); } break; case SecurityXPartyDataModel.DataColumns.DeliveryAgent: if (!string.IsNullOrEmpty(data.DeliveryAgent)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SecurityXPartyDataModel.DataColumns.DeliveryAgent, data.DeliveryAgent); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SecurityXPartyDataModel.DataColumns.DeliveryAgent); } break; case SecurityXPartyDataModel.DataColumns.SecurityId: if (data.SecurityId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SecurityXPartyDataModel.DataColumns.SecurityId, data.SecurityId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SecurityXPartyDataModel.DataColumns.SecurityId); } break; case SecurityXPartyDataModel.DataColumns.Security: if (!string.IsNullOrEmpty(data.Security)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SecurityXPartyDataModel.DataColumns.Security, data.Security); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SecurityXPartyDataModel.DataColumns.Security); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(UseCaseActorXUseCaseDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case UseCaseActorXUseCaseDataModel.DataColumns.UseCaseActorXUseCaseId: if (data.UseCaseActorXUseCaseId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, UseCaseActorXUseCaseDataModel.DataColumns.UseCaseActorXUseCaseId, data.UseCaseActorXUseCaseId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UseCaseActorXUseCaseDataModel.DataColumns.UseCaseActorXUseCaseId); } break; case UseCaseActorXUseCaseDataModel.DataColumns.UseCaseActorId: if (data.UseCaseActorId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, UseCaseActorXUseCaseDataModel.DataColumns.UseCaseActorId, data.UseCaseActorId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UseCaseActorXUseCaseDataModel.DataColumns.UseCaseActorId); } break; case UseCaseActorXUseCaseDataModel.DataColumns.UseCaseId: if (data.UseCaseId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, UseCaseActorXUseCaseDataModel.DataColumns.UseCaseId, data.UseCaseId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UseCaseActorXUseCaseDataModel.DataColumns.UseCaseId); } break; case UseCaseActorXUseCaseDataModel.DataColumns.UseCaseRelationshipId: if (data.UseCaseRelationshipId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, UseCaseActorXUseCaseDataModel.DataColumns.UseCaseRelationshipId, data.UseCaseRelationshipId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UseCaseActorXUseCaseDataModel.DataColumns.UseCaseRelationshipId); } break; case UseCaseActorXUseCaseDataModel.DataColumns.UseCaseActor: if (data.UseCaseActor != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, UseCaseActorXUseCaseDataModel.DataColumns.UseCaseActor, data.UseCaseActor); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UseCaseActorXUseCaseDataModel.DataColumns.UseCaseActor); } break; case UseCaseActorXUseCaseDataModel.DataColumns.UseCase: if (data.UseCase != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, UseCaseActorXUseCaseDataModel.DataColumns.UseCase, data.UseCase); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UseCaseActorXUseCaseDataModel.DataColumns.UseCase); } break; case UseCaseActorXUseCaseDataModel.DataColumns.UseCaseRelationship: if (data.UseCaseRelationship != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, UseCaseActorXUseCaseDataModel.DataColumns.UseCaseRelationship, data.UseCaseRelationship); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UseCaseActorXUseCaseDataModel.DataColumns.UseCaseRelationship); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(ProvinceDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case ProvinceDataModel.DataColumns.ProvinceId: if (data.ProvinceId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ProvinceDataModel.DataColumns.ProvinceId, data.ProvinceId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ProvinceDataModel.DataColumns.ProvinceId); } break; case ProvinceDataModel.DataColumns.CountryId: if (data.CountryId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ProvinceDataModel.DataColumns.CountryId, data.CountryId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ProvinceDataModel.DataColumns.CountryId); } break; case ProvinceDataModel.DataColumns.Country: if (!string.IsNullOrEmpty(data.Country)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ProvinceDataModel.DataColumns.Country, data.Country); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ProvinceDataModel.DataColumns.Country); } break; case ProvinceDataModel.DataColumns.ProvinceTypeId: if (data.ProvinceTypeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ProvinceDataModel.DataColumns.ProvinceTypeId, data.ProvinceTypeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ProvinceDataModel.DataColumns.ProvinceTypeId); } break; case ProvinceDataModel.DataColumns.ProvinceType: if (!string.IsNullOrEmpty(data.ProvinceType)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ProvinceDataModel.DataColumns.ProvinceType, data.ProvinceType); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ProvinceDataModel.DataColumns.ProvinceType); } break; case ProvinceDataModel.DataColumns.Name: if (!string.IsNullOrEmpty(data.Name)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ProvinceDataModel.DataColumns.Name, data.Name); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ProvinceDataModel.DataColumns.Name); } break; case ProvinceDataModel.DataColumns.Description: if (!string.IsNullOrEmpty(data.Description)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ProvinceDataModel.DataColumns.Description, data.Description); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ProvinceDataModel.DataColumns.Description); } break; case ProvinceDataModel.DataColumns.SortOrder: if (data.SortOrder != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ProvinceDataModel.DataColumns.SortOrder, data.SortOrder); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ProvinceDataModel.DataColumns.SortOrder); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(OrderStatusTypeDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case OrderStatusTypeDataModel.DataColumns.OrderStatusTypeId: if (data.OrderStatusTypeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, OrderStatusTypeDataModel.DataColumns.OrderStatusTypeId, data.OrderStatusTypeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, OrderStatusTypeDataModel.DataColumns.OrderStatusTypeId); } break; case OrderStatusTypeDataModel.DataColumns.Code: if (!string.IsNullOrEmpty(data.Code)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, OrderStatusTypeDataModel.DataColumns.Code, data.Code); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, OrderStatusTypeDataModel.DataColumns.Code); } break; case OrderStatusTypeDataModel.DataColumns.Description: if (!string.IsNullOrEmpty(data.Description)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, OrderStatusTypeDataModel.DataColumns.Description, data.Description); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, OrderStatusTypeDataModel.DataColumns.Description); } break; case OrderStatusTypeDataModel.DataColumns.OrderStatusGroupId: if (data.OrderStatusGroupId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, OrderStatusTypeDataModel.DataColumns.OrderStatusGroupId, data.OrderStatusGroupId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, OrderStatusTypeDataModel.DataColumns.OrderStatusGroupId); } break; case OrderStatusTypeDataModel.DataColumns.OrderStatusGroup: if (!string.IsNullOrEmpty(data.OrderStatusGroup)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, OrderStatusTypeDataModel.DataColumns.OrderStatusGroup, data.OrderStatusGroup); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, OrderStatusTypeDataModel.DataColumns.OrderStatusGroup); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(TabChildStructureDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case TabChildStructureDataModel.DataColumns.TabChildStructureId: if (data.TabChildStructureId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TabChildStructureDataModel.DataColumns.TabChildStructureId, data.TabChildStructureId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TabChildStructureDataModel.DataColumns.TabChildStructureId); } break; case TabChildStructureDataModel.DataColumns.Name: if (!string.IsNullOrEmpty(data.Name)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TabChildStructureDataModel.DataColumns.Name, data.Name.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TabChildStructureDataModel.DataColumns.Name); } break; case TabChildStructureDataModel.DataColumns.InnerControlPath: if (!string.IsNullOrEmpty(data.Name)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TabChildStructureDataModel.DataColumns.InnerControlPath, data.InnerControlPath.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TabChildStructureDataModel.DataColumns.InnerControlPath); } break; case TabChildStructureDataModel.DataColumns.EntityName: if (!string.IsNullOrEmpty(data.EntityName)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TabChildStructureDataModel.DataColumns.EntityName, data.EntityName.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TabChildStructureDataModel.DataColumns.EntityName); } break; case TabChildStructureDataModel.DataColumns.SortOrder: if (data.SortOrder != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TabChildStructureDataModel.DataColumns.SortOrder, data.SortOrder); } else { returnValue = returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TabChildStructureDataModel.DataColumns.SortOrder); } break; case TabChildStructureDataModel.DataColumns.TabParentStructureId: if (data.TabParentStructureId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TabChildStructureDataModel.DataColumns.TabParentStructureId, data.TabParentStructureId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TabChildStructureDataModel.DataColumns.TabParentStructureId); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(ReportXReportCategoryDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case ReportXReportCategoryDataModel.DataColumns.ReportXReportCategoryId: if (data.ReportXReportCategoryId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReportXReportCategoryDataModel.DataColumns.ReportXReportCategoryId, data.ReportXReportCategoryId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReportXReportCategoryDataModel.DataColumns.ReportXReportCategoryId); } break; case ReportXReportCategoryDataModel.DataColumns.ReportId: if (data.ReportId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReportXReportCategoryDataModel.DataColumns.ReportId, data.ReportId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReportXReportCategoryDataModel.DataColumns.ReportId); } break; case ReportXReportCategoryDataModel.DataColumns.ReportCategoryId: if (data.ReportCategoryId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReportXReportCategoryDataModel.DataColumns.ReportCategoryId, data.ReportCategoryId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReportXReportCategoryDataModel.DataColumns.ReportCategoryId); } break; case ReportXReportCategoryDataModel.DataColumns.Report: if (!string.IsNullOrEmpty(data.Report)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReportXReportCategoryDataModel.DataColumns.Report, data.Report); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReportXReportCategoryDataModel.DataColumns.Report); } break; case ReportXReportCategoryDataModel.DataColumns.ReportCategory: if (!string.IsNullOrEmpty(data.ReportCategory)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReportXReportCategoryDataModel.DataColumns.ReportCategory, data.ReportCategory); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReportXReportCategoryDataModel.DataColumns.ReportCategory); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(TxInvestmentDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case TxInvestmentDataModel.DataColumns.TxInvestmentId: if (data.TxInvestmentId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TxInvestmentDataModel.DataColumns.TxInvestmentId, data.TxInvestmentId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxInvestmentDataModel.DataColumns.TxInvestmentId); } break; case TxInvestmentDataModel.DataColumns.TransactionEventId: if (data.TransactionEventId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TxInvestmentDataModel.DataColumns.TransactionEventId, data.TransactionEventId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxInvestmentDataModel.DataColumns.TransactionEventId); } break; case TxInvestmentDataModel.DataColumns.TransactionEvent: if (!string.IsNullOrEmpty(data.TransactionEvent)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TxInvestmentDataModel.DataColumns.TransactionEvent, data.TransactionEvent); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxInvestmentDataModel.DataColumns.TransactionEvent); } break; case TxInvestmentDataModel.DataColumns.InvestmentId: if (data.InvestmentId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TxInvestmentDataModel.DataColumns.InvestmentId, data.InvestmentId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxInvestmentDataModel.DataColumns.InvestmentId); } break; case TxInvestmentDataModel.DataColumns.CustAccountId: if (data.CustAccountId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TxInvestmentDataModel.DataColumns.CustAccountId, data.CustAccountId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TxInvestmentDataModel.DataColumns.CustAccountId); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(SubClassDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case SubClassDataModel.DataColumns.SubClassId: if (data.SubClassId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SubClassDataModel.DataColumns.SubClassId, data.SubClassId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SubClassDataModel.DataColumns.SubClassId); } break; case SubClassDataModel.DataColumns.FundId: if (data.FundId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SubClassDataModel.DataColumns.FundId, data.FundId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SubClassDataModel.DataColumns.FundId); } break; case SubClassDataModel.DataColumns.Fund: if (!string.IsNullOrEmpty(data.Fund)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SubClassDataModel.DataColumns.Fund, data.Fund); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SubClassDataModel.DataColumns.Fund); } break; case SubClassDataModel.DataColumns.Name: if (!string.IsNullOrEmpty(data.Name)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SubClassDataModel.DataColumns.Name, data.Name); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SubClassDataModel.DataColumns.Name); } break; case SubClassDataModel.DataColumns.Description: if (!string.IsNullOrEmpty(data.Description)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SubClassDataModel.DataColumns.Description, data.Description); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SubClassDataModel.DataColumns.Description); } break; case SubClassDataModel.DataColumns.SortOrder: if (data.SortOrder != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SubClassDataModel.DataColumns.SortOrder, data.SortOrder); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SubClassDataModel.DataColumns.SortOrder); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static string ToSQLParameter(SearchKeyDetailDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case SearchKeyDetailDataModel.DataColumns.SearchKeyDetailId: if (data.SearchKeyDetailId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SearchKeyDetailDataModel.DataColumns.SearchKeyDetailId, data.SearchKeyDetailId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SearchKeyDetailDataModel.DataColumns.SearchKeyDetailId); } break; case SearchKeyDetailDataModel.DataColumns.SearchKeyId: if (data.SearchKeyId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SearchKeyDetailDataModel.DataColumns.SearchKeyId, data.SearchKeyId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SearchKeyDetailDataModel.DataColumns.SearchKeyId); } break; case SearchKeyDetailDataModel.DataColumns.SearchParameter: if (!string.IsNullOrEmpty(data.SearchParameter)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SearchKeyDetailDataModel.DataColumns.SearchParameter, data.SearchParameter.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SearchKeyDetailDataModel.DataColumns.SearchParameter); } break; case SearchKeyDetailDataModel.DataColumns.SearchKey: if (!string.IsNullOrEmpty(data.SearchKey)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SearchKeyDetailDataModel.DataColumns.SearchKey, data.SearchKey.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SearchKeyDetailDataModel.DataColumns.SearchKey); } break; case SearchKeyDetailDataModel.DataColumns.SortOrder: if (data.SortOrder != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SearchKeyDetailDataModel.DataColumns.SortOrder, data.SortOrder); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SearchKeyDetailDataModel.DataColumns.SortOrder); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
void Start() { if (Instance == null) Instance = this; }
public static string ToSQLParameter(ConnectionStringXApplicationDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case ConnectionStringXApplicationDataModel.DataColumns.ConnectionStringXApplicationId: if (data.ConnectionStringXApplicationId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ConnectionStringXApplicationDataModel.DataColumns.ConnectionStringXApplicationId, data.ConnectionStringXApplicationId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ConnectionStringXApplicationDataModel.DataColumns.ConnectionStringXApplicationId); } break; case ConnectionStringXApplicationDataModel.DataColumns.ApplicationId: if (data.ApplicationId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ConnectionStringXApplicationDataModel.DataColumns.ApplicationId, data.ApplicationId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ConnectionStringXApplicationDataModel.DataColumns.ApplicationId); } break; case ConnectionStringXApplicationDataModel.DataColumns.ConnectionStringId: if (data.ConnectionStringId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ConnectionStringXApplicationDataModel.DataColumns.ConnectionStringId, data.ConnectionStringId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ConnectionStringXApplicationDataModel.DataColumns.ConnectionStringId); } break; case ConnectionStringXApplicationDataModel.DataColumns.ConnectionString: if (!string.IsNullOrEmpty(data.ConnectionString)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ConnectionStringXApplicationDataModel.DataColumns.ConnectionString, data.ConnectionString); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ConnectionStringXApplicationDataModel.DataColumns.ConnectionString); } break; case ConnectionStringXApplicationDataModel.DataColumns.Application: if (!string.IsNullOrEmpty(data.Application)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ConnectionStringXApplicationDataModel.DataColumns.Application, data.Application); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ConnectionStringXApplicationDataModel.DataColumns.Application); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }