protected void Page_Load(object sender, EventArgs e)
{
bool hasError = false;
// Convert page into number
try
{
pageNo = Convert.ToInt32(Request.QueryString["page"].ToString());
LoadButtons(itemLimit);
}
catch (Exception ex)
{
Net.Redirect("~/Pages/AllGallery.aspx?page=1");
}
if (pageNo < 1)
{
Net.Redirect("~/Pages/AllGallery.aspx?page=1");
}
offsetAmt = CalculateOffset(itemLimit);
// Get search from URL
search = Net.GetQueryStr("search");
if (search == null)
{
GallerySource.SelectParameters.Clear();
GallerySource.SelectCommand = "SELECT ARTPIECE.TITLE, ARTPIECE.IMAGELINK AS URL, ARTPIECE.ArtpieceId, ARTIST.Username, ARTIST.DisplayName FROM ARTPIECE INNER JOIN ARTIST ON ARTPIECE.ARTISTID = ARTIST.ARTISTID WHERE (ARTPIECE.ISPUBLIC = 1) ORDER BY ARTPIECE.ARTPIECEID DESC OFFSET @OFFSETAMT ROWS FETCH NEXT @ITEMLIMIT ROWS ONLY";
GallerySource.SelectParameters.Add("offsetAmt", System.Data.DbType.Int32, offsetAmt + "");
GallerySource.SelectParameters.Add("itemLimit", System.Data.DbType.Int32, itemLimit + "");
ArtRepeater.DataSource = GallerySource;
ArtRepeater.DataBind();
}
else
{
GallerySource.SelectParameters.Clear();
GallerySource.SelectCommand = "SELECT ARTPIECE.TITLE, ARTPIECE.IMAGELINK AS URL, ARTPIECE.ArtpieceId, ARTIST.Username, ARTIST.DisplayName FROM ARTPIECE INNER JOIN ARTIST ON ARTPIECE.ARTISTID = ARTIST.ARTISTID WHERE (ARTPIECE.ISPUBLIC = 1) AND (ARTPIECE.TITLE LIKE '%' + @SEARCH + '%') ORDER BY ARTPIECE.ARTPIECEID DESC OFFSET @OFFSETAMT ROWS FETCH NEXT @ITEMLIMIT ROWS ONLY";
GallerySource.SelectParameters.Add("offsetAmt", System.Data.DbType.Int32, offsetAmt + "");
GallerySource.SelectParameters.Add("itemLimit", System.Data.DbType.Int32, itemLimit + "");
GallerySource.SelectParameters.Add("search", search + "");
ArtRepeater.DataSource = GallerySource;
ArtRepeater.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Redirects
if (Request.QueryString["username"] == null)
{
Net.Redirect("~/Pages/Home.aspx");
}
if (Request.QueryString["username"].ToString().Equals("session") && Net.GetSession("artist") == null && Net.GetSession("customer") == null)
{
Net.Redirect("~/Pages/LoginRegister.aspx");
}
Net.AllowOnly("artist");
/*if (Net.GetSession("artist") == null && Net.GetSession("customer") != null)
* {
* Net.Redirect("~/Pages/CustomerProfile.aspx?username=session");
* }*/
// To ensure that a valid username is entered
try
{
username = Request.QueryString["username"].ToString();
}
catch (Exception ex)
{
// Show error msg
}
int offsetAmt = 0;
int ItemLimit = 9; // How many items per page
// Convert page into number
try
{
pageNo = Convert.ToInt32(Request.QueryString["page"].ToString());
LoadButtons(ItemLimit);
}
catch (Exception ex)
{
Net.Redirect("~/Pages/ArtistProfile.aspx?username="******"&page=1");
}
if (pageNo < 1)
{
Net.Redirect("~/Pages/ArtistProfile.aspx?username="******"&page=1");
}
offsetAmt = CalculateOffset(ItemLimit);
// Clear parameters
GallerySource.SelectParameters.Clear();
GallerySource.SelectCommand = "SELECT ARTPIECE.TITLE, ARTPIECE.IMAGELINK AS URL, ARTPIECE.ArtpieceId, ARTIST.USERNAME, ARTIST.DisplayName FROM ARTPIECE INNER JOIN ARTIST ON ARTPIECE.ARTISTID = ARTIST.ARTISTID WHERE (ARTPIECE.ISPUBLIC = 1) AND ARTIST.USERNAME = @USERNAME ORDER BY ARTPIECE.ARTPIECEID DESC OFFSET @OFFSETAMT ROWS FETCH NEXT @ItemLimit ROWS ONLY";
GallerySource.SelectParameters.Add("offsetAmt", System.Data.DbType.Int32, offsetAmt + "");
GallerySource.SelectParameters.Add("ItemLimit", System.Data.DbType.Int32, ItemLimit + "");
GallerySource.SelectParameters.Add("USERNAME", username);
//Fetch from DB
Artist Artist = null;
if (username.Equals("session"))
{
Artist = (Artist)Net.GetSession("artist");
}
else
{
ArtistDao Dao = new ArtistDao();
Artist = Dao.Get("username", username);
}
if (Artist == null)
{
lblName.Text = "Artist does not exist.";
}
else
{
lblHandle.Text = "@" + Artist.Username;
lblName.Text = Artist.DisplayName;
lblBio.Text = Artist.Bio + "<br><span style='font-size: 20px; color: grey;'>Viewing " + Artist.DisplayName + "'s artworks.</span>";
}
ArtRepeater.DataSource = GallerySource;
ArtRepeater.DataBind();
}
