protected override void readCSVFile(CachedCsvReader csv)
{
#if(UseHeaders)
#else
int persNumberIndex = _PersNumberIndex;
int contractBeginIndex= _ContractBeginIndex;
int contractEndIndex= _ContractEndIndex;
int persIDIndex= _PersIDIndex;
int lastNameIndex= _LastNameIndex;
int firstNameIndex= _FirstNameIndex;
int worldIDIndex= _WorldIDIndex;
int hwgr_IDIndex = _HWGR_IDIndex;
int storeIDIndex = _StoreIDIndex;
int departmentIndex = _DepartmentIndex;
int allInIndex = _AllInIndex;
#endif
if (csv.FieldCount < (allInIndex + 1))
{
throw new Exception(GetLocalized("EmployeeImportFileOldVersion"));
}
//CultureInfo.GetCultureInfo("en-US").NumberFormat
NumberFormatInfo numberFormatInfo = new NumberFormatInfo();
numberFormatInfo.CurrencyDecimalSeparator = ".";
numberFormatInfo.CurrencyGroupSeparator = " ";
numberFormatInfo.NumberDecimalSeparator = ".";
numberFormatInfo.NumberGroupSeparator = " ";
//numberFormatInfo.PositiveInfinitySymbol = "+";
//numberFormatInfo.NegativeInfinitySymbol = "-";
Dictionary<string, ImportFileEmployeeData> data = new Dictionary<string, ImportFileEmployeeData>();
while (csv.ReadNextRecord())
{
csvDataNextRow();
string department = csv[departmentIndex];
string worldID = csv[worldIDIndex];
if (string.IsNullOrEmpty(worldID)) worldID = "-1";
string hwgr_ID = csv[hwgr_IDIndex];
if (string.IsNullOrEmpty(hwgr_ID)) hwgr_ID = "-1";
string storeID = csv[storeIDIndex];
string key = csv[persIDIndex];//storeID.ToString() + worldID.ToString() + hwgr_ID.ToString();
if (string.IsNullOrEmpty(storeID)) storeID = "-1";
string contractWorkingHours = csv[_ContractWorkingHoursIndex];
if (string.IsNullOrEmpty(contractWorkingHours)) contractWorkingHours = "0";
//else if (contractWorkingHours[0] == ',') contractWorkingHours = "0" + contractWorkingHours;
string availableHolidays= csv[_AvailableHolidaysIndex];
if (string.IsNullOrEmpty(availableHolidays)) availableHolidays = "0";
//else if (availableHolidays[0] == ',') availableHolidays = "0" + availableHolidays;
string balanceHours = csv[_BalanceHoursIndex];
if (string.IsNullOrEmpty(balanceHours)) balanceHours = "0";
//else if (balanceHours[0] == ',') balanceHours = "0" + balanceHours;
string persNumber = csv[persNumberIndex];
if (string.IsNullOrEmpty(persNumber)) persNumber = "0";
if (!data.ContainsKey(key))
{
ImportEmployeeData eData = new ImportEmployeeData();
eData.World_SystemID = int.Parse(worldID);
eData.HWGR_SystemID = int.Parse(hwgr_ID);
eData.Store_SystemID = int.Parse(storeID);
eData.PersID = key;
eData.FirstName = csv[firstNameIndex];
eData.LastName = csv[lastNameIndex];
eData.Department = department;
string contractBegin = csv[contractBeginIndex];
if (string.IsNullOrEmpty(contractBegin)) contractBegin = DateTimeSql.SmallDatetimeMinStr;
eData.ContractBegin = DateTime.ParseExact(contractBegin, "yyyyMMdd", null);
string contractEnd = csv[contractEndIndex];
if (string.IsNullOrEmpty(contractEnd)) contractEnd = DateTimeSql.SmallDatetimeMaxStr;
eData.ContractEnd = DateTime.ParseExact(contractEnd, "yyyyMMdd", null);
try
{
eData.ContractWorkingHours = decimal.Parse(contractWorkingHours, numberFormatInfo);
eData.AvailableHolidays = decimal.Parse(availableHolidays, numberFormatInfo);
eData.BalanceHours = decimal.Parse(balanceHours, numberFormatInfo);
eData.BalanceHours = eData.BalanceHours * 60;//minutes
eData.PersNumber = int.Parse(persNumber);
eData.AllIn = byte.Parse(csv[allInIndex]);
}
catch (FormatException ex)
{
message(string.Format(GetLocalized("NumberFormatError"),_CurrentRow,ex.Message));
continue;
}
if (eData.AllIn != 0)
eData.AllIn = 1;
if (eData.ContractEnd < eData.ContractBegin)
{
message(string.Format(GetLocalized("EmployeeContractDateError"), _CurrentRow, key, eData.ContractBegin, eData.ContractEnd));
continue;
}
else if (eData.ContractWorkingHours <= 0)
{
message(string.Format(GetLocalized("EmployeeContractTimeError"), _CurrentRow, key, eData.ContractWorkingHours));
continue;
}
data.Add(key, new ImportFileEmployeeData(_CurrentRow, eData));
}
else
message(string.Format(GetLocalized("EmployeeExists"), _CurrentRow, key));
}
csvDataEndRead();
List<ImportEmployeeData> list = new List<ImportEmployeeData>(data.Count);
foreach (ImportFileEmployeeData value in data.Values)
list.Add(value.Data);
ImportEmployeeResult importEmployeeResult = _EmployeeService.ImportEmployee(list);
list = (List<ImportEmployeeData>)importEmployeeResult.DataError;
if (list != null)
{
foreach (ImportEmployeeData value in list)
{
string key = value.PersID;
switch (value.ImportError)
{
case EmployeeImportError.NotAssignToStore:
message(string.Format(GetLocalized("EmployeeNotAssignToStore"), data[key].RecordNumber, key));
break;
case EmployeeImportError.ContractBeginChange:
message(string.Format(GetLocalized("EmployeeIEContractBeginChange"), data[key].RecordNumber, key, data[key].Data.ContractBegin));
break;
case EmployeeImportError.ContractEndChangeAndLessImportDate:
message(string.Format(GetLocalized("EmployeeIEContractEndChangeAndLessImportDate"), data[key].RecordNumber, key, data[key].Data.ContractEnd));
break;
default:
goto case EmployeeImportError.NotAssignToStore;
}
}
}
if (importEmployeeResult.DataChanged != null)
_Result = importEmployeeResult.DataChanged;
if (!importEmployeeResult.Success)
throw new Exception("");
}
internal ImportFileEmployeeData(int recordNumber, ImportEmployeeData data)
{
RecordNumber = recordNumber;
Data = data;
}
