public JenisMutasiModel GetData(string id)
{
JenisMutasiModel result = null;
var sSql = @"
SELECT
aa.JenisMutasiNAme, aa.IsBrgMasuk
FROM
JenisMutasi aa
WHERE
aa.JenisMutasiID = @JenisMutasiID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@JenisMutasiID", id);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
dr.Read();
result = new JenisMutasiModel
{
JenisMutasiID = id,
JenisMutasiName = dr["JenisMutasiNAme"].ToString(),
IsBrgMasuk = Convert.ToBoolean(dr["IsBrgMasuk"])
};
}
}
}
return(result);
}
public IEnumerable <JenisMutasiModel> ListData()
{
List <JenisMutasiModel> result = null;
var sSql = @"
SELECT
aa.JenisMutasiID, aa.JenisMutasiNAme,
aa.IsBrgMasuk
FROM
JenisMutasi aa ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
result = new List <JenisMutasiModel>();
while (dr.Read())
{
var item = new JenisMutasiModel
{
JenisMutasiID = dr["JenisMutasiID"].ToString(),
JenisMutasiName = dr["JenisMutasiNAme"].ToString(),
IsBrgMasuk = Convert.ToBoolean(dr["IsBrgMasuk"])
};
result.Add(item);
}
}
}
}
return(result);
}
public void Insert(JenisMutasiModel jenisMutasi)
{
var sSql = @"
INSERT INTO
JenisMutasi (
JenisMutasiID, JenisMutasiName, IsBrgMasuk)
VALUES (
@JenisMutasiID, @JenisMutasiName, @IsBrgMasuk) ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@JenisMutasiID", jenisMutasi.JenisMutasiID);
cmd.AddParam("@JenisMutasiNAme", jenisMutasi.JenisMutasiName);
cmd.AddParam("@IsBrgMasuk", jenisMutasi.IsBrgMasuk);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public JenisMutasiModel TryValidate(JenisMutasiModel jenisMutasi)
{
var result = jenisMutasi;
if (jenisMutasi == null)
{
throw new ArgumentNullException(nameof(jenisMutasi));
}
if (jenisMutasi.JenisMutasiID.Trim() == "")
{
throw new ArgumentException("JenisMutasiID empty");
}
if (jenisMutasi.JenisMutasiName.Trim() == "")
{
throw new ArgumentException("JenisMUtasiName empty");
}
return(result);
}
public JenisMutasiModel Save(JenisMutasiModel jenisMutasi)
{
// validasi
var result = jenisMutasi;
result = TryValidate(jenisMutasi);
// save
var dummyJenisMutasi = _jenisMutasiDal.GetData(jenisMutasi.JenisMutasiID);
if (dummyJenisMutasi == null)
{
_jenisMutasiDal.Insert(result);
}
else
{
_jenisMutasiDal.Update(result);
}
return(result);
}
public void Update(JenisMutasiModel jenisMutasi)
{
var sSql = @"
UPDATE
JenisMutasi
SET
JenisMutasiNAme = @JenisMutasiNAme
IsBrgMasuk = @IsBrgMasuk
WHERE
JenisMutasiID = @JenisMutasiID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@JenisMutasiID", jenisMutasi.JenisMutasiID);
cmd.AddParam("@JenisMutasiNAme", jenisMutasi.JenisMutasiName);
cmd.AddParam("@IsBrgMasuk", jenisMutasi.IsBrgMasuk);
conn.Open();
cmd.ExecuteNonQuery();
}
}
