public HT_Nguoi_Dung_Dang_Nhap_Chi_Tiet Lay(int Ma_Dang_Nhap)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("HT_Nguoi_Dung_Dang_Nhap_Lay", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pMa_Dang_Nhap = new SqlParameter("@Ma_Dang_Nhap", SqlDbType.Int, 4);
pMa_Dang_Nhap.Value = Ma_Dang_Nhap;
myCommand.Parameters.Add(pMa_Dang_Nhap);
SqlDataAdapter myAdapter = new SqlDataAdapter();
DataSet myDataSet = new DataSet();
myConnection.Open();
myAdapter.SelectCommand = myCommand;
myAdapter.Fill(myDataSet, "HT_Nguoi_Dung_Dang_Nhap_Chi_Tiet");
HT_Nguoi_Dung_Dang_Nhap_Chi_Tiet myHT_Nguoi_Dung_Dang_Nhap_Chi_Tiet = new HT_Nguoi_Dung_Dang_Nhap_Chi_Tiet();
if (myDataSet.Tables["HT_Nguoi_Dung_Dang_Nhap_Chi_Tiet"] != null)
{
myHT_Nguoi_Dung_Dang_Nhap_Chi_Tiet.Ma_Dang_Nhap = Ma_Dang_Nhap;
myHT_Nguoi_Dung_Dang_Nhap_Chi_Tiet.Ma_Nguoi_Dung = myDataSet.Tables["HT_Nguoi_Dung_Dang_Nhap_Chi_Tiet"].Rows[0]["Ma_Nguoi_Dung"] != DBNull.Value?(int?)myDataSet.Tables["HT_Nguoi_Dung_Dang_Nhap_Chi_Tiet"].Rows[0]["Ma_Nguoi_Dung"]:(int?)null;
myHT_Nguoi_Dung_Dang_Nhap_Chi_Tiet.Ngay_Dang_Nhap = myDataSet.Tables["HT_Nguoi_Dung_Dang_Nhap_Chi_Tiet"].Rows[0]["Ngay_Dang_Nhap"] != DBNull.Value?(DateTime?)myDataSet.Tables["HT_Nguoi_Dung_Dang_Nhap_Chi_Tiet"].Rows[0]["Ngay_Dang_Nhap"]:(DateTime?)null;
myHT_Nguoi_Dung_Dang_Nhap_Chi_Tiet.Kieu_Dang_Nhap = myDataSet.Tables["HT_Nguoi_Dung_Dang_Nhap_Chi_Tiet"].Rows[0]["Kieu_Dang_Nhap"] != DBNull.Value?(string)myDataSet.Tables["HT_Nguoi_Dung_Dang_Nhap_Chi_Tiet"].Rows[0]["Kieu_Dang_Nhap"]:(string)null;
}
return(myHT_Nguoi_Dung_Dang_Nhap_Chi_Tiet);
}
}
}
public void Cap_Nhat(HT_Nguoi_Dung_Dang_Nhap_Chi_Tiet myHT_Nguoi_Dung_Dang_Nhap_Chi_Tiet)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("HT_Nguoi_Dung_Dang_Nhap_Cap_Nhat", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pMa_Dang_Nhap = new SqlParameter("@Ma_Dang_Nhap", SqlDbType.Int, 4);
pMa_Dang_Nhap.Value = myHT_Nguoi_Dung_Dang_Nhap_Chi_Tiet.Ma_Dang_Nhap;
myCommand.Parameters.Add(pMa_Dang_Nhap);
SqlParameter pMa_Nguoi_Dung = new SqlParameter("@Ma_Nguoi_Dung", SqlDbType.Int, 4);
pMa_Nguoi_Dung.Value = myHT_Nguoi_Dung_Dang_Nhap_Chi_Tiet.Ma_Nguoi_Dung;
myCommand.Parameters.Add(pMa_Nguoi_Dung);
SqlParameter pNgay_Dang_Nhap = new SqlParameter("@Ngay_Dang_Nhap", SqlDbType.DateTime, 8);
pNgay_Dang_Nhap.Value = myHT_Nguoi_Dung_Dang_Nhap_Chi_Tiet.Ngay_Dang_Nhap;
myCommand.Parameters.Add(pNgay_Dang_Nhap);
SqlParameter pKieu_Dang_Nhap = new SqlParameter("@Kieu_Dang_Nhap", SqlDbType.VarChar, 10);
pKieu_Dang_Nhap.Value = myHT_Nguoi_Dung_Dang_Nhap_Chi_Tiet.Kieu_Dang_Nhap;
myCommand.Parameters.Add(pKieu_Dang_Nhap);
myConnection.Open();
myCommand.ExecuteNonQuery();
}
}
}
