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