//tim ca si
public Singer findSinger(int SingerID)
{
SqlConnection cnn = new SqlConnection(strConnection);
string SQL = "Select SingerID, SingerName, SingerAge, SingerEmail from Singer where SingerID=@SingerID";
SqlCommand cmd = new SqlCommand(SQL, cnn);
cmd.Parameters.AddWithValue("@SingerID", SingerID);
if (cnn.State == ConnectionState.Closed)
{
cnn.Open();
}
Singer s = null;
SqlDataReader reader = cmd.ExecuteReader();
{
while (reader.Read())
{
Console.WriteLine(String.Format("{0}, {1}, {2}, {3}", reader[0], reader[1], reader[2], reader[3]));
var ID = reader[0];
var Name = reader[1];
var Age = reader[2];
var Email = reader[3];
s = new Singer
{
SingerID = (int)ID,
SingerName = (string)Name,
SingerAge = (int)Age,
SingerEmail = (string)Email
};
break;
}
}
return(s);
}
//Them ca si
public bool addSinger(Singer singer)
{
SqlConnection cnn = new SqlConnection(strConnection);
string SQL = "Insert Singer values(@SingerID,@SingerName,@SingerAge,@SingerEmail)";
SqlCommand cmd = new SqlCommand(SQL, cnn);
cmd.Parameters.AddWithValue("@SingerID", singer.SingerID);
cmd.Parameters.AddWithValue("@SingerName", singer.SingerName);
cmd.Parameters.AddWithValue("@SingerAge", singer.SingerAge);
cmd.Parameters.AddWithValue("@SingerEmail", singer.SingerEmail);
if (cnn.State == ConnectionState.Closed)
{
cnn.Open();
}
int count = cmd.ExecuteNonQuery();
return(count > 0);
}
