protected void btnRegister_Click(object sender, EventArgs e)
{
// Open SQL connection
SQLConnector con = new SQLConnector();
string EncryptedPassword = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPassword.Text, "SHA1");
ResourceDTO NewResource = new ResourceDTO
{
LoginName = txtUserName.Text,
LoginPassword = EncryptedPassword,
FirstName = Firstname.Text,
LastName = Lastname.Text,
Email = Email.Text
};
// Insert User into table
List <ResourceDTO> ExistingUser = new List <ResourceDTO>();
ExistingUser = con.GetAll("Resource", "LoginName", NewResource.LoginName, typeof(string)).Cast <ResourceDTO>().ToList();
if (ExistingUser.Count == 0)
{
NewResource = (ResourceDTO)(con.CreateObject(NewResource));
string strMessage = string.Format("Hej {0},\r\n\r\nDin bruger \"{1}\" er hermed oprettet i vores system! Vi håber du får set mange film hos os!\r\n\r\nMvh.\r\nTEC BioBooking!", NewResource.FirstName, NewResource.LoginName);
string strSubject = string.Format("Bruger {0} oprettet!", NewResource.LoginName);
Mailor mailor = new Mailor();
mailor.SendMail(NewResource.Email, strSubject, strMessage);
Response.Redirect("default.aspx");
}
else
{
lblMessage.Text = "Brugernavn er optaget - prøv igen.";
}
}
protected void MailButton_Click(object sender, EventArgs e)
{
Mailor mailor = new Mailor();
mailor.SendMail("*****@*****.**");
}
protected void ReservationConfirm_Click(object sender, EventArgs e)
{
// Input checks
if (String.IsNullOrEmpty(ChosenSeatString.Value))
{
RaiseAlert("Minimum et sæde skal vælges.");
return;
}
// Initialize variables
int ScreeningId = Convert.ToInt32(Request.QueryString["Id"]);
int UserId = 0;
List <ResourceDTO> Resource = new List <ResourceDTO>();
ResourceDTO resourceSingle = new ResourceDTO();
SQLConnector con = new SQLConnector();
Resource = con.GetAll("Resource", "LoginName", Context.User.Identity.Name, typeof(string)).Cast <ResourceDTO>().ToList();
try
{
resourceSingle = Resource[0];
}
catch (Exception)
{
throw;
}
UserId = resourceSingle.Id;
MovieScreeningDTO MovieScreeningSingle = new MovieScreeningDTO();
List <MovieScreeningDTO> MovieScreening = new List <MovieScreeningDTO>();
MovieScreening = con.GetAll("MovieScreening", "ScreeningId", ScreeningId.ToString(), typeof(int)).Cast <MovieScreeningDTO>().ToList();
try
{
MovieScreeningSingle = MovieScreening[0];
}
catch (Exception)
{
return;
}
List <String> ConfirmedSeats;
ConfirmedSeats = ChosenSeatString.Value.Split(',').ToList();
ReservationDTO Reservation = new ReservationDTO()
{
ResourceId = UserId,
ScreeningId = ScreeningId
};
// Ensure that other users haven't reserved we're about to insert.
// Get existing reservations
List <ReservationDTO> ExistingReservation = new List <ReservationDTO>();
ExistingReservation = con.GetAll("Reservation", "ScreeningId", ScreeningId.ToString(), typeof(int)).Cast <ReservationDTO>().ToList();
// Only check against ConfirmedSeats if there are existing reservations
if (ExistingReservation.Count() > 0)
{
foreach (var item in ConfirmedSeats)
{
if (ExistingReservation.Where(x => x.SeatId == Convert.ToInt32(item.Substring(12))).Count() > 0)
{
Response.Redirect("~/MovieReservation?ScreeningId=" + ScreeningId.ToString() + "\"");
RaiseAlert("Sæderne er ikke længere ledige - prøv igen");
return;
}
}
}
// Opret nye reservationer
foreach (var item in ConfirmedSeats)
{
Reservation.SeatId = Convert.ToInt32(item.Substring(12));
// Create screening
con.CreateObject(Reservation);
}
// Redirect to same page
string strMessage = string.Format("Hej {0}, tak for din bestilling!\r\n\r\nDu har reserveret {1} {3} til filmen {2}\r\n\r\nMvh.\r\nTEC BioBooking!", resourceSingle.FirstName, ConfirmedSeats.Count().ToString(), MovieScreeningSingle.MovieTitle, (ConfirmedSeats.Count() == 1 ? "billet" : "billetter"));
string strSubject = string.Format("Tak for din bestilling");
Mailor mailor = new Mailor();
mailor.SendMail(resourceSingle.Email, strSubject, strMessage);
Response.Redirect("/MovieReservation?Id=" + ScreeningId.ToString() + "&Done=1");
}
