public static bool AddExtensionObject(int targetId, int table, string name, string value) { bool retVal = false; if (table != null) { using (VpnManagerEntities entities = new VpnManagerEntities()) { var checkedTargetId = 0; var targetTable = string.Empty; switch (table) { case (int)TargetTable.VpnType: checkedTargetId = (from vpn in entities.VpnType where vpn.Id == targetId select vpn.Id).FirstOrDefault(); targetTable = TargetTable.VpnType.ToString(); break; case (int)TargetTable.Machine: checkedTargetId = (from machine in entities.Machine where machine.Id == targetId select machine.Id).FirstOrDefault(); targetTable = TargetTable.Machine.ToString(); break; case (int)TargetTable.Customer: checkedTargetId = (from customer in entities.Customer where customer.Id == targetId select customer.Id).FirstOrDefault(); targetTable = TargetTable.Customer.ToString(); break; case (int)TargetTable.Plant: checkedTargetId = (from plant in entities.Plant where plant.Id == targetId select plant.Id).FirstOrDefault(); targetTable = TargetTable.Plant.ToString(); break; } if (checkedTargetId != 0) { ExtensionObjects eObj = new ExtensionObjects(); eObj.Name = name; eObj.Value = value; eObj.IdTargetElement = targetId; eObj.TargetTableName = targetTable; entities.ExtensionObjects.Add(eObj); } retVal = entities.SaveChanges() > 0; } } return(retVal); }
/// <summary> /// Delete the extension obj from the passe id (Id of the table Extension objects) /// </summary> /// <param name="id"></param> /// <returns></returns> public static bool DeleteExtensionObject(int id) { bool retVal = false; using (VpnManagerEntities entities = new VpnManagerEntities()) { ExtensionObjects eobj = (from extObj in entities.ExtensionObjects where extObj.Id == id select extObj).FirstOrDefault(); if (eobj != null) { entities.ExtensionObjects.Remove(eobj); retVal = entities.SaveChanges() > 0; } } return(retVal); }
public static bool DeleteExtensionObject(int targetId, TargetTable table, string name) { bool retVal = false; using (VpnManagerEntities entities = new VpnManagerEntities()) { ExtensionObjects eobj = (from extObj in entities.ExtensionObjects where extObj.TargetTableName == table.ToString() && extObj.IdTargetElement == targetId && extObj.Name == name select extObj).FirstOrDefault(); if (eobj != null) { entities.ExtensionObjects.Remove(eobj); retVal = entities.SaveChanges() > 0; } } return(retVal); }