public JenisArsipModel GetData(IJenisArsipKey key) { JenisArsipModel result = null; var sql = @" SELECT JenisArsipName FROM OFTA_JenisArsip WHERE JenisArsipID = @JenisArsipID"; using (var conn = new SqlConnection(ConnStringHelper.Get())) using (var cmd = new SqlCommand(sql, conn)) { cmd.AddParam("@JenisArsipID", key.JenisArsipID, SqlDbType.VarChar); conn.Open(); using (var dr = cmd.ExecuteReader()) { if (!dr.HasRows) { return(null); } dr.Read(); result = new JenisArsipModel { JenisArsipID = key.JenisArsipID, JenisArsipName = dr["JenisArsipName"].ToString() }; } } return(result); }
public IEnumerable <JenisArsipModel> ListData() { List <JenisArsipModel> result = null; var sql = @" SELECT JenisArsipID,JenisArsipName FROM OFTA_JenisArsip"; 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 <JenisArsipModel>(); while (dr.Read()) { var itemResult = new JenisArsipModel { JenisArsipID = dr["JenisArsipID"].ToString(), JenisArsipName = dr["JenisArsipName"].ToString() }; result.Add(itemResult); } } } return(result); }
private JenisArsipModel JenisArsipSample() { var result = new JenisArsipModel { JenisArsipID = "A", JenisArsipName = "B" }; return(result); }
private JenisArsipModel Validate(JenisArsipModel jenisArsip) { jenisArsip.Empty().Throw("JENIS ARSIP kosong"); jenisArsip.JenisArsipID.Empty().Throw("JENIS ARSIP ID invalid"); jenisArsip.JenisArsipID.Length.GreaterThan(3).Throw("JENIS ARSIP ID max length is 3"); jenisArsip.JenisArsipName.Empty().Throw("JENIS ARSIP NAME invalid"); jenisArsip.JenisArsipName.Length.GreaterThan(20).Throw("JENIS ARSIP NAME max length is 20"); return(jenisArsip); }
public IHttpActionResult Update(JenisArsipModel jenisArsip) { try { var result = _jenisArsipBL.Update(jenisArsip); return(Ok(result)); } catch (ArgumentException ex) { return(BadRequest(ex.Message)); } }
public IHttpActionResult Delete(string jenisArsipID) { var jbtn = new JenisArsipModel { JenisArsipID = jenisArsipID }; try { _jenisArsipBL.Delete(jbtn); return(Ok("Data has been deleted")); } catch (ArgumentException ex) { return(BadRequest(ex.Message)); } }
public JenisArsipModel Update(JenisArsipModel jenisArsip) { // INPUT VALIDATION var kt = Validate(jenisArsip); // BUSINESS VALIDATION var jenisArsipDb = _jenisArsipDal.GetData(kt); jenisArsipDb.Empty().Throw("JENIS ARSIP ID not found"); // REPO-OP _jenisArsipDal.Update(kt); // RETURN return(kt); }
public JenisArsipModel Add(JenisArsipModel jenisArsip) { // INPUT VALIDATION var kt = Validate(jenisArsip); // BUSINESS VALIDATION var jenisArsipDb = _jenisArsipDal.GetData(kt); jenisArsipDb.NotEmpty().Throw("JENIS ARSIP ID already exist"); // REPO-OP _jenisArsipDal.Insert(kt); // RETURN return(kt); }
public void Insert(JenisArsipModel entity) { var sql = @" INSERT INTO OFTA_JenisArsip( JenisArsipID, JenisArsipName) VALUES( @JenisArsipID, @JenisArsipName)"; using (var conn = new SqlConnection(ConnStringHelper.Get())) using (var cmd = new SqlCommand(sql, conn)) { cmd.AddParam("@JenisArsipID", entity.JenisArsipID, SqlDbType.VarChar); cmd.AddParam("@JenisArsipName", entity.JenisArsipName, SqlDbType.VarChar); conn.Open(); cmd.ExecuteNonQuery(); } }
public void Update(JenisArsipModel entity) { var sql = @" UPDATE OFTA_JenisArsip SET JenisArsipName = @JenisArsipName WHERE JenisArsipID = @JenisArsipID"; using (var conn = new SqlConnection(ConnStringHelper.Get())) using (var cmd = new SqlCommand(sql, conn)) { cmd.AddParam("@JenisArsipID", entity.JenisArsipID, SqlDbType.VarChar); cmd.AddParam("@JenisArsipName", entity.JenisArsipName, SqlDbType.VarChar); conn.Open(); cmd.ExecuteNonQuery(); } }
public IHttpActionResult GetData(string jenisArsipID) { var jbtn = new JenisArsipModel { JenisArsipID = jenisArsipID }; try { var result = _jenisArsipBL.GetData(jbtn); if (result is null) { return(BadRequest("Data Not Found")); } return(Ok(result)); } catch (ArgumentException ex) { return(BadRequest(ex.Message)); } }