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);
}
