protected void DDListSortMethod_SelectedIndexChanged(object sender, EventArgs e) { PanelPublicationInfo.Visible = false; PanelEditDelete.Visible = false; GridViewPublications.DataSource = PublicationsDAL.GetPublications($"SELECT * FROM publications ORDER BY {DDListSortMethod.SelectedValue}"); GridViewPublications.DataBind(); }
protected void GridViewPublications_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridViewPublications.PageIndex = e.NewPageIndex; GridViewPublications.SelectedIndex = -1; PanelPublicationInfo.Visible = false; PanelEditDelete.Visible = false; GridViewPublications.DataSource = PublicationsDAL.PublicationsAll; GridViewPublications.DataBind(); //Find(); }
protected void Page_Load(object sender, EventArgs e) { GridViewPublications.PageSize = int.Parse(DDListNumberResults.SelectedValue); if (!IsPostBack) //only at the beginning { PublicationsDAL.PublicationsAll = PublicationsDAL.GetPublications($"SELECT * FROM publications ORDER BY {DDListSortMethod.SelectedValue}"); } GridViewPublications.DataSource = PublicationsDAL.PublicationsAll; GridViewPublications.DataBind(); PanelFields.Visible = false; }
protected void ButtonDelete_Click(object sender, EventArgs e) { PublicationsDAL.DeletePublication(selectedPublication.PairsFieldValue["tag"]); GridViewPublications.DataSource = PublicationsDAL.PublicationsAll = PublicationsDAL.GetPublications($"SELECT * FROM publications " + $"ORDER BY {DDListSortMethod.SelectedValue}"); GridViewPublications.DataBind(); GridViewPublications.SelectedIndex = 0; foreach (var publication in PublicationsDAL.PublicationsAll) { if (publication.Klucz == (string)GridViewPublications.SelectedValue) { selectedPublication = new Publication(publication.PairsFieldValue); ShowInfo(selectedPublication); break; } } Response.Write("<script>alert('Publikacja została usunięta')</script>"); }
protected void ButtonSave_Click(object sender, EventArgs e) { Dictionary <string, string> changes = GetChanges(selectedPublication); if (changes.Count != 0) { PublicationsDAL.UpdatePublication(selectedPublication.PairsFieldValue["tag"], changes); //update view GridViewPublications.DataSource = PublicationsDAL.PublicationsAll = PublicationsDAL.GetPublications($"SELECT * FROM publications " + $"ORDER BY {DDListSortMethod.SelectedValue}"); GridViewPublications.DataBind(); foreach (var publication in PublicationsDAL.PublicationsAll) { if (publication.Klucz == (string)GridViewPublications.SelectedValue) { selectedPublication = new Publication(publication.PairsFieldValue); ShowInfo(selectedPublication); break; } } Response.Write("<script>alert('Publikacja zaktualizowana')</script>"); } }