protected void Page_PreRender(object sender, EventArgs e) { if (grid.UpdatedRow != null) { var region = new Region { RegionID = SQLDataHelper.GetInt(grid.UpdatedRow["ID"]), Name = grid.UpdatedRow["RegionName"], RegionCode = grid.UpdatedRow["RegionCode"], SortOrder = SQLDataHelper.GetInt(grid.UpdatedRow["RegionSort"]) }; RegionService.UpdateRegion(region); } DataTable data = _paging.PageItems; while (data.Rows.Count < 1 && _paging.CurrentPageIndex > 1) { _paging.CurrentPageIndex--; data = _paging.PageItems; } var clmn = new DataColumn("IsSelected", typeof(bool)) { DefaultValue = _inverseSelection }; data.Columns.Add(clmn); if ((_selectionFilter != null) && (_selectionFilter.Values != null)) { for (int i = 0; i <= data.Rows.Count - 1; i++) { int intIndex = i; if (Array.Exists(_selectionFilter.Values, c => c == data.Rows[intIndex]["ID"].ToString())) { data.Rows[i]["IsSelected"] = !_inverseSelection; } } } if (data.Rows.Count < 1) { goToPage.Visible = false; } grid.DataSource = data; grid.DataBind(); pageNumberer.PageCount = _paging.PageCount; lblFound.Text = _paging.TotalRowsCount.ToString(); }
protected void grid_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "DeleteRegion") { RegionService.DeleteRegion(SQLDataHelper.GetInt(e.CommandArgument)); } if (e.CommandName == "AddRegion") { GridViewRow footer = grid.FooterRow; if ( string.IsNullOrEmpty(((TextBox)footer.FindControl("txtNewName")).Text) || string.IsNullOrEmpty(((TextBox)footer.FindControl("txtNewNumber")).Text) ) { grid.FooterStyle.BackColor = System.Drawing.Color.FromName("#ffcccc"); return; } int temp; int.TryParse(((TextBox)footer.FindControl("txtNewSort")).Text, out temp); var region = new Region { Name = ((TextBox)footer.FindControl("txtNewName")).Text, RegionCode = ((TextBox)footer.FindControl("txtNewNumber")).Text, SortOrder = temp, CountryID = CountryID }; RegionService.InsertRegion(region); grid.ShowFooter = false; } if (e.CommandName == "CancelAdd") { grid.FooterStyle.BackColor = System.Drawing.Color.FromName("#ccffcc"); grid.ShowFooter = false; } }
public static void InsertRegion(Region region) { region.RegionID = SQLDataAccess.ExecuteScalar<int>("INSERT INTO [Customers].[Region] (RegionName, RegionCode, RegionSort, CountryID) VALUES (@Name, @RegionCode, @Sort, @CountryID);SELECT scope_identity();", CommandType.Text, new SqlParameter("@Name", region.Name), new SqlParameter("@RegionCode", region.RegionCode), new SqlParameter("@Sort", region.SortOrder), new SqlParameter("@CountryID", region.CountryID)); }
public static Region ReadRegion(SqlDataReader reader) { var r = new Region { CountryID = SQLDataHelper.GetInt(reader, "CountryID"), Name = SQLDataHelper.GetString(reader, "RegionName"), RegionCode = SQLDataHelper.GetString(reader, "RegionCode"), RegionID = SQLDataHelper.GetInt(reader, "RegionID") }; return r; }
public static void UpdateRegion(Region region) { SQLDataAccess.ExecuteNonQuery("Update [Customers].[Region] set RegionName=@name, RegionCode=@RegionCode, RegionSort=@RegionSort where RegionID = @id", CommandType.Text, new SqlParameter("@id", region.RegionID), new SqlParameter("@name", region.Name), new SqlParameter("@RegionCode", region.RegionCode), new SqlParameter("@RegionSort", region.SortOrder)); }