protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
Warna_Class ClassWarna = new Warna_Class(db);
PemilikProduk_Class ClassPemilikProduk = new PemilikProduk_Class(db);
KategoriProduk_Class KategoriProduk_Class = new KategoriProduk_Class();
Tempat_Class ClassTempat = new Tempat_Class(db);
AtributProduk_Class ClassAtributProduk = new AtributProduk_Class(db);
Tanggal_Class Tanggal_Class = new Tanggal_Class();
DropDownListBulan.Items.AddRange(Tanggal_Class.DropdownlistBulan());
DropDownListTahun.Items.AddRange(Tanggal_Class.DropdownlistTahun());
DropDownListWarna.Items.AddRange(ClassWarna.Dropdownlist());
DropDownListBrand.Items.AddRange(ClassPemilikProduk.Dropdownlist());
DropDownListKategori.Items.AddRange(KategoriProduk_Class.Dropdownlist(db));
DropDownListTempat.Items.AddRange(ClassTempat.DataDropDownList());
DropDownListTempat.SelectedValue = ((PenggunaLogin)Session["PenggunaLogin"]).IDTempat.ToString();
DropDownListVarian.Items.AddRange(ClassAtributProduk.Dropdownlist());
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
Tempat_Class ClassTempat = new Tempat_Class(db);
Tanggal_Class Tanggal_Class = new Tanggal_Class();
DropDownListTempat.Items.AddRange(ClassTempat.DataDropDownList().Where(item => item.Value != "0").ToArray());
DropDownListBulan.Items.AddRange(Tanggal_Class.DropdownlistBulan());
DropDownListTahun.Items.AddRange(Tanggal_Class.DropdownlistTahun());
DropDownListBulan.Visible = false;
}
}
}
private void LoadData()
{
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
int tahun = DropDownListTahun.SelectedValue.ToInt();
int bulan = DropDownListBulan.SelectedValue.ToInt();
int idTempat = DropDownListTempat.SelectedValue.ToInt();
Tanggal_Class Tanggal_Class = new Tanggal_Class();
if (DropDownListTipe.SelectedValue == "1")
{
var ForecastBulan = db.TBForecasts
.Where(item =>
item.IDTempat == idTempat &&
item.Tanggal.Year == tahun)
.GroupBy(item => item.Tanggal.Month)
.Select(item => new
{
item.Key,
Nominal = item.Sum(item2 => item2.Nominal),
Quantity = item.Sum(item2 => item2.Quantity)
});
var Result = Tanggal_Class.DropdownlistBulan()
.Select(item => new
{
Key = item.Value,
Nama = item.Text,
Nominal = ForecastBulan.FirstOrDefault(item2 => item2.Key == item.Value.ToInt()) != null ? ForecastBulan.FirstOrDefault(item2 => item2.Key == item.Value.ToInt()).Nominal : 0,
Quantity = ForecastBulan.FirstOrDefault(item2 => item2.Key == item.Value.ToInt()) != null ? ForecastBulan.FirstOrDefault(item2 => item2.Key == item.Value.ToInt()).Quantity : 0,
Weekend = 1 //BUKAN WEEKEND
});
TextBoxTotalNominal.Text = Result.Sum(item => item.Nominal).ToString();
TextBoxTotalQuantity.Text = Result.Sum(item => item.Quantity).ToString();
RepeaterForecastBulan.DataSource = Result;
RepeaterForecastBulan.DataBind();
}
else if (DropDownListTipe.SelectedValue == "2")
{
var ForecastBulan = db.TBForecasts
.Where(item =>
item.IDTempat == idTempat &&
item.Tanggal.Month == bulan &&
item.Tanggal.Year == tahun)
.Select(item => new
{
Key = item.Tanggal.Day,
Nominal = item.Nominal,
Quantity = item.Quantity
});
var Result = Tanggal_Class.DropDownListHariBulan(tahun, bulan)
.Select(item => new
{
Key = item.Value,
Nama = item.Text,
Nominal = ForecastBulan.FirstOrDefault(item2 => item2.Key == item.Value.ToInt()) != null ? ForecastBulan.FirstOrDefault(item2 => item2.Key == item.Value.ToInt()).Nominal : 0,
Quantity = ForecastBulan.FirstOrDefault(item2 => item2.Key == item.Value.ToInt()) != null ? ForecastBulan.FirstOrDefault(item2 => item2.Key == item.Value.ToInt()).Quantity : 0,
Weekend = new DateTime(tahun, bulan, item.Value.ToInt()).DayOfWeek
});
TextBoxTotalNominal.Text = Result.Sum(item => item.Nominal).ToString();
TextBoxTotalQuantity.Text = Result.Sum(item => item.Quantity).ToString();
RepeaterForecastBulan.DataSource = Result;
RepeaterForecastBulan.DataBind();
}
}
}