public override void UpdateEntities(PxMetaModel.PcAxisMetabaseEntities context)
{
if (!IsNew)
{
PxMetaModel.Variable variable = (from v in context.Variables
where v.Variable1 == Variable
select v).First();
variable.PresText = PresText;
variable.VariableInfo = VariableInfo;
variable.Footnote = Footnote == null ? "N" : Footnote;
variable.UserId = System.Security.Principal.WindowsIdentity.GetCurrent().Name;
variable.LogDate = DateTime.Now;
PxMetaModel.Variable_Eng variableEng = (from v in context.Variable_Eng
where v.Variable == Variable
select v).First();
variableEng.PresText = PresTextEnglish;
variableEng.UserId = System.Security.Principal.WindowsIdentity.GetCurrent().Name;
variableEng.LogDate = DateTime.Now;
}
PxMetaModel.SubTableVariable subTableVariable = (from st in context.SubTableVariables
where st.MainTable == MainTable.TableId && st.SubTable == "1" && st.Variable == Variable
select st).FirstOrDefault();
if (subTableVariable == null)
{
subTableVariable = new PxMetaModel.SubTableVariable();
subTableVariable.MainTable = MainTable.TableId;
subTableVariable.SubTable = "1";
subTableVariable.Variable = Variable;
context.AddToSubTableVariables(subTableVariable);
}
subTableVariable.ValueSet = String.IsNullOrWhiteSpace(ValueSet) ? null : ValueSet;
subTableVariable.VariableType = VariableType;
subTableVariable.StoreColumnNo = StoreColumnNo;
subTableVariable.UserID = System.Security.Principal.WindowsIdentity.GetCurrent().Name;
subTableVariable.LogDate = DateTime.Now;
foreach (var variableFootnote in VariableFootnotes)
{
variableFootnote.Variable = this;
variableFootnote.Save(context);
}
foreach (var removedVariableFootnote in RemovedVariableFootnotes)
{
removedVariableFootnote.DeleteEntities(context);
}
}
public override void CreateEntities(PxMetaModel.PcAxisMetabaseEntities context)
{
if (IsNew)
{
PxMetaModel.Variable variable = new PxMetaModel.Variable();
variable.Variable1 = Variable;
variable.PresText = PresText;
variable.VariableInfo = VariableInfo;
variable.Footnote = Footnote;
variable.UserId = System.Security.Principal.WindowsIdentity.GetCurrent().Name;
variable.LogDate = DateTime.Now;
context.AddToVariables(variable);
PxMetaModel.Variable_Eng variableEng = new PxMetaModel.Variable_Eng();
variableEng.Variable1 = variable;
variableEng.PresText = PresTextEnglish;
variableEng.UserId = System.Security.Principal.WindowsIdentity.GetCurrent().Name;
variableEng.LogDate = DateTime.Now;
context.AddToVariable_Eng(variableEng);
}
PxMetaModel.SubTableVariable subTableVariable = new PxMetaModel.SubTableVariable();
subTableVariable.MainTable = MainTable.TableId;
subTableVariable.SubTable = "1";
subTableVariable.Variable = Variable;
subTableVariable.ValueSet = String.IsNullOrWhiteSpace(ValueSet)?null:ValueSet;
subTableVariable.VariableType = VariableType;
subTableVariable.StoreColumnNo = StoreColumnNo;
subTableVariable.UserID = System.Security.Principal.WindowsIdentity.GetCurrent().Name;
subTableVariable.LogDate = DateTime.Now;
context.AddToSubTableVariables(subTableVariable);
foreach (var variableFootnote in VariableFootnotes)
{
variableFootnote.Variable = this;
variableFootnote.Save(context);
}
}