private string getTextVal() { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; // hard coded val.Where.ItemFieldId.Value = 7; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); tblItemFieldStringValues txt = new tblItemFieldStringValues(); if (val.ItemFieldStringTempId > -1) { txt.LoadByPrimaryKey(val.ItemFieldStringTempId); } else { txt.LoadByPrimaryKey(val.ItemFieldStringId); } return(txt.ItemFieldValue); }
public void SaveValue() { if (FileUpload1.PostedFile.ContentLength > 0) { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; // hard coded val.Where.ItemFieldId.Value = 3; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); // tblItemFieldBlobValues imgAsset = new tblItemFieldBlobValues(); //imgAsset.AddNew(); tblPdfAssets imgAsset = new tblPdfAssets(); imgAsset.AddNew(); int sizeFile = FileUpload1.PostedFile.ContentLength; imgAsset.PdfData = getImageBits(FileUpload1.PostedFile.InputStream, sizeFile); // imgAsset.ImageTitle = FileUpload1.PostedFile.FileName.Substring(FileUpload1.PostedFile.FileName.LastIndexOf("\\") + 1); imgAsset.PdfTitle = TextBox1.Text; imgAsset.Save(); } }
private string getPdfURL() { if (_itemId > 0) { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.LanguageId.Value = Int32.Parse(Request["langId"]); // 4 is PDF location val.Where.ItemFieldId.Value = 4; val.Where.ItemId.Value = _itemId; val.Query.Load(); if (val.RowCount > 0) { val.Rewind(); return("~/renderpdf.aspx?itemId=" + _itemId.ToString() + "&hei=100"); } else { return(""); } } else { return("~/renderpdf.aspx?pdfid=" + _pdfId.ToString()); } }
private string getPdfURL() { if (_itemId > 0) { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.LanguageId.Value = Int32.Parse(Request["langId"]); // 4 is PDF location val.Where.ItemFieldId.Value = 4; val.Where.ItemId.Value = _itemId; val.Query.Load(); if (val.RowCount > 0) { val.Rewind(); return "~/renderpdf.aspx?itemId=" + _itemId.ToString() + "&hei=100"; } else { return ""; } } else { return "~/renderpdf.aspx?pdfid=" + _pdfId.ToString(); } }
public void SaveValue() { if (DropDownList1.SelectedIndex > 0) { tblItems itm = new tblItems(); itm.LoadByPrimaryKey(_itemId); tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; val.Where.ItemFieldId.Value = 5; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); if (val.RowCount == 0) { val.AddNew(); val.ItemId = _itemId; val.ItemId = 5; val.LanguageId = int.Parse(Request["langId"]); } if (val.ItemFieldPdfAssetId != Int32.Parse(DropDownList1.SelectedValue)) { val.ItemFieldPdfAssetTempId = Int32.Parse(DropDownList1.SelectedValue); } val.Save(); } }
private string getTextVal() { if (_itemId > 0) { tblItemFieldsXValue val = new tblItemFieldsXValue(); //val.Where.ItemId.Value = _itemId; val.Where.ItemId.Value = _itemId; // hard coded val.Where.ItemFieldId.Value = 3; val.Where.LanguageId.Value = (int)ViewState["_langId"]; val.Query.Load(); tblItemFieldStringValues txt = new tblItemFieldStringValues(); if (val.ItemFieldStringTempId > -1) { txt.LoadByPrimaryKey(val.ItemFieldStringTempId); } else { txt.LoadByPrimaryKey(val.ItemFieldStringId); } return(txt.ItemFieldValue); } else { return(_selCatImage + "/" + _selImg); } }
protected void LinkButton1_Click(object sender, EventArgs e) { #region remove value stores tblItemFieldsXValue vals = new tblItemFieldsXValue(); vals.Where.ItemId.Value = _itemId; vals.Query.Load(); if (vals.RowCount > 0) { vals.Rewind(); do { if (vals.s_ItemFieldStringId != "") { tblItemFieldStringValues val = new tblItemFieldStringValues(); val.LoadByPrimaryKey(vals.ItemFieldStringId); val.MarkAsDeleted(); val.Save(); } if (vals.s_ItemFieldTextId != "") { tblItemFieldTextValues val = new tblItemFieldTextValues(); val.LoadByPrimaryKey(vals.ItemFieldTextId); val.MarkAsDeleted(); val.Save(); } if (vals.s_ItemFieldStringId != "") { tblItemFieldStringValues val = new tblItemFieldStringValues(); val.LoadByPrimaryKey(vals.ItemFieldStringId); val.MarkAsDeleted(); val.Save(); } if (vals.s_ItemFieldPdfAssetId != "") { tblPdfAssets val = new tblPdfAssets(); val.LoadByPrimaryKey(vals.ItemFieldPdfAssetId); val.MarkAsDeleted(); val.Save(); } } while (vals.MoveNext()); } #endregion tblItems item = new tblItems(); item.LoadByPrimaryKey(_itemId); item.MarkAsDeleted(); item.Save(); Response.Redirect(Request.RawUrl); }
public void RejectChange() { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; // hard coded val.Where.ItemFieldId.Value = 5; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); val.s_ItemFieldPdfAssetTempId = ""; val.Save(); }
private string getTextVal() { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; // hard coded val.Where.ItemFieldId.Value = 6; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); tblItemFieldStringValues txt = new tblItemFieldStringValues(); txt.LoadByPrimaryKey(val.ItemFieldStringId); return txt.ItemFieldValue; }
public void ApproveChange() { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; // hard coded val.Where.ItemFieldId.Value = 2; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); // load the temp tblItemFieldTextValues txt = new tblItemFieldTextValues(); txt.LoadByPrimaryKey(val.ItemFieldTextTempId); // load the live tblItemFieldTextValues txt2 = new tblItemFieldTextValues(); try { txt2.LoadByPrimaryKey(val.ItemFieldTextId); } catch { // for some reason, wasn't created for this language txt2.AddNew(); } // make them equal txt2.ItemFieldValue = txt.ItemFieldValue; // save txt2.Save(); val.ItemFieldTextId = txt2.ItemFieldStringValueId; // delete the old reference val.s_ItemFieldTextTempId = ""; val.Save(); // delete the old txt.MarkAsDeleted(); txt.Save(); }
public void ApproveChange() { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; // hard coded val.Where.ItemFieldId.Value = 7; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); // load the temp tblItemFieldStringValues txt = new tblItemFieldStringValues(); txt.LoadByPrimaryKey(val.ItemFieldStringTempId); // load the live tblItemFieldStringValues txt2 = new tblItemFieldStringValues(); if (val.ItemFieldStringId > -1) { txt2.LoadByPrimaryKey(val.ItemFieldStringId); } else { txt2.AddNew(); } // make them equal txt2.ItemFieldValue = txt.ItemFieldValue; // save txt2.Save(); val.ItemFieldStringId = txt2.ItemFieldStringValueId; // delete the old reference val.ItemFieldStringTempId = -1; val.Save(); // delete the old txt.MarkAsDeleted(); txt.Save(); }
public void SaveValue() { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; // hard coded val.Where.ItemFieldId.Value =6; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); tblItemFieldStringValues txt = new tblItemFieldStringValues(); txt.LoadByPrimaryKey(val.ItemFieldStringId); txt.ItemFieldValue =TextBox1.Text; txt.Save(); }
public void ApproveChange() { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; // hard coded val.Where.ItemFieldId.Value = 3; val.Where.LanguageId.Value = (int)ViewState["_langId"]; val.Query.Load(); // load the temp tblItemFieldStringValues txt = new tblItemFieldStringValues(); txt.LoadByPrimaryKey(val.ItemFieldStringTempId); // load the live tblItemFieldStringValues txt2 = new tblItemFieldStringValues(); if (val.ItemFieldStringId > -1) { txt2.LoadByPrimaryKey(val.ItemFieldStringId); } else { txt2.AddNew(); } // make them equal txt2.ItemFieldValue = txt.ItemFieldValue; // save txt2.Save(); val.ItemFieldStringId = txt2.ItemFieldStringValueId; // delete the old reference val.ItemFieldStringTempId = -1; val.Save(); // delete the old txt.MarkAsDeleted(); txt.Save(); }
public void SaveValue() { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; // hard coded val.Where.ItemFieldId.Value = 6; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); tblItemFieldStringValues txt = new tblItemFieldStringValues(); txt.LoadByPrimaryKey(val.ItemFieldStringId); txt.ItemFieldValue = TextBox1.Text; txt.Save(); }
public void RejectChange() { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; // hard coded val.Where.ItemFieldId.Value = 7; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); // load the temp tblItemFieldStringValues txt = new tblItemFieldStringValues(); txt.LoadByPrimaryKey(val.ItemFieldStringTempId); val.s_ItemFieldStringTempId = ""; txt.MarkAsDeleted(); txt.Save(); val.Save(); }
public void RejectChange() { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; // hard coded val.Where.ItemFieldId.Value = 3; val.Where.LanguageId.Value = (int)ViewState["_langId"]; val.Query.Load(); // load the temp tblItemFieldStringValues txt = new tblItemFieldStringValues(); txt.LoadByPrimaryKey(val.ItemFieldStringTempId); val.ItemFieldStringTempId = -1; txt.MarkAsDeleted(); txt.Save(); val.Save(); }
private void getTemp() { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; // hard coded val.Where.ItemFieldId.Value = 7; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); try { int ret = val.ItemFieldStringTempId; _temp = true; } catch { _temp = false; } }
public void LoadItem(int itemId) { _itemId = itemId; tblItems item = new tblItems(); item.LoadByPrimaryKey(itemId); tblItemTypes type = new tblItemTypes(); type.LoadByPrimaryKey(item.ItemTypeId); lbItemName.Text = item.ItemTitle; if ((int)UserContext.GetContextItemAsInt("userlevel") == 1) { lbItemName.Text += "[" + item.ItemId.ToString() + "]"; } _itemTypeTitle = type.ItemTypeTitle; switch (_itemTypeTitle) { case "epicCMSRichTextControl": // cmsTextEditControl edit = new adm admin_controls_cmsTextEditControl txt = (admin_controls_cmsTextEditControl)Page.LoadControl("~/admin/controls/cmsTextEditControl.ascx"); txt.ItemId = itemId; PlaceHolder1.Controls.Add(txt); lbApprove.Visible = false; lbReject.Visible = false; if (txt.IsTemp()) { if ((int)UserContext.GetContextItemAsInt("userlevel") > 2) { Label1.Visible = false; } else { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; val.Where.ItemFieldId.Value = 7; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); //if (val.ItemFieldStringTempId > -1) //{ // lbApprove.Visible = true; // lbReject.Visible = true; //} } } break; case "epicCMSTextControl": admin_controls_cmsBasicTextEditControl txt4 = (admin_controls_cmsBasicTextEditControl)Page.LoadControl("~/admin/controls/cmsBasicTextEditControl.ascx"); txt4.ItemId = itemId; PlaceHolder1.Controls.Add(txt4); lbApprove.Visible = false; lbReject.Visible = false; if (txt4.IsTemp()) { if ((int)UserContext.GetContextItemAsInt("userlevel") > 2) { Label1.Visible = false; } else { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; val.Where.ItemFieldId.Value = 7; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); //if (val.ItemFieldStringTempId > -1) //{ // lbApprove.Visible = true; // lbReject.Visible = true; //} } } break; case "epicCMSImageControl": //admin_controls_cmsImageEditControl img = (admin_controls_cmsImageEditControl)Page.LoadControl("~/admin/controls/cmsImageEditControl.ascx"); admin_controls_cmsSelectImage img = (admin_controls_cmsSelectImage)Page.LoadControl("~/admin/controls/cmsSelectImage.ascx"); img.ItemId = itemId; PlaceHolder1.Controls.Add(img); lbApprove.Visible = false; lbReject.Visible = false; if (img.IsTemp()) { if ((int)UserContext.GetContextItemAsInt("userlevel") > 2) { Label1.Visible = false; } else { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; val.Where.ItemFieldId.Value = 3; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); //if (val.ItemFieldStringTempId > -1) //{ //lbApprove.Visible = true; // lbReject.Visible = true; //} } } break; case "epicCMSPDFControl": admin_controls_cmsPDFEditControl img2 = (admin_controls_cmsPDFEditControl)Page.LoadControl("~/admin/controls/cmsPDFEditControl.ascx"); admin_controls_cmsSelectPdf pdf = (admin_controls_cmsSelectPdf)Page.LoadControl("~/admin/controls/cmsSelectPDF.ascx"); img2.ItemId = itemId; pdf.ItemId = itemId; PlaceHolder1.Controls.Add(pdf); lbApprove.Visible = false; lbReject.Visible = false; if (pdf.IsTemp()) { if ((int)UserContext.GetContextItemAsInt("userlevel") > 2) { Label1.Visible = false; } //else //{ // lbApprove.Visible = true; // lbReject.Visible = true; //} } break; case "epicCMSImageTextControl": admin_controls_cmsTextImageEditControl te = (admin_controls_cmsTextImageEditControl)Page.LoadControl("~/admin/controls/cmsTextImageEditControl.ascx"); te.ItemId = itemId; PlaceHolder1.Controls.Add(te); break; } if (ConfigurationManager.AppSettings["usesApprovals"] != "true") { lbApprove.Visible = false; lbReject.Visible = false; } }
private void loadPdfs() { tblPdfAssets assets = new tblPdfAssets(); assets.LoadAll(); int sel = -1; if (_itemId > -1) { tblItems itm = new tblItems(); itm.LoadByPrimaryKey(_itemId); tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; val.Where.ItemFieldId.Value = 5; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); if (val.RowCount > 0) { val.Rewind(); if (_temp) { sel = val.ItemFieldPdfAssetTempId; } else { sel = val.ItemFieldPdfAssetId; } HyperLink2.Text = "View PDF"; HyperLink2.Target = "_blank"; HyperLink2.NavigateUrl = "~/renderpdf.aspx?itemid=" + _itemId.ToString() + "&langid=" + Request["langid"]; } else { val.AddNew(); val.ItemId = _itemId; val.ItemFieldId = 5; val.LanguageId = int.Parse(Request["langId"]); val.ItemFieldPdfAssetId = -1; val.Save(); } } else { if (_pdfid > -1) { HyperLink2.NavigateUrl = "~/renderpdf.aspx?pdfid=" + _pdfid.ToString(); HyperLink2.Text = "View PDF"; HyperLink2.Target = "_blank"; sel = _pdfid; } else { HyperLink2.Visible = false; LinkButton1.Visible = false; } } ListItem li2 = new ListItem("--Select--"); DropDownList1.Items.Add(li2); if (assets.RowCount > 0) { assets.Rewind(); do { ListItem li = new ListItem(assets.PdfTitle, assets.PdfAssetId.ToString()); if (sel == assets.PdfAssetId) { li.Selected = true; } DropDownList1.Items.Add(li); } while (assets.MoveNext()); } if (DropDownList1.SelectedIndex == 0) { HyperLink2.Visible = false; LinkButton1.Visible = false; } }
public void SaveValue() { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; // hard coded val.Where.ItemFieldId.Value = 3; val.Where.LanguageId.Value = (int)ViewState["_langId"]; val.Query.Load(); if (val.RowCount == 0) { val.AddNew(); val.ItemFieldId = 3; val.LanguageId = (int)ViewState["_langId"]; val.ItemId = _itemId; } tblItemFieldStringValues txt = new tblItemFieldStringValues(); try { if (val.ItemFieldStringTempId > -1) { txt.LoadByPrimaryKey(val.ItemFieldStringTempId); } else { txt.AddNew(); } } catch { txt.AddNew(); } // check if we need an update tblItemFieldStringValues valtxt = new tblItemFieldStringValues(); bool update = true; string imgroot = ddCat.SelectedItem.Value + "/" + ddFiles.SelectedItem.Value; try { valtxt.LoadByPrimaryKey(val.ItemFieldStringId); if (valtxt.ItemFieldValue == imgroot) { update = false; } } catch { } if (update) { txt.ItemFieldValue = imgroot; txt.Save(); val.ItemFieldStringTempId = txt.ItemFieldStringValueId; val.Save(); } }
protected void Button1_Click(object sender, EventArgs e) { tblItems item = new tblItems(); item.AddNew(); item.ItemTitle = TextBox1.Text; item.ItemTypeId = int.Parse(DropDownList1.SelectedValue); item.Save(); tblItemFieldsXValue fxv = new tblItemFieldsXValue(); // now, create the field values switch (DropDownList1.SelectedValue) { case "1": tblItemFieldStringValues txt21 = new tblItemFieldStringValues(); txt21.AddNew(); txt21.ItemFieldValue = " "; txt21.Save(); fxv.AddNew(); fxv.ItemId = item.ItemId; fxv.LanguageId = int.Parse(Request["langId"]); fxv.ItemFieldId = 7; // text fxv.ItemFieldStringId = -1; if (ConfigurationManager.AppSettings["usesApprovals"] == "true") { fxv.ItemFieldStringTempId = txt21.ItemFieldStringValueId; } else { fxv.ItemFieldStringId = txt21.ItemFieldStringValueId; } fxv.Save(); break; case "2": // image //tblImageAssets blob = new tblImageAssets(); //blob.AddNew(); //blob.Save(); tblItemFieldStringValues img = new tblItemFieldStringValues(); img.AddNew(); img.ItemFieldValue = " "; img.Save(); fxv.AddNew(); fxv.ItemId = item.ItemId; fxv.LanguageId = int.Parse(Request["langId"]); fxv.ItemFieldId = 3; // image fxv.ItemFieldStringId = -1; if (ConfigurationManager.AppSettings["usesApprovals"] == "true") { fxv.ItemFieldStringTempId = img.ItemFieldStringValueId; } else { fxv.ItemFieldStringId = img.ItemFieldStringValueId; } fxv.Save(); break; case "3": // rich text tblItemFieldTextValues txt = new tblItemFieldTextValues(); txt.AddNew(); txt.Save(); fxv.AddNew(); fxv.ItemId = item.ItemId; fxv.LanguageId = int.Parse(Request["langId"]); fxv.ItemFieldId = 2; // image if (ConfigurationManager.AppSettings["usesApprovals"] == "true") { fxv.ItemFieldTextTempId = txt.ItemFieldStringValueId; } else { fxv.ItemFieldTextId = txt.ItemFieldStringValueId; } fxv.Save(); break; case "4": // pdf fxv.AddNew(); fxv.ItemId = item.ItemId; fxv.LanguageId = int.Parse(Request["langId"]); fxv.ItemFieldId = 5; // pdf fxv.ItemFieldPdfAssetId = -1; fxv.Save(); break; case "5": // rich text tblItemFieldStringValues txt2 = new tblItemFieldStringValues(); txt2.AddNew(); txt2.ItemFieldValue = " "; txt2.Save(); fxv.AddNew(); fxv.ItemId = item.ItemId; fxv.LanguageId = int.Parse(Request["langId"]); fxv.ItemFieldId = 6; // image if (ConfigurationManager.AppSettings["usesApprovals"] == "true") { fxv.ItemFieldStringTempId = txt2.ItemFieldStringValueId; } else { fxv.ItemFieldStringId = txt2.ItemFieldStringValueId; } fxv.Save(); break; } tblControlsXItems cxi = new tblControlsXItems(); cxi.AddNew(); cxi.ControlId = int.Parse(Request["ctl"]); cxi.LanguageId = int.Parse(Request["langId"]); cxi.ItemId = item.ItemId; cxi.Save(); lbJs.Text = epicCMSLib.Navigation.CloseWindowString; }
public void SaveValue() { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; // hard coded val.Where.ItemFieldId.Value = 7; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); if (val.RowCount == 0) { val.AddNew(); val.ItemFieldId = 7; val.LanguageId = int.Parse(Request["langId"]); ; val.ItemId = _itemId; } tblItemFieldStringValues txt = new tblItemFieldStringValues(); try { if (val.ItemFieldStringTempId > -1) { txt.LoadByPrimaryKey(val.ItemFieldStringTempId); } else { txt.AddNew(); } } catch { txt.AddNew(); } // check if we need an update tblItemFieldStringValues valtxt = new tblItemFieldStringValues(); bool update = true; try { valtxt.LoadByPrimaryKey(val.ItemFieldStringId); if (valtxt.ItemFieldValue == TextBox1.Text) { update = false; } } catch { } if (update) { txt.ItemFieldValue = TextBox1.Text; txt.Save(); val.ItemFieldStringTempId = txt.ItemFieldStringValueId; val.Save(); } }
public void SaveValue() { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; // hard coded val.Where.ItemFieldId.Value = 7; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); if (val.RowCount == 0) { val.AddNew(); val.ItemFieldId = 7; val.LanguageId = int.Parse(Request["langId"]);; val.ItemId = _itemId; } tblItemFieldStringValues txt = new tblItemFieldStringValues(); try { if (val.ItemFieldStringTempId > -1) { txt.LoadByPrimaryKey(val.ItemFieldStringTempId); } else { txt.AddNew(); } } catch { txt.AddNew(); } // check if we need an update tblItemFieldStringValues valtxt = new tblItemFieldStringValues(); bool update = true; try { valtxt.LoadByPrimaryKey(val.ItemFieldStringId); if (valtxt.ItemFieldValue == TextBox1.Text) { update = false; } } catch { } if (update) { txt.ItemFieldValue = TextBox1.Text; txt.Save(); val.ItemFieldStringTempId = txt.ItemFieldStringValueId; val.Save(); } }
private string getTextVal() { if (_itemId > 0) { tblItemFieldsXValue val = new tblItemFieldsXValue(); //val.Where.ItemId.Value = _itemId; val.Where.ItemId.Value = _itemId; // hard coded val.Where.ItemFieldId.Value = 3; val.Where.LanguageId.Value = (int)ViewState["_langId"]; val.Query.Load(); tblItemFieldStringValues txt = new tblItemFieldStringValues(); if (val.ItemFieldStringTempId > -1) { txt.LoadByPrimaryKey(val.ItemFieldStringTempId); } else { txt.LoadByPrimaryKey(val.ItemFieldStringId); } return txt.ItemFieldValue; } else { return _selCatImage + "/" + _selImg; } }
public void SaveValue() { if (DropDownList1.SelectedIndex > 0) { tblItems itm = new tblItems(); itm.LoadByPrimaryKey(_itemId); tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; val.Where.ItemFieldId.Value = 5; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); if (val.RowCount == 0) { val.AddNew(); val.ItemId = _itemId; val.ItemId = 5; val.LanguageId = int.Parse(Request["langId"]); } if (val.ItemFieldPdfAssetId != Int32.Parse(DropDownList1.SelectedValue)) val.ItemFieldPdfAssetTempId = Int32.Parse(DropDownList1.SelectedValue); val.Save(); } }
private void loadPdfs() { tblPdfAssets assets = new tblPdfAssets(); assets.LoadAll(); int sel = -1; if (_itemId > -1) { tblItems itm = new tblItems(); itm.LoadByPrimaryKey(_itemId); tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; val.Where.ItemFieldId.Value = 5; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); if (val.RowCount > 0) { val.Rewind(); if (_temp) sel = val.ItemFieldPdfAssetTempId; else sel = val.ItemFieldPdfAssetId; HyperLink2.Text = "View PDF"; HyperLink2.Target = "_blank"; HyperLink2.NavigateUrl = "~/renderpdf.aspx?itemid=" + _itemId.ToString()+"&langid=" + Request["langid"]; } else { val.AddNew(); val.ItemId = _itemId; val.ItemFieldId = 5; val.LanguageId = int.Parse(Request["langId"]); val.ItemFieldPdfAssetId = -1; val.Save(); } } else { if (_pdfid > -1) { HyperLink2.NavigateUrl = "~/renderpdf.aspx?pdfid=" + _pdfid.ToString(); HyperLink2.Text = "View PDF"; HyperLink2.Target = "_blank"; sel = _pdfid; } else { HyperLink2.Visible = false; LinkButton1.Visible = false; } } ListItem li2 = new ListItem("--Select--"); DropDownList1.Items.Add(li2); if (assets.RowCount > 0) { assets.Rewind(); do { ListItem li = new ListItem(assets.PdfTitle, assets.PdfAssetId.ToString()); if (sel == assets.PdfAssetId) { li.Selected = true; } DropDownList1.Items.Add(li); } while (assets.MoveNext()); } if (DropDownList1.SelectedIndex == 0) { HyperLink2.Visible = false; LinkButton1.Visible = false; } }
public void LoadItem(int itemId) { _itemId = itemId; tblItems item = new tblItems(); item.LoadByPrimaryKey(itemId); tblItemTypes type = new tblItemTypes(); type.LoadByPrimaryKey(item.ItemTypeId); lbItemName.Text = item.ItemTitle; if ((int)UserContext.GetContextItemAsInt("userlevel") == 1) lbItemName.Text += "[" + item.ItemId.ToString() + "]"; _itemTypeTitle = type.ItemTypeTitle; switch (_itemTypeTitle) { case "epicCMSRichTextControl": // cmsTextEditControl edit = new adm admin_controls_cmsTextEditControl txt = (admin_controls_cmsTextEditControl)Page.LoadControl("~/admin/controls/cmsTextEditControl.ascx"); txt.ItemId = itemId; PlaceHolder1.Controls.Add(txt); lbApprove.Visible = false; lbReject.Visible = false; if (txt.IsTemp()) { if ((int)UserContext.GetContextItemAsInt("userlevel") > 2) { Label1.Visible = false; } else { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; val.Where.ItemFieldId.Value = 7; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); //if (val.ItemFieldStringTempId > -1) //{ // lbApprove.Visible = true; // lbReject.Visible = true; //} } } break; case "epicCMSTextControl": admin_controls_cmsBasicTextEditControl txt4 = (admin_controls_cmsBasicTextEditControl)Page.LoadControl("~/admin/controls/cmsBasicTextEditControl.ascx"); txt4.ItemId = itemId; PlaceHolder1.Controls.Add(txt4); lbApprove.Visible = false; lbReject.Visible = false; if (txt4.IsTemp()) { if ((int)UserContext.GetContextItemAsInt("userlevel") > 2) { Label1.Visible = false; } else { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; val.Where.ItemFieldId.Value = 7; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); //if (val.ItemFieldStringTempId > -1) //{ // lbApprove.Visible = true; // lbReject.Visible = true; //} } } break; case "epicCMSImageControl": //admin_controls_cmsImageEditControl img = (admin_controls_cmsImageEditControl)Page.LoadControl("~/admin/controls/cmsImageEditControl.ascx"); admin_controls_cmsSelectImage img = (admin_controls_cmsSelectImage)Page.LoadControl("~/admin/controls/cmsSelectImage.ascx"); img.ItemId = itemId; PlaceHolder1.Controls.Add(img); lbApprove.Visible = false; lbReject.Visible = false; if (img.IsTemp()) { if ((int)UserContext.GetContextItemAsInt("userlevel") > 2) { Label1.Visible = false; } else { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; val.Where.ItemFieldId.Value = 3; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); //if (val.ItemFieldStringTempId > -1) //{ //lbApprove.Visible = true; // lbReject.Visible = true; //} } } break; case "epicCMSPDFControl": admin_controls_cmsPDFEditControl img2 = (admin_controls_cmsPDFEditControl)Page.LoadControl("~/admin/controls/cmsPDFEditControl.ascx"); admin_controls_cmsSelectPdf pdf = (admin_controls_cmsSelectPdf)Page.LoadControl("~/admin/controls/cmsSelectPDF.ascx"); img2.ItemId = itemId; pdf.ItemId = itemId; PlaceHolder1.Controls.Add(pdf); lbApprove.Visible = false; lbReject.Visible = false; if (pdf.IsTemp()) { if ((int)UserContext.GetContextItemAsInt("userlevel") > 2) { Label1.Visible = false; } //else //{ // lbApprove.Visible = true; // lbReject.Visible = true; //} } break; case "epicCMSImageTextControl": admin_controls_cmsTextImageEditControl te = (admin_controls_cmsTextImageEditControl)Page.LoadControl("~/admin/controls/cmsTextImageEditControl.ascx"); te.ItemId = itemId; PlaceHolder1.Controls.Add(te); break; } if (ConfigurationManager.AppSettings["usesApprovals"] != "true") { lbApprove.Visible = false; lbReject.Visible = false; } }
public void SaveValue() { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; // hard coded val.Where.ItemFieldId.Value = 2; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); if (val.RowCount == 0) { val.AddNew(); val.ItemFieldId = 2; val.LanguageId = int.Parse(Request["langId"]);; val.ItemId = _itemId; } tblItemFieldTextValues txt = new tblItemFieldTextValues(); try { txt.LoadByPrimaryKey(val.ItemFieldTextTempId); if (txt.RowCount == 0) { txt.AddNew(); } } catch { txt.AddNew(); } // check if we need an update tblItemFieldTextValues valtxt = new tblItemFieldTextValues(); bool update = true; try { valtxt.LoadByPrimaryKey(val.ItemFieldTextId); if (valtxt.ItemFieldValue == CtlRichTextControl1.Text) { update = false; } } catch { } if (update) { txt.ItemFieldValue = CtlRichTextControl1.Text; txt.Save(); if (ConfigurationManager.AppSettings["usesApprovals"] == "true") { val.ItemFieldTextTempId = txt.ItemFieldStringValueId; } else { val.ItemFieldTextId = txt.ItemFieldStringValueId; } val.Save(); } }
private void getTemp() { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; // hard coded val.Where.ItemFieldId.Value = 3; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); try { int ret = val.ItemFieldStringTempId; _temp = true; } catch { _temp = false; } }
public void SaveValue() { tblItemFieldsXValue val = new tblItemFieldsXValue(); val.Where.ItemId.Value = _itemId; // hard coded val.Where.ItemFieldId.Value = 2; val.Where.LanguageId.Value = int.Parse(Request["langId"]); val.Query.Load(); if (val.RowCount == 0) { val.AddNew(); val.ItemFieldId = 2; val.LanguageId = int.Parse(Request["langId"]); ; val.ItemId = _itemId; } tblItemFieldTextValues txt = new tblItemFieldTextValues(); try { txt.LoadByPrimaryKey(val.ItemFieldTextTempId); if (txt.RowCount == 0) { txt.AddNew(); } } catch { txt.AddNew(); } // check if we need an update tblItemFieldTextValues valtxt = new tblItemFieldTextValues(); bool update = true; try { valtxt.LoadByPrimaryKey(val.ItemFieldTextId); if (valtxt.ItemFieldValue == CtlRichTextControl1.Text) { update = false; } } catch { } if (update) { txt.ItemFieldValue = CtlRichTextControl1.Text; txt.Save(); if (ConfigurationManager.AppSettings["usesApprovals"] == "true") val.ItemFieldTextTempId = txt.ItemFieldStringValueId; else val.ItemFieldTextId = txt.ItemFieldStringValueId; val.Save(); } }