private ExecutableProgramTypeSingletonRepository()
{
ServiceUtility serviceUtility = new ServiceUtility();
_rootUri = serviceUtility.BaseUri;
_repositoryContext = new MenuSecurityEntities(_rootUri);
}
public void DeleteFromRepository(ExecutableProgramType executableProgramType)
{
if (_repositoryContext.GetEntityDescriptor(executableProgramType) != null)
{//if it exists in the db delete it from the db
MenuSecurityEntities context = new MenuSecurityEntities(_rootUri);
context.MergeOption = MergeOption.AppendOnly;
context.IgnoreResourceNotFoundException = true;
ExecutableProgramType deletedExecutableProgramType = (from q in context.ExecutableProgramTypes
where q.ExecutableProgramTypeID == executableProgramType.ExecutableProgramTypeID
select q).FirstOrDefault();
if (deletedExecutableProgramType != null)
{
context.DeleteObject(deletedExecutableProgramType);
context.SaveChanges();
}
context = null;
_repositoryContext.MergeOption = MergeOption.AppendOnly;
//if it is being tracked remove it...
if (GetExecutableProgramTypeEntityState(executableProgramType) != EntityStates.Detached)
{
_repositoryContext.Detach(executableProgramType);
}
}
}
public static List <Temp> GetMetaData(this MenuItemCode entityObject)
{
XERP.Server.DAL.MenuSecurityDAL.DALUtility dalUtility = new DALUtility();
List <Temp> tempList = new List <Temp>();
int id = 0;
using (MenuSecurityEntities ctx = new MenuSecurityEntities(dalUtility.EntityConectionString))
{
var c = ctx.MenuItemCodes.FirstOrDefault();
var queryResults = from meta in ctx.MetadataWorkspace.GetItems(DataSpace.CSpace)
.Where(m => m.BuiltInTypeKind == BuiltInTypeKind.EntityType)
from query in (meta as EntityType).Properties
.Where(p => p.DeclaringType.Name == entityObject.GetType().Name)
select query;
if (queryResults.Count() > 0)
{
foreach (var queryResult in queryResults.ToList())
{
Temp temp = new Temp();
temp.ID = id;
temp.Name = queryResult.Name.ToString();
temp.ShortChar_1 = queryResult.TypeUsage.EdmType.Name;
if (queryResult.TypeUsage.EdmType.Name == "String")
{
temp.Int_1 = Convert.ToInt32(queryResult.TypeUsage.Facets["MaxLength"].Value);
}
temp.Bool_1 = false; //we use this as a error trigger false = not an error...
tempList.Add(temp);
id++;
}
}
}
return(tempList);
}
public IEnumerable <ExecutableProgramType> GetExecutableProgramTypes(ExecutableProgramType executableProgramTypeQuerryObject, string companyID)
{
_repositoryContext = new MenuSecurityEntities(_rootUri);
_repositoryContext.MergeOption = MergeOption.AppendOnly;
_repositoryContext.IgnoreResourceNotFoundException = true;
var queryResult = from q in _repositoryContext.ExecutableProgramTypes
where q.CompanyID == companyID
select q;
if (!string.IsNullOrEmpty(executableProgramTypeQuerryObject.Type))
{
queryResult = queryResult.Where(q => q.Type.StartsWith(executableProgramTypeQuerryObject.Type.ToString()));
}
if (!string.IsNullOrEmpty(executableProgramTypeQuerryObject.Description))
{
queryResult = queryResult.Where(q => q.Description.StartsWith(executableProgramTypeQuerryObject.Description.ToString()));
}
if (!string.IsNullOrEmpty(executableProgramTypeQuerryObject.ExecutableProgramTypeID))
{
queryResult = queryResult.Where(q => q.Description.StartsWith(executableProgramTypeQuerryObject.ExecutableProgramTypeID.ToString()));
}
return(queryResult);
}
private MenuItemSingletonRepository()
{
ServiceUtility serviceUtility = new ServiceUtility();
_rootUri = serviceUtility.BaseUri;
_repositoryContext = new MenuSecurityEntities(_rootUri);
}
//Upsert(Add and Update) SecurityGroup to the MenuSecurity table...
public void AddAllMenuSecurities(string menuItemID, string companyID)
{ //remove them all then we will add them all...
RemoveAllMenuSecurities(menuItemID, companyID);
//declare a different context as to not disturb the repostitory context that is tracking MenuItems
MenuSecurityEntities context = new MenuSecurityEntities(_rootUri);
//get Security Groups...
context.MergeOption = MergeOption.AppendOnly;
context.IgnoreResourceNotFoundException = true;
var queryResult = from q in context.SecurityGroups
where q.CompanyID == companyID
select q;
foreach (SecurityGroup item in queryResult.ToList())
{
MenuSecurity menuSecurity = new MenuSecurity();
menuSecurity.CompanyID = companyID;
menuSecurity.MenuItemID = menuItemID;
menuSecurity.SecurityGroupID = item.SecurityGroupID;
context.MergeOption = MergeOption.NoTracking;
context.AddToMenuSecurities(menuSecurity);
context.SaveChanges();
}
context = null;
}
public void DeleteFromRepository(MenuItem menuItem)
{
if (_repositoryContext.GetEntityDescriptor(menuItem) != null)
{//if it exists in the db delete it from the db
MenuSecurityEntities context = new MenuSecurityEntities(_rootUri);
context.MergeOption = MergeOption.AppendOnly;
context.IgnoreResourceNotFoundException = true;
MenuItem deletedMenuItem = (from q in context.MenuItems
where q.MenuItemID == menuItem.MenuItemID
select q).FirstOrDefault();
if (deletedMenuItem != null)
{
context.DeleteObject(deletedMenuItem);
context.SaveChanges();
}
context = null;
_repositoryContext.MergeOption = MergeOption.AppendOnly;
//if it is being tracked remove it...
if (GetMenuItemEntityState(menuItem) != EntityStates.Detached)
{
_repositoryContext.Detach(menuItem);
}
}
}
//Upsert(Add and Update) SecurityGroup to the MenuSecurity table...
public void AddMenuSecurity(string menuItemID, string securityGroupID, string companyID)
{//declare a different context as to not disturb the repostitory context that is tracking MenuItems
MenuSecurityEntities context = new MenuSecurityEntities(_rootUri);
//make sure it does not exist all ready...
context.MergeOption = MergeOption.AppendOnly;
context.IgnoreResourceNotFoundException = true;
var queryResult = from q in context.MenuSecurities
where q.CompanyID == companyID &&
q.MenuItemID == menuItemID &&
q.SecurityGroupID == securityGroupID
select q;
if (queryResult.ToList().Count() == 0)
{//it does not exist add it...
MenuSecurity menuSecurity = new MenuSecurity();
menuSecurity.CompanyID = companyID;
menuSecurity.MenuItemID = menuItemID;
menuSecurity.SecurityGroupID = securityGroupID;
context.MergeOption = MergeOption.NoTracking;
context.AddToMenuSecurities(menuSecurity);
context.SaveChanges();
}
context = null;
}
public IEnumerable <MenuItem> GetMenuItems(MenuItem menuItemQuerryObject, string companyID)
{
_repositoryContext = new MenuSecurityEntities(_rootUri);
_repositoryContext.MergeOption = MergeOption.AppendOnly;
_repositoryContext.IgnoreResourceNotFoundException = true;
var queryResult = from q in _repositoryContext.MenuItems.Expand("MenuSecurities/SecurityGroup")
where q.CompanyID == companyID
select q;
if (!string.IsNullOrEmpty(menuItemQuerryObject.Name))
{
queryResult = queryResult.Where(q => q.Name.StartsWith(menuItemQuerryObject.Name.ToString()));
}
if (!string.IsNullOrEmpty(menuItemQuerryObject.Description))
{
queryResult = queryResult.Where(q => q.Description.StartsWith(menuItemQuerryObject.Description.ToString()));
}
if (!string.IsNullOrEmpty(menuItemQuerryObject.MenuItemTypeID))
{
queryResult = queryResult.Where(q => q.MenuItemTypeID.StartsWith(menuItemQuerryObject.MenuItemTypeID.ToString()));
}
if (!string.IsNullOrEmpty(menuItemQuerryObject.MenuItemCodeID))
{
queryResult = queryResult.Where(q => q.MenuItemCodeID.StartsWith(menuItemQuerryObject.MenuItemCodeID.ToString()));
}
return(queryResult);
}
public MenuSecurityServiceAgent()
{
ServiceUtility serviceUtility = new ServiceUtility();
_rootUri = _serviceUtility.BaseUri;
//this context will be used for read only gets...
_context = new MenuSecurityEntities(_rootUri);
}
public DBStoredImageServiceAgent()
{
ServiceUtility serviceUtility = new ServiceUtility();
_rootUri = serviceUtility.BaseUri;
//this context will be used for read only gets...
_context = new MenuSecurityEntities(_rootUri);
_context.MergeOption = MergeOption.NoTracking;
}
public IEnumerable <ExecutableProgram> Refresh(string autoIDs)
{
_repositoryContext = new MenuSecurityEntities(_rootUri);
_repositoryContext.MergeOption = MergeOption.AppendOnly;
_repositoryContext.IgnoreResourceNotFoundException = true;
var queryResult = _repositoryContext.CreateQuery <ExecutableProgram>("RefreshExecutableProgram").AddQueryOption("autoIDs", "'" + autoIDs + "'");
return(queryResult);
}
public IEnumerable <ExecutableProgramType> GetExecutableProgramTypes(string companyID)
{
_repositoryContext = new MenuSecurityEntities(_rootUri);
_repositoryContext.MergeOption = MergeOption.AppendOnly;
_repositoryContext.IgnoreResourceNotFoundException = true;
var queryResult = (from q in _repositoryContext.ExecutableProgramTypes
where q.CompanyID == companyID
select q);
return(queryResult);
}
public IEnumerable <MenuItem> GetMenuItems(string companyID)
{
_repositoryContext = new MenuSecurityEntities(_rootUri);
_repositoryContext.MergeOption = MergeOption.AppendOnly;
_repositoryContext.IgnoreResourceNotFoundException = true;
var queryResult = (from q in _repositoryContext.MenuItems.Expand("MenuSecurities/SecurityGroup")
where q.CompanyID == companyID
select q);
return(queryResult);
}
public IEnumerable <DBStoredImage> GetDBStoredImageByID(string dBImageID, string companyID)
{
_repositoryContext = new MenuSecurityEntities(_rootUri);
_repositoryContext.MergeOption = MergeOption.AppendOnly;
_repositoryContext.IgnoreResourceNotFoundException = true;
var queryResult = (from q in _repositoryContext.DBStoredImages
where q.ImageID == dBImageID &&
q.CompanyID == companyID
select q);
return(queryResult);
}
public IEnumerable <DBStoredImage> GetDBStoredImages(DBStoredImage dBStoredImageQuerryObject, string companyID)
{
_repositoryContext = new MenuSecurityEntities(_rootUri);
_repositoryContext.MergeOption = MergeOption.AppendOnly;
_repositoryContext.IgnoreResourceNotFoundException = true;
var queryResult = from q in _repositoryContext.DBStoredImages
where q.CompanyID == companyID
select q;
if (!string.IsNullOrEmpty(dBStoredImageQuerryObject.Description))
{
queryResult = queryResult.Where(q => q.Description.StartsWith(dBStoredImageQuerryObject.Description.ToString()));
}
return(queryResult);
}
//delete SecurityGroup from the MenuSecurity table...
public void RemoveAllMenuSecurities(string menuItemID, string companyID)
{//declare a different context as to not disturb the repostitory context that is tracking MenuItems
MenuSecurityEntities context = new MenuSecurityEntities(_rootUri);
context.MergeOption = MergeOption.AppendOnly;
context.IgnoreResourceNotFoundException = true;
var deleteItems = from q in context.MenuSecurities
where q.CompanyID == companyID &&
q.MenuItemID == menuItemID
select q;
foreach (MenuSecurity item in deleteItems.ToList())
{
context.DeleteObject(item);
context.SaveChanges();
}
context = null;
}
//delete SecurityGroup from the MenuSecurity table...
public void RemoveMenuSecurity(string menuItemID, string securityGroupID, string companyID)
{//declare a different context as to not disturb the repostitory context that is tracking MenuItems
MenuSecurityEntities context = new MenuSecurityEntities(_rootUri);
context.MergeOption = MergeOption.AppendOnly;
context.IgnoreResourceNotFoundException = true;
var deleteItem = (from q in context.MenuSecurities
where q.CompanyID == companyID &&
q.MenuItemID == menuItemID &&
q.SecurityGroupID == securityGroupID
select q).FirstOrDefault();
if (deleteItem != null)
{
context.DeleteObject(deleteItem);
context.SaveChanges();
}
context = null;
}
