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