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();
}
}
