示例#1
0
        public static List <DiaDiemModel> getAll()
        {
            List <DiaDiemModel> list = new List <DiaDiemModel>();
            string        cnnstring  = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            SqlConnection cnn        = new SqlConnection(cnnstring);

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

            while (reader.HasRows)
            {
                while (reader.Read())
                {
                    DiaDiemModel dd = new DiaDiemModel();
                    dd.dd_id       = reader.GetInt32(0);
                    dd.dd_thanhpho = reader.GetString(1);
                    dd.dd_ten      = reader.GetString(2);
                    dd.dd_mota     = reader.GetString(3);
                    list.Add(dd);
                }
                reader.NextResult();
            }
            return(list);
        }
示例#2
0
        public static void Insert(DiaDiemModel dd)
        {
            string        cnnstring = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            SqlConnection cnn       = new SqlConnection(cnnstring);

            cnn.Open();
            string sql = "INSERT INTO tour_diadiem(dd_thanhpho, dd_ten, dd_mota) VALUES @tp, @ten, @mota";

            SqlCommand cmd = new SqlCommand(sql, cnn);

            cmd.Parameters.AddWithValue("@tp", dd.dd_thanhpho);
            cmd.Parameters.AddWithValue("@ten", dd.dd_ten);
            cmd.Parameters.AddWithValue("@mota", dd.dd_mota);

            cmd.ExecuteNonQuery();
        }
示例#3
0
        public static void Update(DiaDiemModel dd)
        {
            string        cnnstring = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            SqlConnection cnn       = new SqlConnection(cnnstring);

            cnn.Open();
            string sql = "UPDATE tour_diadiem SET dd_thanhpho =@ tp, @ten = dd_ten, @mota = dd_mota WHERE dd_id = @id";

            SqlCommand cmd = new SqlCommand(sql, cnn);

            cmd.Parameters.AddWithValue("@id", dd.dd_id);
            cmd.Parameters.AddWithValue("@tp", dd.dd_thanhpho);
            cmd.Parameters.AddWithValue("@ten", dd.dd_ten);
            cmd.Parameters.AddWithValue("@mota", dd.dd_mota);

            cmd.ExecuteNonQuery();
        }
示例#4
0
        public static DiaDiemModel getDetail(int id)
        {
            DiaDiemModel  dd        = new DiaDiemModel();
            string        cnnstring = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            SqlConnection cnn       = new SqlConnection(cnnstring);

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

            if (reader.HasRows)
            {
                dd.dd_id       = reader.GetInt32(0);
                dd.dd_thanhpho = reader.GetString(1);
                dd.dd_ten      = reader.GetString(2);
                dd.dd_mota     = reader.GetString(3);
            }
            return(dd);
        }