async Task auth(bool is_admin) { MySQLServer.InputStatus status = await MySQLServer.login(loginBox.Value, passwordBox.Value, Response, is_admin); loginError.Text = "<br />"; passwordError.Text = "<br />"; if (status == MySQLServer.InputStatus.LoginRequired) { loginError.Text = "Login required"; } if (status == MySQLServer.InputStatus.PasswordRequired) { passwordError.Text = "Password required"; } if (status == MySQLServer.InputStatus.NoSuchUser) { loginError.Text = "No such user"; } if (status == MySQLServer.InputStatus.IncorrectPassword) { passwordError.Text = "Incorrect password"; } }
protected void Page_Load(object sender, EventArgs e) { if (!(MySQLServer.auth_chech(Request) && MySQLServer.admin_check(Request))) { Response.Redirect("~/", false); } }
private void loadMeta() { List <string> items = MySQLServer.get_orders_information(); orders.Text += String.Format("<tr><th>User</th><th>Film title</th><th>Date and time</th><th>Places</th><th>Cost</th><th>Status</th></tr>"); for (int i = 0; i < items.Count / 7; ++i) { string id = items[i * 7 + 0]; string user = items[i * 7 + 1]; string film = items[i * 7 + 2]; string date = items[i * 7 + 3]; string status = items[i * 7 + 4]; string cost = items[i * 7 + 5]; string places = items[i * 7 + 6]; if (status == "pending confirmation") { orders.Text += String.Format("<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{5}</td><td class=\"flex\"><input class=\"sub-button\" onClick=\"approve(this)\" id=\"a{4}\" type = \"submit\" value=\"Accept\"/><input class=\"dec-button\" onClick=\"approve(this)\" id=\"d{4}\" type = \"submit\" value=\"Decline\"/></td></tr>", user, film, date, places, id, cost); } else { orders.Text += String.Format("<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{5}</td><td class=\"flex\">{4}</td></tr>", user, film, date, places, status, cost); } } orders.Text = "<table cellspacing=\"0\">" + orders.Text + "</table>"; }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "application/pdf"; context.Response.AddHeader("content-disposition", "inline; filename=ticket.pdf"); List <string> items = MySQLServer.get_orders_information(int.Parse(context.Request["id"])); if (items.Count == 0 || items[1] != context.Request.Cookies["login"].Value.ToUpper() || items[4] != "confirmed") { context.Response.Redirect("~/Account/Profile"); } QRCodeEncoder encoder = new QRCodeEncoder(); Bitmap QRImage = encoder.Encode(SignGenerator.GetSign(items[0] + items[1])); Document doc = new Document(iTextSharp.text.PageSize.A4, 40, 40, 42, 35); PdfWriter writer = PdfWriter.GetInstance(doc, context.Response.OutputStream); doc.Open(); doc.Add(new Paragraph("User: "******"Film: " + items[2])); doc.Add(new Paragraph("Date: " + items[3].Split(' ')[0])); doc.Add(new Paragraph("Time: " + items[3].Split(' ')[1])); doc.Add(new Paragraph("\n")); doc.Add(new Paragraph("Cost: " + items[5])); doc.Add(new Paragraph("\n")); doc.Add(new Paragraph("Places: " + items[6])); doc.Add(new Paragraph("\n")); iTextSharp.text.Image i = iTextSharp.text.Image.GetInstance(QRImage, ImageFormat.Jpeg); doc.Add(i); doc.Close(); }
protected void Check(object sender, EventArgs e) { time.Items.Clear(); string date = Calendar1.SelectedDate.ToShortDateString(); string mySQLDate = date.Split('.')[2] + '-' + date.Split('.')[1] + '-' + date.Split('.')[0]; Debug.WriteLine(mySQLDate); List <string> items = MySQLServer.get_times(mySQLDate); bool[] used = new bool[12]; foreach (string item in items) { int begin = int.Parse(item.Split(':')[0]); for (int hour = begin - 1; hour < begin + 2; ++hour) { if (hour - 10 >= 0) { used[hour - 10] = true; } } } for (int hour = 10; hour < 22; ++hour) { if (!used[hour - 10]) { string h = hour.ToString() + ":00:00"; time.Items.Add(new ListItem(h)); } } }
protected void Page_Load(object sender, EventArgs e) { String[] info = Request.FilePath.Split('/'); if (info.Length < 3) { Response.Redirect("~/"); } id = info[info.Length - 1]; time = info[info.Length - 2]; date = info[info.Length - 3]; List <string> show = MySQLServer.get_show_information(id, date + " " + time + ":00:00"); if (show.Count == 0) { Response.Redirect("~/"); } session_id = show[0]; title = show[1]; cost = show[2]; film_cost.Text = "<h3 style=\"header-text\">Film cost: " + cost + "</h3>"; film.Text = "<h1 style=\"header-text\">" + title + "</h1>"; session_date.Text = "<h3>Date: " + date + "</h3>"; session_time.Text = "<h3>Time: " + time + ":00</h3>"; seats.Text = ""; loadSeats(); if (Request.Cookies["login"] != null) { move.Text = "<input class=\"sub-button\" type=\"submit\" value=\"Book\" style=\"width: 290px\" runat=\"server\" onclick=\"get()\" />"; } else { move.Text = "<p class=\"lower-text\">New to Cinema?<a href = \"../../../Account/Register\"> Create an account.</a><p/>"; } }
protected async void Page_Load(object sender, EventArgs e) { connection = new MySqlConnection(MySQLServer.connectionString); await connection.OpenAsync(); if (MySQLServer.auth_chech(Request)) { Response.Redirect("~/Account/Profile", false); } }
protected async void submit_Click(object sender, EventArgs e) { MySQLServer.InputStatus[] status = await MySQLServer.register(loginBox.Value, passwordBox.Value, emalBox.Value, Response); if (status[0] == MySQLServer.InputStatus.Succeed && status[0] == status[1] && status[0] == status[2]) { await MySQLServer.login(loginBox.Value, passwordBox.Value, Response, false); } else { loginError.Text = "This will be your username."; emailError.Text = "We'll occasionally send updates about your account to this inbox."; passwordError.Text = "Use at least one lowercase letter, one numeral, and seven characters."; loginError.CssClass = "lower-text"; emailError.CssClass = "lower-text"; passwordError.CssClass = "lower-text"; if (status[0] == MySQLServer.InputStatus.LoginRequired) { loginError.CssClass = "error-string"; loginError.Text = "Login required"; } if (status[1] == MySQLServer.InputStatus.EmailRequired) { emailError.CssClass = "error-string"; emailError.Text = "E-mail required"; } if (status[2] == MySQLServer.InputStatus.PasswordRequired) { passwordError.CssClass = "error-string"; passwordError.Text = "Password required"; } if (status[0] == MySQLServer.InputStatus.LoginAlreadyTaken) { loginError.CssClass = "error-string"; loginError.Text = "This login already taken"; } if (status[1] == MySQLServer.InputStatus.EmailAlreadyTaken) { emailError.CssClass = "error-string"; emailError.Text = "This e-mail already taken"; } if (status[2] == MySQLServer.InputStatus.ShortPassword) { passwordError.CssClass = "error-string"; passwordError.Text = "Password must be longer than 6 characters"; } } }
private void loadMeta() { List <string> items = MySQLServer.get_films(); films_id = new List <string>(); foreach (string item in items) { films.Items.Add(new ListItem(item.ToString().Split('&')[1])); films_id.Add(item.ToString().Split('&')[0]); } }
protected async void submit_Click(object sender, EventArgs e) { string date = Calendar1.SelectedDate.ToShortDateString(); string mySQLDate = date.Split('.')[2] + '-' + date.Split('.')[1] + '-' + date.Split('.')[0] + " " + time.SelectedValue; await MySQLServer.add_session(films_id[films.SelectedIndex], mySQLDate, cost.SelectedValue); Response.Redirect("~/Shows/", false); }
protected async void Page_Load(object sender, EventArgs e) { if (!(MySQLServer.auth_chech(Request) && MySQLServer.admin_check(Request))) { Response.Redirect("~/", false); } if (category.Items.Count == 0) { loadMeta(); } }
protected void HiddenField1_ValueChanged(object sender, EventArgs e) { string id = HiddenField1.Value; if (id[0] == 'a') { MySQLServer.confirm(id.Substring(1)); } else { MySQLServer.decline(id.Substring(1)); } Response.Redirect("~/Manage/Orders"); }
private void loadMeta() { List <string> items = MySQLServer.get_categories(); foreach (string item in items) { category.Items.Add(new ListItem(item.ToString())); } items = MySQLServer.get_coutries(); foreach (string item in items) { country.Items.Add(item); } }
protected void HiddenField1_ValueChanged(object sender, EventArgs e) { string[] list = HiddenField1.Value.Split(','); List <string> places = new List <string>(); for (int i = 0; i < list.Length; ++i) { if (list[i] == "true") { places.Add((i + 1).ToString()); } } MySQLServer.add_order(Request.Cookies["login"].Value, session_id, places); Response.Redirect("~/Account/Profile"); }
static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); /*********** * Debug w/o eFlash MySQL: set localDB = useDB.none; start your own server * Debug w/eFlash MySQL: install eFlash; set localDB = useDB.debug; change path below * Production build: set localDB = useDB.release; build installer ***********/ useMySQL localDB = useMySQL.release; if (localDB != useMySQL.none) { Form loadScreen = new eFlash.GUI.Loading(); loadScreen.Visible = true; string pwd = AppHelper.GetPresentWorkingDirectory(); if (localDB == useMySQL.debug) { // Path to your MySQL bin directory, i.e.: pwd = "C:\\Program Files\\eFlash\\Data\\MySQL\\bin\\"; } else if (localDB == useMySQL.release) { pwd = AppHelper.GetPresentWorkingDirectory() + "\\Data\\MySQL\\bin\\"; } MySQLServer.mybin = pwd; MySQLServer.StartAndWait(); loadScreen.Visible = false; } Application.Run(new eFlash.GUI.Profile.profile_selector()); //Application.Run(new main()); //Application.Run(new eFlash.GUI.File.importScreen()); //Application.Run(new eFlash.GUI.File.exportScreen()); //Application.Run(new eFlash.GUI.Network.welcome()); //Application.Run(new eFlash.GUI.Creator.LayoutEditor(null, null)); //Application.Run(new eFlash.GUI.Network.browser()); //eFlash.dbAccess.remoteDB.test(); if (localDB != useMySQL.none) { MySQLServer.StopAndWait(); } }
protected void Page_Load(object sender, EventArgs e) { HttpCookie loginCookie = Request.Cookies["login"]; HttpCookie signCookie = Request.Cookies["sign"]; if (!MySQLServer.auth_chech(Request)) { Response.Redirect("../Accounts/Login.aspx"); return; } name = loginCookie.Value.ToUpper(); login.Text = "<h1>" + name + "</h1>"; loadMeta(); //QRCode(); }
private void loadSeats() { for (int row = 1; row <= 5; ++row) { string places = string.Empty; for (int column = 1; column <= 6; ++column) { int place = (row - 1) * 6 + column; if (!MySQLServer.check_seat(session_id, place.ToString())) { places += String.Format("<li class=\"seat\"><input type=\"checkbox\" id=\"{0}\" onchange=\"update_cost(this)\" /><label for=\"{0}\">{0}</label></li>", place); } else { places += String.Format("<li class=\"seat\"><input type=\"checkbox\" disabled id=\"{0}\" /><label for=\"{0}\">Occupied</label></li>", place); } } places = "<ol class=\"seats\" type=\"A\">" + places + "</ol>"; seats.Text += String.Format("<li class=\"row row--{0}\">{1}</li>", row.ToString(), places); } }
protected async void Page_Load(object sender, EventArgs e) { String URL = Request.FilePath.Split('/').Last(); if (await MySQLServer.URL_check(URL)) { List <String> list = await MySQLServer.get_film_information(URL); title.Text = list[1]; description.Text = list[2]; durability.Text = list[3]; producer.Text = list[4]; year.Text = list[5]; country.Text = list[6]; genre.Text = list[7]; poster.ImageUrl = "~/Posters/" + URL + ".jpg"; } else { Response.Redirect("~/", false); } }
public override void ViewDidLoad() { base.ViewDidLoad(); myLoginButton.TouchUpInside += delegate { var username = myUsername; var password = myPassword; if (password.Text.Length == 0 || username.Text.Length == 0) { Alert.Message(Alert.error, "Username or password is emty!", Alert.buttonOk); MySQLServer.GetArticles(); //AppAlert.Message(AppAlert.error, "Username or password is emty!", AppAlert.buttonOk); return; } Alert.Message(Alert.info, username.Text.ToString() + "\n" + password.Text.ToString() + "\n" + MySQLServer.article[2].Title, Alert.buttonOk); //AppAlert.Message(AppAlert.info, username.Text.ToString() + "\n" + password.Text.ToString(), AppAlert.buttonOk); }; myPassword.ShouldReturn = (textField) => { textField.ResignFirstResponder(); return(true); }; }
private void loadMeta() { List <string> items = MySQLServer.get_orders_information(name); orders.Text += String.Format("<tr><th>Film title</th><th>Date and time</th><th>Places</th><th>Cost</th><th>Status</th><th>Get PDF</th></tr>"); for (int i = 0; i < items.Count / 7; ++i) { string id = items[i * 7 + 0]; string user = items[i * 7 + 1]; string film = items[i * 7 + 2]; string date = items[i * 7 + 3]; string status = items[i * 7 + 4]; string cost = items[i * 7 + 5]; string places = items[i * 7 + 6]; string PDF = "<a runat=\"server\" class = \"pdf\" href=\"Ticket.ashx?id=" + id + "\">Download</a>"; if (status != "confirmed") { PDF = ""; } orders.Text += String.Format("<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{4}</td><td class=\"flex\">{3}</td><td>{5}<td></tr>", film, date, places, status, cost, PDF); } orders.Text = "<table cellspacing=\"0\">" + orders.Text + "</table>"; }
protected async void submit_Click(object sender, EventArgs e) { MySQLServer.InputStatus[] status = await MySQLServer.add_film(title.Text, description.Text, durability.Text, poster, URL.Text, year.Text, producer.Value, country.SelectedValue, category, Response, Server); if (!(status[0] == MySQLServer.InputStatus.Succeed && status[0] == status[1] && status[0] == status[2] && status[2] == status[3] && status[3] == status[4])) { title_error.Text = "Enter film title."; description_error.Text = "Fill out a short description of the film."; image_error.Text = "Select an image for the poster."; durability_error.Text = "Enter the length of the movie (in minutes)."; category_error.Text = "Select at least one category."; producer_error.Text = "Producer's name."; year_error.Text = "Enter year of film."; URL_error.Text = "Enter the URL (must be unique)."; poster_path.Value = ""; category_error.CssClass = "lower-text"; producer_error.CssClass = "lower-text"; durability_error.CssClass = "lower-text"; title_error.CssClass = "lower-text"; description_error.CssClass = "lower-text"; image_error.CssClass = "lower-text"; year_error.CssClass = "lower-text"; URL_error.CssClass = "lower-text"; if (status[0] == MySQLServer.InputStatus.EmptyString) { title_error.CssClass = "error-string"; title_error.Text = "Title required"; } if (status[1] == MySQLServer.InputStatus.EmptyString) { description_error.CssClass = "error-string"; description_error.Text = "Description required"; } if (status[2] == MySQLServer.InputStatus.EmptyString) { durability_error.CssClass = "error-string"; durability_error.Text = "Durability required"; } else if (status[2] == MySQLServer.InputStatus.IncorrectNumber) { durability_error.CssClass = "error-string"; durability_error.Text = "Must be a positive number not greater than 500"; } if (status[3] == MySQLServer.InputStatus.WrongPosterExp) { image_error.CssClass = "error-string"; image_error.Text = "File must be in '*.jpg' format."; } if (status[4] == MySQLServer.InputStatus.NoCategoriesSelected) { category_error.CssClass = "error-string"; category_error.Text = "No categories selected"; } if (status[5] == MySQLServer.InputStatus.EmptyString) { producer_error.CssClass = "error-string"; producer_error.Text = "Producer required."; } if (status[6] == MySQLServer.InputStatus.IncorrectNumber) { year_error.CssClass = "error-string"; year_error.Text = "Wrong year."; } if (status[7] != MySQLServer.InputStatus.Succeed) { URL_error.CssClass = "error-string"; URL_error.Text = "Wrong URL or already exist."; } } else { Response.Redirect("~/Films/" + URL.Text, false); } }
protected void Page_Load(object sender, EventArgs e) { List <string> Shows = MySQLServer.get_shows(); List <DayShow> Days = new List <DayShow>(); String first_date = String.Empty; String last_show_date = String.Empty; Tabs.Text = string.Empty; for (int show = 0; show < Shows.Count / 6; show++) { String film_id = Shows[show * 6 + 0]; String film_name = Shows[show * 6 + 1]; String URL = Shows[show * 6 + 2]; String country = Shows[show * 6 + 3]; String continuance = Shows[show * 6 + 4]; String show_date = Shows[show * 6 + 5]; if (first_date == String.Empty) { first_date = show_date.Split(' ')[0]; } if (show_date.Split(' ').First() != last_show_date.Split(' ').First()) { last_show_date = show_date; Days.Add(new DayShow()); Days.Last().film_list.Add(new DayShow.Film()); Days.Last().film_list.Last().film_id = film_id; Days.Last().film_list.Last().film_name = film_name; Days.Last().film_list.Last().URL = URL; Days.Last().film_list.Last().country = country; Days.Last().film_list.Last().continuance = continuance; Days.Last().film_list.Last().time.Add(show_date.Split(' ').Last()); Days.Last().date = show_date.Split(' ').First(); } else { int film_is_found = -1; for (int film = 0; film < Days.Last().film_list.Count; ++film) { if (Days.Last().film_list[film].film_name == film_name) { film_is_found = film; break; } } if (film_is_found != -1) { Days.Last().film_list[film_is_found].time.Add(show_date.Split(' ').Last()); } else { Days.Last().film_list.Add(new DayShow.Film()); Days.Last().film_list.Last().film_id = film_id; Days.Last().film_list.Last().film_name = film_name; Days.Last().film_list.Last().URL = URL; Days.Last().film_list.Last().country = country; Days.Last().film_list.Last().continuance = continuance; Days.Last().film_list.Last().time.Add(show_date.Split(' ').Last()); } } } //**DEBUG**// /* * for (int i = 0; i < Days.Count; ++i) * { * Debug.WriteLine("Date: " + Days[i].date); * Debug.WriteLine("Hall: " + Days[i].hall_name); * Debug.WriteLine("Films:"); * for (int j = 0; j < Days[i].film_list.Count; ++j) * { * Debug.WriteLine(Days[i].film_list[j].film_name + " " + Days[i].film_list[j].film_id + ":"); * for (int k = 0; k < Days[i].film_list[j].time.Count; ++k) * { * Debug.WriteLine(Days[i].film_list[j].time[k]); * } * } * Debug.WriteLine(""); * } */ for (int i = 0; i < Days.Count; ++i) { string tabclass = "tablinks"; if (int.Parse(selectedTab.Value) == i) { tabclass = "tablinks active"; } Tabs.Text += String.Format("<button id=\"T" + i + "\" class=\"" + tabclass + "\" onclick=\"openTab(event,this, '{0}')\">{0}</button>", Days[i].date); String content = String.Empty; for (int j = 0; j < Days[i].film_list.Count; ++j) { String sessions = String.Empty; for (int k = 0; k < Days[i].film_list[j].time.Count; ++k) { string[] d = Days[i].date.Split('.').Reverse().ToArray(); string date = string.Empty; foreach (string s in d) { date += s + "-"; } sessions += String.Format("<a class=\"link\" href=\"{0}/{1}/{2}\">{3}</a>", date.Substring(0, date.Length - 1), Days[i].film_list[j].time[k].Split(':').First(), Days[i].film_list[j].film_id, Days[i].film_list[j].time[k]); } string genres = MySQLServer.get_films_genres(Days[i].film_list[j].film_id); content += String.Format("<ul class=\"list\"><li><img src=\"../Posters/{0}.jpg\" alt=\"\" /><a class=\"link\"href=\"../Films/{0}\">{1}</a><br />Country: {2}<br/>Genres: {3}<br/>Durability: {4} <br/>Sessions: {5} <br/></li></ul>", Days[i].film_list[j].URL, Days[i].film_list[j].film_name, Days[i].film_list[j].country, genres, Days[i].film_list[j].continuance, sessions); } generateInfo.Text += String.Format("<div id = \"{0}\" class=\"tabcontent\"><div class=\"content\">{1}</div></div>", Days[i].date, content); } Page.ClientScript.RegisterStartupScript(this.GetType(), "selectFirst", "selectFirst('" + first_date + "')", true); }