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