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