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));
}
