private void LoadData(bool GenerateExcel)
{
//DEFAULT
TextBoxTanggalAwal.Text = ((DateTime)ViewState["TanggalAwal"]).ToString("d MMMM yyyy");
TextBoxTanggalAkhir.Text = ((DateTime)ViewState["TanggalAkhir"]).ToString("d MMMM yyyy");
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
BusinessIntelligence_Class ClassLaporan = new BusinessIntelligence_Class(db, (PenggunaLogin)Session["PenggunaLogin"], (DateTime)ViewState["TanggalAwal"], (DateTime)ViewState["TanggalAkhir"], GenerateExcel);
List <int> ListIDGrupPelanggan = new List <int>();
foreach (ListItem item in ListBoxGrupPelanggan.Items)
{
if (item.Selected)
{
ListIDGrupPelanggan.Add(Parse.Int(item.Value));
}
}
var Result = ClassLaporan.CustomerLocation(ListIDGrupPelanggan);
#region KONFIGURASI LAPORAN
LabelPeriode.Text = ClassLaporan.Periode;
////////////LinkDownload.Visible = GenerateExcel;
////////////if (LinkDownload.Visible)
//////////// LinkDownload.HRef = ClassLaporan.LinkDownload;
////////////ButtonPrint.OnClientClick = "return popitup('Print.aspx" + ClassLaporan.TempPencarian + "')";
#endregion
LabelBaruJumlahTransaksi.Text = Result["BaruJumlahTransaksi"];
LabelBaruJumlahProduk.Text = Result["BaruJumlahProduk"];
LabelBaruGrandtotal.Text = Result["BaruGrandtotal"];
LabelLamaJumlahTransaksi.Text = Result["LamaJumlahTransaksi"];
LabelLamaJumlahProduk.Text = Result["LamaJumlahProduk"];
LabelLamaGrandtotal.Text = Result["LamaGrandtotal"];
RepeaterLaporanGrupPelanggan.DataSource = Result["DataGrupPelanggan"];
RepeaterLaporanGrupPelanggan.DataBind();
LabelTotalGrupPelangganJumlahTransaksi.Text = Result["TotalGrupPelangganJumlahTransaksi"];
LabelTotalGrupPelangganJumlahProduk.Text = Result["TotalGrupPelangganJumlahProduk"];
LabelTotalGrupPelangganGrandtotal.Text = Result["TotalGrupPelangganGrandtotal"];
RepeaterLaporanPelanggan.DataSource = Result["DataPelanggan"];
RepeaterLaporanPelanggan.DataBind();
LabelTotalPelangganJumlahTransaksi.Text = Result["TotalPelangganJumlahTransaksi"];
LabelTotalPelangganJumlahProduk.Text = Result["TotalPelangganJumlahProduk"];
LabelTotalPelangganGrandtotal.Text = Result["TotalPelangganGrandtotal"];
RepeaterLaporanKota.DataSource = Result["DataKota"];
RepeaterLaporanKota.DataBind();
LabelTotalKotaJumlahTransaksi.Text = Result["TotalKotaJumlahTransaksi"];
LabelTotalKotaJumlahProduk.Text = Result["TotalKotaJumlahProduk"];
LabelTotalKotaGrandtotal.Text = Result["TotalKotaGrandtotal"];
RepeaterLaporanProvinsi.DataSource = Result["DataProvinsi"];
RepeaterLaporanProvinsi.DataBind();
LabelTotalProvinsiJumlahTransaksi.Text = Result["TotalProvinsiJumlahTransaksi"];
LabelTotalProvinsiJumlahProduk.Text = Result["TotalProvinsiJumlahProduk"];
LabelTotalProvinsiGrandtotal.Text = Result["TotalProvinsiGrandtotal"];
}
}
protected void RepeaterLaporan_ItemCommand(object source, RepeaterCommandEventArgs e)
{
List <int> ListIDGrupPelanggan = new List <int>();
foreach (ListItem item in ListBoxGrupPelanggan.Items)
{
if (item.Selected)
{
ListIDGrupPelanggan.Add(Parse.Int(item.Value));
}
}
if (e.CommandName == "Pelanggan")
{
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
TBPelanggan pelanggan = db.TBPelanggans.FirstOrDefault(item => item.IDPelanggan == Parse.Int(e.CommandArgument.ToString()));
LabelDetailJudul.Text = "Pelanggan " + pelanggan.NamaLengkap.ToUpper();
BusinessIntelligence_Class ClassLaporan = new BusinessIntelligence_Class(db, (PenggunaLogin)Session["PenggunaLogin"], (DateTime)ViewState["TanggalAwal"], (DateTime)ViewState["TanggalAkhir"], false);
var Result = ClassLaporan.CustomerDetailTransaksiProduk(ListIDGrupPelanggan, Parse.Int(e.CommandArgument.ToString()), "Pelanggan");
RepeaterLaporanDetailTransaksi.DataSource = Result["HasilTransaksi"];
RepeaterLaporanDetailTransaksi.DataBind();
RepeaterLaporanDetailProduk.DataSource = Result["HasilProduk"];
RepeaterLaporanDetailProduk.DataBind();
}
DivKota.Visible = false;
DivProvinsi.Visible = false;
DivDetail.Visible = true;
PanelDetail.Attributes.Add("class", "panel panel-success");
}
else if (e.CommandName == "Kota")
{
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
TBWilayah pelanggan = db.TBWilayahs.FirstOrDefault(item => item.IDWilayah == Parse.Int(e.CommandArgument.ToString()));
LabelDetailJudul.Text = "Kota " + pelanggan.Nama.ToUpper();
BusinessIntelligence_Class ClassLaporan = new BusinessIntelligence_Class(db, (PenggunaLogin)Session["PenggunaLogin"], (DateTime)ViewState["TanggalAwal"], (DateTime)ViewState["TanggalAkhir"], false);
var Result = ClassLaporan.CustomerDetailTransaksiProduk(ListIDGrupPelanggan, Parse.Int(e.CommandArgument.ToString()), "Kota");
RepeaterLaporanDetailTransaksi.DataSource = Result["HasilTransaksi"];
RepeaterLaporanDetailTransaksi.DataBind();
RepeaterLaporanDetailProduk.DataSource = Result["HasilProduk"];
RepeaterLaporanDetailProduk.DataBind();
}
DivPelanggan.Visible = false;
DivProvinsi.Visible = false;
DivDetail.Visible = true;
PanelDetail.Attributes.Add("class", "panel panel-info");
}
else if (e.CommandName == "Provinsi")
{
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
TBWilayah pelanggan = db.TBWilayahs.FirstOrDefault(item => item.IDWilayah == Parse.Int(e.CommandArgument.ToString()));
LabelDetailJudul.Text = "Provinsi " + pelanggan.Nama.ToUpper();
BusinessIntelligence_Class ClassLaporan = new BusinessIntelligence_Class(db, (PenggunaLogin)Session["PenggunaLogin"], (DateTime)ViewState["TanggalAwal"], (DateTime)ViewState["TanggalAkhir"], false);
var Result = ClassLaporan.CustomerDetailTransaksiProduk(ListIDGrupPelanggan, Parse.Int(e.CommandArgument.ToString()), "Provinsi");
RepeaterLaporanDetailTransaksi.DataSource = Result["HasilTransaksi"];
RepeaterLaporanDetailTransaksi.DataBind();
RepeaterLaporanDetailProduk.DataSource = Result["HasilProduk"];
RepeaterLaporanDetailProduk.DataBind();
}
DivPelanggan.Visible = false;
DivKota.Visible = false;
DivDetail.Visible = true;
PanelDetail.Attributes.Add("class", "panel panel-warning");
}
}
