/// <summary>
/// Loads the context.
/// </summary>
/// <param name="context">The context.</param>
public void LoadContext(IDictionary context)
{
_Tax = (TaxDto)context[_TaxDtoContextString];
if (_Tax != null && _Tax.Tax.Rows.Count > 0)
{
_taxId = _Tax.Tax[0].TaxId;
}
else
{
_taxId = -1;
TaxDto.TaxRow taxRow = _Tax.Tax.NewTaxRow();
taxRow.ApplicationId = OrderConfiguration.Instance.ApplicationId;
taxRow.TaxId = _taxId;
taxRow.TaxType = 0;
taxRow.Name = String.Empty;
taxRow.SortOrder = 0;
if (taxRow.RowState == DataRowState.Detached)
{
_Tax.Tax.Rows.Add(taxRow);
}
}
}
/// <summary>
/// Imports the specified input.
/// </summary>
/// <param name="input">The input.</param>
/// <param name="applicationId">The application id.</param>
/// <param name="baseFilePath">The base file path.</param>
public void Import(string pathToCsvFile, Guid applicationId, Guid?siteId, char delimiter)
{
CultureInfo currentCultureInfo = GetImportExportCulture();
int totalImportSteps = GetTotalImportSteps();
OnEvent("Starting import...", 0);
string fileName = Path.GetFileName(pathToCsvFile);
// 1. Parse csv file
OnEvent("Start parsing csv file", GetProgressPercent((int)ImportSteps.StartParseFile, totalImportSteps));
CsvIncomingDataParser parser = new CsvIncomingDataParser(Path.GetDirectoryName(pathToCsvFile), true, delimiter);
DataSet taxDataSet = parser.Parse(fileName, null);
OnEvent("Finished parsing csv file", GetProgressPercent((int)ImportSteps.EndParseFile, totalImportSteps));
// 2. Create Dtos from parsed DataSet
if (taxDataSet.Tables[fileName] == null)
{
throw new OrdersImportExportException(String.Format("Unknown problem with parsing file {0}.", fileName));
}
OnEvent("Start processing parsed rows", GetProgressPercent((int)ImportSteps.StartImport, totalImportSteps));
int totalRowCount = taxDataSet.Tables[fileName].Rows.Count;
JurisdictionDto currentJurisdictionDto = JurisdictionManager.GetJurisdictions(Mediachase.Commerce.Orders.Managers.JurisdictionManager.JurisdictionType.Tax);
TaxDto currentTaxDto = TaxManager.GetTaxDto(TaxType.SalesTax);
JurisdictionDto jurisdictionDto = new JurisdictionDto();
TaxDto taxDto = new TaxDto();
for (int i = 0; i <= totalRowCount - 1; i++)
{
DataRow currentRow = taxDataSet.Tables[fileName].Rows[i];
#region Import Jurisdictions
#region JurisdictionDto
string jurisdictionCode = currentRow.ItemArray.GetValue(9).ToString();
JurisdictionDto.JurisdictionRow jRow = null;
JurisdictionDto.JurisdictionRow[] jRows = (JurisdictionDto.JurisdictionRow[])currentJurisdictionDto.Jurisdiction.Select(String.Format("Code='{0}'", jurisdictionCode));
// check if row has already been imported
// (to support multiple values for the same jurisdiction need to check if jurisdiction with the given name already exists in jurisdictionDto)
JurisdictionDto.JurisdictionRow[] jRows2 = (JurisdictionDto.JurisdictionRow[])jurisdictionDto.Jurisdiction.Select(String.Format("Code='{0}'", jurisdictionCode));
bool jurisdictionExists = jRows2 != null && jRows2.Length > 0;
if (jurisdictionExists)
{
jRow = jRows2[0];
}
else
{
if (jRows != null && jRows.Length > 0)
{
jurisdictionDto.Jurisdiction.ImportRow(jRows[0]);
jRow = jurisdictionDto.Jurisdiction[jurisdictionDto.Jurisdiction.Count - 1];
}
else
{
jRow = jurisdictionDto.Jurisdiction.NewJurisdictionRow();
jRow.ApplicationId = applicationId;
jRow.JurisdictionType = Mediachase.Commerce.Orders.Managers.JurisdictionManager.JurisdictionType.Tax.GetHashCode();
}
}
jRow.DisplayName = currentRow.ItemArray.GetValue(0).ToString();
jRow.StateProvinceCode = GetStringValue(currentRow.ItemArray.GetValue(1));
jRow.CountryCode = currentRow.ItemArray.GetValue(2).ToString();
jRow.ZipPostalCodeStart = GetStringValue(currentRow.ItemArray.GetValue(3));
jRow.ZipPostalCodeEnd = GetStringValue(currentRow.ItemArray.GetValue(4));
jRow.City = GetStringValue(currentRow.ItemArray.GetValue(5));
jRow.District = GetStringValue(currentRow.ItemArray.GetValue(6));
jRow.County = GetStringValue(currentRow.ItemArray.GetValue(7));
jRow.GeoCode = GetStringValue(currentRow.ItemArray.GetValue(8));
jRow.Code = jurisdictionCode;
if (jRow.RowState == DataRowState.Detached)
{
jurisdictionDto.Jurisdiction.Rows.Add(jRow);
}
#endregion
#region JurisdictionGroupDto
string jurisdictionGroupCode = currentRow.ItemArray.GetValue(11).ToString();
JurisdictionDto.JurisdictionGroupRow jGroupRow = null;
JurisdictionDto.JurisdictionGroupRow[] jGroupRows = (JurisdictionDto.JurisdictionGroupRow[])currentJurisdictionDto.JurisdictionGroup.Select(String.Format("Code='{0}'", jurisdictionGroupCode));
// check if row has already been imported
// (to support multiple values for the same jurisdiction need to check if jurisdiction with the given name already exists in jurisdictionDto)
JurisdictionDto.JurisdictionGroupRow[] jGroupRows2 = (JurisdictionDto.JurisdictionGroupRow[])jurisdictionDto.JurisdictionGroup.Select(String.Format("Code='{0}'", jurisdictionGroupCode));
bool jurisdictionGroupExists = jGroupRows2 != null && jGroupRows2.Length > 0;
if (jurisdictionGroupExists)
{
jGroupRow = jGroupRows2[0];
}
else
{
if (jGroupRows != null && jGroupRows.Length > 0)
{
jurisdictionDto.JurisdictionGroup.ImportRow(jGroupRows[0]);
jGroupRow = jurisdictionDto.JurisdictionGroup[jurisdictionDto.JurisdictionGroup.Count - 1];
}
else
{
jGroupRow = jurisdictionDto.JurisdictionGroup.NewJurisdictionGroupRow();
jGroupRow.ApplicationId = applicationId;
jGroupRow.JurisdictionType = Mediachase.Commerce.Orders.Managers.JurisdictionManager.JurisdictionType.Tax.GetHashCode();
}
}
jGroupRow.DisplayName = currentRow.ItemArray.GetValue(10).ToString();
jGroupRow.Code = jurisdictionGroupCode;
if (jGroupRow.RowState == DataRowState.Detached)
{
jurisdictionDto.JurisdictionGroup.Rows.Add(jGroupRow);
}
#endregion
#region JurisdictionRelationDto
JurisdictionDto.JurisdictionRelationRow jRelationRow = null;
if (jRow.JurisdictionId > 0 && jGroupRow.JurisdictionGroupId > 0)
{
// check if relation already exists
JurisdictionDto.JurisdictionRelationRow[] jRelationRows = (JurisdictionDto.JurisdictionRelationRow[])currentJurisdictionDto.JurisdictionRelation.Select(String.Format("JurisdictionId={0} AND JurisdictionGroupId={1}", jRow.JurisdictionId, jGroupRow.JurisdictionGroupId));
if (jRelationRows != null && jRelationRows.Length > 0)
{
jurisdictionDto.JurisdictionRelation.ImportRow(jRelationRows[0]);
jRelationRow = jurisdictionDto.JurisdictionRelation[jurisdictionDto.JurisdictionRelation.Count - 1];
}
}
if (jRelationRow == null)
{
// create new relation
jRelationRow = jurisdictionDto.JurisdictionRelation.NewJurisdictionRelationRow();
jRelationRow.JurisdictionId = jRow.JurisdictionId;
jRelationRow.JurisdictionGroupId = jGroupRow.JurisdictionGroupId;
jurisdictionDto.JurisdictionRelation.Rows.Add(jRelationRow);
}
#endregion
// save jurisdictionDto
if (jurisdictionDto.HasChanges())
{
JurisdictionManager.SaveJurisdiction(jurisdictionDto);
}
#endregion
#region Import Taxes
#region TaxDto
TaxDto.TaxRow taxRow = null;
string taxName = currentRow.ItemArray.GetValue(13).ToString();
// check if row already exists
TaxDto.TaxRow[] taxRows = (TaxDto.TaxRow[])currentTaxDto.Tax.Select(String.Format("Name='{0}'", taxName));
// check if row has already been imported
TaxDto.TaxRow[] taxRows2 = (TaxDto.TaxRow[])taxDto.Tax.Select(String.Format("Name='{0}'", taxName));
bool taxExists = taxRows2 != null && taxRows2.Length > 0;
if (taxExists)
{
taxRow = taxRows2[0];
}
else
{
#region if tax is not in the destination dto
if (taxRows != null && taxRows.Length > 0)
{
taxDto.Tax.ImportRow(taxRows[0]);
taxRow = taxDto.Tax[taxDto.Tax.Count - 1];
}
else
{
taxRow = taxDto.Tax.NewTaxRow();
taxRow.ApplicationId = applicationId;
taxRow.TaxType = TaxType.SalesTax.GetHashCode();
taxRow.Name = taxName;
}
#endregion
}
taxRow.SortOrder = Int32.Parse(currentRow.ItemArray.GetValue(14).ToString());
if (taxRow.RowState == DataRowState.Detached)
{
taxDto.Tax.Rows.Add(taxRow);
}
#endregion
#region TaxLanguageDto
TaxDto.TaxLanguageRow taxLanguageRow = null;
string langCode = currentRow.ItemArray.GetValue(15).ToString();
// check if row already exists
TaxDto.TaxLanguageRow[] taxLanguageRows = (TaxDto.TaxLanguageRow[])currentTaxDto.TaxLanguage.Select(String.Format("LanguageCode='{0}' and TaxId={1}", langCode, taxRow.TaxId));
// check if row has already been imported
TaxDto.TaxLanguageRow[] taxLanguageRows2 = (TaxDto.TaxLanguageRow[])taxDto.TaxLanguage.Select(String.Format("LanguageCode='{0}' and TaxId={1}", langCode, taxRow.TaxId));
bool taxLanguageExists = taxLanguageRows2 != null && taxLanguageRows2.Length > 0;
string displayName = currentRow.ItemArray.GetValue(12).ToString();
if (taxLanguageExists)
{
taxLanguageRow = taxLanguageRows2[0];
}
else
{
#region if tax is not in the destination dto
if (taxLanguageRows != null && taxLanguageRows.Length > 0)
{
taxDto.TaxLanguage.ImportRow(taxLanguageRows[0]);
taxLanguageRow = taxDto.TaxLanguage[taxDto.TaxLanguage.Count - 1];
}
else
{
taxLanguageRow = taxDto.TaxLanguage.NewTaxLanguageRow();
taxLanguageRow.LanguageCode = langCode;
taxLanguageRow.TaxId = taxRow.TaxId;
}
#endregion
}
taxLanguageRow.DisplayName = displayName;
if (taxLanguageRow.RowState == DataRowState.Detached)
{
taxDto.TaxLanguage.Rows.Add(taxLanguageRow);
}
#endregion
#region TaxValueDto
TaxDto.TaxValueRow taxValueRow = null;
// check if row already exists
TaxDto.TaxValueRow[] taxValueRows = null;
if (siteId.HasValue)
{
taxValueRows = (TaxDto.TaxValueRow[])currentTaxDto.TaxValue.Select(String.Format("TaxId={0} and SiteId={1} and JurisdictionGroupId={2}", taxRow.TaxId, siteId.Value, jRelationRow.JurisdictionGroupId));
}
else
{
taxValueRows = (TaxDto.TaxValueRow[])currentTaxDto.TaxValue.Select(String.Format("TaxId={0} and JurisdictionGroupId={1}", taxRow.TaxId, jRelationRow.JurisdictionGroupId));
}
// check if row has already been imported
TaxDto.TaxValueRow[] taxValueRows2 = null;
if (siteId.HasValue)
{
taxValueRows2 = (TaxDto.TaxValueRow[])taxDto.TaxValue.Select(String.Format("TaxId={0} and SiteId={1} and JurisdictionGroupId={2}", taxRow.TaxId, siteId.Value, jRelationRow.JurisdictionGroupId));
}
else
{
taxValueRows2 = (TaxDto.TaxValueRow[])taxDto.TaxValue.Select(String.Format("TaxId={0} and JurisdictionGroupId={1}", taxRow.TaxId, jRelationRow.JurisdictionGroupId));
}
bool taxValueExists = taxValueRows2 != null && taxValueRows2.Length > 0;
if (taxValueExists)
{
taxValueRow = taxValueRows2[0];
}
else
{
if (taxValueRows != null && taxValueRows.Length > 0)
{
taxDto.TaxValue.ImportRow(taxValueRows[0]);
taxValueRow = taxDto.TaxValue[taxDto.TaxValue.Count - 1];
}
else
{
taxValueRow = taxDto.TaxValue.NewTaxValueRow();
taxValueRow.TaxId = taxRow.TaxId;
}
}
// assign tax values
taxValueRow.JurisdictionGroupId = jGroupRow.JurisdictionGroupId;
taxValueRow.TaxCategory = currentRow.ItemArray.GetValue(16).ToString();
taxValueRow.Percentage = float.Parse(currentRow.ItemArray.GetValue(17).ToString(), currentCultureInfo);
taxValueRow.AffectiveDate = DateTime.Parse(currentRow.ItemArray.GetValue(18).ToString(), currentCultureInfo);
if (siteId.HasValue)
{
taxValueRow.SiteId = siteId.Value;
}
// add row to dto, if needed
if (taxValueRow.RowState == DataRowState.Detached)
{
taxDto.TaxValue.Rows.Add(taxValueRow);
}
// create tax category, if it doesn't exist yet
CatalogTaxManager.CreateTaxCategory(taxValueRow.TaxCategory, true);
#endregion
if (taxDto.HasChanges())
{
TaxManager.SaveTax(taxDto);
}
#endregion
if ((i + 1) % 20 == 0)
{
OnEvent(String.Format("Processed {0} of {1} rows", i + 1, totalRowCount), GetProgressPercent((int)ImportSteps.StartImport, totalImportSteps));
}
}
OnEvent(String.Format("Finished processing parsed rows. Total processed: {0}", totalRowCount), GetProgressPercent((int)ImportSteps.Finish, totalImportSteps));
OnEvent("CSV file successfully imported.", 100);
}
/// <summary>
/// Loads the data and data bind.
/// </summary>
/// <param name="sortExpression">The sort expression.</param>
private void LoadDataAndDataBind(string sortExpression)
{
TaxDto dto = TaxManager.GetTaxDto(null);
if (dto.Tax != null)
{
//string taxCategoryColumnKey = "TaxCategory";
//string percentageColumnKey = "Percentage";
string taxTypeNameColumnKey = "TaxTypeName";
DataTable taxesTable = dto.Tax;
//taxesTable.Columns.Add(percentageColumnKey, typeof(double));
//taxesTable.Columns.Add(taxCategoryColumnKey, typeof(string));
taxesTable.Columns.Add(taxTypeNameColumnKey, typeof(string));
/*var tbl1 = from tax in dto.Tax
* join taxValue in dto.TaxValue
* on tax.TaxId equals taxValue.TaxId
* select new { tax.TaxId, tax.Name, tax.TaxType, tax.SortOrder, Percentage = taxValue.Percentage, TaxCategory = taxValue.TaxCategory };*/
for (int i = 0; i < dto.Tax.Rows.Count; i++)
{
TaxDto.TaxRow currentTaxRow = (TaxDto.TaxRow)dto.Tax.Rows[i];
switch ((TaxType)currentTaxRow.TaxType)
{
case TaxType.SalesTax:
currentTaxRow[taxTypeNameColumnKey] = Resources.SharedStrings.Sales;
break;
case TaxType.ShippingTax:
currentTaxRow[taxTypeNameColumnKey] = Resources.SharedStrings.Shipping;
break;
default:
currentTaxRow[taxTypeNameColumnKey] = String.Empty;
break;
}
}
//for (int i = 0; i < dto.Tax.Rows.Count; i++)
//{
// TaxDto.TaxRow currentTaxRow = (TaxDto.TaxRow)dto.Tax.Rows[i];
// var valueRow = from taxValue in dto.TaxValue where taxValue.TaxId == currentTaxRow.TaxId select taxValue;
// bool fillWithEmptyValues = true;
// if (valueRow != null)
// {
// DataView dv = valueRow.AsDataView();
// if (dv.Count > 0) // must be 1
// {
// taxesTable.Rows[i][percentageColumnKey] = dv[0]["Percentage"];
// taxesTable.Rows[i][taxCategoryColumnKey] = dv[0]["TaxCategory"];
// fillWithEmptyValues = false;
// }
// }
// if (fillWithEmptyValues)
// {
// taxesTable.Rows[i][percentageColumnKey] = 0;
// taxesTable.Rows[i][taxCategoryColumnKey] = "";
// }
//}
DataView view = taxesTable.DefaultView;
view.Sort = sortExpression;
MyListView.DataSource = view;
}
MyListView.CurrentListView.PrimaryKeyId = EcfListView.MakePrimaryKeyIdString("TaxId");
MyListView.DataBind();
}
/// <summary>
/// Saves the changes.
/// </summary>
/// <param name="context">The context.</param>
public void SaveChanges(IDictionary context)
{
CultureInfo ci = GetCurrentCulture();
TaxDto dto = (TaxDto)context[_TaxDtoString];
TaxDto.TaxRow taxRow = null;
if (dto == null)
{
// dto must be created in base control that holds tabs
return;
}
if (dto.Tax.Count > 0)
{
taxRow = dto.Tax[0];
}
else
{
taxRow = dto.Tax.NewTaxRow();
taxRow.ApplicationId = OrderConfiguration.Instance.ApplicationId;
}
taxRow.Name = tbName.Text;
taxRow.SortOrder = Int32.Parse(tbSortOrder.Text);
taxRow.TaxType = Int32.Parse(TaxTypeList.SelectedValue);
if (taxRow.RowState == DataRowState.Detached)
{
dto.Tax.Rows.Add(taxRow);
}
// save localized values
foreach (RepeaterItem item in LanguagesList.Items)
{
HiddenField hfCtrl = item.FindControl("hfLangCode") as HiddenField;
TextBox tbCtrl = item.FindControl("tbDisplayName") as TextBox;
if (hfCtrl != null && tbCtrl != null)
{
TaxDto.TaxLanguageRow[] taxLanguageRows = (TaxDto.TaxLanguageRow[])dto.TaxLanguage.Select(String.Format("LanguageCode='{0}'", hfCtrl.Value));
TaxDto.TaxLanguageRow taxLanguageRow = null;
if (taxLanguageRows != null && taxLanguageRows.Length > 0)
{
taxLanguageRow = taxLanguageRows[0];
}
else
{
// add a new record for the current language
taxLanguageRow = dto.TaxLanguage.NewTaxLanguageRow();
taxLanguageRow.TaxId = taxRow.TaxId;
taxLanguageRow.LanguageCode = hfCtrl.Value;
}
taxLanguageRow.DisplayName = tbCtrl.Text;
if (taxLanguageRow.RowState == DataRowState.Detached)
{
dto.TaxLanguage.Rows.Add(taxLanguageRow);
}
}
}
}
