public JenisLunasModel GetData(string id) { JenisLunasModel result = null; var sSql = @" SELECT aa.JenisLunasName, aa.JenisBiayaID, ISNULL(bb.JenisBiayaName, '') JenisBiayaName FROM JenisLunas aa LEFT JOIN JenisBiaya bb ON aa.JenisBiayaID = bb.JenisBiayaID WHERE aa.JenisLunasID = @JenisLunasID "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@JenisLunasID", id); conn.Open(); using (var dr = cmd.ExecuteReader()) { if (dr.HasRows) { dr.Read(); result = new JenisLunasModel { JenisLunasID = id, JenisLunasName = dr["JenisLunasName"].ToString(), JenisBiayaID = dr["JenisBiayaID"].ToString(), JenisBiayaName = dr["JenisBiayaName"].ToString() }; } } } return(result); }
public JenisLunasModel TryValidate(JenisLunasModel jenisLunas) { var result = jenisLunas; if (jenisLunas == null) { throw new ArgumentNullException(nameof(jenisLunas)); } if (jenisLunas.JenisLunasID.Trim() == "") { throw new ArgumentException("JenisLunasID empty"); } if (jenisLunas.JenisLunasName.Trim() == "") { throw new ArgumentException("JenisLunasName empty"); } if (jenisLunas.JenisBiayaID.Trim() != "") { var jenisBiaya = _jenisBiayaBL.GetData(jenisLunas.JenisBiayaID); if (jenisBiaya == null) { throw new ArgumentException("JenisBiayaID invalid"); } } return(result); }
JenisLunasModel JenisLunas2DataFactory() { var result = new JenisLunasModel { JenisLunasID = "A2", JenisLunasName = "B2", JenisBiayaID = "C2", JenisBiayaName = "" }; return(result); }
public void Insert(JenisLunasModel jenisLunas) { var sSql = @" INSERT INTO JenisLunas ( JenisLunasID, JenisLunasName, JenisBiayaID ) VALUES ( @JenisLunasID, @JenisLunasName, @JenisBiayaID) "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@JenisLunasID", jenisLunas.JenisLunasID); cmd.AddParam("@JenisLunasName", jenisLunas.JenisLunasName); cmd.AddParam("@JenisBiayaID", jenisLunas.JenisBiayaID); conn.Open(); cmd.ExecuteNonQuery(); } }
public void Update(JenisLunasModel jenisLunas) { var sSql = @" UPDATE JenisLunas SET JenisLunasName = @JenisLunasName, JenisBiayaID = @JenisBiayaID WHERE JenisLunasID = @JenisLunasID "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@JenisLunasID", jenisLunas.JenisLunasID); cmd.AddParam("@JenisLunasName", jenisLunas.JenisLunasName); cmd.AddParam("@JenisBiayaID", jenisLunas.JenisBiayaID); conn.Open(); cmd.ExecuteNonQuery(); } }
public JenisLunasModel Save(JenisLunasModel jenisLunas) { // validasi var result = jenisLunas; result = TryValidate(jenisLunas); // save var dummyJenisLunas = _jenisLunasDal.GetData(jenisLunas.JenisLunasID); if (dummyJenisLunas == null) { _jenisLunasDal.Insert(result); } else { _jenisLunasDal.Update(result); } return(result); }
public IEnumerable <JenisLunasModel> ListData() { List <JenisLunasModel> result = null; var sSql = @" SELECT aa.JenisLunasID, aa.JenisLunasName, aa.JenisBiayaID, ISNULL(bb.JenisBiayaName, '') JenisBiayaName FROM JenisLunas aa LEFT JOIN JenisBiaya bb ON aa.JenisBiayaID = bb.JenisBiayaID "; 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 <JenisLunasModel>(); while (dr.Read()) { var item = new JenisLunasModel { JenisLunasID = dr["JenisLunasID"].ToString(), JenisLunasName = dr["JenisLunasName"].ToString(), JenisBiayaID = dr["JenisBiayaID"].ToString(), JenisBiayaName = dr["JenisBiayaName"].ToString() }; result.Add(item); } } } } return(result); }