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); }