public Biodata GetBiodata(Biodata p) { Biodata biodata = new Biodata(); try { comm.CommandText = "SELECT * FROM TBioadata WHERE Id=@id"; comm.Parameters.AddWithValue("Id", p.Id); comm.CommandType = CommandType.Text; conn.Open(); SqlDataReader reader = comm.ExecuteReader(); while (reader.Read()) { biodata.Id = Convert.ToInt32(reader[0]); biodata.Nama = reader[1].ToString(); biodata.Umur = Convert.ToInt32(reader[2]); } return(biodata); } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } } }
public int HapusBiodata(Biodata p) { try { comm.CommandText = "DELETE FROM TBioadata WHERE Id=@Id"; comm.Parameters.AddWithValue("Id", p.Id); comm.CommandType = CommandType.Text; conn.Open(); return(comm.ExecuteNonQuery()); } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } } }
public int EditBiodata(Biodata p) { try { comm.CommandText = "UPDATE TBioadata SET Nama=@Nama, Umur=@Umur WHERE Id=@Id"; comm.Parameters.AddWithValue("Id", p.Id); comm.Parameters.AddWithValue("Nama", p.Nama); comm.Parameters.AddWithValue("Umur", p.Umur); comm.CommandType = CommandType.Text; conn.Open(); return(comm.ExecuteNonQuery()); } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } } }
public int TambahBiodata(Biodata p) { try { comm.CommandText = "INSERT INTO TBioadata VALUES(@Id, @Nama, @Umur)"; comm.Parameters.AddWithValue("Id", p.Id); comm.Parameters.AddWithValue("Nama", p.Nama); comm.Parameters.AddWithValue("Umur", p.Umur); comm.CommandType = CommandType.Text; conn.Open(); return(comm.ExecuteNonQuery()); } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } } }
public List <Biodata> GetAllBiodata() { List <Biodata> biodataList = new List <Biodata>(); try { comm.CommandText = "SELECT * FROM TBioadata"; comm.CommandType = CommandType.Text; conn.Open(); SqlDataReader reader = comm.ExecuteReader(); while (reader.Read()) { Biodata biodata = new Biodata() { Id = Convert.ToInt32(reader[0]), Nama = reader[1].ToString(), Umur = Convert.ToInt32(reader[2]) }; biodataList.Add(biodata); } return(biodataList); } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } } }