private void GetDowonloadsByEvents(string searchField) { Session["Alphabet"] = null; Session["SearchByEvents"] = null; Session["SearchByDownloadTypes"] = null; Session["SearchField"] = null; DataTable dt = new DataTable(); DownloadsBll obj = new DownloadsBll(); obj.EventName = searchField; dt = obj.GetDownloadsByEventType(); if (dt.Rows.Count > 0) { lblMsg.Visible = false; RadGrid1.Visible = true; RadGrid1.DataSourceID = string.Empty; RadGrid1.DataSource = dt; RadGrid1.Rebind(); } else { lblMsg.Visible = true; RadGrid1.Visible = false; } }
private void SearchByAlphabet(string name) { Session["Alphabet"] = name; Session["SearchByEvents"] = null; Session["SearchByDownloadTypes"] = null; Session["SearchField"] = null; DataTable dt = new DataTable(); DownloadsBll obj = new DownloadsBll(); obj.Title = name; dt = obj.SearchDownloadsByAlphabet(); if (dt.Rows.Count > 0) { lblMsg.Visible = false; RadGrid1.Visible = true; RadGrid1.DataSourceID = string.Empty; RadGrid1.DataSource = dt; RadGrid1.Rebind(); } else { lblMsg.Visible = true; RadGrid1.Visible = false; } }
protected void RadGrid1_ItemCommand(object source, Telerik.Web.UI.GridCommandEventArgs e) { if (e.CommandName == "Delete") { string i = e.CommandArgument.ToString(); int id = int.Parse(i.ToString()); DownloadsBll obj = new DownloadsBll(); obj.Id = id; if (obj.DeleteDownloads() > 0) { RadGrid1.DataBind(); } } }
private void GetDownloads(int id) { DownloadsBll obj = new DownloadsBll(); obj.Id = id; DataTable dt = new DataTable(); dt = obj.GetDownloadsById(); if (dt.Rows.Count > 0) { string downloadType = dt.Rows[0]["download_type"].ToString(); if (downloadType == "Powerpoints") { rbtnDownloadType.SelectedIndex = 0; } if (downloadType == "Documents") { rbtnDownloadType.SelectedIndex = 1; } if (downloadType == "Manuals") { rbtnDownloadType.SelectedIndex = 2; } event_date.DbSelectedDate = DateTime.Parse(dt.Rows[0]["event_date"].ToString()); txtEventName.Text = dt.Rows[0]["event_name"].ToString(); txtTitle.Text = dt.Rows[0]["title"].ToString(); txtAuthor.Text = dt.Rows[0]["author"].ToString(); string file = dt.Rows[0]["file_name"].ToString(); if (file != "") { Session["DownloadedFile"] = file; } //lblFileSize.Text = dt.Rows[0]["file_size"].ToString(); //string section = dt.Rows[0]["presented_at"].ToString(); //if (section == "PrePets") // rbtnPresentedAt.SelectedIndex = 0; //if (section == "SOTS") // rbtnPresentedAt.SelectedIndex = 1; } }
private void SearchByDownloadTypes(string strEvent) { DataTable dt = new DataTable(); DownloadsBll obj = new DownloadsBll(); obj.DownloadType = strEvent; dt = obj.GetDownloadsByDownloadsType(); if (dt.Rows.Count > 0) { lblMsg.Visible = false; RadGrid1.Visible = true; RadGrid1.DataSourceID = string.Empty; RadGrid1.DataSource = dt; RadGrid1.Rebind(); } else { lblMsg.Visible = true; RadGrid1.Visible = false; } }
private void BindGrid() { Session["Alphabet"] = null; Session["SearchByEvents"] = null; Session["SearchByDownloadTypes"] = null; Session["SearchField"] = null; DataTable dt = new DataTable(); DownloadsBll obj = new DownloadsBll(); dt = obj.GetDownloads(); if (dt.Rows.Count > 0) { lblMsg.Visible = false; RadGrid1.Visible = true; RadGrid1.DataSource = dt; RadGrid1.DataBind(); } else { lblMsg.Visible = true; RadGrid1.Visible = false; } }