static void Main(string[] args)
{
Context _context = new Context();
DateTime tarih = DateTime.Now;
BookingInformation bookinginf = new BookingInformation();
bookinginf.Arrivaldate = tarih;
bookinginf.DepartureDate = tarih.AddDays(+1);
bookinginf.InsertDateTime = tarih;
bookinginf.UpdateDateTime = tarih;
bookinginf.AllPersonTotal = 10;
GuestInformation guestinf = new GuestInformation();
guestinf.GuestName = "Lemmy";
guestinf.GuestSurName = "Kilmester";
guestinf.GuestPhone = "5312232322";
guestinf.InsertDateTime = tarih;
guestinf.UpdateDateTime = tarih;
guestinf.GuestBirthDay = tarih;
Payments pay = new Payments();
pay.InsertDateTime = tarih;
pay.UpdateDateTime = tarih;
pay.DailyGuestFee = 44.58;
pay.TotalPrice = 60.88;
_context.BookingInformation.Add(bookinginf);
_context.GuestInformation.Add(guestinf);
_context.Payments.Add(pay);
_context.SaveChanges();
//Console.WriteLine("***************");
//Console.WriteLine("Kayıt Girildi!");
//Console.WriteLine("***************");
//var bknfgd = _context.BookingInformation.Include(g => g.GuestInformation).Include(p => p.Payments);
//foreach (var item in bknfgd)
//{
// foreach (var item2 in item.GuestInformation)
// {
// item2.GuestName;
// }
//}
//var bookings = _context.BookingInformation
// .Include(i => i.GuestInformation)
// .Include(i => i.Payments)
// .Select(i => new
// {
// i.BookingId,
// i.Arrivaldate,
// i.DepartureDate,
// i.RoomNo,
// i.AllPersonTotal,
// i.GuestInformation,
// i.Payments
// });
var BookingsAll = (from Booking in _context.BookingInformation
join Guest in _context.GuestInformation
on Booking.BookingId equals Guest.BookingId
join Payment in _context.Payments
on Booking.BookingId equals Payment.BookingId
select new
{
ID = Booking.BookingId,
ArrivalDates = Booking.Arrivaldate,
DepartureDates = Booking.DepartureDate,
BookingInsertDate = Booking.InsertDateTime,
BookingUpdateDate = Booking.UpdateDateTime,
GuestTotal = Booking.AllPersonTotal,
GuestNames = Guest.GuestName,
GuestSurNames = Guest.GuestSurName,
GuestInsertDate = Guest.InsertDateTime,
GuestUpdateDate = Guest.UpdateDateTime,
DailyGuestFees = Payment.DailyGuestFee,
TotalFee = Payment.TotalPrice
}).ToList();
foreach (var BookingsAllItem in BookingsAll)
{
Console.WriteLine("Misafir Numarası={0} Misafir Adı={1} Tutar={2}", BookingsAllItem.ID, BookingsAllItem.GuestNames, BookingsAllItem.TotalFee);
}
//var BookingsAll1 = _context.BookingInformation
// .Include(i => i.GuestInformation)
// .Include(i => i.Payments)
// .ToList();
//int id = 0;
//string name = "";
//double price = 0;
//foreach (var BookingsAllItem in BookingsAll1)
//{
// id = BookingsAllItem.BookingId;
// foreach (var guest in BookingsAllItem.GuestInformation)
// {
// name = guest.GuestName;
// }
// foreach (var payment in BookingsAllItem.Payments)
// {
// price = payment.TotalPrice;
// }
//}
//Console.WriteLine("Misafir Numarası={0} Misafir Adı={1} Tutar={2}", id, name, price);
//var guests = con.GuestInformation.ToList();
//foreach (var guest in guests)
//{
// Console.WriteLine("Misafir No={0} | Misafir Adı={1} | Misafir Soyadı={2}",guest.Id,guest.GuestName,guest.GuestSureName);
//}
//Console.WriteLine(" ");
//Console.WriteLine("-----------------------------------");
//Console.WriteLine(" ");
//var guest1 = con.GuestInformation.Find(4);
//Console.WriteLine("Misaifir No:{0} | Misafir Adı:{1}",guest1.Id,guest1.GuestName);
//if (guest1!=null)
//{
// con.GuestInformation.Remove(guest1);
//}
//con.SaveChanges();
//Console.WriteLine(" ");
//Console.WriteLine("Misafir Bilgisi Silindi!");
//Console.WriteLine(" ");
//foreach (var guest in con.GuestInformation)
//{
// Console.WriteLine("Misafir No={0} | Misafir Adı={1} | Misafir Soyadı={2}", guest.Id, guest.GuestName, guest.GuestSureName);
//}
//var guest = con.GuestInformation.Find();
//var pay = con.Payments.ToList();
//foreach (var payment in pay)
//{
// Console.WriteLine("Fiyat No: {0} Günlük Fiyat:{1}", payment.Id, payment.DailyPersonPrice);
//}
//Console.WriteLine("-----------------------------------");
//foreach (var payment in pay)
//{
// payment.DailyPersonPrice *= 1.25;
// Console.WriteLine("Fiyat No: {0} Günlük Fiyat:{1}",payment.Id,payment.DailyPersonPrice);
//}
//con.SaveChanges();
//var payment = con.Payments.Find(2);
//Console.WriteLine("Ödeme No: {2} Günlük Kişi Başı:{0} Toplam:{1}", payment.DailyPersonPrice, payment.TotalPrice, payment.Id);
//payment.DailyPersonPrice /= 2;
//payment.TotalPrice= payment.TotalPrice+(payment.TotalPrice * 1.5);
//Console.WriteLine("Ödeme No: {2} Günlük Kişi Başı:{0} Toplam:{1}", payment.DailyPersonPrice, payment.TotalPrice, payment.Id);
//con.SaveChanges();
//var guest1 = con.GuestInformation.Find(2);
//Console.WriteLine("Misafir No:{0} Misafir Adı:{1} Misafir Soyadı:{2}",guest1.Id,guest1.GuestName,guest1.GuestSureName);
//guest1.GuestName = "Şerafettin";
//guest1.GuestSureName = "Şahin";
//Console.WriteLine("Misafir No:{0} Misafir Adı:{1} Misafir Soyadı:{2}", guest1.Id, guest1.GuestName, guest1.GuestSureName);
//con.SaveChanges();
//var guests = con.GuestInformation.ToList();
//foreach (var guest in guests)
//{
// Console.WriteLine("Guest Id:{0} Guest Name:{1}", guest.Id, guest.GuestName );
//}
//var bookings = con.BookingInformation.ToList();
//foreach (var booking in bookings)
//{
// Console.WriteLine("Booking Id:{0}",booking.Id);
//}
//var payments = con.Payments.ToList();
//foreach (var payment in payments)
//{
// Console.WriteLine("Payment Id:{0}",payment.Id);
//}
//DateTime tarih = DateTime.Now;
//List<BookingInformation> bookings = new List<BookingInformation>()
//{
// new BookingInformation() {PersonQuantity=1,SumDays=1,AllPersonTotal=1,Arrivaldate=tarih,DepartureDate=tarih,InsertDateTime=tarih,UpdateDateTime=tarih},
// //new BookingInformation() {PersonQuantity=1,SumDays=1,AllPersonTotal=1},
// //new BookingInformation() {PersonQuantity=3,SumDays=1,AllPersonTotal=3},
// //new BookingInformation() {PersonQuantity=4,SumDays=1,AllPersonTotal=4}
//};
//foreach (var bookingslist in bookings)
//{
// context.BookingInformation.Add(bookingslist);
//}
//List<Payments> payment = new List<Payments>()
//{
// new Payments() {DailyPersonPrice=0, TotalPrice=0,InsertDateTime=tarih,UpdateDateTime=tarih},
// //new Payments() {DailyPersonPrice=200.0000,TotalPrice=200.0000},
// //new Payments() {DailyPersonPrice=300.0000,TotalPrice=300.0000},
// //new Payments() {DailyPersonPrice=150.0000,TotalPrice=150.0000}
//};
//foreach (var paymentslist in payment)
//{
// context.Payments.Add(paymentslist);
//}
//List<GuestInformation> guests = new List<GuestInformation>()
//{
// new GuestInformation() {GuestName="Mehmet",GuestSureName="Ak",InsertDateTime=tarih,UpdateDateTime=tarih,GuestBirthDay=tarih},
// //new GuestInformation() {GuestName="Mehmet",GuestSureName="Ay"},
// //new GuestInformation() {GuestName="Ayşe",GuestSureName="YOK"},
// //new GuestInformation() {GuestName="Nebile",GuestSureName="Yim"}
//};
//foreach (var guestslist in guests)
//{
// context.GuestInformation.Add(guestslist);
//}
//context.SaveChanges();
//Console.WriteLine("-----------------------------------");
//Console.WriteLine("Ekleme Yapıldı!");
//Console.WriteLine("-----------------------------------");
//var guestss = context.GuestInformation.ToList();
//foreach (var guest in guestss)
//{
// Console.WriteLine("Guest Id:{0} Guest Name:{1}", guest.GuestId, guest.GuestName);
//}
//var bookingss = context.BookingInformation.ToList();
//foreach (var booking in bookingss)
//{
// Console.WriteLine("Booking Id:{0}", booking.BookingId);
//}
//var payments = context.Payments.ToList();
//foreach (var paymentt in payments)
//{
// Console.WriteLine("Payment Id:{0}", paymentt.PaymentId);
//}
Console.ReadLine();
}
public ActionResult Edit(BookingInformation booking, GuestInformation guest, Payments payment)
{
if (booking == null || guest == null || payment == null)
{
return(new HttpNotFoundResult());
}
var updateBooking = db.BookingInformation.FirstOrDefault(i => i.BookingId == booking.BookingId);
updateBooking.UpdateDateTime = DateTime.Now;
updateBooking.Arrivaldate = booking.Arrivaldate;
updateBooking.DepartureDate = booking.DepartureDate;
updateBooking.Status = booking.Status;
updateBooking.AccommodationType = booking.AccommodationType;
updateBooking.AllPersonTotal = booking.AllPersonTotal;
updateBooking.BoardType = booking.BoardType;
updateBooking.Breakfast = booking.Breakfast;
updateBooking.ChildTotal = booking.ChildTotal;
updateBooking.ChildWithFeeTotal = booking.ChildWithFeeTotal;
updateBooking.Dinner = booking.Dinner;
updateBooking.Lunch = booking.Lunch;
updateBooking.PersonQuantity = booking.PersonQuantity;
updateBooking.RoomNo = booking.RoomNo;
updateBooking.SumDays = booking.SumDays;
var updateGuest = db.GuestInformation.FirstOrDefault(i => i.BookingId == guest.BookingId);
updateGuest.UpdateDateTime = DateTime.Now;
updateGuest.GuestAddress = guest.GuestAddress;
updateGuest.GuestBirthDay = guest.GuestBirthDay;
updateGuest.GuestCarPlate = guest.GuestCarPlate;
updateGuest.GuestCity = guest.GuestCity;
updateGuest.GuestCountry = guest.GuestCountry;
updateGuest.GuestDistrict = guest.GuestDistrict;
updateGuest.GuestEmail = guest.GuestEmail;
updateGuest.GuestFatherName = guest.GuestFatherName;
updateGuest.GuestGender = guest.GuestGender;
updateGuest.GuestIdentNumber = guest.GuestIdentNumber;
updateGuest.GuestIdentSerialNo = guest.GuestIdentSerialNo;
updateGuest.GuestIdentType = guest.GuestIdentType;
updateGuest.GuestMartialStatus = guest.GuestMartialStatus;
updateGuest.GuestMotherName = guest.GuestMotherName;
updateGuest.GuestName = guest.GuestName;
updateGuest.GuestPhone = guest.GuestPhone;
updateGuest.GuestRezervationNote = guest.GuestRezervationNote;
updateGuest.GuestSurName = guest.GuestSurName;
var updatePayment = db.Payments.FirstOrDefault(i => i.BookingId == payment.BookingId);
updatePayment.UpdateDateTime = DateTime.Now;
updatePayment.TotalPrice = payment.TotalPrice;
updatePayment.BreakfastPrice = payment.BreakfastPrice;
updatePayment.ChildFee = payment.ChildFee;
updatePayment.ChildFeeTotal = payment.ChildFeeTotal;
updatePayment.DailyGuestFee = payment.DailyGuestFee;
updatePayment.DailyPersonPrice = payment.DailyPersonPrice;
updatePayment.DinnerPrice = payment.DinnerPrice;
updatePayment.DiscountPrice = payment.DiscountPrice;
updatePayment.Extrasprice = payment.Extrasprice;
updatePayment.LunchPrice = payment.LunchPrice;
updatePayment.RoomPrice = payment.RoomPrice;
updatePayment.TotalAccommodationFee = payment.TotalAccommodationFee;
updatePayment.TotalBreakFastFee = payment.TotalBreakFastFee;
updatePayment.TotalDinnerFee = payment.TotalDinnerFee;
updatePayment.TotalLunchFee = payment.TotalLunchFee;
updatePayment.TotalRoomFee = payment.TotalRoomFee;
updatePayment.Totaldayspersonfee = payment.Totaldayspersonfee;
db.SaveChanges();
return(Redirect("Index"));
}
