private void PopulateDataGrid()
{
//Hide Details
this.dvDataContent.Visible = false;
this.dvEmptyContent.Visible = false;
this.dvNoSearchResult.Visible = false;
//Search Text
string searchText = this.txtSearch.Text.ToLower().Trim();
SportsCategoryBO objSportCategory = new SportsCategoryBO();
List <SportsCategoryBO> lstSportCategory = new List <SportsCategoryBO>();
if (txtSearch.Text != string.Empty && txtSearch.Text != "search")
{
lstSportCategory = (from pt in objSportCategory.SearchObjects().AsQueryable().OrderBy(SortExpression).ToList()
where pt.Name.ToLower().Contains(searchText) ||
(pt.Description != null && pt.Description.ToLower().Contains(searchText))
select pt).ToList();
}
else
{
lstSportCategory = objSportCategory.SearchObjects().AsQueryable().OrderBy(SortExpression).ToList();
}
if (lstSportCategory.Count > 0)
{
//Bind data to the Data Grid
this.dataGridSportCategory.AllowPaging = (lstSportCategory.Count > this.dataGridSportCategory.PageSize);
this.dataGridSportCategory.DataSource = lstSportCategory;
this.dataGridSportCategory.DataBind();
this.dvDataContent.Visible = true;
}
else if ((searchText != string.Empty && searchText != "search"))
{
this.lblSerchKey.Text = searchText + ((searchText != string.Empty) ? " - " : string.Empty);
this.dvDataContent.Visible = true;
this.dvNoSearchResult.Visible = true;
}
else
{
this.dvEmptyContent.Visible = true;
this.btnAddSportCatagories.Visible = false;
}
this.dataGridSportCategory.Visible = (lstSportCategory.Count > 0);
}
protected void dataGridSportCategory_ItemDataBound(object sender, DataGridItemEventArgs e)
{
DataGridItem item = e.Item;
if (item.ItemIndex > -1 && item.DataItem is SportsCategoryBO)
{
SportsCategoryBO objSportsCategory = (SportsCategoryBO)item.DataItem;
//Edit Link (add attribute)
HyperLink linkEdit = (HyperLink)item.FindControl("linkEdit");
linkEdit.Attributes.Add("qid", objSportsCategory.ID.ToString());
//Delete Link (add attribute)
HyperLink linkDelete = (HyperLink)item.FindControl("linkDelete");
linkDelete.Attributes.Add("qid", objSportsCategory.ID.ToString());
}
}
private void ProcessForm(int sportcategoryId, bool isDelete)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
SportsCategoryBO objSportCategory = new SportsCategoryBO(this.ObjContext);
if (sportcategoryId > 0)
{
objSportCategory.ID = sportcategoryId;
objSportCategory.GetObject();
//get data for update
objSportCategory.Name = this.txtSportCategoryName.Text;
objSportCategory.Description = this.txtDescription.Text;
//btn_Delete
if (isDelete)
{
objSportCategory.Delete();
}
}
else
{
//btn_SaveChanges
objSportCategory.Name = this.txtSportCategoryName.Text;
objSportCategory.Description = this.txtDescription.Text;
if (sportcategoryId == 0)
{
objSportCategory.Add();
}
}
this.ObjContext.SaveChanges();
ts.Complete();
}
}
catch (Exception ex)
{
//throw ex;
}
}
