public static void Export(DetailsView dvGetStudent)
 {
     int rows = dvGetStudent.Rows.Count;
     int columns = dvGetStudent.Rows[0].Cells.Count;
     int pdfTableRows = rows;
     iTextSharp.text.Table PdfTable = new iTextSharp.text.Table(2, pdfTableRows);
     PdfTable.BorderWidth = 1;
     PdfTable.Cellpadding = 0;
     PdfTable.Cellspacing = 0;
     for (int rowCounter = 0; rowCounter < rows; rowCounter++)
     {
         for (int columnCounter = 0; columnCounter < columns; columnCounter++)
         {
             string strValue = dvGetStudent.Rows[rowCounter].Cells[columnCounter].Text;
             PdfTable.AddCell(strValue);
         }
     }
     Document Doc = new Document();
     PdfWriter.GetInstance(Doc, HttpContext.Current.Response.OutputStream);
     Doc.Open();
     Doc.Add(PdfTable);
     Doc.Close();
     HttpContext.Current.Response.ContentType = "application/pdf";
     HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename=StudentDetails.pdf");
     HttpContext.Current.Response.End();
 }

        public static void Export(DetailsView dvGetStudent, string imageFilePath, string filename)
        {
            int rows = dvGetStudent.Rows.Count;
            int columns = dvGetStudent.Rows[0].Cells.Count;
            int pdfTableRows = rows - 1;
            iTextSharp.text.Table PdfTable = new iTextSharp.text.Table(2, pdfTableRows);
            //PdfTable.BorderWidth = 1;
            PdfTable.Cellpadding = 0;
            PdfTable.Cellspacing = 0;
            iTextSharp.text.Image jpg = iTextSharp.text.Image.GetInstance(imageFilePath);
            jpg.Alignment = Element.ALIGN_CENTER;
            jpg.ScaleToFit(150f, 150f);
            string fontUrl = System.AppDomain.CurrentDomain.BaseDirectory + "Files\\arial.ttf";
            BaseFont STF_Helvetica_Russian = BaseFont.CreateFont(fontUrl, BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED);
            Font font = new Font(STF_Helvetica_Russian, Font.DEFAULTSIZE, Font.NORMAL);
            for (int rowCounter = 1; rowCounter < rows; rowCounter++)
            {
                for (int columnCounter = 0; columnCounter < columns; columnCounter++)
                {
                    string strValue = dvGetStudent.Rows[rowCounter].Cells[columnCounter].Text;

                    PdfTable.AddCell(new Paragraph(strValue, font));
                }
            }
            Document Doc = new Document();

            PdfWriter.GetInstance(Doc, HttpContext.Current.Response.OutputStream);
            Doc.Open();
            Doc.Add(jpg);
            Doc.Add(PdfTable);
            Doc.Close();
            HttpContext.Current.Response.ContentType = "application/pdf";
            HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename=" + filename + ".pdf");
            HttpContext.Current.Response.End();
        }

        protected string CoalesceBadges(DetailsView dv)
        {
            var gv = (GridView)dv.FindControl("gvBadgeMembership");
            string badgesList= string.Empty;
            foreach(GridViewRow row in gv.Rows) {
                if(((CheckBox)row.FindControl("isMember")).Checked) {
                    badgesList = string.Format("{0},{1}", badgesList, ((Label)row.FindControl("BID")).Text);
                }
            }
            if(badgesList.Length > 0)
                badgesList = badgesList.Substring(1, badgesList.Length - 1);

            return badgesList;
        }

        public void SetDataObject(object dataObject, DetailsView detailsView) {

            DataObject = dataObject;
            TypeDescriptionProvider typeDescriptionProvider;

            CustomTypeDescriptor = dataObject as ICustomTypeDescriptor;
            Type dataObjectType;

            if (CustomTypeDescriptor == null) {
                dataObjectType = dataObject.GetType();
                typeDescriptionProvider = TypeDescriptor.GetProvider(DataObject);
                CustomTypeDescriptor = typeDescriptionProvider.GetTypeDescriptor(DataObject);
            }
            else {
                dataObjectType = GetEntityType();
                typeDescriptionProvider = new TrivialTypeDescriptionProvider(CustomTypeDescriptor);
            }

            // Set the context type and entity set name on ourselves. Note that in this scenario those
            // concepts are somewhat artificial, since we don't have a real context. 

            // Set the ContextType to the dataObjectType, which is a bit strange but harmless
            Type contextType = dataObjectType;

            ((IDynamicDataSource)this).ContextType = contextType;

            // We can set the entity set name to anything, but using the
            // DataObjectType makes some Dynamic Data error messages clearer.
            ((IDynamicDataSource)this).EntitySetName = dataObjectType.Name;

            MetaModel model = null;
            try {
                model = MetaModel.GetModel(contextType);
            }
            catch {
                model = new MetaModel();
                model.RegisterContext(
                    new SimpleModelProvider(contextType, dataObjectType, dataObject),
                    new ContextConfiguration() {
                        MetadataProviderFactory = (type => typeDescriptionProvider)
                    });
            }

            MetaTable table = model.GetTable(dataObjectType);

            if (detailsView != null) {
                detailsView.RowsGenerator = new AdvancedFieldGenerator(table, false);
            }
        }

        protected void grid_SelectedIndexChanged(Object sender, EventArgs e)
        {
            DetailsView details = new DetailsView();

            GridViewRow selectedRow = grid.SelectedRow;
            String title_id = selectedRow.Cells[1].Text;

            SqlCommand cmd = new SqlCommand("SELECT * from titles where titles.title_id='"+title_id+"';", con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds);

            details.DataSource = ds;
            details.DataBind();
            details.Visible = true;
            details.CssClass = "table table-striped table-hover";
            PlaceHolder3.Controls.Add(details);
        }

        protected override void CreateChildControls()
        {
            _detailsView = new DetailsView
            {
                ID = string.Format("{0}_detailsView", base.ID),
                AutoGenerateRows = false,
                AllowPaging = true
            };

            //Set Paging Events
            _detailsView.PageIndexChanging += DetailsView_PageIndexChanging;

            //Create Custom Field
            var customField = new TemplateField
            {
                HeaderTemplate = new SetTemplate(DataControlRowType.Header, "Name"),
                ItemTemplate = new SetTemplate(DataControlRowType.DataRow)
            };

            //Add custom field to detailsview field
            _detailsView.Fields.Add(customField);

            //Create Bound Field
            var boundField = new BoundField
            {
                DataField = "PhoneNumber",
                HeaderText = "Phone Number",
            };

            //Set header font to bold
            boundField.HeaderStyle.Font.Bold = true;

            //Add bound field to detailsview field
            _detailsView.Fields.Add(boundField);

            //Bind Details View
            DetailsView_DataBind();

            //Add detaisview to composite control
            Controls.Add(_detailsView);
        }

		public void DetailsView_GetPostBackOptions_Null_Argument () {
			DetailsView dv = new DetailsView ();
			dv.Page = new Page ();
			PostBackOptions options = ((IPostBackContainer) dv).GetPostBackOptions (null);
		}

		public void DetailsView_GetPostBackOptions () {
			DetailsView dv = new DetailsView ();
			dv.Page = new Page ();
			IButtonControl btn = new Button ();
			btn.CausesValidation = false;
			Assert.IsFalse (btn.CausesValidation, "DetailsView_GetPostBackOptions #1");
			Assert.AreEqual (String.Empty, btn.CommandName, "DetailsView_GetPostBackOptions #2");
			Assert.AreEqual (String.Empty, btn.CommandArgument, "DetailsView_GetPostBackOptions #3");
			Assert.AreEqual (String.Empty, btn.PostBackUrl, "DetailsView_GetPostBackOptions #4");
			Assert.AreEqual (String.Empty, btn.ValidationGroup, "DetailsView_GetPostBackOptions #5");
			PostBackOptions options = ((IPostBackContainer) dv).GetPostBackOptions (btn);
			Assert.IsFalse (options.PerformValidation, "DetailsView_GetPostBackOptions #6");
			Assert.IsFalse (options.AutoPostBack, "DetailsView_GetPostBackOptions #7");
			Assert.IsFalse (options.TrackFocus, "DetailsView_GetPostBackOptions #8");
			Assert.IsTrue (options.ClientSubmit, "DetailsView_GetPostBackOptions #9");
			Assert.IsTrue (options.RequiresJavaScriptProtocol, "DetailsView_GetPostBackOptions #10");
			Assert.AreEqual ("$", options.Argument, "DetailsView_GetPostBackOptions #11");
			Assert.AreEqual (null, options.ActionUrl, "DetailsView_GetPostBackOptions #12");
			Assert.AreEqual (null, options.ValidationGroup, "DetailsView_GetPostBackOptions #13");

			btn.ValidationGroup = "VG";
			btn.CommandName = "CMD";
			btn.CommandArgument = "ARG";
			btn.PostBackUrl = "Page.aspx";
			Assert.IsFalse (btn.CausesValidation, "DetailsView_GetPostBackOptions #14");
			Assert.AreEqual ("CMD", btn.CommandName, "DetailsView_GetPostBackOptions #15");
			Assert.AreEqual ("ARG", btn.CommandArgument, "DetailsView_GetPostBackOptions #16");
			Assert.AreEqual ("Page.aspx", btn.PostBackUrl, "DetailsView_GetPostBackOptions #17");
			Assert.AreEqual ("VG", btn.ValidationGroup, "DetailsView_GetPostBackOptions #18");
			options = ((IPostBackContainer) dv).GetPostBackOptions (btn);
			Assert.IsFalse (options.PerformValidation, "DetailsView_GetPostBackOptions #19");
			Assert.IsFalse (options.AutoPostBack, "DetailsView_GetPostBackOptions #20");
			Assert.IsFalse (options.TrackFocus, "DetailsView_GetPostBackOptions #21");
			Assert.IsTrue (options.ClientSubmit, "DetailsView_GetPostBackOptions #22");
			Assert.IsTrue (options.RequiresJavaScriptProtocol, "DetailsView_GetPostBackOptions #23");
			Assert.AreEqual ("CMD$ARG", options.Argument, "DetailsView_GetPostBackOptions #24");
			Assert.AreEqual (null, options.ActionUrl, "DetailsView_GetPostBackOptions #25");
			Assert.AreEqual (null, options.ValidationGroup, "DetailsView_GetPostBackOptions #26");
		}

		public void DetailsView_GetPostBackOptions_CausesValidation () {
			DetailsView dv = new DetailsView ();
			dv.Page = new Page ();
			IButtonControl btn = new Button ();
			Assert.IsTrue (btn.CausesValidation);
			Assert.AreEqual (String.Empty, btn.CommandName);
			Assert.AreEqual (String.Empty, btn.CommandArgument);
			Assert.AreEqual (String.Empty, btn.PostBackUrl);
			Assert.AreEqual (String.Empty, btn.ValidationGroup);
			PostBackOptions options = ((IPostBackContainer) dv).GetPostBackOptions (btn);
		}

 /// <summary>
 /// Localizes headers and fields on a DetailsView control
 /// </summary>
 /// <param name="detailsView"></param>
 /// <param name="resourceFile">The root name of the resource file where the localized
 ///  texts can be found</param>
 /// <remarks></remarks>
 public static void LocalizeDetailsView(ref DetailsView detailsView, string resourceFile)
 {
     foreach (DataControlField field in detailsView.Fields)
     {
         LocalizeDataControlField(field, resourceFile);
     }
 }

		public void DetailsView_CurrentMode () {
			DetailsView view = new DetailsView ();
			view.DefaultMode = DetailsViewMode.Insert;
			Assert.AreEqual (DetailsViewMode.Insert, view.CurrentMode, "DetailsView_CurrentMode#1");
			view.ChangeMode (DetailsViewMode.Edit);
			Assert.AreEqual (DetailsViewMode.Edit, view.CurrentMode, "DetailsView_CurrentMode#2");
		}

		/// <summary>
		/// Redirects the client to a new URL after the ItemUpdated event
		/// of the <see cref="DetailsView"/> object has been raised.
		/// </summary>
		/// <param name="view">A <see cref="DetailsView"/> object.</param>
		/// <param name="url">The target location.</param>
		public static void RedirectAfterUpdate(DetailsView view, String url)
		{
			RedirectAfterUpdate(view, url, null);
		}

        public string cArchivoExcelHTMLPorRequerimientoDetalleGrilla(DetailsView objDetailView, string strNombreArchivo, Page objPage, string IdRequerimiento)
        {
            int intIdRequerimiento = int.Parse(IdRequerimiento);

            StringBuilder sb = new StringBuilder();

            #region Creamos la cabecera

            sb.Append(strCrearDocumentoExcelDetalleGrilla(objDetailView, intIdRequerimiento));

            #endregion

            StringWriter sw = new StringWriter(sb);
            HtmlTextWriter htw = new HtmlTextWriter(sw);
            Page page = new Page();
            HtmlForm form = new HtmlForm();

            #region Crea el Archivo Excel
            try
            {
                objDetailView.AllowPaging = false;
                objDetailView.DataBind();
                objDetailView.EnableViewState = false;

                page.EnableEventValidation = false;

                page.DesignerInitialize();
                page.Controls.Add(form);
                form.Controls.Add(objDetailView);

                page.RenderControl(htw);

                objPage.Response.Clear();
                objPage.Response.Buffer = true;
                objPage.Response.ContentType = "application/vnd.ms-excel";
                objPage.Response.AppendHeader("Content-Disposition", "attachment;filename=" + strNombreArchivo + "" + DateTime.Now.ToShortDateString() + ".xls");
                objPage.Response.Charset = "UTF-8";
                objPage.Response.ContentEncoding = System.Text.Encoding.Default;
                objPage.Response.Write(sb.ToString());
                objPage.Response.Flush();
                objPage.Response.Close();
                objPage.Response.End();

            }
            catch (Exception ex)
            {

                return "Error al crear Archivo Excel " + ": " + ex.ToString();
            }
            #endregion

            return "Por favor guardar el archivo Excel creado";
        }

		/// <summary>
		/// Redirects the client to a new URL after the ItemUpdated event of the <see cref="DetailsView"/>
		/// has been raised or after the ItemCommand event of the <see cref="DetailsView"/> object has
		/// been raised with a CommandName of "Cancel".
		/// </summary>
		/// <param name="view">A <see cref="DetailsView"/> object.</param>
		/// <param name="grid">A <see cref="GridView"/> object.</param>
		/// <param name="url">The target location.</param>
		public static void RedirectAfterUpdateCancel(DetailsView view, GridView grid, String url)
		{
			url = GetRedirectUrl(grid, url);
			RedirectAfterUpdateCancel(view, url);
		}

		/// <summary>
		/// Redirects the client to a new URL after the ItemInserted or ItemUpdated event of the <see cref="DetailsView"/>
		/// has been raised or after the ItemCommand event of the <see cref="DetailsView"/> object has
		/// been raised with a CommandName of "Cancel".
		/// </summary>
		/// <param name="view">A <see cref="DetailsView"/> object.</param>
		/// <param name="url">The target location.</param>
		public static void RedirectAfterInsertUpdateCancel(DetailsView view, String url)
		{
			RedirectAfterInsertUpdateCancel(view, url, null);
		}

        private DetailsView GetProjectDetails(UpdateType updateType)
        {
            DetailsView dvProjectDetails = new DetailsView();

            DataTable projectRecord = new DataTable();
            projectRecord.Columns.Add("ProjectId", typeof(Int32));
            projectRecord.Columns.Add("Description", typeof(String));
            DataRow dr = projectRecord.NewRow();
            dr["ProjectId"] = 3;
            dr["Description"] = "Test Project";
            projectRecord.Rows.Add(dr);

            dvProjectDetails.DataSource = projectRecord;
            dvProjectDetails.DataBind();

            switch (updateType)
            {
                case UpdateType.Insert:
                    dvProjectDetails.ChangeMode(DetailsViewMode.Insert);
                    break;
                case UpdateType.Update:
                    dvProjectDetails.ChangeMode(DetailsViewMode.Edit);
                    break;
                //case EditGatewaysPresenterFixture.UpdateType.View:
                //    dvProjectDetails.Rows(p.DetailColumns.PaymentTypeID).Cells[1].Controls.Add(Me.GetPaymentTypeIDLabel);
                //    break;
            }

            return dvProjectDetails;
        }

        protected override void OnLoad(EventArgs e)
        {
            if (!string.IsNullOrEmpty(DetailsViewID) && !string.IsNullOrEmpty(GridViewID))
                throw new InvalidOperationException("Too many controls defined");
            if (string.IsNullOrEmpty(DetailsViewID) && string.IsNullOrEmpty(GridViewID))
                throw new InvalidOperationException("GridView or DetailsView ID is missing");

            if (Items == null)
                Items = new Dictionary<string, StateContainer>();

            _actionMode = string.IsNullOrEmpty(DetailsViewID) ? (string.IsNullOrEmpty(GridViewID) ? ActionMode.None : ActionMode.List) : ActionMode.Edit;

            switch (_actionMode)
            {
                case ActionMode.Edit:
                    _detailView = (DetailsView)Parent.FindControl(DetailsViewID);
                    if (_detailView != null)
                    {
                        _stateName = GetTableName(_detailView);
                        if (!Items.ContainsKey(_stateName))
                            Items.Add(_stateName, new StateContainer());
                    }
                    break;
                case ActionMode.List:
                    _gridView = (GridView)Parent.FindControl(GridViewID);

                    if (_gridView != null)
                    {
                        _stateName = GetTableName(_gridView);
                        if (!Items.ContainsKey(_stateName))
                            Items.Add(_stateName, new StateContainer());

                        _gridView.PageIndexChanged += GridViewPagerIndexChanged;
                        _gridView.Sorted += GridViewSorted;
                        if (_gridView.BottomPagerRow != null && _gridView.BottomPagerRow.Cells[0].FindControl("GridViewPager") != null)
                        {
                            _pageSizer =
                                (DropDownList)
                                _gridView.BottomPagerRow.Cells[0].FindControl("GridViewPager").TemplateControl.FindControl(
                                    "DropDownListPageSize");

                            if (_pageSizer != null)
                                _pageSizer.SelectedIndexChanged += PageSizeChanged;
                        }
                        if (!string.IsNullOrEmpty(FilterRepeaterID))
                        {
                            FilterRepeater filterRepeater = (FilterRepeater)FindControl(Parent.Controls, FilterRepeaterID);
                            if (filterRepeater != null)
                            {
                                List<UserControl> filterControls = GetFilterControls(filterRepeater);
                                _filters = new List<DropDownList>();
                                foreach (UserControl ctl in filterControls)
                                {
                                    DropDownList listbox = ctl.FindControl("DropDownList1") as DropDownList;
                                    if (listbox != null)
                                    {
                                        _filters.Add(listbox);
                                        listbox.SelectedIndexChanged += FilterSelectedIndexChanged;
                                    }
                                }
                                if (_filters.Count > 0)
                                {
                                    Button btnClear = new Button();
                                    btnClear.Text = "Снять все фильтры";
                                    btnClear.Click += ClearFilters;
                                    btnClear.CssClass = "dropdown";
                                    Controls.Add(btnClear);
                                }
                            }
                        }
                    }

                    break;
            }
            if (!string.IsNullOrEmpty(RecentName) && _stateName != RecentName)
                Items[RecentName].Reset();

            RecentName = _stateName;
            base.OnLoad(e);
        }

        protected void SetUp()
        {
            this._DataPath = "/DataFiles";

            this.gvList = new GridView();
            this.dv = new DetailsView();

            this.gvStoryList = new GridView();
        }

        protected void SavePermissions(DetailsView dv, SRPUser obj) {
            GridView gv = (GridView)dv.FindControl("gvUserPermissions");
            string groupPermissions= string.Empty;
            foreach(GridViewRow row in gv.Rows) {
                if(((CheckBox)row.FindControl("isChecked")).Checked) {
                    groupPermissions = string.Format("{0},{1}", groupPermissions, ((Label)row.FindControl("PermissionID")).Text);
                }
            }
            if(groupPermissions.Length > 0)
                groupPermissions = groupPermissions.Substring(1, groupPermissions.Length - 1);

            SRPUser.UpdatePermissions((int)obj.Uid, groupPermissions, ((SRPUser)Session[SessionData.UserProfile.ToString()]).Username);
        }

        protected void SaveGroups(DetailsView dv, SRPUser obj) {
            GridView gv = (GridView)dv.FindControl("gvUserGroups");
            string memberGroups= string.Empty;
            foreach(GridViewRow row in gv.Rows) {
                if(((CheckBox)row.FindControl("isMember")).Checked) {
                    memberGroups = string.Format("{0},{1}", memberGroups, ((Label)row.FindControl("GID")).Text);
                }
            }
            if(memberGroups.Length > 0)
                memberGroups = memberGroups.Substring(1, memberGroups.Length - 1);

            SRPUser.UpdateMemberGroups((int)obj.Uid, memberGroups, ((SRPUser)Session[SessionData.UserProfile.ToString()]).Username);
        }