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