public static void SaveCBC01FormData(CBC01Data formData)
{
try
{
var oParams = new DBParamCollection
{
{ "@RegisteredName", formData.RegisteredName },
{ "@CompanyRegNo", formData.CompanyRegNo },
{ "@TaxRefNo", formData.TaxRefNo },
{ "@ReportingPeriod", formData.ReportingPeriod },
{ "@FormData", formData.FormData },
{ "@Year", formData.TaxYear }
};
using (var oCommand = new DBCommand("[dbo].[uspINSERT_CBC01Data]", QueryType.StoredProcedure, oParams))
{
oCommand.Execute();
}
}
catch (Exception x)
{
EventLogging.LogError("Error Msg : " + x.Message + "\n" +
"Source : " + x.Source + "\n" +
"Event : GetYear");
}
}
private static void InterogateXML(string xml, decimal id)
{
try
{
var doc = XDocument.Parse(xml);
var cbcFormData = doc.Descendants("SubmitCountryByCountryDeclarationRequest").Select(el => el.LastNode);
long tPeriod = 0;
var cbcData = cbcFormData.ToList()[0];
var reportingPeriod = GetReportingPeriod(doc);
var taxRefNo = GetTaxReference(doc);
var taxYear = GetReportingPeriod(doc).Substring(0, 4);//GetYear(doc);
if (reportingPeriod.Length > 8)
{
tPeriod = long.Parse(DateTime.ParseExact(reportingPeriod, "yyyy-MM-dd", System.Globalization.CultureInfo.CurrentCulture).ToString("yyyyMMdd"));
}
else
{
tPeriod = long.Parse(reportingPeriod);
}
var cbcForm = new CBC01Data()
{
TaxRefNo = taxRefNo,
ReportingPeriod = tPeriod,
FormData = cbcData.ToString(),
TaxYear = int.Parse(taxYear)
};
dbManager.SaveCBC01FormData(cbcForm);
dbManager.UpdateCBCDeclarations(id);
}
catch (Exception x)
{
EventLogging.LogError("Error Msg : " + x.Message + "\n" +
"Source : " + x.Source + "\n" +
"Event : InterogateXML");
}
}
