public AddUpdateResponseModel AddCustomer(Customer customer) { Customer appcustomer = _context.Customers.FirstOrDefault(x => x.FIN == customer.FIN); if (appcustomer == null) { if (_context.Customers.Any(x => x.FIN != customer.FIN && x.Email == customer.Email)) { return(new AddUpdateResponseModel { Message = "Email Already Exist", Status = false }); } else if (_context.Customers.Any(x => x.FIN != customer.FIN && x.PhoneNumber == customer.PhoneNumber)) { return(new AddUpdateResponseModel { Message = "Phonenumber Already Exist", Status = false }); } _context.Customers.Add(customer); _context.SaveChanges(); return(new AddUpdateResponseModel { Message = "ok", Status = true }); } return(new AddUpdateResponseModel { Message = "FIN Already Exist", Status = false }); }
public IHttpActionResult PutCustomer(int id, Customer customer) { if (id != customer.Id) { return(BadRequest()); } db.Entry(customer).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!CustomerExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public AddUpdateResponseModel AddUser(AppUsers user) { AppUsers appUser = _context.AppUsers.FirstOrDefault(x => x.FIN == user.FIN); if (appUser == null) { if (_context.AppUsers.Any(x => x.FIN != user.FIN && x.Email == user.Email)) { return(new AddUpdateResponseModel { Message = "Email Already Exist", Status = false }); } else if (_context.AppUsers.Any(x => x.FIN != user.FIN && x.PhoneNumber == user.PhoneNumber)) { return(new AddUpdateResponseModel { Message = "Phonenumber Already Exist", Status = false }); } user.Password = user.Password.HashPassword(); _context.AppUsers.Add(user); _context.SaveChanges(); return(new AddUpdateResponseModel { Message = "ok", Status = true }); } return(new AddUpdateResponseModel { Message = "FIN Already Exist", Status = false }); }
public ActionResult Create([Bind(Include = "nombre_Hotel,descripcion_Hotel,sobreNosotros_Hotel,latitud_Hotel,longitud_Hotel,comoLlegar_Hotel,telefono_Hotel,aptoPostal_Hotel,email_Hotel")] Hotel hotel) { if (ModelState.IsValid) { db.Hotel.Add(hotel); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hotel)); }
public void AddReservation(Reservation model, string FIN) { if (model != null) { model.CustomerId = _context.Customers.FirstOrDefault(c => c.FIN == FIN).Id; Room room = _context.Rooms.Find(model.RoomId); room.RoomStatusId = 1; _context.Reservations.Add(model); _context.SaveChanges(); } }
private void btn_addHotel_Click(object sender, RoutedEventArgs e) { try { byte[] img = null; FileStream fs = new FileStream(imgLocation, FileMode.Open, FileAccess.Read); BinaryReader br = new BinaryReader(fs); img = br.ReadBytes((int)fs.Length); using (HotelDB db = new HotelDB()) { Hotels hotel = new Hotels(); hotel.Name = txt_Name.Text; hotel.Address = txt_Address.Text; hotel.Description = txt_Description.Text; hotel.Stars = Convert.ToInt32(txt_Stars.Text); hotel.RoomsCount = Convert.ToInt32(txt_RoomsCount.Text); hotel.Photo = img; db.Hotels.Add(hotel); db.SaveChanges(); } this.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public ActionResult Reservation(RoomInfo rooms) { if (Session["UserID"] == null) { return(RedirectToAction("Login", "Account")); } var room = db.ROOMS.Where(m => m.CATEGORY == rooms.catRoom && m.PLACES == rooms.placeRoom).First(); if (room == null) { ViewBag.Error = "В данный момент нет свободных номеров по Вашему запросу."; return(View()); } List <RESERVATION> addRoom = new List <RESERVATION>(); int id = Int32.Parse(Session["UserID"].ToString()); addRoom.Add(new RESERVATION() { ID_CLIENT = id, ID_ROOM = room.ID_ROOM, DATE_IN = rooms.dateinRoom, DATE_OUT = rooms.dateoutRoom }); foreach (var i in addRoom) { db.RESERVATION.Add(i); } db.SaveChanges(); ViewBag.SuccessReserv = "Вы успешно забронировали номер."; RedirectToAction("Profile", "Account"); return(View()); }
private void btn_addRoom_Click(object sender, RoutedEventArgs e) { int allRoomCount = hotel.RoomsCount; if (db.Rooms.ToList().Where(x => x.HotelsID == hotel.Id).Count() < allRoomCount) { room = new Rooms(); room.Number = Convert.ToInt32(txt_Number.Text); room.Price = Convert.ToDecimal(txt_Price.Text); room.Count = Convert.ToInt32(txt_Count.Text); room.RoomTypesID = Convert.ToInt32(cbx_RoomTypes.SelectedValue); room.HotelsID = hotel.Id; db.Rooms.Add(room); db.SaveChanges(); listRooms.ItemsSource = db.Rooms.Where(x => x.HotelsID == hotel.Id).Select(r => new { Number = r.Number, Count = r.Count, Price = r.Price, RoomTypesName = r.RoomTypes.Title }).ToList(); } else { string message = string.Format("Ви не можете додати кімнату до даного готелю! ( Максимальний ліміт {0} кімнат(и) )", allRoomCount); MessageBox.Show(message); } }
private void btn_payment_Click(object sender, RoutedEventArgs e) { int orderID = Convert.ToInt32(listOrders.SelectedValue); order = db.OrdersToReservations.FirstOrDefault(x => x.Id == orderID); order.IsPayment = true; db.SaveChanges(); GetListOrder(); }
private void btn_freeRoom_Click(object sender, RoutedEventArgs e) { int roomID = Convert.ToInt32(listRooms.SelectedValue); room = (Rooms)db.Rooms.FirstOrDefault(x => x.Id == roomID); room.IsBlocked = false; db.SaveChanges(); GetListRooms(); }
public void AddRoom(Room room) { if (room != null) { _context.Rooms.Add(room); _context.SaveChanges(); } }
public ActionResult Register(CLIENTS account) { if (ModelState.IsValid) { var acc = db.CLIENTS.SingleOrDefault(u => u.LOGIN == account.LOGIN); if (acc != null) { ModelState.AddModelError("LOGIN", "Такой логин уже занят."); return(View()); } if (account.GENDER != "Мужской" && account.GENDER != "Женский") { ModelState.AddModelError("GENDER", "Введите 'Мужской' или 'Женский'."); return(View()); } db.CLIENTS.Add(account); db.SaveChanges(); ModelState.Clear(); ViewBag.Message = account.IM + " " + account.OT + ", " + "вы успешно зарегистрировались!"; } return(View()); }
public int Save() { return(db.SaveChanges()); }
public bool Save() { return(db.SaveChanges() > 0); }