public List <Docgia> Show()
{
List <Docgia> lst = new List <Docgia>();
if (con.State != ConnectionState.Open)
{
con.Open();
}
SqlCommand sc = new SqlCommand("xem_docgia", con);
sc.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(sc);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow row in dt.Rows)
{
Docgia Docgia = new Docgia();
Docgia.cmnd = row[0].ToString();
Docgia.ten = row[1].ToString();
Docgia.ngaysinh = row[2].ToString();
Docgia.diachi = row[3].ToString();
Docgia.gioitinh = row[4].ToString();
Docgia.taikhoan = row[5].ToString();
Docgia.matkhau = row[6].ToString();
lst.Add(Docgia);
}
con.Close();
return(lst);
}
public void Add(Docgia docgia)
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
SqlCommand sc = new SqlCommand("them_docgia", con);
sc.Parameters.Add(new SqlParameter("cmnd", docgia.cmnd));
sc.Parameters.Add(new SqlParameter("ten", docgia.ten));
sc.Parameters.Add(new SqlParameter("ngaysinh", docgia.ngaysinh));
sc.Parameters.Add(new SqlParameter("diachi", docgia.diachi));
sc.Parameters.Add(new SqlParameter("gioitinh", docgia.gioitinh));
sc.Parameters.Add(new SqlParameter("taikhoan", docgia.taikhoan));
sc.Parameters.Add(new SqlParameter("matkhau", docgia.matkhau));
sc.CommandType = CommandType.StoredProcedure;
sc.ExecuteNonQuery();
con.Close();
}