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