// GET: Computer/Create
public ActionResult Create()
{
var employeeOptions = GetEmployeeOptions();
var viewModel = new ComputerFormViewModel()
{
PurchaseDate = DateTime.Now,
EmployeeOptions = employeeOptions
};
return(View(viewModel));
}
public IActionResult New()
{
var vm = new ComputerFormViewModel()
{
Computer = new Computer(),
AgTips = _context.AgTips.ToList()
};
vm.AgTips.Insert(0, new AgTip {
Id = 0, Ad = "Seçiniz..."
});
return(View("ComputerForm", vm));
}
public ViewResult New()
{
var viewModel = new ComputerFormViewModel()
{
Computer = new Computer()
{
KontoId = computerKontoNr
},
Arbeitsspeichers = _context.Arbeitsspeichers.ToList(),
Mauese = _context.Maeuse.ToList(),
Prozessoren = _context.Prozessoren.ToList(),
Tastaturen = _context.Tastaturen.ToList(),
Betriebssysteme = _context.Betriebssysteme.ToList(),
};
var allFestplattenList = _context.Festplatten.ToList();
viewModel.Festplatten = allFestplattenList.Select(c => new SelectListItem
{
Text = c.Hersteller,
Value = c.Id.ToString()
});
var allMonitorenList = _context.Monitore.ToList();
viewModel.Monitore = allMonitorenList.Select(c => new SelectListItem
{
Text = c.Hersteller,
Value = c.Id.ToString()
});
var allAnwendungsSoftwareList = _context.Anwendungssoftwares.ToList();
viewModel.Anwendungssoftware = allAnwendungsSoftwareList.Select(c => new SelectListItem
{
Text = c.Hersteller + " " + c.Bezeichnung,
Value = c.Id.ToString()
});
var allUnterstuetzungsSoftwareList = _context.Unterstuetzungssoftwares.ToList();
viewModel.Unterstuetzungssoftware = allUnterstuetzungsSoftwareList.Select(c => new SelectListItem
{
Text = c.Hersteller + " " + c.Bezeichnung,
Value = c.Id.ToString()
});
return(View("ComputerForm", viewModel));
}
public async Task <IActionResult> Save(ComputerFormViewModel model)
{
if (!ModelState.IsValid)
{
var vm = new ComputerFormViewModel()
{
Computer = new Computer(),
AgTips = _context.AgTips.ToList()
};
vm.AgTips.Insert(0, new AgTip {
Id = 0, Ad = "Seçiniz..."
});
return(View("ComputerForm", vm));
}
try
{
if (model.Computer.Id == 0)
{
_context.Add(model.Computer);
}
else
{
var computerInDb = _context.Computers.Single(c => c.Id == model.Computer.Id);
computerInDb.Stn = model.Computer.Stn;
computerInDb.Serino = model.Computer.Serino;
computerInDb.AgTipId = model.Computer.AgTipId;
computerInDb.Lat = model.Computer.Lat;
computerInDb.Lon = model.Computer.Lon;
}
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
catch (DbUpdateException /* ex */)
{
//Log the error (uncomment ex variable name and write a log.
ModelState.AddModelError("", "Unable to save changes. " +
"Try again, and if the problem persists " +
"see your system administrator.");
}
return(View("ComputerForm", model));
}
public ActionResult Create(ComputerFormViewModel computer)
{
try
{
//if there is an Employee ID value
//execute an update employee function
//this will add the new computerId to an existing employee
//return to indexView
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"INSERT INTO Computer (Make, Model, PurchaseDate)
OUTPUT INSERTED.Id
VALUES (@make, @model, @purchaseDate)";
cmd.Parameters.Add(new SqlParameter("@make", computer.Make));
cmd.Parameters.Add(new SqlParameter("@model", computer.Model));
cmd.Parameters.Add(new SqlParameter("@purchaseDate", computer.PurchaseDate));
var id = (int)cmd.ExecuteScalar();
computer.Id = id;
if (computer.EmployeeId != 0)
{
//update employee
//I will need, the computer.EmployeeId
//and I will need the computer.Id
UpdateEmployee(computer.Id, computer.EmployeeId);
}
return(RedirectToAction(nameof(Index)));
}
}
}
catch (Exception ex)
{
return(View());
}
}
public async Task <IActionResult> Edit(int id)
{
var computer = await _context.Computers.SingleOrDefaultAsync(c => c.Id == id);
if (computer == null)
{
return(NotFound());
}
var vm = new ComputerFormViewModel
{
Computer = computer,
AgTips = _context.AgTips.ToList()
};
vm.AgTips.Insert(0, new AgTip {
Id = 0, Ad = "Seçiniz..."
});
return(View("ComputerForm", vm));
}
public ActionResult Edit(int id)
{
var computer = _context.Computers
.Include(c => c.Festplatten)
.Include(c => c.Monitore)
.Include(c => c.Anwendungssoftware)
.Include(c => c.Unterstuetzungssoftware)
.Include(c => c.Konto)
.First(i => i.Id == id);
if (computer == null)
{
return(HttpNotFound());
}
var viewModel = new ComputerFormViewModel()
{
Computer = computer,
Arbeitsspeichers = _context.Arbeitsspeichers.ToList(),
Mauese = _context.Maeuse.ToList(),
Prozessoren = _context.Prozessoren.ToList(),
Tastaturen = _context.Tastaturen.ToList(),
Betriebssysteme = _context.Betriebssysteme.ToList()
};
var allFestplattenList = _context.Festplatten.ToList();
viewModel.Festplatten = allFestplattenList.Select(c => new SelectListItem
{
Text = c.Hersteller + " " + c.Produktbezeichnung,
Value = c.Id.ToString()
});
var allMonitorenList = _context.Monitore.ToList();
viewModel.Monitore = allMonitorenList.Select(c => new SelectListItem
{
Text = c.Hersteller + " " + c.Produktbezeichnung,
Value = c.Id.ToString()
});
var allAnwendungsSoftwareList = _context.Anwendungssoftwares.ToList();
viewModel.Anwendungssoftware = allAnwendungsSoftwareList.Select(c => new SelectListItem
{
Text = c.Hersteller + " " + c.Bezeichnung,
Value = c.Id.ToString()
});
var allUnterstuetzungsSoftwareList = _context.Unterstuetzungssoftwares.ToList();
viewModel.Unterstuetzungssoftware = allUnterstuetzungsSoftwareList.Select(c => new SelectListItem
{
Text = c.Hersteller + " " + c.Bezeichnung,
Value = c.Id.ToString()
});
return(View("ComputerForm", viewModel));
}
public ActionResult Save(ComputerFormViewModel editedViewModel)
{
if (!ModelState.IsValid)
{
var viewModel = new ComputerFormViewModel()
{
Computer = editedViewModel.Computer,
Arbeitsspeichers = _context.Arbeitsspeichers.ToList(),
Mauese = _context.Maeuse.ToList(),
Prozessoren = _context.Prozessoren.ToList(),
Tastaturen = _context.Tastaturen.ToList(),
Betriebssysteme = _context.Betriebssysteme.ToList()
};
var allFestplattenList = _context.Festplatten.ToList();
viewModel.Festplatten = allFestplattenList.Select(c => new SelectListItem
{
Text = c.Hersteller,
Value = c.Id.ToString()
});
var allMonitorenList = _context.Monitore.ToList();
viewModel.Monitore = allMonitorenList.Select(c => new SelectListItem
{
Text = c.Hersteller,
Value = c.Id.ToString()
});
return(View("ComputerForm", viewModel));
}
if (editedViewModel.Computer.Id == 0)
{
editedViewModel.Computer.Festplatten = GetFestplattenFromIDs(editedViewModel.SelectedFestplatten);
editedViewModel.Computer.Monitore = GetMonitoreFromIDs(editedViewModel.SelectedMonitore);
editedViewModel.Computer.Anwendungssoftware =
GetAnwendungssoftwareFromIDs(editedViewModel.SelectedAnwendungsSoftware);
editedViewModel.Computer.Unterstuetzungssoftware =
GetUnterstuetzungsSoftwareFromIDs(editedViewModel.SelectedUnterstuetzungsSoftware);
editedViewModel.Computer.Id = GetNewComputerId(_context.Computers.ToList());
editedViewModel.Computer.KontoId = computerKontoNr;
_context.Computers.Add(editedViewModel.Computer);
}
else
{
var computerInDb = _context.Computers.Single(c => c.Id == editedViewModel.Computer.Id);
computerInDb.Hersteller = editedViewModel.Computer.Hersteller;
computerInDb.MacAdresse = editedViewModel.Computer.MacAdresse;
computerInDb.Einkaufspreis = editedViewModel.Computer.Einkaufspreis;
computerInDb.Einkaufsdatum = editedViewModel.Computer.Einkaufsdatum;
computerInDb.ArbeitsspeicherId = editedViewModel.Computer.ArbeitsspeicherId;
computerInDb.MausId = editedViewModel.Computer.MausId;
computerInDb.ProzessorId = editedViewModel.Computer.ProzessorId;
computerInDb.TastaturId = editedViewModel.Computer.TastaturId;
computerInDb.KontoId = computerKontoNr;
if (computerInDb.FestplattenIds != editedViewModel.SelectedFestplatten)
{
computerInDb.Festplatten = GetFestplattenFromIDs(editedViewModel.SelectedFestplatten);
}
if (computerInDb.MonitorenIds != editedViewModel.SelectedMonitore)
{
computerInDb.Monitore = GetMonitoreFromIDs(editedViewModel.SelectedMonitore);
}
}
_context.SaveChanges();
return(RedirectToAction("Index", "Computer"));
}
