public void Delete(IPegKey key) { // INPUT VALIDATION if (key is null) { throw new ArgumentException("PEGAWAI ID empty"); } // REPO-OP _pegDal.Delete(key); }
public PegModel GetData(IPegKey key) { // INPUT VALIDATION if (key is null) { throw new ArgumentException("PEGAWAI ID empty"); } // REPO-OP var result = _pegDal.GetData(key); // RETURN return(result); }
public void Delete(IPegKey key) { var sql = @" DELETE OFTA_Peg WHERE PegID = @PegID "; using (var conn = new SqlConnection(ConnStringHelper.Get())) using (var cmd = new SqlCommand(sql, conn)) { cmd.AddParam("@PegID", key.PegID, SqlDbType.VarChar); conn.Open(); cmd.ExecuteNonQuery(); } }
public PegModel GetData(IPegKey key) { PegModel result = null; var sql = @" SELECT aa.PegID, aa.PegName, aa.JabatanID, ISNULL(bb.JabatanName, '') JabatanName FROM OFTA_Peg aa LEFT JOIN OFTA_Jabatan bb ON aa.JabatanID = bb.JabatanID WHERE PegID = @PegID "; using (var conn = new SqlConnection(ConnStringHelper.Get())) using (var cmd = new SqlCommand(sql, conn)) { cmd.AddParam("@PegID", key.PegID, SqlDbType.VarChar); conn.Open(); using (var dr = cmd.ExecuteReader()) { if (!dr.HasRows) { return(null); } dr.Read(); result = new PegModel { PegID = dr["PegID"].ToString(), PegName = dr["PegName"].ToString(), JabatanID = dr["JabatanID"].ToString(), JabatanName = dr["JabatanName"].ToString() }; } } return(result); }