public void MassCreateComputers()
{
var fakeComputers = new List <ComputerViewModel>();
for (int i = 1; i < 6; i++)
{
var computer = new ComputerViewModel()
{
ComputerCode = $"CCODE{i}",
ComputerName = $"ComputerName {i}",
ComputerDescription = $"ComputerDesription {i}",
ComputerTypeId = i,
DeparmentTypeId = i,
ProducerTypeId = i,
IsBusyNow = false,
Status = true
};
fakeComputers.Add(computer);
}
foreach (var computerViewModel in fakeComputers)
{
Model.Models.Computer newComputer = new Model.Models.Computer();
newComputer.UpdateComputer(computerViewModel);
_computerService.Add(newComputer);
_computerService.Save();
}
}
// GET: Computers/Details/5
// details of a computer from the last aida report
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var comp = await _db.Computers.FindAsync(id);
if (comp == null)
{
return(HttpNotFound());
}
var compModel = new ComputerViewModel
{
Id = comp.Id,
MbId = comp.MbId,
ComputerName = comp.ComputerName,
Cpu = comp.Cpu,
Ram = comp.Ram,
Hdd = comp.Hdd,
MotherBoard = comp.MotherBoard,
VideoAdapter = comp.VideoAdapter,
Monitor = comp.Monitor,
LastReportDate = comp.LastReportDate?.ToString("d MMMM HH:mm") ?? comp.UpdateDate?.ToString("d MMMM HH:mm"),
Owner = comp.Owner == null ? string.Empty : comp.Owner.FullName,
Software = comp.Software.Split(new[] { "[NEW_LINE]" }, StringSplitOptions.None)
};
return(View(compModel));
}
private bool AddUpdateComputerValidation(HttpRequestMessage request, ComputerViewModel computerVm,
out HttpResponseMessage errorResponse)
{
if (!_computerTypeService.CheckExistedId(computerVm.ComputerTypeId))
{
{
errorResponse = request.CreateErrorResponse(HttpStatusCode.BadRequest, CommonConstants.CannotFindComputerTypeId);
return(true);
}
}
if (!_deparmentTypeService.CheckExistedId(computerVm.DeparmentTypeId))
{
{
errorResponse = request.CreateErrorResponse(HttpStatusCode.BadRequest, CommonConstants.CannotFindDeparmentTypeId);
return(true);
}
}
if (!_producerTypeService.CheckExistedId(computerVm.ProducerTypeId))
{
{
errorResponse = request.CreateErrorResponse(HttpStatusCode.BadRequest, CommonConstants.CannotFindProducerTypeId);
return(true);
}
}
if (!ModelState.IsValid)
{
{
errorResponse = request.CreateErrorResponse(HttpStatusCode.BadRequest,
ModelState.Values.FirstOrDefault()?.Errors.FirstOrDefault()?.ErrorMessage);
return(true);
}
}
errorResponse = null;
return(false);
}
public MainWindow()
{
InitializeComponent();
MySQLMain.SetupMySqlConnection();
try
{
RoomViewModel = new RoomViewModel();
UserViewModel = new UserViewModel();
ComputerViewModel = new ComputerViewModel();
ComponentViewModel = new ComponentViewModel();
JournalViewModel = new JournalViewModel();
}
catch
{
MySQLMain.CloseConnection(); // сброс соединения в случае, если SQL-коннекторы не смогли закрыть соединение
MessageBox.Show("Внимание, база данных не установлена. Пожалуйста, установите ее из резервной копии");
}
finally
{
ComputerTab.DataContext = ComputerViewModel;
ComponentTab.DataContext = ComponentViewModel;
UserTab.DataContext = UserViewModel;
RoomTab.DataContext = RoomViewModel;
JournalTab.DataContext = JournalViewModel;
}
}
// GET: Computers/Create
public ActionResult Create()
{
var employeeOptions = GetEmployeeOptions();
var viewModel = new ComputerViewModel()
{
EmployeeOptions = employeeOptions
};
return(View(viewModel));
}
public IActionResult Edit(ComputerViewModel model)
{
var computer = context.Computers.FirstOrDefault(c => c.Id == model.Id);
computer.Name = model.Name;
computer.Price = model.Price;
context.Computers.Update(computer);
context.SaveChanges();
return(RedirectToAction("Index"));
}
public IActionResult Create(ComputerViewModel model)
{
var computer = new Computer
{
Name = model.Name,
Price = model.Price
};
context.Computers.Add(computer);
context.SaveChanges();
return(RedirectToAction("Index"));
}
public static ComputerResourceModel ToResourceModel(this ComputerViewModel computer)
{
return(new ComputerResourceModel()
{
Name = computer.Name,
Cpu = computer.Cpu,
Gpu = computer.Gpu,
Ram = computer.Ram,
OperatingSystem = computer.OperatingSystem,
MacAddress = computer.MacAddress
});
}
public ActionResult Edit(ComputerViewModel ComputerVM, IEnumerable <HttpPostedFileBase> files)
{
var city = db.Cities.Find(ComputerVM.CityId);
if (ModelState.IsValid)
{
var computer = db.Computers.Find(ComputerVM.Id);
var pics = computer.Ad.Pictures;
var pictures = new List <Picture>();
if (files != null && files.Count() > 0 && files.FirstOrDefault() != null)
{
foreach (var file in files)
{
string filName = Guid.NewGuid() + Path.GetFileName(file.FileName);
pictures.Add(new Picture {
PictureURL = filName, AdId = computer.AdId
});
file.SaveAs(Path.Combine(Server.MapPath("/Uploads/"), filName));
}
}
computer.Ad.AdDescribtion = ComputerVM.AdDescribtion;
computer.Ad.AdPrice = ComputerVM.AdPrice;
computer.Ad.AdTitle = ComputerVM.AdTitle;
computer.Ad.City = city;
computer.CD_Drive = ComputerVM.CD_Drive;
computer.ComputerBattery = ComputerVM.ComputerBattery;
computer.ComputerColor = ComputerVM.ComputerColor;
computer.ComputerCompany = ComputerVM.ComputerCompany;
computer.ComputerCpu = ComputerVM.ComputerCpu;
computer.ComputerOS = ComputerVM.ComputerOS;
computer.ComputerRam = ComputerVM.ComputerRam;
computer.ComputerScreenCard = ComputerVM.ComputerScreenCard;
computer.ComputerScreenSize = ComputerVM.ComputerScreenSize;
computer.ComputerStatus = ComputerVM.ComputerStatus;
computer.ComputerStorage = ComputerVM.ComputerStorage;
if (pictures.Count() > 0)
{
computer.Ad.Pictures.AddRange(pictures);
}
db.Entry(computer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("MyAds", "Ads"));
}
ViewBag.CityId = new SelectList(db.Cities, "Id", "Name", ComputerVM.CityId);
return(View(ComputerVM));
}
public IActionResult Get(string id)
{
ComputerViewModel computer = _computerService.GetComputerById(id);
if (computer != null)
{
return(Ok(computer));
}
else
{
return(NotFound());
}
}
private ComputerViewModel GetComputerById(int id)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"SELECT c.Id, c.PurchaseDate, c.DecomissionDate, c.Make, c.Model,
e.Id AS EmployeeId, e.FirstName, e.LastName
FROM Computer c
LEFT JOIN Employee e
ON c.Id = e.ComputerId
WHERE c.Id = @id";
cmd.Parameters.Add(new SqlParameter("@id", id));
var reader = cmd.ExecuteReader();
ComputerViewModel computer = null;
if (reader.Read())
{
computer = new ComputerViewModel
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
PurchaseDate = reader.GetDateTime(reader.GetOrdinal("PurchaseDate")),
Make = reader.GetString(reader.GetOrdinal("Make")),
Model = reader.GetString(reader.GetOrdinal("Model"))
};
if (!reader.IsDBNull(reader.GetOrdinal("DecomissionDate")))
{
computer.DecomissionDate = reader.GetDateTime(reader.GetOrdinal("DecomissionDate"));
}
if (!reader.IsDBNull(reader.GetOrdinal("EmployeeId")))
{
computer.EmployeeId = reader.GetInt32(reader.GetOrdinal("EmployeeId"));
Employee employee = new Employee
{
FirstName = reader.GetString(reader.GetOrdinal("FirstName")),
LastName = reader.GetString(reader.GetOrdinal("LastName")),
};
computer.Employee = employee;
}
}
reader.Close();
return(computer);
}
}
}
public ComputerViewModel ReturnModel()
{
var computerViewModel = new ComputerViewModel
{
ComputerM = _computerLoader.Computer,
UserComputers = _userComputers,
MyComputerParts = _myComputerParts,
ShopPartsPagedList = _shopPartsPagedList,
ShopPartsFilteredByPartName = _searchedComputerPart,
TextAndIconToCustomer = _feedback
};
return(computerViewModel);
}
public IActionResult Edit(int id)
{
var computer = context.Computers.FirstOrDefault(c => c.Id == id);
if (computer != null)
{
var model = new ComputerViewModel
{
Name = computer.Name,
Price = computer.Price
};
return(View(model));
}
return(NotFound());
}
public static ComputerViewModel GetComputer()
{
var computer = new ComputerViewModel()
{
Cpu = GetCpuName(),
Gpu = GetGpuName(),
Name = Environment.MachineName,
Ram = GetTotalRamInGigaBytes(),
OperatingSystem = GetWindowsName(),
MacAddress = GetMacAddress(),
Disks = GetDisks(),
ComputerUsers = ComputerUsersHelper.GetComputerUsers()
};
return(computer);
}
public static void UpdateComputer(this Model.Models.Computer computer, ComputerViewModel computerVm)
{
computer.ComputerId = computerVm.ComputerId;
computer.ComputerCode = computerVm.ComputerCode;
computer.ComputerName = computerVm.ComputerName;
computer.ComputerDescription = computerVm.ComputerDescription;
computer.ComputerTypeId = computerVm.ComputerTypeId;
computer.ProducerTypeId = computerVm.ProducerTypeId;
computer.DeparmentTypeId = computerVm.DeparmentTypeId;
computer.IsBusyNow = computerVm.IsBusyNow;
computer.CreatedDate = computerVm.CreatedDate;
computer.CreatedBy = computerVm.CreatedBy;
computer.UpdatedDate = computerVm.UpdatedDate;
computer.UpdatedBy = computerVm.UpdatedBy;
computer.MetaKeyword = computerVm.MetaKeyword;
computer.MetaDescription = computerVm.MetaDescription;
computer.Status = computerVm.Status;
}
public HttpResponseMessage Put(HttpRequestMessage request, ComputerViewModel computerVm)
{
return(CreateHttpResponse(request, () =>
{
HttpResponseMessage errorResponse;
if (AddUpdateComputerValidation(request, computerVm, out errorResponse))
{
return errorResponse;
}
var computerDb = _computerService.GetById(computerVm.ComputerId);
computerDb.UpdateComputer(computerVm);
_computerService.Update(computerDb);
_computerService.Save();
var response = request.CreateResponse(HttpStatusCode.OK);
return response;
}));
}
public ComputerViewModel GetComputerByLogin(string login)
{
Computer computer = _unitOfWork.Computers.GetByLogin(login);
if (computer == null)
{
return(null);
}
ComputerViewModel computerViewModel = _mapper.Map <Computer, ComputerViewModel>(computer);
computerViewModel.ComputerSystem = _mapper.Map <ComputerSystem, ComputerSystemViewModel>
(_unitOfWork.ComputerSystems.GetByComputerId(computer.Id));
computerViewModel.MotherBoardId = _unitOfWork.MotherBoards.GetMotherBoardByComputerId(computer.Id)?.Id;
computerViewModel.ProcessorId = _unitOfWork.Processors.GetProcessorByComputerId(computer.Id)?.Id;
computerViewModel.DiskDrivesId = _unitOfWork.DiskDrives.GetDiskDrivesByComputerId(computer.Id)?.Select(d => d.Id);
computerViewModel.PhysicalMemoriesId = _unitOfWork.PhysicalMemories.GetPhysicalMemoriesByComputerId(computer.Id)?.Select(d => d.Id);
computerViewModel.VideoCardsId = _unitOfWork.VideoCards.GetVideoCardsByComputerId(computer.Id)?.Select(d => d.Id);
computerViewModel.ProcessesId = _unitOfWork.Processes.GetProcessesByComputerId(computer.Id)?.Select(d => d.Id);
return(computerViewModel);
}
public IActionResult Register([FromBody] RegisterComputerModel registerComputerModel)
{
if (ModelState.IsValid)
{
if (_computerService.CheckUniqueLogin(registerComputerModel.Login))
{
ComputerViewModel computer = _computerService.RegisterNewComputer(registerComputerModel.Login
, registerComputerModel.Password);
return(Ok(computer));
}
else
{
return(BadRequest("Login already use"));
}
}
else
{
return(BadRequest(ModelState));
}
}
public IEnumerable <ComputerViewModel> GetAllComputers()
{
IEnumerable <Computer> computers = _unitOfWork.Computers.GetAll();
IList <ComputerViewModel> viewComputers = new List <ComputerViewModel>();
foreach (Computer computer in computers)
{
ComputerViewModel computerViewModel = _mapper.Map <Computer, ComputerViewModel>(computer);
computerViewModel.ComputerSystem = _mapper.Map <ComputerSystem, ComputerSystemViewModel>
(_unitOfWork.ComputerSystems.GetByComputerId(computer.Id));
computerViewModel.MotherBoardId = _unitOfWork.MotherBoards.GetMotherBoardByComputerId(computer.Id)?.Id;
computerViewModel.ProcessorId = _unitOfWork.Processors.GetProcessorByComputerId(computer.Id)?.Id;
computerViewModel.DiskDrivesId = _unitOfWork.DiskDrives.GetDiskDrivesByComputerId(computer.Id)?.Select(d => d.Id);
computerViewModel.PhysicalMemoriesId = _unitOfWork.PhysicalMemories.GetPhysicalMemoriesByComputerId(computer.Id)?.Select(d => d.Id);
computerViewModel.VideoCardsId = _unitOfWork.VideoCards.GetVideoCardsByComputerId(computer.Id)?.Select(d => d.Id);
computerViewModel.ProcessesId = _unitOfWork.Processes.GetProcessesByComputerId(computer.Id)?.Select(d => d.Id);
viewComputers.Add(computerViewModel);
}
return(viewComputers);
}
public HttpResponseMessage Post(HttpRequestMessage request, ComputerViewModel computerVm)
{
return(CreateHttpResponse(request, () =>
{
HttpResponseMessage errorResponse;
if (AddUpdateComputerValidation(request, computerVm, out errorResponse))
{
return errorResponse;
}
var newComputer = new Model.Models.Computer();
newComputer.UpdateComputer(computerVm);
var computer = _computerService.Add(newComputer);
_computerService.Save();
var response = request.CreateResponse(HttpStatusCode.Created, computer);
return response;
}));
}
public IActionResult CreateComputers(ComputerViewModel pvm)
{
Computer computer = new Computer {
ComputerId = pvm.ComputerId, Name = pvm.Name, Model = pvm.Model, CPU = pvm.CPU, MotherBoard = pvm.MotherBoard, GraphicsCard = pvm.GraphicsCard, HardDisk = pvm.HardDisk, Price = pvm.Price
};
if (pvm.Image != null)
{
byte[] imageData = null;
using (var binaryReader = new BinaryReader(pvm.Image.OpenReadStream()))
{
imageData = binaryReader.ReadBytes((int)pvm.Image.Length);
}
computer.Image = imageData;
}
db.Computers.Add(computer);
db.SaveChanges();
return(RedirectToAction("CatalogComputers"));
}
/// <summary>
/// Deletes Operating Computer
/// </summary>
/// <param name="cvm">ComputerViewModel</param>
/// <param name="UserId">User ID</param>
/// <param name="Username">Username</param>
/// <param name="CreatedDate">Created Date</param>
/// <returns>Delete Message string</returns>
public string DeleteOperatingComputer(ComputerViewModel cvm, long UserId, string Username, DateTime CreatedDate)
{
string errorMessage = "";
var rollbackFlag = 0;
using (SqlConnection con = new SqlConnection(TableConstant.CONNECTION_STRING))
{
using (SqlCommand cmd = new SqlCommand("dbo.usp_DeleteOperatingComputer"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@OperatingComputerId", cvm.Id);
cmd.Parameters.AddWithValue("@ComputerName", cvm.ComputerName);
cmd.Parameters.AddWithValue("@Department", cvm.Department);
cmd.Parameters.AddWithValue("@Status", cvm.Status);
cmd.Parameters.AddWithValue("@Username", Username);
cmd.Parameters.AddWithValue("@UserId", UserId);
cmd.Parameters.AddWithValue("@CreatedDate", CreatedDate);
var returnParameter = cmd.Parameters.Add("@RollBackFlag", SqlDbType.Int);
returnParameter.Direction = ParameterDirection.ReturnValue;
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
catch (SqlException ex)
{
errorMessage = ex.Message;
int errorCode = ex.ErrorCode;
}
rollbackFlag = (int)returnParameter.Value;
}
}
return(errorMessage);
}
public ActionResult Create(ComputerViewModel computer)
{
try
{
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)
{
cmd.CommandText = @"UPDATE Employee
SET ComputerId = @computerId
WHERE Id = @id";
cmd.Parameters.Add(new SqlParameter("@computerId", computer.Id));
cmd.Parameters.Add(new SqlParameter("@id", computer.EmployeeId));
cmd.ExecuteNonQuery();
}
return(RedirectToAction(nameof(Index)));
}
}
}
catch (Exception ex)
{
return(View(computer));
}
}
public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Computer computer = db.Computers.Find(id);
if (computer == null)
{
return(HttpNotFound());
}
ComputerViewModel computerViewModel = new ComputerViewModel
{
AdDescribtion = computer.Ad.AdDescribtion,
AdPrice = computer.Ad.AdPrice,
AdTitle = computer.Ad.AdTitle,
Id = computer.AdId,
CityId = computer.Ad.City.Id,
CD_Drive = computer.CD_Drive,
ComputerBattery = computer.ComputerBattery,
ComputerColor = computer.ComputerColor,
ComputerCompany = computer.ComputerCompany,
ComputerCpu = computer.ComputerCpu,
ComputerOS = computer.ComputerOS,
ComputerRam = computer.ComputerRam,
ComputerScreenCard = computer.ComputerScreenCard,
ComputerScreenSize = computer.ComputerScreenSize,
ComputerStatus = computer.ComputerStatus,
ComputerStorage = computer.ComputerStorage,
};
ViewBag.CityId = new SelectList(db.Cities, "Id", "Name", computer.Ad.City.Name);
return(View(computerViewModel));
}
public async Task <HttpResponseMessage> UpdateComputerAsync(ComputerViewModel computer)
{
return(await _client.PutAsync($"{baseUrl}/api/Computers/{computer.Id}", RequestHelper.GetStringContentFromObject(computer)));
}
public ActionResult Create(ComputerViewModel ComputerVM, IEnumerable <HttpPostedFileBase> files)
{
var uid = User.Identity.GetUserId();
var user = db.Users.Find(uid);
if (!user.Confirmed)
{
ViewBag.NotConfirmed = "Sory! wait until the confirmation, thanks!.";
ViewBag.CityId = new SelectList(db.Cities, "Id", "Name", ComputerVM.CityId);
return(View(ComputerVM));
}
if (ModelState.IsValid)
{
if (!User.IsInRole("Admin"))
{
//find user's listings and check if he advertised more than allowed size
int uLiveAdsCount = db.Ads.Where(ap => ap.UserId.Equals(uid)).Count();
////find user's subscription size
int usubsId = db.Users.Where(u => u.Id.Equals(uid)).Select(usub => usub.SubscriptionId).FirstOrDefault();
int subsSize = db.Subscriptions.Where(s => s.SubscriptionId == usubsId).Select(sz => sz.SubscripsionSize).FirstOrDefault();
if (uLiveAdsCount >= subsSize)
{
ViewBag.LimitReached = "Sory! you have reached the limit of this subscription please remove some ads or upgrade your subscription, thanks!.";
ViewBag.CityId = new SelectList(db.Cities, "Id", "Name", ComputerVM.CityId);
return(View(ComputerVM));
}
}
//if user chooses no image show him error
if (files == null || files.Count() <= 0 || files.FirstOrDefault() == null)
{
ViewBag.chooseImage = "Please choose image";
ViewBag.CityId = new SelectList(db.Cities, "Id", "Name", ComputerVM.CityId);
return(View(ComputerVM));
}
//end
var pictures = new List <Picture>();
foreach (var file in files)
{
if (file != null && file.ContentLength > 0)
{
string filName = Guid.NewGuid() + Path.GetFileName(file.FileName);
pictures.Add(new Picture {
PictureURL = filName
});
file.SaveAs(Path.Combine(Server.MapPath("/Uploads/"), filName));
}
}
var City = db.Cities.Find(ComputerVM.CityId);
Ad Ad = new Ad()
{
AdTitle = ComputerVM.AdTitle,
AdDescribtion = ComputerVM.AdDescribtion,
AdPrice = ComputerVM.AdPrice,
City = City,
Discriminator = DiscriminatorOptions.Computer,
Pictures = pictures,
UserId = User.Identity.GetUserId(),
Date = DateTime.Now.Date,
};
Computer Computer = new Computer()
{
Ad = Ad,
ComputerCompany = ComputerVM.ComputerCompany,
ComputerRam = ComputerVM.ComputerRam,
ComputerStorage = ComputerVM.ComputerStorage,
ComputerScreenSize = ComputerVM.ComputerScreenSize,
ComputerCpu = ComputerVM.ComputerCpu,
ComputerOS = ComputerVM.ComputerOS,
ComputerColor = ComputerVM.ComputerColor,
ComputerBattery = ComputerVM.ComputerBattery,
ComputerStatus = ComputerVM.ComputerStatus,
CD_Drive = ComputerVM.CD_Drive,
ComputerScreenCard = ComputerVM.ComputerScreenCard,
};
db.Computers.Add(Computer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CityId = new SelectList(db.Cities, "Id", "Name", ComputerVM.CityId);
return(View(ComputerVM));
}
private OggettoViewModel SetInfoCategoriaOggetto(OGGETTO oggetto, OggettoViewModel oggettoView)
{
// gestito cosi, perchè nel caso faccio macroricerche, recupero lo stesso i dati personalizzati
// sulla specifica sottocategoria.
// new List<int> { 14 }.IndexOf(oggetto.CategoriaID) != 1
if (oggettoView.CategoriaID == 12)
{
TelefonoViewModel viewModel = new TelefonoViewModel(oggettoView);
OGGETTO_TELEFONO model = oggetto.OGGETTO_TELEFONO.FirstOrDefault();
viewModel.modelloID = model.ID_MODELLO;
viewModel.modelloNome = model.MODELLO.NOME;
viewModel.sistemaOperativoID = model.ID_SISTEMA_OPERATIVO;
viewModel.sistemaOperativoNome = model.SISTEMA_OPERATIVO.NOME;
return(viewModel);
}
else if (oggettoView.CategoriaID == 64)
{
ConsoleViewModel viewModel = new ConsoleViewModel(oggettoView);
OGGETTO_CONSOLE model = oggetto.OGGETTO_CONSOLE.FirstOrDefault();
viewModel.piattaformaID = model.ID_PIATTAFORMA;
viewModel.piattaformaNome = model.PIATTAFORMA.NOME;
return(viewModel);
}
else if (oggettoView.CategoriaID == 13 || (oggettoView.CategoriaID >= 62 && oggettoView.CategoriaID <= 63) || oggettoView.CategoriaID == 65)
{
ModelloViewModel viewModel = new ModelloViewModel(oggettoView);
OGGETTO_TECNOLOGIA model = oggetto.OGGETTO_TECNOLOGIA.FirstOrDefault();
viewModel.modelloID = model.ID_MODELLO;
viewModel.modelloNome = model.MODELLO.NOME;
return(viewModel);
}
else if (oggettoView.CategoriaID == 14)
{
ComputerViewModel viewModel = new ComputerViewModel(oggettoView);
OGGETTO_COMPUTER model = oggetto.OGGETTO_COMPUTER.FirstOrDefault();
viewModel.modelloID = model.ID_MODELLO;
viewModel.modelloNome = model.MODELLO.NOME;
viewModel.sistemaOperativoID = model.ID_SISTEMA_OPERATIVO;
viewModel.sistemaOperativoNome = model.SISTEMA_OPERATIVO.NOME;
return(viewModel);
}
else if (oggettoView.CategoriaID == 26)
{
ModelloViewModel viewModel = new ModelloViewModel(oggettoView);
OGGETTO_ELETTRODOMESTICO model = oggetto.OGGETTO_ELETTRODOMESTICO.FirstOrDefault();
viewModel.modelloID = model.ID_MODELLO;
viewModel.modelloNome = model.MODELLO.NOME;
return(viewModel);
}
else if ((oggettoView.CategoriaID >= 28 && oggettoView.CategoriaID <= 39) || oggettoView.CategoriaID == 41)
{
/*MusicaViewModel viewModel = new MusicaViewModel(oggettoView);
* OGGETTO_MUSICA model = oggetto.OGGETTO_MUSICA.FirstOrDefault();
* viewModel.formatoID = model.FORMATO;
* viewModel.formatoNome = model.FORMATO1.NOME;
* viewModel.artistaID = model.ARTISTA;
* viewModel.artistaNome = model.ARTISTA1.NOME;
* return viewModel;*/
}
else if (oggettoView.CategoriaID == 40)
{
ModelloViewModel viewModel = new ModelloViewModel(oggettoView);
OGGETTO_STRUMENTO model = oggetto.OGGETTO_STRUMENTO.FirstOrDefault();
viewModel.modelloID = model.ID_MODELLO;
viewModel.modelloNome = model.MODELLO.NOME;
return(viewModel);
}
else if (oggettoView.CategoriaID == 45)
{
VideogamesViewModel viewModel = new VideogamesViewModel(oggettoView);
OGGETTO_VIDEOGAMES model = oggetto.OGGETTO_VIDEOGAMES.FirstOrDefault();
viewModel.piattaformaID = model.ID_PIATTAFORMA;
viewModel.piattaformaNome = model.PIATTAFORMA.NOME;
viewModel.genereID = model.ID_GENERE;
viewModel.genereNome = model.GENERE.NOME;
return(viewModel);
}
else if (oggettoView.CategoriaID >= 42 && oggettoView.CategoriaID <= 47)
{
ModelloViewModel viewModel = new ModelloViewModel(oggettoView);
OGGETTO_GIOCO model = oggetto.OGGETTO_GIOCO.FirstOrDefault();
viewModel.modelloID = model.ID_MODELLO;
viewModel.modelloNome = model.MODELLO.NOME;
return(viewModel);
}
else if (oggettoView.CategoriaID >= 50 && oggettoView.CategoriaID <= 61)
{
ModelloViewModel viewModel = new ModelloViewModel(oggettoView);
OGGETTO_SPORT model = oggetto.OGGETTO_SPORT.FirstOrDefault();
viewModel.modelloID = model.ID_MODELLO;
viewModel.modelloNome = model.MODELLO.NOME;
return(viewModel);
}
else if (oggettoView.CategoriaID >= 67 && oggettoView.CategoriaID <= 80)
{
VideoViewModel viewModel = new VideoViewModel(oggettoView);
OGGETTO_VIDEO model = oggetto.OGGETTO_VIDEO.FirstOrDefault();
viewModel.formatoID = model.ID_FORMATO;
viewModel.formatoNome = model.FORMATO.NOME;
viewModel.registaID = model.ID_REGISTA;
viewModel.registaNome = model.REGISTA.NOME;
return(viewModel);
}
else if (oggettoView.CategoriaID >= 81 && oggettoView.CategoriaID <= 85)
{
LibroViewModel viewModel = new LibroViewModel(oggettoView);
OGGETTO_LIBRO model = oggetto.OGGETTO_LIBRO.FirstOrDefault();
viewModel.autoreID = model.ID_AUTORE;
viewModel.autoreNome = model.AUTORE.NOME;
return(viewModel);
}
else if (oggettoView.CategoriaID >= 89 && oggettoView.CategoriaID <= 93)
{
VeicoloViewModel viewModel = new VeicoloViewModel(oggettoView);
OGGETTO_VEICOLO model = oggetto.OGGETTO_VEICOLO.FirstOrDefault();
viewModel.modelloID = model.ID_MODELLO;
viewModel.modelloNome = model.MODELLO.NOME;
viewModel.alimentazioneID = model.ID_ALIMENTAZIONE;
viewModel.alimentazioneNome = model.ALIMENTAZIONE.NOME;
return(viewModel);
}
else if (oggettoView.CategoriaID >= 127 && oggettoView.CategoriaID <= 170 && oggettoView.CategoriaID != 161 && oggettoView.CategoriaID != 152 && oggettoView.CategoriaID != 141 && oggettoView.CategoriaID != 127)
{
VestitoViewModel viewModel = new VestitoViewModel(oggettoView);
OGGETTO_VESTITO model = oggetto.OGGETTO_VESTITO.FirstOrDefault();
viewModel.taglia = model.TAGLIA;
return(viewModel);
}
return(oggettoView);
}
public async Task <int> InsertComputerAsync(ComputerViewModel computer)
{
var response = await _client.PostAsync($"{baseUrl}/api/Computers", RequestHelper.GetStringContentFromObject(computer));
return(JsonConvert.DeserializeObject <ComputerViewModel>(response.Content.ReadAsStringAsync().Result).Id);
}
