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