public int UploadPackageImages(HttpPostedFileBase[] files, ImageType imgtype, string packageName)
{
string uploadDirectory = ConfigurationManager.AppSettings["UploadDirectoryImages"].ToString();
using (camphorizonEntities db = new camphorizonEntities())
{
var order = db.ImagesCatalogues.Where(x => x.ImageFor == (short)imgtype).Max(x => x.SlideOrder);
int lastOrder = order.HasValue ? order.Value : 0;
foreach (var img in files)
{
string uploadFileLink = UploadFile(img, uploadDirectory);
lastOrder++;
db.ImagesCatalogues.Add(new ImagesCatalogue()
{
Active = true,
ImageFor = (short)imgtype,
ImageLink = uploadFileLink,
Name = packageName + " " + lastOrder.ToString(),
SlideOrder = (short)lastOrder
});
}
return(db.SaveChanges());
}
}
public int UploadImages(ImageUploadViewModel model)
{
string uploadDirectory = ConfigurationManager.AppSettings["UploadDirectoryImages"].ToString();
using (camphorizonEntities db = new camphorizonEntities())
{
var order = db.ImagesCatalogues.Where(x => x.ImageFor == model.ImageType).Max(x => x.SlideOrder);
int lastOrder = order.HasValue ? order.Value : 0;
foreach (var img in model.Images)
{
string uploadFileLink = UploadFile(img, uploadDirectory);
lastOrder++;
db.ImagesCatalogues.Add(new ImagesCatalogue()
{
Active = model.Active,
ImageFor = model.ImageType,
ImageLink = uploadFileLink,
Name = model.Name,
OfferDetails = model.OfferDetails,
OfferHeading = model.OfferHeading,
SlideOrder = (short)lastOrder
});
}
return(db.SaveChanges());
}
}
public int CreateAmmenities(AmmenitiesViewModel model)
{
using (camphorizonEntities db = new camphorizonEntities()) {
db.Facilities.Add(new Facility()
{
Facility1 = model.Name
});
return(db.SaveChanges());
}
}
public int CreateCancellationTerm(CancellationTermViewModel model)
{
using (camphorizonEntities db = new camphorizonEntities())
{
db.CancellationTerms.Add(new CancellationTerm()
{
CancellationTerm1 = model.CancellationTerm
});
return(db.SaveChanges());
}
}
public int CreateReservationRequest(ReservationModel model)
{
using (camphorizonEntities db = new camphorizonEntities()) {
db.ReservationRequests.Add(new ReservationRequest()
{
Adults = model.Adults,
CheckInDate = model.CheckInDate,
CheckOutDate = model.CheckOutDate,
Children = model.Children,
Contact = model.Contact,
DateCreated = DateTime.UtcNow,
Email = model.Email,
ForDays = (model.CheckOutDate - model.CheckInDate).Days
});
return(db.SaveChanges());
}
}
public bool UpdateHomeConfiguration(WebPortalConfigurationsViewModel model)
{
using (camphorizonEntities db = new camphorizonEntities())
{
var config = db.ApplicationSettings.Where(x => x.Name == "Address").FirstOrDefault();
config.Value = model.Address;
db.Entry(config).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
config = db.ApplicationSettings.Where(x => x.Name == "Helpline").FirstOrDefault();
config.Value = model.Contact;
db.Entry(config).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
config = db.ApplicationSettings.Where(x => x.Name == "HelpEmail").FirstOrDefault();
config.Value = model.HelpEmail;
db.Entry(config).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
config = db.ApplicationSettings.Where(x => x.Name == "WebsiteName").FirstOrDefault();
config.Value = model.WebsiteName;
db.Entry(config).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
config = db.ApplicationSettings.Where(x => x.Name == "WelcomeText").FirstOrDefault();
config.Value = model.WelcomeText;
db.Entry(config).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
config = db.ApplicationSettings.Where(x => x.Name == "AboutText").FirstOrDefault();
config.Value = model.AboutText;
db.Entry(config).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(true);
}
}
public bool CreatePackage(PackageViewModel model, string user)
{
bool isSave = false;
using (camphorizonEntities db = new camphorizonEntities())
{
var package = new Package()
{
Active = model.Active,
CreatedBy = user,
CreatedDate = DateTime.UtcNow,
Description = model.Description,
Duration = model.Duration,
Name = model.Name,
Price = model.Price,
UpdatedBy = user,
UpdatedDate = DateTime.UtcNow
};
db.Packages.Add(package);
if (db.SaveChanges() > 0)
{
isSave = true;
}
else
{
isSave = false;
}
db.PackageInclusions.Add(new PackageInclusion()
{
CreateDate = DateTime.UtcNow,
CreatedBy = user,
Inclusions = model.Inclusions,
PackageID = package.Id,
UpdateDate = DateTime.UtcNow,
UpdatedBy = user
});
db.PackageItineraries.Add(new PackageItinerary()
{
CreateDate = DateTime.UtcNow,
CreatedBy = user,
Itinerary = model.Itinerary,
PackageID = package.Id,
UpdateDate = DateTime.UtcNow,
UpdatedBy = user
});
db.PackageExclusions.Add(new PackageExclusion()
{
CreateDate = DateTime.UtcNow,
CreatedBy = user,
Exclusions = model.Exclusions,
PackageID = package.Id,
UpdateDate = DateTime.UtcNow,
UpdatedBy = user
});
if (UploadPackageImages(model.Images, ImageType.Package, model.Name) > 0)
{
isSave = true;
}
else
{
isSave = false;
}
foreach (var ammenity in model.Ammenities)
{
if (ammenity.Checked)
{
db.PackageFacilityMappings.Add(new PackageFacilityMapping()
{
FacilityID = ammenity.Id, PackageID = package.Id
});
}
}
foreach (var ct in model.CancellationTerms)
{
if (ct.Checked)
{
db.PackageCancellationTermsMappings.Add(new PackageCancellationTermsMapping()
{
CancellationTermID = ct.Id, PackageID = package.Id
});
}
}
if (db.SaveChanges() > 0)
{
isSave = true;
}
else
{
isSave = false;
}
}
return(isSave);
}