Esempio n. 1
0
        public static List <ChiTietModel> getAll()
        {
            List <ChiTietModel> list = new List <ChiTietModel>();
            string        cnnstring  = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            SqlConnection cnn        = new SqlConnection(cnnstring);

            cnn.Open();
            string        sql    = "SELECT * FROM tour_chitiet";
            SqlCommand    cmd    = new SqlCommand(sql, cnn);
            SqlDataReader reader = cmd.ExecuteReader();

            while (reader.HasRows)
            {
                while (reader.Read())
                {
                    ChiTietModel ct = new ChiTietModel();
                    ct.ct_id    = reader.GetInt32(0);
                    ct.tour_id  = reader.GetInt32(1);
                    ct.dd_id    = reader.GetInt32(2);
                    ct.ct_thutu = reader.GetInt32(3);
                    list.Add(ct);
                }
                reader.NextResult();
            }
            return(list);
        }
Esempio n. 2
0
        public static void Insert(ChiTietModel ct)
        {
            string        cnnstring = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            SqlConnection cnn       = new SqlConnection(cnnstring);

            cnn.Open();
            string sql = "INSERT INTO tour_chitiet(tour_id, dd_id, ct_thutu) VALUES @tourid, @ddid, @thutu";

            SqlCommand cmd = new SqlCommand(sql, cnn);

            cmd.Parameters.AddWithValue("@tourid", ct.tour_id);
            cmd.Parameters.AddWithValue("@ddid", ct.dd_id);
            cmd.Parameters.AddWithValue("@thutu", ct.ct_thutu);

            cmd.ExecuteNonQuery();
        }
Esempio n. 3
0
        public static void Update(ChiTietModel ct)
        {
            string        cnnstring = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            SqlConnection cnn       = new SqlConnection(cnnstring);

            cnn.Open();
            string sql = "UPDATE tour_chitiet SET tour_id = @tourid, dd_id = @ddid, ct_thutu = @thutu WHERE ct_id = @id";

            SqlCommand cmd = new SqlCommand(sql, cnn);

            cmd.Parameters.AddWithValue("@id", ct.ct_id);
            cmd.Parameters.AddWithValue("@tourid", ct.tour_id);
            cmd.Parameters.AddWithValue("@ddid", ct.dd_id);
            cmd.Parameters.AddWithValue("@thutu", ct.ct_thutu);

            cmd.ExecuteNonQuery();
        }
Esempio n. 4
0
        public static ChiTietModel getDetail(int id)
        {
            ChiTietModel  ct        = new ChiTietModel();
            string        cnnstring = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            SqlConnection cnn       = new SqlConnection(cnnstring);

            cnn.Open();
            string        sql    = "SELECT * FROM tour_chiphi WHERE ct_id=id";
            SqlCommand    cmd    = new SqlCommand(sql, cnn);
            SqlDataReader reader = cmd.ExecuteReader();

            if (reader.HasRows)
            {
                ct.ct_id    = reader.GetInt32(0);
                ct.tour_id  = reader.GetInt32(1);
                ct.dd_id    = reader.GetInt32(2);
                ct.ct_thutu = reader.GetInt32(3);
            }
            return(ct);
        }