public bool themlichtrinh(tblLichtrinh ltr)
{
using (SqlConnection cnn = dtcn.getconnect())
{
cnn.Open();
try
{
using (SqlCommand cmd = new SqlCommand("them_lichtrinh", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@matuyen", ltr.Fk_matx);
cmd.Parameters.AddWithValue("@diemden", ltr.diemden);
cmd.Parameters.AddWithValue("@gia", ltr.giave);
cmd.Parameters.AddWithValue("@trangthai", ltr.trangthai);
cmd.ExecuteNonQuery();
cnn.Close();
}
}
catch (Exception e)
{
return(false);
}
return(true);
}
}
public bool updateltr(tblLichtrinh ltr)
{
using (SqlConnection cnn = dtcn.getconnect())
{
cnn.Open();
try
{
using (SqlCommand cmd = new SqlCommand("updateltr", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@maltr", ltr.malt);
cmd.Parameters.AddWithValue("@trangthai ", ltr.trangthai);
cmd.ExecuteNonQuery();
cnn.Close();
}
}
catch (Exception e)
{
return(false);
}
return(true);
}
}
