public void Update(BiayaModel model)
{
var sSql = @"
UPDATE
Biaya
SET
Tgl = @Tgl,
Jam = @Jam,
Keterangan = @Keterangan,
JenisBiayaID = @JenisBiayaID,
JenisKasID = @JenisKasID,
NilaiBiaya = @NilaiBiaya
WHERE
BiayaID = @BiayaID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@BiayaID", model.BiayaID);
cmd.AddParam("@Tgl", model.Tgl.ToTglYMD());
cmd.AddParam("@Jam", model.Jam);
cmd.AddParam("@Keterangan", model.Keterangan);
cmd.AddParam("@JenisBiayaID", model.JenisBiayaID);
cmd.AddParam("@JenisKasID", model.JenisKasID);
cmd.AddParam("@NilaiBiaya", model.NilaiBiaya);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public void Insert(BiayaModel model)
{
var sSql = @"
INSERT INTO
Biaya (
BiayaID, Tgl, Jam, Keterangan,
JenisBiayaID, JenisKasID, NilaiBiaya)
VALUES (
@BiayaID, @Tgl, @Jam, @Keterangan,
@JenisBiayaID, @JenisKasID, @NilaiBiaya) ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@BiayaID", model.BiayaID);
cmd.AddParam("@Tgl", model.Tgl.ToTglYMD());
cmd.AddParam("@Jam", model.Jam);
cmd.AddParam("@Keterangan", model.Keterangan);
cmd.AddParam("@JenisBiayaID", model.JenisBiayaID);
cmd.AddParam("@JenisKasID", model.JenisKasID);
cmd.AddParam("@NilaiBiaya", model.NilaiBiaya);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public void GenDelete(BiayaModel biaya)
{
if (biaya == null)
{
throw new ArgumentNullException(nameof(biaya));
}
_bpKasDal.Delete(biaya.BiayaID);
}
public BPKasModel Generate(BiayaModel biaya)
{
if (biaya == null)
{
throw new ArgumentNullException(nameof(biaya));
}
var bpKas = (BPKasModel)biaya;
var result = Save(bpKas);
return(result);
}
public IEnumerable <BiayaModel> ListData(string tgl1, string tgl2)
{
List <BiayaModel> result = null;
var sSql = @"
SELECT
aa.BiayaID, aa.Tgl, aa.Jam, aa.Keterangan,
aa.JenisBiayaID, aa.JenisKasID, aa.NilaiBiaya,
ISNULL(bb.JenisBiayaName, '') JenisBiayaName,
ISNULL(cc.JenisKasName, '') JenisKasName
FROM
Biaya aa
LEFT JOIN JenisBiaya bb ON aa.JenisBiayaID = bb.JenisBiayaID
LEFT JOIN JenisKas cc ON aa.JenisKasID = cc.JenisKasID
WHERE
Tgl BETWEEN @Tgl1 AND @Tgl2 ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@Tgl1", tgl1.ToTglYMD());
cmd.AddParam("@Tgl2", tgl2.ToTglYMD());
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (!dr.HasRows)
{
return(null);
}
result = new List <BiayaModel>();
while (dr.Read())
{
var item = new BiayaModel
{
BiayaID = dr["BiayaID"].ToString(),
Tgl = dr["Tgl"].ToString().ToTglDMY(),
Jam = dr["Jam"].ToString(),
Keterangan = dr["Keterangan"].ToString(),
JenisBiayaID = dr["JenisBiayaID"].ToString(),
JenisBiayaName = dr["JenisBiayaName"].ToString(),
JenisKasID = dr["JenisKasID"].ToString(),
JenisKasName = dr["JenisKasName"].ToString(),
NilaiBiaya = Convert.ToDecimal(dr["NilaiBiaya"])
};
result.Add(item);
}
}
}
return(result);
}
private void Save()
{
var biaya = new BiayaModel
{
BiayaID = BiayaIDText.Text,
Tgl = TglText.Value.ToString("dd-MM-yyyy"),
Jam = JamText.Text,
JenisBiayaID = JenisBiayaCombo.SelectedValue.ToString(),
JenisKasID = JenisKasCombo.SelectedValue.ToString(),
Keterangan = KeteranganText.Text,
NilaiBiaya = NilIText.Value
};
var result = _biayaBL.Save(biaya);
_bpKasBL.Generate(result);
}
private BiayaModel BiayaDataFactory()
{
var result = new BiayaModel
{
BiayaID = "A1",
Tgl = "11-02-2019",
Jam = "01:38:00",
Keterangan = "B1",
JenisBiayaID = "C1",
JenisBiayaName = "",
JenisKasID = "D1",
JenisKasName = "",
NilaiBiaya = 300000
};
return(result);
}
public BiayaModel GetData(string id)
{
BiayaModel result = null;
var sSql = @"
SELECT
aa.BiayaID, aa.Tgl, aa.Jam, aa.Keterangan,
aa.JenisBiayaID, aa.JenisKasID, aa.NilaiBiaya,
ISNULL(bb.JenisBiayaName,'') JenisBiayaName,
ISNULL(cc.JenisKasName, '') JenisKasName
FROM
Biaya aa
LEFT JOIN JenisBiaya bb ON aa.JenisBiayaID = bb.JenisBiayaID
LEFT JOIN JenisKas cc ON aa.JenisKasID = cc.JenisKasID
WHERE
BiayaID = @BiayaID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@BiayaID", id);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (!dr.HasRows)
{
return(null);
}
dr.Read();
result = new BiayaModel
{
BiayaID = id,
Tgl = dr["Tgl"].ToString().ToTglDMY(),
Jam = dr["Jam"].ToString(),
Keterangan = dr["Keterangan"].ToString(),
JenisBiayaID = dr["JenisBiayaID"].ToString(),
JenisBiayaName = dr["JenisBiayaName"].ToString(),
JenisKasID = dr["JenisKasID"].ToString(),
JenisKasName = dr["JenisKasName"].ToString(),
NilaiBiaya = Convert.ToDecimal(dr["NilaiBiaya"])
};
}
}
return(result);
}
public BiayaModel Save(BiayaModel model)
{
if (model == null)
{
throw new ArgumentNullException(nameof(model));
}
if (model.NilaiBiaya <= 0)
{
throw new ArgumentException("Nilai Biaya invalid");
}
var jenisBiaya = _jenisBiayaBL.GetData(model.JenisBiayaID);
if (jenisBiaya == null)
{
throw new ArgumentException("JenisBiayaID invalid");
}
var jenisKas = _jenisKasBL.GetData(model.JenisKasID);
if (jenisKas == null)
{
throw new ArgumentException("JenisKasID invalid");
}
if (model.BiayaID.Trim() == "")
{
model.BiayaID = GenNewID();
}
using (var trans = TransHelper.NewScope())
{
// hapus data lama
_biayaDal.Delete(model.BiayaID);
// simpan data baru
_biayaDal.Insert(model);
trans.Complete();
}
return(model);
}
public IEnumerable <BiayaModel> Generate(LunasKasBonModel lunasKasBon)
{
List <BiayaModel> result = null;
if (lunasKasBon == null)
{
throw new ArgumentNullException(nameof(lunasKasBon));
}
if (lunasKasBon.ListLunas == null)
{
throw new ArgumentNullException(nameof(lunasKasBon.ListLunas));
}
// cek kasbon-nya exist atau tidak
var kasBon = _kasBonBL.GetData(lunasKasBon.KasBonID);
if (kasBon == null)
{
throw new ArgumentException("KasBon tidak ditemukasn");
}
// cek apakah ada detil ListLunas yang BIAYA
IEnumerable <LunasKasBonDetilModel> listDetilLunasKasBonBiaya =
from c in lunasKasBon.ListLunas
where c.JenisLunasID != "KAS"
select c;
if (listDetilLunasKasBonBiaya == null)
{
return(null);
}
// Generate Biaya
var noUrut = 0;
foreach (var item in listDetilLunasKasBonBiaya)
{
var jenisLunas = _jenisLunasBL.GetData(item.JenisLunasID);
if (jenisLunas == null)
{
throw new ArgumentException("Generate Biaya failed. JenisLunas invalid");
}
var biaya = new BiayaModel
{
BiayaID = lunasKasBon.LunasKasBonID + '-' + noUrut.ToString().PadLeft(2, '0'),
Tgl = lunasKasBon.Tgl,
Jam = lunasKasBon.Jam,
JenisBiayaID = jenisLunas.JenisBiayaID,
JenisKasID = kasBon.JenisKasID,
Keterangan = "[LUNAS-KASBON] " + jenisLunas.JenisLunasName + ' ' + kasBon.Keterangan,
NilaiBiaya = item.NilaiLunas
};
var itemResult = Save(biaya);
if (result == null)
{
result = new List <BiayaModel>();
}
result.Add(itemResult);
noUrut++;
}
return(result);
}