public int simpanberita(string idberita, string idkatberita, string judul, string tanggal, string isiberita, string sumber, string idadmin, string foto) { crud con = new crud(); SqlConnection sqlcon = con.sambung(); int result = 0; using (sqlcon) { sqlcon.Open(); string sql = "INSERT INTO Berita VALUES(@ID_Berita, @ID_Kategori, @Judul, @Tanggal, @IsiBerita, @Sumber, @ID_Admin, @Foto)"; SqlCommand sqlcom = new SqlCommand(sql, sqlcon); using (sqlcom) { sqlcom.Parameters.Add(new SqlParameter("@ID_Berita", idberita)); sqlcom.Parameters.Add(new SqlParameter("@ID_Kategori", idkatberita)); sqlcom.Parameters.Add(new SqlParameter("@Judul", judul)); sqlcom.Parameters.Add(new SqlParameter("@Tanggal", tanggal)); sqlcom.Parameters.Add(new SqlParameter("@IsiBerita", isiberita)); sqlcom.Parameters.Add(new SqlParameter("@Sumber", sumber)); sqlcom.Parameters.Add(new SqlParameter("@ID_Admin", idadmin)); sqlcom.Parameters.Add(new SqlParameter("@Foto", foto)); sqlcom.ExecuteNonQuery(); } //HttpResponse.ReferenceEquals("KatBerita.aspx"); } return(result); }
public void DeleteAdmin(string IDAdmin) { crud con = new crud(); conn = con.sambung(); using (conn) { conn.Open(); string sql = "DELETE FROM Admin WHERE ID_Admin = @ID_Admin"; SqlCommand sqlcom = new SqlCommand(sql, conn); using (sqlcom) { sqlcom.Parameters.Add(new SqlParameter("@ID_Admin", IDAdmin)); sqlcom.ExecuteNonQuery(); } conn.Close(); } }
public void Delete(string IDcat) { crud con = new crud(); conn = con.sambung(); using (conn) { conn.Open(); string sql = "DELETE FROM Kategori WHERE ID_Kategori = @ID_Kategori"; SqlCommand sqlcom = new SqlCommand(sql, conn); using (sqlcom) { sqlcom.Parameters.Add(new SqlParameter("@ID_Kategori", IDcat)); sqlcom.ExecuteNonQuery(); } conn.Close(); } }
public void ubah(string idkat, string namakat) { crud con = new crud(); conn = con.sambung(); using (conn) { conn.Open(); string sql = "UPDATE Kategori SET NamaKategori = @NamaKategori WHERE ID_Kategori = @ID_Kategori"; SqlCommand sqlcom = new SqlCommand(sql, conn); using (sqlcom) { sqlcom.Parameters.Add(new SqlParameter("@ID_Kategori", idkat)); sqlcom.Parameters.Add(new SqlParameter("@NamaKategori", namakat)); sqlcom.ExecuteNonQuery(); } conn.Close(); } }
public void simpan(string id, string nama) { crud con = new crud(); SqlConnection sqlcon = con.sambung(); using (sqlcon) { sqlcon.Open(); string sql = "INSERT INTO Kategori VALUES(@ID_Kategori, @NamaKategori)"; SqlCommand sqlcom = new SqlCommand(sql, sqlcon); using (sqlcom) { sqlcom.Parameters.Add(new SqlParameter("@ID_Kategori", id)); sqlcom.Parameters.Add(new SqlParameter("@NamaKategori", nama)); sqlcom.ExecuteNonQuery(); } sqlcon.Close(); //HttpResponse.ReferenceEquals("KatBerita.aspx"); } }
//crud untuk berita //public void cbIDkasus() //{ // crud con = new crud(); // SqlConnection sqlcon = con.sambung(); // SqlDataAdapter sqlda = new SqlDataAdapter("select * from Kategori", sqlcon); // sqlcon.Open(); // SqlCommand sqlselect = new SqlCommand("Select ID_Kategori from Kategori", sqlcon); // SqlDataReader dr = sqlselect.ExecuteReader(); // while (dr.Read()) // { // ArrayList MyAL = new ArrayList(); // MyAL.Add(dr.GetString(0)); // foreach (string s in MyAL) // cbidkasus.Items.Add(s); // cbidkasus.SelectedIndex = 0; // } // sqlcon.Close(); //} // crud untuk admin public void ubahAdmin(string idA, string namaA, string username, string pass) { crud con = new crud(); conn = con.sambung(); using (conn) { conn.Open(); string sql = "UPDATE Admin SET Nama = @Nama, Username = @Username, Password = @Password WHERE ID_Admin = @ID_Admin"; SqlCommand sqlcom = new SqlCommand(sql, conn); using (sqlcom) { sqlcom.Parameters.Add(new SqlParameter("@ID_Admin", idA)); sqlcom.Parameters.Add(new SqlParameter("@Nama", namaA)); sqlcom.Parameters.Add(new SqlParameter("@Username", username)); sqlcom.Parameters.Add(new SqlParameter("@Password", pass)); sqlcom.ExecuteNonQuery(); } conn.Close(); } }
public void simpanadmin(string id, string nama, string user, string password) { crud con = new crud(); SqlConnection sqlcon = con.sambung(); using (sqlcon) { sqlcon.Open(); string sql = "INSERT INTO Admin VALUES(@ID_Admin, @Nama, @Username, @Password)"; SqlCommand sqlcom = new SqlCommand(sql, sqlcon); using (sqlcom) { sqlcom.Parameters.Add(new SqlParameter("@ID_Admin", id)); sqlcom.Parameters.Add(new SqlParameter("@Nama", nama)); sqlcom.Parameters.Add(new SqlParameter("@Username", user)); sqlcom.Parameters.Add(new SqlParameter("@Password", password)); sqlcom.ExecuteNonQuery(); } sqlcon.Close(); //HttpResponse.ReferenceEquals("KatBerita.aspx"); } }