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