//---them thong tin bang Nguoi Lon
//create proc sp_ThemThongTinNguoiLon @maBN int,
//@email nvarchar, @dienthoai int, @maTK int
public void sp_ThemThongTinNguoiLon(NguoiLonInfo info)
{
dataService.Conect();
dataService.Cmd = new SqlCommand("sp_ThemThongTinNguoiLon", dataService.Cnn);
dataService.Cmd.CommandType = CommandType.StoredProcedure;
dataService.Cmd.Parameters.Add("@maBN", SqlDbType.Int);
dataService.Cmd.Parameters["@maBN"].Value = info.MaBenhNhan;
dataService.Cmd.Parameters.Add("@email", SqlDbType.NVarChar);
dataService.Cmd.Parameters["@email"].Value = info.Email;
dataService.Cmd.Parameters.Add("@dienthoai", SqlDbType.Int);
dataService.Cmd.Parameters["@dienthoai"].Value = info.DienThoai;
dataService.Cmd.Parameters.Add("@maTK", SqlDbType.Int);
dataService.Cmd.Parameters["@maTK"].Value = info.MaTaiKhoan;
dataService.Cmd.ExecuteNonQuery();
dataService.DisConect();
}
public void sp_ThemThongTinNguoiLon(NguoiLonInfo info)
{
accNguoilon.sp_ThemThongTinNguoiLon(info);
}