public JenisSuratDinasModel GetData(IJenisSuratDinasKey key)
{
JenisSuratDinasModel result = null;
var sql = @"
SELECT
JenisSuratDinasID, JenisSuratDinasName
FROM
OFTA_JenisSuratDinas
WHERE
JenisSuratDinasID = @JenisSuratDinasID ";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@JenisSuratDinasID", key.JenisSuratDinasID, SqlDbType.VarChar);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (!dr.HasRows)
{
return(null);
}
dr.Read();
result = new JenisSuratDinasModel
{
JenisSuratDinasID = dr["JenisSuratDinasID"].ToString(),
JenisSuratDinasName = dr["JenisSuratDinasName"].ToString(),
};
}
}
return(result);
}
public void Delete(IJenisSuratDinasKey key)
{
// INPUT VALIDATION
if (key is null)
{
throw new ArgumentException("JENIS SURAT DINAS ID empty");
}
// REPO-OP
_jenisSuratDinasDal.Delete(key);
}
public JenisSuratDinasModel GetData(IJenisSuratDinasKey key)
{
// INPUT VALIDATION
if (key is null)
{
throw new ArgumentException("JENIS SURAT DINAS ID empty");
}
// REPO-OP
var result = _jenisSuratDinasDal.GetData(key);
// RETURN
return(result);
}
public void Delete(IJenisSuratDinasKey key)
{
var sql = @"
DELETE
OFTA_JenisSuratDinas
WHERE
JenisSuratDinasID = @JenisSuratDinasID ";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@JenisSuratDinasID", key.JenisSuratDinasID, SqlDbType.VarChar);
conn.Open();
cmd.ExecuteNonQuery();
}
}
