public OBJSQL UpdatePelanggan(MPelanggan MPelanggan, string kode) { OBJSQL obj = null; List <MySqlParameter> sqlParam = new List <MySqlParameter>(); sqlParam.Add(new MySqlParameter() { ParameterName = "@kode", MySqlDbType = MySqlDbType.VarChar, Value = MPelanggan.kode }); sqlParam.Add(new MySqlParameter() { ParameterName = "@nama", MySqlDbType = MySqlDbType.VarChar, Value = MPelanggan.nama }); sqlParam.Add(new MySqlParameter() { ParameterName = "@alamat", MySqlDbType = MySqlDbType.VarChar, Value = MPelanggan.alamat }); sqlParam.Add(new MySqlParameter() { ParameterName = "@tlp", MySqlDbType = MySqlDbType.VarChar, Value = MPelanggan.tlp }); sqlParam.Add(new MySqlParameter() { ParameterName = "@email", MySqlDbType = MySqlDbType.VarChar, Value = MPelanggan.email }); sqlParam.Add(new MySqlParameter() { ParameterName = "@keterangan", MySqlDbType = MySqlDbType.VarChar, Value = MPelanggan.keterangan }); string SQLQuery = "UPDATE m_pelanggan set kode=@kode, nama=@nama, alamat=@alamat, tlp=@tlp, email=@email, keterangan=@keterangan where kode= " + kode; obj = h.InsertQuery(SQLQuery, sqlParam); return(obj); }
private void updatePelanggan(string _kode, string _nama, string _alamat, string _tlp, string _email, string _keterangan) { InsertController ic = new InsertController(); ListController lc = new ListController(); MPelanggan i = new MPelanggan() { kode = _kode, nama = _nama, alamat = _alamat, tlp = _tlp, email = _email, keterangan = _keterangan, }; OBJSQL obj = ic.UpdatePelanggan(i, kode); }
/* ============================================================= */ /* TABEL Pelanggan */ #region Tabel Pelanggan public OBJSQL SaveNewPelanggan(MPelanggan MPelanggan) { OBJSQL obj = null; List <MySqlParameter> sqlParam = new List <MySqlParameter>(); sqlParam.Add(new MySqlParameter() { ParameterName = "@kode", MySqlDbType = MySqlDbType.VarChar, Value = MPelanggan.kode }); sqlParam.Add(new MySqlParameter() { ParameterName = "@nama", MySqlDbType = MySqlDbType.VarChar, Value = MPelanggan.nama }); sqlParam.Add(new MySqlParameter() { ParameterName = "@alamat", MySqlDbType = MySqlDbType.VarChar, Value = MPelanggan.alamat }); sqlParam.Add(new MySqlParameter() { ParameterName = "@tlp", MySqlDbType = MySqlDbType.VarChar, Value = MPelanggan.tlp }); sqlParam.Add(new MySqlParameter() { ParameterName = "@email", MySqlDbType = MySqlDbType.VarChar, Value = MPelanggan.email }); sqlParam.Add(new MySqlParameter() { ParameterName = "@keterangan", MySqlDbType = MySqlDbType.VarChar, Value = MPelanggan.keterangan }); String SQLQuery = "INSERT INTO m_pelanggan (kode, nama, alamat, tlp, email, keterangan) " + "VALUES (@kode, @nama, @alamat, @tlp, @email, @keterangan); "; obj = h.InsertQuery(SQLQuery, sqlParam); return(obj); }