public formPassportList(Driver driver)
{
InitializeComponent();
this.driver = driver;
passportList = PassportList.getInstance();
}
public void ShowNotice(DTP dtp)
{
_excelDoc = openDocumentExcel("Извещение о страховом случае");
var owners = Owners.getInstance();
_excelDoc.setValue(6, 5, owners.getItem(Convert.ToInt32(_car.ownerID))); //страхователь
_excelDoc.setValue(7, 6, "а/я 34, 196128"); //почтовый адрес
_excelDoc.setValue(8, 7, "320-40-04"); //телефон
var driverCarList = DriverCarList.getInstance();
var driver = driverCarList.GetDriver(_car, dtp.Date);
var passportList = PassportList.getInstance();
var passport = passportList.getLastPassport(driver);
if (passport.Number != string.Empty)
{
var number = passport.Number;
var numbers = number.Split(' ');
_excelDoc.setValue(10, 3, numbers[0]); //серия
_excelDoc.setValue(10, 6, numbers[1]); //номер
_excelDoc.setValue(11, 3, passport.GiveOrg); //кем выдан
_excelDoc.setValue(12, 4, passport.GiveDate.ToShortDateString()); //дата выдачи
}
var policyList = PolicyList.getInstance();
var policy = policyList.getItem(_car, PolicyType.КАСКО);
_excelDoc.setValue(14, 6, policy.Number); //полис
_excelDoc.setValue(16, 6, string.Concat(_car.Mark.Name, " ", _car.info.Model)); //марка а/м
_excelDoc.setValue(18, 6, _car.Grz); //рег номер а/м
_excelDoc.setValue(20, 6, _car.vin); //вин
_excelDoc.setValue(22, 6, dtp.Date.ToShortDateString()); //дата дтп
_excelDoc.setValue(27, 2, driver.GetName(NameType.Full)); //водитель фио
var regions = Regions.getInstance();
_excelDoc.setValue(29, 3, regions.getItem(Convert.ToInt32(dtp.IDRegion))); //город
_excelDoc.setValue(31, 14, dtp.Damage); //повреждения
_excelDoc.setValue(33, 2, dtp.Facts); //обстоятельства происшествия
//SsDTP ssDTP = SsDTPList.getInstance().getItem(_car.Mark);
//_excelDoc.setValue(63, 11, ssDTP.ServiceStantion);
//DateTime date = DateTime.Today;
//MyDateTime myDate = new MyDateTime(date.ToShortDateString());
//_excelDoc.setValue(71, 3, string.Concat("« ", date.Day.ToString(), " »"));
//_excelDoc.setValue(71, 4, myDate.MonthToStringGenitive());
//_excelDoc.setValue(71, 8, date.Year.ToString().Substring(2, 2));
_excelDoc.Show();
}
private WordDoc CreateProxyOnSTO()
{
WordDoc wordDoc = openDocumentWord("Доверенность на предоставление интересов на СТО");
DriverCarList driverCarList = DriverCarList.getInstance();
Driver driver = (_invoice == null) ? driverCarList.GetDriver(_car) : driverList.getItem(Convert.ToInt32(_invoice.DriverToID));
MyDateTime myDate = new MyDateTime(DateTime.Today.ToShortDateString());
wordDoc.setValue("текущая дата", myDate.ToLongString());
String fio = String.Empty;
if (driver != null)
{
fio = driver.GetName(NameType.Full);
}
wordDoc.setValue("ФИО регионального представителя", fio);
PassportList passportList = PassportList.getInstance();
Passport passport = null;
if (driver != null)
{
passport = passportList.getLastPassport(driver);
}
string passportToString = "нет данных";
if (passport != null)
{
passportToString = string.Concat(passport.Number, ", выдан ", passport.GiveDate.ToShortDateString(), ", ", passport.GiveOrg, ", Адрес: ", passport.Address);
}
wordDoc.setValue("паспорт регионального представителя", passportToString);
string fullNameAuto = string.Concat(_car.Mark.Name, " ", _car.info.Model);
wordDoc.setValue("Название марки автомобиля", fullNameAuto);
wordDoc.setValue("VIN-автомобиля", _car.vin);
wordDoc.setValue("Модель и марка двигателя автомобиля", _car.eNumber);
wordDoc.setValue("Номер кузова автомобиля", _car.bodyNumber);
wordDoc.setValue("Год выпуска автомобиля", _car.Year);
wordDoc.setValue("Цвет автомобиля", _car.info.Color);
PTSList ptsList = PTSList.getInstance();
PTS pts = ptsList.getItem(_car);
string ptsName = string.Concat(pts.Number, ", выдан ", pts.Date.ToShortDateString(), " ", pts.GiveOrg);
wordDoc.setValue("ПТС автомобиля", ptsName);
wordDoc.setValue("ГРЗ автомобиля", _car.Grz);
wordDoc.setValue("текущий год", DateTime.Today.Year.ToString());
return(wordDoc);
}
private void FillPassport()
{
PassportList passportList = PassportList.getInstance();
Passport passport = passportList.getLastPassport(_driver);
if (passport != null)
{
labelPassport.Text = passport.ToString();
}
}
public override void Save()
{
DeleteFile(File);
File = WorkWithFiles.fileCopyByID(File, "drivers", Driver.ID, "Passports", _number);
int id;
int.TryParse(_provider.Insert("Passport", ID, Driver.ID, LastName, FirstName, SecondName, Number, GiveOrg, GiveDate, Address, File), out id);
ID = id;
PassportList.getInstance().Add(this);
}
/* Старое извещение
* public void showNotice(DTP dtp)
* {
* _excelDoc = openDocumentExcel("Извещение о страховом случае");
*
* Owners owners = Owners.getInstance();
*
* _excelDoc.setValue(7, 4, owners.getItem(Convert.ToInt32(_car.ownerID)));
* _excelDoc.setValue(8, 5, "а/я 34, 196128");
* _excelDoc.setValue(9, 6, "320-40-04");
*
* DriverCarList driverCarList = DriverCarList.getInstance();
* Driver driver = driverCarList.GetDriver(_car, dtp.Date);
*
* PassportList passportList = PassportList.getInstance();
* Passport passport = passportList.getLastPassport(driver);
*
* if (passport.Number != string.Empty)
* {
* string number = passport.Number;
* string[] numbers = number.Split(' ');
*
* _excelDoc.setValue(11, 2, numbers[0]);
* _excelDoc.setValue(11, 5, numbers[1]);
*
* _excelDoc.setValue(12, 2, passport.GiveOrg);
* _excelDoc.setValue(13, 3, passport.GiveDate.ToShortDateString());
* }
*
* PolicyList policyList = PolicyList.getInstance();
* Policy policy = policyList.getItem(_car, PolicyType.КАСКО);
* _excelDoc.setValue(15, 5, policy.Number);
*
* _excelDoc.setValue(17, 5, string.Concat(_car.Mark.Name, " ", _car.info.Model));
* _excelDoc.setValue(19, 5, _car.Grz);
* _excelDoc.setValue(21, 5, _car.vin);
*
* _excelDoc.setValue(23, 5, dtp.Date.ToShortDateString());
*
* _excelDoc.setValue(28, 1, driver.GetName(NameType.Full));
*
* Regions regions = Regions.getInstance();
*
* _excelDoc.setValue(30, 2, regions.getItem(Convert.ToInt32(dtp.IDRegion)));
* _excelDoc.setValue(32, 13, dtp.Damage);
* _excelDoc.setValue(34, 1, dtp.Facts);
*
* SsDTP ssDTP = SsDTPList.getInstance().getItem(_car.Mark);
*
* _excelDoc.setValue(63, 11, ssDTP.ServiceStantion);
*
* DateTime date = DateTime.Today;
* MyDateTime myDate = new MyDateTime(date.ToShortDateString());
*
* _excelDoc.setValue(71, 3, string.Concat("« ", date.Day.ToString(), " »"));
* _excelDoc.setValue(71, 4, myDate.MonthToStringGenitive());
* _excelDoc.setValue(71, 8, date.Year.ToString().Substring(2, 2));
*
* _excelDoc.Show();
* }
*
*/
public void CreateWaybill(DateTime date, Driver driver = null)
{
date = new DateTime(date.Year, date.Month, 1);
if (driver == null)
{
var driverCarList = DriverCarList.getInstance();
driver = driverCarList.GetDriver(_car, date);
if (driver == null)
{
driver = driverCarList.GetDriver(_car);
var invoiceList = InvoiceList.getInstance();
var invoice = invoiceList.getItem(_car);
if (!string.IsNullOrEmpty(invoice?.DateMove))
{
DateTime.TryParse(invoice.DateMove, out DateTime dateMove);
if (dateMove.Year == date.Year && dateMove.Month == date.Month)
{
date = new DateTime(date.Year, date.Month, dateMove.Day);
}
}
}
}
_excelDoc = openDocumentExcel("Путевой лист");
_excelDoc.setValue(4, 28, _car.BBNumber);
var myDate = new MyDateTime(date.ToShortDateString());
_excelDoc.setValue(4, 39, driver.Id + "/01/" + myDate.MonthSlashYear());
_excelDoc.setValue(6, 15, myDate.DaysRange);
_excelDoc.setValue(6, 19, myDate.MonthToStringNominative());
_excelDoc.setValue(6, 32, date.Year.ToString());
_excelDoc.setValue(29, 35, _car.info.Grade.EngineType.ShortName);
var mml = new MileageMonthList(_car.Id, date.Year + "-" + date.Month + "-01");
/* Из файла Татьяны Мироновой пробег за месяц */
_excelDoc.setValue(19, 39, mml.PSN);
_excelDoc.setValue(33, 41, mml.Gas);
_excelDoc.setValue(35, 41, mml.GasBegin);
_excelDoc.setValue(36, 41, mml.GasEnd);
_excelDoc.setValue(37, 41, mml.GasNorm);
_excelDoc.setValue(38, 41, mml.GasNorm);
_excelDoc.setValue(43, 39, mml.PSK);
_excelDoc.setValue(41, 59, mml.Mileage);
var owners = Owners.getInstance();
var owner = owners.getItem(1);
_excelDoc.setValue(8, 8, owner);
_excelDoc.setValue(10, 11, string.Concat(_car.Mark.Name, " ", _car.info.Model));
_excelDoc.setValue(11, 17, _car.Grz);
_excelDoc.setValue(12, 6, driver.GetName(NameType.Full));
_excelDoc.setValue(44, 16, driver.GetName(NameType.Short));
_excelDoc.setValue(26, 40, driver.GetName(NameType.Short));
var licencesList = LicenseList.getInstance();
var driverLicense = licencesList.getItem(driver);
_excelDoc.setValue(14, 10, driverLicense.Number);
_excelDoc.setValue(20, 9, owner);
string suppyAddressName;
if (driver.suppyAddress != string.Empty)
{
suppyAddressName = driver.suppyAddress;
}
else
{
var suppyAddressList = SuppyAddressList.getInstance();
var suppyAddress = suppyAddressList.getItemByRegion(driver.Region.Id);
if (suppyAddress != null)
{
suppyAddressName = suppyAddress.ToString();
}
else
{
var passportList = PassportList.getInstance();
var passport = passportList.getLastPassport(driver);
suppyAddressName = passport.Address;
}
}
var suppyAddressName2 = string.Empty;
if (suppyAddressName.Length > 40)
{
for (var i = 30; i < suppyAddressName.Length; i++)
{
if (suppyAddressName[i] == ' ')
{
suppyAddressName2 = suppyAddressName.Substring(i, suppyAddressName.Length - i);
suppyAddressName = suppyAddressName.Substring(0, i);
}
}
}
_excelDoc.setValue(25, 8, suppyAddressName);
_excelDoc.setValue(26, 1, suppyAddressName2);
string mechanicName;
var employeesList = EmployeesList.getInstance();
var accountant = employeesList.getItem(driver.Region, "Бухгалтер Б.Браун");
if (driver.IsOne)
{
mechanicName = driver.GetName(NameType.Short);
}
else
{
var mechanic = employeesList.getItem(driver.Region, "Механик", true);
mechanicName = mechanic == null
? driver.GetName(NameType.Short)
: mechanic.Name;
}
var dispatcher = employeesList.getItem(driver.Region, "Диспечер-нарядчик");
var dispatcherName = dispatcher.Name;
_excelDoc.setValue(22, 40, mechanicName);
_excelDoc.setValue(44, 40, mechanicName);
_excelDoc.setValue(31, 18, dispatcherName);
_excelDoc.setValue(35, 18, dispatcherName);
_excelDoc.setValue(43, 72, accountant.Name);
}
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));
}
}
public void PassWordValidTest()
{
PassportList pL = new PassportList("valid.dat");
Assert.AreEqual(4, pL.ValidPasswordsCount(Validator.requiredFields));
}
