public bool themTT(TTCayDTO TT) { string query = string.Empty; query += "INSERT INTO [TINHTRANGCAYCANH] ([matinhtrangthang],[thangtt]) "; query += "VALUES (@matinhtrangthang,@thangtt)"; using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@machiphithang", TT.MaTinhTrangThangPT); cmd.Parameters.AddWithValue("@thang", TT.ThangTTPT); try { con.Open(); cmd.ExecuteNonQuery(); con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(false); } } } return(true); }
public bool themlich(TTCayDTO tt) { bool result = TTDAL.themTT(tt); return(result); }