public ActionResult Create(Vehicle vehicle) { try { sqlconn.Open(); var r = VehicleLogic.Create(sqlconn, vehicle, vehicle.VehicleTypeId.Value, vehicle.VehicleBrandId.Value, 4, 1); if (r == -1) { sqlconn.Close(); TempData["SuccessMessage"] = "VIN už v DB existuje."; return(View()); } sqlconn.Close(); return(RedirectToAction(nameof(Index))); } catch { sqlconn.Close(); TempData["SuccessMessage"] = "Chyba při ukládání vozidla do DB."; return(View()); } }
private void Button_Click(object sender, RoutedEventArgs e) { try { Inspection im = new Inspection() { Id = -1, Vehicle = VehicleLogic.FindById(_sqlConn, Convert.ToInt32(cbVehicle.SelectedValue)), InspectionDate = inspectionDatePicker.SelectedDate.Value, ValidTo = validToPicker.SelectedDate.Value, InspectionStation = InspectionStationLogic.FindById(_sqlConn, Convert.ToInt32(cbStation.SelectedValue)), ProtocolNumber = tbProtocolNr.Text, Tachometer = Convert.ToInt32(tbTachometer.Text), Price = Convert.ToInt32(tbPrice.Text), Defects = tbDefects.Text }; bool result = InspectionLogic.Insert(_sqlConn, im, out var error); if (!result) { MessageBox.Show(error, "Stop", MessageBoxButton.OK, MessageBoxImage.Stop); } else { MessageBox.Show($"Prohlídka byla uložena.", "Info", MessageBoxButton.OK, MessageBoxImage.Information); } } catch (Exception ex) { MessageBox.Show($"Vyplněné údaje jsou chybné:\n{ex.Message}", "Stop", MessageBoxButton.OK, MessageBoxImage.Stop); } }
// Use this for initialization void Start() { collider = GetComponent<WheelCollider>(); owner = GetComponentInParent<VehicleLogic>(); foreach (Transform t in transform) wheel = t; //happens only once }
// GET: Vehicles/Details/5 public ActionResult Details(int id) { sqlconn.Open(); Vehicle vehicle = VehicleLogic.FindById(sqlconn, id); sqlconn.Close(); return(View(vehicle)); }
// GET: Vehicles public ActionResult Index() { sqlconn.Open(); List <Vehicle> vehicles = VehicleLogic.FindAll(sqlconn); sqlconn.Close(); return(View(vehicles)); }
// Use this for initialization void Start() { wheelCollider = GetComponent <WheelCollider>(); owner = GetComponentInParent <VehicleLogic>(); foreach (Transform t in transform) { wheel = t; //happens only once } }
public void Refresh() { List <Vehicle> vehicles = VehicleLogic.FindAll(_sqlConn); cbVehicle.ItemsSource = vehicles; cbVehicle.DisplayMemberPath = "Title"; cbVehicle.SelectedValuePath = "Id"; List <InspectionStation> stations = InspectionStationLogic.FindAll(_sqlConn); cbStation.ItemsSource = stations; cbStation.DisplayMemberPath = "Company"; cbStation.SelectedValuePath = "Id"; }
// GET: Vehicles/Delete/5 public ActionResult Delete(int id) { sqlconn.Open(); var vehicle = VehicleLogic.Delete(sqlconn, 1, id); sqlconn.Close(); if (!vehicle) { return(View(@"<script language='javascript'>alert('Nemáte oprávnění smazat vozidlo.');</script>")); } return(RedirectToAction(nameof(Index))); }
private void btnDelete_Click(object sender, RoutedEventArgs e) { var mb = MessageBox.Show($"Přejete si opravdu smazat vozdilo?", "Smazání vozidla", MessageBoxButton.YesNo, MessageBoxImage.Warning); if (mb == MessageBoxResult.No) { return; } VehicleLogic.Delete(_sqlConn, 2, _vehicle.Id); _parent.Refresh(); Close(); }
// GET: Stats public ActionResult Index() { sqlconn.Open(); long vehiclesCount = VehicleLogic.CountVehiclesByAdminId(sqlconn, 1); long driversCount = VehicleLogic.CountDriversByAdminId(sqlconn, 1); long inspectionsCount = InspectionLogic.EndingInspectionsCount(sqlconn, 1, 30); sqlconn.Close(); ViewData["Vehicles"] = vehiclesCount; ViewData["Drivers"] = driversCount; ViewData["Inspections"] = inspectionsCount; return(View()); }
private void Button_Click(object sender, RoutedEventArgs e) { var typeId = cbType.SelectedValue; var brandId = cbBrand.SelectedValue; Vehicle vm = new Vehicle() { Id = -1, LicensePlate = tbLicensePlate.Text, Price = Convert.ToDecimal(tbPrice.Text), PurchasedOn = Convert.ToDateTime(datePicker.Text), Title = tbTitle.Text, VehicleBrand = null, VehicleType = null, Vin = tbVin.Text, Vintage = Convert.ToInt16(tbVintage.Text) }; var result = VehicleLogic.Create(_sqlConn, vm, Convert.ToInt32(typeId), Convert.ToInt32(brandId), 4, 1); if (result == -1) { MessageBox.Show($"VIN již v DB existuje.", "Stop", MessageBoxButton.OK, MessageBoxImage.Stop); } else if (result == 0) { MessageBox.Show($"Vozidlo bylo uloženo.", "Info", MessageBoxButton.OK, MessageBoxImage.Information); Refresh(); } }
public ActionResult Delete(int id, Vehicle vehicle) { try { sqlconn.Open(); List <Inspection> inspections = InspectionLogic.FindAllByVehicleId(sqlconn, id); sqlconn.Close(); if (inspections.Count > 0) { return(View("<script>alert('Nemůžete smazat vozidlo, které obsahuje prohlídky.');</script>")); } sqlconn.Open(); VehicleLogic.Delete(sqlconn, 1, vehicle.Id); sqlconn.Close(); return(RedirectToAction(nameof(Index))); } catch { return(View(vehicle)); } }
static void Main(string[] args) { LanguageLogic languageLogic = new LanguageLogic(); UserLogic userLogic = new UserLogic(); UserFleetLogic userFleetLogic = new UserFleetLogic(); FleetLogic fleetLogic = new FleetLogic(); VehicleLogic vehicleLogic = new VehicleLogic(); DriverLogic driverLogic = new DriverLogic(); ConfigTagLogic configTagLogic = new ConfigTagLogic(); ConfigTagLanguageCrud configTagLanguageCrud = new ConfigTagLanguageCrud(); FunctionsLogic functionsLogic = new FunctionsLogic(); ConfigUserLoginLogic configUserLoginLogic = new ConfigUserLoginLogic(); Mail mail = new Mail(); UserRestoreLogic userRestoreLogic = new UserRestoreLogic(); CarFleetSecurity secCarFleet = CarFleetSecurity.GetContext; //List<LanguageEntity> listLanguage = languageLogic.SelectAll(); //LanguageEntity languageEntity = languageLogic.GetById(1); //UserEntity userEntity = userLogic.Login("ManuelM"); //List<UserFleetEntity> listuserFleet = userFleetLogic.SelectByUserId(userEntity.Id); //List<FleetEntity> listFleet = fleetLogic.GetByCompanyId(userEntity.Id_company); //List<VehicleEntity> listVehicle = vehicleLogic.GetByCompanyId(userEntity.Id_company); //List<VehicleEntity> listVehicle2 = vehicleLogic.GetByFleetId(listFleet.FirstOrDefault().Id); //List<DriverEntity> listDriver = driverLogic.GetByCompanyId(userEntity.Id_company); //ConfigTagEntity configTagEntity=new ConfigTagEntity(); //configTagEntity.Tag_key = "lblUser"; //configTagEntity.Page_name = "Login"; //configTagLogic.Insert(configTagEntity); //int totalDriver = functionsLogic.GetTotalsByCompanyId(2099, Utils.Constants.CARFLEET_ENTITY.DRIVER); //int totalFleet= functionsLogic.GetTotalsByCompanyId(2099, Utils.Constants.CARFLEET_ENTITY.FLEET); //int totalVehicle = functionsLogic.GetTotalsByCompanyId(2099, Utils.Constants.CARFLEET_ENTITY.VEHICLE); //string token=configUserLoginLogic.Insert(4188, "", 1800); string pass = CarFleetSecurityCipher.Encrypt("ManuelM"); string passDecrypt = CarFleetSecurityCipher.Decrypt(pass); string email = "ManuelM"; List <string> addressList = new List <string>(); addressList.Add("*****@*****.**"); string errorMessage; UserEntity userEntity = userLogic.SelectByLoginName(email); if (userEntity != null) { Random random = new Random(); string code = random.Next(10000, 99999).ToString(); int timeExpiration = secCarFleet.GetNumberConfig(CarFleetSecurity.APP_CONFIG_RESTORE_PASSWORD_TIME_EXPIRE); if (userRestoreLogic.Insert(userEntity.Id, code, timeExpiration)) { Mail carFleetMail = new Mail(); var sendMail = carFleetMail.RestorePassword("*****@*****.**", code, out errorMessage); } if (userRestoreLogic.IsValidCode(email, code, out errorMessage)) { string newPassword = "******"; var updatePass = userLogic.UpdatePassword(email, newPassword); } } var f = 234; }
public void Refresh() { var vehicles = VehicleLogic.FindAll(_sqlConn); DgVehicles.ItemsSource = vehicles; }
public HttpResponseMessage PutVehicles(Vehicle vehicle) { return(VehicleLogic.PutVehicles(Request, vehicle)); }
public HttpResponseMessage DeleteVehicles(int id) { return(VehicleLogic.DeleteVehicles(Request, id)); }
public HttpResponseMessage GetVehicles(int?id = null, string make = null, string model = null) { return(VehicleLogic.GetVehicles(Request, id)); }