// ---------- // Product Details Page private DetailsAnuntViewModel MapDbObjectToModelIMG(Anunt dbAnunt) { DetailsAnuntViewModel detailsAnunt = new DetailsAnuntViewModel(); if (dbAnunt != null) { detailsAnunt.ID_Anunt = dbAnunt.ID_Anunt; detailsAnunt.KM = dbAnunt.KM; detailsAnunt.AnFabricatie = dbAnunt.AnFabricatie; detailsAnunt.Descriere = dbAnunt.Descriere; detailsAnunt.DescriereScurta = dbAnunt.DescriereScurta; detailsAnunt.Pret = dbAnunt.Pret; MarcaAutoRepository marcaAutoRepository = new Repository.MarcaAutoRepository(); MarcaAutoModel marca = marcaAutoRepository.GetMarcaAutoByID(dbAnunt.ID_Marca); if (marca != null) { detailsAnunt.Marca = marca.Marca; } ModelAutoRepository modelAutoRepository = new Repository.ModelAutoRepository(); ModelAutoModel model = modelAutoRepository.GetModelAutoByID(dbAnunt.ID_Model); if (model != null) { detailsAnunt.Model = model.Model; } TipCaracteristicaRepository tipCaracteristica = new TipCaracteristicaRepository(); TipCaracteristicaModel tipCaracteristicaModel = tipCaracteristica.GetTipCaracteristicaByID(dbAnunt.ID_TipCaracteristica); if (tipCaracteristicaModel != null) { detailsAnunt.NumeTipCaracteristica = tipCaracteristicaModel.NumeTipCaracteristica; } CaracteristiciRepository caracteristicaRepo = new CaracteristiciRepository(); CaracteristiciModel caracteristicaModel = caracteristicaRepo.GetCaracteristiciModelByID(dbAnunt.ID_Caracteristica); if (caracteristicaModel != null) { detailsAnunt.NumeTipCaracteristica = caracteristicaModel.NumeTipCaracteristica; } CarImgRepository carImgRepository = new CarImgRepository(); List <CarImgModel> listaImg = carImgRepository.GetAllCarImgByAnunt(dbAnunt.ID_Anunt); if (listaImg != null) { detailsAnunt.Photos = listaImg; } return(detailsAnunt); } return(null); }
//insert CaracteristiciModel public void InsertCaracteristiciModel(CaracteristiciModel caracteristiciModel) { //generate new guid id caracteristiciModel.ID_Caracteristica = Guid.NewGuid(); //add to orm layer dbContext.Caracteristicis.InsertOnSubmit(MapModelsToDbObject(caracteristiciModel)); dbContext.SubmitChanges(); }
// GET: Admin/Edit/5 public ActionResult EditCaracteristica(Guid id) { CaracteristiciModel Model = caracteristiciRepository.GetCaracteristiciModelByID(id); AdminCaracteristiciViewModel model = new AdminCaracteristiciViewModel(); model.TipCaracteristici1 = tipCaracteristicaRepository.GetAllTipCaracteristica(); model.ID_Caracteristica = id; model.NumeCaracteristica1 = Model.NumeCaracteristica; model.ID_TipCaracteristica = Model.ID_TipCaracteristica; return(View("DashboardListaCaracteristici", model)); }
//update public void UpdateCaracteristiciModel(CaracteristiciModel caracteristiciModel) { //get existing record to update Models.DbObjects.Caracteristici existingModel = dbContext.Caracteristicis.FirstOrDefault(x => x.ID_Caracteristica == caracteristiciModel.ID_Caracteristica); if (existingModel != null) { //map updated values with keeping the orm reference existingModel.ID_Caracteristica = caracteristiciModel.ID_Caracteristica; existingModel.ID_TipCaracteristica = caracteristiciModel.ID_TipCaracteristica; existingModel.NumeCaracteristica = caracteristiciModel.NumeCaracteristica; dbContext.SubmitChanges(); } }
// map Model to ORM private Models.DbObjects.Caracteristici MapModelsToDbObject(CaracteristiciModel caracteristiciModel) { Models.DbObjects.Caracteristici dbCaracteristiciModel = new Models.DbObjects.Caracteristici(); if (dbCaracteristiciModel != null) { dbCaracteristiciModel.ID_Caracteristica = caracteristiciModel.ID_Caracteristica; dbCaracteristiciModel.ID_TipCaracteristica = caracteristiciModel.ID_TipCaracteristica; dbCaracteristiciModel.NumeCaracteristica = caracteristiciModel.NumeCaracteristica; return(dbCaracteristiciModel); } return(null); }
// map orm to model - mapper method private CaracteristiciModel MapDbObjectToModel(Models.DbObjects.Caracteristici dbCaracteristici) { CaracteristiciModel caracteristiciModel = new CaracteristiciModel(); if (dbCaracteristici != null) { caracteristiciModel.ID_Caracteristica = dbCaracteristici.ID_Caracteristica; caracteristiciModel.ID_TipCaracteristica = dbCaracteristici.ID_TipCaracteristica; caracteristiciModel.NumeCaracteristica = dbCaracteristici.NumeCaracteristica; return(caracteristiciModel); } return(null); }
//initializam repositori //intreaba proful // afisare anunt // GET: Anunt public ActionResult IndexAnunt() { List <AnuntModel> anunturi = anuntRepository.GetAllAnunt(); foreach (var anunt in anunturi) { MarcaAutoModel marcaAutoModel = marcaAutoRepository.GetMarcaAutoByID(anunt.ID_Marca); ModelAutoModel modelAutoModel = modelAutoRepository.GetModelAutoByID(anunt.ID_Model); CaracteristiciModel caracteristiciModel = caracteristiciRepository.GetCaracteristiciModelByID(anunt.ID_Caracteristica); TipCaracteristicaModel tipCaracteristicaModel = tipCaracteristicaRepository.GetTipCaracteristicaByID(anunt.ID_TipCaracteristica); //anunt.Marca3 = marcaAutoModel.Marca; anunt.Model = modelAutoModel.Model; anunt.NumeCaracteristica = caracteristiciModel.NumeCaracteristica; anunt.NumeTipCaracteristica = tipCaracteristicaModel.NumeTipCaracteristica; } return(View("IndexAnunt", anunturi)); }
//Post: Admin/SaveCaracteristica/5 public ActionResult SaveCaracteristica(AdminCaracteristiciViewModel model) { if (model.ID_Caracteristica != Guid.Empty) { CaracteristiciModel caracteristiciModel = new CaracteristiciModel(); caracteristiciModel.NumeCaracteristica = model.NumeCaracteristica1; caracteristiciModel.ID_Caracteristica = model.ID_Caracteristica; caracteristiciModel.ID_TipCaracteristica = model.ID_TipCaracteristica; caracteristiciRepository.UpdateCaracteristiciModel(caracteristiciModel); return(RedirectToAction("DashboardListaCaracteristici")); } else { CaracteristiciModel caracteristiciModel = new CaracteristiciModel(); caracteristiciModel.NumeCaracteristica = model.NumeCaracteristica1; caracteristiciModel.ID_TipCaracteristica = model.ID_TipCaracteristica; caracteristiciRepository.InsertCaracteristiciModel(caracteristiciModel); return(RedirectToAction("DashboardListaCaracteristici")); } }