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