private void Delete_Category(object sender, EventArgs e)
{
IList <Definition> _Ldef = Definition.LoadFromQuery("SELECT * FROM SYNAPSEREPORT_DEFINITION WHERE FK_CATEGORY=" + ((Category)olvCategory.SelectedObject).ID);
if (_Ldef.Count > 0)
{
GlobalFunctions.showMessage("INFO", "Info.0003");
}
else
{
if (GlobalFunctions.showMessage("QUEST", "Quest.0001") == System.Windows.Forms.DialogResult.Yes)
{
SynapseLabel synLbl = SynapseLabel.LoadByID(((Category)olvCategory.SelectedObject).LABELID);
SynapseCore.Database.DBFunction.StartTransaction();
try
{
synLbl.delete();
((Category)olvCategory.SelectedObject).delete();
SynapseCore.Database.DBFunction.CommitTransaction();
listCategory();
}
catch (Exception ex)
{
SynapseCore.Database.DBFunction.RollbackTransaction();
GlobalFunctions.showMessage("ERR", "Err.9999", ex.Message);
}
}
}
}
private void tsbSave_Click(object sender, EventArgs e)
{
GlobalFunctions.resetError();
if (checkFields())
{
SynapseCore.Database.DBFunction.StartTransaction();
try
{
foreach (uc_LabelBag bag in flowLayoutPanel1.Controls)
{
if (bag.LblBag.Labels[0].LABELID == 0)
{
lblid = SynapseLabel.GetNextID();
for (Int32 x = 0; x < bag.LblBag.Labels.Count; x++)
{
bag.LblBag.Labels[x].LABELID = lblid;
}
bag.Save();
}
else
{
lblid = bag.LblBag.Labels[0].LABELID;
bag.Save();
}
}
_category.ID = _categoryID;
switch (GlobalVariables.selectedOrigin.ORIGIN)
{
case Origin.Module:
_category.FK_MODULE = GlobalVariables.selectedOrigin.MODULEID;
_category.FK_INTERFACE = 0;
break;
case Origin.Interface:
_category.FK_MODULE = 0;
_category.FK_INTERFACE = GlobalVariables.selectedOrigin.INTERFACEID;
break;
}
_category.LABELID = lblid;
_category.save();
SynapseCore.Database.DBFunction.CommitTransaction();
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
catch (Exception ex)
{
SynapseCore.Database.DBFunction.RollbackTransaction();
GlobalFunctions.showMessage("ERR", "Err.9999", ex.Message);
}
}
else
{
GlobalFunctions.showError();
}
}
private static void setTo(SynapseInterface Int)
{
ReportOrigin _reportOrigin = new ReportOrigin();
_reportOrigin.ORIGIN = Origin.Interface;
_reportOrigin.TECHNICALNAME = Int.TECHNICALNAME;
_reportOrigin.DBTYPE = (DatabaseType)Enum.Parse(typeof(DatabaseType), Int.DBTYPE, true);
_reportOrigin.DBCONNECTION = Int.TECHNICALNAME;
_reportOrigin.FriendlyName = new LabelBag();
_reportOrigin.FriendlyName.Labels = new List <SynapseLabel>();
foreach (SynapseLanguage lang in SynapseLanguage.LoadFromQuery("SELECT * FROM SYNAPSE_LANGUAGE ORDER BY CODE"))
{
SynapseLabel newlabel = new SynapseLabel();
newlabel.LABELID = 0;
newlabel.LANGUAGE = lang.CODE;
newlabel.TEXT = Int.TECHNICALNAME;
_reportOrigin.FriendlyName.Labels.Add(newlabel);
}
_reportOrigin._MODULEID = 0;
_reportOrigin.INTERFACEID = Int.ID;
_reportOrigin._TYPE = Int.TYPE;
_reportOrigin.CONNECTIONSTRING = Int.CONNECTIONSTRING;
_reportOrigin.TABLESQUERY = Int.TABLESQUERY;
_reportOrigin.VIEWSQUERY = Int.VIEWSQUERY;
_reportOrigin.FIELDSQUERY = Int.FIELDSQUERY;
_reportOrigin.ORACLE_HOME = Int.ORACLE_HOME;
GlobalVariables.selectedOrigin = _reportOrigin;
}
private void CopyProperties(object dest, object src)
{
Type srctype = src.GetType();
foreach (PropertyInfo pi in dest.GetType().GetProperties())
{
if (pi.CanWrite)
{
if (pi.PropertyType.ToString() != "SynapseCore.Database.LabelBag")
{
pi.SetValue(dest, srctype.GetProperty(pi.Name).GetValue(src, null), null);
}
else
{
if (chk_save.Checked)
{
//--------------------------------------------
Int64 labelID = 0;
string DefaultText = null;
LabelId[] ids = (LabelId[])pi.GetCustomAttributes(typeof(LabelId), true);
foreach (LabelId id in ids)
{
PropertyInfo field = src.GetType().GetProperty(id.IDField);
labelID = (Int64)field.GetValue(src, null);
if (id.DefaultField != null)
{
PropertyInfo defaultfield = src.GetType().GetProperty(id.DefaultField);
DefaultText = (string)defaultfield.GetValue(src, null);
}
}
ACCLabelBag srclb = new ACCLabelBag();
srclb.load(labelID, DefaultText);
//--------------------------------------------
LabelBag destlb = new LabelBag();
destlb.Labels = new List <SynapseLabel>();
//CopyProperties(destlb, srclb);
foreach (ACCSynapseLabel a_lbl in srclb.Labels)
{
SynapseLabel p_lbl = new SynapseLabel();
CopyProperties(p_lbl, a_lbl);
destlb.Labels.Add(p_lbl);
}
Int64 nextid = SynapseLabel.GetNextID();
foreach (LabelId id in ids)
{
dest.GetType().GetProperty(id.IDField).SetValue(dest, nextid, null);
}
foreach (SynapseLabel lbl in destlb.Labels)
{
lbl.LABELID = nextid;
}
CreateLinkEntry(srclb, labelID, nextid);
}
}
}
}
}
public void Refresh()
{
List <uc_Field> c = flowLayoutPanel1.Controls.OfType <uc_Field>().Cast <uc_Field>().ToList();
foreach (uc_Field field in c)
{
SynapseLabel lbl = _lblBag.GetLabel(field.FieldName);
lbl.TEXT = field.FieldValue.ToString();
}
}
public override void initForm(SynapseCore.Security.Tools.SecureAndTranslateMode Mode)
{
base.initForm(Mode);
switch (_action)
{
case "NEW":
this.Text = this.Text + " - " + SynapseForm.GetLabel("global.Create");
_category.ID = 0;
_category.LABEL = new LabelBag();
_category.LABEL.Labels = new List <SynapseLabel>();
foreach (SynapseLanguage lang in languages)
{
SynapseLabel newlabel = new SynapseLabel();
newlabel.LABELID = 0;
newlabel.LANGUAGE = lang.CODE;
newlabel.TEXT = "";
_category.LABEL.Labels.Add(newlabel);
}
break;
case "EDIT":
this.Text = this.Text + " - " + SynapseForm.GetLabel("global.Edit");
_category = Category.LoadByID(_categoryID);
if (_category.LABEL.Labels.Count < languages.Count)
{
foreach (SynapseLanguage lang in languages)
{
if (_category.LABEL.GetLabel(lang.CODE) == null)
{
SynapseLabel newlabel = new SynapseLabel();
newlabel.LABELID = _category.LABEL.GetLabelID();
newlabel.LANGUAGE = lang.CODE;
newlabel.TEXT = "";
newlabel.save();
_category.LABEL.Labels.Add(newlabel);
}
}
}
break;
}
bag.FieldName = GetLabel("frmCategory.lblBag");
bag.LblBag = _category.LABEL;
bag.Visible = true;
bag.Dock = DockStyle.Fill;
flowLayoutPanel1.Controls.Add(bag);
}
private void tsbSave_Click(object sender, EventArgs e)
{
if (checkFields())
{
SynapseCore.Database.DBFunction.StartTransaction();
try
{
_profile.FK_ModuleID = (Int64)cbModule.SelectedValue;
_profile.TECHNICALNAME = txTechnicalName.Text;
_profile.LEVEL = Int64.Parse("0" + txLevel.Text);
_profile.IS_OWNER = ckOwner.Checked;
Int64 lblid = 0;
if (bagDescription.LblBag.Labels[0].LABELID == 0)
{
lblid = SynapseLabel.GetNextID();
for (Int32 x = 0; x < bagDescription.LblBag.Labels.Count; x++)
{
bagDescription.LblBag.Labels[x].LABELID = lblid;
}
bagDescription.Save();
}
else
{
lblid = bagDescription.LblBag.Labels[0].LABELID;
bagDescription.Save();
}
_profile.FK_LABELID = lblid;
_profile.save();
SynapseCore.Database.DBFunction.CommitTransaction();
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
catch (Exception ex)
{
SynapseCore.Database.DBFunction.RollbackTransaction();
MessageBox.Show("Data not saved in Database:" + ex.Message, "Database Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void tsbSave_Click(object sender, EventArgs e)
{
GlobalFunctions.resetError();
if (checkFields())
{
SynapseCore.Database.DBFunction.StartTransaction();
try
{
foreach (uc_LabelBag bag in flowLayoutPanel1.Controls)
{
if (bag.LblBag.Labels[0].LABELID == 0)
{
Int64 lblID = SynapseLabel.GetNextID();
for (Int32 x = 0; x < bag.LblBag.Labels.Count; x++)
{
bag.LblBag.Labels[x].LABELID = lblID;
}
bag.Save();
}
else
{
bag.Save();
}
}
SynapseCore.Database.DBFunction.CommitTransaction();
this.DialogResult = System.Windows.Forms.DialogResult.OK;
}
catch (Exception ex)
{
SynapseCore.Database.DBFunction.RollbackTransaction();
GlobalFunctions.showMessage("ERR", "Err.9999", ex.Message);
}
}
else
{
GlobalFunctions.showError();
}
}
public override void initForm(SynapseCore.Security.Tools.SecureAndTranslateMode Mode)
{
base.initForm(Mode);
ckOwner.Text = SynapseForm.GetLabel("frmGroup.ckOwner");
fillModule();
switch (_action)
{
case "NEW":
this.Text = this.Text + " - " + SynapseForm.GetLabel("Label.Create");
_profile.ID = 0;
cbModule.SelectedIndex = -1;
txTechnicalName.Text = "";
txLevel.Text = "";
ckOwner.Checked = false;
_profile.Description = new LabelBag();
_profile.Description.Labels = new List <SynapseLabel>();
foreach (SynapseLanguage lang in languages)
{
SynapseLabel newDescription = new SynapseLabel();
newDescription.LABELID = 0;
newDescription.LANGUAGE = lang.CODE;
newDescription.TEXT = "";
_profile.Description.Labels.Add(newDescription);
}
break;
case "EDIT":
this.Text = this.Text + " - " + SynapseForm.GetLabel("Label.Edit");
if (_profile.FK_ModuleID != null)
{
cbModule.SelectedValue = _profile.FK_ModuleID;
}
else
{
cbModule.SelectedIndex = -1;
}
txTechnicalName.Text = _profile.TECHNICALNAME;
txLevel.Text = _profile.LEVEL.ToString();
ckOwner.Checked = _profile.IS_OWNER;
if (_profile.Description.Labels.Count < languages.Count)
{
foreach (SynapseLanguage lang in languages)
{
if (_profile.Description.GetLabel(lang.CODE) == null)
{
SynapseLabel newlabel = new SynapseLabel();
newlabel.LABELID = _profile.Description.GetLabelID();
newlabel.LANGUAGE = lang.CODE;
newlabel.TEXT = "";
newlabel.save();
_profile.Description.Labels.Add(newlabel);
}
}
}
break;
}
bagDescription.FieldName = GetLabel("frmGroup.gbDescription");
bagDescription.LblBag = _profile.Description;
bagDescription.Visible = true;
bagDescription.Dock = DockStyle.Fill;
flowLayoutPanel1.Controls.Add(bagDescription);
}
public void load(Int64 ID, string DefaultText)
{
_labels = SynapseLabel.Load("Where LABELID = " + ID + " ORDER BY LANGUAGE");
_defaultLabel = DefaultText;
}
public frm_SynapseObjectEdit(object SynapseObject)
{
InitializeComponent();
_SynapseObject = SynapseObject;
bags = new Hashtable();
languages = SynapseLanguage.Load();
IList <PropertyInfo> properties = SynapseObject.GetType().GetProperties();
IList <FieldInfo> fields = SynapseObject.GetType().GetFields(BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.Static);
List <Control> labelBagControl = new List <Control>();
foreach (FieldInfo fi in fields)
{
if (fi.Name == "_IDproperty")
{
_IDproperty = fi.GetValue(SynapseObject).ToString();
}
if (fi.Name == "_EcludeForSave")
{
_EcludeForSave = fi.GetValue(SynapseObject).ToString();
}
if (fi.Name == "_tableName")
{
_tableName = fi.GetValue(SynapseObject).ToString().Trim(new char[] { '[', ']' });
}
}
foreach (PropertyInfo pi in from x in properties where x.PropertyType.ToString() == "SynapseCore.Database.LabelBag" select x)
{
uc_LabelBag bag = new uc_LabelBag();
object value = pi.GetValue(SynapseObject, null);
LabelBag lbl = (LabelBag)value;
Int64 lblid = lbl.GetLabelID();
if (lblid == 0)
{
lblid = SynapseLabel.GetNextID();
}
LabelId[] ids = (LabelId[])pi.GetCustomAttributes(typeof(LabelId), true);
foreach (LabelId id in ids)
{
PropertyInfo field = SynapseObject.GetType().GetProperty(id.IDField);
field.SetValue(SynapseObject, lblid, null);
bags.Add(id.IDField, id);
}
if (lbl.Labels.Count < languages.Count)
{
foreach (SynapseLanguage lang in languages)
{
if (lbl.GetLabel(lang.CODE) == null)
{
SynapseLabel newlabel = new SynapseLabel();
newlabel.LABELID = lblid;
newlabel.LANGUAGE = lang.CODE;
newlabel.TEXT = "";
newlabel.save();
lbl.Labels.Add(newlabel);
}
}
_NewLabels = true;
}
bag.FieldName = pi.Name;
bag.LblBag = lbl;
labelBagControl.Add(bag);
//flowLayoutPanel1.Controls.Add(bag);
}
foreach (PropertyInfo pi in from x in properties where x.PropertyType.ToString() != "SynapseCore.Database.LabelBag" select x)
{
if (!bags.ContainsKey(pi.Name))
{
EntityFieldType FieldType = ((EntityFieldType[])pi.GetCustomAttributes(typeof(EntityFieldType), true)).SingleOrDefault();
uc_Field field;
if (FieldType != null)
{
field = new uc_Field(FieldType);
}
else
{
field = new uc_Field();
}
field.FieldName = pi.Name;
field.DisplayName = SynapseForm.GetLabel(_tableName.ToUpperInvariant() + "." + pi.Name.ToUpperInvariant());
object value = pi.GetValue(SynapseObject, null);
if (value != null)
{
field.FieldValue = value;
}
if (pi.Name == _IDproperty)
{
field.Enabled = false;
}
flowLayoutPanel1.Controls.Add(field);
}
}
flowLayoutPanel1.Controls.AddRange(labelBagControl.ToArray());
if (_NewLabels)
{
SynapseObject.GetType().InvokeMember("save", BindingFlags.InvokeMethod | BindingFlags.Instance | BindingFlags.Public, null, SynapseObject, null);
}
}
public override void initForm(SynapseCore.Security.Tools.SecureAndTranslateMode Mode)
{
base.initForm(Mode);
switch (_action)
{
case "NEW":
this.Text = this.Text + " - " + SynapseForm.GetLabel("Label.Create");
_module.ID = 0;
txPath.Text = "";
txTechnicalName.Text = "";
txVersion.Text = "";
txVersionDate.Text = "";
txCategory.Text = "";
txDevSources.Text = "";
txProdSources.Text = "";
ckActive.Checked = true;
ckRequestable.Checked = false;
_module.FriendlyName = new LabelBag();
_module.FriendlyName.Labels = new List <SynapseLabel>();
_module.Description = new LabelBag();
_module.Description.Labels = new List <SynapseLabel>();
foreach (SynapseLanguage lang in languages)
{
SynapseLabel newFriendlyName = new SynapseLabel();
newFriendlyName.LABELID = 0;
newFriendlyName.LANGUAGE = lang.CODE;
newFriendlyName.TEXT = "";
_module.FriendlyName.Labels.Add(newFriendlyName);
SynapseLabel newDescription = new SynapseLabel();
newDescription.LABELID = 0;
newDescription.LANGUAGE = lang.CODE;
newDescription.TEXT = "";
_module.Description.Labels.Add(newDescription);
}
break;
case "EDIT":
this.Text = this.Text + " - " + SynapseForm.GetLabel("Label.Edit");
_module = SynapseModule.LoadByID(_moduleID);
txPath.Text = _module.PATH;
txTechnicalName.Text = _module.TECHNICALNAME;
txVersion.Text = _module.VERSION;
txVersionDate.Text = _module.VERSIONDATE;
txCategory.Text = _module.MODULECATEGORY;
txDevSources.Text = _module.DEVSOURCE;
txProdSources.Text = _module.PRODSOURCE;
ckActive.Checked = _module.IS_ACTIVE;
ckRequestable.Checked = _module.IS_REQUESTABLE;
if (_module.FriendlyName.Labels.Count < languages.Count)
{
foreach (SynapseLanguage lang in languages)
{
if (_module.FriendlyName.GetLabel(lang.CODE) == null)
{
SynapseLabel newlabel = new SynapseLabel();
newlabel.LABELID = _module.FriendlyName.GetLabelID();
newlabel.LANGUAGE = lang.CODE;
newlabel.TEXT = "";
newlabel.save();
_module.FriendlyName.Labels.Add(newlabel);
}
}
}
if (_module.Description.Labels.Count < languages.Count)
{
foreach (SynapseLanguage lang in languages)
{
if (_module.Description.GetLabel(lang.CODE) == null)
{
SynapseLabel newlabel = new SynapseLabel();
newlabel.LABELID = _module.Description.GetLabelID();
newlabel.LANGUAGE = lang.CODE;
newlabel.TEXT = "";
newlabel.save();
_module.Description.Labels.Add(newlabel);
}
}
}
break;
}
bagName.FieldName = GetLabel("frmModule.gbFiendlyName");
bagName.LblBag = _module.FriendlyName;
bagName.Visible = true;
bagName.Dock = DockStyle.Fill;
flowLayoutPanel1.Controls.Add(bagName);
bagDescription.FieldName = GetLabel("frmModule.gbDescription");
bagDescription.LblBag = _module.Description;
bagDescription.Visible = true;
bagDescription.Dock = DockStyle.Fill;
flowLayoutPanel1.Controls.Add(bagDescription);
}
private void tsbSave_Click(object sender, EventArgs e)
{
if (checkFields())
{
SynapseCore.Database.DBFunction.StartTransaction();
try
{
_module.ID = _moduleID;
_module.PATH = txPath.Text;
_module.TECHNICALNAME = txTechnicalName.Text;
_module.VERSION = txVersion.Text;
_module.VERSIONDATE = txVersionDate.Text;
_module.MODULECATEGORY = txCategory.Text;
_module.DEVSOURCE = txDevSources.Text;
_module.PRODSOURCE = txProdSources.Text;
_module.IS_ACTIVE = ckActive.Checked;
_module.IS_REQUESTABLE = ckRequestable.Checked;
if (bagName.LblBag.Labels[0].LABELID == 0)
{
lblid = SynapseLabel.GetNextID();
for (Int32 x = 0; x < bagName.LblBag.Labels.Count; x++)
{
bagName.LblBag.Labels[x].LABELID = lblid;
}
bagName.Save();
}
else
{
lblid = bagName.LblBag.Labels[0].LABELID;
bagName.Save();
}
_module.LABELID = lblid;
if (bagDescription.LblBag.Labels[0].LABELID == 0)
{
lblid = SynapseLabel.GetNextID();
for (Int32 x = 0; x < bagDescription.LblBag.Labels.Count; x++)
{
bagDescription.LblBag.Labels[x].LABELID = lblid;
}
bagDescription.Save();
}
else
{
lblid = bagDescription.LblBag.Labels[0].LABELID;
bagDescription.Save();
}
_module.DESCLABELID = lblid;
_module.save();
SynapseCore.Database.DBFunction.CommitTransaction();
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
catch (Exception ex)
{
SynapseCore.Database.DBFunction.RollbackTransaction();
MessageBox.Show("Data not saved in Database:" + ex.Message, "Database Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void tsbCopy_Click(object sender, EventArgs e)
{
SynapseCore.Database.DBFunction.StartTransaction();
Definition reportDef = Definition.LoadByID(((Definition)olvReport.SelectedObject).ID);
Definition reportNew = new Definition();
try
{
reportNew.ID = 0;
reportNew.QRY_JOIN = reportDef.QRY_JOIN;
reportNew.QRY_CONDITION = reportDef.QRY_CONDITION;
reportNew.QRY_GROUP = reportDef.QRY_GROUP;
reportNew.FK_MODULE = reportDef.FK_MODULE;
reportNew.FK_INTERFACE = reportDef.FK_INTERFACE;
reportNew.FK_CATEGORY = reportDef.FK_CATEGORY;
reportNew.FK_TYPE = reportDef.FK_TYPE;
reportNew.ADDCATEGORY = reportDef.ADDCATEGORY;
reportNew.AVAILABLE = false;
Int64 reportNew_lblID = SynapseLabel.GetNextID();
foreach (SynapseLanguage lang in SynapseLanguage.LoadFromQuery("SELECT * FROM SYNAPSE_LANGUAGE ORDER BY CODE"))
{
SynapseLabel newlabel = new SynapseLabel();
newlabel.LABELID = reportNew_lblID;
newlabel.LANGUAGE = lang.CODE;
newlabel.TEXT = SynapseLabel.Load("WHERE LANGUAGE='" + lang.CODE + "' AND LABELID=" + reportDef.LABELID).FirstOrDefault().TEXT + " (*)";
newlabel.save();
}
reportNew.LABELID = reportNew_lblID;
reportNew.save();
foreach (Tables tbl in Tables.Load("WHERE FK_REPORT=" + reportDef.ID))
{
Tables tblNew = new Tables();
tblNew.ID = 0;
tblNew.TABLENAME = tbl.TABLENAME;
tblNew.TYPE = tbl.TYPE;
tblNew.FK_REPORT = reportNew.ID;
tblNew.save();
}
foreach (Field fld in Field.Load("WHERE FK_REPORT=" + reportDef.ID))
{
Field fldNew = new Field();
fldNew.ID = 0;
fldNew.FIELDNAME = fld.FIELDNAME;
fldNew.FORMAT = fld.FORMAT;
fldNew.POSITION = fld.POSITION;
fldNew.WIDTH = fld.WIDTH;
fldNew.FK_REPORT = reportNew.ID;
Int64 fldNew_lblID = SynapseLabel.GetNextID();
foreach (SynapseLanguage lang in SynapseLanguage.LoadFromQuery("SELECT * FROM SYNAPSE_LANGUAGE ORDER BY CODE"))
{
SynapseLabel newlabel = new SynapseLabel();
newlabel.LABELID = fldNew_lblID;
newlabel.LANGUAGE = lang.CODE;
newlabel.TEXT = SynapseLabel.Load("WHERE LANGUAGE='" + lang.CODE + "' AND LABELID=" + fld.ALIASID).FirstOrDefault().TEXT;
newlabel.save();
}
fldNew.ALIASID = fldNew_lblID;
fldNew.save();
}
foreach (Filter flt in Filter.Load("WHERE FK_REPORT=" + reportDef.ID))
{
Filter fltNew = new Filter();
fltNew.ID = 0;
fltNew.NAME = flt.NAME;
fltNew.TYPE = flt.TYPE;
fltNew.POSITION = flt.POSITION;
fltNew.CTRL_TABLE = flt.CTRL_TABLE;
fltNew.CTRL_FIELD = flt.CTRL_FIELD;
fltNew.CTRL_CUSTOM = flt.CTRL_CUSTOM;
fltNew.DATA_TABLE = flt.DATA_TABLE;
fltNew.DATA_VALUE = flt.DATA_VALUE;
fltNew.DATA_DISPLAY = flt.DATA_DISPLAY;
fltNew.DATA_QUERY = flt.DATA_QUERY;
fltNew.WIDTH = flt.WIDTH;
fltNew.ADD_TO_REPORTTITLE = flt.ADD_TO_REPORTTITLE;
fltNew.IS_LINKED = false;
fltNew.LINKED_FILTERID = 0;
fltNew.LINKED_FIELD = "";
fltNew.CTRL_TYPE = flt.CTRL_TYPE;
fltNew.FK_REPORT = reportNew.ID;
Int64 fltNew_lblID = SynapseLabel.GetNextID();
foreach (SynapseLanguage lang in SynapseLanguage.LoadFromQuery("SELECT * FROM SYNAPSE_LANGUAGE ORDER BY CODE"))
{
SynapseLabel newlabel = new SynapseLabel();
newlabel.LABELID = fltNew_lblID;
newlabel.LANGUAGE = lang.CODE;
newlabel.TEXT = SynapseLabel.Load("WHERE LANGUAGE='" + lang.CODE + "' AND LABELID=" + flt.LABELID).FirstOrDefault().TEXT;
newlabel.save();
}
fltNew.LABELID = fltNew_lblID;
fltNew.save();
}
SynapseCore.Database.DBFunction.CommitTransaction();
listReport();
}
catch (Exception ex)
{
SynapseCore.Database.DBFunction.RollbackTransaction();
GlobalFunctions.showMessage("ERR", "Err.9999", ex.Message);
}
}
