public void AddOrderDetails(Order orderDetails)
{
using (OnlineTourismDBContext context = new OnlineTourismDBContext())
{
context.OrderDetails.Add(orderDetails);
context.SaveChanges();
}
}
//Update package types if required
public void UpdatePackageType(PackageType packageType)
{
using (OnlineTourismDBContext context = new OnlineTourismDBContext())
{
context.Entry(packageType).State = EntityState.Modified;
context.SaveChanges();
}
}
//Update Giftcardtypes
public void UpdateGiftCardType(GiftCardType giftCardType)
{
using (OnlineTourismDBContext context = new OnlineTourismDBContext())
{
context.Entry(giftCardType).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
//Add the packages types
public void AddPackageType(PackageType packageType)
{
using (OnlineTourismDBContext context = new OnlineTourismDBContext())
{
context.PackageTypes.Add(packageType);
context.SaveChanges();
}
}
//Add giftcardtyes into database
public void AddGiftCardType(GiftCardType giftCardType)
{
using (OnlineTourismDBContext context = new OnlineTourismDBContext())
{
context.GiftCardTypes.Add(giftCardType);
context.SaveChanges();
}
}
//Update itinerary details
public void UpdateItinerary(Itinerary itinerary)
{
using (OnlineTourismDBContext context = new OnlineTourismDBContext())
{
context.Entry(itinerary).State = EntityState.Modified;
context.SaveChanges();
}
}
//Adding itinerary details in database
public void AddItinerary(List <Itinerary> itineraries)
{
using (OnlineTourismDBContext context = new OnlineTourismDBContext())
{
context.Itineraries.AddRange(itineraries);
context.SaveChanges();
}
}
public Customer GetUsersByUserName(string UserName)
{
Customer users;
using (OnlineTourismDBContext context = new OnlineTourismDBContext())
{
users = context.Users.Where(id => UserName == id.MailId).SingleOrDefault();
}
return(users);
}
//Validate the login details
public Customer ValidateSignIn(Customer userDetails)
{
Customer users;
using (OnlineTourismDBContext context = new OnlineTourismDBContext())
{
users = context.Users.ToList().Where(id => userDetails.MailId == id.MailId && userDetails.Password == DecryptPassword(id.Password)).SingleOrDefault();//Check if user details are validate or not
}
return(users);
}
//Delete package
public void DeletePackage(int id)
{
using (OnlineTourismDBContext context = new OnlineTourismDBContext())
{
Package package = GetPackageById(id);
context.Packages.Attach(package);
context.Packages.Remove(package); //Removing package from database
context.SaveChanges();
}
}
//Delete package types
public void DeletePackageType(int id)
{
using (OnlineTourismDBContext context = new OnlineTourismDBContext())
{
PackageType packageType = GetPackageTypeById(id);
context.PackageTypes.Attach(packageType);
context.PackageTypes.Remove(packageType);
context.SaveChanges();
}
}
//Delete giftcardtype from database
public void DeleteGiftCardType(int giftCardTypeId)
{
using (OnlineTourismDBContext context = new OnlineTourismDBContext())
{
GiftCardType giftCardType = GetGiftCardTypeById(giftCardTypeId);
context.GiftCardTypes.Attach(giftCardType);
context.GiftCardTypes.Remove(giftCardType);
context.SaveChanges();
}
}
//Delete itinerary details
public void DeleteItinerary(int id)
{
using (OnlineTourismDBContext context = new OnlineTourismDBContext())
{
Itinerary itinerary = GetItineraryById(id);
context.Itineraries.Attach(itinerary);
context.Itineraries.Remove(itinerary); //Removing itineray details from database
context.SaveChanges();
}
}
//Search package by package name
public IEnumerable <Package> SearchPackageByName(string search, string searchBy)
{
using (OnlineTourismDBContext context = new OnlineTourismDBContext())
{
if (searchBy == "PackageName")
{
return(context.Packages.Where(name => name.PackageName.Contains(search)).ToList());
}
else
{
return(context.Packages.Include("PackageTypes").Where(type => type.PackageTypes.PackageTypeName.Contains(search)).ToList());
}
}
}
//Adding user details into database
public void AddUser(Customer user)
{
using (OnlineTourismDBContext context = new OnlineTourismDBContext())
{
SqlParameter firstName = new SqlParameter("@FirstName", user.FirstName);
SqlParameter lastName = new SqlParameter("@LastName", user.LastName);
SqlParameter mobileNumber = new SqlParameter("@MobileNumber", user.MobileNumber);
SqlParameter gender = new SqlParameter("@Gender", user.Gender);
SqlParameter dateofBirth = new SqlParameter("@DateOfBirth", user.DateOfBirth);
SqlParameter username = new SqlParameter("@Username", user.MailId);
user.Password = EncryptPassword(user.Password);
SqlParameter password = new SqlParameter("@Password", user.Password);
SqlParameter role = new SqlParameter("@Role", user.UserRole);
int result = context.Database.ExecuteSqlCommand("sp_InsertUser @FirstName,@LastName,@MobileNumber,@Gender,@DateOfBirth,@Username,@Password,@Role", firstName, lastName, mobileNumber, gender, dateofBirth, username, password, role);
}
}
