public JabatanModel GetData(IJabatanKey key)
{
JabatanModel result = null;
var sql = @"
SELECT
JabatanName
FROM
OFTA_Jabatan
WHERE
JabatanID = @JabatanID ";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@JabatanID", key.JabatanID, SqlDbType.VarChar);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (!dr.HasRows)
{
return(null);
}
dr.Read();
result = new JabatanModel
{
JabatanID = key.JabatanID,
JabatanName = dr["JabatanName"].ToString()
};
}
}
return(result);
}
public IEnumerable <JabatanModel> ListData()
{
List <JabatanModel> result = null;
var sql = @"
SELECT
JabatanID, JabatanName
FROM
OFTA_Jabatan ";
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 <JabatanModel>();
while (dr.Read())
{
var itemResult = new JabatanModel
{
JabatanID = dr["JabatanID"].ToString(),
JabatanName = dr["JabatanName"].ToString()
};
result.Add(itemResult);
}
}
}
return(result);
}
private JabatanModel Validate(JabatanModel jabatan)
{
jabatan.Empty().Throw("JABATAN kosong");
jabatan.JabatanID.Empty().Throw("JABATAN ID invalid");
jabatan.JabatanID.Length.GreaterThan(3).Throw("JABATAN ID max length is 3");
jabatan.JabatanName.Empty().Throw("JABATAN NAME invalid");
jabatan.JabatanName.Length.GreaterThan(20).Throw("JABATAN NAME max length is 20");
return(jabatan);
}
private JabatanModel JabatanSample()
{
var result = new JabatanModel
{
JabatanID = "A",
JabatanName = "B"
};
return(result);
}
public IHttpActionResult Update(JabatanModel jabatan)
{
try
{
var result = _jabatanBL.Update(jabatan);
return(Ok(result));
}
catch (ArgumentException ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult Delete(string jabatanID)
{
var jbtn = new JabatanModel {
JabatanID = jabatanID
};
try
{
_jabatanBL.Delete(jbtn);
return(Ok("Data has been deleted"));
}
catch (ArgumentException ex)
{
return(BadRequest(ex.Message));
}
}
public JabatanModel Update(JabatanModel jabatan)
{
// INPUT VALIDATION
var kt = Validate(jabatan);
// BUSINESS VALIDATION
var jabatanDb = _jabatanDal.GetData(kt);
jabatanDb.Empty().Throw("JABATAN ID not found");
// REPO-OP
_jabatanDal.Update(kt);
// RETURN
return(kt);
}
public JabatanModel Add(JabatanModel jabatan)
{
// INPUT VALIDATION
var kt = Validate(jabatan);
// BUSINESS VALIDATION
var jabatanDb = _jabatanDal.GetData(kt);
jabatanDb.NotEmpty().Throw("JABATAN ID already exist");
// REPO-OP
_jabatanDal.Insert(kt);
// RETURN
return(kt);
}
public void Insert(JabatanModel entity)
{
var sql = @"
INSERT INTO
OFTA_Jabatan (
JabatanID, JabatanName )
VALUES (
@JabatanID, @JabatanName)";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@JabatanID", entity.JabatanID, SqlDbType.VarChar);
cmd.AddParam("@JabatanName", entity.JabatanName, SqlDbType.VarChar);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public void Update(JabatanModel entity)
{
var sql = @"
UPDATE
OFTA_Jabatan
SET
JabatanName = @JabatanName
WHERE
JabatanID = @JabatanID ";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@JabatanID", entity.JabatanID, SqlDbType.VarChar);
cmd.AddParam("@JabatanName", entity.JabatanName, SqlDbType.VarChar);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public IHttpActionResult GetData(string jabatanID)
{
var jbtn = new JabatanModel {
JabatanID = jabatanID
};
try
{
var result = _jabatanBL.GetData(jbtn);
if (result is null)
{
return(BadRequest("Data Not Found"));
}
return(Ok(result));
}
catch (ArgumentException ex)
{
return(BadRequest(ex.Message));
}
}
