/// <summary>
/// Applies the rule
/// </summary>
public override void ApplyRule(DataRow row)
{
if (!row.Table.Columns.Contains(this.DestinationColumnName) || !row.Table.Columns.Contains(this.SourceColumnName))
{
return;
}
string value = string.Empty;
if (this.FormatType != FormatTypes.EpiWeek)
{
value = string.Format(System.Globalization.CultureInfo.CurrentCulture, this.GetFormatString(), row[this.SourceColumnName]) + this.Suffix;
value = value.Trim();
}
else
{
StatisticsRepository.EpiWeek epiWeek = new StatisticsRepository.EpiWeek();
if (row[this.SourceColumnName] != null && !string.IsNullOrEmpty(row[this.SourceColumnName].ToString()))
{
string datestring = row[this.SourceColumnName].ToString();
DateTime?dt = Convert.ToDateTime(datestring);
value = epiWeek.GetEpiWeek(dt).ToString();
value = value.Trim();
}
}
if (string.IsNullOrEmpty(value))
{
row[this.DestinationColumnName] = DBNull.Value;
}
else
{
row[this.DestinationColumnName] = value;
}
}
private void cbxFormatOptions_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbxFormatOptions.SelectedIndex >= 0)
{
FormatTypes type = GetFormatType();
if (type != FormatTypes.EpiWeek)
{
Rule_Format tempFormatRule = new Rule_Format(dashboardHelper, "temp", "temp", "temp", "temp", type);
string formatString = tempFormatRule.GetFormatString();
txtPreview.Text = string.Format(System.Globalization.CultureInfo.CurrentCulture, formatString, DateTime.Now);
}
else
{
StatisticsRepository.EpiWeek epiWeek = new StatisticsRepository.EpiWeek();
txtPreview.Text = epiWeek.GetEpiWeek(DateTime.Now).ToString().Trim();
}
}
}
/// <summary>
/// Applies the rule
/// </summary>
public override void ApplyRule(DataRow row)
{
if (!row.Table.Columns.Contains(this.DestinationColumnName) || !row.Table.Columns.Contains(this.SourceColumnName))
{
return;
}
string value = string.Empty;
if (this.FormatType != FormatTypes.EpiWeek)
{
value = string.Format(System.Globalization.CultureInfo.CurrentCulture, this.GetFormatString(), row[this.SourceColumnName]) + this.Suffix;
value = value.Trim();
}
else
{
StatisticsRepository.EpiWeek epiWeek = new StatisticsRepository.EpiWeek();
if(row[this.SourceColumnName] != null && !string.IsNullOrEmpty(row[this.SourceColumnName].ToString()))
{
string datestring = row[this.SourceColumnName].ToString();
DateTime? dt = Convert.ToDateTime(datestring);
value = epiWeek.GetEpiWeek(dt).ToString();
value = value.Trim();
}
}
if (string.IsNullOrEmpty(value))
{
row[this.DestinationColumnName] = DBNull.Value;
}
else
{
row[this.DestinationColumnName] = value;
}
}