public bool updateTk(tbltk tk)
{
using (SqlConnection cnn = dtcn.getconnect())
{
cnn.Open();
try
{
using (SqlCommand cmd = new SqlCommand("updatetk", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@matk", tk.Matk);
cmd.Parameters.AddWithValue("@maquyen", tk.Fk_maquyen);
cmd.Parameters.AddWithValue("@tendn", tk.Tendn);
cmd.Parameters.AddWithValue("@mk", tk.Matkhau);
cmd.Parameters.AddWithValue("@trangthai ", tk.Trangthai);
cmd.ExecuteNonQuery();
cnn.Close();
}
}
catch (Exception e)
{
return(false);
}
return(true);
}
}
public DataTable timkiem_tk(tbltk tk)
{
DataTable data = new DataTable();
using (SqlConnection cnn = dtcn.getconnect())
{
cnn.Open();
using (SqlCommand cmd = new SqlCommand("timkiem_tk", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@maquyen", tk.Fk_maquyen);
cmd.Parameters.AddWithValue("@tendn", tk.Tendn);
SqlDataReader abc = cmd.ExecuteReader();
if (abc.HasRows)
{
data.Load(abc);
}
cnn.Close();
return(data);
}
}
}
