public NguoiDungInfo Check_Login(string TenDN, string MatKhau) { string sql = @"SELECT * FROM NGUOIDUNG WHERE TenDN=@TenDN AND MatKhau=@MatKhau"; SqlDataReader dr = null; using (SqlCommand cmd = new SqlCommand(sql, getConnet())) { cmd.Parameters.AddWithValue("@TenDN", TenDN); cmd.Parameters.AddWithValue("@MatKhau", MatKhau); dr = cmd.ExecuteReader(); if (dr.Read()) { NguoiDungInfo dt = new NguoiDungInfo { TenDN = (string)dr["TenDN"], HoTen = (string)dr["HoTen"], NgaySinh = (string)dr["NgaySinh"], GioiTinh = (string)dr["GioiTinh"], DiaChi = (string)dr["DiaChi"], Email = (string)dr["Email"] }; dr.Close(); return(dt); } else { dr.Close(); } } return(null); }
public NguoiDungInfo Get_TenDT(string TenDN) { string sql = @"SELECT * FROM NGUOIDUNG where TenDN=@TenDN"; using (SqlCommand cmd = new SqlCommand(sql, getConnet())) { cmd.Parameters.Add(new SqlParameter("@TenDN", TenDN)); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { NguoiDungInfo nd = new NguoiDungInfo { TenDN = (string)dr["TenDN"], MatKhau = (string)dr["MatKhau"], HoTen = (string)dr["HoTen"], NgaySinh = (string)dr["NgaySinh"], GioiTinh = (string)dr["GioiTinh"], DiaChi = (string)dr["DiaChi"], Email = (string)dr["Email"] }; dr.Close(); return(nd); } } return(null); }
public bool NguoiDung_Insert(NguoiDungInfo data) { string sql = @"INSERT INTO dbo.NGUOIDUNG(TenDN, MatKhau, HoTen , NgaySinh, GioiTinh, DiaChi, ,Email ) VALUES (@TenDangNhap,@MatKhau, @Email, @HoTen, @SDT, @DiaChi)"; using (SqlCommand cmd = new SqlCommand(sql, getConnet())) { cmd.Parameters.Add(new SqlParameter("@TenDN", data.TenDN)); cmd.Parameters.Add(new SqlParameter("@MatKhau", data.MatKhau)); cmd.Parameters.Add(new SqlParameter("@HoTen", data.HoTen)); cmd.Parameters.Add(new SqlParameter("@NgaySinh", data.NgaySinh)); cmd.Parameters.Add(new SqlParameter("@GioiTinh", data.GioiTinh)); cmd.Parameters.Add(new SqlParameter("@DiaChi", data.DiaChi)); cmd.Parameters.Add(new SqlParameter("@Email", data.Email)); int t = (int)cmd.ExecuteNonQuery(); return(t >= 1); } }