public bool InsertCTChuyenBay(DTO.Chitietchuyenbay CTCB) { string sql = "INSERT INTO CTCHUYENBAY(MACTCB, MACB, MASANBAYTG,THOIGIANDUNG,GHICHU) VALUES(@MACTCB, @MACB, @MASANBAYTG,@THOIGIANDUNG,@GHICHU)"; //string sql2 = "INSERT INTO CTCHUYENBAY(MACTCB, MACB, MASANBAYTG,THOIGIANDUNG,GHICHU) VALUES('MACTCB0003', 'CB0009', 'SB0006',16,'khong')"; SqlConnection con = dc.GetConnect(); try { cmd = new SqlCommand(sql, con); con.Open(); cmd.Parameters.Add("@MACTCB", SqlDbType.VarChar).Value = TaoMa_CT_CB(); cmd.Parameters.Add("@MACB", SqlDbType.VarChar).Value = CTCB.macb; cmd.Parameters.Add("@MASANBAYTG", SqlDbType.VarChar).Value = CTCB.masbtg; cmd.Parameters.Add("@THOIGIANDUNG", SqlDbType.Float).Value = CTCB.thoigiandung; cmd.Parameters.Add("@GHICHU", SqlDbType.NVarChar).Value = CTCB.ghichu; cmd.ExecuteNonQuery(); con.Close(); } catch (Exception e) { return(false); } return(true); }
public bool InsertCTChuyenBay(DTO.Chitietchuyenbay dto) { return(dal.InsertCTChuyenBay(dto)); }