protected void ButtonExcel_Click(object sender, EventArgs e)
{
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
PenggunaLogin pengguna = (PenggunaLogin)Session["PenggunaLogin"];
Excel_Class Excel_Class = new Excel_Class(pengguna, "Neraca", DropDownListBulan.SelectedItem.Text + " " + DropDownListTahun.SelectedItem.Text, 4);
var result = new Excel_Class(pengguna, "Neraca", DropDownListBulan.SelectedItem.Text + " " + DropDownListTahun.SelectedItem.Text, 4);
ExcelWorksheet Worksheet = Excel_Class.Worksheet;
Excel_Class.Header(1, "No");
Excel_Class.Header(2, "Kode");
Excel_Class.Header(3, "Nama");
Excel_Class.Header(4, "Nominal");
Excel_Class.SetBackground(1, 1, Color.Black);
Excel_Class.SetBackground(1, 2, Color.Black);
Excel_Class.SetBackground(1, 3, Color.Black);
Excel_Class.SetBackground(1, 4, Color.Black);
Excel_Class.SetColor(1, 1, Color.White);
Excel_Class.SetColor(1, 2, Color.White);
Excel_Class.SetColor(1, 3, Color.White);
Excel_Class.SetColor(1, 4, Color.White);
int index = 2;
foreach (var item in LoadNeraca(db))
{
if (item.TBAkunGrup == null)
{
Excel_Class.SetBackground(index, 1, Color.LightGreen);
Excel_Class.SetBackground(index, 2, Color.LightGreen);
Excel_Class.SetBackground(index, 3, Color.LightGreen);
Excel_Class.SetBackground(index, 4, Color.LightGreen);
Excel_Class.SetColor(index, 1, Color.Black);
Excel_Class.SetColor(index, 2, Color.Black);
Excel_Class.SetColor(index, 3, Color.Black);
Excel_Class.SetColor(index, 4, Color.Black);
}
else
{
if (item.Grup == true)
{
Excel_Class.SetBackground(index, 1, Color.LightYellow);
Excel_Class.SetBackground(index, 2, Color.LightYellow);
Excel_Class.SetBackground(index, 3, Color.LightYellow);
Excel_Class.SetBackground(index, 4, Color.LightYellow);
Excel_Class.SetColor(index, 1, Color.Black);
Excel_Class.SetColor(index, 2, Color.Black);
Excel_Class.SetColor(index, 3, Color.Black);
Excel_Class.SetColor(index, 4, Color.Black);
}
}
Excel_Class.Content(index, 1, item.Nomor.Replace(" ", ""));
Excel_Class.Content(index, 2, item.Grup == true ? string.Empty : item.Kode);
Excel_Class.Content(index, 3, item.Nama);
Excel_Class.Content(index, 4, item.Grup == true ? string.Empty : item.Nominal.ToString());
index++;
}
List <ListAkun> listAkun = new List <ListAkun>();
var result2 = db.TBAkunGrups.Where(item => item.IDAkunGrupParent == null &&
(item.IDAkunGrup != 4 && item.IDAkunGrup != 5)).ToArray();
//CARI AKUN GRUP
CariAkunGrup("1", result2, listAkun);
var dataBulanIni = Akuntansi_Class.LaporanLabaRugi(DropDownListBulan.SelectedItem.Value, DropDownListTahun.SelectedItem.Value, false, pengguna, "");
var dataBulanSebelumnya = Akuntansi_Class.LaporanLabaRugi(((DropDownListBulan.SelectedItem.Value).ToInt() - 1).ToString(), DropDownListTahun.SelectedItem.Value, false, pengguna, "");
decimal LabaRugiBerjalan = dataBulanIni["TotalLabaRugi"];
decimal LabaRugiBulanSebelumnya = dataBulanSebelumnya["TotalLabaRugi"];
Excel_Class.Content(index, 1, "Laba Rugi Bulan Berjalan");
Excel_Class.Content(index, 2, "");
Excel_Class.Content(index, 3, "");
Excel_Class.Content(index, 4, LabaRugiBerjalan);
Excel_Class.Content(index + 1, 1, "Laba Rugi Bulan Sebelumnya");
Excel_Class.Content(index + 1, 2, "");
Excel_Class.Content(index + 1, 3, "");
Excel_Class.Content(index + 1, 4, LabaRugiBulanSebelumnya);
Excel_Class.Save();
LinkDownload.Visible = true;
ButtonExcel.Visible = false;
if (LinkDownload.Visible)
{
LinkDownload.HRef = Excel_Class.LinkDownload;
}
}
}
