public void DeleteComplaintByID(int complaintID)
{
using (CinemaEntities database = new CinemaEntities())
{
database.Complaint.RemoveRange(database.Complaint.Where(x => x.Complaint_ID == complaintID));
database.SaveChanges();
}
}
public void DeleteCommentByCustomer(int customerID)
{
using (CinemaEntities database = new CinemaEntities())
{
database.Comment.RemoveRange(database.Comment.Where(x => x.Customer_ID == customerID));
database.SaveChanges();
}
}
public void SetPassword(int customerID, string password)
{
using (CinemaEntities database = new CinemaEntities())
{
Customer customer = database.Customer.Single(x => x.Customer_ID == customerID);
customer.Password = password;
database.SaveChanges();
}
}
public void DeleteMovie(int MovieID)
{
using (CinemaEntities database = new CinemaEntities())
{
Movie movie = database.Movie.Single(x => x.Movie_ID == MovieID);
database.Movie.Remove(movie);
database.SaveChanges();
}
}
private void ClickMethod()
{
_ctx.Бронь.Add(new Бронь()
{
ФИО = NewName, Телефон = NewPhone, IDБилета = Tickets.Last().ID
});
_ctx.SaveChanges();
RaisePropertyChanged("Collection");
}
public void SetLogin(int customerID, string login)
{
using (CinemaEntities database = new CinemaEntities())
{
Customer customer = database.Customer.Single(x => x.Customer_ID == customerID);
customer.Login = login;
database.SaveChanges();
}
}
public void SetSurname(int customerID, string surname)
{
using (CinemaEntities database = new CinemaEntities())
{
Customer customer = database.Customer.Single(x => x.Customer_ID == customerID);
customer.Last_Name = surname;
database.SaveChanges();
}
}
public void SetPhone(int customerID, string phone)
{
using (CinemaEntities database = new CinemaEntities())
{
Customer customer = database.Customer.Single(x => x.Customer_ID == customerID);
customer.Phone = phone;
database.SaveChanges();
}
}
public void DeleteComment(int commentID)
{
using (CinemaEntities database = new CinemaEntities())
{
Comment comment = database.Comment.Single(x => x.Comment_ID == commentID);
database.Comment.Remove(comment);
database.SaveChanges();
}
}
public void SetEmail(int customerID, string email)
{
using (CinemaEntities database = new CinemaEntities())
{
Customer customer = database.Customer.Single(x => x.Customer_ID == customerID);
customer.Email = email;
database.SaveChanges();
}
}
public void UnbookTicket(int ticketID)
{
using (CinemaEntities database = new CinemaEntities())
{
Ticket ticket = database.Ticket.Where(x => x.Ticket_ID == ticketID).SingleOrDefault();
if (ticket != null)
{
database.Ticket.Remove(ticket);
database.SaveChanges();
}
}
}
public void BuyTicket(int ticketID)
{
using (CinemaEntities database = new CinemaEntities())
{
Ticket ticket = database.Ticket.Single(x => x.Ticket_ID == ticketID);
if (ticket != null)
{
ticket.Status = "Paid";
database.SaveChanges();
}
}
}
public void EditShowtime(int showtimeID, int screenID, string date, string technology)
{
using (CinemaEntities database = new CinemaEntities())
{
Showtime showtime = database.Showtime.Single(x => x.Showtime_ID == showtimeID);
showtime.Screen_ID = screenID;
showtime.Date = DateTime.Parse(date);
showtime.Technology = technology;
database.SaveChanges();
}
}
private void ToOrderCommandExecute(object obj)
{
var ticket = new Tickets
{
id_session = SelectedSession.id,
id_user = CurrentUser.id
};
_database.Tickets.Add(ticket);
_database.FreePlacesForSession.Single(p => p.id_hall == SelectedSession.id_hall && p.place_number == SelectedPlace.place_number).is_empty = false;
_database.SaveChanges();
SendReceiptByEmail(ticket);
}
private void btnBuy_Click(object sender, EventArgs e)
{
foreach (SeatButton item in SelectedSeats)
{
Ticket ticket = new Ticket()
{
SeansId = item.PosterId,
SeatId = item.SeatId
};
db.Tickets.Add(ticket);
}
db.SaveChanges();
this.Hide();
AboutForm.Show();
}
public void AddShowtime(int movieID, int screenID, string date, string technology)
{
using (CinemaEntities database = new CinemaEntities())
{
Showtime showtime = database.Showtime.Create();
showtime.Showtime_ID = Convert.ToInt32(database.sp_getSeqShowtimeID().FirstOrDefault());
showtime.Movie_ID = movieID;
showtime.Screen_ID = screenID;
showtime.Date = DateTime.Parse(date);
showtime.Technology = technology;
database.Showtime.Add(showtime);
database.SaveChanges();
}
}
public ActionResult ChangePass(string[] pass)
{
if (Session["USER_LOGIN"] != null)
{
using (CinemaEntities db = new CinemaEntities())
{
byte[] old_password = Encoding.Default.GetBytes(pass[0]);
//utworzenie skrotu od pobranego hasla (SHA_1)
using (var sha1 = SHA1.Create())
{
byte[] old_password_sha1 = sha1.ComputeHash(old_password);
string s_old_password_sha1 = Encoding.Default.GetString(old_password_sha1);
string user_login = Session["USER_LOGIN"].ToString();
if (s_old_password_sha1 == db.USERS.Where(x => x.USER_LOGIN == user_login).Select(x => x.PASSWORD).FirstOrDefault().ToString())
{
if (pass[1] == pass[2])
{
//nowe hasla sa poprawne
byte[] new_pass1 = Encoding.Default.GetBytes(pass[1]);
byte[] new_pass1_sha1 = sha1.ComputeHash(new_pass1); //skrot sha_1 w byte
string s_new_pass1_sha1 = Encoding.Default.GetString(new_pass1_sha1);
var findUser = db.USERS.Where(u => u.USER_LOGIN == user_login).FirstOrDefault();
findUser.PASSWORD = s_new_pass1_sha1;
db.Entry(findUser).State = EntityState.Modified;
db.SaveChanges();
ModelState.AddModelError("", "Hasło zmieniono poprawnie!");
}
else
{
ModelState.AddModelError("", "Podane hasła nie zgadzają się!");
}
} //podano niepoprawne stare haslo
else
{
ModelState.AddModelError("", "Podane stare hasło jest nieprawidłowe!");
}
}
return(View());
}
}
else
{
return(RedirectToAction("", "Home"));
}
}
public void EditMovie(int ID, string title, string director, string release, int genreID, int age, int duration, string description)
{
using (CinemaEntities database = new CinemaEntities())
{
Movie editMovie = database.Movie.Single(x => x.Movie_ID == ID);
editMovie.Title = title;
editMovie.Director = director;
editMovie.Age_Category = age;
editMovie.Duration = duration;
editMovie.Release_Date = DateTime.Parse(release);
editMovie.Genre_ID = genreID;
editMovie.Description = description;
database.SaveChanges();
}
}
public ActionResult DeleteConfirmed(string id)
{
if (Session["USER_LOGIN"] != null)
{
using (CinemaEntities db = new CinemaEntities())
{
USERS uSERS = db.USERS.Find(Session["USER_LOGIN"]);
if (uSERS == null)
{
return(HttpNotFound());
}
db.USERS.Remove(uSERS);
db.SaveChanges();
}
}
return(RedirectToAction("", "Home"));
}
public void AddMovie(string title, string director, string release, int genreID, int age, int duration, string description)
{
using (CinemaEntities database = new CinemaEntities())
{
Movie newMovie = database.Movie.Create();
newMovie.Movie_ID = Convert.ToInt32(database.sp_getSeqMovieID().FirstOrDefault());
newMovie.Title = title;
newMovie.Director = director;
newMovie.Age_Category = age;
newMovie.Duration = duration;
newMovie.Release_Date = DateTime.Parse(release);
newMovie.Genre_ID = genreID;
newMovie.Description = description;
database.Movie.Add(newMovie);
database.SaveChanges();
}
}
public ActionResult Edit([Bind(Include = "USER_LOGIN,PASSWORD,NAME,SURNAME,E_MAIL,TELEPHONE,LAST_LOGIN")] USERS uSERS)
{
if (uSERS.NAME != "" && uSERS.SURNAME != "" && uSERS.E_MAIL != "" && uSERS.TELEPHONE != "")
{
using (CinemaEntities db = new CinemaEntities())
{
string login = Session["USER_LOGIN"].ToString();
var findUser = db.USERS.Where(u => u.USER_LOGIN == login).FirstOrDefault();
findUser.NAME = uSERS.NAME;
findUser.SURNAME = uSERS.SURNAME;
findUser.E_MAIL = uSERS.E_MAIL;
findUser.TELEPHONE = uSERS.TELEPHONE;
db.Entry(findUser).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
}
return(View(uSERS));
}
public void CreateComplaint(int customerID, string description)
{
using (CinemaEntities database = new CinemaEntities())
{
Complaint newComplaint = database.Complaint.Create();
//obecna data
DateTime myDateTime = DateTime.Now;
//format daty poprawny do sql
string sqlFormattedDate = myDateTime.ToString("yyyy-MM-dd HH:mm");
newComplaint.Complaint_ID = Convert.ToInt32(database.sp_getSeqComplaintID().FirstOrDefault());
newComplaint.Customer_ID = customerID;
newComplaint.Description = description;
newComplaint.Date = DateTime.Parse(sqlFormattedDate);
database.Complaint.Add(newComplaint);
database.SaveChanges();
}
}
public void CreateRating(int customerID, int rating, int movieID)
{
using (CinemaEntities database = new CinemaEntities())
{
Rating newRating = database.Rating.Create();
//obecna data
DateTime myDateTime = DateTime.Now;
//format daty poprawny do sql
string sqlFormattedDate = myDateTime.ToString("yyyy-MM-dd HH:mm");
newRating.Rating_ID = Convert.ToInt32(database.sp_getSeqRatingID().FirstOrDefault());
newRating.Customer_ID = customerID;
newRating.Movie_ID = movieID;
newRating.Stars = rating;
newRating.Date = DateTime.Parse(sqlFormattedDate);
database.Rating.Add(newRating);
database.SaveChanges();
}
}
public void OrderingTicket(int showtimeID, int customerID, int seatID, int ticketTypeID, string status)
{
using (CinemaEntities database = new CinemaEntities())
{
Ticket newTicket = database.Ticket.Create();
//obecna data
DateTime myDateTime = DateTime.Now;
//format daty poprawny do sql
string sqlFormattedDate = myDateTime.ToString("yyyy-MM-dd HH:mm");
newTicket.Ticket_ID = Convert.ToInt32(database.sp_getSeqTicketID().FirstOrDefault());
newTicket.Customer_ID = customerID;
newTicket.Showtime_ID = showtimeID;
newTicket.Seat_ID = seatID;
newTicket.Ticket_Type_ID = ticketTypeID;
newTicket.Status = status;
newTicket.Date = DateTime.Parse(sqlFormattedDate);
database.Ticket.Add(newTicket);
database.SaveChanges();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
Sean sean = new Sean()
{
FilmId = (int)cmbFilms.SelectedValue,
HallId = (byte)cmbHalls.SelectedValue,
Date = dtpDate.Value.Date,
Time = dtpTime.Value.TimeOfDay,
Price = Convert.ToDecimal(txtPrice.Text)
};
db.Seans.Add(sean);
db.SaveChanges();
this.Hide();
MainForm.Show();
}
catch (Exception d)
{
MessageBox.Show(d.Message);
this.Hide();
MainForm.Show();
}
}
public ActionResult Register(USERS account)
{
if (ModelState.IsValid)
{
using (CinemaEntities db = new CinemaEntities())
{
byte[] client_password = Encoding.Default.GetBytes(account.PASSWORD); //pobrana wartosc z pola login_textBox w byte
//utworzenie skrotu od pobranego hasla (SHA_1)
using (var sha1 = SHA1.Create())
{
byte[] client_password_sha1 = sha1.ComputeHash(client_password); //Convert the input byte to a byte array and compute the hash.
string s_client_password_sha1 = Encoding.Default.GetString(client_password_sha1);
var number_of_clients = db.USERS.Where(a => a.USER_LOGIN == account.USER_LOGIN);
//if (number_of_admins.Count() != 0)
if (number_of_clients.Count() != 0)
{
ModelState.AddModelError("", "Podany login jest zajęty!");
}
else
{
account.PASSWORD = s_client_password_sha1;
db.USERS.Add(account);
db.SaveChanges(); //zapis do bazy danych
ModelState.Clear();
ViewBag.Message = "Pomyślnie utworzono konto dla użytkownika: " + account.USER_LOGIN;
}
}
}
}
return(View());
}
public void DeleteCustomer(int customerID)
{
using (CinemaEntities database = new CinemaEntities())
{
// before delete customer
// must delete all records with his foreign key
CommentService commentService = new CommentService();
ComplaintService complaintService = new ComplaintService();
TicketService ticketService = new TicketService();
RatingsService ratingsService = new RatingsService();
commentService.DeleteCommentByCustomer(customerID);
complaintService.DeleteComplaintByCustomer(customerID);
ticketService.DeleteTicketByCustomer(customerID);
ratingsService.DeleteRatingByCustomer(customerID);
// now delete customer
Customer customer = database.Customer.Single(x => x.Customer_ID == customerID);
database.Customer.Remove(customer);
database.SaveChanges();
}
}
//Method that submits the order
public UserOrderDTO CreateOrder(UserOrderDTO NewOrder)
{
UserOrderDTO OrderOut = new UserOrderDTO();
Order OrderIn = new Order();
using (TransactionScope Trans = new TransactionScope())
{
try
{
using (var context = new CinemaEntities())
{
OrderIn.NumberOfSeatsReserved = NewOrder.NumberOfSeats;
OrderIn.TotalPrice = NewOrder.TotalPrice;
OrderIn.UserID = NewOrder.UserID;
OrderIn.PerfomanceID = NewOrder.PerformanceID;
if (OrderIn.EntityState == EntityState.Detached)
{
context.Orders.AddObject(OrderIn);
}
context.SaveChanges();
OrderOut.OrderID = OrderIn.OrderID;
}
}
catch
{
OrderOut.isValid = false;
Trans.Dispose();
return(OrderOut);
}
OrderOut.isValid = true;
Trans.Complete();
return(OrderOut);
}
}
private void SignUpCommandExecute(object obj)
{
PasswordBox pb = obj as PasswordBox;
if (_generatedSmsCode.ToString() == SmsCode)
{
_database.Users.Add(new Users {
phone_number = PhoneNumber, email = Email, password = pb.Password
});
UserWindow.UserWindowClass wnd = new UserWindow.UserWindowClass();
wnd.Show();
_database.SaveChanges();
Messenger.Default.Send(PhoneNumber);
Application.Current.Windows[0].Close();
}
else
{
SmsCode = "You've typed a wrong code. Try again.";
}
}
public ActionResult SummaryReservation(short?id)
{
if (Session["USER_LOGIN"] != null)
{
if (id == -1) //uzytkownik dokonuje nowej rezerwacji
{
RESERVATIONS rESERVATIONS = new RESERVATIONS();
string dateTimeHall = Session["DateTimeHall"].ToString();
string[] date_time_hall_Array = dateTimeHall.Split(' ');//3 -hall
string[] date = date_time_hall_Array[0].Split('-');
//year, month, day
DateTime YearMonthDay = new DateTime(Int32.Parse(date[0]), Int32.Parse(date[1]), Int32.Parse(date[2]));
//hour, minutes, seconds
string[] time = date_time_hall_Array[1].Split(':');
TimeSpan HourMinutesSeconds = new TimeSpan(Int32.Parse(time[0]), Int32.Parse(time[1]), Int32.Parse(time[2]));
string Hallid = date_time_hall_Array[3];
//ID_Program
var idProgram = db.PROGRAM.Where
(x => x.DATE == YearMonthDay &&
x.TIME == HourMinutesSeconds &&
x.ID_HALL == Hallid).Select(x => x.ID_PROGRAM).FirstOrDefault();
//rESERVATIONS.ID_RESERVATION=
string userLogin = Session["USER_LOGIN"].ToString();
rESERVATIONS.ID_PROGRAM = idProgram;
rESERVATIONS.USER_LOGIN = userLogin;
db.RESERVATIONS.Add(rESERVATIONS);
db.SaveChanges();
//id_reser | id_seat |id_ticket
RESERVATIONS_DETAILS rESERVATIONS_DETAILS;
var idReservation = rESERVATIONS.ID_RESERVATION;
Dictionary <string, string> seatTicket = (Dictionary <string, string>)Session["seatTicket"];
//pair.Value - rodzaj biletu
//pair.Key - miejsce
foreach (KeyValuePair <string, string> pair in seatTicket)
{
rESERVATIONS_DETAILS = new RESERVATIONS_DETAILS();
rESERVATIONS_DETAILS.ID_RESERVATION = idReservation;
if (pair.Key.Contains("VIP"))
{
rESERVATIONS_DETAILS.ID_SEAT = pair.Key.Remove(pair.Key.Length - 4);
}
else
{
rESERVATIONS_DETAILS.ID_SEAT = pair.Key;
}
rESERVATIONS_DETAILS.ID_TICKET = db.TICKETS.Where(x => x.TYPE == pair.Value).Select(x => x.ID_TICKET).FirstOrDefault();
db.RESERVATIONS_DETAILS.Add(rESERVATIONS_DETAILS);
}
}
else //uzytkownik ma rezerwacje
{
List <RESERVATIONS_DETAILS> rESERVATIONS_DETAILS_List = db.RESERVATIONS_DETAILS.Where(x => x.ID_RESERVATION == id).ToList(); //zwraca wszystkie rezerwacje o ID==id uzytkownika
Dictionary <string, string> seatTicket = (Dictionary <string, string>)Session["seatTicket"]; //siedzenia i bilety, ktore wybrał uzytkownik
//1. Skasowanie pozycji z RESERVATIONS_DETAILS o id przeslanym w argumencie metody
foreach (var item in rESERVATIONS_DETAILS_List)
{
db.RESERVATIONS_DETAILS.Remove(item);
}
db.SaveChanges();
RESERVATIONS_DETAILS rESERVATIONS_DETAILS;
//2. Dodanie do bazy poprawnych pozycji z listy
foreach (KeyValuePair <string, string> pair in seatTicket)
{
rESERVATIONS_DETAILS = new RESERVATIONS_DETAILS();
rESERVATIONS_DETAILS.ID_RESERVATION = id.Value;
if (pair.Key.Contains("VIP"))
{
rESERVATIONS_DETAILS.ID_SEAT = pair.Key.Remove(pair.Key.Length - 4);
}
else
{
rESERVATIONS_DETAILS.ID_SEAT = pair.Key;
}
rESERVATIONS_DETAILS.ID_TICKET = db.TICKETS.Where(x => x.TYPE == pair.Value).Select(x => x.ID_TICKET).FirstOrDefault();
db.RESERVATIONS_DETAILS.Add(rESERVATIONS_DETAILS);
}
}
Session["mTitle"] = null;
Session["DateTimeHall"] = null;
Session["seatTicket"] = null;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
