public JenisBrgModel GetData(string id) { JenisBrgModel result = null; var sSql = @" SELECT aa.JenisBrgName FROM JenisBrg aa WHERE aa.JenisBrgID = @JenisBrgID "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@JenisBrgID", id); conn.Open(); using (var dr = cmd.ExecuteReader()) { if (dr.HasRows) { dr.Read(); result = new JenisBrgModel { JenisBrgID = id, JenisBrgName = dr["JenisBrgName"].ToString() }; } } } return(result); }
public IEnumerable <JenisBrgModel> ListData() { List <JenisBrgModel> result = null; var sSql = @" SELECT aa.JenisBrgID, aa.JenisBrgName FROM JenisBrg 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 <JenisBrgModel>(); while (dr.Read()) { var item = new JenisBrgModel { JenisBrgID = dr["JenisBrgID"].ToString(), JenisBrgName = dr["JenisBrgName"].ToString() }; result.Add(item); } } } } return(result); }
JenisBrgModel JenisBrg2DataFactory() { var result = new JenisBrgModel { JenisBrgID = "A2", JenisBrgName = "B2" }; return(result); }
JenisBrgModel JenisBrgDataFactory() { var result = new JenisBrgModel { JenisBrgID = "A1", JenisBrgName = "B1", }; return(result); }
private void OKButton_Click(object sender, EventArgs e) { var jenisBrg = new JenisBrgModel { JenisBrgID = JenisBrgIDTextBox.Text, JenisBrgName = JenisBrgNameTextBox.Text }; var result = _jenisBrgBL.Save(jenisBrg); DialogResult = DialogResult.OK; }
public void Insert(JenisBrgModel jenisBrg) { var sSql = @" INSERT INTO JenisBrg ( JenisBrgID, JenisBrgName) VALUES ( @JenisBrgID, @JenisBrgName) "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@JenisBrgID", jenisBrg.JenisBrgID); cmd.AddParam("@JenisBrgName", jenisBrg.JenisBrgName); conn.Open(); cmd.ExecuteNonQuery(); } }
public void Update(JenisBrgModel jenisBrg) { var sSql = @" UPDATE JenisBrg SET JenisBrgName = @JenisBrgName WHERE JenisBrgID = @JenisBrgID "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@JenisBrgID", jenisBrg.JenisBrgID); cmd.AddParam("@JenisBrgName", jenisBrg.JenisBrgName); conn.Open(); cmd.ExecuteNonQuery(); } }
public JenisBrgModel TryValidate(JenisBrgModel jenisBrg) { var result = jenisBrg; if (jenisBrg == null) { throw new ArgumentNullException(nameof(jenisBrg)); } if (jenisBrg.JenisBrgID.Trim() == "") { throw new ArgumentException("JenisBrgID empty"); } if (jenisBrg.JenisBrgName.Trim() == "") { throw new ArgumentException("JenisBrgName empty"); } return(result); }
public JenisBrgModel Save(JenisBrgModel jenisBrg) { // validasi var result = jenisBrg; result = TryValidate(jenisBrg); // save var dummyJenisBrg = _jenisBrgDal.GetData(jenisBrg.JenisBrgID); if (dummyJenisBrg == null) { _jenisBrgDal.Insert(result); } else { _jenisBrgDal.Update(result); } return(result); }