public static string ToSQLParameter(ReportDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case ReportDataModel.DataColumns.ReportId:
if (data.ReportId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReportDataModel.DataColumns.ReportId, data.ReportId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReportDataModel.DataColumns.ReportId);
}
break;
case ReportDataModel.DataColumns.Title:
if (!string.IsNullOrEmpty(data.Title))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReportDataModel.DataColumns.Title, data.Title);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReportDataModel.DataColumns.Title);
}
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 ReportDataModel.DataColumns.Application:
if (!string.IsNullOrEmpty(data.Application))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReportDataModel.DataColumns.Application, data.Application.Trim());
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReportDataModel.DataColumns.Application);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(TaskPriorityTypeDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case TaskPriorityTypeDataModel.DataColumns.TaskPriorityTypeId:
if (data.TaskPriorityTypeId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TaskPriorityTypeDataModel.DataColumns.TaskPriorityTypeId, data.TaskPriorityTypeId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskPriorityTypeDataModel.DataColumns.TaskPriorityTypeId);
}
break;
case TaskPriorityTypeDataModel.DataColumns.Weight:
if (data.Weight != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TaskPriorityTypeDataModel.DataColumns.Weight, data.Weight);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskPriorityTypeDataModel.DataColumns.Weight);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(TypeOfIssueDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case TypeOfIssueDataModel.DataColumns.TypeOfIssueId:
if (data.TypeOfIssueId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TypeOfIssueDataModel.DataColumns.TypeOfIssueId, data.TypeOfIssueId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TypeOfIssueDataModel.DataColumns.TypeOfIssueId);
}
break;
case TypeOfIssueDataModel.DataColumns.Category:
if (!string.IsNullOrEmpty(data.Category))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TypeOfIssueDataModel.DataColumns.Category, data.Category);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TypeOfIssueDataModel.DataColumns.Category);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(ApplicationMonitoredEventSourceDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case ApplicationMonitoredEventSourceDataModel.DataColumns.ApplicationMonitoredEventSourceId:
if (data.ApplicationMonitoredEventSourceId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ApplicationMonitoredEventSourceDataModel.DataColumns.ApplicationMonitoredEventSourceId, data.ApplicationMonitoredEventSourceId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationMonitoredEventSourceDataModel.DataColumns.ApplicationMonitoredEventSourceId);
}
break;
case ApplicationMonitoredEventSourceDataModel.DataColumns.Code:
if (!string.IsNullOrEmpty(data.Code))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ApplicationMonitoredEventSourceDataModel.DataColumns.Code, data.Code.Trim());
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationMonitoredEventSourceDataModel.DataColumns.Code);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(ApplicationAttributeDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case ApplicationAttributeDataModel.DataColumns.ApplicationId:
if (data.ApplicationId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ApplicationAttributeDataModel.DataColumns.ApplicationId, data.ApplicationId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationAttributeDataModel.DataColumns.ApplicationId);
}
break;
case ApplicationAttributeDataModel.DataColumns.RenderApplicationFilter:
if (data.RenderApplicationFilter != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ApplicationAttributeDataModel.DataColumns.RenderApplicationFilter, data.RenderApplicationFilter);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationAttributeDataModel.DataColumns.RenderApplicationFilter);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(BatchFileSetDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case BatchFileSetDataModel.DataColumns.BatchFileSetId:
if (data.BatchFileSetId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, BatchFileSetDataModel.DataColumns.BatchFileSetId, data.BatchFileSetId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, BatchFileSetDataModel.DataColumns.BatchFileSetId);
}
break;
case BatchFileSetDataModel.DataColumns.CreatedByPersonId:
if (data.CreatedByPersonId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, BatchFileSetDataModel.DataColumns.CreatedByPersonId, data.CreatedByPersonId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, BatchFileSetDataModel.DataColumns.CreatedByPersonId);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(SearchKeyDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case SearchKeyDataModel.DataColumns.SearchKeyId:
if (data.SearchKeyId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SearchKeyDataModel.DataColumns.SearchKeyId, data.SearchKeyId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SearchKeyDataModel.DataColumns.SearchKeyId);
}
break;
case SearchKeyDataModel.DataColumns.View:
if (data.View != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SearchKeyDataModel.DataColumns.View, data.View);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SearchKeyDataModel.DataColumns.View);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(FeatureRuleDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case FeatureRuleDataModel.DataColumns.FeatureRuleId:
if (data.FeatureRuleId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FeatureRuleDataModel.DataColumns.FeatureRuleId, data.FeatureRuleId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FeatureRuleDataModel.DataColumns.FeatureRuleId);
}
break;
case FeatureRuleDataModel.DataColumns.FeatureRuleCategoryId:
if (data.FeatureRuleCategoryId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FeatureRuleDataModel.DataColumns.FeatureRuleCategoryId, data.FeatureRuleCategoryId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FeatureRuleDataModel.DataColumns.FeatureRuleCategoryId);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(CountryDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case CountryDataModel.DataColumns.CountryId:
if (data.CountryId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, CountryDataModel.DataColumns.CountryId, data.CountryId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CountryDataModel.DataColumns.CountryId);
}
break;
case CountryDataModel.DataColumns.TimeZoneId:
if (data.TimeZoneId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, CountryDataModel.DataColumns.TimeZoneId, data.TimeZoneId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, CountryDataModel.DataColumns.TimeZoneId);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(NotificationEventTypeDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case NotificationEventTypeDataModel.DataColumns.NotificationEventTypeId:
if (data.NotificationEventTypeId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, NotificationEventTypeDataModel.DataColumns.NotificationEventTypeId, data.NotificationEventTypeId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, NotificationEventTypeDataModel.DataColumns.NotificationEventTypeId);
}
break;
case NotificationEventTypeDataModel.DataColumns.ApplicationId:
if (data.ApplicationId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, NotificationEventTypeDataModel.DataColumns.ApplicationId, data.ApplicationId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, NotificationEventTypeDataModel.DataColumns.ApplicationId);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(TabParentStructureDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case TabParentStructureDataModel.DataColumns.TabParentStructureId:
if (data.TabParentStructureId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TabParentStructureDataModel.DataColumns.TabParentStructureId, data.TabParentStructureId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TabParentStructureDataModel.DataColumns.TabParentStructureId);
}
break;
case TabParentStructureDataModel.DataColumns.IsAllTab:
if (data.IsAllTab != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TabParentStructureDataModel.DataColumns.IsAllTab, data.IsAllTab);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TabParentStructureDataModel.DataColumns.IsAllTab);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(ScheduleItemDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case ScheduleItemDataModel.DataColumns.ScheduleItemId:
if (data.ScheduleItemId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ScheduleItemDataModel.DataColumns.ScheduleItemId, data.ScheduleItemId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleItemDataModel.DataColumns.ScheduleItemId);
}
break;
case ScheduleItemDataModel.DataColumns.ScheduleId:
if (data.ScheduleId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ScheduleItemDataModel.DataColumns.ScheduleId, data.ScheduleId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleItemDataModel.DataColumns.ScheduleId);
}
break;
case ScheduleItemDataModel.DataColumns.TaskFormulationId:
if (data.TaskFormulationId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ScheduleItemDataModel.DataColumns.TaskFormulationId, data.TaskFormulationId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleItemDataModel.DataColumns.TaskFormulationId);
}
break;
case ScheduleItemDataModel.DataColumns.TotalTimeSpent:
if (data.TotalTimeSpent != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ScheduleItemDataModel.DataColumns.TotalTimeSpent, data.TotalTimeSpent);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleItemDataModel.DataColumns.TotalTimeSpent);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(UserPreferenceKeyDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case UserPreferenceKeyDataModel.DataColumns.UserPreferenceKeyId:
if (data.UserPreferenceKeyId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, UserPreferenceKeyDataModel.DataColumns.UserPreferenceKeyId, data.UserPreferenceKeyId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UserPreferenceKeyDataModel.DataColumns.UserPreferenceKeyId);
}
break;
case UserPreferenceKeyDataModel.DataColumns.Value:
if (!string.IsNullOrEmpty(data.Value))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, UserPreferenceKeyDataModel.DataColumns.Value, data.Value);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UserPreferenceKeyDataModel.DataColumns.Value);
}
break;
case UserPreferenceKeyDataModel.DataColumns.DataTypeId:
if (data.DataTypeId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, UserPreferenceKeyDataModel.DataColumns.DataTypeId, data.DataTypeId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UserPreferenceKeyDataModel.DataColumns.DataTypeId);
}
break;
case UserPreferenceKeyDataModel.DataColumns.DataType:
if (!string.IsNullOrEmpty(data.DataType))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, UserPreferenceKeyDataModel.DataColumns.DataType, data.DataType);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UserPreferenceKeyDataModel.DataColumns.DataType);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(ReleaseNoteBusinessValueDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case ReleaseNoteBusinessValueDataModel.DataColumns.ReleaseNoteBusinessValueId:
if (data.ReleaseNoteBusinessValueId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ReleaseNoteBusinessValueDataModel.DataColumns.ReleaseNoteBusinessValueId, data.ReleaseNoteBusinessValueId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseNoteBusinessValueDataModel.DataColumns.ReleaseNoteBusinessValueId);
}
break;
case ReleaseNoteBusinessValueDataModel.DataColumns.DateCreated:
if (data.DateCreated != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseNoteBusinessValueDataModel.DataColumns.DateCreated, data.DateCreated);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseNoteBusinessValueDataModel.DataColumns.DateCreated);
}
break;
case ReleaseNoteBusinessValueDataModel.DataColumns.DateModified:
if (data.DateModified != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ReleaseNoteBusinessValueDataModel.DataColumns.DateModified, data.DateModified);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ReleaseNoteBusinessValueDataModel.DataColumns.DateModified);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(FunctionalityStatusDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case FunctionalityStatusDataModel.DataColumns.FunctionalityStatusId:
if (data.FunctionalityStatusId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityStatusDataModel.DataColumns.FunctionalityStatusId, data.FunctionalityStatusId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityStatusDataModel.DataColumns.FunctionalityStatusId);
}
break;
case DataModel.TaskTimeTracker.ApplicationDevelopment.FunctionalityStatusDataModel.BaseDataColumns.ApplicationId:
if (data.ApplicationId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DataModel.TaskTimeTracker.ApplicationDevelopment.FunctionalityStatusDataModel.BaseDataColumns.ApplicationId, data.ApplicationId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.TaskTimeTracker.ApplicationDevelopment.FunctionalityStatusDataModel.BaseDataColumns.ApplicationId);
}
break;
case DataModel.TaskTimeTracker.ApplicationDevelopment.FunctionalityStatusDataModel.DataColumns.Application:
if (!string.IsNullOrEmpty(data.Application))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DataModel.TaskTimeTracker.ApplicationDevelopment.FunctionalityStatusDataModel.DataColumns.Application, data.Application.Trim());
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.TaskTimeTracker.ApplicationDevelopment.FunctionalityStatusDataModel.DataColumns.Application);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(FunctionalityImageAttributeDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case FunctionalityImageAttributeDataModel.DataColumns.FunctionalityImageAttributeId:
if (data.FunctionalityImageAttributeId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityImageAttributeDataModel.DataColumns.FunctionalityImageAttributeId, data.FunctionalityImageAttributeId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityImageAttributeDataModel.DataColumns.FunctionalityImageAttributeId);
}
break;
case FunctionalityImageAttributeDataModel.DataColumns.FunctionalityImageId:
if (data.FunctionalityImageId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityImageAttributeDataModel.DataColumns.FunctionalityImageId, data.FunctionalityImageId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityImageAttributeDataModel.DataColumns.FunctionalityImageId);
}
break;
case FunctionalityImageAttributeDataModel.DataColumns.FunctionalityImage:
if (data.FunctionalityImage != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityImageAttributeDataModel.DataColumns.FunctionalityImage, data.FunctionalityImage);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityImageAttributeDataModel.DataColumns.FunctionalityImage);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(SuperKeyDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case SuperKeyDataModel.DataColumns.SuperKeyId:
if (data.SuperKeyId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SuperKeyDataModel.DataColumns.SuperKeyId, data.SuperKeyId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SuperKeyDataModel.DataColumns.SuperKeyId);
}
break;
case SuperKeyDataModel.DataColumns.SystemEntityTypeId:
if (data.SystemEntityTypeId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SuperKeyDataModel.DataColumns.SystemEntityTypeId, data.SystemEntityTypeId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SuperKeyDataModel.DataColumns.SystemEntityTypeId);
}
break;
case SuperKeyDataModel.DataColumns.ExpirationDate:
if (data.ExpirationDate != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SuperKeyDataModel.DataColumns.ExpirationDate, data.ExpirationDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SuperKeyDataModel.DataColumns.ExpirationDate);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(ActivityDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case ActivityDataModel.DataColumns.ActivityId:
if (data.ActivityId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ActivityDataModel.DataColumns.ActivityId, data.ActivityId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ActivityDataModel.DataColumns.ActivityId);
}
break;
case ActivityDataModel.DataColumns.LayerId:
if (data.LayerId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ActivityDataModel.DataColumns.LayerId, data.LayerId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ActivityDataModel.DataColumns.LayerId);
}
break;
case ActivityDataModel.DataColumns.Layer:
if (data.Layer != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ActivityDataModel.DataColumns.Layer, data.Layer);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ActivityDataModel.DataColumns.Layer);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(MilestoneDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case MilestoneDataModel.DataColumns.MilestoneId:
if (data.MilestoneId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, MilestoneDataModel.DataColumns.MilestoneId, data.MilestoneId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MilestoneDataModel.DataColumns.MilestoneId);
}
break;
case MilestoneDataModel.DataColumns.ProjectId:
if (data.ProjectId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, MilestoneDataModel.DataColumns.ProjectId, data.ProjectId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MilestoneDataModel.DataColumns.ProjectId);
}
break;
case MilestoneDataModel.DataColumns.Project:
if (data.Project != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, MilestoneDataModel.DataColumns.Project, data.Project);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MilestoneDataModel.DataColumns.Project);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(HelpPageContextDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case HelpPageContextDataModel.DataColumns.HelpPageContextId:
if (data.HelpPageContextId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, HelpPageContextDataModel.DataColumns.HelpPageContextId, data.HelpPageContextId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, HelpPageContextDataModel.DataColumns.HelpPageContextId);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(FieldConfigurationModeAccessModeDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case FieldConfigurationModeAccessModeDataModel.DataColumns.FieldConfigurationModeAccessModeId:
if (data.FieldConfigurationModeAccessModeId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FieldConfigurationModeAccessModeDataModel.DataColumns.FieldConfigurationModeAccessModeId, data.FieldConfigurationModeAccessModeId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationModeAccessModeDataModel.DataColumns.FieldConfigurationModeAccessModeId);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(ScheduleDetailActivityCategoryDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case ScheduleDetailActivityCategoryDataModel.DataColumns.ScheduleDetailActivityCategoryId:
if (data.ScheduleDetailActivityCategoryId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ScheduleDetailActivityCategoryDataModel.DataColumns.ScheduleDetailActivityCategoryId, data.ScheduleDetailActivityCategoryId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleDetailActivityCategoryDataModel.DataColumns.ScheduleDetailActivityCategoryId);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(EntityDateRangeStateTypeDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case EntityDateRangeStateTypeDataModel.DataColumns.EntityDateRangeStateTypeId:
if (data.EntityDateRangeStateTypeId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, EntityDateRangeStateTypeDataModel.DataColumns.EntityDateRangeStateTypeId, data.EntityDateRangeStateTypeId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, EntityDateRangeStateTypeDataModel.DataColumns.EntityDateRangeStateTypeId);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(DailyTaskItemQueueStatusDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case DailyTaskItemQueueStatusDataModel.DataColumns.DailyTaskItemQueueStatusId:
if (data.DailyTaskItemQueueStatusId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DailyTaskItemQueueStatusDataModel.DataColumns.DailyTaskItemQueueStatusId, data.DailyTaskItemQueueStatusId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DailyTaskItemQueueStatusDataModel.DataColumns.DailyTaskItemQueueStatusId);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(SystemForeignRelationshipTypeDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case SystemForeignRelationshipTypeDataModel.DataColumns.SystemForeignRelationshipTypeId:
if (data.SystemForeignRelationshipTypeId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SystemForeignRelationshipTypeDataModel.DataColumns.SystemForeignRelationshipTypeId, data.SystemForeignRelationshipTypeId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SystemForeignRelationshipTypeDataModel.DataColumns.SystemForeignRelationshipTypeId);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(ProjectPortfolioDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case ProjectPortfolioDataModel.DataColumns.ProjectPortfolioId:
if (data.ProjectPortfolioId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ProjectPortfolioDataModel.DataColumns.ProjectPortfolioId, data.ProjectPortfolioId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ProjectPortfolioDataModel.DataColumns.ProjectPortfolioId);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(ApplicationEntityParentalHierarchyDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case ApplicationEntityParentalHierarchyDataModel.DataColumns.ApplicationEntityParentalHierarchyId:
if (data.ApplicationEntityParentalHierarchyId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ApplicationEntityParentalHierarchyDataModel.DataColumns.ApplicationEntityParentalHierarchyId, data.ApplicationEntityParentalHierarchyId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationEntityParentalHierarchyDataModel.DataColumns.ApplicationEntityParentalHierarchyId);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(FunctionalityEntityStatusArchiveDataModel data, string dataColumnName, object value)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case FunctionalityEntityStatusArchiveDataModel.DataColumns.FunctionalityEntityStatusArchiveId:
if (data.FunctionalityEntityStatusArchiveId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityEntityStatusArchiveDataModel.DataColumns.FunctionalityEntityStatusArchiveId, data.FunctionalityEntityStatusArchiveId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusArchiveDataModel.DataColumns.FunctionalityEntityStatusArchiveId);
}
break;
case FunctionalityEntityStatusArchiveDataModel.DataColumns.FunctionalityEntityStatusId:
if (data.FunctionalityEntityStatusId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityEntityStatusArchiveDataModel.DataColumns.FunctionalityEntityStatusId, data.FunctionalityEntityStatusId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusArchiveDataModel.DataColumns.FunctionalityEntityStatusId);
}
break;
case FunctionalityEntityStatusArchiveDataModel.DataColumns.Functionality:
if (data.Functionality != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityEntityStatusArchiveDataModel.DataColumns.Functionality, data.Functionality);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusArchiveDataModel.DataColumns.Functionality);
}
break;
case FunctionalityEntityStatusArchiveDataModel.DataColumns.FunctionalityStatus:
if (value != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityEntityStatusArchiveDataModel.DataColumns.FunctionalityStatus, value);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusArchiveDataModel.DataColumns.FunctionalityStatus);
}
break;
case FunctionalityEntityStatusArchiveDataModel.DataColumns.FunctionalityPriority:
if (data.FunctionalityPriority != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FunctionalityEntityStatusArchiveDataModel.DataColumns.FunctionalityPriority, data.FunctionalityPriority);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusArchiveDataModel.DataColumns.FunctionalityPriority);
}
break;
case FunctionalityEntityStatusArchiveDataModel.DataColumns.Memo:
if (data.Memo != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FunctionalityEntityStatusArchiveDataModel.DataColumns.Memo, data.Memo);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusArchiveDataModel.DataColumns.Memo);
}
break;
case FunctionalityEntityStatusArchiveDataModel.DataColumns.SystemEntityType:
if (data.SystemEntityType != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FunctionalityEntityStatusArchiveDataModel.DataColumns.SystemEntityType, data.SystemEntityType);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusArchiveDataModel.DataColumns.SystemEntityType);
}
break;
case FunctionalityEntityStatusArchiveDataModel.DataColumns.StartDate:
if (data.StartDate != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FunctionalityEntityStatusArchiveDataModel.DataColumns.StartDate, data.StartDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusArchiveDataModel.DataColumns.StartDate);
}
break;
case FunctionalityEntityStatusArchiveDataModel.DataColumns.TargetDate:
if (data.TargetDate != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FunctionalityEntityStatusArchiveDataModel.DataColumns.TargetDate, data.TargetDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusArchiveDataModel.DataColumns.TargetDate);
}
break;
case FunctionalityEntityStatusArchiveDataModel.DataColumns.AssignedTo:
if (data.AssignedTo != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FunctionalityEntityStatusArchiveDataModel.DataColumns.AssignedTo, data.AssignedTo);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityEntityStatusArchiveDataModel.DataColumns.AssignedTo);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(ScheduleEmailDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case ScheduleEmailDataModel.DataColumns.ScheduleEmailId:
if (data.ScheduleEmailId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ScheduleEmailDataModel.DataColumns.ScheduleEmailId, data.ScheduleEmailId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleEmailDataModel.DataColumns.ScheduleEmailId);
}
break;
case ScheduleEmailDataModel.DataColumns.ScheduleId:
if (data.ScheduleId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleEmailDataModel.DataColumns.ScheduleId, data.ScheduleId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleEmailDataModel.DataColumns.ScheduleId);
}
break;
case ScheduleEmailDataModel.DataColumns.SentDate:
if (data.SentDate != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleEmailDataModel.DataColumns.SentDate, data.SentDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleEmailDataModel.DataColumns.SentDate);
}
break;
case ScheduleEmailDataModel.DataColumns.CreatedDate:
if (data.CreatedDate != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleEmailDataModel.DataColumns.CreatedDate, data.CreatedDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleEmailDataModel.DataColumns.CreatedDate);
}
break;
case ScheduleEmailDataModel.DataColumns.SentTo:
if (!string.IsNullOrEmpty(data.SentTo))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleEmailDataModel.DataColumns.SentTo, data.SentTo);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleEmailDataModel.DataColumns.SentTo);
}
break;
case ScheduleEmailDataModel.DataColumns.UpdatedDate:
if (data.UpdatedDate != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleEmailDataModel.DataColumns.UpdatedDate, data.UpdatedDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleEmailDataModel.DataColumns.UpdatedDate);
}
break;
//case ScheduleEmailDataModel.DataColumns.LastAction:
// if (data.LastAction != null)
// {
// returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleEmailDataModel.DataColumns.LastAction, data.LastAction);
// }
// else
// {
// returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleEmailDataModel.DataColumns.LastAction);
// }
// break;
case ScheduleEmailDataModel.DataColumns.ModifiedDate:
if (data.ModifiedDate != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleEmailDataModel.DataColumns.ModifiedDate, data.ModifiedDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleEmailDataModel.DataColumns.ModifiedDate);
}
break;
case ScheduleEmailDataModel.DataColumns.CreatedByAuditId:
if (data.CreatedByAuditId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleEmailDataModel.DataColumns.CreatedByAuditId, data.CreatedByAuditId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleEmailDataModel.DataColumns.CreatedByAuditId);
}
break;
case ScheduleEmailDataModel.DataColumns.ModifiedByAuditId:
if (data.ModifiedByAuditId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleEmailDataModel.DataColumns.ModifiedByAuditId, data.ModifiedByAuditId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleEmailDataModel.DataColumns.ModifiedByAuditId);
}
break;
case ScheduleEmailDataModel.DataColumns.FromSearchDate:
if (data.FromSearchDate != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleEmailDataModel.DataColumns.FromSearchDate, data.FromSearchDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleEmailDataModel.DataColumns.FromSearchDate);
}
break;
case ScheduleEmailDataModel.DataColumns.ToSearchDate:
if (data.ToSearchDate != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleEmailDataModel.DataColumns.ToSearchDate, data.ToSearchDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleEmailDataModel.DataColumns.ToSearchDate);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static string ToSQLParameter(ScheduleDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case ScheduleDataModel.DataColumns.ScheduleId:
if (data.ScheduleId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ScheduleDataModel.DataColumns.ScheduleId, data.ScheduleId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleDataModel.DataColumns.ScheduleId);
}
break;
case ScheduleDataModel.DataColumns.PersonId:
if (data.PersonId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ScheduleDataModel.DataColumns.PersonId, data.PersonId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleDataModel.DataColumns.PersonId);
}
break;
case ScheduleDataModel.DataColumns.ScheduleStateId:
if (data.ScheduleStateId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ScheduleDataModel.DataColumns.ScheduleStateId, data.ScheduleStateId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleDataModel.DataColumns.ScheduleStateId);
}
break;
case ScheduleDataModel.DataColumns.ScheduleStateName:
if (data.ScheduleStateName != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleDataModel.DataColumns.ScheduleStateName, data.ScheduleStateName);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleDataModel.DataColumns.ScheduleStateName);
}
break;
case ScheduleDataModel.DataColumns.WorkDate:
if (data.WorkDate != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleDataModel.DataColumns.WorkDate, data.WorkDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleDataModel.DataColumns.WorkDate);
}
break;
case ScheduleDataModel.DataColumns.StartTime:
if (data.StartTime != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleDataModel.DataColumns.StartTime, data.StartTime);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleDataModel.DataColumns.StartTime);
}
break;
case ScheduleDataModel.DataColumns.EndTime:
if (data.EndTime != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleDataModel.DataColumns.EndTime, data.EndTime);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleDataModel.DataColumns.EndTime);
}
break;
case ScheduleDataModel.DataColumns.TotalHoursWorked:
if (data.TotalHoursWorked != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ScheduleDataModel.DataColumns.TotalHoursWorked, data.TotalHoursWorked);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleDataModel.DataColumns.TotalHoursWorked);
}
break;
case ScheduleDataModel.DataColumns.ComputedHours:
if (data.ComputedHours != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ScheduleDataModel.DataColumns.ComputedHours, data.ComputedHours);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleDataModel.DataColumns.ComputedHours);
}
break;
case ScheduleDataModel.DataColumns.NextWorkDate:
if (data.NextWorkDate != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleDataModel.DataColumns.NextWorkDate, data.NextWorkDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleDataModel.DataColumns.NextWorkDate);
}
break;
case ScheduleDataModel.DataColumns.NextWorkTime:
if (data.NextWorkTime != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleDataModel.DataColumns.NextWorkTime, data.NextWorkTime);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleDataModel.DataColumns.NextWorkTime);
}
break;
case ScheduleDataModel.DataColumns.FromSearchDate:
if (data.FromSearchDate != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleDataModel.DataColumns.FromSearchDate, data.FromSearchDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleDataModel.DataColumns.FromSearchDate);
}
break;
case ScheduleDataModel.DataColumns.ToSearchDate:
if (data.ToSearchDate != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleDataModel.DataColumns.ToSearchDate, data.ToSearchDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleDataModel.DataColumns.ToSearchDate);
}
break;
case ScheduleDataModel.DataColumns.Person:
if (data.Person != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleDataModel.DataColumns.Person, data.Person);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleDataModel.DataColumns.Person);
}
break;
//case ScheduleDataModel.DataColumns.CreatedDate:
// if (data.CreatedDate != null)
// {
// returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleDataModel.DataColumns.CreatedDate, data.CreatedDate);
// }
// else
// {
// returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleDataModel.DataColumns.CreatedDate);
// }
// break;
//case ScheduleDataModel.DataColumns.ModifiedDate:
// if (data.ModifiedDate != null)
// {
// returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleDataModel.DataColumns.ModifiedDate, data.ModifiedDate);
// }
// else
// {
// returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleDataModel.DataColumns.ModifiedDate);
// }
// break;
//case ScheduleDataModel.DataColumns.CreatedByAuditId:
// if (data.CreatedByAuditId != null)
// {
// returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ScheduleDataModel.DataColumns.CreatedByAuditId, data.CreatedByAuditId);
// }
// else
// {
// returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleDataModel.DataColumns.CreatedByAuditId);
// }
// break;
//case ScheduleDataModel.DataColumns.ModifiedByAuditId:
// if (data.ModifiedByAuditId != null)
// {
// returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ScheduleDataModel.DataColumns.ModifiedByAuditId, data.ModifiedByAuditId);
// }
// else
// {
// returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleDataModel.DataColumns.ModifiedByAuditId);
// }
// break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}