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();
}
}
}
