public string Put(Tb_SMK tbsmk) { try { //string query = @"Update Anggota set Type_Insurance = '" + ang.Type_Insurance + "' ,Perusahaan ='" + ang.Perusahaan + "', Telp = '" + ang.Telp + "'" //+ ", Fax = '" + ang.Telp + "'" //+ ", Email = '" + ang.Telp + "'" //+ ", CP = '" + ang.Telp + "'" //+ ", KuasaKhusus1 = '" + ang.Telp + "'" //+ ", KuasaKhusus2 = '" + ang.Telp + "'" //+ ", KuasaKhusus3 = '" + ang.Telp + "'" //+ " where idAnggota = '" + ang.idAnggota + "'"; string query = @"UPDATE [LSPdb].[dbo].[Tb_SMK] SET " + " ,[Kode_Kabupaten] = '" + tbsmk.Kode_Kabupaten + "'" + " ,[Nama_Sekolah] = '" + tbsmk.Nama_Sekolah + "'" + " ,[Status_Sekolah] = '" + tbsmk.Status_Sekolah + "'" + " ,[Status_LSP] = '" + tbsmk.Status_LSP + "'" + " ,[Kode_KK] = '" + tbsmk.Kode_KK + "'" + " WHERE [NPSN] = '" + tbsmk.NPSN + "' "; DataTable table = new DataTable(); using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["LSPdb"].ConnectionString)) { using (var cmd = new SqlCommand(query, conn)) { using (var da = new SqlDataAdapter(cmd)) { cmd.CommandType = CommandType.Text; da.Fill(table); } } } return("Update Successfully"); } catch (Exception err) { return(err.Message); } }
public string Post(Tb_SMK tbsmk) { try { //string query = @"Insert Into Anggota([Type_Insurance] ,[Perusahaan] ,[Telp] ,[Fax] ,[Email] ,[CP] ,[KuasaKhusus1] ,[KuasaKhusus2] ,[KuasaKhusus3])" //+ "values ('" + ang.Type_Insurance + "' ,'" + ang.Perusahaan + "','" + ang.Telp + "','" + ang.Fax + "','" + ang.Email + "','" + ang.CP + "','" + ang.KuasaKhusus1 + "','" + ang.KuasaKhusus2 + "','" + ang.KuasaKhusus3 + "' )"; string query = @" INSERT INTO [LSPdb].[dbo].[Tb_SMK] ([NPSN] ,[Kode_Kabupaten] ,[Nama_Sekolah] ,[Status_Sekolah] ,[Status_LSP] ,[Kode_KK]) VALUES " + " ('" + tbsmk.NPSN + "','" + tbsmk.Kode_Kabupaten + "','" + tbsmk.Nama_Sekolah + "','" + tbsmk.Status_Sekolah + "','" + tbsmk.Status_LSP + "','" + tbsmk.Kode_KK + "')"; DataTable table = new DataTable(); using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["LSPdb"].ConnectionString)) { using (var cmd = new SqlCommand(query, conn)) { using (var da = new SqlDataAdapter(cmd)) { cmd.CommandType = CommandType.Text; da.Fill(table); } } } return("Insert Successfully"); } catch (Exception err) { return(err.Message); } }