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