public static decimal TotalCity(TXImportFileData record)
{
decimal result = record.CitySalesTaxRate.Value;
if (record.TransitTaxIsCity == "T")
{
result += record.TransitSalesTaxRate.Value;
}
if (record.Other1TaxIsCity == "T")
{
result += record.Other1SalesTaxRate.Value;
}
if (record.Other2TaxIsCity == "T")
{
result += record.Other2SalesTaxRate.Value;
}
if (record.Other3TaxIsCity == "T")
{
result += record.Other3SalesTaxRate.Value;
}
if (record.Other4TaxIsCity == "T")
{
result += record.Other4SalesTaxRate.Value;
}
return(result);
}
protected virtual void SetFlags(TaxRecord tax, TXImportFileData record)
{
tax.IsTaxable = record.CombinedSalesTaxRate > 0;
tax.IsFreight = record.TaxFreight == "Y";
tax.IsService = record.TaxServices == "Y";
tax.IsLabor = record.TaxServices == "Y" || record.TaxServices == "S";
}
public static bool ContainsDistrictTax(TXImportFileData record)
{
if (TotalDistrict(record) > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool ContainsCityTax(TXImportFileData record)
{
if ((TotalCounty(record) + record.StateSalesTaxRate) == record.CombinedSalesTaxRate)
{
return(false);
}
else
{
return(true);
}
}
protected virtual void TXImportFileData_RowPersisting(PXCache sender, PXRowPersistingEventArgs e)
{
TXImportFileData row = e.Row as TXImportFileData;
if (row != null)
{
if (_importing && !_cleared)
{
PXDatabase.Delete <TXImportFileData>();
_cleared = true;
}
}
}
protected virtual void AppendZip(ZoneRecord zone, TXImportFileData t)
{
var zips = from z in zipData
where z.ZipCode == t.ZipCode && z.CountyName == t.CountyName
select z;
bool added = false;
foreach (TXImportZipFileData zz in zips)
{
ZoneZipPlusRecord pr = new ZoneZipPlusRecord();
pr.ZoneID = zone.ZoneID;
pr.ZipCode = t.ZipCode;
pr.ZipMin = zz.Plus4PortionOfZipCode;
pr.ZipMax = zz.Plus4PortionOfZipCode2;
if (zoneZipPlus.ContainsKey(zone))
{
zoneZipPlus[zone].Add(pr);
}
else
{
List <ZoneZipPlusRecord> list = new List <ZoneZipPlusRecord>();
list.Add(pr);
zoneZipPlus.Add(zone, list);
}
added = true;
}
if (!added)
{
ZoneZipPlusRecord pr = new ZoneZipPlusRecord();
pr.ZoneID = zone.ZoneID;
pr.ZipCode = t.ZipCode;
pr.ZipMin = 1;
pr.ZipMax = 9999;
if (zoneZipPlus.ContainsKey(zone))
{
zoneZipPlus[zone].Add(pr);
}
else
{
List <ZoneZipPlusRecord> list = new List <ZoneZipPlusRecord>();
list.Add(pr);
zoneZipPlus.Add(zone, list);
}
}
}
public static decimal TotalCounty(TXImportFileData record)
{
decimal result = record.CountySalesTaxRate.Value;
return(result + TotalDistrict(record));
}
public static bool IsOnlyStateAndCounty(TXImportFileData record)
{
return((record.StateSalesTaxRate + record.CountySalesTaxRate) == record.CombinedSalesTaxRate);
}
public static bool IsOnlyState(TXImportFileData record)
{
return(record.StateSalesTaxRate == record.CombinedSalesTaxRate);
}
public static bool HasTax(TXImportFileData record)
{
return(record.CombinedSalesTaxRate > 0);
}
