public IEnumerable <JenisBiayaModel> ListData()
{
List <JenisBiayaModel> result = null;
var sql = @"
SELECT
JenisBiayaID, JenisBiayaName
FROM
OFTA_JenisBiaya ";
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 <JenisBiayaModel>();
while (dr.Read())
{
var itemResult = new JenisBiayaModel
{
JenisBiayaID = dr["JenisBiayaID"].ToString(),
JenisBiayaName = dr["JenisBiayaName"].ToString()
};
result.Add(itemResult);
}
}
}
return(result);
}
public JenisBiayaModel GetData(string id)
{
JenisBiayaModel result = null;
var sSql = @"
SELECT
aa.JenisBiayaName
FROM
JenisBiaya aa
WHERE
aa.JenisBiayaID = @JenisBiayaID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@JenisBiayaID", id);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
dr.Read();
result = new JenisBiayaModel
{
JenisBiayaID = id,
JenisBiayaName = dr["JenisBiayaName"].ToString()
};
}
}
}
return(result);
}
public IEnumerable <JenisBiayaModel> ListData()
{
List <JenisBiayaModel> result = null;
var sSql = @"
SELECT
aa.JenisBiayaID, aa.JenisBiayaName
FROM
JenisBiaya aa ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
result = new List <JenisBiayaModel>();
while (dr.Read())
{
var item = new JenisBiayaModel
{
JenisBiayaID = dr["JenisBiayaID"].ToString(),
JenisBiayaName = dr["JenisBiayaName"].ToString()
};
result.Add(item);
}
}
}
}
return(result);
}
public JenisBiayaModel GetData(IJenisBiayaKey key)
{
JenisBiayaModel result = null;
var sql = @"
SELECT
JenisBiayaName
FROM
OFTA_JenisBiaya
WHERE
JenisBiayaID = @JenisBiayaID ";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@JenisBiayaID", key.JenisBiayaID, SqlDbType.VarChar);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (!dr.HasRows)
{
return(null);
}
dr.Read();
result = new JenisBiayaModel
{
JenisBiayaID = key.JenisBiayaID,
JenisBiayaName = dr["JenisBiayaName"].ToString()
};
}
}
return(result);
}
private JenisBiayaModel Validate(JenisBiayaModel jenisBiaya)
{
jenisBiaya.Empty().Throw("JENIS BIAYA kosong");
jenisBiaya.JenisBiayaID.Empty().Throw("JENIS BIAYA ID invalid");
jenisBiaya.JenisBiayaID.Length.GreaterThan(3).Throw("JENIS BIAYA ID max length is 3");
jenisBiaya.JenisBiayaName.Empty().Throw("JENIS BIAYA NAME invalid");
jenisBiaya.JenisBiayaName.Length.GreaterThan(20).Throw("JENIS BIAYA NAME max length is 20");
return(jenisBiaya);
}
private JenisBiayaModel JenisBiayaSample()
{
var result = new JenisBiayaModel
{
JenisBiayaID = "A",
JenisBiayaName = "B"
};
return(result);
}
public IHttpActionResult Update(JenisBiayaModel jenisBiaya)
{
try
{
var result = _jenisBiayaBL.Update(jenisBiaya);
return(Ok(result));
}
catch (ArgumentException ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult Delete(string jenisBiayaID)
{
var jbtn = new JenisBiayaModel {
JenisBiayaID = jenisBiayaID
};
try
{
_jenisBiayaBL.Delete(jbtn);
return(Ok("Data has been deleted"));
}
catch (ArgumentException ex)
{
return(BadRequest(ex.Message));
}
}
public JenisBiayaModel Update(JenisBiayaModel jenisBiaya)
{
// INPUT VALIDATION
var kt = Validate(jenisBiaya);
// BUSINESS VALIDATION
var jenisBiayaDb = _jenisBiayaDal.GetData(kt);
jenisBiayaDb.Empty().Throw("JENIS BIAYA ID not found");
// REPO-OP
_jenisBiayaDal.Update(kt);
// RETURN
return(kt);
}
public JenisBiayaModel Add(JenisBiayaModel jenisBiaya)
{
// INPUT VALIDATION
var kt = Validate(jenisBiaya);
// BUSINESS VALIDATION
var jenisBiayaDb = _jenisBiayaDal.GetData(kt);
jenisBiayaDb.NotEmpty().Throw("JENIS BIAYA ID already exist");
// REPO-OP
_jenisBiayaDal.Insert(kt);
// RETURN
return(kt);
}
public void Insert(JenisBiayaModel entity)
{
var sql = @"
INSERT INTO
OFTA_JenisBiaya (
JenisBiayaID, JenisBiayaName )
VALUES (
@JenisBiayaID, @JenisBiayaName)";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@JenisBiayaID", entity.JenisBiayaID, SqlDbType.VarChar);
cmd.AddParam("@JenisBiayaName", entity.JenisBiayaName, SqlDbType.VarChar);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public void Insert(JenisBiayaModel model)
{
var sSql = @"
INSERT INTO
JenisBiaya (
JenisBiayaID, JenisBiayaName)
VALUES (
@JenisBiayaID, @JenisBiayaName) ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@JenisBiayaID", model.JenisBiayaID);
cmd.AddParam("@JenisBiayaName", model.JenisBiayaName);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public void Update(JenisBiayaModel entity)
{
var sql = @"
UPDATE
OFTA_JenisBiaya
SET
JenisBiayaName = @JenisBiayaName
WHERE
JenisBiayaID = @JenisBiayaID ";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@JenisBiayaID", entity.JenisBiayaID, SqlDbType.VarChar);
cmd.AddParam("@JenisBiayaName", entity.JenisBiayaName, SqlDbType.VarChar);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public void Update(JenisBiayaModel model)
{
var sSql = @"
UPDATE
JenisBiaya
SET
JenisBiayaName = @JenisBiayaName
WHERE
JenisBiayaID = @JenisBiayaID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@JenisBiayaID", model.JenisBiayaID);
cmd.AddParam("@JenisBiayaName", model.JenisBiayaName);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public IHttpActionResult GetData(string jenisBiayaID)
{
var jbtn = new JenisBiayaModel {
JenisBiayaID = jenisBiayaID
};
try
{
var result = _jenisBiayaBL.GetData(jbtn);
if (result is null)
{
return(BadRequest("Data Not Found"));
}
return(Ok(result));
}
catch (ArgumentException ex)
{
return(BadRequest(ex.Message));
}
}
public JenisBiayaModel TryValidate(JenisBiayaModel jenisBiaya)
{
var result = jenisBiaya;
if (jenisBiaya == null)
{
throw new ArgumentNullException(nameof(jenisBiaya));
}
if (jenisBiaya.JenisBiayaID.Trim() == "")
{
throw new ArgumentException("JenisBiayaID empty");
}
if (jenisBiaya.JenisBiayaName.Trim() == "")
{
throw new ArgumentException("JenisBiayaName empty");
}
return(result);
}
public JenisBiayaModel Save(JenisBiayaModel jenisBiaya)
{
// validasi
var result = jenisBiaya;
result = TryValidate(jenisBiaya);
// save
var dummyJenisBiaya = _jenisBiayaDal.GetData(jenisBiaya.JenisBiayaID);
if (dummyJenisBiaya == null)
{
_jenisBiayaDal.Insert(result);
}
else
{
_jenisBiayaDal.Update(result);
}
return(result);
}
