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 void Delete(IJenisSuratDinasKey key) { // INPUT VALIDATION if (key is null) { throw new ArgumentException("JENIS SURAT DINAS ID empty"); } // REPO-OP _jenisSuratDinasDal.Delete(key); }
public JenisSuratDinasModel GetData(IJenisSuratDinasKey key) { // INPUT VALIDATION if (key is null) { throw new ArgumentException("JENIS SURAT DINAS ID empty"); } // REPO-OP var result = _jenisSuratDinasDal.GetData(key); // RETURN return(result); }
public void Delete(IJenisSuratDinasKey key) { var sql = @" DELETE 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(); cmd.ExecuteNonQuery(); } }