public void Add(Region region)
{
if (list.Exists(item => item == region))
return;
list.Add(region);
}
public Employees getItem(Region region, string EmployeesName, bool allowNull = false)
{
int idEmployeesName = 0;
EmployeesNames employeesNames = EmployeesNames.getInstance();
idEmployeesName = employeesNames.getItem(EmployeesName);
return getItem(region, idEmployeesName, allowNull);
}
public void Delete(Region region, int idEmployeesName)
{
Employees employees = getItem(region, idEmployeesName);
list.Remove(employees);
employees.Delete();
}
protected override void loadFromSql()
{
DataTable dt = _provider.Select("Region");
foreach (DataRow row in dt.Rows)
{
Region region = new Region(row);
Add(region);
}
}
internal int CountDriversInRegion(Region region)
{
return _list.Where(item => item.Region == region && !item.Fired).Count();
}
public DataTable ToDataTableByRegion(Region region, bool all = false)
{
var tempList = (all) ? _list.Where(item => item.Region == region || item.ID == 1).ToList() : _list.Where(item => (item.Region == region || item.ID == 1) && item.IsDriver);
return CreateDataTable(tempList);
}
private List<Employees> getList(Region region, int idEmployeesName)
{
var EmployeesList = from employees in list
where employees.Region == region && employees.IDEmployeesName == idEmployeesName.ToString()
select employees;
return EmployeesList.ToList();
}
private Employees getItem(Region region, int idEmployeesName, bool allowNull = false)
{
List<Employees> EmployeesList = getList(region, idEmployeesName);
Employees employees;
if (EmployeesList.Count() > 0)
employees = EmployeesList.First() as Employees;
else if (allowNull)
return null;
else
{
RegionList regionList = RegionList.getInstance();
region = regionList.getItem(1);
EmployeesList = getList(region, idEmployeesName);
if (EmployeesList.Count() > 0)
employees = EmployeesList.First() as Employees;
else
employees = new Employees();
}
return employees;
}
private void fillFields(DataRow row)
{
int idRegion;
int.TryParse(row.ItemArray[0].ToString(), out idRegion);
RegionList regionList = RegionList.getInstance();
Region = regionList.getItem(idRegion);
int.TryParse(row.ItemArray[1].ToString(), out idEmployeesName);
int.TryParse(row.ItemArray[2].ToString(), out idDriver);
}
public void StartImport()
{
string[] files = Directory.GetFiles(FilePath, "*.txt");
foreach (var file in files)
{
string[] lines = File.ReadAllLines(file);
for (int i = 1; i < lines.Count(); i++)
{
string[] fields = lines[i].Split(';');
DriverList driverList = DriverList.getInstance();
Driver driver = driverList.getItemByNumber(fields[1]);
if (driver == null)
driver = new Driver();
driver.Fio = fields[0];
driver.Number = fields[1];
driver.Sex = fields[2];
string regionName = fields[3];
RegionList regionList = RegionList.getInstance();
Region region = regionList.getItem(regionName);
if (region == null)
{
region = new Region(fields[3]);
region.Save();
region = regionList.getItem(regionName);
}
driver.Region = region;
driver.CompanyName = fields[4];
driver.Dept = fields[5];
driver.Position = fields[6];
driver.DateBirth = fields[7];
driver.Login = fields[9];
driver.email = fields[10];
driver.Decret = ((fields[15] == "Временно не работает") || (fields[15] == "В декретном отпуске"));
driver.Fired = (!string.IsNullOrEmpty(fields[15]) && (fields[15].Split(' ')[0] == "Уволен"));
driver.Save();
if (!string.IsNullOrEmpty(fields[11]))
{
string passportNumber = fields[11].Replace(" ", "");
if (passportNumber.Length == 0)
continue;
PassportList passportList = PassportList.getInstance();
Passport passport = passportList.GetPassport(driver, passportNumber);
passport.Number = passportNumber;
string[] fio = fields[0].Split(' ');
passport.LastName = fio[0];
passport.FirstName = fio[1];
passport.SecondName = fio[2];
DateTime date;
DateTime.TryParse(fields[12], out date);
passport.GiveDate = date;
passport.GiveOrg = fields[13];
passport.Address = fields[14];
passport.Save();
}
}
File.Move(file, FilePath + @"\processed\" + DateTime.Today.ToShortDateString() + " " + Path.GetFileName(file));
}
}
