public IEnumerable <PegawaiModel> ListData() { List <PegawaiModel> result = null; var sSql = @" SELECT aa.PegawaiID, aa.PegawaiName FROM Pegawai 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 <PegawaiModel>(); while (dr.Read()) { var item = new PegawaiModel { PegawaiID = dr["PegawaiID"].ToString(), PegawaiName = dr["PegawaiName"].ToString() }; result.Add(item); } } } } return(result); }
public PegawaiModel GetData(string id) { PegawaiModel result = null; var sSql = @" SELECT aa.PegawaiName FROM Pegawai aa WHERE aa.PegawaiID = @PegawaiID "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@PegawaiID", id); conn.Open(); using (var dr = cmd.ExecuteReader()) { if (dr.HasRows) { dr.Read(); result = new PegawaiModel { PegawaiID = id, PegawaiName = dr["PegawaiName"].ToString() }; } } } return(result); }
public PihakKeduaModel Save(PegawaiModel pegawai) { PihakKeduaModel result = new PihakKeduaModel { PihakKeduaID = pegawai.PegawaiID, PihakKeduaName = pegawai.PegawaiName }; return(_Save(result)); }
public void Save() { var pegawai = new PegawaiModel { PegawaiID = _view.PegawaiID, PegawaiName = _view.PegawaiName, Alamat = _view.Alamat, NoTelp = _view.NoTelp }; var result = _pegawaiBL.Save(pegawai); }
public void Insert(PegawaiModel model) { var sSql = @" INSERT INTO Pegawai ( PegawaiID, PegawaiName) VALUES ( @PegawaiID, @PegawaiName) "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@PegawaiID", model.PegawaiID); cmd.AddParam("@PegawaiName", model.PegawaiName); conn.Open(); cmd.ExecuteNonQuery(); } }
public void Update(PegawaiModel model) { var sSql = @" UPDATE Pegawai SET PegawaiName = @PegawaiName WHERE PegawaiID = @PegawaiID "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@PegawaiID", model.PegawaiID); cmd.AddParam("@PegawaiName", model.PegawaiName); conn.Open(); cmd.ExecuteNonQuery(); } }
public PegawaiModel Save(PegawaiModel pegawai) { if (pegawai == null) { throw new ArgumentNullException(nameof(pegawai)); } if (pegawai.PegawaiName.Trim() == "") { throw new ArgumentException("Pegawai Name kosong"); } using (var trans = TransHelper.NewScope()) { if (pegawai.PegawaiID.Trim() == "") { pegawai.PegawaiID = GenNewID(); } // simapn (hapus >> simpan) _pegawaiDal.Delete(pegawai.PegawaiID); _pegawaiDal.Insert(pegawai); // update pihak kedua _pihakKeduaDal.Delete(pegawai.PegawaiID); var pihakKedua = new PihakKeduaModel { PihakKeduaID = pegawai.PegawaiID, PihakKeduaName = pegawai.PegawaiName }; _pihakKeduaDal.Insert(pihakKedua); trans.Complete(); } return(pegawai); }