/// <summary>
/// Parses a string into a Billing Entry.
/// </summary>
/// <remarks>
///
/// The first 4 characters are the fee code.
/// The next 8 characters are the effective date (YYYYMMDD).
/// The last 11 characters are the dollar amount (7.2 as float format).
///
/// </remarks>
/// <param name="str">The string</param>
/// <returns>The parsed BillingMasterEntry</returns>
public static BillingMasterEntry ParseFromString(string data)
{
//Create a new instance of the parsedCode
BillingMasterEntry parsedCode = new BillingMasterEntry();
//If the length is less than 23, not a proper billing code length
if (ValidMasterEntry(data))
{
Match match = Regex.Match(data, pattern);
parsedCode.FeeCode = match.Groups["code"].Value;
parsedCode.EffectiveDate = match.Groups["year"].Value + match.Groups["month"].Value + match.Groups["day"].Value;
parsedCode.DollarAmount = match.Groups["amt1"].Value + match.Groups["amt2"].Value;
return(parsedCode);
}
else
{
//Length error
return(null);
}
}
/// <summary>
/// Reads the master description file into the database.
/// </summary>
/// <param name="BillingDescription">The master billing code table</param>
/// <param name="data">The master file data</param>
/// <remarks>
///
/// Calls <see cref="ParseFromString(string)"/>.
///
/// Pass each line to the method. If the method returns a null,
/// log the error and ignore the line.
///
/// </remarks>
///
public static void Initialize(DatabaseTable BillingDescription, string data)
{
//Create a new instance of the logging class so error could be logged
Logging logger = new Logging();
//Create a string[] reading all data from text file
string[] masterBillingFiles = { };
try
{
//Reads all lines from the master file
masterBillingFiles = data.Split('\n');
}
catch (Exception)
{
//Log the error
logger.Log(Definitions.LoggingInfo.ErrorLevel.ERROR, "Master file cannot be found");
}
//For each billing code in master file
foreach (string code_ in masterBillingFiles)
{
// Remove any extra whitespace
string code = code_.Trim();
// Ignore the line if it's empty, or if it starts with two dashes
if (code.Length == 0 || code.StartsWith("--"))
{
continue;
}
//Parse the information from the line
BillingMasterEntry billingEntry = ParseFromString(code);
//If there was a length error
if (billingEntry == null)
{
//Log the error, and continue with code
logger.Log(Definitions.LoggingInfo.ErrorLevel.ERROR, "Incorrect length of billing code");
continue;
}
else
{
//Insert the information into the table
BillingDescription.Insert(billingEntry.FeeCode, billingEntry.EffectiveDate, billingEntry.DollarAmount);
}
}
}
