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); }
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); }
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 = 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 = 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(); }
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(); }
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() { 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(); } }
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(); } }