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