public async Task <long> DeletePost(long ID, string username)
{
int result = 0;
if (db != null)
{
//Find the warna for specific warna id
Barang barang = await db.Barang.FirstOrDefaultAsync(x => x.Id == ID);
if (barang != null)
{
barang.Modified = DateTime.Now;
barang.ModifiedBy = username;
barang.RowStatus = false;
//Commit the transaction
result = await db.SaveChangesAsync();
}
return(result);
}
return(result);
}
private void txtKodeBarang_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
Barang obj = getDataBarang(txtKodeBarang.Text.Trim());
txtNamaBarang.Text = obj.NamaBarang;
txtJenisBarang.Text = obj.JenisBarang;
txtBeratBarang.Text = obj.BeratBarang.ToString();
if (Int32.Parse(txtBeratBarang.Text) == 1)
{
txtOngkosKirim.Text = "5000";
}
else if (Int32.Parse(txtBeratBarang.Text) >= 2 && Int32.Parse(txtBeratBarang.Text) <= 5)
{
txtOngkosKirim.Text = "20000";
}
else if (Int32.Parse(txtBeratBarang.Text) >= 5)
{
txtOngkosKirim.Text = "50000";
}
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
listHasilData.Clear();
string hasil = Barang.BacaData("kode", comboBoxKodeBarang.Text, listHasilData);
if (hasil == "1")
{
if (listHasilData.Count > 0)
{
textBoxNama.Text = listHasilData[0].Nama;
textBoxSatuan.Text = listHasilData[0].Satuan;
numericUpDownJumlah.Value = listHasilData[0].Jumlah;
numericUpDownHargaSatuan.Value = listHasilData[0].HargaSatuan;
textBoxKeterangan.Text = listHasilData[0].Keterangan;
if (File.Exists(Application.StartupPath + "\\Images\\Barang\\" + comboBoxKodeBarang.Text + ".jpg"))
{
Image s = GetCopyImage(Application.StartupPath + "\\Images\\Barang\\" + comboBoxKodeBarang.Text + ".jpg");
pictureBox1.BackgroundImage = s;
}
//textBoxIdOrder.Text = listHasilData[0].OrderPenjualan.NoOrder;
textBoxNama.Focus();
}
}
else
{
textBoxIdOrder.Text = "";
textBoxKeterangan.Text = "";
textBoxSatuan.Text = "";
textBoxNama.Text = "";
numericUpDownJumlah.Value = 0;
numericUpDownHargaSatuan.Value = 0;
}
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
}
public IActionResult EditPost(string id, Barang brg)
{
/*
* byref vs byval
* int a = 10;
* int b = a;
* b = 12;
*
* Barang b1 = new Barang();
* b1.HargaJual = 1000;
* Barang b2 = b1;
* b2.HargaJual = 500;*/
var barang = GetById(id);
barang.NamaBarang = brg.NamaBarang;
barang.Stok = brg.Stok;
barang.HargaJual = brg.HargaJual;
barang.Tanggal = brg.Tanggal;
return(RedirectToAction("Index"));
}
private void btnAdd_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("Do You Want to Save Data?", "Simpan Data", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
try
{
Barang obj = new Barang();
obj.NamaBarang = txtNamaBarang.Text.Trim();
obj.KodeBarang = txtKodeBarang.Text.Trim();
obj.JenisBarang = txtJenisBarang.Text.Trim();
obj.BeratBarang = Int32.Parse(txtBeratBarang.Text.Trim());
add(obj);
MessageBox.Show("Data berhasil disimpan");
}
catch (Exception ex)
{
MessageBox.Show("Masukkan angka pada bagian harga");
}
}
}
private void tbNamaBrg_Leave(object sender, EventArgs e)
{
if (tbNamaBrg.Text.Trim().Equals(""))
{
this.tbNamaBrg.Focus();
}
else
{
BarangDAO dao = new BarangDAO(Setting.GetConnectionString());
result = dao.GetNamaBarang(tbNamaBrg.Text);
if (result == null)
{
MessageBox.Show("Maaf, Barang tidak ditemukan", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
this.tbNamaBrg.Text = null;
this.tbNamaBrg.Focus();
}
else
{
this.tbHarga.Text = result.HargaBarang;
}
}
}
//konstruktor
public BarangController()
{
Barang barang1 = new Barang
{
kodebarang = "KK001",
namabarang = "Keyboard Logitech",
stok = 12,
hargabeli = 200000,
hargajual = 250000
};
Barang barang2 = new Barang
{
kodebarang = "KK002",
namabarang = "Keyboard Samsung",
stok = 13,
hargabeli = 2500000,
hargajual = 3000000
};
lstBarang.Add(barang1);
lstBarang.Add(barang2);
}
public bool tambah(Barang barang)
{
using (var context = new PsboContext())
{
try
{
var bar = context.Barang.Where(o => o.NamaBarang == barang.NamaBarang).FirstOrDefault();
if (bar != null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
}
private void TambahPerbaikiLaporanBarang_Click(object sender, EventArgs e)
{
if (lsvBarang.SelectedItems.Count > 0)
{
// ambil objek mhs yang mau diedit dari collection
Barang brg = listOfBarang[lsvBarang.SelectedIndices[0]];
// buat objek form entry data mahasiswa
FrmEntryBarang frmEntry = new FrmEntryBarang("Edit Data Pengurus", brg, barangController);
// mendaftarkan method event handler untuk merespon event OnUpdate
frmEntry.OnUpdate += OnUpdateEventHandler;
// tampilkan form entry mahasiswa
frmEntry.ShowDialog();
}
else // data belum dipilih
{
MessageBox.Show("Data belum dipilih", "Peringatan", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation);
}
}
private void btnEditBarang_Click(object sender, EventArgs e)
{
foreach (Control ctrl in mtpBarang.Controls)
{
if (ctrl is TextBox && ctrl.Text.Trim() == "")
{
MessageBox.Show("Data tidak boleh ada yang kosong.");
return;
}
}
Barang barang = new Barang();
barang.setId(Convert.ToInt32(txtIdBarang.Text));
barang.setKode(txtKode.Text);
barang.setNama(txtNamaBarang.Text);
barang.setHargaHpp(Convert.ToDecimal(txtHargaHpp.Text));
barang.setHargaJual(Convert.ToDecimal(txtHargaJual.Text));
barang.setJumlah(Convert.ToInt32(txtJumlahAwal.Text));
barang.Update();
MessageBox.Show("Barang dengan kode " + barang.getKode() + " berhasil diupdate.");
}
public bool InsertBarang(Barang oBarang)
{
bool result = false;
string sql = string.Format(@"INSERT INTO `barang`
(`KodeBarang`,
`NamaBarang`,
`HargaBeli`,
`HargaJual`,
`Stock`)
VALUES (@0,
@1,
@2,
@3,
@4)");
result = db.Execute(sql, oBarang.KodeBarang,
oBarang.NamaBarang,
oBarang.HargaBeli,
oBarang.HargaJual,
oBarang.Stock) == 1;
return(result);
}
public List <Barang> ReadByNama(string Nama)
{
// membuat objek collection untuk menampung objek mahasiswa
List <Barang> list = new List <Barang>();
try
{
// deklarasi perintah SQL
string sql = @"select * from barang where Kode_Barang like @Kode_Barang order by Kode_Barang";
// membuat objek command menggunakan blok using
using (MySqlCommand cmd = new MySqlCommand(sql, _conn))
{
// membuat objek dtr (data reader) untuk menampung result set (hasil perintah SELECT)
using (MySqlDataReader dtr = cmd.ExecuteReader())
{
cmd.Parameters.AddWithValue("@Nama", "%" + Nama + "%");
// panggil method Read untuk mendapatkan baris dari result set
while (dtr.Read())
{
// proses konversi dari row result set ke object
Barang brg = new Barang();
brg.Kode_Barang = dtr["Kode_Barang"].ToString();
brg.Nama_Barang = dtr["Nama"].ToString();
brg.Harga = dtr["Harga"].ToString();
// tambahkan objek mahasiswa ke dalam collection
list.Add(brg);
}
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.Print("ReadAll error: {0}", ex.Message);
}
return(list);
}
public ActionResult Create(BarangViewModel model)
{
if (!ModelState.IsValid)
{
ViewBag.KodeTipeCuci = new SelectList(_db.TipeCucis, "Kode", "Tipe", model.KodeTipeCuci);
return(View(model));
}
var barang = new Barang
{
Harga = model.Harga,
Nama = model.Nama,
KodeTipeCuci = model.KodeTipeCuci
};
_db.Barangs.Add(barang);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
private void textBoxKodeBarang_TextChanged(object sender, EventArgs e)
{
if (textBoxKodeBarang.Text.Length == textBoxKodeBarang.MaxLength)
{
listBarang = barang.QueryData("kodebarang", textBoxKodeBarang.Text);
if (listBarang.Count > 0)
{
Barang bar = (Barang)listBarang[0];
textBoxBarcode.Text = bar.Barcode;
textBoxNamaBarang.Text = bar.Nama;
textBoxHargaJual.Text = bar.HargaJual.ToString();
textBoxStok.Text = bar.Stok.ToString();
textBoxKategoriBarang.Text = bar.Kategori.Nama;
}
else
{
MessageBox.Show("Data Barang Tidak Ditemukan", "Warning");
buttonKosongi_Click(textBoxKodeBarang, e);
}
}
}
public async Task <bool> UpdatePost(Barang model)
{
try
{
if (db != null)
{
Barang barang = await db.Barang.Where(x => x.Id == model.Id).FirstOrDefaultAsync();
if (barang != null)
{
barang.Name = model.Name;
barang.JumlahKlik = model.JumlahKlik;
barang.Year = model.Year;
barang.HargaOtr = model.HargaOtr;
barang.WarnaId = model.WarnaId;
barang.TypeBarangId = model.TypeBarangId;
barang.PhotoPath = model.PhotoPath;
barang.Modified = model.Modified;
barang.ModifiedBy = model.ModifiedBy;
await db.SaveChangesAsync();
}
else
{
return(false);
}
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
return(true);
}
public int Update(Barang barang)
{
int result = 0;
if (string.IsNullOrEmpty(barang.Kode_Barang))
{
MessageBox.Show("Kode Harus harus diisi !", "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(0);
}
if (string.IsNullOrEmpty(barang.Nama_Barang))
{
MessageBox.Show("Nama Barang Harus Diisi !", "Peringatan ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(0);
}
if (string.IsNullOrEmpty(barang.Harga))
{
MessageBox.Show("Harga Barang Harus Diisi !", "Peringatan ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(0);
}
using (DbContext context = new DbContext())
{
_repository = new BarangRepository(context);
result = _repository.Update(barang);
}
if (result > 0)
{
MessageBox.Show("Data Barang berhasil diupdate !", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Data Barang gagal diupdate !", "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
return(result);
}
public ActionResult TambahEditDataBarang(int id = 0)
{
using (HttpClient client = new HttpClient())
{
client.BaseAddress = new Uri(Helpers.RestAPIAddress.GetUrl());
if (id == 0)
{
return(View(new Barang()));
}
else
{
client.DefaultRequestHeaders.Authorization =
new AuthenticationHeaderValue("Bearer",
HttpContext.Session.GetString("JWTtoken"));
var token = HttpContext.Session.GetString("JWTtoken");
HttpResponseMessage response = client.GetAsync("/api/Barang/" + id).Result;
string stringData = response.Content.ReadAsStringAsync().Result;
Barang data = JsonConvert.DeserializeObject <Barang>(stringData);
TempData["Pesan"] = "Saved Successfully";
return(View(data));
}
}
}
public static bool Createbarang(Barang barangmdl)
{
try
{
Barang barang = new Barang();
using (DataContext db = new DataContext())
{
barang.KodeBarang = barangmdl.KodeBarang;
barang.NamaBarang = barangmdl.NamaBarang;
barang.Satuan = barangmdl.Satuan;
barang.Stok = barangmdl.Stok;
barang.Harga = barangmdl.Harga;
db.Barang.Add(barang);
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
private void textBoxBarcode_TextChanged(object sender, EventArgs e)
{
Barang barang = new Barang();
if (textBoxBarcode.Text.Length == textBoxBarcode.MaxLength)
{
listBarang = barang.QueryData("Barcode", textBoxBarcode.Text);
if (listBarang.Count > 0)
{
labelKode.Text = ((Barang)listBarang[0]).KodeBarang;
labelNamaBarang.Text = ((Barang)listBarang[0]).Nama;
labelHarga.Text = ((Barang)listBarang[0]).HargaJual.ToString();
textBoxJumlah.Text = "1";
textBoxJumlah.Focus();
}
else
{
MessageBox.Show("Barang tidak ada");
textBoxBarcode.Text = "";
}
}
}
public bool Update(Barang barang)
{
using (var context = new PsboContext())
{
var bar = context.Barang.SingleOrDefault(a => a.IdBarang == barang.IdBarang);
if (bar != null)
{
try
{
if (Delete(bar) & Add(barang))
{
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
throw;
}
}
return(false);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
string hasil = Barang.HapusData(comboBoxKodeBarang.Text);
if (hasil == "1")
{
MessageBox.Show("Barang telah dihapus");
FormDaftarBarang frm = (FormDaftarBarang)this.Owner;
frm.FormDaftarBarang_Load(sender, e);
this.Close();
}
else
{
MessageBox.Show("Error. Pesan : " + hasil);
}
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
}
public void FormUbahBarang_Load(object sender, EventArgs e)
{
frmDaftar = (FormDaftarBarang)this.Owner;
listHasilData.Clear();
string hasil = Barang.BacaData("", "", listHasilData);
if (hasil == "1")
{
for (int i = 0; i < listHasilData.Count; i++)
{
comboBoxKodeBarang.Items.Add(listHasilData[i].Kode);
}
}
//textBoxIdOrder.Enabled = false;
//textBoxKeterangan.Enabled = false;
//textBoxSatuan.Enabled = false;
//textBoxNama.Enabled = false;
//numericUpDownJumlah.Enabled = false;
//numericUpDownHargaSatuan.Enabled = false;
}
public ActionResult Edit(BarangViewModel model)
{
if (!ModelState.IsValid)
{
ViewBag.KodeTipeCuci = new SelectList(_db.TipeCucis, "Kode", "Tipe", model.KodeTipeCuci);
return(View(model));
}
var barang = new Barang
{
Kode = model.Kode,
Harga = model.Harga,
Nama = model.Nama,
KodeTipeCuci = model.KodeTipeCuci
};
_db.Entry(barang).State = EntityState.Modified;
_db.SaveChanges();
return(RedirectToAction("Index"));
}
private async void BtnJenisMotor_Clicked(object sender, EventArgs e)
{
var _request = new RestRequest("api/Barang", Method.POST);
var newBarang = new Barang {
IdJenisMotor = TxtIdJenisMotor.Text, KategoriId = TxtKategoriId.Text, Nama = TxtNama.Text, Stok = TxtStok.Text, HargaBeli = TxtHargaBeli.Text
, HargaJual = TxtHargaJual.Text, TanggalBeli = DtTanggalBeli.Date
};
_request.AddBody(newBarang);
try
{
var _response = await _client.Execute(_request);
if (_response.StatusCode == System.Net.HttpStatusCode.OK)
{
await Navigation.PushAsync(new BarangPage());
}
}
catch (Exception ex)
{
await DisplayAlert("Error", "Error : " + ex.Message, "OK");
}
}
private void textBoxCari_TextChanged(object sender, EventArgs e)
{
string kriteria = "";
if (comboBoxCari.Text == "Kode Barang")
{
kriteria = "kode";
}
else if (comboBoxCari.Text == "Nama")
{
kriteria = "Nama";
}
else if (comboBoxCari.Text == "Satuan")
{
kriteria = "satuan";
}
else if (comboBoxCari.Text == "Harga Satuan")
{
kriteria = "harga_satuan";
}
else if (comboBoxCari.Text == "ID Order Penjualan")
{
kriteria = "id_order_penjualan";
}
// Kosongi isi list
listHasilData.Clear();
// Tampilkan data kategori sesuai kriteria
string hasilBaca = Barang.BacaData(kriteria, textBoxCari.Text, listHasilData);
if (hasilBaca == "1")
{
dataGridViewBahanBaku.DataSource = null;
dataGridViewBahanBaku.DataSource = listHasilData;
}
}
private void buttonTambahBarang_Click(object sender, EventArgs e)
{
try
{
Barang b;
if (comboBoxPO.Text != "")
{
OrderPenjualan o = listHasilData[comboBoxPO.SelectedIndex];
b = new Barang(textBoxKodeBarang.Text, textBoxNamaBarang.Text, (int)numericUpDownJumlah.Value, textBoxSatuanBarang.Text, (int)numericUpDownHargaSatuan.Value, richTextBoxKeterangan.Text, o);
}
else
{
b = new Barang(textBoxKodeBarang.Text, textBoxNamaBarang.Text, (int)numericUpDownJumlah.Value, textBoxSatuanBarang.Text, (int)numericUpDownHargaSatuan.Value, richTextBoxKeterangan.Text, null);
}
string hasil = Barang.TambahData(b);
if (hasil == "1")
{
if (pictureBoxGambar.BackgroundImage != null)
{
pictureBoxGambar.BackgroundImage.Save(Application.StartupPath + "\\Images\\Barang\\" + textBoxKodeBarang.Text + ".jpg");
}
MessageBox.Show("Barang telah ditambahkan");
FormTambahBarang_Load(sender, e);
frmDaftar.FormDaftarBarang_Load(sender, e);
}
else
{
MessageBox.Show("Gagal menambahkan barang. Pesan: Kode Barang telah digunakan");
}
}
catch (Exception es)
{
MessageBox.Show(es.Message);
}
}
public List <Barang> View()
{
SqlDataReader reader;
List <Barang> listBarang = new List <Barang>();
string query = "SELECT * FROM Barang";
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText = query;
connection.Open();
reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
int id = Convert.ToInt32(reader["ID"].ToString());
int harga = Convert.ToInt32(reader["Harga"].ToString());
string name = reader["Nama"].ToString();
int qty = Convert.ToInt32(reader["Qty"].ToString());
Barang barang = new Barang(id, harga, name, qty);
listBarang.Add(barang);
}
}
reader.Close();
connection.Close();
command.Dispose();
return(listBarang);
}
public void UpdateDataTestMinus()
{
Barang lama = new Barang
{
Kode = "0003",
Nama = "Novel",
Quantity = 5,
Harga = 50000,
Pajak = "5"
};
daoBarang.listBarang.Add(lama);
Barang baru = new Barang
{
Kode = "0003",
Nama = "Novel",
Quantity = -5,
Harga = 50000,
Pajak = "5"
};
daoBarang.UpdateData(lama, baru);
}
private void buttonSimpan_Click(object sender, EventArgs e)
{
try
{
int indexpeg = comboBoxPekerja.SelectedIndex;
//int indexDipilihUser = comboBoxNoPo.SelectedIndex;
for (int i = 0; i < listdatabarang.Count; i++)
{
if (comboBoxNoPo.Text == (listdatabarang[i].Kode + " - " + listdatabarang[i].Nama))
{
op = listdatabarang[i];
}
}
Pekerja p = ListDatapeg[indexpeg];
Spk s = new Spk(textBoxNoSPK.Text, dateTimePickerdt.Value, op, p, textBoxPekerjaan.Text, textBoxLokasi.Text, int.Parse(textBoxBiaya.Text), textBoxLamaKerja.Text, textBoxSyarat.Text, comboBoxMetode.Text);
string hasilTambah = Spk.TambahData(s);
if (hasilTambah == "1")
{
MessageBox.Show("SPK telah tersimpan.", "Informasi");
frmDaftar.FormDaftarSPK_Load(sender, e);
buttonKosongi_Click(sender, e);
}
else
{
MessageBox.Show("Gagal menambah SPK. Pesan kesalahan: " + hasilTambah);
}
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
}
public void Insert(Barang barang)
{
using (NpgsqlConnection conn = new NpgsqlConnection(GetConnStr()))
{
string strSql = @"insert into barang(kodebarang,namabarang,stok,hargabeli,hargajual)
values(@kodebarang,@namabarang,@stok,@hargabeli,@hargajual)";
var param = new
{
kodebarang = barang.kodebarang,
namabarang = barang.namabarang,
stok = barang.stok,
hargabeli = barang.hargabeli,
hargajual = barang.hargajual
};
try
{
conn.Execute(strSql, param);
}
catch (NpgsqlException sqlEx)
{
throw new Exception($"Error: {sqlEx.Message}");
}
}
}
