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