public void PopulatePlayerFromReader(ThongTinNguoiDung detail_user, IDataReader data)
{
//MessageBox.Show(data.GetString(data.GetOrdinal(ThongTinNguoiDung.DetailUserFields.MaDangNhapNguoiDung.ToString())));
detail_user.MaDangNhapNguoiDung = data.GetString(data.GetOrdinal(ThongTinNguoiDung.DetailUserFields.MaDangNhapNguoiDung.ToString()));
if (!data.IsDBNull(data.GetOrdinal(ThongTinNguoiDung.DetailUserFields.HoTen.ToString())))
{
detail_user.HoTen = data.GetString(data.GetOrdinal(ThongTinNguoiDung.DetailUserFields.HoTen.ToString()));
}
if (!data.IsDBNull(data.GetOrdinal(ThongTinNguoiDung.DetailUserFields.Email.ToString())))
{
detail_user.Email = data.GetString(data.GetOrdinal(ThongTinNguoiDung.DetailUserFields.Email.ToString()));
}
if (!data.IsDBNull(data.GetOrdinal(ThongTinNguoiDung.DetailUserFields.SoDienThoai.ToString())))
{
detail_user.SoDienThoai = data.GetString(data.GetOrdinal(ThongTinNguoiDung.DetailUserFields.SoDienThoai.ToString()));
}
if (!data.IsDBNull(data.GetOrdinal(ThongTinNguoiDung.DetailUserFields.DiaChi.ToString())))
{
detail_user.DiaChi = data.GetString(data.GetOrdinal(ThongTinNguoiDung.DetailUserFields.DiaChi.ToString()));
}
if (!data.IsDBNull(data.GetOrdinal(ThongTinNguoiDung.DetailUserFields.NgaySinh.ToString())))
{
detail_user.NgaySinh = data.GetDateTime(data.GetOrdinal(ThongTinNguoiDung.DetailUserFields.NgaySinh.ToString()));
}
if (!data.IsDBNull(data.GetOrdinal(ThongTinNguoiDung.DetailUserFields.NgayTao.ToString())))
{
detail_user.NgayTao = data.GetDateTime(data.GetOrdinal(ThongTinNguoiDung.DetailUserFields.NgayTao.ToString()));
}
}
public ThongTinNguoiDung Select_Detail(ThongTinNguoiDung detail_user, string ma)
{
SqlCommand command = new SqlCommand("Detail_User @MA", Connection);
command.Parameters.Add(new SqlParameter("@MA", SqlDbType.VarChar, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, ma));
command.CommandType = CommandType.Text;
try
{
Connection.Open();
IDataReader data = command.ExecuteReader();
data.Read();
PopulatePlayerFromReader(detail_user, data);
return(detail_user);
}
catch (Exception ex)
{
Connection.Close();
command.Dispose();
throw new Exception("user::Select Detail User::Error occured.", ex);
}
finally
{
Connection.Close();
command.Dispose();
}
}
public bool Update_Detail(ThongTinNguoiDung detail_user)
{
SqlCommand command = new SqlCommand("Update_Detail_User", Connection);
command.CommandType = CommandType.StoredProcedure;
try
{
command.Parameters.Add(new SqlParameter("@EMAIL", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, detail_user.Email));
command.Parameters.Add(new SqlParameter("@MA", SqlDbType.VarChar, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, detail_user.MaDangNhapNguoiDung));
command.Parameters.Add(new SqlParameter("@SDT", SqlDbType.Char, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, detail_user.SoDienThoai));
command.Parameters.Add(new SqlParameter("@HOTEN", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, detail_user.HoTen));
command.Parameters.Add(new SqlParameter("@NGAYTAO", SqlDbType.DateTime, 15, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, detail_user.NgayTao));
command.Parameters.Add(new SqlParameter("@DC", SqlDbType.NVarChar, 200, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, detail_user.DiaChi));
command.Parameters.Add(new SqlParameter("@NS", SqlDbType.Date, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, detail_user.NgaySinh));
Connection.Open();
command.ExecuteNonQuery();
return(true);
}
catch (SqlException ex)
{
Connection.Close();
command.Dispose();
throw new Exception("Player::UpdatePass::Error occured.", ex);
}
finally
{
Connection.Close();
command.Dispose();
}
}