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(); }
protected void btnSearch_Click(object sender, EventArgs e) { string FromMonths = ddlFrom.SelectedItem.Value; string ToMonths = ddlTo.SelectedItem.Value; if (!string.IsNullOrEmpty(FromMonths)) { string[] FromArr = FromMonths.Split('_'); string FromMonth = FromArr[0].ToString(); string[] ToArr = ToMonths.Split('_'); string ToMonth = ToArr[0].ToString(); int YearName = Convert.ToInt32(FromArr[1].ToString()); clsPromotionFactory fac = new clsPromotionFactory(); DataTable myDataTable = fac.GetAll(FromMonth, ToMonth, YearName, 0); grd.DataSource = myDataTable; grd.DataBind(); } else { DateTime Currentdate = DateTime.Now; int CurrentYear = Currentdate.Year; string CurrentMonth = Currentdate.ToString("MMMM"); string FromMonth = (CurrentMonth == "gennaio" ? "January" : CurrentMonth == "febbraio" ? "February" : CurrentMonth == "marzo" ? "March" : CurrentMonth == "aprile" ? "April" : CurrentMonth == "maggio" ? "May" : CurrentMonth == "giugno" ? "June" : CurrentMonth == "luglio" ? "July" : CurrentMonth == "agosto" ? "August" : CurrentMonth == "settembre" ? "September" : CurrentMonth == "ottobre" ? "October" : CurrentMonth == "novembre" ? "November" : CurrentMonth == "dicembre" ? "December" : CurrentMonth); string ToMonth = FromMonth; BindTaskList(FromMonth, ToMonth, CurrentYear, 0); } }
protected void btnComplete_Click(object sender, EventArgs e) { clsPromotionFactory fac = new clsPromotionFactory(); DataTable myDataTable = fac.GetAll(string.Empty, string.Empty, DateTime.Now.Year, 1); grd.DataSource = myDataTable; grd.DataBind(); }
////Bind your Grid View here //private void BindTaskList() //{ // clsPromotionFactory fac = new clsPromotionFactory(); // //DataSet Emergenti = fac.GetAllWithPaging(Convert.ToInt32(ViewState["PageNumber"]), 100, ViewState["SortColumn"].ToString(), null); // DataTable Emergenti = fac.GetAll(); // //DataTable myDataTable = Emergenti.Tables[0]; //Set your DataTable here // //ViewState["Count"] = Emergenti.Tables[1]; // grd.DataSource = Emergenti; // grd.DataBind(); //} private void BindTaskList(string FromMonth, string ToMonth, int CurrentYear, int IsAll) { clsPromotionFactory fac = new clsPromotionFactory(); DataTable Emergenti = fac.GetAll(FromMonth, ToMonth, CurrentYear, IsAll); grd.DataSource = Emergenti; grd.DataBind(); }
//Bind your Grid View here private void BindTaskList(int PromoterID, string FromMonth, string ToMonth, int CurrentYear, int IsAll) { clsPromotionFactory fac = new clsPromotionFactory(); int pageNumber = Convert.ToInt32(ViewState["PageNumber"]); int PageSize = 100; string sortcolumn = ViewState["SortColumn"].ToString(); DataSet Promoter = fac.GetSongByPromoterID(PromoterID, FromMonth, ToMonth, CurrentYear, 0, pageNumber, PageSize, sortcolumn, null); DataTable myDataTable = Promoter.Tables[0]; //Set your DataTable here ViewState["Count"] = Promoter.Tables[1]; grd.DataSource = myDataTable; grd.DataBind(); }
protected void btnComplete_Click(object sender, EventArgs e) { int PromoterID = Convert.ToInt32(hdnID.Value); clsPromotionFactory fac = new clsPromotionFactory(); int pageNumber = Convert.ToInt32(ViewState["PageNumber"]); int PageSize = 100; string sortcolumn = ViewState["SortColumn"].ToString(); DataSet Promter = fac.GetSongByPromoterID(PromoterID, string.Empty, string.Empty, DateTime.Now.Year, 1, pageNumber, PageSize, sortcolumn, null); DataTable myDataTable = Promter.Tables[0]; //Set your DataTable here grd.DataSource = myDataTable; grd.DataBind(); }
protected void btnSearch_Click(object sender, EventArgs e) { string FromMonths = ddlFrom.SelectedItem.Value; string ToMonths = ddlTo.SelectedItem.Value; if (!string.IsNullOrEmpty(FromMonths)) { string[] FromArr = FromMonths.Split('_'); string FromMonth = FromArr[0].ToString(); string[] ToArr = ToMonths.Split('_'); string ToMonth = ToArr[0].ToString(); int PromoterID = Convert.ToInt32(hdnID.Value); int YearName = Convert.ToInt32(FromArr[1].ToString()); clsPromotionFactory fac = new clsPromotionFactory(); int pageNumber = Convert.ToInt32(ViewState["PageNumber"]); int PageSize = 100; string sortcolumn = ViewState["SortColumn"].ToString(); DataSet Promter = fac.GetSongByPromoterID(PromoterID, FromMonth, ToMonth, YearName, 0, pageNumber, PageSize, sortcolumn, null); DataTable myDataTable = Promter.Tables[0]; //Set your DataTable here grd.DataSource = myDataTable; grd.DataBind(); } else { int PromoterID = Convert.ToInt32(hdnID.Value); DateTime Currentdate = DateTime.Now; int CurrentYear = Currentdate.Year; string CurrentMonth = Currentdate.ToString("MMMM"); string FromMonth = (CurrentMonth == "gennaio" ? "January" : CurrentMonth == "febbraio" ? "February" : CurrentMonth == "marzo" ? "March" : CurrentMonth == "aprile" ? "April" : CurrentMonth == "maggio" ? "May" : CurrentMonth == "giugno" ? "June" : CurrentMonth == "luglio" ? "July" : CurrentMonth == "agosto" ? "August" : CurrentMonth == "settembre" ? "September" : CurrentMonth == "ottobre" ? "October" : CurrentMonth == "novembre" ? "November" : CurrentMonth == "dicembre" ? "December" : CurrentMonth); string ToMonth = FromMonth; BindTaskList(PromoterID, FromMonth, ToMonth, CurrentYear, 0); } }
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(); }