/// <summary>
/// Returns a SQL Script that will Set the destination column in the Table
/// to the values of the associated Extended Date field, converted from "mmddyyyy (no spaces)" format.
/// The Values will only be set for rows that contain the extended data.
/// </summary>
private string FromMMDDYYYY()
{
return(string.Format(UpdateDateTime,
ExtendedFieldDataScriptor.UsingTableScriptor.TableName,
Column,
Util.InsertDelimiters(Util.Clean(Util.PullValue(ExtendedFieldKey)), Delimiters.DASH), //convert the "mmddyyyy" to "mm-dd-yyyy", which SQL can process
ExtendedFieldKey,
SqlDateStyles.MMDDYYYY_DASH));
}
/// <summary>
/// Returns a SQL Script that will test Setting the destination column in the Table
/// to the values of the associated Extended Date field, converted from "mmddyyyy (no spaces)" format.
/// The Values will only be set for rows that contain the extended data.
/// </summary>
public string FromMMDDYYYY()
{
string contextName = ExtendedFieldDataScriptor.UsingTableScriptor.Context;
//if a context was specified, we can give more specific information back about any conversion failures
switch (contextName)
{
case ContextNames.Reports:
return(string.Format(
ProcessExtractedDateWithContextScript,
ExtendedFieldDataScriptor.UsingTableScriptor.TableName,
Column,
//create value script to get value, strip outer whitespace/double quotes, and insert dashes so we can match against a built in SQL date style
Util.InsertDelimiters(Util.Clean(Util.PullValue(ExtendedFieldDataScriptor.Key)), Delimiters.DASH),
ExtendedFieldDataScriptor.Key,
SqlDateStyles.MMDDYYYY_DASH,
DateStyles.MMDDYYYY,
"dbo.Reports",
"Report_Id"));
case ContextNames.Summaries:
return(string.Format(
ProcessExtractedDateWithContextScript,
ExtendedFieldDataScriptor.UsingTableScriptor.TableName,
Column,
//create value script to get value, strip outer whitespace/double quotes, and insert dashes so we can match against a built in SQL date style
Util.InsertDelimiters(Util.Clean(Util.PullValue(ExtendedFieldKey)), Delimiters.DASH),
ExtendedFieldDataScriptor.Key,
SqlDateStyles.MMDDYYYY_DASH,
DateStyles.MMDDYYYY,
"dbo.Summaries",
"Summary_Id"));
case ContextNames.Administration:
case ContextNames.Audit:
case ContextNames.ExternalApi:
case ContextNames.Media:
case ContextNames.Messaging:
case ContextNames.Metadata:
case ContextNames.RecentInfo:
default:
return(string.Format(
ProcessExtractedDateWithoutContextScript,
ExtendedFieldDataScriptor.UsingTableScriptor.TableName,
Column,
Util.InsertDelimiters(Util.Clean(Util.PullValue(ExtendedFieldKey)), Delimiters.DASH), //convert the "mmddyyyy" to "mm-dd-yyyy", which SQL can process
ExtendedFieldKey,
SqlDateStyles.MMDDYYYY_DASH,
DateStyles.MMDDYYYY));
}
}