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();
}
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;
}
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();
}
