protected void Page_Load(object sender, EventArgs e)
{
if (!User.IsInRole("Librarian"))
{
Response.Redirect(SitePages.GetUrl(LibraryPage.NotAuthorized));
}
}
protected void SaveButton_Command(object sender, CommandEventArgs e)
{
string firstName = NewFirstNameTextBox.Text;
string lastName = NewLastNameTextBox.Text;
int libraryId = int.Parse(NewLibraryDropDownList.SelectedValue);
string emailAddress = NewEmailAddressTextBox.Text;
string addressLine1 = NewAddressLine1TextBox.Text;
string addressLine2 = NewAddressLine2TextBox.Text;
string city = NewCityTextBox.Text;
int stateId = int.Parse(NewStateDropDownList.SelectedValue);
string postalCode = NewPostalCodeTextBox.Text;
DatabaseHelper.ExecuteNonQuery(
UpdateUserAccountQuery,
new SqlParameter("@FirstName", firstName),
new SqlParameter("@LastName", lastName),
new SqlParameter("@AddressLine1", addressLine1),
DatabaseHelper.GetNullableStringSqlParameter("@AddressLine2", addressLine2),
new SqlParameter("@City", city),
new SqlParameter("@StateId", stateId),
new SqlParameter("@PostalCode", postalCode),
new SqlParameter("@EmailAddress", emailAddress),
new SqlParameter("@LibrarianId", librarianId)
);
DatabaseHelper.ExecuteNonQuery(
UpdateEmployeeQuery,
new SqlParameter("@LibraryId", libraryId),
new SqlParameter("@LibrarianId", librarianId)
);
Response.Redirect(SitePages.GetUrl(LibraryPage.Librarians));
}
public async Task <bool> AddPage(NewPageInputModel pageInput)
{
var page = new SitePages();
page.Title = pageInput.Title;
page.Content = pageInput.Content;
page.ImageUrl = pageInput.ImageUrl;
page.CreatedOn = DateTime.UtcNow;
try
{
await this.db.SitePages.AddAsync(page);
}
catch (NullReferenceException e)
{
throw new NullReferenceException("Add Page Needs a valid page model.");
}
int result = await this.db.SaveChangesAsync();
if (!(result == 0))
{
return(false);
}
return(true);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!User.IsInRole("Librarian"))
{
Response.Redirect(SitePages.GetUrl(LibraryPage.NotAuthorized));
}
if (!int.TryParse(Request.QueryString["ID"], out authorId))
{
Response.Redirect(AuthorsUrl);
}
if (!IsPostBack)
{
DataTable dt = DatabaseHelper.Retrieve(
GetAuthorQuery,
new SqlParameter("@AuthorId", authorId));
if (dt.Rows.Count == 1)
{
string oldFirstName = dt.Rows[0].Field <string>("FirstName");
string oldLastName = dt.Rows[0].Field <string>("LastName");
OldFirstName.Text = oldFirstName;
OldLastName.Text = oldLastName;
NewFirstName.Text = oldFirstName;
NewLastName.Text = oldLastName;
}
else
{
Response.Redirect(AuthorsUrl);
}
}
}
protected void AddButton_Command(object sender, CommandEventArgs e)
{
string firstName = FirstNameTextBox.Text;
string lastName = LastNameTextBox.Text;
int libraryId = int.Parse(LibraryDropDownList.SelectedValue);
string emailAddress = EmailAddressTextBox.Text;
string addressLine1 = AddressLine1TextBox.Text;
string addressLine2 = AddressLine2TextBox.Text;
string city = CityTextBox.Text;
int stateId = int.Parse(StateDropDownList.SelectedValue);
string postalCode = PostalCodeTextBox.Text;
// Insert to Employee first
int?employeeId = DatabaseHelper.Insert(AddEmployeeQuery,
new SqlParameter("@FirstName", firstName),
new SqlParameter("@LastName", lastName),
new SqlParameter("@LibraryId", libraryId),
new SqlParameter("@AddressLine1", addressLine1),
DatabaseHelper.GetNullableStringSqlParameter("@AddressLine2", addressLine2),
new SqlParameter("@City", city),
new SqlParameter("@StateId", stateId),
new SqlParameter("@PostalCode", postalCode),
new SqlParameter("@EmailAddress", emailAddress));
// Insert to Librarian
if (employeeId != null)
{
DatabaseHelper.Insert(AddLibrarianQuery,
new SqlParameter("@EmployeeId", employeeId));
}
Response.Redirect(SitePages.GetUrl(LibraryPage.Librarians));
}
public void CheckSiteLoad()
{
SitePages homePage = new SitePages(this.driver);
homePage.NavigateToHomePage();
Assert.AreEqual("SOFTUNI BLOG", homePage.heading.Text);
}
public void LoadLoginPage()
{
SitePages homePage = new SitePages(this.driver);
homePage.NavigateToLoginPage();
Assert.AreEqual("Log in", homePage.loginHeading.Text);
}
public void LoadHelloWorldPost()
{
SitePages homePage = new SitePages(this.driver);
homePage.NavigateToHelloWorldPost();
Assert.AreEqual("Hello World", homePage.helloWorldHeading.Text);
}
public void LoadProBlogPost()
{
SitePages homePage = new SitePages(this.driver);
homePage.NavigateToProBlogPost();
Assert.AreEqual("Pro Blog", homePage.proBlogHeading.Text);
}
public void LoadBlogUpdatePage()
{
SitePages homePage = new SitePages(this.driver);
homePage.NavigateToBlogUpdatePost();
Assert.AreEqual("Blog Update!", homePage.blogUpdateHeading.Text);
}
public void LoadRegistrationPage()
{
SitePages homePage = new SitePages(this.driver);
homePage.NavigateToRegistrationPage();
Assert.AreEqual("Register", homePage.registrationHeading.Text);
}
public void GivenIGoToPageWithListOfPressReleases()
{
if (!SitePages.IsOpen)
{
page = (PageOfPressReleases)SitePages.NavigatePageTo(
PageOfPressReleases.MenuPressCenter,
PageOfPressReleases.MenuPressReleases,
SitePages.Pages.PageOfPressReleases);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!User.IsInRole("Librarian"))
{
Response.Redirect(SitePages.GetUrl(LibraryPage.NotAuthorized));
}
if (!int.TryParse(Request.QueryString["ID"], out libraryId))
{
Response.Redirect(LibrariesUrl);
}
if (!IsPostBack)
{
DataTable libraryTable = DatabaseHelper.Retrieve(GetLibraryQuery,
new SqlParameter("@Id", libraryId));
if (libraryTable.Rows.Count == 1)
{
DataRow row = libraryTable.Rows[0];
string oldName = row.Field <string>("Name");
string oldAddressLine1 = row.Field <string>("AddressLine1");
string oldAddressLine2 = row.Field <string>("AddressLine2");
string oldCity = row.Field <string>("City");
string oldState = row.Field <string>("StateAbbreviation");
int oldStateId = row.Field <int>("StateId");
string oldPostalCode = row.Field <string>("PostalCode");
// Format address for OldAddress label
StringBuilder formattedAddress = new StringBuilder();
formattedAddress.Append(oldAddressLine1);
if (oldAddressLine2 != null)
{
formattedAddress.Append(" " + oldAddressLine2);
}
formattedAddress.Append(", " + oldCity);
formattedAddress.Append(", " + oldState);
formattedAddress.Append(" " + oldPostalCode);
// Fill in all controls in the page
OldName.Text = oldName;
OldAddress.Text = formattedAddress.ToString();
NewNameTextBox.Text = oldName;
NewAddressLine1TextBox.Text = oldAddressLine1;
NewAddressLine2TextBox.Text = (oldAddressLine2 ?? string.Empty);
NewCityTextBox.Text = oldCity;
NewStateDropDown.ListDataSource = () =>
{
DataTable dt = DatabaseHelper.Retrieve(GetStatesQuery);
NewStateDropDown.SetTextAndValueFields("Abbreviation", "Id");
return(dt);
};
NewStateDropDown.SelectedValue = oldStateId.ToString();
NewPostalCodeTextBox.Text = oldPostalCode;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!User.IsInRole("Librarian"))
{
Response.Redirect(SitePages.GetUrl(LibraryPage.NotAuthorized));
}
if (!IsPostBack)
{
DataTable librariansTable = DatabaseHelper.Retrieve(GetLibrariansQuery);
LibrariansRepeater.DataSource = librariansTable.Rows;
LibrariansRepeater.DataBind();
}
}
public void NavigateToLogoffPage()
{
SitePages homePage = new SitePages(this.driver);
homePage.NavigateToHomePage();
LoginPage logPage = new LoginPage(this.driver);
var user = AccessExcelData.GetTestDataLoging("LoginSuccessfully");
logPage.NavigateTo();
logPage.FillLoginForm(user);
homePage.logoffButton.Click();
Assert.AreEqual("http://localhost:60634/Article/List", homePage.homeUrl);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!User.IsInRole("Librarian"))
{
Response.Redirect(SitePages.GetUrl(LibraryPage.NotAuthorized));
}
if (!IsPostBack)
{
AuthorDropDown.ListDataSource = () =>
{
DataTable dt = DatabaseHelper.Retrieve(GetAuthorsQuery);
AuthorDropDown.SetTextAndValueFields("AuthorName", "Id");
return(dt);
};
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!User.IsInRole("Librarian"))
{
Response.Redirect(SitePages.GetUrl(LibraryPage.NotAuthorized));
}
if (!int.TryParse(Request.QueryString["ID"], out bookId))
{
Response.Redirect(BooksUrl);
}
if (!IsPostBack)
{
AuthorDropDown.ListDataSource = () =>
{
DataTable authorsTable = DatabaseHelper.Retrieve(GetAuthorsQuery);
AuthorDropDown.SetTextAndValueFields("AuthorName", "Id");
return(authorsTable);
};
DataTable bookTable = DatabaseHelper.Retrieve(
GetBookQuery,
new SqlParameter("@BookId", bookId));
if (bookTable.Rows.Count == 1)
{
string oldTitle = bookTable.Rows[0].Field <string>("Title");
string oldAuthor = bookTable.Rows[0].Field <string>("AuthorName");
string oldIsbn = bookTable.Rows[0].Field <string>("Isbn");
int oldAuthorId = bookTable.Rows[0].Field <int>("AuthorId");
OldTitle.Text = oldTitle;
OldAuthor.Text = oldAuthor;
OldIsbn.Text = oldIsbn;
TitleTextBox.Text = oldTitle;
AuthorDropDown.SelectedValue = oldAuthorId.ToString();
IsbnTextBox.Text = oldIsbn;
}
else
{
Response.Redirect(BooksUrl);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!User.IsInRole("Librarian"))
{
Response.Redirect(SitePages.GetUrl(LibraryPage.NotAuthorized));
}
if (!IsPostBack)
{
// Bind libraries list
LibraryDropDownList.ListDataSource = () => {
DataTable librariesTable = DatabaseHelper.Retrieve(GetLibrariesQuery);
LibraryDropDownList.SetTextAndValueFields("Name", "Id");
return(librariesTable);
};
// Bind states list
StateDropDownList.ListDataSource = () =>
{
DataTable statesTable = DatabaseHelper.Retrieve(GetStatesQuery);
StateDropDownList.SetTextAndValueFields("Abbreviation", "Id");
return(statesTable);
};
}
}
protected void HomeButton_Command(object sender, CommandEventArgs e)
{
Response.Redirect(SitePages.GetUrl(LibraryPage.Home));
}
protected void SwitchButton_Command(object sender, CommandEventArgs e)
{
// TODO Attempt to redirect to restricted page after switching accounts
FormsAuthentication.SignOut();
Response.Redirect(SitePages.GetUrl(LibraryPage.Login));
}
public IActionResult Detail(int?id)
{
if (id == null)
{
NotFound();
}
string currentUserID = _userManager.GetUserId(User);
Site site = _context.Sites.Where(s => s.UserID == currentUserID)
.Include(s => s.Pages)
.SingleOrDefault(s => s.ID == id);
SitePages sitePages = new SitePages {
Site = site, PageTrees = new List <PageTree>()
};
// foreach( var page in site.Pages)
// {
// if(page.ParentID == 0)
// {
// var topPage = new PageTree{Page = page};
// sitePages.PageTrees.Add(topPage);
// } else
// {
// var pageInSecondLevel = true;
// foreach(var pageTree in sitePages.PageTrees)
// {
// pageInSecondLevel = true;
// if(pageTree.Page.ID == page.ParentID)
// {
// pageInSecondLevel = false;
// if(pageTree.ChildPages == null)
// {
// pageTree.ChildPages = new List<PageTree>();
// }
// PageTree newPageTree = new PageTree{Page = page};
// pageTree.ChildPages.Add(newPageTree);
// }
// }
// if(pageInSecondLevel){
// foreach(var pageTree in sitePages.PageTrees){
// if(pageTree.ChildPages != null){
// foreach(var secondLevelPage in pageTree.ChildPages)
// {
// if(page.ParentID == secondLevelPage.Page.ID)
// {
// if(secondLevelPage.ChildPages == null)
// {
// secondLevelPage.ChildPages = new List<PageTree>();
// }
// PageTree newPageTree = new PageTree{Page = page};
// secondLevelPage.ChildPages.Add(newPageTree);
// }
// }
// }
// }
// }
// }
// }
// if(sitePages == null)
if (site == null)
{
NotFound();
}
// return View(sitePages);
return(View(site));
}
protected void AddButton_Command(object sender, CommandEventArgs e)
{
Response.Redirect(SitePages.GetUrl(LibraryPage.AddPatron));
}
protected void CancelButton_Command(object sender, CommandEventArgs e)
{
Response.Redirect(SitePages.GetUrl(LibraryPage.Librarians));
}
public static void CleanUpTestClass()
{
BaseTest.SoftAssert.AssertAll();
SitePages.Close();
WDriver.Quit();
}
