private PegModel Validate(PegModel peg)
{
peg.Empty().Throw("PEGAWAI kosong");
peg.PegName.Empty().Throw("PEGAWAI NAME invalid");
peg.PegName.Length.GreaterThan(20).Throw("PEGAWAI NAME max length is 20");
peg.JabatanID.Empty().Throw("JABATAN empty");
return(peg);
}
public IHttpActionResult Update(PegModel peg)
{
try
{
var result = _pegBL.Update(peg);
return(Ok(result));
}
catch (ArgumentException ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult Delete(string pegID)
{
var jbtn = new PegModel {
PegID = pegID
};
try
{
_pegBL.Delete(jbtn);
return(Ok("Data has been deleted"));
}
catch (ArgumentException ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult GetData(string pegID)
{
var jbtn = new PegModel {
PegID = pegID
};
try
{
var result = _pegBL.GetData(jbtn);
if (result is null)
{
return(BadRequest("Data Not Found"));
}
return(Ok(result));
}
catch (ArgumentException ex)
{
return(BadRequest(ex.Message));
}
}
public void Insert(PegModel entity)
{
var sql = @"
INSERT INTO
OFTA_Peg (
PegID, PegName, JabatanID)
VALUES (
@PegID, @PegName, @JabatanID) ";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@PegID", entity.PegID, SqlDbType.VarChar);
cmd.AddParam("@PegName", entity.PegName, SqlDbType.VarChar);
cmd.AddParam("@JabatanID", entity.JabatanID, SqlDbType.VarChar);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public PegModel Add(PegAddDto peg)
{
// INPUT VALIDATION
peg.Empty().Throw("DATA PEGAWAI empty");
// CONVERT DTO >> MODEL
var pg = new PegModel
{
PegName = peg.PegName,
JabatanID = peg.JabatanID
};
pg = Validate(pg);
// BUSINESS VALIDATION
var listPeg = _pegDal.ListData();
if (listPeg != null)
{
var exist = listPeg.FirstOrDefault(x => x
.PegName.Trim().ToLower() == peg.PegName.Trim().ToLower());
exist.NotEmpty().Throw("Pegawai already exist");
}
var jbtn = _jabatanDal.GetData(pg);
jbtn.Empty().Throw("JABATAN ID invalid");
pg.JabatanName = jbtn.JabatanName;
// REPO-OP
using (var trans = TransHelper.NewScope())
{
pg.PegID = _paramNoBL.GenNewID("PG", ParamNoLengthEnum.Code_5);
_pegDal.Insert(pg);
trans.Complete();
}
// RETURN
return(pg);
}
public PegModel Update(PegModel peg)
{
// INPUT VALIDATION
var pg = Validate(peg);
// BUSINESS VALIDATION
var pegDb = _pegDal.GetData(pg);
pegDb.Empty().Throw("PEGAWAI ID not found");
var jbtn = _jabatanDal.GetData(pg);
jbtn.Empty().Throw("JABATAN ID invalid");
pg.JabatanName = jbtn.JabatanName;
// REPO-OP
_pegDal.Update(pg);
// RETURN
return(pg);
}
public void Update(PegModel entity)
{
var sql = @"
UPDATE
OFTA_Peg
SET
PegName = @PegName,
JabatanID = @JabatanID
WHERE
PegID = @PegID ";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@PegID", entity.PegID, SqlDbType.VarChar);
cmd.AddParam("@PegName", entity.PegName, SqlDbType.VarChar);
cmd.AddParam("@JabatanID", entity.JabatanID, SqlDbType.VarChar);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public IEnumerable <PegModel> ListData()
{
List <PegModel> result = null;
var sql = @"
SELECT
aa.PegID, aa.PegName, aa.JabatanID,
ISNULL(bb.JabatanName, '') JabatanName
FROM
OFTA_Peg aa
LEFT JOIN OFTA_Jabatan bb ON aa.JabatanID = bb.JabatanID ";
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 <PegModel>();
while (dr.Read())
{
var item = new PegModel
{
PegID = dr["PegID"].ToString(),
PegName = dr["PegName"].ToString(),
JabatanID = dr["JabatanID"].ToString(),
JabatanName = dr["JabatanName"].ToString()
};
result.Add(item);
}
}
}
return(result);
}
public PegModel GetData(IPegKey key)
{
PegModel result = null;
var sql = @"
SELECT
aa.PegID, aa.PegName, aa.JabatanID,
ISNULL(bb.JabatanName, '') JabatanName
FROM
OFTA_Peg aa
LEFT JOIN OFTA_Jabatan bb ON aa.JabatanID = bb.JabatanID
WHERE
PegID = @PegID ";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@PegID", key.PegID, SqlDbType.VarChar);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (!dr.HasRows)
{
return(null);
}
dr.Read();
result = new PegModel
{
PegID = dr["PegID"].ToString(),
PegName = dr["PegName"].ToString(),
JabatanID = dr["JabatanID"].ToString(),
JabatanName = dr["JabatanName"].ToString()
};
}
}
return(result);
}
