public List <BagiShuDto> GetAllByTahun(int Tahun)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
conn = DBConnection.connect();
List <BagiShuDto> ListDto = new List <BagiShuDto>();
using (OleDbCommand _command = new OleDbCommand())
{
_command.CommandType = CommandType.Text;
_command.Connection = conn;
_command.CommandText = "Select * from BAGI_SHU where periode=@Periode";
using (OleDbDataReader _dr = _command.ExecuteReader())
{
DataTable _dt = new DataTable();
_dt.Load(_dr);
foreach (DataRow row in _dt.AsEnumerable())
{
var Dto = new BagiShuDto();
Dto.Id = Convert.ToInt64(row["id"]);
Dto.IdAnggota = Convert.ToString(row["id_anggota"]);
Dto.NamaAnggota = Convert.ToString(row["nama_anggota"]);
Dto.Jma = Convert.ToDouble(row["JMA"]);
Dto.Jua = Convert.ToDouble(row["JUA"]);
Dto.Jpa = Convert.ToDouble(row["JPA"]);
Dto.ModifiedBy = Convert.ToString(row["modified_by"]);
Dto.ModifiedDate = Convert.ToDateTime(row["modified_date"]);
Dto.CreatedBy = Convert.ToString(row["created_by"]);
Dto.CreatedDate = Convert.ToDateTime(row["created_date"]);
Dto.Periode = Convert.ToInt32(row["periode"]);
Dto.Status = Convert.ToBoolean(row["status"]);
Dto.TotalShu = Convert.ToInt64(row["total_SHU"]);
ListDto.Add(Dto);
}
}
}
return(ListDto);
}
public void Insert(BagiShuDto Dto)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
conn = DBConnection.connect();
using (OleDbCommand _command = new OleDbCommand())
{
_command.CommandType = CommandType.Text;
_command.Connection = conn;
_command.CommandText = "DELETE FROM BAGI_SHU WHERE periode=@Periode; ";
_command.Parameters.AddWithValue("@periode", Dto.Periode);
_command.ExecuteNonQuery();
_command.Connection = conn;
_command.CommandText = "INSERT INTO BAGI_SHU " +
"(id_anggota, JMA, JUA, total_SHU, total_simpanan, total_belanja, total_bungapinjaman, periode, created_date, created_by, modified_date, modified_by,status) " +
"VALUES (@id_anggota, @JMA, @JUA, @JPA, @total_SHU, @total_simpanan, @total_belanja, @total_bungapinjaman, @periode, @created_date, @created_by, @modified_date, @modified_by, @status);";
_command.Parameters.AddWithValue("@id_anggota", Dto.IdAnggota);
_command.Parameters.AddWithValue("@JMA", Dto.Jma);
_command.Parameters.AddWithValue("@JUA", Dto.Jua);
_command.Parameters.AddWithValue("@JPA", Dto.Jpa);
_command.Parameters.AddWithValue("@total_SHU", Dto.TotalShu);
_command.Parameters.AddWithValue("@total_simpanan", Dto.TotalSimpanan);
_command.Parameters.AddWithValue("@total_belanja", Dto.TotalBelanja);
_command.Parameters.AddWithValue("@total_bungapinjaman", Dto.TotalBungaPinjaman);
_command.Parameters.AddWithValue("@periode", Dto.Periode);
_command.Parameters.AddWithValue("@created_date", DateTime.Now);
_command.Parameters.AddWithValue("@created_by", "Admin");
_command.Parameters.AddWithValue("@modified_date", DateTime.Now);
_command.Parameters.AddWithValue("@modified_by", "Admin");
_command.Parameters.AddWithValue("@status", true);
_command.ExecuteNonQuery();
}
}
public Window_BagiShuAnggota(BagiShuDto Dto)
{
InitializeComponent();
Data = Dto;
}
public List <BagiShuDto> HitungAllShu(int Tahun)
{
try
{
var ListBagiShuDto = new List <BagiShuDto>();
var GetDataShu = _dataKoperasiServices.GetByTahun(Tahun);
var GetAllDataAnggota = _dataAnggotaServices.GetAllActive();
foreach (var item in GetAllDataAnggota)
{
var Dto = new BagiShuDto();
Dto.IdAnggota = item.IdAnggota;
Dto.NamaAnggota = item.NamaAnggota;
Dto.Periode = Tahun;
var GetAllIpt = _iptAnggotaServices.GetAllByIdAnggotaDanTahun(Dto.IdAnggota, Tahun);
if (GetAllIpt.Count > 0)
{
#region hitung JMA
try
{
var Pokok = GetAllIpt.FirstOrDefault().Pokok;
var Wajib = GetAllIpt.Sum(x => x.Wajib);
var Sukarela = GetAllIpt.Sum(x => x.Sukarela);
Dto.TotalSimpanan = Pokok + Wajib + Sukarela;
Dto.Jma = (Dto.TotalSimpanan / GetDataShu.TotalSimpanan) * (double)0.2 * GetDataShu.TotalShu;
}
catch (Exception)
{
throw;
}
#endregion
#region hitung JUA
try
{
Dto.TotalBelanja = GetAllIpt.Sum(x => x.Belanja);
Dto.Jua = (Dto.TotalBelanja / GetDataShu.TotalPenjualan) * (double)0.1 * GetDataShu.TotalShu;
}
catch (Exception)
{
throw;
}
#endregion
#region hitung JPA
try
{
Dto.TotalBungaPinjaman = GetAllIpt.Sum(x => x.BungaPinjaman);
Dto.Jpa = (Dto.TotalBungaPinjaman / GetDataShu.TotalPinjaman) * (double)0.1 * GetDataShu.TotalShu;
}
catch (Exception)
{
throw;
}
Dto.TotalShu = Dto.Jma + Dto.Jpa + Dto.Jua;
ListBagiShuDto.Add(Dto);
#endregion
}
}
return(ListBagiShuDto);
}
catch (Exception)
{
throw;
}
}
