private string getTextVal() { 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(); tblItemFieldTextValues txt = new tblItemFieldTextValues(); try { txt.LoadByPrimaryKey(val.ItemFieldTextTempId); } catch { txt.LoadByPrimaryKey(val.ItemFieldTextId); } return(txt.ItemFieldValue); }
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 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 RejectChange() { 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); val.s_ItemFieldTextTempId = ""; txt.MarkAsDeleted(); txt.Save(); 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; }
private string getTextVal() { 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(); tblItemFieldTextValues txt = new tblItemFieldTextValues(); try { txt.LoadByPrimaryKey(val.ItemFieldTextTempId); } catch { txt.LoadByPrimaryKey(val.ItemFieldTextId); } return txt.ItemFieldValue; }
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(); } }
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(); } }