public static int Add(NgonNguDto nn)
{
OleDbConnection cn;
cn = DataProvider.ConnectionData();
string strSQL;
strSQL = "Insert into NgonNgu(TenNgonNgu) values (?)";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@TenNgonNgu", OleDbType.WChar);
cmd.Parameters["@TenNgonNgu"].Value = nn.TenNgonNgu;
cmd.ExecuteNonQuery();
strSQL = "Select @@IDENTITY";
cmd = new OleDbCommand(strSQL, cn);
nn.MaNgonNgu = (int)cmd.ExecuteScalar();
cn.Close();
return nn.MaNgonNgu;
}
public static IList GetList()
{
ArrayList ds = new ArrayList();
OleDbConnection cn;
cn = DataProvider.ConnectionData();
string strSQL;
strSQL = "Select * From NgonNgu";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
OleDbDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
NgonNguDto nn = new NgonNguDto();
nn.MaNgonNgu = (int)dr["MNgonNgu"];
nn.TenNgonNgu = (String)dr["TenNgonNgu"];
ds.Add(nn);
}
dr.Close();
cn.Close();
return ds;
}
public static NgonNguDto Search(int MaNn)
{
NgonNguDto nn = null;
OleDbConnection cn;
cn = DataProvider.ConnectionData();
string strSQL;
strSQL = "Select * From NgonNgu Where MNgonNgu= ? ";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@MNgonNgu", OleDbType.Integer);
cmd.Parameters["@MNgonNgu"].Value = MaNn;
OleDbDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
nn = new NgonNguDto();
nn.MaNgonNgu = (int)dr["MNgonNgu"];
nn.TenNgonNgu = (String)dr["TenNgonNgu"];
}
dr.Close();
cn.Close();
return nn;
}
public static void Update(NgonNguDto nn)
{
OleDbConnection cn;
cn = DataProvider.ConnectionData();
string strSQL;
strSQL = "Update NgonNgu Set TenNgonNgu = ? Where MNgonNgu = ?";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@TenNgonNgu", OleDbType.WChar);
cmd.Parameters.Add("@MNgonNgu", OleDbType.Integer);
cmd.Parameters["@TenNgonNgu"].Value = nn.TenNgonNgu;
cmd.Parameters["@MNgonNgu"].Value = nn.MaNgonNgu;
cmd.ExecuteNonQuery();
cn.Close();
}
public static void Update(NgonNguDto nn)
{
NgonNguDao.Update(nn);
}
public static int Add(NgonNguDto nn)
{
return NgonNguDao.Add(nn);
}
