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