public string Put(Tb_Admin_Provinsi tbadprov)
{
try
{
string query = @"UPDATE [dbo].[Tb_Admin_Provinsi] SET "
+ " ,[Password] = '" + tbadprov.Password + "'"
+ " ,[NamaLengkap] = '" + tbadprov.NamaLengkap + "'"
+ " WHERE [Username] = '" + tbadprov.Username + "'";
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_Admin_Provinsi tbadprov)
{
try
{
string query = @"
INSERT INTO [dbo].[Tb_Admin_Provinsi]
([Username]
,[Password]
,[NamaLengkap])
VALUES"
+ " ('" + tbadprov.Username + "','" + tbadprov.Password + "','" + tbadprov.NamaLengkap + "')";
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);
}
}
