public int UpdateCongNhan(congnhan cn) { using (MySqlConnection conn = GetConnection()) { conn.Open(); var str = "update CONGNHAN set TenCongNhan = @tencongnhan, GioiTinh = @gt, NamSinh = @ns, NuocVe = @nv where MaCongNhan=@macongnhan"; MySqlCommand cmd = new MySqlCommand(str, conn); cmd.Parameters.AddWithValue("macongnhan", cn.MaCongNhan); cmd.Parameters.AddWithValue("tencongnhan", cn.TenCongNhan); cmd.Parameters.AddWithValue("gt", cn.GioiTinh); cmd.Parameters.AddWithValue("ns", cn.NamSinh); cmd.Parameters.AddWithValue("nv", cn.NuocVe); return(cmd.ExecuteNonQuery()); } }
public congnhan ViewCongNhan(string Id) { congnhan cn = new congnhan(); using (MySqlConnection conn = GetConnection()) { conn.Open(); var str = "select * from congnhan where MaCongNhan=@mcn"; MySqlCommand cmd = new MySqlCommand(str, conn); cmd.Parameters.AddWithValue("mcn", Id); using (var reader = cmd.ExecuteReader()) { reader.Read(); cn.MaCongNhan = reader["MaCongNhan"].ToString(); cn.TenCongNhan = reader["TenCongNhan"].ToString(); cn.GioiTinh = bool.Parse(reader["GioiTinh"].ToString()); cn.NamSinh = int.Parse(reader["NamSinh"].ToString()); cn.NuocVe = reader["NuocVe"].ToString(); } } return(cn); }