protected void btn_Click(object sender, EventArgs e) { clsLabelsFactory fac = new clsLabelsFactory(); if (string.IsNullOrEmpty(hf.Value)) { List <clsLabels> lbl = fac.GetAllBy(clsLabels.clsLabelsFields.Title, txtLable.Text); if (lbl != null && lbl.Count > 0) { pnlSuccess.Visible = false; pnlError.Visible = true; } else { clsLabels label = new clsLabels(); label.Title = txtLable.Text; label.Data = ddlFirst.SelectedValue == "1" ? false : true; fac.Insert(label); pnlSuccess.Visible = true; lblSuccess.Text = "Label added successfully"; pnlError.Visible = false; } } else { clsLabelsKeys key = new clsLabelsKeys(Convert.ToInt32(hf.Value)); clsLabels label = fac.GetByPrimaryKey(key); label.Title = txtLable.Text; label.Data = ddlFirst.SelectedValue == "1" ? false : true; fac.Update(label); pnlSuccess.Visible = true; lblSuccess.Text = "Label updated successfully"; pnlError.Visible = false; } }
private void LoadData() { clsCompaniesFactory fac = new clsCompaniesFactory(); DataTable comp = fac.GetAll(); DataView dv = comp.DefaultView; dv.Sort = "Company"; ddlCompany.DataSource = dv; ddlCompany.DataTextField = "Company"; ddlCompany.DataValueField = "Id"; ddlCompany.DataBind(); clsLabelsFactory facl = new clsLabelsFactory(); DataTable lbl = facl.GetAll(); DataView dv1 = lbl.DefaultView; dv1.Sort = "Title"; ddlLabel.DataSource = dv1; ddlLabel.DataTextField = "Title"; ddlLabel.DataValueField = "Id"; ddlLabel.DataBind(); clsPromotionFactory facp = new clsPromotionFactory(); DataSet prmtn = facp.GetAllWithPaging(1, 1000, "Id", string.Empty); DataTable myDataTable = prmtn.Tables[0]; DataView dv2 = myDataTable.DefaultView; dv2.Sort = "Title"; ddlPromoter.DataSource = dv2; ddlPromoter.DataTextField = "Title"; ddlPromoter.DataValueField = "Id"; ddlPromoter.DataBind(); }
//Bind your Grid View here private void BindTaskList() { clsLabelsFactory fac = new clsLabelsFactory(); DataSet Songs = fac.GetAllInTable(Convert.ToInt32(ViewState["PageNumber"]), 100, ViewState["SortColumn"].ToString()); DataTable myDataTable = Songs.Tables[0]; //Set your DataTable here ViewState["Count"] = Songs.Tables[1]; grd.DataSource = myDataTable; grd.DataBind(); }
protected void grd_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.ToString() == "_Edit") { Response.Redirect("AddLabels.aspx?id=" + e.CommandArgument + ""); } else if (e.CommandName.ToString() == "_delete") { clsLabelsFactory fac = new clsLabelsFactory(); clsLabelsKeys key = new clsLabelsKeys(Convert.ToInt32(e.CommandArgument)); fac.Delete(key); LoadData(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["User"] != null) { HtmlGenericControl ManageSongs = (HtmlGenericControl)Master.FindControl("ManageSongs"); ManageSongs.Attributes.Add("class", "select"); HtmlGenericControl ManageCompany = (HtmlGenericControl)Master.FindControl("ManageCompany"); ManageCompany.Attributes.Add("class", "select"); HtmlGenericControl ManageLabel = (HtmlGenericControl)Master.FindControl("ManageLabel"); ManageLabel.Attributes.Add("class", "current"); HtmlGenericControl ManageEmergenti = (HtmlGenericControl)Master.FindControl("ManageEmergenti"); ManageEmergenti.Attributes.Add("class", "select"); HtmlGenericControl ImportData = (HtmlGenericControl)Master.FindControl("ImportData"); ImportData.Attributes.Add("class", "select"); HtmlGenericControl audienceFigures = (HtmlGenericControl)Master.FindControl("audienceFigures"); audienceFigures.Attributes.Add("class", "select"); HtmlGenericControl digitalData = (HtmlGenericControl)Master.FindControl("digitalData"); digitalData.Attributes.Add("class", "select"); HtmlGenericControl MoveFiles = (HtmlGenericControl)Master.FindControl("MoveFiles"); MoveFiles.Attributes.Add("class", "select"); HtmlGenericControl Promoter = (HtmlGenericControl)Master.FindControl("Promoter"); Promoter.Attributes.Add("class", "select"); Session["Songs"] = null; Session["eSongs"] = null; if (Request.QueryString != null && Request.QueryString["id"] != null) { hf.Value = Request.QueryString["id"]; clsLabelsFactory fac = new clsLabelsFactory(); clsLabelsKeys key = new clsLabelsKeys(Convert.ToInt32(hf.Value)); clsLabels lvl = fac.GetByPrimaryKey(key); txtLable.Text = lvl.Title; ddlFirst.SelectedValue = lvl.Data == true ? "0" : "1"; } } else { Response.Redirect("Login.aspx"); } } }
protected void Button1_Click(object sender, EventArgs e) { clsLabelsFactory fac = new clsLabelsFactory(); List <clsLabels> lbl = fac.GetAllBy(clsLabels.clsLabelsFields.Title, txtLable.Text); if (lbl != null && lbl.Count > 0) { pnlSuccess.Visible = false; pnlError.Visible = true; lblError.Text = "Label already exists"; } else { clsLabels label = new clsLabels(); label.Title = txtLable.Text; label.Data = ddlFirst.SelectedValue == "1" ? false : true; fac.Insert(label); pnlSuccess.Visible = true; lblSuccess.Text = "Label added successfully"; pnlError.Visible = false; } LoadData(); }
private void LoadData() { clsCompaniesFactory fac = new clsCompaniesFactory(); DataTable comp = fac.GetAll(); DataView dv = comp.DefaultView; dv.Sort = "Company"; ddlCompany.DataSource = dv; ddlCompany.DataTextField = "Company"; ddlCompany.DataValueField = "Id"; ddlCompany.DataBind(); clsLabelsFactory facl = new clsLabelsFactory(); DataTable lbl = facl.GetAll(); DataView dv1 = lbl.DefaultView; dv1.Sort = "Title"; ddlLabel.DataSource = dv1; ddlLabel.DataTextField = "Title"; ddlLabel.DataValueField = "Id"; ddlLabel.DataBind(); clsPromotionFactory facp = new clsPromotionFactory(); DataSet prmtn = facp.GetAllWithPaging(1, 1000, "Id", string.Empty); DataTable myDataTable = prmtn.Tables[0]; DataView dv2 = myDataTable.DefaultView; dv2.Sort = "Title"; ddlPromoter.DataSource = dv2; ddlPromoter.DataTextField = "Title"; ddlPromoter.DataValueField = "Id"; ddlPromoter.SelectedValue = "11"; ddlPromoter.DataBind(); //List<clsGenre> GenreList = new List<clsGenre>(); //clsSongsFactory fac2 = new clsSongsFactory(); //List<clsSongs> Songs1 = fac2.GetAllArtists(""); //foreach (clsSongs s in Songs1) //{ // if (!string.IsNullOrEmpty(s.GENRE)) // { // if (!GenreList.Any(d => d.Value.Contains(s.GENRE)))// s.GENRE.ToLower() == "pop" || s.GENRE.ToLower() == "rock" || s.GENRE.ToLower() == "dance") // GenreList.Add(new clsGenre { Key = s.GENRE.ToLower(), Value = s.GENRE }); // } //} //GenreList = GenreList.Distinct().ToList(); //ddlGenre.DataSource = GenreList; //ddlGenre.DataTextField = "Value"; //ddlGenre.DataValueField = "Key"; //ddlGenre.DataBind(); //List<clsLanguage> LanguageList = new List<clsLanguage>(); //List<clsSongs> Songs2 = fac2.GetAllTitle(""); //foreach (clsSongs s in Songs2) //{ // if (!string.IsNullOrEmpty(s.LANGUAGE)) // { // if (s.LANGUAGE.ToLower() == "int" || s.LANGUAGE.ToLower() == "ita") // LanguageList.Add(new clsLanguage { Key = s.LANGUAGE.ToLower(), Value = s.LANGUAGE }); // } //} //LanguageList = LanguageList.Distinct().ToList(); //ddlLanguage.DataSource = LanguageList; //ddlLanguage.DataTextField = "Value"; //ddlLanguage.DataValueField = "Key"; //ddlLanguage.DataBind(); }