private void radioBtnLinea_CheckedChanged(object sender, EventArgs e)
{
if (radioBtnLinea.Checked == true)
{
grdVehicles.DataSource = WorkVehicle.getAllVehicleLine();
}
}
private void btnDeleteVehicle_Click(object sender, EventArgs e)
{
if (grdVehicles.SelectedRows.Count > 0)
{
var result = MessageBox.Show("¿Desea eliminar el Vehiculo?", "Confirmación", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
try
{
idVehicle = grdVehicles.CurrentRow.Cells["Id"].Value.ToString();
WorkVehicle.deleteVehicleSP(idVehicle);
MessageBox.Show("Se elimino correctamente", "Información", MessageBoxButtons.OK, MessageBoxIcon.Information);
loadVehiclesSP();
}
catch (Exception)
{
MessageBox.Show("No se pudo eliminar!!!. Tiene una venta asociada", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show("Seleccione una fila!!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public PartialViewResult CreateEditWorkVehicle(WorkVehicle model)
{
ViewBag.Title = (model.Id == -1) ? "Aggiungi Percorso" : "Modifica Percorso";
ViewBag.Routes = GetRoutes(User.Identity.Name);
// Ordini Configurabili
ViewBag.lstUserOrders = DAL.SelectList.UserOrders(model.UserId);
if (!ModelState.IsValid)
{
return(PartialView("_CreateEditWorkVehicle", model));
}
// Inserimento/Modifica in database
try
{
// verifico se l'utente e teamleader
model.UserApprove = (db.Orders.Any(x => x.OrderId == model.OrderId && x.TeamLeaderId == model.UserId)) ? model.UserId : null;
db.WorkVehicles.AddOrUpdate(m => m.Id, model);
db.SaveChanges();
ViewBag.Message = (model.Id == -1) ? "Aggiunto con Successo!" : "Modificato con Successo!";
ViewBag.ReturnUrl = string.Format("/Vehicle/Index?year={0}&month={1}", model.Date.Year, model.Date.Month);
return(PartialView("../Shared/_Success"));
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.MySqlExMessage());
return(PartialView("_CreateEditWorkVehicle", model));
}
}
public PartialViewResult CreateWorkVehicle(int VehicleId)
{
var user = db.Users.Find(User.Identity.Name);
var vehicle = db.UsersVehicles.Find(VehicleId);
// Se il veicolo e piu vecchio di tre mesi chiedo la modifica
if (DateTime.Now > vehicle.UpdateDate.AddMonths(3))
{
ViewBag.Title = "Modifica Veicolo";
ModelState.AddModelError("", "Aggiornare costo veicolo");
return(PartialView("_CreateEditUserVehicle", vehicle));
}
var model = new WorkVehicle();
model.Id = -1;
model.Date = DateTime.Now;
model.UserId = user.UserId;
model.VehicleDescription = vehicle.VehicleDescription;
model.Cost_Km = vehicle.Cost;
model.KmHomeWork = vehicle.KmHomeWork;
ViewBag.Title = "Aggiungi Percorso";
ViewBag.Routes = GetRoutes(User.Identity.Name);
// Ordini Configurabili
ViewBag.lstUserOrders = DAL.SelectList.UserOrders(user.UserId);
return(PartialView("_CreateEditWorkVehicle", model));
}
private void btnInsertSale_Click(object sender, EventArgs e)
{
Sale sale = new Sale();
var result = MessageBox.Show("¿Desea registrar la venta?", "Confirmación", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
sale.Date = dateTimePickerDate.Value;
//sale.PaymentMethod = (string)comboBoxPaymentMethod.SelectedValue;
sale.idPaymentMethod = Convert.ToInt32(comboBoxPaymentMethod.SelectedValue);
sale.FinalPrice = Convert.ToDecimal(textBoxPriceTotal.Text);
sale.CustomerID = Convert.ToInt32(comboBoxCustomer.SelectedValue);
sale.VehicleID = Convert.ToInt32(comboBoxVehicle.SelectedValue);
sale.UserId = currentUser.Id;
sale.State = "ACTIVA";
WorkSales.insertarVenta(sale);
WorkVehicle.updateVehicleState(sale.VehicleID);
MessageBox.Show("Se registro correctamente la venta", "Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information);
clear();
this.Hide();
}
}
private void btnRegisterUser_Click(object sender, EventArgs e)
{
VehicleForm vehicleForm = new VehicleForm();
Vehicle vehicle = new Vehicle();
if (validateField())
{
if (!WorkVehicle.getVehiculeByEnrollment(textEnrollment.Text))
{
if (isEdit == false)
{
var result = MessageBox.Show("¿Desea registrar el vehiculo?", "Confirmación", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
vehicle.Enrollment = textEnrollment.Text;
vehicle.Brand = comboBoxBrands.Text;
vehicle.VehicleLine = comboBoxLine.Text;
vehicle.Model = int.Parse(textBoxModel.Text);
vehicle.Colour = textBoxColor.Text;
vehicle.NumberOfDoors = int.Parse(comboBoxDoors.Text);
vehicle.Gps = radioButton1.Checked;
vehicle.idType = Convert.ToInt32(comboBoxType.SelectedValue);
vehicle.idClassVehicle = Convert.ToInt32(comboBoxClass.SelectedValue);
vehicle.Price = decimal.Parse(textBoxPrice.Text);
//WorkVehicle.addVehicle(vehicle);
WorkVehicle.addVehicleSP(vehicle);
MessageBox.Show("MATRICULA: " + vehicle.Enrollment + " MARCA: " + vehicle.Brand + "LINEA: " + vehicle.VehicleLine +
" MODELO: " + vehicle.Model + " COLOR: " + vehicle.Colour + " PUERTAS: " + vehicle.NumberOfDoors +
" GPS: " + vehicle.showGps() + " TIPO: " + vehicle.Type + " CLASE: " + vehicle.ClassVehicle
+ " PRECIO: " + vehicle.Price, "Datos del Vehiculo cargados", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
//loadVehicles();
vehicleForm.loadVehiclesSP();
cleanFields();
}
}
//update Vehicle
if (isEdit == true)
{
var result = MessageBox.Show("¿Desea guardar los cambios?", "Confirmación", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
vehicle.Id = Convert.ToInt32(idVehicle);
vehicle.Enrollment = textEnrollment.Text;
vehicle.Brand = comboBoxBrands.Text;
vehicle.VehicleLine = comboBoxLine.Text;
vehicle.Model = int.Parse(textBoxModel.Text);
vehicle.Colour = textBoxColor.Text;
vehicle.NumberOfDoors = int.Parse(comboBoxDoors.Text);
vehicle.Gps = radioButton1.Checked;
vehicle.idType = Convert.ToInt32(comboBoxType.SelectedValue);
vehicle.idClassVehicle = Convert.ToInt32(comboBoxClass.SelectedValue);
vehicle.Price = decimal.Parse(textBoxPrice.Text);
//WorkVehicle.updateVehicle(vehicle);
WorkVehicle.updateVehicleSP(vehicle);
//loadVehicles();
vehicleForm.loadVehiclesSP();
cleanFields();
isEdit = false;
MessageBox.Show("Se actualizo correctamente", "Información", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
vForm.loadVehiclesSP();
this.Hide();
}
else
{
MessageBox.Show("La matricula: " + textEnrollment.Text + " ya está registrada, intente otra matricula");
}
}
else
{
MessageBox.Show("Campos en Blancos", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public void loadVehiclesSP()
{
grdVehicles.DataSource = WorkVehicle.getAllVehiclesSP();
}
