public bool UpdateAccomodationPackage(AccomodationPackage accomodationPackage) { var _context = new HMSContext(); _context.Entry(accomodationPackage).State = System.Data.Entity.EntityState.Modified; return(_context.SaveChanges() > 0); }
public bool DeleteAccomodationPackage(AccomodationPackage accomodationPackage) { var context = new HMSContext(); context.Entry(accomodationPackage).State = System.Data.Entity.EntityState.Deleted; return(context.SaveChanges() > 0); }
public bool SaveAccomodationPackage(AccomodationPackage accomodationPackage) { var context = new HMSContext(); context.AccomodationPackage.Add(accomodationPackage); return(context.SaveChanges() > 0); }
public IActionResult Edit(AccomodationPackageEditViewModel model) { if (!ModelState.IsValid) { AccomodationPackage accomodation = _context.AccomodationPackages.SingleOrDefault(r => r.ID == model.Id); accomodation.AccomodationTypeID = model.AccomodationTypeID; accomodation.FeePerNight = model.FeePerNight; accomodation.NoOfRoom = model.NoOfRoom; accomodation.Name = model.Name; if (model.Image == null) { if (model.ExistingPhotoPath != null) { string filePath = Path.Combine(hostingEnvironment.WebRootPath, "img", model.ExistingPhotoPath); System.IO.File.Delete(filePath); } accomodation.IMGPackage = ProcessUploadedFile(model); } AccomodationPackage updatedAccomodation = accomodationPackagesService.Update(accomodation); } return(RedirectToAction("Index")); }
public bool Save(AccomodationPackage model) { var db = new HmsContext(); db.AccomodationPackages.Add(model); return(db.SaveChanges() > 0); }
public JsonResult Action(AccomodationPackageActionModels model) { JsonResult json = new JsonResult(); var result = false; if (model.ID > 0)//Edit { var accomodationpackage = PackagesServices.GetAllAccomodationPackageById(model.ID); accomodationpackage.AccomodationTypeID = model.AccomodationTypeID; accomodationpackage.Name = model.Name; accomodationpackage.NoofRooms = model.NoofRooms; accomodationpackage.FeesperNight = model.FeesperNight; result = PackagesServices.UpdateAccomodationPackage(accomodationpackage); } else//Create { AccomodationPackage accomodationpackage = new AccomodationPackage(); accomodationpackage.AccomodationTypeID = model.AccomodationTypeID; accomodationpackage.Name = model.Name; accomodationpackage.NoofRooms = model.NoofRooms; accomodationpackage.FeesperNight = model.FeesperNight; result = PackagesServices.SaveAccomodationPackage(accomodationpackage); } if (result) { json.Data = new { success = true }; } else { json.Data = new { success = false, message = "unable to perform Accomodation packages" }; } return(json); }
public AccomodationPackage Update(AccomodationPackage roomChanges) { var room = context.AccomodationPackages.Attach(roomChanges); room.State = Microsoft.EntityFrameworkCore.EntityState.Modified; context.SaveChanges(); return(roomChanges); }
public AccomodationPackagesController() { _AccomodationPackagesService = new AccomodationPackagesService(); _AccomodationPackage = new AccomodationPackage(); _AccomodationTypeService = new AccomodationTypeService(); _Picture = new Picture(); _SharedService = new SharedService(); }
public bool UpdateAccomodationPackage(AccomodationPackage accomodationPackage) { var exitingAccomodationPackage = context.AccomodationPackages.Find(accomodationPackage.ID); //context.Entry(accomodationPackage).State = System.Data.Entity.EntityState.Modified; context.Entry(exitingAccomodationPackage).CurrentValues.SetValues(accomodationPackage); return(context.SaveChanges() > 0); }
public JsonResult Action(AccomodationPackageActionViewModel model) { JsonResult json = new JsonResult(); AccomodationPackage result = null; List <int> imgIds = !string.IsNullOrEmpty(model.ImageIDs)? (model.ImageIDs).Split(',').Select(x => int.Parse(x)).ToList():new List <int>(); //var images = imgIds.Select(x =>_repoWrapper.Images.Find(x)).ToList(); var images = _repoWrapper.Images.GetAll().Where(x => imgIds.Contains(x.ID)).ToList(); if (model.ID > 0) { AccomodationPackage accomodationPackage = _repoWrapper.AccomodationPackages.Get(model.ID); accomodationPackage.Name = model.Name; accomodationPackage.AccomodationTypeID = model.AccomodationTypeID; accomodationPackage.NoOfRooms = model.NoOfRooms; accomodationPackage.FeePerNight = model.FeePerNight; accomodationPackage.Description = model.Description; //accomodationPackage.AccomodationPackageImages.Clear(); _repoWrapper.AccomodationPackageImages.RemoveRange(accomodationPackage.AccomodationPackageImages); accomodationPackage.AccomodationPackageImages.AddRange(images.Select(x => new AccomodationPackageImage() { ImageID = x.ID })); result = _repoWrapper.AccomodationPackages.Update(accomodationPackage); _repoWrapper.AccomodationTypes.Save(); } else { AccomodationPackage accomodationPackage = new AccomodationPackage(); accomodationPackage.Name = model.Name; accomodationPackage.AccomodationTypeID = model.AccomodationTypeID; accomodationPackage.NoOfRooms = model.NoOfRooms; accomodationPackage.FeePerNight = model.FeePerNight; accomodationPackage.Description = model.Description; accomodationPackage.AccomodationPackageImages = new List <AccomodationPackageImage>(); accomodationPackage.AccomodationPackageImages.AddRange(images.Select(x => new AccomodationPackageImage() { ImageID = x.ID })); result = _repoWrapper.AccomodationPackages.Add(accomodationPackage); _repoWrapper.AccomodationPackages.Save(); } if (result != null) { json.Data = new { Success = true }; } else { json.Data = new { Success = false, Message = "Unable to save accomodation package" }; } _repoWrapper.AccomodationPackages.Save(); return(json); }
public bool SaveAccomodationPackages(AccomodationPackage accomodationPackage) { var context = new HMSContext(); context.AccomodationPackages.Add(accomodationPackage); var result = context.SaveChanges() > 0; return(result); }
public bool DeleteAccomodationPackage(AccomodationPackage accomodationPackage) { var context = new HBContext(); var exitingAccomodationPackage = context.AccomodationPackages.Find(accomodationPackage.ID); context.AccomodationPackagePictures.RemoveRange(exitingAccomodationPackage.AccomodationPackagePictures); context.Entry(exitingAccomodationPackage).State = System.Data.Entity.EntityState.Deleted; return(context.SaveChanges() > 0); }
public JsonResult Action(AccomodationPackagesActionViewModel model) { JsonResult jsonResult = new JsonResult(); var result = false; List <int> picIds = !string.IsNullOrEmpty(model.PictureIds) ? model.PictureIds.Split(',').Select(s => int.Parse(s)).ToList() : new List <int>(); var pictures = dashboardService.GetPicturesByIds(picIds); if (model.Id > 0) { var accomodationPackage = accomodationPackagesService.GetAccomodationPackageById(model.Id); accomodationPackage.Name = model.Name; accomodationPackage.NoOfRoom = model.NoOfRoom; accomodationPackage.FeePerNight = model.FeePerNight; accomodationPackage.AccomodationTypeId = model.AccomodationTypeId; accomodationPackage.AccomodationPackagePictures.Clear(); accomodationPackage.AccomodationPackagePictures.AddRange(pictures.Select(s => new AccomodationPackagePicture() { AccomodationPackageId = accomodationPackage.Id, PictureId = s.Id })); result = accomodationPackagesService.UpdateAccomodationPackage(accomodationPackage); } else { AccomodationPackage newRecord = new AccomodationPackage(); newRecord.Name = model.Name; newRecord.NoOfRoom = model.NoOfRoom; newRecord.FeePerNight = model.FeePerNight; newRecord.AccomodationTypeId = model.AccomodationTypeId; newRecord.AccomodationPackagePictures = new List <AccomodationPackagePicture>(); newRecord.AccomodationPackagePictures.AddRange(pictures.Select(s => new AccomodationPackagePicture() { PictureId = s.Id })); result = accomodationPackagesService.SaveAccomodationPackage(newRecord); } if (result) { jsonResult.Data = new { Success = true } } ; else { jsonResult.Data = new { Success = false, Message = "Unable to perform action on Accomodation Package!!!" } }; return(jsonResult); }
public JsonResult Action(AccomodationPackageActionModel model) { JsonResult json = new JsonResult(); var result = false; //model.PictureIDs = "90,67,23" = ["90", "67", "23"] = {90, 67, 23} List <int> pictureIDs = !string.IsNullOrEmpty(model.PictureIDs) ? model.PictureIDs.Split(',').Select(x => int.Parse(x)).ToList() : new List <int>(); var pictures = dashboardService.GetPicturesByIDs(pictureIDs); if (model.ID > 0) //we are trying to edit a record { var accomodationPackage = accomodationPackagesService.GetAccomodationPackageByID(model.ID); accomodationPackage.AccomodationTypeID = model.AccomodationTypeID; accomodationPackage.Name = model.Name; accomodationPackage.NoOfRoom = model.NoOfRoom; accomodationPackage.FeePerNight = model.FeePerNight; accomodationPackage.AccomodationPackagePictures.Clear(); accomodationPackage.AccomodationPackagePictures.AddRange(pictures.Select(x => new AccomodationPackagePicture() { AccomodationPackageID = accomodationPackage.ID, PictureID = x.ID })); result = accomodationPackagesService.UpdateAccomodationPackage(accomodationPackage); } else //we are trying to create a record { AccomodationPackage accomodationPackage = new AccomodationPackage(); accomodationPackage.AccomodationTypeID = model.AccomodationTypeID; accomodationPackage.Name = model.Name; accomodationPackage.NoOfRoom = model.NoOfRoom; accomodationPackage.FeePerNight = model.FeePerNight; accomodationPackage.AccomodationPackagePictures = new List <AccomodationPackagePicture>(); accomodationPackage.AccomodationPackagePictures.AddRange(pictures.Select(x => new AccomodationPackagePicture() { PictureID = x.ID })); result = accomodationPackagesService.SaveAccomodationPackage(accomodationPackage); } if (result) { json.Data = new { Success = true }; } else { json.Data = new { Success = false, Message = "Unable to perform action on Accomodation Package." }; } return(json); }
public bool UpdateAccomodationPackage(AccomodationPackage accomodationPackage) { var context = new HMSContext(); var existingAccomodationPackage = context.AccomodationPackages.Find(accomodationPackage.Id); context.AccomodationPackagePictures.RemoveRange(existingAccomodationPackage.AccomodationPackagePictures); context.Entry(existingAccomodationPackage).CurrentValues.SetValues(accomodationPackage); context.AccomodationPackagePictures.AddRange(accomodationPackage.AccomodationPackagePictures); return(context.SaveChanges() > 0); }
public bool Delete(AccomodationPackage model) { using (var db = new HmsContext()) { var data = db.AccomodationPackages.Find(model.Id); db.AccomodationPackageImages.RemoveRange(data.AccomodationPackageImages); db.Entry(data).State = System.Data.Entity.EntityState.Deleted; //db.AccomodationTypes.Remove(data); return(db.SaveChanges() > 0); } }
public bool UpdateAccomodationPackages(AccomodationPackage model) { using (var context = new HMSContext()) { var existingAccomodationPackage = context.AccomodationPackages.Find(model.ID); context.AccomodationPackagePictures.RemoveRange(existingAccomodationPackage.AccomodationPackagePictures); context.Entry(existingAccomodationPackage).CurrentValues.SetValues(model); context.AccomodationPackagePictures.AddRange(model.AccomodationPackagePictures); return(context.SaveChanges() > 0); } }
public JsonResult Action(AccomodationPackagesModels model) { JsonResult json = new JsonResult(); AccomodationPackage models = new AccomodationPackage(); List <int> picIds = !string.IsNullOrEmpty(model.PicTureIds)? model.PicTureIds.Split(',').Select(z => int.Parse(z)).ToList() : new List <int>(); var pictures = DashboardServices.Instance.GetPicBtIds(picIds); var result = false; if (model.Id > 0) { models.Id = model.Id; models.Name = model.Name; models.NoOfRooms = model.NoOfRooms; models.PerNight = model.PerNight; models.AccomodationTypeId = model.AccomodationTypeId; models.Details = model.Details; models.AccomodationPackageImages = new List <AccomodationPackageImage>(); models.AccomodationPackageImages.AddRange(pictures.Select(x => new AccomodationPackageImage() { AccomodationPackageId = models.Id, ImageId = x.Id })); result = AccomodationPackagesServices.Instance.Edit(models); } else { models.Name = model.Name; models.NoOfRooms = model.NoOfRooms; models.PerNight = model.PerNight; models.AccomodationTypeId = model.AccomodationTypeId; models.Details = model.Details; models.AccomodationPackageImages = new List <AccomodationPackageImage>(); models.AccomodationPackageImages.AddRange(pictures.Select(x => new AccomodationPackageImage() { ImageId = x.Id })); result = AccomodationPackagesServices.Instance.Save(models); } if (result) { json.Data = new { Success = true }; } else { json.Data = new { Success = false, Message = "Unable To Add Accomodation Type" }; } return(json); }
public bool Edit(AccomodationPackage model) { var db = new HmsContext(); var exist = db.AccomodationPackages.Find(model.Id); db.AccomodationPackageImages.RemoveRange(exist.AccomodationPackageImages); db.AccomodationPackageImages.AddRange(model.AccomodationPackageImages); db.Entry(exist).CurrentValues.SetValues(model); return(db.SaveChanges() > 0); }
public JsonResult Action(AccomodationPackageActionModel model) { JsonResult json = new JsonResult(); var result = false; //this part is for picture upload List <int> picturesIds = !string.IsNullOrEmpty(model.PictureIds) ?model.PictureIds.Split(',').Select(x => int.Parse(x)).ToList():new List <int>(); var pictures = dashboardService.GetPictureByIds(picturesIds); if (model.Id > 0)//editing a record { var accomodationPackage = accomodationPackageService.GetAccomodationPackageId(model.Id); accomodationPackage.Name = model.Name; accomodationPackage.NoOfRoom = model.NoOfRoom; accomodationPackage.FeePerNight = model.FeePerNight; accomodationPackage.Description = model.Description; accomodationPackage.AccomodationTypeId = model.AccomodationTypeId; result = accomodationPackageService.UpdateAccomodationPackage(accomodationPackage); //for picture edit accomodationPackage.AccomodationPackagePictures.Clear(); accomodationPackage.AccomodationPackagePictures.AddRange(pictures.Select(x => new AccomodationPackagePicture() { AccomodationPackageId = accomodationPackage.Id, PictureId = x.Id })); } else//creating a new record { AccomodationPackage accomodationPackage = new AccomodationPackage(); accomodationPackage.Name = model.Name; accomodationPackage.NoOfRoom = model.NoOfRoom; accomodationPackage.FeePerNight = model.FeePerNight; accomodationPackage.Description = model.Description; accomodationPackage.AccomodationTypeId = model.AccomodationTypeId; accomodationPackage.AccomodationPackagePictures = new List <AccomodationPackagePicture>(); accomodationPackage.AccomodationPackagePictures.AddRange(pictures.Select(x => new AccomodationPackagePicture() { PictureId = x.Id })); result = accomodationPackageService.SaveAccomodationPackage(accomodationPackage); } if (result) { json.Data = new { Success = true }; } else { json.Data = new { Success = false, Message = "Unable to perform action on Accomodation Type" }; } return(json); }
public bool DeleteAccomodationPackage(AccomodationPackage model) { var existingAccomodationPackage = db.AccomodationPackages.Find(model.Id); var existingAccomodationPackagePicturesOfThisAccomodation = db.AccomodationPackagePictures.Find(model.Id); if (existingAccomodationPackagePicturesOfThisAccomodation != null) { db.AccomodationPackagePictures.RemoveRange(existingAccomodationPackage.AccomodationPackagePictures); } db.Entry(model).State = System.Data.Entity.EntityState.Deleted; return(db.SaveChanges() > 0); }
public JsonResult Delete(AccomodationPackageActionViewModel model) { JsonResult json = new JsonResult(); AccomodationPackage accomodationPackage = _repoWrapper.AccomodationPackages.Get(model.ID); _repoWrapper.AccomodationPackages.Remove(accomodationPackage); _repoWrapper.AccomodationPackages.Save(); json.Data = new { Success = false, Message = "Accomodation packages deleted successfully" }; _repoWrapper.AccomodationPackages.Save(); return(json); }
public JsonResult Action(AccomodationPackageActionModel model) { JsonResult jsonResult = new JsonResult(); var result = false; //model.pictureIDs = "90","91","92" //return list={90,91,92} if agar empty ho to empty list return karyga List <int> pictureIDs = !string.IsNullOrEmpty(model.PictureIDs) ? model.PictureIDs.Split(',').Select(x => int.Parse(x)).ToList() : new List <int>(); var pictures = dashboardService.GetPictureByIDs(pictureIDs); if (model.ID > 0)//Edit { var accomodationPackage = accomodationPackageService.GetAccomodationPackagesByID(model.ID); accomodationPackage.AccomodationTypeID = model.AccomodationTypeID; accomodationPackage.Name = model.Name; accomodationPackage.NoOfRoom = model.NoOfRoom; accomodationPackage.FeePerNight = model.FeePerNight; accomodationPackage.AccomodationPackagePictures.Clear(); accomodationPackage.AccomodationPackagePictures.AddRange(pictures.Select(x => new AccomodationPackagePictures() { AccomodationPackageID = accomodationPackage.ID, PictureID = x.ID })); result = accomodationPackageService.UpdateAccomodationPackage(accomodationPackage); } else//Add/Create { AccomodationPackage accomodationPackage = new AccomodationPackage(); accomodationPackage.AccomodationTypeID = model.AccomodationTypeID; accomodationPackage.Name = model.Name; accomodationPackage.NoOfRoom = model.NoOfRoom; accomodationPackage.FeePerNight = model.FeePerNight; accomodationPackage.AccomodationPackagePictures = new List <AccomodationPackagePictures>(); accomodationPackage.AccomodationPackagePictures.AddRange(pictures.Select(x => new AccomodationPackagePictures() { PictureID = x.ID })); result = accomodationPackageService.SaveAccomodationPackage(accomodationPackage); } if (result) { jsonResult.Data = new { Success = true }; } else { jsonResult.Data = new { Success = false, Message = "Unable to Perform Action On Accomodation Type" }; } return(jsonResult); }
public bool UpdateAccomodationPackage(AccomodationPackage accomodationPackage) { var context = new HMSContext(); var existingAccomodationPackage = context.AccomodationPackages.Find(accomodationPackage.ID); context.AccomodationPackagePictures.RemoveRange(existingAccomodationPackage.AccomodationPackagePictures); context.Entry(existingAccomodationPackage).CurrentValues.SetValues(accomodationPackage); context.AccomodationPackagePictures.AddRange(accomodationPackage.AccomodationPackagePictures); //context.Entry(accomodationPackage).State = System.Data.Entity.EntityState.Modified; return(context.SaveChanges() > 0); }
public bool UpdateAccomodationPackage(AccomodationPackage accomodationPackage) { var context = new HMSContext(); //iskay krny Ki waaja ye hai ki context dispose horha tha q ki ham accomdationpkgid ko 2 jaga use kr rhy thy yani //2 context mai to vo dusry ma akar dispose horha tha iswaja sy ye existingAccomodationPackage ka scene kia hai //isky zareye phly accomodation find ki phr id sy phr update krdya mgr jo List hain unhen nahe var existingAccomodationPackage = context.AccomodationPackage.Find(accomodationPackage.ID); context.AccomodationPackagePictures.RemoveRange(existingAccomodationPackage.AccomodationPackagePictures); context.Entry(existingAccomodationPackage).CurrentValues.SetValues(accomodationPackage); context.AccomodationPackagePictures.AddRange(accomodationPackage.AccomodationPackagePictures); return(context.SaveChanges() > 0); }
public ActionResult Delete(AccomodationPackage models) { JsonResult json = new JsonResult(); var result = false; var accomdationTypes = AccomodationPackagesServices.Instance.GetById(models.Id); result = AccomodationPackagesServices.Instance.Delete(models); if (result) { json.Data = new { Success = true }; } else { json.Data = new { Success = false, Message = "Unable To Delete Accomodation Type" }; } return(json); }
public bool UpdateAccomodationPackage(AccomodationPackage accomodationPackage) { var existingAccomodationPackage = db.AccomodationPackages.Find(accomodationPackage.Id); var existingAccomodationPackagePicturesOfThisAccomodation = db.AccomodationPackagePictures.Find(accomodationPackage.Id); if (existingAccomodationPackagePicturesOfThisAccomodation != null) { db.AccomodationPackagePictures.RemoveRange(existingAccomodationPackage.AccomodationPackagePictures); } db.Entry(accomodationPackage).CurrentValues.SetValues(accomodationPackage); db.AccomodationPackagePictures.AddRange(accomodationPackage.AccomodationPackagePictures); return(db.SaveChanges() > 0); }
public PartialViewResult Action(int?id) { AccomodationPackagesModel model = new AccomodationPackagesModel(); if (id.HasValue) { _AccomodationPackage = _AccomodationPackagesService.GetAccomodationPackagesById(id.Value); model.ID = _AccomodationPackage.ID; model.Name = _AccomodationPackage.Name; model.NoOfRoom = _AccomodationPackage.NoOfRoom; model.AccomodationTypeID = _AccomodationPackage.AccomodationTypeID; model.FeePerNight = _AccomodationPackage.FeePerNight; model.AccomodationPackagePictures = _AccomodationPackage.AccomodationPackagePictures; } model.AccomodationType = _AccomodationTypeService.GetAllAccomodationType(); return(PartialView("_Action", model)); }
public IActionResult Create(AccomodationPackageViewModel model) { if (!ModelState.IsValid) { AccomodationPackage newAccomo = new AccomodationPackage { AccomodationTypeID = model.AccomodationTypeID, IMGPackage = ProcessUploadedFile(model), FeePerNight = model.FeePerNight, NoOfRoom = model.NoOfRoom, Name = model.Name, }; _context.AccomodationPackages.Add(newAccomo); _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View()); }
public JsonResult Action(AccomodationPackagesActionViewModel model) { JsonResult json = new JsonResult(); var result = false; if (model.Id > 0) { // edit var accomodationPackage = accomodationPackageService.GetAccomodationPackageById(model.Id); accomodationPackage.AccomodationTypeId = model.AccomodationTypeId; accomodationPackage.Name = model.Name; accomodationPackage.NoOfRoom = model.NoOfRoom; accomodationPackage.FeePerNight = model.FeePerNight; result = accomodationPackageService.UpdateAccomodationPackage(accomodationPackage); } else { // create AccomodationPackage accomodationPackage = new AccomodationPackage(); accomodationPackage.AccomodationTypeId = model.AccomodationTypeId; accomodationPackage.Name = model.Name; accomodationPackage.NoOfRoom = model.NoOfRoom; accomodationPackage.FeePerNight = model.FeePerNight; result = accomodationPackageService.SaveAccomodationPackage(accomodationPackage); } if (result) { json.Data = new { Success = true }; } else { json.Data = new { Success = false, Message = "Unable to Save" }; } return(json); }