private IEnumerable <INotification> GetListWithoutFile() { var driverList = DriverList.getInstance(); var listDriver = driverList.ToList() .Where(item => (!item.Fired && !item.Decret && !item.NotificationStop && item.IsDriver)).ToList(); var list = _list.ToList(); var listExist = (from itemMc in list join itemDriver in listDriver on itemMc.Driver.Id equals itemDriver.Id into table1 from itemRes in table1.DefaultIfEmpty() where itemRes != null select itemMc).ToList(); var listNotification = new List <INotification>(); foreach (IActual item in listExist) { if (item.IsDateActual() && !item.IsHaveFile()) { if (list.First() is MedicalCert) { listNotification.Add(item as MedicalCert); } else if (list.First() is DriverLicense) { listNotification.Add(item as DriverLicense); } } } return(listNotification); }
private List <INotification> GetListNotExist() { var driverList = DriverList.getInstance(); var listDriver = driverList.ToList() .Where(item => (!item.Fired && !item.Decret && !item.NotificationStop && item.IsDriver)).ToList(); var list = _list.ToList(); var driversWithoutActualDocuments = (from itemDriver in listDriver join itemMc in list on itemDriver.Id equals itemMc.Driver.Id into table1 from itemRes in table1.DefaultIfEmpty() where itemRes == null select itemDriver).ToList(); var listNotification = new List <INotification>(); foreach (var driver in driversWithoutActualDocuments) { if (list.First() is MedicalCert) { listNotification.Add(new MedicalCert(driver)); } else if (list.First() is DriverLicense) { listNotification.Add(new DriverLicense(driver)); } } return(listNotification); }
private void fillFields(DataRow row) { ID = Convert.ToInt32(row.ItemArray[0]); int idDriver; int.TryParse(row.ItemArray[1].ToString(), out idDriver); Driver = DriverList.getInstance().getItem(idDriver); Number = row.ItemArray[2].ToString(); DateTime dateBegin; DateTime.TryParse(row.ItemArray[3].ToString(), out dateBegin); DateBegin = dateBegin; DateTime dateEnd; DateTime.TryParse(row.ItemArray[4].ToString(), out dateEnd); DateEnd = dateEnd; File = row.ItemArray[5].ToString(); _fileBegin = File; int.TryParse(row.ItemArray[6].ToString(), out _notificationSent); }
private void SetFormatDriver() { DriverList driverList = DriverList.getInstance(); foreach (DataGridViewRow row in _dgv.Rows) { if ((row.Cells["Скан водительского удостоверения"].Value.ToString() == "нет") || (row.Cells["Скан медицинской справки"].Value.ToString() == "нет")) { row.DefaultCellStyle.BackColor = Color.LightYellow; } int idDriver = 0; int.TryParse(row.Cells[0].Value.ToString(), out idDriver); Driver driver = driverList.getItem(idDriver); if (driver.Fired) { row.DefaultCellStyle.ForeColor = Color.Red; } if (((driver.OwnerID < 3) && (string.IsNullOrEmpty(driver.Number))) || (driver.Decret)) { row.DefaultCellStyle.ForeColor = Color.Blue; } if (driver.OwnerID > 2) { row.DefaultCellStyle.ForeColor = BBColors.bbGreen1; } } }
//НЕПРАВИЛЬНО!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! //По 2 раза отправляются письма, тем, у кого нет справки (кого нет в list2) private List <INotification> GetListOverdue(DateTime date) { var list = _list.ToList(); /* select driver_fio, max(MedicalCert_dateEnd) from [dbo].[MedicalCert] mc * join Driver d on d.driver_id = mc.driver_id * where MedicalCert_dateEnd < date//'2017-10-24' * group by driver_fio * order by driver_fio */ var temp = (from item in list group item by item.Driver.Id into t orderby t.Key select t.OrderByDescending(y => y.DateEnd).FirstOrDefault()).ToList(); /* тут будет несколько прошлогодних справок */ //var list1 = (list.Where(item => (item.DateEnd < date))).ToList(); var list2 = (list.Where(item => (item.DateEnd >= date))).ToList(); DriverList driverList = DriverList.getInstance(); return((from item1 in temp join item2 in list2 on item1.Driver.Id equals item2.Driver.Id into table1 from item3 in table1.DefaultIfEmpty() where item3 == null && (!driverList.getItem(item1.Driver.Id).NotificationStop) select item1).ToList()); }
private void fillFields(DataRow row) { int id; int.TryParse(row.ItemArray[0].ToString(), out id); ID = id; int idCar; int.TryParse(row.ItemArray[1].ToString(), out idCar); Car = CarList.getInstance().getItem(idCar); int idDriver; int.TryParse(row.ItemArray[2].ToString(), out idDriver); Driver = DriverList.getInstance().getItem(idDriver); DateTime dateBegin; DateTime.TryParse(row.ItemArray[3].ToString(), out dateBegin); DateBegin = dateBegin; DateTime dateEnd; DateTime.TryParse(row.ItemArray[4].ToString(), out dateEnd); DateEnd = dateEnd; }
private List <INotification> GetListNotExist() { DriverList driverList = DriverList.getInstance(); List <Driver> listDriver = driverList.ToList().Where(item => (!item.Fired && !item.Decret && !item.NotificationStop && item.IsDriver)).ToList(); List <INotification> list = _list.ToList(); List <Driver> listNotExist = (from itemDriver in listDriver join itemMC in list on itemDriver.ID equals itemMC.Driver.ID into table1 from itemRes in table1.DefaultIfEmpty() where itemRes == null select itemDriver).ToList(); List <INotification> listNotification = new List <INotification>(); foreach (Driver item in listNotExist) { if (list.First() is MedicalCert) { listNotification.Add(new MedicalCert(item)); } else if (list.First() is DriverLicense) { listNotification.Add(new DriverLicense(item)); } } return(listNotification); }
private void btnSave_Click(object sender, EventArgs e) { if (_workWithForm.IsEditMode()) { int idDriver; int.TryParse(cbDriver.SelectedValue.ToString(), out idDriver); _fuelCardDriver.Driver = DriverList.getInstance().getItem(idDriver); _fuelCardDriver.DateBegin = dtpDateBegin.Value; if (chbNotUse.Checked) { if ((!_fuelCardDriver.IsNotUse) && (chbNotUse.Checked)) { FuelCard fuelCard = _fuelCardDriver.FuelCard; FuelCardDriver fuelCardDriver = fuelCard.CreateFuelCardDriver(); fuelCardDriver.Save(); } _fuelCardDriver.DateEnd = dtpDateEnd.Value.Date; } else { _fuelCardDriver.IsNotUse = false; } _fuelCardDriver.Save(); DialogResult = System.Windows.Forms.DialogResult.OK; } else { _workWithForm.SetEditMode(true); } }
private ToolStripMenuItem CreateDeleteDriver() { ToolStripMenuItem item = CreateItem("Удалить водителя"); item.Click += delegate { if (MessageBox.Show("Вы действительно хотите удалить водителя из списка?", "Удаление", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes) { DriverList driverList = DriverList.getInstance(); Driver driver = driverList.getItem(_dgvMain.GetID()); DriverCarList driverCarList = DriverCarList.getInstance(); if (driverCarList.IsDriverHaveCar(driver)) { MessageBox.Show("За водителем закреплён автомобиль, удаление невозможно", "Удаление", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { driver.IsDriver = false; driver.Save(); _mainStatus.Set(_mainStatus.Get()); } } }; return(item); }
public override void Save() { DriverList driverList = DriverList.getInstance(); string dateBirthSql = string.Empty; if (DateBirth != string.Empty) { dateBirthSql = string.Concat(_dateBirth.Year.ToString(), "-", _dateBirth.Month.ToString(), "-", _dateBirth.Day.ToString()); } string dateStopNotificationSql = string.Empty; if (DateStopNotification.Year != 1) { dateStopNotificationSql = string.Concat(DateStopNotification.Year.ToString(), "-", DateStopNotification.Month.ToString(), "-", DateStopNotification.Day.ToString()); } int id; int.TryParse(Provider.Insert("Driver", Id, GetName(NameType.Full), Region.Id, dateBirthSql, _mobile, email, _fired, _expSince, PositionID, DeptID, Login, OwnerID, suppyAddress, SexIndex, _decret, dateStopNotificationSql, _number, _isDriver, _from1C), out id); Id = id; driverList.Add(this); }
internal void SendNotification(Driver driver, string message, bool addTransportToCopy = true, List <string> fileNames = null) { _subject = "Уведомление"; _body = message; string[] copyEmails = null; if (addTransportToCopy) { Driver transportEmployee = DriverList.getInstance().GetDriverListByRole(RolesList.Editor).First(); copyEmails = new string[] { transportEmployee.email }; } var listAttachment = new List <Attachment>(); if (fileNames != null) { fileNames.ForEach(item => listAttachment.Add(new Attachment(item))); } Send(new List <Driver> { driver }, copyEmails, listAttachment); LogManager.Logger.Debug(message); }
private void fillFields(DataRow row) { int id; int.TryParse(row.ItemArray[0].ToString(), out id); ID = id; int idDriver; int.TryParse(row.ItemArray[1].ToString(), out idDriver); Driver = DriverList.getInstance().getItem(idDriver); LastName = row.ItemArray[2].ToString(); FirstName = row.ItemArray[3].ToString(); SecondName = row.ItemArray[4].ToString(); _number = row.ItemArray[5].ToString(); GiveOrg = row.ItemArray[6].ToString(); DateTime giveDate; DateTime.TryParse(row.ItemArray[7].ToString(), out giveDate); GiveDate = giveDate; Address = row.ItemArray[8].ToString(); File = row.ItemArray[9].ToString(); _fileBegin = File; }
public DriverCar(DataRow row) { int idCar; int.TryParse(row.ItemArray[0].ToString(), out idCar); Car = CarList.getInstance().getItem(idCar); if (idCar == 191) { idCar = 191; } int idDriver; int.TryParse(row.ItemArray[1].ToString(), out idDriver); Driver = DriverList.getInstance().getItem(idDriver); DateTime.TryParse(row.ItemArray[2].ToString(), out dateBegin); DateTime.TryParse(row.ItemArray[3].ToString(), out dateEnd); int number; int.TryParse(row.ItemArray[4].ToString(), out number); Number = number; dateEnd = dateEnd.Date; }
public FormWayBillDaily(MainDGV dgv) { InitializeComponent(); list = new List <Car>(); fuelList = FuelList.getInstance(); foreach (DataGridViewCell cell in dgv.SelectedCells) { string fio = dgv.GetFIO(cell.RowIndex); DriverList dl = DriverList.getInstance(); driverCurrent = dl.getItemByFullFIO(fio); int idCar = dgv.GetCarID(cell.RowIndex); CarList carList = CarList.getInstance(); Car car = carList.getItem(idCar); list.Add(car); lbCars.Items.Add(car); } btnNext.Enabled = list.Count > 1; index = 0; lbCar.Text = "Выбранный автомобиль: " + list[index].ToString(); }
private void fillFields(DataRow row) { ID = Convert.ToInt32(row.ItemArray[0]); int idFuelCard; int.TryParse(row.ItemArray[1].ToString(), out idFuelCard); FuelCard = FuelCardList.getInstance().getItem(idFuelCard); int idDriver; int.TryParse(row.ItemArray[2].ToString(), out idDriver); Driver = DriverList.getInstance().getItem(idDriver); DateTime dateBegin; DateTime.TryParse(row.ItemArray[3].ToString(), out dateBegin); DateBegin = dateBegin; DateTime dateEnd; if (DateTime.TryParse(row.ItemArray[4].ToString(), out dateEnd)) { DateEnd = dateEnd; } }
public FuelCardDriver(FuelCard fuelCard) { FuelCard = fuelCard; DateBegin = DateTime.Today; Driver = DriverList.getInstance().getItem(1); IsNotUse = false; }
private CreateDocument CreateWayBill(Car car, DateTime date, int idInvoice = 0) { CreateDocument waybill = new CreateDocument(car); Driver driver = null; if (idInvoice != 0) { InvoiceList invoiceList = InvoiceList.getInstance(); Invoice invoice = invoiceList.getItem(idInvoice); DriverList driverList = DriverList.getInstance(); driver = driverList.getItem(Convert.ToInt32(invoice.DriverToID)); } waybill.CreateWaybill(date, driver); try { if (_type == WayBillType.Day) { waybill.AddRouteInWayBill(date, Fields.All); } } catch (NullReferenceException ex) { MessageBox.Show(ex.Message, "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Information); waybill.Exit(); throw; } return(waybill); }
private void btnSave_Click(object sender, EventArgs e) { if (_workWithForm.IsEditMode()) { _invoice.DriverFromID = cbDriverFrom.SelectedValue.ToString(); _invoice.DriverToID = cbDriverTo.SelectedValue.ToString(); _invoice.RegionFromID = cbRegionFrom.SelectedValue.ToString(); _invoice.RegionToID = cbRegionTo.SelectedValue.ToString(); _invoice.Date = dtpDate.Value; _invoice.DateMove = mtbDateMove.Text; TextBox tbFile = ucFile.Controls["tbFile"] as TextBox; _invoice.File = tbFile.Text; _invoice.Save(); if (_check.Checked) { DriverList driverList = DriverList.getInstance(); Driver driver = driverList.getItem(Convert.ToInt32(cbDriverFrom.SelectedValue.ToString())); driver.IsDriver = false; driver.Save(); } DialogResult = System.Windows.Forms.DialogResult.OK; } else { _workWithForm.SetEditMode(true); } }
private void LoadDictionary() { DriverList driverList = DriverList.getInstance(); cbDriver.DataSource = driverList.ToDataTable(_fuelCardDriver.Driver.ID != 0); cbDriver.DisplayMember = "ФИО"; cbDriver.ValueMember = "id"; }
public Tabel(string number, DateTime date) { Driver = DriverList.getInstance().getItemByNumber(number); Date = date; Comment = string.Empty; provider = Provider.GetProvider(); }
public EMail() { Driver driver = User.getDriver(); DriverList driverList = DriverList.getInstance(); Driver employeeTransport = driverList.GetDriverListByRole(RolesList.Editor).First(); _authorEmail = driver == null ? employeeTransport == null ? ROBOT_EMAIL : employeeTransport.email : driver.email; }
private void setDataSourceDriver(ComboBox combo) { DriverList driverList = DriverList.getInstance(); combo.DataSource = driverList.ToDataTable(_invoice.Id != 0); combo.DisplayMember = "ФИО"; combo.ValueMember = "id"; }
public EMail() { var driver = User.GetDriver(); var driverList = DriverList.getInstance(); var employeeTransport = driverList.GetDriverListByRole(RolesList.Editor).First(); _authorEmail = driver == null ? employeeTransport == null ? RobotEmail : employeeTransport.email : driver.email; }
private void ReadFile(string filename) { try { using (var excelDoc = new ExcelDoc(filename)) { try { excelDoc.SetList("Расходы по а-м"); var grz = (excelDoc.getValue("B4") != null) ? excelDoc.getValue("B4").ToString() : string.Empty; var car = GetCar(grz); if (car == null) { var driverFio = (excelDoc.getValue("B5") != null) ? excelDoc.getValue("B5").ToString() : string.Empty; var driverList = DriverList.getInstance(); var driver = driverList.getItemByFIO(driverFio); if (driver != null) { var driverCarList = DriverCarList.getInstance(); car = driverCarList.GetCar(driver); } if (car == null) { _mileageReportList.Add(new MileageReport(null, string.Concat("Не найден автомобиль: ", grz, " сотрудник: ", driverFio, ". Файл: ", filename))); } } if (car != null) { string value = excelDoc.getValue("C8") != null?excelDoc.getValue("C8").ToString() : string.Empty; SetMileage(car, value); } } catch (IndexOutOfRangeException) { _mileageReportList.Add(new MileageReport(null, string.Concat("Ошибка при чтении файла: ", filename))); } catch (OverflowException) { _mileageReportList.Add(new MileageReport(null, string.Concat("Указан слишком большой пробег в файле: ", filename))); } } } catch { _mileageReportList.Add(new MileageReport(null, string.Concat("Ошибка при чтении файла: ", filename))); } }
private void loadData() { loadDictionary(cbRegion, "Region"); DriverList driverList = DriverList.getInstance(); fillCommonFields(); fillExtraFields(); }
public void ClearStopIfNeed() { DriverList driverList = DriverList.getInstance(); List <Driver> listDriver = driverList.ToList().Where(item => (item.NotificationStop && item.DateStopNotification == DateTime.Today)).ToList(); foreach (Driver driver in listDriver) { driver.DateStopNotification = new DateTime(1, 1, 1); } }
private void changeDataSourceDriverTo() { if (isRegionToNotNull()) { Region region = getRegion(); DriverList driverList = DriverList.getInstance(); cbDriverTo.DataSource = driverList.ToDataTableByRegion(region, _invoice.Id != 0); cbDriverTo.DisplayMember = "ФИО"; cbDriverTo.ValueMember = "id"; } }
internal override object[] getRow() { Regions regions = Regions.getInstance(); DriverList driverList = DriverList.getInstance(); Driver driverFrom = driverList.getItem(_idDriverFrom); Driver driverTo = driverList.getItem(_idDriverTo); return(new object[] { ID, Car.ID, Car.BBNumber, Car.Grz, Number, regions.getItem(_idRegionFrom), driverFrom.GetName(NameType.Full), regions.getItem(_idRegionTo), driverTo.GetName(NameType.Full), Date, _dateMove }); }
private void loadDictionary() { CarList carList = CarList.getInstance(); cbCar.DataSource = carList.ToDataTable(Status.All); cbCar.ValueMember = "idCar"; cbCar.DisplayMember = "Регистрационный знак"; DriverList driverList = DriverList.getInstance(); cbDriver.DataSource = driverList.ToDataTable(); cbDriver.ValueMember = "id"; cbDriver.DisplayMember = "ФИО"; }
private void LoadDictionary() { if (((rbBraun.Checked) || (rbGematek.Checked)) && !chbEmployeeIn1C.Checked) { DriverList driverList = DriverList.getInstance(); cbFio.DataSource = driverList.ToDataTableNotDriver(rbBraun.Checked ? 1 : 2); cbFio.DisplayMember = "ФИО"; cbFio.ValueMember = "id"; } else { cbFio.DataSource = null; } }