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 IEnumerable <JenisSuratDinasModel> ListData()
{
List <JenisSuratDinasModel> result = null;
var sql = @"
SELECT
JenisSuratDinasID, JenisSuratDinasName
FROM
OFTA_JenisSuratDinas ";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (!dr.HasRows)
{
return(null);
}
result = new List <JenisSuratDinasModel>();
while (dr.Read())
{
var item = new JenisSuratDinasModel
{
JenisSuratDinasID = dr["JenisSuratDinasID"].ToString(),
JenisSuratDinasName = dr["JenisSuratDinasName"].ToString(),
};
result.Add(item);
}
}
}
return(result);
}
private JenisSuratDinasModel Validate(JenisSuratDinasModel jenisSuratDinas)
{
jenisSuratDinas.Empty().Throw("JENIS SURAT DINAS kosong");
jenisSuratDinas.JenisSuratDinasID.Empty().Throw("JENIS SURAT DINAS ID invalid");
jenisSuratDinas.JenisSuratDinasID.Length.GreaterThan(3).Throw("JENIS SURAT DINAS ID max length is 3");
jenisSuratDinas.JenisSuratDinasName.Empty().Throw("JENIS SURAT DINAS NAME invalid");
jenisSuratDinas.JenisSuratDinasName.Length.GreaterThan(20).Throw("JENIS SURAT DINAS NAME max length is 20");
return(jenisSuratDinas);
}
private JenisSuratDinasModel JenisSuratDinasTestData()
{
var result = new JenisSuratDinasModel
{
JenisSuratDinasID = "A1",
JenisSuratDinasName = "A2"
};
return(result);
}
public IHttpActionResult Update(JenisSuratDinasModel jenisSuratDinas)
{
try
{
var result = _jenisSuratDinasBL.Update(jenisSuratDinas);
return(Ok(result));
}
catch (ArgumentException ex)
{
return(BadRequest(ex.Message));
}
}
public JenisSuratDinasModel Update(JenisSuratDinasModel jenisSuratDinas)
{
// INPUT VALIDATION
var kt = Validate(jenisSuratDinas);
// BUSINESS VALIDATION
var jenisSuratDinasDb = _jenisSuratDinasDal.GetData(kt);
jenisSuratDinasDb.Empty().Throw("JENIS SURAT DINAS ID not found");
// REPO-OP
_jenisSuratDinasDal.Update(kt);
// RETURN
return(kt);
}
public JenisSuratDinasModel Add(JenisSuratDinasModel jenisSuratDinas)
{
// INPUT VALIDATION
var kt = Validate(jenisSuratDinas);
// BUSINESS VALIDATION
var jenisSuratDinasDb = _jenisSuratDinasDal.GetData(kt);
jenisSuratDinasDb.NotEmpty().Throw("JENIS SURAT DINAS ID already exist");
// REPO-OP
_jenisSuratDinasDal.Insert(kt);
// RETURN
return(kt);
}
public IHttpActionResult Delete(string jenisSuratDinasID)
{
var jbtn = new JenisSuratDinasModel {
JenisSuratDinasID = jenisSuratDinasID
};
try
{
_jenisSuratDinasBL.Delete(jbtn);
return(Ok("Data has been deleted"));
}
catch (ArgumentException ex)
{
return(BadRequest(ex.Message));
}
}
public void Insert(JenisSuratDinasModel entity)
{
var sql = @"
INSERT INTO
OFTA_JenisSuratDinas (
JenisSuratDinasID, JenisSuratDinasName)
VALUES (
@JenisSuratDinasID, @JenisSuratDinasName)";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@JenisSuratDinasID", entity.JenisSuratDinasID, SqlDbType.VarChar);
cmd.AddParam("@JenisSuratDinasName", entity.JenisSuratDinasName, SqlDbType.VarChar);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public void Update(JenisSuratDinasModel entity)
{
var sql = @"
UPDATE
OFTA_JenisSuratDinas
SET
JenisSuratDinasName = @JenisSuratDinasName
WHERE
JenisSuratDinasID = @JenisSuratDinasID ";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@JenisSuratDinasID", entity.JenisSuratDinasID, SqlDbType.VarChar);
cmd.AddParam("@JenisSuratDinasName", entity.JenisSuratDinasName, SqlDbType.VarChar);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public IHttpActionResult GetData(string jenisSuratDinasID)
{
var jbtn = new JenisSuratDinasModel {
JenisSuratDinasID = jenisSuratDinasID
};
try
{
var result = _jenisSuratDinasBL.GetData(jbtn);
if (result is null)
{
return(BadRequest("Data Not Found"));
}
return(Ok(result));
}
catch (ArgumentException ex)
{
return(BadRequest(ex.Message));
}
}
