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