public string Post(Tb_Kompetensi_Keahlian_Terlisensi tbkkt)
{
try
{
string query = @"
INSERT INTO [dbo].[Tb_Kompetensi_Keahlian_Terlisensi]
([Kode_KK_Terlisensi]
,[Nomer_Lisensi]
,[Kode_KK]
,[Status_KK_Terlisensi]
,[Jumlah_asesor])
VALUES"
+ "('" + tbkkt.Kode_KK_Terlisensi + "','" + tbkkt.Nomer_Lisensi + "','" + tbkkt.Kode_KK + "','" + tbkkt.Status_KK_Terlisensi + "','" + tbkkt.Jumlah_asesor + "')";
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);
}
}
public string Put(Tb_Kompetensi_Keahlian_Terlisensi tbkkt)
{
try
{
string query = @"UPDATE [dbo].[Tb_Kompetensi_Keahlian_Terlisensi] SET "
+ " ,[Nomer_Lisensi] = '" + tbkkt.Nomer_Lisensi + "'"
+ " ,[Kode_KK] = '" + tbkkt.Kode_KK + "'"
+ " ,[Status_KK_Terlisensi] = '" + tbkkt.Status_KK_Terlisensi + "'"
+ " ,[Jumlah_asesor] = '" + tbkkt.Jumlah_asesor + "'"
+ " WHERE [Kode_KK_Terlisensi] = '" + tbkkt.Kode_KK_Terlisensi + "' ";
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);
}
}
