public void PopulateData(DataKoperasiDto data) { Id.Text = data.Id.ToString(); total_shu.Text = data.TotalShu.ToString(); total_simpanan.Text = data.TotalSimpanan.ToString(); total_belanja.Text = data.TotalPenjualan.ToString(); total_pinjaman.Text = data.TotalPinjaman.ToString(); CreatedBy.Text = data.CreatedBy; CreatedDate.Text = data.CreatedDate.ToString("yyyy-MM-dd HH:mm:ss"); ModifiedBy.Text = data.ModifiedBy; ModifiedDate.Text = data.ModifiedDate.ToString("yyyy-MM-dd HH:mm:ss"); }
public DataKoperasiDto InserOrUpdate(DataKoperasiDto Dto) { if (Dto.Id == 0) { Dto = Insert(Dto); } else { Dto = Update(Dto); } return(Dto); }
public DataKoperasiDto Insert(DataKoperasiDto Dto) { try { if (conn.State == ConnectionState.Open) { conn.Close(); } conn = DBConnection.connect(); using (OleDbCommand _command = new OleDbCommand()) { _command.CommandType = CommandType.Text; _command.Connection = conn; _command.CommandText = "INSERT INTO DATA_KOPERASI " + "(tahun, total_shu, total_simpanan, total_penjualan, total_pinjaman, created_date, created_by, modified_date, modified_by) " + "VALUES (@Tahun, @TotalShu, @TotalSimpanan, @TotalPenjualan, @TotalPinjaman, @created_date, @created_by, @modified_date, @modified_by);"; _command.Parameters.AddWithValue("@Tahun", Dto.Tahun); _command.Parameters.AddWithValue("@TotalShu", Dto.TotalShu); _command.Parameters.AddWithValue("@TotalSimpanan", Dto.TotalSimpanan); _command.Parameters.AddWithValue("@TotalPenjualan", Dto.TotalPenjualan); _command.Parameters.AddWithValue("@TotalPinjaman", Dto.TotalPinjaman); _command.Parameters.AddWithValue("@created_date", DateTime.Today); _command.Parameters.AddWithValue("@created_by", "Admin"); _command.Parameters.AddWithValue("@modified_date", DateTime.Today); _command.Parameters.AddWithValue("@modified_by", "Admin"); _command.ExecuteNonQuery(); string query2 = "Select @@Identity"; _command.CommandText = query2; int ID = (int)_command.ExecuteScalar(); Dto.CreatedBy = "Admin"; Dto.CreatedDate = DateTime.Today; Dto.ModifiedBy = "Admin"; Dto.ModifiedDate = DateTime.Today; Dto.Id = ID; return(Dto); } } catch (Exception) { throw; } }
public DataKoperasiDto Update(DataKoperasiDto Dto) { try { if (conn.State == ConnectionState.Open) { conn.Close(); } conn = DBConnection.connect(); var GetData = GetById(Dto.Id); using (OleDbCommand _command = new OleDbCommand()) { _command.CommandType = CommandType.Text; _command.Connection = conn; _command.CommandText = "Update DATA_KOPERASI " + "SET tahun =@Tahun, total_shu =@TotalShu, total_simpanan =@TotalSimpanan, total_penjualan=@TotalPenjualan, total_pinjaman=@TotalPinjaman, created_date=@created_date, created_by=@created_by, modified_date=@modified_date, modified_by=@modified_by WHERE id = @Id;"; _command.Parameters.AddWithValue("@Tahun", Dto.Tahun); _command.Parameters.AddWithValue("@TotalShu", Dto.TotalShu); _command.Parameters.AddWithValue("@TotalSimpanan", Dto.TotalSimpanan); _command.Parameters.AddWithValue("@TotalPenjualan", Dto.TotalPenjualan); _command.Parameters.AddWithValue("@TotalPinjaman", Dto.TotalPinjaman); _command.Parameters.AddWithValue("@created_date", GetData.CreatedDate); _command.Parameters.AddWithValue("@created_by", GetData.CreatedBy); _command.Parameters.AddWithValue("@modified_date", DateTime.Today); _command.Parameters.AddWithValue("@modified_by", "Admin"); _command.Parameters.AddWithValue("@Id", Dto.Id); _command.ExecuteNonQuery(); Dto.ModifiedDate = DateTime.Today; Dto.ModifiedBy = "Admin"; return(Dto); } } catch (Exception) { throw; } }
public DataKoperasiDto GetById(long Id) { if (conn.State == ConnectionState.Open) { conn.Close(); } conn = DBConnection.connect(); DataKoperasiDto Dto = null; using (OleDbCommand _command = new OleDbCommand()) { _command.CommandType = CommandType.Text; _command.Connection = conn; _command.CommandText = "Select * from DATA_KOPERASI WHERE ID = @Id"; _command.Parameters.AddWithValue("@Id", Id); using (OleDbDataReader _dr = _command.ExecuteReader()) { DataTable _dt = new DataTable(); _dt.Load(_dr); foreach (DataRow row in _dt.AsEnumerable()) { Dto = new DataKoperasiDto(); Dto.Id = Convert.ToInt64(row["id"]); Dto.Tahun = Convert.ToInt32(row["tahun"]); Dto.TotalShu = Convert.ToDouble(row["total_shu"]); Dto.TotalSimpanan = Convert.ToDouble(row["total_simpanan"]); Dto.TotalPenjualan = Convert.ToDouble(row["total_penjualan"]); Dto.TotalPinjaman = Convert.ToDouble(row["total_pinjaman"]); Dto.CreatedBy = Convert.ToString(row["created_by"]); Dto.CreatedDate = Convert.ToDateTime(row["created_date"]); Dto.ModifiedDate = Convert.ToDateTime(row["modified_date"]); Dto.ModifiedBy = Convert.ToString(row["modified_by"]); } } } return(Dto); }
private void BtnSimpan_Click(object sender, RoutedEventArgs e) { try { var Dto = new DataKoperasiDto(); if (string.IsNullOrEmpty(total_shu.Text)) { System.Windows.MessageBox.Show("Total SHU tidak boleh kosong", "Info", MessageBoxButton.OK, MessageBoxImage.Information); return; } if (string.IsNullOrEmpty(total_belanja.Text)) { total_belanja.Text = "0"; } if (string.IsNullOrEmpty(total_simpanan.Text)) { total_simpanan.Text = "0"; } if (string.IsNullOrEmpty(total_pokok.Text)) { total_pokok.Text = "0"; } if (string.IsNullOrEmpty(total_wajib.Text)) { total_wajib.Text = "0"; } if (string.IsNullOrEmpty(total_sukarela.Text)) { total_sukarela.Text = "0"; } if (string.IsNullOrEmpty(total_pinjaman.Text)) { total_pinjaman.Text = "0"; } if (!string.IsNullOrEmpty(Id.Text)) { Dto.Id = Convert.ToInt32(Id.Text); } Dto.Tahun = Convert.ToInt32(Tahun.Text); Dto.TotalShu = Convert.ToDouble(total_shu.Text); Dto.TotalPenjualan = Convert.ToDouble(total_belanja.Text); Dto.TotalPinjaman = Convert.ToDouble(total_pinjaman.Text); Dto.TotalSimpanan = Convert.ToDouble(total_simpanan.Text); _dataKoperasiServices.InserOrUpdate(Dto); PopulateData(Dto); System.Windows.MessageBox.Show("Data sudah tersimpan", "Info", MessageBoxButton.OK, MessageBoxImage.Information); } catch (Exception ex) { LogError.WriteError(ex); System.Windows.MessageBox.Show("Error!! \n telah terjadi kesalahan, Hubungi administrator", "Error", MessageBoxButton.OK, MessageBoxImage.Error); } }