public KotaModel GetData(IKotaKey key)
{
KotaModel result = null;
var sql = @"
SELECT
KotaName
FROM
OFTA_Kota
WHERE
KotaID = @KotaID ";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@KotaID", key.KotaID, SqlDbType.VarChar);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (!dr.HasRows)
{
return(null);
}
dr.Read();
result = new KotaModel
{
KotaID = key.KotaID,
KotaName = dr["KotaName"].ToString()
};
}
}
return(result);
}
public IEnumerable <KotaModel> ListData()
{
List <KotaModel> result = null;
var sql = @"
SELECT
KotaID, KotaName
FROM
OFTA_Kota ";
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 <KotaModel>();
while (dr.Read())
{
var itemResult = new KotaModel
{
KotaID = dr["KotaID"].ToString(),
KotaName = dr["KotaName"].ToString()
};
result.Add(itemResult);
}
}
}
return(result);
}
private KotaModel Validate(KotaModel kota)
{
kota.Empty().Throw("KOTA kosong");
kota.KotaID.Empty().Throw("KOTA ID invalid");
kota.KotaID.Length.GreaterThan(3).Throw("KOTA ID max length is 3");
kota.KotaName.Empty().Throw("KOTA NAME invalid");
kota.KotaName.Length.GreaterThan(20).Throw("KOTA NAME max length is 20");
return(kota);
}
private KotaModel KotaSample()
{
var result = new KotaModel
{
KotaID = "A1",
KotaName = "B1"
};
return(result);
}
public IHttpActionResult Update(KotaModel kota)
{
try
{
var result = _kotaBL.Update(kota);
return(Ok(result));
}
catch (ArgumentException ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult Delete(string kotaID)
{
var kota = new KotaModel {
KotaID = kotaID
};
try
{
_kotaBL.Delete(kota);
return(Ok("Data has been deleted"));
}
catch (ArgumentException ex)
{
return(BadRequest(ex.Message));
}
}
public KotaModel Update(KotaModel kota)
{
// INPUT VALIDATION
var kt = Validate(kota);
// BUSINESS VALIDATION
var kotaDb = _kotaDal.GetData(kt);
kotaDb.Empty().Throw("KOTA ID not found");
// REPO-OP
_kotaDal.Update(kt);
// RETURN
return(kt);
}
public KotaModel Add(KotaModel kota)
{
// INPUT VALIDATION
var kt = Validate(kota);
// BUSINESS VALIDATION
var kotaDb = _kotaDal.GetData(kt);
kotaDb.NotEmpty().Throw("KOTA ID already exist");
// REPO-OP
_kotaDal.Insert(kt);
// RETURN
return(kt);
}
public void Insert(KotaModel entity)
{
var sql = @"
INSERT INTO
OFTA_Kota (
KotaID, KotaName )
VALUES (
@KotaID, @KotaName)";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@KotaID", entity.KotaID, SqlDbType.VarChar);
cmd.AddParam("@KotaName", entity.KotaName, SqlDbType.VarChar);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public void Update(KotaModel entity)
{
var sql = @"
UPDATE
OFTA_Kota
SET
KotaName = @KotaName
WHERE
KotaID = @KotaID ";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@KotaID", entity.KotaID, SqlDbType.VarChar);
cmd.AddParam("@KotaName", entity.KotaName, SqlDbType.VarChar);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public IHttpActionResult GetData(string kotaID)
{
var kota = new KotaModel {
KotaID = kotaID
};
try
{
var result = _kotaBL.GetData(kota);
if (result is null)
{
return(BadRequest("Data Not Found"));
}
return(Ok(result));
}
catch (ArgumentException ex)
{
return(BadRequest(ex.Message));
}
}
