public static string FormatDate(string dt, Huron.HuronEnums.DateType inputDtFormat, Huron.HuronEnums.DateType outputDtFormat, Huron.HuronEnums.ScalarDateType scalarDt)
{
string s = scalarDt.ToString().Substring(1);
s = s.Substring(0, 4) + "/" + s.Substring(4, 2) + "/" + s.Substring(6);
return(DateRoutine(dt, inputDtFormat, outputDtFormat, "", s));
}
//Returna a date based on date,input, and output information.
private static string DateRoutine(string dt, Huron.HuronEnums.DateType inputDateFormat, Huron.HuronEnums.DateType outputDateFormat, string ind, string scalarDt)
{
string day = "";
string month = "";
string year = "";
string yr = "";
string returnDt = "";
double a = 0;
DateTime dateTime;
dt = dt.Trim();
ind = ind.Trim();
if (inputDateFormat.ToString() == "mmddyy")
{
dt = Right(dt, 6);
yr = Right(dt, 2);
if (ind == "")
{
if (yr == "00" || yr == "01" || yr == "02" || yr == "03" || yr == "04" || yr == "05")
{
ind = "20";
}
}
}
if (inputDateFormat.ToString() == "yyyymmdd" || inputDateFormat.ToString() == "mmddyyyy")
{
dt = Right(dt, 8);
}
if (dt == "" || dt == "//" || dt == "000000" || dt == "00000000" || dt == "00000")
{
return("");
}
if (ind == "00" || ind == "0" || ind == "18" || ind == "018")
{
ind = "18";
}
else if (ind == "01" || ind == "1" || ind == "19" || ind == "019" || ind == "")
{
ind = "19";
}
else if (ind == "02" || ind == "2" || ind == "20" || ind == "020")
{
ind = "20";
}
else
{
ind = "";
}
if (inputDateFormat.ToString() == "mmddyy" || inputDateFormat.ToString() == "mmddyyyy")
{
if (dt.Length == 6)
{
dt = dt.Substring(0, 2) + "/" + dt.Substring(2, 2) + "/" + ind + dt.Substring(4);
}
else if (dt.Length > 6)
{
dt = dt.Substring(0, 2) + "/" + dt.Substring(2, 2) + "/" + dt.Substring(4);
}
}
else if (inputDateFormat.ToString() == "yyyymmdd")
{
if (dt.Length >= 8)
{
dt = dt.Substring(0, 4) + "/" + dt.Substring(4, 2) + "/" + dt.Substring(6);
}
}
else if (inputDateFormat.ToString() == "mmddyySlash" || inputDateFormat.ToString() == "mmddyyDash")
{
if (dt.Length == 8)
{
dt = dt.Substring(0, 6) + ind + dt.Substring(6, 2);
}
}
else if (inputDateFormat.ToString() == "scalarDate")
{
a = double.Parse(dt);
DateTime beginDt = DateTime.Parse(scalarDt);
DateTime answer = beginDt.AddDays(a);
day = string.Format("{0:00}", answer.Day);
month = string.Format("{0:00}", answer.Month);
year = answer.Year.ToString();
dt = month + "/" + day + "/" + year;
}
if (IsDate(dt) == true)
{
dateTime = DateTime.Parse(dt);
day = string.Format("{0:00}", dateTime.Day);
month = string.Format("{0:00}", dateTime.Month);
year = string.Format("{0:00}", dateTime.Year);
}
else
{
return("");
}
returnDt = OutputDate(outputDateFormat, month, day, year, scalarDt);
return(returnDt);
}
private static string OutputDate(Huron.HuronEnums.DateType output, string m, string d, string y, string sDt)
{
string outDt = "";
string[] array;
string abrMonth = Huron.HuronEnums.MonthAbbrs;
string fullMonth = Huron.HuronEnums.MonthNames;
const string defaultDate = "Dec 30, 1899";
switch (output)
{
case Huron.HuronEnums.DateType.mmddyy:
outDt = m + d + y.Substring(2);
break;
case Huron.HuronEnums.DateType.yyyymmdd:
outDt = y + m + d;
break;
case Huron.HuronEnums.DateType.mmddyyyy:
outDt = m + d + y;
break;
case Huron.HuronEnums.DateType.mmddyySlash:
outDt = m + "/" + d + "/" + y.Substring(2);
break;
case Huron.HuronEnums.DateType.yyyymmddSlash:
outDt = y + "/" + m + "/" + d;
break;
case Huron.HuronEnums.DateType.mmddyyyySlash:
outDt = m + "/" + d + "/" + y;
break;
case Huron.HuronEnums.DateType.mmddyyDash:
outDt = m + "-" + d + "-" + y.Substring(2);
break;
case Huron.HuronEnums.DateType.yyyymmddDash:
outDt = y + "-" + m + "-" + d;
break;
case Huron.HuronEnums.DateType.mmddyyyyDash:
outDt = m + "-" + d + "-" + y;
break;
case Huron.HuronEnums.DateType.abrMonDayYear:
array = abrMonth.Split(',');
outDt = array[int.Parse(m) - 1] + " " + int.Parse(d).ToString() + ", " + y;
break;
case Huron.HuronEnums.DateType.fullMonDayYear:
array = fullMonth.Split(',');
outDt = array[int.Parse(m) - 1] + " " + int.Parse(d).ToString() + ", " + y;
break;
case Huron.HuronEnums.DateType.scalarDate:
if (sDt == "")
{
sDt = defaultDate;
}
DateTime scalarDt = DateTime.Parse(sDt);
DateTime dt = DateTime.Parse(m + "/" + d + "/" + y);
TimeSpan num = dt.Subtract(scalarDt);
outDt = int.Parse(num.TotalDays.ToString()).ToString();
break;
}
return(outDt);
}
public static string FormatDate(string dt, Huron.HuronEnums.DateType inputDtFormat, Huron.HuronEnums.DateType outputDtFormat, DateTime scalarDt)
{
string s = scalarDt.Year + "/" + scalarDt.Month + "/" + scalarDt.Day;
return(DateRoutine(dt, inputDtFormat, outputDtFormat, "", s));
}
/// <summary>
/// Returns the date string.
/// </summary>
/// <param name="dt">Input date.</param>
/// <param name="inputDtFormat">Input date format.</param>
/// <param name="outputDtFormat">Output date format.</param>
/// <param name="centIndicator">Century Indicator. Includes values 0,18,1,19,2,20.</param>
/// <returns></returns>
public static string FormatDate(string dt, Huron.HuronEnums.DateType inputDtFormat, Huron.HuronEnums.DateType outputDtFormat, string centIndicator)
{
return(DateRoutine(dt, inputDtFormat, outputDtFormat, centIndicator, ""));
}
public static string FormatDate(string dt, Huron.HuronEnums.DateType inputDtFormat, Huron.HuronEnums.DateType outputDtFormat)
{
return(DateRoutine(dt, inputDtFormat, outputDtFormat, "", ""));
}
