コード例 #1
0
        public NV_MediaLib_ChiTiet GetByUrl(string url)
        {
            using (SqlConnection myConnection = new SqlConnection(ConnectionString))
            {
                using (SqlCommand myCommand = new SqlCommand("NV_MediaLib_getByUrl", myConnection))
                {
                    myCommand.CommandType = CommandType.StoredProcedure;

                    SqlParameter pID = new SqlParameter("@Url", SqlDbType.NVarChar, 200);
                    pID.Value = url;
                    myCommand.Parameters.Add(pID);

                    NV_MediaLib_ChiTiet model = new NV_MediaLib_ChiTiet();
                    DataTable           dt;

                    myConnection.Open();
                    using (SqlDataAdapter mData = new SqlDataAdapter(myCommand))
                    {
                        dt = new DataTable();
                        mData.Fill(dt);
                    }
                    if (dt != null && dt.Rows.Count > 0)
                    {
                        model = new NV_MediaLib_ChiTiet(dt.Rows[0]);
                    }
                    return(model);
                }
            }
        }
コード例 #2
0
        public bool ThemMediaLib(NV_MediaLib_ChiTiet model)
        {
            using (SqlConnection myConnection = new SqlConnection(ConnectionString))
            {
                using (SqlCommand myCommand = new SqlCommand("NV_MediaLib_add", myConnection))
                {
                    myCommand.CommandType = CommandType.StoredProcedure;

                    SqlParameter pTenMediaLib = new SqlParameter("@TenMediaLib", SqlDbType.NVarChar, 500);
                    pTenMediaLib.Value = model.TenMediaLib;
                    myCommand.Parameters.Add(pTenMediaLib);

                    SqlParameter pTypeMedia = new SqlParameter("@TypeMedia", SqlDbType.Int);
                    pTypeMedia.Value = model.TypeMedia;
                    myCommand.Parameters.Add(pTypeMedia);

                    SqlParameter pMoTa = new SqlParameter("@MoTa", SqlDbType.NText);
                    pMoTa.Value = model.MoTa;
                    myCommand.Parameters.Add(pMoTa);

                    SqlParameter pHoatDongID = new SqlParameter("@HoatDongID", SqlDbType.Int);
                    pHoatDongID.Value = model.HoatDongID;
                    myCommand.Parameters.Add(pHoatDongID);

                    SqlParameter pHinhAnh = new SqlParameter("@HinhAnh", SqlDbType.Int);
                    pHinhAnh.Value = model.HinhAnh;
                    myCommand.Parameters.Add(pHinhAnh);

                    SqlParameter pDiSanID = new SqlParameter("@DiSanID", SqlDbType.Int);
                    pDiSanID.Value = model.DiSanID;
                    myCommand.Parameters.Add(pDiSanID);

                    SqlParameter pNgayTao = new SqlParameter("@NgayTao", SqlDbType.DateTime);
                    pNgayTao.Value = model.NgayTao;
                    myCommand.Parameters.Add(pNgayTao);

                    SqlParameter pNgaySua = new SqlParameter("@NgaySua", SqlDbType.DateTime);
                    pNgaySua.Value = model.NgaySua;
                    myCommand.Parameters.Add(pNgaySua);

                    SqlParameter pNguoiTao = new SqlParameter("@NguoiTao", SqlDbType.NVarChar, 200);
                    pNguoiTao.Value = model.NguoiTao;
                    myCommand.Parameters.Add(pNguoiTao);

                    SqlParameter pDuyet = new SqlParameter("@Duyet", SqlDbType.Bit);
                    pDuyet.Value = model.Duyet;
                    myCommand.Parameters.Add(pDuyet);

                    SqlParameter pMediaArray = new SqlParameter("@MediaArray", SqlDbType.NVarChar, 500);
                    pMediaArray.Value = model.MediaArray;
                    myCommand.Parameters.Add(pMediaArray);

                    SqlParameter pDanhMuc = new SqlParameter("@DanhMuc", SqlDbType.NVarChar, 200);
                    pDanhMuc.Value = model.DanhMuc;
                    myCommand.Parameters.Add(pDanhMuc);

                    SqlParameter pPageTitle = new SqlParameter("@PageTitle", SqlDbType.NVarChar, 200);
                    pPageTitle.Value = model.PageTitle;
                    myCommand.Parameters.Add(pPageTitle);

                    SqlParameter pMetaKeyword = new SqlParameter("@MetaKeyword", SqlDbType.NVarChar, 200);
                    pMetaKeyword.Value = model.MetaKeyword;
                    myCommand.Parameters.Add(pMetaKeyword);

                    SqlParameter pMetaDescription = new SqlParameter("@MetaDescription", SqlDbType.NVarChar, 300);
                    pMetaDescription.Value = model.MetaDescription;
                    myCommand.Parameters.Add(pMetaDescription);

                    SqlParameter pUrl = new SqlParameter("@Url", SqlDbType.NVarChar, 200);
                    pUrl.Value = model.Url;
                    myCommand.Parameters.Add(pUrl);

                    try
                    {
                        myConnection.Open();
                        myCommand.ExecuteNonQuery();
                        return(true);
                    }
                    catch
                    {
                        return(false);
                    }
                }
            }
        }