private static int?GetNullableInt(ExcelWorksheet sheet, PersonImport columnId, int rowNumber)
{
var cellValue = sheet.Cells[rowNumber, columnId.ToInt()].Text;
if (string.IsNullOrEmpty(cellValue))
{
return(null);
}
if (int.TryParse(cellValue, out var intValue))
{
return(intValue);
}
return(null);
}
private Who ProjectPersonToWho(PersonImport person)
{
return(new Who
{
FatherId = person.FatherId.NullSafeTrim(),
FirstName = person.FirstName.NullSafeTrim(),
Gender = ParseGender(person.Gender),
Generation = ParseGeneration(person.Generation),
Id = person.TreeId.NullSafeTrim(),
LastName = person.LastName.NullSafeTrim(),
MatchName = person.MatchName,
MiddleName = person.MiddleName.NullSafeTrim(),
MotherId = person.MotherId.NullSafeTrim(),
TreeId = person.ResultId.NullSafeTrim(),
});
}
private CustomerImport MakeCustomer(string[] properties, FileRequisition fileRequisition)
{
CustomerImport customer;
if (properties[ConstantsFileImport.TypeCustomer].Trim().ToLower() == "pf")
{
customer = new PersonImport
{
FirstName = properties[ConstantsFileImport.FirstName],
LastName = properties[ConstantsFileImport.LastName],
CPF = properties[ConstantsFileImport.Document],
RG = string.Empty,
BirthDate = DateTime.Parse(properties[ConstantsFileImport.BirthDate]),
Gender = properties[ConstantsFileImport.Sexo].IsNullorEmpty() ? null : properties[ConstantsFileImport.Sexo].AsString().ToUpper(),
Type = CustomerType.Person
};
}
else
{
customer = new CompanyImport
{
CompanyName = properties[ConstantsFileImport.CompanyName],
TradeName = properties[ConstantsFileImport.TradeName],
CNPJ = properties[ConstantsFileImport.Document],
IM = properties[ConstantsFileImport.IM],
IE = properties[ConstantsFileImport.IE],
Type = CustomerType.Company
};
}
customer.Email = properties[ConstantsFileImport.Email];
customer.NewsLetter = false;
customer.Status = true;
customer.Removed = false;
customer.SaveDate = DateTime.Now;
customer.UpdateDate = DateTime.Now;
customer.StoreCode = fileRequisition.Store.Code;
customer.Address = MakeAddress(properties);
return(customer);
}
public static int ToInt(this PersonImport value)
{
return((int)value);
}
private static string ReadStringCell(ExcelWorksheet sheet, int rowNumber, PersonImport columnId)
{
return(sheet.Cells[rowNumber, columnId.ToInt()].Text.Trim());
}
private static int?ReadNullableIntCell(ExcelWorksheet sheet, int rowNumber, PersonImport columnId)
{
return(ReadNullableIntCell(sheet, rowNumber, columnId.ToInt()));
}
private static DateTime?ReadNullableDate(ExcelWorksheet sheet, int rowId, PersonImport columnId)
{
return(ReadNullableDate(sheet, rowId, (int)columnId));
}
