public DataTable get_MarcDatafieldTable() { DataTable marcTable = create_MarcDataTable(); CDatafield Df = new CDatafield(); DataRow nRow; //add datafields for (int i = 0; i < this.Datafields.Count; i++) { Df = this.Datafields.Datafield(i); for (int j = 0; j < Df.Subfields.Count; j++) { nRow = marcTable.NewRow(); nRow["TAG"] = Df.Tag; nRow["TAG_INDEX"] = i + 1; nRow["INDICATOR"] = Df.Ind1 + Df.Ind2; nRow["SUBFIELD_ID"] = String.IsNullOrEmpty(Df.Subfields.Subfield(j).ID) ? 0 : int.Parse(Df.Subfields.Subfield(j).ID); nRow["SUBFIELD_CODE"] = Df.Subfields.Subfield(j).Code; nRow["SUBFIELD_TYPE"] = Df.Subfields.Subfield(j).Type; nRow["SUBFIELD_VALUE"] = Df.Subfields.Subfield(j).Value; marcTable.Rows.Add(nRow); } } return(marcTable); }
public void bind_TableDataToMarc(ref DataTable marcDataTable) { if (marcDataTable.Rows.Count == 0) { return; } //remove all old datafields while (this.Datafields.Count > 0) { this.Datafields.Remove(0); this.Datafields.Refresh(); } for (int i = 0; i < marcDataTable.Rows.Count; i++) { CDatafield Df = new CDatafield(); int tagIndex = int.Parse(marcDataTable.Rows[i]["TAG_INDEX"].ToString()); Df.Tag = marcDataTable.Rows[i]["TAG"].ToString(); while ((i < marcDataTable.Rows.Count) && (tagIndex == int.Parse(marcDataTable.Rows[i]["TAG_INDEX"].ToString()))) { CSubfield Sf = new CSubfield(); Sf.ID = marcDataTable.Rows[i]["SUBFIELD_ID"].ToString(); Sf.Code = marcDataTable.Rows[i]["SUBFIELD_CODE"].ToString(); Sf.Type = marcDataTable.Rows[i]["SUBFIELD_TYPE"].ToString(); Sf.Value = marcDataTable.Rows[i]["SUBFIELD_VALUE"].ToString(); Df.Subfields.Add(Sf); i++; } i--;//back to for step this.Datafields.Add(Df); } }
public void Take_LinkRelatedContents() { try { if (Session["METADATA"] == null) { Response.Redirect("MetaContentEditor.aspx"); } LegoWebAdmin.DataProvider.ContentEditorDataHelper _MetaContentObject = new ContentEditorDataHelper(); _MetaContentObject.load_Xml(Session["METADATA"].ToString()); DataTable marcTable = _MetaContentObject.get_MarcDatafieldTable(); CDatafield Df = new CDatafield(); for (int i = 0; i < this.metaContentManagerRepeater.Items.Count; i++) { CheckBox cbRow = ((CheckBox)metaContentManagerRepeater.Items[i].FindControl("chkSelect")); if (cbRow.Checked == true) { TextBox txtMetaContentId = (TextBox)metaContentManagerRepeater.Items[i].FindControl("txtMetaContentId"); if (txtMetaContentId != null) { int iTagIndex = marcTable.Rows.Count; Int32 iMetaContentId = Int32.Parse(txtMetaContentId.Text); Label labelMetaContentTitle = (Label)metaContentManagerRepeater.Items[i].FindControl("labelMetaContentTitle"); if (labelMetaContentTitle != null) { DataRow addRow = marcTable.NewRow(); addRow["TAG"] = 780; addRow["TAG_INDEX"] = iTagIndex; addRow["SUBFIELD_CODE"] = "t"; addRow["SUBFIELD_LABEL"] = " "; addRow["SUBFIELD_TYPE"] = "TEXT"; addRow["SUBFIELD_VALUE"] = labelMetaContentTitle.Text; marcTable.Rows.Add(addRow); addRow = marcTable.NewRow(); addRow["TAG"] = 780; addRow["TAG_INDEX"] = iTagIndex; addRow["SUBFIELD_CODE"] = "w"; addRow["SUBFIELD_LABEL"] = " "; addRow["SUBFIELD_TYPE"] = "NUMBER"; addRow["SUBFIELD_VALUE"] = iMetaContentId; marcTable.Rows.Add(addRow); } } } } _MetaContentObject.bind_TableDataToMarc(ref marcTable); Session["METADATA"] = _MetaContentObject.OuterXml; Response.Redirect("MetaContentEditor.aspx"); } catch (Exception ex) { throw ex; } }
protected void listAddTag_SelectedIndexChanged(object sender, EventArgs e) { CRecord labelRec = new CRecord(); string labelFileName = FileTemplateDataProvider.get_LabelTemplateFile(LegoWebAdmin.BusLogic.Categories.get_CATEGORY_TEMPLATE_NAME(int.Parse(dropCategories.SelectedValue.ToString()))); labelRec.load_File(labelFileName); listAddSubfieldCode.Items.Clear(); listAddSubfieldCode.Items.Add(new ListItem("All", "")); CDatafield Df = new CDatafield(); if (labelRec.Datafields.get_Datafield(listAddTag.SelectedValue, ref Df)) { for (int i = 0; i < Df.Subfields.Count; i++) { listAddSubfieldCode.Items.Add(new ListItem(Df.Subfields.Subfield(i).Value, Df.Subfields.Subfield(i).Code)); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!String.IsNullOrEmpty(_box_css_name)) { if (_box_css_name.IndexOf("-title-") > 0) { string sBoxTop = String.Format("<div id=\"{0}\"><div class=\"t\"><div class=\"t\"><div class=\"t\"></div></div></div><div class=\"title\">{1}</div><div class=\"m\"><div class=\"clearfix\">", _box_css_name, LegoWebSite.Buslgic.CommonParameters.asign_COMMON_PARAMETER(this.Title)); string sBoxBottom = "</div><div class=\"clr\"></div></div><div class=\"b\"><div class=\"b\"><div class=\"b\"></div></div></div></div>"; this.litBoxTop.Text = sBoxTop; this.litBoxBottom.Text = sBoxBottom; } else { string sBoxTop = String.Format("<div id=\"{0}\"><div class=\"t\"><div class=\"t\"><div class=\"t\"></div></div></div><div class=\"m\"><div class=\"clearfix\">", _box_css_name); string sBoxBottom = "</div><div class=\"clr\"></div></div><div class=\"b\"><div class=\"b\"><div class=\"b\"></div></div></div></div>"; this.litBoxTop.Text = sBoxTop; this.litBoxBottom.Text = sBoxBottom; } } string sliderShowScript = @" <script type='text/javascript'> $(document).ready(function() { //Execute the slideShow slideShow(); }); function slideShow() { //Resize the heigh of the div according to the image heigh $('#gallery').css({height: $('#gallery a').find('img').css('height')}); //Set the opacity of all images to 0 $('#gallery a').css({opacity: 0.0}); //Get the first image and display it (set it to full opacity) $('#gallery a:first').css({opacity: 1.0}); //Set the caption background to semi-transparent $('#gallery .caption').css({opacity: 0.7}); //Resize the width of the caption according to the image width $('#gallery .caption').css({width: $('#gallery a').find('img').css('width')}); //Get the caption of the first image from REL attribute and display it $('#gallery .content').html($('#gallery a:first').find('img').attr('rel')) .animate({opacity: 0.7}, 400); //Call the gallery function to run the slideshow, 6000 = change to next image after 6 seconds setInterval('gallery()',6000); } function gallery() { //if no IMGs have the show class, grab the first image var current = ($('#gallery a.show')? $('#gallery a.show') : $('#gallery a:first')); //Get next image, if it reached the end of the slideshow, rotate it back to the first image var next = ((current.next().length) ? ((current.next().hasClass('caption'))? $('#gallery a:first') :current.next()) : $('#gallery a:first')); //Get next image caption var caption = next.find('img').attr('rel'); //Set the fade in effect for the next image, show class has higher z-index next.css({opacity: 0.0}) .addClass('show') .animate({opacity: 1.0}, 1000); //Hide the current image current.animate({opacity: 0.0}, 1000) .removeClass('show'); //Set the opacity to 0 and height to 1px $('#gallery .caption').animate({opacity: 0.0}, { queue:false, duration:0 }).animate({height: '1px'}, { queue:true, duration:300 }); //Animate the caption, opacity to 0.7 and heigth to 100px, a slide up effect $('#gallery .caption').animate({opacity: 0.7},100 ).animate({height: '65px'},500 ); //Display the content $('#gallery .content').html(caption); } </script> "; int contentid = discover_content_id(); if ((contentid <= 0) || (contentid > 0 && !LegoWebSite.Buslgic.MetaContents.is_META_CONTENTS_EXIST(contentid))) { this.litContent.Text = "<H3>No suitable data!</H3>"; return; } CRecord myRec = new CRecord(); string sMetaXml = LegoWebSite.Buslgic.MetaContents.get_META_CONTENT_MARCXML(contentid, 0); myRec.load_Xml(sMetaXml); myRec.Sort(); string sdefaultHeight = myRec.Datafields.Datafield("300").Subfields.Subfield("h").Value; string sdefaultWidth = myRec.Datafields.Datafield("300").Subfields.Subfield("w").Value; CDatafields Dfs = myRec.Datafields; Dfs.Filter("856"); if (Dfs.Count == 0) { this.litContent.Text = "<H3>No image info</H3>"; return; } else { string sSliderHTML = "<div id='gallery'>"; string aFormat = "<a href='{0}' {1}> <img src='{2}' alt='{3}' width='{4}' height='{5}' rel='<h3>{3}</h3>{6}'/></a>"; for (int i = 0; i < Dfs.Count; i++) { CDatafield Df = Dfs.Datafield(i); if (i == 0) { sSliderHTML += String.Format(aFormat, String.IsNullOrEmpty(Df.Subfields.Subfield("l").Value) ? "#" : Df.Subfields.Subfield("l").Value, " class='show'", Df.Subfields.Subfield("u").Value, Df.Subfields.Subfield("3").Value, String.IsNullOrEmpty(Df.Subfields.Subfield("w").Value) == true ? sdefaultWidth : Df.Subfields.Subfield("w").Value, String.IsNullOrEmpty(Df.Subfields.Subfield("h").Value) == true ? sdefaultHeight: Df.Subfields.Subfield("h").Value, Df.Subfields.Subfield("a").Value); } else { sSliderHTML += String.Format(aFormat, String.IsNullOrEmpty(Df.Subfields.Subfield("l").Value) ? "#" : Df.Subfields.Subfield("l").Value, "", Df.Subfields.Subfield("u").Value, Df.Subfields.Subfield("3").Value, String.IsNullOrEmpty(Df.Subfields.Subfield("w").Value) == true ? sdefaultWidth : Df.Subfields.Subfield("w").Value, String.IsNullOrEmpty(Df.Subfields.Subfield("h").Value) == true ? sdefaultHeight: Df.Subfields.Subfield("h").Value, Df.Subfields.Subfield("a").Value); } } sSliderHTML += "<div class='caption'><div class='content'></div></div>"; sSliderHTML += "</div"; this.litContent.Text = sSliderHTML; } Page.RegisterStartupScript("slidershowscript", sliderShowScript); } }
protected void linkExportButton_Click(object sender, EventArgs e) { CRecords exRecs = new CRecords(); CRecord myRec = new CRecord(); CControlfield Cf = new CControlfield(); CDatafield Df = new CDatafield(); CSubfield Sf = new CSubfield(); DataTable tbData = new DataTable(); try { switch (radioFilterType.SelectedValue) { case "0": int iSectionID = 0; int iCategoryID = 0; if (dropSections.SelectedValue != null) { iSectionID = int.Parse(dropSections.SelectedValue.ToString()); } if (dropCategories.SelectedValue != null) { iCategoryID = int.Parse(dropCategories.SelectedValue.ToString()); } tbData = LegoWebAdmin.BusLogic.MetaContents.get_META_CONTENT_BY_CATEGORY_ID(iCategoryID, iSectionID).Tables[0]; for (int i = 0; i < tbData.Rows.Count; i++) { string sXmlContent = LegoWebAdmin.BusLogic.MetaContents.get_META_CONTENT_MARCXML(Int16.Parse(tbData.Rows[i]["META_CONTENT_ID"].ToString()), 1); myRec.load_Xml(sXmlContent); exRecs.Add(myRec); } break; case "1": int iFromID = String.IsNullOrEmpty(txtFromId.Text) ? 0 : int.Parse(txtFromId.Text); int iToID = String.IsNullOrEmpty(txtToId.Text) ? 0 : int.Parse(txtToId.Text); tbData = LegoWebAdmin.BusLogic.MetaContents.get_META_CONTENT_BY_ID(iFromID, iToID).Tables[0]; for (int i = 0; i < tbData.Rows.Count; i++) { string sXmlContent = LegoWebAdmin.BusLogic.MetaContents.get_META_CONTENT_MARCXML(Int16.Parse(tbData.Rows[i]["META_CONTENT_ID"].ToString()), 1); myRec.load_Xml(sXmlContent); exRecs.Add(myRec); } break; case "2": //create each system table one MarcRecord //leader 06 = s mean system table data record //001 value is TABLE NAME //LEGOWEB_COMMON_PARAMETERS myRec = new CRecord(); myRec.set_LeaderValueByPos("s", 6, 6); Cf = new CControlfield(); Cf.Tag = "001"; Cf.Value = "LEGOWEB_COMMON_PARAMETERS"; myRec.Controlfields.Add(Cf); Df = new CDatafield(); Df.Tag = "245"; Df.SubfieldsText = "$aLEGOWEB_COMMON_PARAMETERS TABLE DATA"; myRec.Datafields.Add(Df); tbData = LegoWebAdmin.BusLogic.CommonParameters.get_LEGOWEB_COMMON_PARAMETERS().Tables[0]; foreach (DataRow row in tbData.Rows) { //a PARAMETER_NAME nvarchar(50) Unchecked //b PARAMETER_TYPE smallint Checked //c PARAMETER_VI_VALUE nvarchar(255) Checked //d PARAMETER_EN_VALUE nvarchar(255) Checked //e PARAMETER_DESCRIPTION nvarchar(255) Checked Df = new CDatafield(); Df.Tag = "650"; Df.SubfieldsText = String.Format("$a{0}$b{1}$c{2}$d{3}$e{4}", row["PARAMETER_NAME"].ToString(), row["PARAMETER_TYPE"].ToString(), row["PARAMETER_VI_VALUE"].ToString(), row["PARAMETER_EN_VALUE"].ToString(), row["PARAMETER_DESCRIPTION"].ToString()); myRec.Datafields.Add(Df); } exRecs.Add(myRec); //LEGOWEB_SECTIONS myRec = new CRecord(); myRec.set_LeaderValueByPos("s", 6, 6); Cf = new CControlfield(); Cf.Tag = "001"; Cf.Value = "LEGOWEB_SECTIONS"; myRec.Controlfields.Add(Cf); Df = new CDatafield(); Df.Tag = "245"; Df.SubfieldsText = "$aLEGOWEB_SECTIONS TABLE DATA"; myRec.Datafields.Add(Df); tbData = LegoWebAdmin.BusLogic.Sections.get_LEGOWEB_SECTIONS().Tables[0]; foreach (DataRow row in tbData.Rows) { //a SECTION_ID int Unchecked //b SECTION_VI_TITLE nvarchar(250) Unchecked //c SECTION_EN_TITLE nvarchar(250) Checked Df = new CDatafield(); Df.Tag = "650"; Df.SubfieldsText = String.Format("$a{0}$b{1}$c{2}", row["SECTION_ID"].ToString(), row["SECTION_VI_TITLE"].ToString(), row["SECTION_EN_TITLE"].ToString()); myRec.Datafields.Add(Df); } exRecs.Add(myRec); //LEGOWEB_CATEGORIES myRec = new CRecord(); myRec.set_LeaderValueByPos("s", 6, 6); Cf = new CControlfield(); Cf.Tag = "001"; Cf.Value = "LEGOWEB_CATEGORIES"; myRec.Controlfields.Add(Cf); Df = new CDatafield(); Df.Tag = "245"; Df.SubfieldsText = "$aLEGOWEB_CATEGORIES TABLE DATA"; myRec.Datafields.Add(Df); tbData = LegoWebAdmin.BusLogic.Categories.get_LEGOWEB_CATEGORIES().Tables[0]; foreach (DataRow row in tbData.Rows) { //a CATEGORY_ID int Unchecked //b PARENT_CATEGORY_ID int Checked //c SECTION_ID int Unchecked //d CATEGORY_VI_TITLE nvarchar(250) Unchecked //e CATEGORY_EN_TITLE nvarchar(250) Checked //f CATEGORY_ALIAS nvarchar(250) Checked //g CATEGORY_TEMPLATE_NAME nvarchar(50) Checked //h CATEGORY_IMAGE_URL nvarchar(250) Checked //i MENU_ID int Unchecked //j IS_PUBLIC bit Checked //k ADMIN_LEVEL smallint Checked //l ADMIN_ROLES nvarchar(250) Checked //m SEO_TITLE nvarchar(100) Checked //n SEO_DESCRIPTION nvarchar(255) Checked //o SEO_KEYWORDS nvarchar(255) Checked //p ORDER_NUMBER smallint //q SORT_CONTENT_BY smallint -- since 10-03-2012 Df = new CDatafield(); Df.Tag = "650"; Df.SubfieldsText = String.Format("$a{0}$b{1}$c{2}$d{3}$e{4}$f{5}$g{6}$h{7}$i{8}$j{9}$k{10}$l{11}$m{12}$n{13}$o{14}$p{15}$q{16}", row["CATEGORY_ID"].ToString(), row["PARENT_CATEGORY_ID"].ToString(), row["SECTION_ID"].ToString(), row["CATEGORY_VI_TITLE"].ToString(), row["CATEGORY_EN_TITLE"].ToString(), row["CATEGORY_ALIAS"].ToString(), row["CATEGORY_TEMPLATE_NAME"].ToString(), row["CATEGORY_IMAGE_URL"].ToString(), row["MENU_ID"].ToString(), row["IS_PUBLIC"].ToString(), row["ADMIN_LEVEL"].ToString(), row["ADMIN_ROLES"].ToString(), row["SEO_TITLE"].ToString(), row["SEO_DESCRIPTION"].ToString(), row["SEO_KEYWORDS"].ToString(), row["ORDER_NUMBER"].ToString(), row["SORT_CONTENT_BY"].ToString()); myRec.Datafields.Add(Df); } exRecs.Add(myRec); //LEGOWEB_MENU_TYPES myRec = new CRecord(); myRec.set_LeaderValueByPos("s", 6, 6); Cf = new CControlfield(); Cf.Tag = "001"; Cf.Value = "LEGOWEB_MENU_TYPES"; myRec.Controlfields.Add(Cf); Df = new CDatafield(); Df.Tag = "245"; Df.SubfieldsText = "$aLEGOWEB_MENU_TYPES TABLE DATA"; myRec.Datafields.Add(Df); tbData = LegoWebAdmin.BusLogic.MenuTypes.get_LEGOWEB_MENU_TYPES().Tables[0]; foreach (DataRow row in tbData.Rows) { //a MENU_TYPE_ID smallint Unchecked //b MENU_TYPE_VI_TITLE nvarchar(50) Unchecked //c MENU_TYPE_EN_TITLE nvarchar(50) Unchecked //d MENU_TYPE_DESCRIPTION nvarchar(250) Checked Df = new CDatafield(); Df.Tag = "650"; Df.SubfieldsText = String.Format("$a{0}$b{1}$c{2}$d{3}", row["MENU_TYPE_ID"].ToString(), row["MENU_TYPE_VI_TITLE"].ToString(), row["MENU_TYPE_EN_TITLE"].ToString(), row["MENU_TYPE_DESCRIPTION"].ToString()); myRec.Datafields.Add(Df); } exRecs.Add(myRec); //LEGOWEB_MENUS myRec = new CRecord(); myRec.set_LeaderValueByPos("s", 6, 6); Cf = new CControlfield(); Cf.Tag = "001"; Cf.Value = "LEGOWEB_MENUS"; myRec.Controlfields.Add(Cf); Df = new CDatafield(); Df.Tag = "245"; Df.SubfieldsText = "$aLEGOWEB_MENUS TABLE DATA"; myRec.Datafields.Add(Df); tbData = LegoWebAdmin.BusLogic.Menus.get_LEGOWEB_MENUS().Tables[0]; foreach (DataRow row in tbData.Rows) { //a MENU_ID int Unchecked //b PARENT_MENU_ID int Unchecked //c MENU_TYPE_ID int Unchecked //d MENU_VI_TITLE nvarchar(50) Checked //e MENU_EN_TITLE nvarchar(50) Checked //f MENU_IMAGE_URL nvarchar(250) Checked //g MENU_LINK_URL nvarchar(50) Checked //h BROWSER_NAVIGATE tinyint Unchecked //i IS_PUBLIC bit Unchecked //j ORDER_NUMBER smallint Df = new CDatafield(); Df.Tag = "650"; Df.SubfieldsText = String.Format("$a{0}$b{1}$c{2}$d{3}$e{4}$f{5}$g{6}$h{7}$i{8}$j{9}", row["MENU_ID"].ToString(), row["PARENT_MENU_ID"].ToString(), row["MENU_TYPE_ID"].ToString(), row["MENU_VI_TITLE"].ToString(), row["MENU_EN_TITLE"].ToString(), row["MENU_IMAGE_URL"].ToString(), row["MENU_LINK_URL"].ToString(), row["BROWSER_NAVIGATE"].ToString(), row["IS_PUBLIC"].ToString(), row["ORDER_NUMBER"].ToString()); myRec.Datafields.Add(Df); } exRecs.Add(myRec); //#region KIPOS TABLES //myRec = new CRecord(); //myRec.set_LeaderValueByPos("s", 6, 6); //Cf = new CControlfield(); //Cf.Tag = "001"; //Cf.Value = "CAT_DMD_CATEGORY"; //myRec.Controlfields.Add(Cf); //Df = new CDatafield(); //Df.Tag = "245"; //Df.SubfieldsText = "$aCAT_DMD_CATEGORY"; //myRec.Datafields.Add(Df); //tbData = LegoWebAdmin.BusLogic.Menus.get_LEGOWEB_MENUS().Tables[0]; //foreach (DataRow row in tbData.Rows) //{ // //a MENU_ID int Unchecked // //b PARENT_MENU_ID int Unchecked // //c MENU_TYPE_ID int Unchecked // //d MENU_VI_TITLE nvarchar(50) Checked // //e MENU_EN_TITLE nvarchar(50) Checked // //f MENU_IMAGE_URL nvarchar(250) Checked // //g MENU_LINK_URL nvarchar(50) Checked // //h BROWSER_NAVIGATE tinyint Unchecked // //i IS_PUBLIC bit Unchecked // //j ORDER_NUMBER smallint // Df = new CDatafield(); // Df.Tag = "650"; // Df.SubfieldsText = String.Format("$a{0}$b{1}$c{2}$d{3}$e{4}$f{5}$g{6}$h{7}$i{8}$j{9}", row["MENU_ID"].ToString(), row["PARENT_MENU_ID"].ToString(), row["MENU_TYPE_ID"].ToString(), row["MENU_VI_TITLE"].ToString(), row["MENU_EN_TITLE"].ToString(), row["MENU_IMAGE_URL"].ToString(), row["MENU_LINK_URL"].ToString(), row["BROWSER_NAVIGATE"].ToString(), row["IS_PUBLIC"].ToString(), row["ORDER_NUMBER"].ToString()); // myRec.Datafields.Add(Df); //} //exRecs.Add(myRec); //#endregion KIPOS TABLES break; } if (exRecs.Count <= 0) { throw new Exception("No data to export!"); } Response.ContentType = "APPLICATION/OCTET-STREAM"; //set the filename Response.AddHeader("Content-Disposition", "attachment;filename=\"legowebdata.xml\""); String outStream = exRecs.OuterXml; Response.Write(outStream); Response.End(); } catch (Exception ex) { String errorFomat = @"<dl id='system-message'> <dd class='error message fade'> <ul> <li>{0}</li> </ul> </dd> </dl>"; litErrorSpaceHolder.Text = String.Format(errorFomat, ex.Message); } }
protected void cmdAddTagOrSubfield_Click(object sender, EventArgs e) { save_MetaContentData();//save data first _MetaContent = new ContentEditorDataHelper(); _MetaContent.load_Xml(Session["METADATA"].ToString()); CRecord labelRec = new CRecord(); labelRec.load_File(FileTemplateDataProvider.get_LabelTemplateFile(LegoWebAdmin.BusLogic.Categories.get_CATEGORY_TEMPLATE_NAME(int.Parse(dropCategories.SelectedValue.ToString())))); CDatafield Df = labelRec.Datafields.Datafield(listAddTag.SelectedValue.ToString()); DataTable marcTable = _MetaContent.get_MarcDatafieldTable(); int iTagIndex = 0; if (marcTable.Rows.Count > 0) { DataRow[] maxRows = marcTable.Select("TAG_INDEX=Max(TAG_INDEX)"); iTagIndex = int.Parse("0" + maxRows[0]["TAG_INDEX"].ToString()); } if (listAddSubfieldCode.SelectedValue == "")//add new tag { for (int i = 0; i < Df.Subfields.Count; i++) { DataRow nRow = marcTable.NewRow(); nRow["TAG"] = Df.Tag; nRow["TAG_INDEX"] = iTagIndex + 1; nRow["SUBFIELD_CODE"] = Df.Subfields.Subfield(i).Code; nRow["SUBFIELD_TYPE"] = Df.Subfields.Subfield(i).Type; nRow["SUBFIELD_LABEL"] = Df.Subfields.Subfield(i).Value; nRow["SUBFIELD_VALUE"] = txtAddValue.Text; marcTable.Rows.Add(nRow); } marcTable.DefaultView.Sort = "TAG, TAG_INDEX ASC"; _MetaContent.set_DataTableLabel(ref marcTable, labelRec); repeater_DataBind(marcTable); _MetaContent.bind_TableDataToMarc(ref marcTable); Session["METADATA"] = _MetaContent.OuterXml; return; } else//add subfield to existing tag or new tag only one subfield { CSubfield Sf = Df.Subfields.Subfield(listAddSubfieldCode.SelectedValue.ToString()); #region add to subfield to selected tag if have one for (int i = 0; i < this.marcTextRepeater.Items.Count; i++) { CheckBox cb = ((CheckBox)marcTextRepeater.Items[i].FindControl("RowLevelCheckBox")); if (cb.Checked) { Label labelTag = (Label)marcTextRepeater.Items[i].FindControl("labelTag"); if (labelTag.Text == listAddTag.SelectedValue.ToString()) { DataRow nRow = marcTable.NewRow(); nRow["TAG"] = labelTag.Text; Label labelTagIndex = (Label)marcTextRepeater.Items[i].FindControl("labelTagIndex"); nRow["TAG_INDEX"] = int.Parse(labelTagIndex.Text); nRow["SUBFIELD_CODE"] = Sf.Code; nRow["SUBFIELD_TYPE"] = Sf.Type; nRow["SUBFIELD_LABEL"] = Sf.Value; nRow["SUBFIELD_VALUE"] = txtAddValue.Text; marcTable.Rows.Add(nRow); //sort go here marcTable.DefaultView.Sort = "TAG, TAG_INDEX ASC"; _MetaContent.set_DataTableLabel(ref marcTable, labelRec); repeater_DataBind(marcTable); _MetaContent.bind_TableDataToMarc(ref marcTable); Session["METADATA"] = _MetaContent.OuterXml; return; } } } #endregion //if don't have match selected tag find existing tag for (int i = 0; i < marcTable.Rows.Count; i++) { if (marcTable.Rows[i]["TAG"].ToString() == listAddTag.SelectedValue.ToString()) { DataRow nRow = marcTable.NewRow(); nRow["TAG"] = marcTable.Rows[i]["TAG"]; nRow["TAG_INDEX"] = marcTable.Rows[i]["TAG_INDEX"]; nRow["SUBFIELD_CODE"] = Sf.Code; nRow["SUBFIELD_TYPE"] = Sf.Type; nRow["SUBFIELD_LABEL"] = Sf.Value; nRow["SUBFIELD_VALUE"] = txtAddValue.Text; marcTable.Rows.Add(nRow); //sort go here marcTable.DefaultView.Sort = "TAG, TAG_INDEX ASC"; _MetaContent.set_DataTableLabel(ref marcTable, labelRec); repeater_DataBind(marcTable); _MetaContent.bind_TableDataToMarc(ref marcTable); Session["METADATA"] = _MetaContent.OuterXml; return; } } //don't have existing match tag create new tag with one subfield DataRow addRow = marcTable.NewRow(); addRow["TAG"] = Df.Tag; addRow["TAG_INDEX"] = iTagIndex + 1; addRow["SUBFIELD_CODE"] = Sf.Code; addRow["SUBFIELD_TYPE"] = Sf.Type; addRow["SUBFIELD_LABEL"] = Sf.Value; addRow["SUBFIELD_VALUE"] = txtAddValue.Text; marcTable.Rows.Add(addRow); //sort go here marcTable.DefaultView.Sort = "TAG, TAG_INDEX ASC"; _MetaContent.set_DataTableLabel(ref marcTable, labelRec); repeater_DataBind(marcTable); _MetaContent.bind_TableDataToMarc(ref marcTable); Session["METADATA"] = _MetaContent.OuterXml; return; } }
protected void import_SystemTableData(CRecord tblRec) { CDatafields Dfs; CDatafield Df = new CDatafield(); switch (tblRec.Controlfields.Controlfield("001").Value) { case "LEGOWEB_COMMON_PARAMETERS": //Df.SubfieldsText = String.Format("$a{0} $b{1} $c{2} $d{3} $e{4}", row["PARAMETER_NAME"].ToString(), row["PARAMETER_TYPE"].ToString(), row["PARAMETER_VI_VALUE"].ToString(), row["PARAMETER_EN_VALUE"].ToString(), row["PARAMETER_DESCRIPTION"].ToString()); Dfs = tblRec.Datafields; Dfs.Filter("650"); for (int i = 0; i < Dfs.Count; i++) { Df = Dfs.Datafield(i); LegoWebAdmin.BusLogic.CommonParameters.addudp_LEGOWEB_COMMON_PARAMETER(Df.Subfields.Subfield("a").Value, int.Parse(Df.Subfields.Subfield("b").Value), Df.Subfields.Subfield("c").Value, Df.Subfields.Subfield("d").Value, Df.Subfields.Subfield("e").Value); } break; case "LEGOWEB_SECTIONS": //Df.SubfieldsText = String.Format("$a{0} $b{1} $c{2}", row["SECTION_ID"].ToString(), row["SECTION_VI_TITLE"].ToString(), row["SECTION_EN_TITLE"].ToString()); Dfs = tblRec.Datafields; Dfs.Filter("650"); for (int i = 0; i < Dfs.Count; i++) { Df = Dfs.Datafield(i); LegoWebAdmin.BusLogic.Sections.add_Update(int.Parse(Df.Subfields.Subfield("a").Value), Df.Subfields.Subfield("b").Value, Df.Subfields.Subfield("c").Value); } break; case "LEGOWEB_CATEGORIES": //Df.SubfieldsText = String.Format("$a{0} $b{1} $c{2} $d{3} $e{4} $f{5} $g{6} $h{7} $i{8} $j{9} $k{10} $l{11} $m{12} $n{13} $o{14} $p{15}", row["CATEGORY_ID"].ToString(), row["PARENT_CATEGORY_ID"].ToString(), row["SECTION_ID"].ToString(), row["CATEGORY_VI_TITLE"].ToString(), row["CATEGORY_EN_TITLE"].ToString(), row["CATEGORY_ALIAS"].ToString(), row["CATEGORY_TEMPLATE_NAME"].ToString(), row["CATEGORY_IMAGE_URL"].ToString(), row["MENU_ID"].ToString(), row["IS_PUBLIC"].ToString(), row["ADMIN_LEVEL"].ToString(), row["ADMIN_ROLES"].ToString(), row["SEO_TITLE"].ToString(), row["SEO_DESCRIPTION"].ToString(), row["SEO_KEYWORDS"].ToString(),row["ORDER_NUMBER"].ToString()); Dfs = tblRec.Datafields; Dfs.Filter("650"); for (int i = 0; i < Dfs.Count; i++) { Df = Dfs.Datafield(i); LegoWebAdmin.BusLogic.Categories.addUpdate_CATEGORY(int.Parse(Df.Subfields.Subfield("a").Value), int.Parse(Df.Subfields.Subfield("b").Value), int.Parse(Df.Subfields.Subfield("c").Value), Df.Subfields.Subfield("d").Value, Df.Subfields.Subfield("e").Value, Df.Subfields.Subfield("f").Value, Df.Subfields.Subfield("g").Value, Df.Subfields.Subfield("h").Value, int.Parse(Df.Subfields.Subfield("i").Value), int.Parse("0" + Df.Subfields.Subfield("q").Value), Convert.ToBoolean(Df.Subfields.Subfield("j").Value), int.Parse(Df.Subfields.Subfield("k").Value), Df.Subfields.Subfield("l").Value, Df.Subfields.Subfield("m").Value, Df.Subfields.Subfield("n").Value, Df.Subfields.Subfield("o").Value); if (!String.IsNullOrEmpty(Df.Subfields.Subfield("p").Value)) { LegoWebAdmin.BusLogic.Categories.update_CATEGORY_ORDER(int.Parse(Df.Subfields.Subfield("a").Value), int.Parse(Df.Subfields.Subfield("p").Value)); } } break; case "LEGOWEB_MENU_TYPES": //Df.SubfieldsText = String.Format("$a{0} $b{1} $c{2} $d{3}", row["MENU_TYPE_ID"].ToString(), row["MENU_TYPE_VI_TITLE"].ToString(), row["MENU_TYPE_EN_TITLE"].ToString(), row["MENU_TYPE_DESCRIPTION"].ToString()); Dfs = tblRec.Datafields; Dfs.Filter("650"); for (int i = 0; i < Dfs.Count; i++) { Df = Dfs.Datafield(i); LegoWebAdmin.BusLogic.MenuTypes.addUpdate_MenuType(int.Parse(Df.Subfields.Subfield("a").Value), Df.Subfields.Subfield("b").Value, Df.Subfields.Subfield("c").Value, Df.Subfields.Subfield("d").Value); } break; case "LEGOWEB_MENUS": //Df.SubfieldsText = String.Format("$a{0} $b{1} $c{2} $d{3} $e{4} $f{5} $g{6} $h{7} $i{8} $j{9}", row["MENU_ID"].ToString(), row["PARENT_MENU_ID"].ToString(), row["MENU_TYPE_ID"].ToString(), row["MENU_VI_TITLE"].ToString(), row["MENU_EN_TITLE"].ToString(), row["MENU_IMAGE_URL"].ToString(), row["MENU_LINK_URL"].ToString(), row["BROWSER_NAVIGATE"].ToString(), row["IS_PUBLIC"].ToString(),row["ORDER_NUMBER"].ToString()); Dfs = tblRec.Datafields; Dfs.Filter("650"); for (int i = 0; i < Dfs.Count; i++) { Df = Dfs.Datafield(i); LegoWebAdmin.BusLogic.Menus.addUpdate_MENU(int.Parse(Df.Subfields.Subfield("a").Value), int.Parse(Df.Subfields.Subfield("b").Value), int.Parse(Df.Subfields.Subfield("c").Value), Df.Subfields.Subfield("d").Value, Df.Subfields.Subfield("e").Value, Df.Subfields.Subfield("f").Value, Df.Subfields.Subfield("g").Value, int.Parse(Df.Subfields.Subfield("h").Value), Convert.ToBoolean(Df.Subfields.Subfield("i").Value)); if (!String.IsNullOrEmpty(Df.Subfields.Subfield("j").Value)) { LegoWebAdmin.BusLogic.Menus.update_MENU_ORDER(int.Parse(Df.Subfields.Subfield("a").Value), int.Parse(Df.Subfields.Subfield("j").Value)); } } break; } }
public static DataTable get_PollData(int iPollContentId, out string sQuestion, out int iTotalVoteCount) { iTotalVoteCount = 0; sQuestion = null; DataTable pollData = new DataTable(); DataColumn IDcol = new DataColumn("ID"); IDcol.DataType = System.Type.GetType("System.Int32"); pollData.Columns.Add(IDcol); DataColumn voteCountCol = new DataColumn("VoteCount"); voteCountCol.DataType = System.Type.GetType("System.Int32"); pollData.Columns.Add(voteCountCol); DataColumn ChoiceCol = new DataColumn("Choice"); ChoiceCol.DataType = System.Type.GetType("System.String"); pollData.Columns.Add(ChoiceCol); DataColumn orderCol = new DataColumn("OrderNumber"); orderCol.DataType = System.Type.GetType("System.Int32"); pollData.Columns.Add(orderCol); CRecord pollRecord = new CRecord(); CDatafield Df = new CDatafield(); CSubfield Sf = new CSubfield(); pollRecord.load_Xml(LegoWebSite.Buslgic.MetaContents.get_META_CONTENT_MARCXML(iPollContentId, 0)); pollRecord.Sort(); //get Question First sQuestion = pollRecord.Datafields.Datafield("245").Subfields.Subfield("a").Value; CDatafields ChoiceDfs = pollRecord.Datafields; ChoiceDfs.Filter("650"); for (int i = 0; i < ChoiceDfs.Count; i++) { string sChoice = ""; int iID = 0; int iVoteCount = 0; int iOrderNumber = 0; Df = ChoiceDfs.Datafield(i); if (Df.Subfields.get_Subfield("0", ref Sf)) { iOrderNumber = String.IsNullOrEmpty(Sf.Value)?0:int.Parse(Sf.Value); } if (Df.Subfields.get_Subfield("a", ref Sf)) { sChoice = Sf.Value; iID = int.Parse(Sf.ID); } else { sChoice = "No choice info"; } if (Df.Subfields.get_Subfield("n", ref Sf)) { iTotalVoteCount += int.Parse(Sf.Value); iVoteCount = int.Parse(Sf.Value); } DataRow row = pollData.NewRow(); row["ID"] = iID; row["Choice"] = sChoice; row["VoteCount"] = iVoteCount; row["OrderNumber"] = iOrderNumber; pollData.Rows.Add(row); } pollData.DefaultView.Sort = " OrderNumber ASC"; return(pollData); }