//Method called when the update and confirm button has been pressed protected void EmployeeGridView_RowUpdating(object sender, GridViewUpdateEventArgs e) { //Collects info from edited lines in the table GridViewRow row = (GridViewRow)EmployeeGridView.Rows[e.RowIndex]; Label textid = EmployeeGridView.Rows[e.RowIndex].FindControl("lbl_ID") as Label; TextBox textAdmin = (TextBox)row.Cells[4].Controls[0]; TextBox textDepID = (TextBox)row.Cells[5].Controls[0]; TextBox textPhone = (TextBox)row.Cells[7].Controls[0]; TextBox textEmail = (TextBox)row.Cells[8].Controls[0]; //Converts the admin text from yes or no into a 1/0 bit textAdmin.Text = textAdmin.Text == "YES" ? "1" : "0"; //Resets the edit index EmployeeGridView.EditIndex = -1; //A new transactionscope is sent and returns and displays whether it is successful or not if (CreateTransactionScope.MakeTransactionScope(String.Format("Exec EmployeeModal @Action = 'Update', @EmployeeID = '{0}', @Admin = '{1}', @DepartmentID = '{2}', @Email = '{3}', @Phone = '{4}'", textid.Text, textAdmin.Text, textDepID.Text, textEmail.Text, textPhone.Text)) > 0) { //Sets the label text to saying the transaction was successful emplbl.Text = "Employee was successfully edited"; emplbl.Visible = true; } else { //Sets the label text to saying the transaction was not successful emplbl.Text = "One or more fields were invalid changes reverted"; emplbl.Visible = true; } //The table is refreshed Binding(Base.RefreshTable()); }
//Method called when pressing the update button protected void DepartmentsGridView_RowUpdating(object sender, GridViewUpdateEventArgs e) { //Collects info from edited lines in the table GridViewRow row = (GridViewRow)DepartmentsGridView.Rows[e.RowIndex]; Label textid = DepartmentsGridView.Rows[e.RowIndex].FindControl("lbl_DID") as Label; TextBox textName = (TextBox)row.Cells[3].Controls[0]; //Resets the edit index DepartmentsGridView.EditIndex = -1; //A new transactionscope is sent and returns and displays whether it is successful or not if (CreateTransactionScope.MakeTransactionScope(String.Format("Exec DepartmentModal @Action = 'Update', @ID = '{0}', @Name = '{1}'", textid.Text, textName.Text)) > 0) { //Sets the label text to saying the transaction was successful deplbl.Text = "Department was successfully edited"; deplbl.Visible = true; } else { //Sets the label text to saying the transaction was not successful deplbl.Text = "One or more fields were invalid changes reverted"; deplbl.Visible = true; } //The table is refreshed Binding(Base.RefreshTable()); }
//Used and called when details button is pressed on the gridview protected void GridView1_OnRowCommand(object sender, GridViewCommandEventArgs e) { //Used to see which command on the row is being called if (e.CommandName == "Details") { //converts retrieved command argument to int for index int index = Convert.ToInt32(e.CommandArgument.ToString()); GridViewRow row = PurchaseOrdersGridView.Rows[index]; //temporary array to store all needed strings for string query string[] squery = { row.Cells[0].Text, row.Cells[2].Text, row.Cells[3].Text, row.Cells[4].Text }; //appends array strings to be sent to response redirect string qstring = "/purchaseorderlines.aspx?purchid=" + squery[0] + "&name=" + squery[1] + "&odate=" + squery[2] + "&ddate=" + squery[3]; //Redirects and attaches purchid of purchase order to query string Response.Redirect(qstring); } else if (e.CommandName == "ConfDeliv") { int index = Convert.ToInt32(e.CommandArgument.ToString()); GridViewRow row = PurchaseOrdersGridView.Rows[index]; CreateTransactionScope.MakeTransactionScope(String.Format("Update PurchaseOrder SET DateDelivered = '{0}' WHERE PurchID = '{1}'", DateTime.Now, row.Cells[0].Text)); this.Binding(Base.RefreshTable()); } }
protected void ItemLookUpGridView_RowEditing(object sender, GridViewEditEventArgs e) { //NewEditIndex property used to determine the index of the row being edited. ItemLookUpGridView.EditIndex = e.NewEditIndex; Binding(Base.RefreshTable()); }