예제 #1
0
        public NV_Video_ChiTiet GetById(int id)
        {
            using (SqlConnection myConnection = new SqlConnection(ConnectionString))
            {
                using (SqlCommand myCommand = new SqlCommand("NV_Video_getByID", myConnection))
                {
                    myCommand.CommandType = CommandType.StoredProcedure;

                    SqlParameter pID = new SqlParameter("@id", SqlDbType.Int);
                    pID.Value = id;
                    myCommand.Parameters.Add(pID);

                    NV_Video_ChiTiet model = new NV_Video_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_Video_ChiTiet(dt.Rows[0]);
                    }
                    return(model);
                }
            }
        }
예제 #2
0
        public bool update(NV_Video_ChiTiet model)
        {
            using (SqlConnection myConnection = new SqlConnection(ConnectionString))
            {
                using (SqlCommand myCommand = new SqlCommand("NV_Video_update", myConnection))
                {
                    myCommand.CommandType = CommandType.StoredProcedure;

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

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

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

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

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

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


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