public static bool DriverTruckIsUnique(truck c) { try { int count; var s = TruckSystemRepo.GetInstance().ExecuteScalar <string>("SELECT COUNT(id) FROM trucks WHERE driver_id=@0", c.driver_id); if (s.Equals(DBNull.Value) || String.IsNullOrEmpty(s)) { count = 0; } else { count = Convert.ToInt32(s); } if (count == 0) { return(true); } else { return(false); } } catch (Exception ex) { throw new Exception(ex.Message, ex.InnerException); } }
private void cbTruck_EditValueChanged(object sender, EventArgs e) { try { SplashScreenManager.ShowForm(desk, typeof(PleaseWaitForm), false, false, false); if (cbTruck.EditValue != DBNull.Value && Convert.ToInt64(cbTruck.EditValue) > 0) { truck t = truck.SingleOrDefault(cbTruck.EditValue); Trailers = trailer.Fetch("WHERE truck_id=@0 ORDER BY index", t.id); setTrailers(); if (IsNew) { cbDriver.EditValue = t.driver_id; ((freight)bdgFreight.Current).driver_id = t.driver_id; } } else { lbTrailers.Text = String.Format("Reboques:"); cbDriver.EditValue = 0; bdgDrivers.ResetCurrentItem(); } SplashScreenManager.CloseForm(false); } catch (Exception ex) { SplashScreenManager.CloseForm(false); XtraMessageBox.Show(String.Format("Ocorreu um erro:\n\n{0}\n{1}", ex.Message, ex.InnerException)); } }
public TrailerForm(truck idTruck) { InitializeComponent(); lbDriver.Text = ""; ControlsUtil.SetBackColor(this.Controls); CurrentTruck = idTruck; setValidations(); loadTrucks(); }
private void btnSave_Click(object sender, EventArgs e) { if (!vTruck.Validate()) { return; } try { SplashScreenManager.ShowForm(null, typeof(PleaseWaitForm), false, false, false); if (IsNew) { if (!Validations.Unique.BoardTruckIsUnique((truck)bdgTruck.Current)) { SplashScreenManager.CloseForm(false); XtraMessageBox.Show("Placa já cadastrada, verifique!"); return; } if (!Validations.Unique.DriverTruckIsUnique((truck)bdgTruck.Current)) { SplashScreenManager.CloseForm(false); XtraMessageBox.Show("Motorista ja cadastrado para outro caminhão, verifique!"); return; } } using (var scope = truck.repo.GetTransaction()) { truck tr = (truck)bdgTruck.Current; if (IsNew) { tr.registred_by = Singleton.getUser().id; tr.registred_at = trailer.Now(); } tr.Save(); tfIdTruck.EditValue = tr.id; scope.Complete(); XtraMessageBox.Show(String.Format("Veículo {0} salvo com sucesso.", tr.board)); desk.AddTabAndCloseCurrent(new TruckForm(truck.SingleOrDefault(tr.id)), "Editar caminhão", false); //if (this.MessageToSave("Caminhão")) // desk.AddTabAndCloseCurrent(new TruckForm(null), "Novo caminhão", false); } } catch (Exception ex) { truck.repo.AbortTransaction(); XtraMessageBox.Show(String.Format("Ocorre um erro:\n{0}\n{1}", ex.Message, ex.InnerException)); } finally { SplashScreenManager.CloseForm(false); } }
public TruckForm(truck t) { InitializeComponent(); ControlsUtil.SetBackColor(this.Controls); setValidations(); loadData(null, null); if (t == null) { t = new truck(); IsNew = true; } else { tfBoardTruck.Properties.ReadOnly = true; } bdgTruck.DataSource = t; }
private void cbTruck_EditValueChanged(object sender, EventArgs e) { pnTabs.Enabled = false; lbDriver.Text = ""; bdgTrailer1.Clear(); bdgTrailer2.Clear(); bdgTrailer3.Clear(); ckTrailer1.Checked = false; ckTrailer2.Checked = false; ckTrailer3.Checked = false; if (cbTruck.EditValue != null || Convert.ToInt64(cbTruck.EditValue) > 0) { pnTabs.Enabled = true; IsNew = true; CurrentTruck = truck.SingleOrDefault( Convert.ToInt64(cbTruck.EditValue)); lbDriver.Text = driver.SingleOrDefault(CurrentTruck.driver_id).full_name; trailer tr1 = trailer.SingleOrDefault("WHERE truck_id=@0 AND index=@1", CurrentTruck.id, 1); if (tr1 != null) { ckTrailer1.Checked = true; bdgTrailer1.DataSource = tr1; IsNew = false; } trailer tr2 = trailer.SingleOrDefault("WHERE truck_id=@0 AND index=@1", CurrentTruck.id, 2); if (tr2 != null) { ckTrailer2.Checked = true; bdgTrailer2.DataSource = tr2; IsNew = false; } trailer tr3 = trailer.SingleOrDefault("WHERE truck_id=@0 AND index=@1", CurrentTruck.id, 3); if (tr3 != null) { ckTrailer3.Checked = true; bdgTrailer3.DataSource = tr3; IsNew = false; } } }
public static bool BoardTruckIsUnique(truck c) { try { int count; var s = TruckSystemRepo.GetInstance().ExecuteScalar<string>("SELECT COUNT(id) FROM trucks WHERE board=@0", c.board); if (s.Equals(DBNull.Value) || String.IsNullOrEmpty(s)) count = 0; else count = Convert.ToInt32(s); if (count == 0) return true; else return false; } catch (Exception ex) { throw new Exception(ex.Message, ex.InnerException); } }
private void btnGenerate_Click(object sender, EventArgs e) { if (!validator.Validate()) return; List<freight> llf = null; truck _truck = null; driver _driver = null; long truck_id = Convert.ToInt64(cbTruck.EditValue); long driver_id = Convert.ToInt64(cbDriver.EditValue); DateTime start = dtStart.DateTime; DateTime end = dtEnd.DateTime; bool isTruck = ckTruck.Checked; if(isTruck) { _truck = truck.SingleOrDefault(truck_id); llf = freight.Fetch(String.Format("WHERE truck_id={0} AND start BETWEEN '{1:yyyy-MM-dd}' AND '{2:yyyy-MM-dd}' ORDER BY start", _truck.id, start, end)); _driver = driver.SingleOrDefault(_truck.driver_id); } else if (ckDriver.Checked) { driver dri = driver.SingleOrDefault(driver_id); _truck = truck.SingleOrDefault("WHERE driver_id=@0", driver_id); llf = freight.Fetch(String.Format("WHERE driver_id={0} AND start BETWEEN '{1:yyyy-MM-dd}' AND '{2:yyyy-MM-dd}' ORDER BY start", dri.id, start, end)); _driver = dri; if (_truck == null) _truck = new truck(); } if (llf.Count <= 0) { XtraMessageBox.Show("Nenhum resultado encontrado para o período informado!"); return; } decimal value_gross = 0; SplashScreenManager.ShowForm(this, typeof(PleaseWaitForm), false, false, false); trailer t1 = new trailer(); trailer t2 = new trailer(); trailer t3 = new trailer(); if (_truck.id > 0) { t1 = trailer.SingleOrDefault("WHERE truck_id=@0 AND index=@1", _truck.id, 1); t2 = trailer.SingleOrDefault("WHERE truck_id=@0 AND index=@1", _truck.id, 2); t3 = trailer.SingleOrDefault("WHERE truck_id=@0 AND index=@1", _truck.id, 3); } FreightsByTruckModel fm = new FreightsByTruckModel() { emission_at = String.Format("Emitido em {0:dd/MM/yyyy HH:mm}", freight.Now()), reference = String.Format("Período de {0:dd/MM/yyyy} à {1:dd/MM/yyyy}", start, end), signature = "Emitido por CadoreTecnologia", truck = String.Format("{0} - {1}{2}{3}", _truck.board, (t1 != null ? t1.board : ""), (t2 != null ? "/" + t2.board : ""), (t3 != null ? "/" + t3.board : "")), driver = _driver.full_name }; if (_truck.id <= 0 && (t1.id <= 0) && (t2.id <= 0) && (t3.id <= 0)) { fm.truck = "Motorista não cadastrado para nenhum veículo."; if (_driver.inactive) fm.truck += " Motorista inativo."; } List<ListFreights> lf = new List<ListFreights>(); foreach (freight f in llf) { decimal value_fueleds = 0, value_outputs = 0; List<ListFueleds> lfueled = new List<ListFueleds>(); List<fueled> llfueled = fueled.Fetch("WHERE freight_id = @0", f.id); foreach (fueled fu in llfueled) { value_fueleds += fu.total; lfueled.Add(new ListFueleds() { date = Convert.ToDateTime(fu.date), liters = fu.liters, discont = fu.discount, value_liters = fu.value_liters, value_total = fu.total, gas_station = customer.SingleOrDefault(fu.gas_station_id).corporate_name }); } List<ListOutputs> loutputs = new List<ListOutputs>(); List<output> lloutputs = output.Fetch("WHERE freight_id = @0", f.id); foreach (output o in lloutputs) { value_outputs += o.value; loutputs.Add(new ListOutputs() { date = Convert.ToDateTime(o.date), description = o.description, value = o.value, customer = customer.SingleOrDefault(o.customer_id).corporate_name }); } lf.Add(new ListFreights() { comission = f.value_comission, date = Convert.ToDateTime(f.start), id = f.id, listFueleds = lfueled, listOutputs = loutputs, driver = isTruck ? driver.SingleOrDefault(f.driver_id).full_name : truck.SingleOrDefault(f.truck_id).board, outputs = value_outputs, fueleds = value_fueleds, product = f.product, value_ton = f.value_ton, gross = (f.value_ton * f.weight), liquid = ((f.value_ton * f.weight) - (f.value_comission + value_fueleds + value_outputs)) }); value_gross += (f.value_ton * f.weight); } fm.gross = value_gross; fm.listFreights = lf; FreightsByTruckReport report = new FreightsByTruckReport(); report.bdgFreigths.DataSource = fm; report.list.Value = isTruck ? "Motorista" : "Placa"; report.start_page.Value = isTruck ? "Veículo" : "Motorista"; ReportPrintTool tool = new ReportPrintTool(report); SplashScreenManager.CloseForm(false); tool.ShowRibbonPreviewDialog(); }
private void cbTruck_EditValueChanged(object sender, EventArgs e) { if (cbTruck.EditValue != null || Convert.ToInt64(cbTruck.EditValue) > 0) { pnTabs.Enabled = true; IsNew = true; CurrentTruck = truck.SingleOrDefault(Convert.ToInt64(cbTruck.EditValue)); lbDriver.Text = driver.SingleOrDefault(CurrentTruck.driver_id).full_name; trailer tr1 = trailer.SingleOrDefault("WHERE truck_id=@0 AND index=@1", CurrentTruck.id, 1); if (tr1 != null) { ckTrailer1.Checked = true; bdgTrailer1.DataSource = tr1; IsNew = false; } trailer tr2 = trailer.SingleOrDefault("WHERE truck_id=@0 AND index=@1", CurrentTruck.id, 2); if (tr2 != null) { ckTrailer2.Checked = true; bdgTrailer2.DataSource = tr2; IsNew = false; } trailer tr3 = trailer.SingleOrDefault("WHERE truck_id=@0 AND index=@1", CurrentTruck.id, 3); if (tr3 != null) { ckTrailer3.Checked = true; bdgTrailer3.DataSource = tr3; IsNew = false; } } else { pnTabs.Enabled = false; lbDriver.Text = ""; bdgTrailer1.Clear(); bdgTrailer2.Clear(); bdgTrailer3.Clear(); } }
private void btnGenerate_Click(object sender, EventArgs e) { if (!validator.Validate()) { return; } List <freight> llf = null; truck _truck = null; driver _driver = null; long truck_id = Convert.ToInt64(cbTruck.EditValue); long driver_id = Convert.ToInt64(cbDriver.EditValue); DateTime start = dtStart.DateTime; DateTime end = dtEnd.DateTime; bool isTruck = ckTruck.Checked; if (isTruck) { _truck = truck.SingleOrDefault(truck_id); llf = freight.Fetch(String.Format("WHERE truck_id={0} AND start BETWEEN '{1:yyyy-MM-dd}' AND '{2:yyyy-MM-dd}' ORDER BY start", _truck.id, start, end)); _driver = driver.SingleOrDefault(_truck.driver_id); } else if (ckDriver.Checked) { driver dri = driver.SingleOrDefault(driver_id); _truck = truck.SingleOrDefault("WHERE driver_id=@0", driver_id); llf = freight.Fetch(String.Format("WHERE driver_id={0} AND start BETWEEN '{1:yyyy-MM-dd}' AND '{2:yyyy-MM-dd}' ORDER BY start", dri.id, start, end)); _driver = dri; if (_truck == null) { _truck = new truck(); } } if (llf.Count <= 0) { XtraMessageBox.Show("Nenhum resultado encontrado para o período informado!"); return; } decimal value_gross = 0; SplashScreenManager.ShowForm(this, typeof(PleaseWaitForm), false, false, false); trailer t1 = new trailer(); trailer t2 = new trailer(); trailer t3 = new trailer(); if (_truck.id > 0) { t1 = trailer.SingleOrDefault("WHERE truck_id=@0 AND index=@1", _truck.id, 1); t2 = trailer.SingleOrDefault("WHERE truck_id=@0 AND index=@1", _truck.id, 2); t3 = trailer.SingleOrDefault("WHERE truck_id=@0 AND index=@1", _truck.id, 3); } FreightsByTruckModel fm = new FreightsByTruckModel() { emission_at = String.Format("Emitido em {0:dd/MM/yyyy HH:mm}", freight.Now()), reference = String.Format("Período de {0:dd/MM/yyyy} à {1:dd/MM/yyyy}", start, end), signature = "Emitido por CadoreTecnologia", truck = String.Format("{0} - {1}{2}{3}", _truck.board, (t1 != null ? t1.board : ""), (t2 != null ? "/" + t2.board : ""), (t3 != null ? "/" + t3.board : "")), driver = _driver.full_name }; if (_truck.id <= 0 && (t1.id <= 0) && (t2.id <= 0) && (t3.id <= 0)) { fm.truck = "Motorista não cadastrado para nenhum veículo."; if (_driver.inactive) { fm.truck += " Motorista inativo."; } } List <ListFreights> lf = new List <ListFreights>(); foreach (freight f in llf) { decimal value_fueleds = 0, value_outputs = 0; List <ListFueleds> lfueled = new List <ListFueleds>(); List <fueled> llfueled = fueled.Fetch("WHERE freight_id = @0", f.id); foreach (fueled fu in llfueled) { value_fueleds += fu.total; lfueled.Add(new ListFueleds() { date = Convert.ToDateTime(fu.date), liters = fu.liters, discont = fu.discount, value_liters = fu.value_liters, value_total = fu.total, gas_station = customer.SingleOrDefault(fu.gas_station_id).corporate_name }); } List <ListOutputs> loutputs = new List <ListOutputs>(); List <output> lloutputs = output.Fetch("WHERE freight_id = @0", f.id); foreach (output o in lloutputs) { value_outputs += o.value; loutputs.Add(new ListOutputs() { date = Convert.ToDateTime(o.date), description = o.description, value = o.value, customer = customer.SingleOrDefault(o.customer_id).corporate_name }); } lf.Add(new ListFreights() { comission = f.value_comission, date = Convert.ToDateTime(f.start), id = f.id, listFueleds = lfueled, listOutputs = loutputs, driver = isTruck ? driver.SingleOrDefault(f.driver_id).full_name : truck.SingleOrDefault(f.truck_id).board, outputs = value_outputs, fueleds = value_fueleds, product = f.product, value_ton = f.value_ton, gross = (f.value_ton * f.weight), liquid = ((f.value_ton * f.weight) - (f.value_comission + value_fueleds + value_outputs)) }); value_gross += (f.value_ton * f.weight); } fm.gross = value_gross; fm.listFreights = lf; FreightsByTruckReport report = new FreightsByTruckReport(); report.bdgFreigths.DataSource = fm; report.list.Value = isTruck ? "Motorista" : "Placa"; report.start_page.Value = isTruck ? "Veículo" : "Motorista"; ReportPrintTool tool = new ReportPrintTool(report); SplashScreenManager.CloseForm(false); tool.ShowRibbonPreviewDialog(); }