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)); } }