private void FormDaftarPermintaan_Load(object sender, EventArgs e)
{
this.Location = new Point(0, 0);
comboBoxCari.DropDownStyle = ComboBoxStyle.DropDownList;
labelLabaRugi.Text = Laporan.HitungLabaRugi().ToString("0,###");
labelTotalHarga.Text = Laporan.HitungEkuitasAkhir().ToString("0,###");
labelEkuitasAwal.Text = Laporan.TampilkanModalAwal().ToString("0,###");
FormatDataGrid();
string hasilBaca = Laporan.BacaDataEkuitas("", "", listHasilData);
if (hasilBaca == "1")
{
dataGridViewEkuitas.Rows.Clear();
for (int i = 0; i < listHasilData.Count; i++)
{
int saldo = int.Parse(listHasilData[i].Periode.IdPeriode);
dataGridViewEkuitas.Rows.Add(
listHasilData[i].IdLaporan,
listHasilData[i].Judul,
saldo.ToString("RP 0,###")
);
//labelEkuitasAwal.Text = saldo.ToString("0,###");
}
}
}
private void FormLaporanNeraca_Load(object sender, EventArgs e)
{
this.Location = new Point(0, 0);
comboBoxCari.DropDownStyle = ComboBoxStyle.DropDownList;
labelTotalHutang.Text = Laporan.tampilHutang().ToString("0,###");
labelTotalEkuitas.Text = Laporan.HitungEkuitasAkhir().ToString("0,###");
labelAktiva.Text = Laporan.HitungTotalAktiva().ToString("0,###");
labelPasiva.Text = Laporan.HitungTotalPasiva().ToString("0,###");
FormatDataGrid();
string hasilBaca = Laporan.BacaDataNeraca("", "", listHasilData);
if (hasilBaca == "1")
{
dataGridViewNeraca.Rows.Clear();
for (int i = 0; i < listHasilData.Count; i++)
{
int saldo = int.Parse(listHasilData[i].Periode.IdPeriode);
dataGridViewNeraca.Rows.Add(
listHasilData[i].IdLaporan,
listHasilData[i].Judul,
saldo.ToString("0,###")
);
}
}
}
private void FormLaporanLabaRugi_Load(object sender, EventArgs e)
{
this.Location = new Point(0, 0);
comboBoxCari.DropDownStyle = ComboBoxStyle.DropDownList;
labelTotalHarga.Text = Laporan.HitungLabaRugi().ToString("0,###");
labelTotalPendapatan.Text = Laporan.HitungTotalPendapatan().ToString("0,###");
labelTotalBiaya.Text = Laporan.HitungTotalBiaya().ToString("0,###");
FormatDataGrid();
string hasilBaca = Laporan.BacaDataLabaRugi("", "", listHasilData);
if (hasilBaca == "1")
{
dataGridViewLabaRugi.Rows.Clear();
for (int i = 0; i < listHasilData.Count; i++)
{
int saldo = int.Parse(listHasilData[i].Periode.IdPeriode);
dataGridViewLabaRugi.Rows.Add(
listHasilData[i].IdLaporan,
listHasilData[i].Judul,
saldo.ToString("0,###"));
}
}
}
private void button1_Click_1(object sender, EventArgs e)
{
if (dgKritik.CurrentRow.Index != -1)
{
Laporan laporan = new Laporan();
laporan.Id = Convert.ToInt32(dgKritik.CurrentRow.Cells["Id"].Value);
ModelContext db = new ModelContext();
laporan = db.Laporan.
Where(x => x.Id == laporan.Id).
FirstOrDefault();
var entry = db.Entry(laporan);
if (entry.State == System.Data.Entity.EntityState.Detached)
{
db.Laporan.Attach(laporan);
}
db.Laporan.Remove(laporan);
db.SaveChanges();
var query =
(from data in db.Laporan
select data).ToList();
dgKritik.DataSource = query;
MessageBox.Show("Data terhapus");
}
else
{
MessageBox.Show("Silakan pilih data yang akan dihapus");
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
//conn.Open();
//SqlCommand cmd = new SqlCommand("insert into Laporan (Nama, Email, Kritik) values(@1,@2,@3)", conn);
//cmd.Parameters.AddWithValue("@1", tbNama.Text);
//cmd.Parameters.AddWithValue("@2", tbEmail.Text);
//cmd.Parameters.AddWithValue("@3", tbReport.Text);
//cmd.ExecuteScalar();
//conn.Close();
if (tbNama.Text != "" && tbEmail.Text != "" && tbReport.Text != "")
{
using (ModelContext db = new ModelContext())
{
Laporan laporan = new Laporan()
{
Nama = tbNama.Text,
Email = tbEmail.Text,
Kritik = tbReport.Text,
Tanggal = DateTime.Now
};
db.Laporan.Add(laporan);
db.SaveChanges();
MessageBox.Show("Terimakasih telah melaporkan bug ini");
}
}
else
{
MessageBox.Show("Nama, Email, dan Kritik harus diisi");
}
}
public Laporan Perizinan(DateTime date, DateTime last, int PegawaiId)
{
using (var db = new OcphDbContext())
{
Laporan lap = new Laporan(1 + (int)last.Subtract(date).TotalDays);
for (DateTime tgl = date; tgl <= last; tgl = tgl.AddDays(1))
{
if (tgl.DayOfWeek != DayOfWeek.Sunday || tgl.DayOfWeek != DayOfWeek.Saturday)
{
var result = db.Perizinan.Where(O => O.PegawaiId == PegawaiId && O.Mulai <= tgl && O.Selesai >= tgl).FirstOrDefault();
if (result != null)
{
switch (result.Jenis)
{
case StatusKehadiran.Izin:
lap.Izin++;
break;
case StatusKehadiran.Sakit:
lap.Sakit++;
break;
case StatusKehadiran.Cuti:
lap.Cuti++;
break;
case StatusKehadiran.TugasBelajar:
lap.TugasBelajar++;
break;
case StatusKehadiran.DinasLuar:
lap.DinasLuar++;
break;
case StatusKehadiran.TugasKedinasan:
lap.TugasKedinasan++;
break;
default:
break;
}
}
}
}
return(lap);
}
}
public Laporan Perizinan(DateTime date, int PegawaiId)
{
using (var db = new OcphDbContext())
{
Laporan lap = new Laporan(1);
var result = db.Perizinan.Where(O => O.PegawaiId == PegawaiId && O.Mulai <= date && O.Selesai >= date);
if (result != null)
{
foreach (var item in result)
{
switch (item.Jenis)
{
case StatusKehadiran.Izin:
lap.Izin++;
break;
case StatusKehadiran.Sakit:
lap.Sakit++;
break;
case StatusKehadiran.Cuti:
lap.Cuti++;
break;
case StatusKehadiran.TugasBelajar:
lap.TugasBelajar++;
break;
case StatusKehadiran.DinasLuar:
lap.DinasLuar++;
break;
case StatusKehadiran.TugasKedinasan:
lap.TugasKedinasan++;
break;
default:
break;
}
}
}
return(lap);
}
}
private void buttonCetak_Click(object sender, EventArgs e)
{
int hasil = Laporan.TampilkanModalAwal() + Laporan.HitungLabaRugi();
string bulan = DateTime.Now.Month.ToString();
string tahun = DateTime.Now.Year.ToString();
string periode = "Periode 1 " + bulan + " " + tahun + " s/d " + " 30 " + bulan + " " + tahun;
StreamWriter file = new StreamWriter("Laporan_Ekuitas.txt");
//Header
file.WriteLine("");
file.WriteLine("".PadRight(21) + "LAPORAN EKUITAS");
file.WriteLine("".PadRight(21) + "\"Bagoes Bangets\"");
file.WriteLine("".PadRight(13) + periode);
file.WriteLine("");
file.WriteLine("");
file.Write("".PadRight(5, ' ') + "Ekuitas Pemilik per awal periode".PadRight(38, ' '));
file.Write(labelEkuitasAwal.Text.PadLeft(12, ' '));
file.WriteLine("");
file.Write("".PadRight(5, ' ') + "Laba Rugi Tahun Berjalan".PadRight(38, ' '));
file.Write(Laporan.HitungLabaRugi().ToString("0,###").PadLeft(12, ' '));
file.WriteLine("");
file.WriteLine("=".PadRight(55, '='));
file.Write("".PadRight(5, ' ') + "Ekuitas setelah Laba Rugi".PadRight(38, ' '));
file.Write(hasil.ToString("0,###").PadLeft(12, ' '));
file.WriteLine("");
file.WriteLine("");
file.Write("".PadRight(5, ' ') + "Penarikan ekuitas pemilik".PadRight(38, ' '));
file.Write("0".PadLeft(12, ' '));
file.WriteLine("");
file.WriteLine("=".PadRight(55, '='));
file.WriteLine("");
file.Write("".PadRight(5, ' ') + "Ekuitas pemilik per akhir periode".PadRight(38, ' '));
file.Write(hasil.ToString("0,###").PadLeft(12, ' '));
file.WriteLine("");
file.Close();
MessageBox.Show("Berhasil cetak laporan Ekuitas", "info");
}
public void FormDaftarPelanggan_Load(object sender, EventArgs e)
{
this.Location = new Point(0, 0);
comboBoxCari.DropDownStyle = ComboBoxStyle.DropDownList;
FormatDataGrid();
string hasilBaca = Laporan.BacaDataBukuBesar("", "", listHasilData);
if (hasilBaca == "1")
{
dataGridViewBukuBesar.Rows.Clear();
for (int i = 0; i < listHasilData.Count; i++)
{
int total = int.Parse(listHasilData[i].Periode.IdPeriode);
dataGridViewBukuBesar.Rows.Add(
listHasilData[i].IdLaporan,
listHasilData[i].Judul,
total.ToString("RP 0,###") // isinya saldo akhir
);
}
}
}
