protected void Page_Load(object sender, EventArgs e) { PatronAddLink.NavigateUrl = addPatronUrl; if (!IsPostBack) { DataTable dt; if (CustomUser.IsLibrarian) { dt = DatabaseHelper.Retrieve(@" Select FirstName, LastName, Email, LibraryCardNumber, Address, Zipcode, State From Patron "); } else { int libraryCardNumber = int.Parse(CustomUser.Identity.Name); dt = DatabaseHelper.Retrieve(@" Select FirstName, LastName, Email, LibraryCardNumber, Address, Zipcode, State From Patron where LibraryCardNumber = @LibraryCardNumber ", new SqlParameter("@LibraryCardNumber", libraryCardNumber)); } Patrons.DataSource = dt.Rows; Patrons.DataBind(); } }
public void NewPatron() { var newPatron = context.Patrons.Create(); newPatron.Id = Guid.NewGuid(); context.Patrons.Add(newPatron); Patrons.Add(newPatron); }
public void BookSeats([Required, Range(1, 12)] int seatsRequested) { if ((Theater.TheaterCapacity - Patrons.Count) > seatsRequested) { for (int i = 0; i < seatsRequested; i++) { Patrons.Add(new Patron()); } } }
protected void Page_Load(object sender, EventArgs e) { DataTable dt = DatabaseHelper.Retrieve(@" SELECT Patron.FirstName FROM Patron "); Patrons.DataSource = dt.Rows; Patrons.DataBind(); }
public Patron AddPatron(Patron patron) { if (patron is null) { return(null); } Patrons.TryAdd(patron.ID, patron); QueueToBar.Enqueue(patron); return(patron); }
protected void Page_Load(object sender, EventArgs e) { PatronAddLink.NavigateUrl = addPatronUrl; if (!IsPostBack) { DataTable dt = DatabaseHelper.Retrieve(@" Select FirstName, LastName, Email, LibraryCardNumber, Address, Zipcode, State From Patron "); Patrons.DataSource = dt.Rows; Patrons.DataBind(); } }
public static int CreatePatron(string firstName, string lastName, string email) { Patrons data = new Patrons { FirstName = firstName, LastName = lastName, Email = email }; string sql = @"insert into dbo.Patrons (FirstName, LastName, Email) values (@FirstName, @LastName, @Email);"; return(SqlDataAccess.SaveData(sql, data)); }
public ActionResult Register(Patrons newPatron) { if (ModelState.IsValid) { CreatePatron(newPatron.FirstName, newPatron.LastName, newPatron.Email); ViewBag.Name = Request["FirstName"]; return(View(newPatron)); } else { ViewBag.ErrorMessage = "The information you entered was not valid"; return(View()); } }
public void DeletePatron() { var patronToRemove = SelectedPatron; if (patronToRemove.Loans.Any()) { foreach (var selectedPatronLoan in patronToRemove.Loans.ToList()) { context.Loans.Remove(selectedPatronLoan); } } context.Patrons.Remove(patronToRemove); Patrons.Remove(patronToRemove); }
/// <summary> /// For SampleTest2 /// </summary> /// <returns></returns> private Team55LibraryContext MakeMediumLibrary() { /*MOCK DATABASE SETUP*/ var optionsBuilder = new DbContextOptionsBuilder <Team55LibraryContext>(); Team55LibraryContext db = new Team55LibraryContext(optionsBuilder.UseInMemoryDatabase("medium_library").Options); /*END MOCK DATABASE SETUP*/ /*Add in data*/ Titles profilesInCourage = new Titles { Isbn = "978-0062278791", Title = "Profiles in Courage", Author = "Kennedy" }; Titles theLorax = new Titles { Isbn = "978-0394823379", Title = "The Lorax", Author = "Seuss" }; Titles dune = new Titles { Isbn = "978-0441172719", Title = "Dune", Author = "Herbert" }; Patrons dan = new Patrons { Name = "Dan", CardNum = 4 }; Inventory inv = new Inventory { Serial = 1001, Isbn = "978-0441172719" }; Inventory inv2 = new Inventory { Serial = 1002, Isbn = "978-0441172719" }; Inventory invPIC = new Inventory { Serial = 1006, Isbn = profilesInCourage.Isbn }; db.Titles.Add(dune); db.Patrons.Add(dan); db.Inventory.Add(inv); db.Inventory.Add(inv2); db.Inventory.Add(invPIC); db.SaveChanges(); return(db); }
protected void Page_Load(object sender, EventArgs e) { if (!int.TryParse(Request.QueryString["ID"], out bookCopyId)) { Response.Redirect("~/BookCopy.aspx"); } if (!IsPostBack) { DataTable dt = DatabaseHelper.Retrieve(@" select Title, ISBN, FirstName, LastName, BranchName from BookCopy join Book on (BookCopy.BookId = Book.Id) join Author on (Book.AuthorId = Author.Id) join Library on (BookCopy.LibraryId = Library.Id) where BookCopy.Id = @BookCopyId ", new SqlParameter("@BookCopyId", bookCopyId)); if (dt.Rows.Count == 1) { Title.Text = "Title: " + dt.Rows[0].Field <string>("Title"); Author.Text = "Author: " + dt.Rows[0].Field <string>("FirstName") + " " + dt.Rows[0].Field <string>("LastName"); ISBN.Text = "ISBN: " + dt.Rows[0].Field <string>("ISBN"); Library.Text = "Library: " + dt.Rows[0].Field <string>("BranchName"); DataTable dt2 = DatabaseHelper.Retrieve(@" select LibraryCardNumber, FirstName + ' ' + LastName as Name from Patron "); Patrons.DataValueField = "LibraryCardNumber"; Patrons.DataTextField = "Name"; Patrons.AppendDataBoundItems = true; Patrons.Items.Add(new ListItem("Select a patron...", "")); Patrons.DataSource = dt2; Patrons.DataBind(); } else { Response.Redirect("~/BookCopy.aspx"); } } }
void InitializeComponent() { WindowStyle = Eto.Forms.WindowStyle.None; Style = "transparent-form"; Title = "DWSIM"; string imgprefix = "DWSIM.UI.Forms.Resources.Icons."; int dx, dy, w, h; if (Application.Instance.Platform.IsGtk) { w = (int)(sf * 1088); h = (int)(sf * 509); dx = 20; dy = 0; } else { w = 1088; h = 509; dx = 0; dy = 0; } ClientSize = new Size(w, h); var lbl1a = new Label { Style = "splashlabels1", Text = "Version".Localize() + " " + Assembly.GetExecutingAssembly().GetName().Version.Major.ToString() + "." + Assembly.GetExecutingAssembly().GetName().Version.Minor.ToString() + "." + Assembly.GetExecutingAssembly().GetName().Version.Build.ToString() }; #if DEBUG lbl1a.Text += "-" + File.GetLastWriteTimeUtc(Assembly.GetExecutingAssembly().Location).ToString(); #endif if (Environment.Is64BitProcess) { lbl1a.Text += " (Cross-Platform UI, 64-bit)"; } else { lbl1a.Text += " (Cross-Platform UI, 32-bit)"; } var lbl3 = new Label { Style = "fixedwidth", Text = "GPLNotice".Localize() }; lbl1a.TextColor = new Color(0.051f, 0.447f, 0.651f); lbl3.TextColor = new Color(0.051f, 0.447f, 0.651f); lbl3.Width = (int)(sf * 576); lbl3.Height = (int)(sf * 40); var lbl5 = new Label { Style = "splashlabels1", Text = Shared.AssemblyCopyright }; lbl5.TextColor = new Color(0.051f, 0.447f, 0.651f); var layout = new PixelLayout(); ImageView img; if (Application.Instance.Platform.IsGtk) { img = new ImageView { Image = Bitmap.FromResource(imgprefix + "DWSIM_splash_gtk.png").WithSize(w, h) }; layout.Add(img, 0, 0); lbl1a.BackgroundColor = Colors.WhiteSmoke; lbl5.BackgroundColor = Colors.WhiteSmoke; lbl3.BackgroundColor = Colors.WhiteSmoke; } else { img = new ImageView { Image = Bitmap.FromResource(imgprefix + "DWSIM_splash.png").WithSize(w, h) }; layout.Add(img, (int)(sf * (0 - dx)), (int)(sf * (0 - dy))); } layout.Add(lbl1a, (int)(sf * (334 - dx)), (int)(sf * (114 - dy))); layout.Add(lbl5, (int)(sf * (334 - dx)), (int)(sf * (430 - dy))); layout.Add(lbl3, (int)(sf * (334 - dx)), (int)(sf * (139 - dy))); var lblpatrons = new Label { Style = "splashlabels1", Text = "Special thanks to the following Patrons: " + Patrons.GetList() }; lblpatrons.TextColor = new Color(0.051f, 0.447f, 0.651f); lblpatrons.Width = (int)(sf * 650); lblpatrons.Height = (int)(sf * 227); layout.Add(lblpatrons, (int)(sf * (334 - dx)), (int)(sf * (190 - dy))); Content = layout; var center = Screen.PrimaryScreen.WorkingArea.Center; center.X -= w / 2; center.Y -= h / 2; Location = new Point(center); Topmost = true; img.BackgroundColor = Colors.Transparent; layout.BackgroundColor = Colors.Transparent; if (Application.Instance.Platform.IsWinForms) { BackgroundColor = Colors.White; } else { BackgroundColor = Colors.Transparent; } Shown += SplashScreen_Shown; ShowInTaskbar = false; }
protected void Page_Load(object sender, EventArgs e) { if (edit) { AddOrEdit.Text = "Edit Librarian"; Cancel.Visible = true; if (!int.TryParse(Request.QueryString["ID"], out librarianId)) { Response.Redirect(LibrarianList); } if (!IsPostBack) { DataTable dt = DatabaseHelper.Retrieve(@" select Librarian.LibraryCardNumber, LibraryId from Librarian join Library on (Librarian.LibraryId = Library.Id) join Patron on (Librarian.LibraryCardNumber = Patron.LibraryCardNumber) where Librarian.Id = @LibrarianId ", new SqlParameter("@LibrarianId", librarianId)); if (dt.Rows.Count == 1) { int selectedPatronId = dt.Rows[0].Field <int>("LibraryCardNumber"); int selectedLibraryId = dt.Rows[0].Field <int>("LibraryId"); Patrons.SelectedValue = selectedPatronId.ToString(); Libraries.SelectedValue = selectedLibraryId.ToString(); } else { Response.Redirect(LibrarianList); } } } else { AddOrEdit.Text = "Add Librarian"; } if (!IsPostBack) { DataTable dt = DatabaseHelper.Retrieve(@" select LibraryCardNumber, FirstName + ' ' + LastName As Name from Patron "); Patrons.DataValueField = "LibraryCardNumber"; Patrons.DataTextField = "Name"; Patrons.AppendDataBoundItems = true; Patrons.Items.Add(new ListItem("Select Value...", string.Empty)); Patrons.DataSource = dt; Patrons.DataBind(); DataTable dt2 = DatabaseHelper.Retrieve(@" select BranchName, Id from Library "); Libraries.DataValueField = "Id"; Libraries.DataTextField = "BranchName"; Libraries.AppendDataBoundItems = true; Libraries.Items.Add(new ListItem("Select Value...", string.Empty)); Libraries.DataSource = dt2; Libraries.DataBind(); } }