public JenisSuratDinasModel GetData(IJenisSuratDinasKey key) { JenisSuratDinasModel result = null; var sql = @" SELECT JenisSuratDinasID, JenisSuratDinasName FROM OFTA_JenisSuratDinas WHERE JenisSuratDinasID = @JenisSuratDinasID "; using (var conn = new SqlConnection(ConnStringHelper.Get())) using (var cmd = new SqlCommand(sql, conn)) { cmd.AddParam("@JenisSuratDinasID", key.JenisSuratDinasID, SqlDbType.VarChar); conn.Open(); using (var dr = cmd.ExecuteReader()) { if (!dr.HasRows) { return(null); } dr.Read(); result = new JenisSuratDinasModel { JenisSuratDinasID = dr["JenisSuratDinasID"].ToString(), JenisSuratDinasName = dr["JenisSuratDinasName"].ToString(), }; } } return(result); }
public IEnumerable <JenisSuratDinasModel> ListData() { List <JenisSuratDinasModel> result = null; var sql = @" SELECT JenisSuratDinasID, JenisSuratDinasName FROM OFTA_JenisSuratDinas "; 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 <JenisSuratDinasModel>(); while (dr.Read()) { var item = new JenisSuratDinasModel { JenisSuratDinasID = dr["JenisSuratDinasID"].ToString(), JenisSuratDinasName = dr["JenisSuratDinasName"].ToString(), }; result.Add(item); } } } return(result); }
private JenisSuratDinasModel Validate(JenisSuratDinasModel jenisSuratDinas) { jenisSuratDinas.Empty().Throw("JENIS SURAT DINAS kosong"); jenisSuratDinas.JenisSuratDinasID.Empty().Throw("JENIS SURAT DINAS ID invalid"); jenisSuratDinas.JenisSuratDinasID.Length.GreaterThan(3).Throw("JENIS SURAT DINAS ID max length is 3"); jenisSuratDinas.JenisSuratDinasName.Empty().Throw("JENIS SURAT DINAS NAME invalid"); jenisSuratDinas.JenisSuratDinasName.Length.GreaterThan(20).Throw("JENIS SURAT DINAS NAME max length is 20"); return(jenisSuratDinas); }
private JenisSuratDinasModel JenisSuratDinasTestData() { var result = new JenisSuratDinasModel { JenisSuratDinasID = "A1", JenisSuratDinasName = "A2" }; return(result); }
public IHttpActionResult Update(JenisSuratDinasModel jenisSuratDinas) { try { var result = _jenisSuratDinasBL.Update(jenisSuratDinas); return(Ok(result)); } catch (ArgumentException ex) { return(BadRequest(ex.Message)); } }
public JenisSuratDinasModel Update(JenisSuratDinasModel jenisSuratDinas) { // INPUT VALIDATION var kt = Validate(jenisSuratDinas); // BUSINESS VALIDATION var jenisSuratDinasDb = _jenisSuratDinasDal.GetData(kt); jenisSuratDinasDb.Empty().Throw("JENIS SURAT DINAS ID not found"); // REPO-OP _jenisSuratDinasDal.Update(kt); // RETURN return(kt); }
public JenisSuratDinasModel Add(JenisSuratDinasModel jenisSuratDinas) { // INPUT VALIDATION var kt = Validate(jenisSuratDinas); // BUSINESS VALIDATION var jenisSuratDinasDb = _jenisSuratDinasDal.GetData(kt); jenisSuratDinasDb.NotEmpty().Throw("JENIS SURAT DINAS ID already exist"); // REPO-OP _jenisSuratDinasDal.Insert(kt); // RETURN return(kt); }
public IHttpActionResult Delete(string jenisSuratDinasID) { var jbtn = new JenisSuratDinasModel { JenisSuratDinasID = jenisSuratDinasID }; try { _jenisSuratDinasBL.Delete(jbtn); return(Ok("Data has been deleted")); } catch (ArgumentException ex) { return(BadRequest(ex.Message)); } }
public void Insert(JenisSuratDinasModel entity) { var sql = @" INSERT INTO OFTA_JenisSuratDinas ( JenisSuratDinasID, JenisSuratDinasName) VALUES ( @JenisSuratDinasID, @JenisSuratDinasName)"; using (var conn = new SqlConnection(ConnStringHelper.Get())) using (var cmd = new SqlCommand(sql, conn)) { cmd.AddParam("@JenisSuratDinasID", entity.JenisSuratDinasID, SqlDbType.VarChar); cmd.AddParam("@JenisSuratDinasName", entity.JenisSuratDinasName, SqlDbType.VarChar); conn.Open(); cmd.ExecuteNonQuery(); } }
public void Update(JenisSuratDinasModel entity) { var sql = @" UPDATE OFTA_JenisSuratDinas SET JenisSuratDinasName = @JenisSuratDinasName WHERE JenisSuratDinasID = @JenisSuratDinasID "; using (var conn = new SqlConnection(ConnStringHelper.Get())) using (var cmd = new SqlCommand(sql, conn)) { cmd.AddParam("@JenisSuratDinasID", entity.JenisSuratDinasID, SqlDbType.VarChar); cmd.AddParam("@JenisSuratDinasName", entity.JenisSuratDinasName, SqlDbType.VarChar); conn.Open(); cmd.ExecuteNonQuery(); } }
public IHttpActionResult GetData(string jenisSuratDinasID) { var jbtn = new JenisSuratDinasModel { JenisSuratDinasID = jenisSuratDinasID }; try { var result = _jenisSuratDinasBL.GetData(jbtn); if (result is null) { return(BadRequest("Data Not Found")); } return(Ok(result)); } catch (ArgumentException ex) { return(BadRequest(ex.Message)); } }