public JsonResult Action(AccomodationPackagesActionModel model)
{
JsonResult json = new JsonResult();
var result = false;
if (model.ID > 0)
{
var accomodationPackage = accomodationPackagesService.GetAllAccomodationPackageByID(model.ID);
accomodationPackage.Name = model.Name;
accomodationPackage.NoOfRoom = model.NoOfRoom;
accomodationPackage.FeePerNight = model.FeePerNight;
result = accomodationPackagesService.UpdateAccomodationPackage(accomodationPackage);
}
else
{
AccommodationPackage accomodationPackage = new AccommodationPackage();
accomodationPackage.Name = model.Name;
accomodationPackage.NoOfRoom = model.NoOfRoom;
accomodationPackage.FeePerNight = model.FeePerNight;
result = accomodationPackagesService.SaveAccomodationPackage(accomodationPackage);
}
if (result)
{
json.Data = new { Sucess = true };
}
else
{
json.Data = new { Sucess = false, Message = "Unable to perform action on Accomodation type" };
}
return(json);
}
public JsonResult Action(AccommodationPackageActionModel model)
{
JsonResult json = new JsonResult();
var result = false;
//model.PictureIDs = "90,32,22" = ["90", "32", "22"] = {90, 32, 22}
List <int> pictureIDs = !string.IsNullOrEmpty(model.PictureIDs) ? model.PictureIDs.Split(',').Select(x => int.Parse(x)).ToList() : new List <int>();
var pictures = _dashboardService.GetPicturesByIDs(pictureIDs);
// trying to edit a record
if (model.ID > 0)
{
var accommodationPackage = _accommodationPackagesService.GetAccommodationPackageById(model.ID);
accommodationPackage.AccommodationTypeID = model.AccommodationTypeID;
accommodationPackage.Name = model.Name;
accommodationPackage.NoOfRoom = model.NoOfRoom;
accommodationPackage.FeePerNight = model.FeePerNight;
accommodationPackage.AccommodationPackagePictures.Clear();
accommodationPackage.AccommodationPackagePictures.AddRange(pictures.Select(x => new AccommodationPackagePicture()
{
AccommodationPackageID = accommodationPackage.ID, PictureID = x.ID
}));
result = _accommodationPackagesService.UpdateAccommodationPackage(accommodationPackage);
}
// trying to create a record
else
{
AccommodationPackage accommodationPackage = new AccommodationPackage();
accommodationPackage.AccommodationTypeID = model.AccommodationTypeID;
accommodationPackage.Name = model.Name;
accommodationPackage.NoOfRoom = model.NoOfRoom;
accommodationPackage.FeePerNight = model.FeePerNight;
accommodationPackage.AccommodationPackagePictures = new List <AccommodationPackagePicture>();
accommodationPackage.AccommodationPackagePictures.AddRange(pictures.Select(x => new AccommodationPackagePicture()
{
PictureID = x.ID
}));
result = _accommodationPackagesService.SaveAccommodationPackage(accommodationPackage);
}
if (result)
{
json.Data = new { Success = true };
}
else
{
json.Data = new { Success = false, Message = "Unable to perform action on Accommodation Package." };
}
return(json);
}
public bool SaveAccommodationPackage(AccommodationPackage accommodationPackage)
{
var context = new PMSContext();
context.AccommodationPackages.Add(accommodationPackage);
return(context.SaveChanges() > 0);
}
public bool DeleteAccomodationPackage(AccommodationPackage accomodationPackage)
{
var context = new HMSContext();
context.Entry(accomodationPackage).State = System.Data.Entity.EntityState.Deleted;
return(context.SaveChanges() > 0);
}
public bool UpdateAccommodationPackage(AccommodationPackage accommodationPackage)
{
var context = new HMSContext();
var exitingAccommodationPackage = context.AccommodationPackages.Find(accommodationPackage.ID);
context.AccommodationPackagePictures.RemoveRange(exitingAccommodationPackage.AccommodationPackagePictures);
context.Entry(exitingAccommodationPackage).CurrentValues.SetValues(accommodationPackage);
context.AccommodationPackagePictures.AddRange(accommodationPackage.AccommodationPackagePictures);
return context.SaveChanges() > 0;
}
//delete accommodation package by id from db
public bool DeleteAccommodationPackage(AccommodationPackage accommodationPackage)
{
if (accommodationPackage.AccommodationPackagePictures != null && accommodationPackage.AccommodationPackagePictures.Count != 0)
{
DeleteAccommdationPackagePictures(accommodationPackage.Id);
}
context.Entry(accommodationPackage).State = System.Data.Entity.EntityState.Deleted;
return(context.SaveChanges() > 0);
}
public JsonResult Action(AccommodationPackageModel model)
{
var result = false;
JsonResult json = new JsonResult();
SharedServices sharedServices = new SharedServices();
List <int> pictureIDs = !string.IsNullOrEmpty(model.PictureIDs)? model.PictureIDs.Split(',').Select(x => int.Parse(x)).ToList():new List <int>();
var pictures = sharedServices.GetPictureByID(pictureIDs);
if (model.ID > 0)//for Edit
{
var accommodationPackage = AccommodationPackagesServices.Instance.GetAccommodationPackageByID(model.ID);
accommodationPackage.AccommodationTypeID = model.AccommodationTypeID;
accommodationPackage.Name = model.Name;
accommodationPackage.FeePerNight = model.FeePerNight;
accommodationPackage.NoOfRoom = model.NoOfRoom;
accommodationPackage.AccommodationPackagePictures.Clear();
accommodationPackage.AccommodationPackagePictures.AddRange(pictures.Select(x => new AccommodationPackagePicture()
{
AccommodationPackageID = model.ID, PictureID = x.ID
}));
result = AccommodationPackagesServices.Instance.UpdateAccommodationPackage(accommodationPackage);
}
else//for create
{
AccommodationPackage accommodationPackage = new AccommodationPackage();
accommodationPackage.AccommodationTypeID = model.AccommodationTypeID;
accommodationPackage.Name = model.Name;
accommodationPackage.FeePerNight = model.FeePerNight;
accommodationPackage.NoOfRoom = model.NoOfRoom;
accommodationPackage.AccommodationPackagePictures = new List <AccommodationPackagePicture>();
accommodationPackage.AccommodationPackagePictures.AddRange(pictures.Select(x => new AccommodationPackagePicture()
{
PictureID = x.ID
}));
result = AccommodationPackagesServices.Instance.SaveAccommodationPackage(accommodationPackage);
}
if (result)
{
json.Data = new { Success = true };
}
else
{
json.Data = new { success = false, Message = "Unable to add Accommodationtype" };
}
return(json);
}
public bool DeleteAccommodationPackage(AccommodationPackage accommodationPackage)
{
var context = new PMSContext();
var existingAccommodationPackage = context.AccommodationPackages.Find(accommodationPackage.ID);
context.AccommodationPackagePictures.RemoveRange(existingAccommodationPackage.AccommodationPackagePicture);
context.Entry(existingAccommodationPackage).State = System.Data.Entity.EntityState.Deleted;
return(context.SaveChanges() > 0);
}
public JsonResult Action(AccommodationPackagesActionModel formModel)
{
bool result = false;
//model.pictureIds = "22,23,24" => ["22","23","24"] => [22,23,24]
var picsIds = !string.IsNullOrEmpty(formModel.PictureIds) ? formModel.PictureIds.Split(',').Select(int.Parse).ToList() : new List <int>();
var pictures = DBServices.GetPicturesByIds(picsIds);
if (formModel.Id == 0) //create
{
AccommodationPackage ap = new AccommodationPackage();
ap.Name = formModel.Name;
ap.NoOfRoom = formModel.NoOfRoom;
ap.FeePerNight = formModel.FeePerNight;
ap.AccommodationTypeId = formModel.AccommodationTypeId;
ap.AccommodationPackagePictures = new List <AccommodationPackagePicture>();
ap.AccommodationPackagePictures.AddRange(pictures.Select(p => new AccommodationPackagePicture()
{
PictureId = p.Id
}));
result = APServices.AddAccommodationPackage(ap);
}
else //edit
{
var ap = APServices.GetAccommodationPackageById(formModel.Id);
ap.Name = formModel.Name;
ap.NoOfRoom = formModel.NoOfRoom;
ap.FeePerNight = formModel.FeePerNight;
ap.AccommodationTypeId = formModel.AccommodationTypeId;
//delete existing accommodation pics to add new one after editing
APServices.DeleteAccommdationPackagePictures(ap.Id);
// in edit : need aPId to edit it not make a new one
ap.AccommodationPackagePictures.AddRange(pictures.Select(p => new AccommodationPackagePicture()
{
AccommodationPackageId = ap.Id,
PictureId = p.Id
}));
result = APServices.UpdateAccommodationPackage(ap);
}
return(JsonDataResult.Result(result));
}
public JsonResult Delete(AccommodationPackageModel model)
{
JsonResult json = new JsonResult();
var result = false;
AccommodationPackage accommodationPackage = new AccommodationPackage();
accommodationPackage.ID = model.ID;
result = AccommodationPackagesServices.Instance.DeleteAccommodationPackage(accommodationPackage);
if (result)
{
json.Data = new { Success = true };
}
else
{
json.Data = new { success = false, Message = "Unable to add Accommodationtype" };
}
return(json);
}
//edit accommodation package in db
public bool UpdateAccommodationPackage(AccommodationPackage accomodationPackage)
{
context.Entry(accomodationPackage).State = EntityState.Modified;
return(context.SaveChanges() > 0);
}
//add accommodation package to db
public bool AddAccommodationPackage(AccommodationPackage accommodationPackage)
{
context.AccommodationPackages.Add(accommodationPackage);
return(context.SaveChanges() > 0);
}