public ActionResult Create_trailer(trailer tra, HttpPostedFileBase fileUpload)
{
if (fileUpload == null)
{
ViewBag.Notification = "Please select the cover photo";
return(View());
}
else
{
if (ModelState.IsValid)
{
var fileName = Path.GetFileName(fileUpload.FileName);
var path = Path.Combine(Server.MapPath("~/images/trailer"), fileName);
if (System.IO.File.Exists(path))
{
ViewBag.Notification = "Image already exists";
}
else
{
fileUpload.SaveAs(path);
}
tra.image_link = fileName;
data.trailers.InsertOnSubmit(tra);
data.SubmitChanges();
}
else
{
return(HttpNotFound());
}
return(RedirectToAction("List_trailers"));
}
}
// Trailer cua tung phim hien thi trong trang film_single
public ActionResult Trailer(int id)
{
trailer trailer = data.trailers.Where(or => or.film_id == id).OrderByDescending(a => a.id).FirstOrDefault();
if (trailer == null)
{
return(PartialView());
}
return(PartialView(trailer));
}
public ActionResult Delete_trailer(int id)
{
trailer tra = data.trailers.SingleOrDefault(n => n.id == id);
if (tra == null)
{
Response.StatusCode = 404;
return(null);
}
else
{
return(View(tra));
}
}
trailer getTrailer3(long idTruckruck_id)
{
if (bdgTrailer3.Current == null)
{
return(null);
}
trailer t3 = (trailer)bdgTrailer3.Current;
t3.truck_id = idTruckruck_id;
t3.index = 3;
if (IsNew)
{
t3.registred_by = Singleton.getUser().id;
t3.registred_at = trailer.Now();
}
return(t3);
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (listBox.SelectedItems.Count > 0)
{
if (bdgSelectedTrailes.Count >= 3)
{
XtraMessageBox.Show("O numero máximo de placas permitido são 3!");
return;
}
trailer t = (trailer)bdgTrailes.Current;
if (!bdgSelectedTrailes.Contains(t))
{
bdgSelectedTrailes.Add(t);
}
}
}
trailer getTrailer2(long idTruckruck_id)
{
if (bdgTrailer2.Current == null)
{
return(null);
}
trailer t2 = (trailer)bdgTrailer2.Current;
t2.truck_id = idTruckruck_id;
t2.index = 2;
if (IsNew)
{
t2.registred_by = Singleton.getUser().id;
t2.registred_at = trailer.Now();
}
return(t2);
}
trailer getTrailer1(long idTruckruck_id)
{
if (bdgTrailer1.Current == null)
{
return(null);
}
trailer t1 = (trailer)bdgTrailer1.Current;
t1.truck_id = idTruckruck_id;
t1.index = 1;
if (IsNew)
{
t1.registred_by = Singleton.getUser().id;
t1.registred_at = trailer.Now();
}
return(t1);
}
public ActionResult Delete_trailer_confirm(int id)
{
trailer tra = data.trailers.SingleOrDefault(n => n.id == id);
if (tra == null)
{
Response.StatusCode = 404;
return(null);
}
else
{
string directoryimg = Server.MapPath("/images/trailer/" + tra.image_link);
System.IO.File.Delete(directoryimg);
data.trailers.DeleteOnSubmit(tra);
data.SubmitChanges();
return(RedirectToAction("List_trailers"));
}
}
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;
}
}
}
private void ckTrailer3_CheckedChanged(object sender, EventArgs e)
{
CheckEdit ck = (CheckEdit)sender;
ActiveInactivePanel(pnTrailer3, ck);
tfBoardTrailer3.Focus();
if (ck.Checked)
{
bdgTrailer3.DataSource = new trailer()
{
index = 3
}
}
;
else
{
trailer t3 = ((trailer)bdgTrailer3.Current);
if ((t3 != null ? t3.id : 0) > 0)
{
trailer.Delete(t3.id);
}
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();
}
private void SpawnTrailer()
{
Trailer = Boat.GetComponent <trailer>();
}
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 btnSave_Click(object sender, EventArgs e)
{
bool error = false;
if (ckTrailer1.Checked && !vTrailer1.Validate())
{
error = true;
}
if (ckTrailer2.Checked && !vTrailer2.Validate())
{
error = true;
}
if (ckTrailer3.Checked && !vTrailer3.Validate())
{
error = true;
}
if (error)
{
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 = trailer.repo.GetTransaction())
{
Console.WriteLine(0);
trailer t1 = getTrailer1(CurrentTruck.id);
if (t1 != null)
{
Console.WriteLine(1);
t1.Save();
tfIdTrailer1.EditValue = t1.id;
}
trailer t2 = getTrailer2(CurrentTruck.id);
if (t2 != null)
{
Console.WriteLine(2);
t2.Save();
tfIdTrailer2.EditValue = t2.id;
}
trailer t3 = getTrailer3(CurrentTruck.id);
if (t3 != null)
{
Console.WriteLine(3);
t3.Save();
tfIdTrailer3.EditValue = t3.id;
}
Console.WriteLine(4);
scope.Complete();
if (this.MessageToSave("Reboque(s)"))
{
desk.AddTabAndCloseCurrent(new TrailerForm(null), "Reboque(s)", 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);
}
}
