public TipeBrgModel GetData(string id) { TipeBrgModel result = null; var sSql = @" SELECT aa.TipeBrgName, aa.JenisBrgID, ISNULL(bb.JenisBrgName, '') JenisBrgName FROM TipeBrg aa LEFT JOIN JenisBrg bb ON aa.JenisBrgID = bb.JenisBrgID WHERE aa.TipeBrgID = @TipeBrgID "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@TipeBrgID", id); conn.Open(); using (var dr = cmd.ExecuteReader()) { if (dr.HasRows) { dr.Read(); result = new TipeBrgModel { TipeBrgID = id, TipeBrgName = dr["TipeBrgName"].ToString(), JenisBrgID = dr["JenisBrgID"].ToString(), JenisBrgName = dr["JenisBrgName"].ToString() }; } } } return(result); }
private void OKButton_Click(object sender, EventArgs e) { var model = new TipeBrgModel { TipeBrgID = TipeBrgIDTextBox.Text, TipeBrgName = TipeBrgNameTextBox.Text, JenisBrgID = JenisBrgIDTextBox.Text }; var resultSave = _tipeBrgBL.Save(model); DialogResult = DialogResult.OK; }
public void Insert(TipeBrgModel tipeBrg) { var sSql = @" INSERT INTO TipeBrg ( TipeBrgID, TipeBrgName, JenisBrgID) VALUES ( @TipeBrgID, @TipeBrgName, @JenisBrgID) "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@TipeBrgID", tipeBrg.TipeBrgID); cmd.AddParam("@TipeBrgName", tipeBrg.TipeBrgName); cmd.AddParam("@JenisBrgID", tipeBrg.JenisBrgID); conn.Open(); cmd.ExecuteNonQuery(); } }
public TipeBrgModel TryValidate(TipeBrgModel tipeBrg) { var result = tipeBrg; if (tipeBrg == null) { throw new ArgumentNullException(nameof(tipeBrg)); } if (tipeBrg.TipeBrgID.Trim() == "") { throw new ArgumentException("TipeBrgID empty"); } if (tipeBrg.TipeBrgName.Trim() == "") { throw new ArgumentException("TipeBrgName empty"); } return(result); }
public TipeBrgModel Save(TipeBrgModel tipeBrg) { // validasi var result = tipeBrg; result = TryValidate(tipeBrg); // save var dummyTipeBrg = _tipeBrgDal.GetData(tipeBrg.TipeBrgID); if (dummyTipeBrg == null) { _tipeBrgDal.Insert(result); } else { _tipeBrgDal.Update(result); } return(result); }
public void Update(TipeBrgModel tipeBrg) { var sSql = @" UPDATE TipeBrg SET TipeBrgName = @TipeBrgName, JenisBrgID = @JenisBrgID WHERE TipeBrgID = @TipeBrgID "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@TipeBrgID", tipeBrg.TipeBrgID); cmd.AddParam("@TipeBrgName", tipeBrg.TipeBrgName); cmd.AddParam("@JenisBrgID", tipeBrg.JenisBrgID); conn.Open(); cmd.ExecuteNonQuery(); } }
public IEnumerable <TipeBrgModel> ListData(string jenisBrgID) { List <TipeBrgModel> result = null; var sSql = @" SELECT aa.TipeBrgID, aa.TipeBrgName, aa.JenisBrgID, ISNULL(bb.JenisBrgName, '') JenisBrgName FROM TipeBrg aa LEFT JOIN JenisBrg bb ON aa.JenisBrgID = bb.JenisBrgID WHERE aa.JenisBrgID = @JenisBrgID "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@JenisBrgID", jenisBrgID); conn.Open(); using (var dr = cmd.ExecuteReader()) { if (dr.HasRows) { result = new List <TipeBrgModel>(); while (dr.Read()) { var item = new TipeBrgModel { TipeBrgID = dr["TipeBrgID"].ToString(), TipeBrgName = dr["TipeBrgName"].ToString(), JenisBrgID = dr["JenisBrgID"].ToString(), JenisBrgName = dr["JenisBrgName"].ToString() }; result.Add(item); } } } } return(result); }