public static void Themnd(DTO_ND nd)
{
SqlCommand cmd = new SqlCommand("sp_themND", DataProvider.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@mand", SqlDbType.VarChar, 50);
cmd.Parameters.Add("@mannd", SqlDbType.VarChar, 50);
cmd.Parameters.Add("@manv", SqlDbType.VarChar, 50);
cmd.Parameters.Add("@tennd", SqlDbType.NVarChar, 100);
cmd.Parameters.Add("@tentk", SqlDbType.VarChar, 100);
cmd.Parameters.Add("@password", SqlDbType.NVarChar, 500);
cmd.Parameters.Add("@ngaytaotk", SqlDbType.VarChar, 100);
cmd.Parameters.Add("@danhmuctc", SqlDbType.NVarChar, 500);
cmd.Parameters.Add("@quyendm", SqlDbType.NVarChar, 500);
//Gan gia tri
cmd.Parameters[0].Value = nd.Mand;
cmd.Parameters[1].Value = nd.Mannd;
cmd.Parameters[2].Value = nd.Manv;
cmd.Parameters[3].Value = nd.Tennd;
cmd.Parameters[4].Value = nd.Tentk;
cmd.Parameters[5].Value = nd.Password;
cmd.Parameters[6].Value = nd.Ngaytaotk;
cmd.Parameters[7].Value = nd.Danhmuctc;
cmd.Parameters[8].Value = nd.Quyendm;
if (DataProvider.con.State == ConnectionState.Closed)
{
DataProvider.con.Open();
}
cmd.ExecuteNonQuery();
DataProvider.disconnect();
}
public static void Suand(DTO_ND nd)
{
SqlCommand cmd = new SqlCommand("sp_suaND", DataProvider.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@mand", SqlDbType.VarChar, 50);
cmd.Parameters.Add("@mannd", SqlDbType.VarChar, 50);
cmd.Parameters.Add("@danhmuctc", SqlDbType.NVarChar, 500);
cmd.Parameters.Add("@quyendm", SqlDbType.NVarChar, 500);
//Gan gia tri
cmd.Parameters[0].Value = nd.Mand;
cmd.Parameters[1].Value = nd.Mannd;
cmd.Parameters[2].Value = nd.Danhmuctc;
cmd.Parameters[3].Value = nd.Quyendm;
if (DataProvider.con.State == ConnectionState.Closed)
{
DataProvider.con.Open();
}
cmd.ExecuteNonQuery();
DataProvider.disconnect();
}
public static void suaND(DTO_ND nd)
{
DAO_ND.Suand(nd);
}
public static void themND(DTO_ND nd)
{
DAO_ND.Themnd(nd);
}
