/* * @Method: UnApprovedList_ItemUpdating * @Params: object sender, ListViewDeleteEventArgs e * @Return: void * @Description: This method will be activated on the click of Approve * venue button. It will pick the VenueID and update the database * accordingly */ protected void UnApprovedList_ItemUpdating(object sender, ListViewUpdateEventArgs e) { string query = null; venueID = UnApprovedList.SelectedDataKey.Value.ToString(); query = "update Venues set IsApproved=1 where VenueID ='" + venueID + "'"; string result = dbCommander.UpdateRecord(query); //If update is successful if (result == "1") { //Closing database connection dbCommander.CloseConnection(); //Turn the list into default UnApprovedList.SelectedIndex = -1; UnApprovedList.DataBind(); //Showing success message ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Alert", "alert('Venue approved successfully');", true); } }
/* * @Method: UnApprovedList_ItemEditing * @Params: object sender, ListViewEditEventArgs e * @Return: void * @Description: This method will be activated on the click of delete button. * The index of the selected item (to be deleted) will be assigned for delete, * and the value of that index will be saved in a global variable to be used * later in another method for editing */ protected void UnApprovedList_ItemEditing(object sender, ListViewEditEventArgs e) { UnApprovedList.EditIndex = e.NewEditIndex; //This variable will be used to create edit request editIndex = UnApprovedList.EditIndex; UnApprovedList.DataBind(); }
protected void UnApprovedList_PreRender(object sender, EventArgs e) { //Configuring Data Source for the ListView string connectionString = ConfigurationManager.ConnectionStrings[dbCommander.sourceString].ConnectionString; string query = "SELECT * FROM Venues INNER JOIN Customers ON Venues.CustomerID = Customers.CustomerID WHERE Venues.IsApproved = 0"; SqlDataSource source = new SqlDataSource(connectionString, query); UnApprovedList.DataSource = source; UnApprovedList.DataBind(); dbCommander.CloseConnection(); }
/* * @Method: UnApprovedList_ItemDeleting * @Params: object sender, ListViewDeleteEventArgs e * @Return: void * @Description: This method will be activated on the click of delete venue button. * This method will be activated on the click of delete venue button. * The selected VenueID will be assigned to a delete query, and database * will be updated accordingly */ protected void UnApprovedList_ItemDeleting(object sender, ListViewDeleteEventArgs e) { UnApprovedList.SelectedIndex = editIndex; string id = UnApprovedList.SelectedDataKey.Value.ToString(); try { //Delete the images folder string path = Server.MapPath("/Content/Images/") + id; DirectoryInfo directory = Directory.CreateDirectory(path); directory.Delete(true); string query = "delete from Venues where VenueID='" + id + "'"; string result = dbCommander.UpdateRecord(query); //If update is successful if (result == "1") { //Closing database connection dbCommander.CloseConnection(); //Turn the list into default UnApprovedList.EditIndex = -1; UnApprovedList.SelectedIndex = -1; UnApprovedList.DataBind(); //Showing success message ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Alert", "alert('Venue deleted successfully');", true); } } catch (SqlException) { //If the user is not inserted, show that there was an error with the database //Showing success message ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Alert", "alert('Database error, please check your provided data to be correct');", true); } }
/* * @Method: CancelDeleteButton_Click * @Params: object sender, EventArgs e * @Return: void * @Description: This method will be activated on the click of Cancel delete button. * The edit index will be reset and the ListView will be refreshed */ protected void CancelDeleteButton_Click(object sender, EventArgs e) { UnApprovedList.EditIndex = -1; UnApprovedList.DataBind(); }
/* * @Method: UnApprovedList_SelectedIndexChanging * @Params: object sender, ListViewSelectEventArgs e * @Return: void * @Description: This method will be activated on the click of Approve or Edit buttons. * The respective item index will be assigned as selected. The ListView will be * refreshed after selection */ protected void UnApprovedList_SelectedIndexChanging(object sender, ListViewSelectEventArgs e) { UnApprovedList.SelectedIndex = e.NewSelectedIndex; UnApprovedList.DataBind(); }