public static Atiran.Connections.AtiranAccModel.Form GetNameSpaceForm(int formID)
{
using (var context = new Connections.AtiranAccModel.AccModelEntities(Connections.AtiranAccModel.ConnectionInfo.BuildConnectionString()))
{
return(context.Forms.Find(formID));
}
}
public static List <Atiran.Connections.AtiranAccModel.Menu> GetMenus(string text)
{
using (var ctx = new Connections.AtiranAccModel.AccModelEntities(Connections.AtiranAccModel.ConnectionInfo.BuildConnectionString()))
{
return(ctx.Menus.Where(m => m.Titel.Contains(text) & m.FormID > 0 & m.SubSystemID != null).OrderBy(m => m.SubSystemID).ToList());
}
}
public static System.Collections.Generic.List <Connections.AtiranAccModel.User> SysList()
{
using (var context = new Connections.AtiranAccModel.AccModelEntities(Connections.AtiranAccModel.ConnectionInfo.BuildConnectionString()))
{
return(context.Users.ToList());
}
}
public static void SetCurrentUserByFiscalUserName(string userName)
{
using (var context = new Connections.AtiranAccModel.AccModelEntities(Connections.AtiranAccModel.ConnectionInfo.BuildConnectionString()))
{
Instance = (from us in context.Users where us.UserName.Equals(userName) select us).FirstOrDefault();
}
}
private static Connections.AtiranAccModel.User setCurrentDefaultUser()
{
using (var context = new Connections.AtiranAccModel.AccModelEntities(Connections.AtiranAccModel.ConnectionInfo.BuildConnectionString()))
{
return(Instance = (from us in context.Users where us.UserName.Equals(Connections.AtiranAccModel.ConnectionInfo.User) select us).FirstOrDefault());
}
}
public static void UserLogined(int userID)
{
using (var context = new Connections.AtiranAccModel.AccModelEntities(Connections.AtiranAccModel.ConnectionInfo.BuildConnectionString()))
{
User instance = context.Users.First(i => i.UserID == userID);
context.SaveChanges();
}
}
public static void SetUserPersonalization()
{
using (var ctx = new Connections.AtiranAccModel.AccModelEntities(ConnectionInfo.BuildConnectionString()))
{
PersonalizationForColor = ctx.UserPersonalizationForColors.AsNoTracking()
.Where(w => w.UserID == GetCurrentSysUser.Instance.UserID).ToList();
PersonalizationForFont = ctx.UserPersonalizationForFonts.AsNoTracking()
.Where(w => w.UserID == GetCurrentSysUser.Instance.UserID).ToList();
}
}
public static bool AccessUserForm(List <int> FormIDs)
{
using (var context = new Connections.AtiranAccModel.AccModelEntities(Connections.AtiranAccModel.ConnectionInfo.BuildConnectionString()))
{
if (context.UserFormPermissions.Where(i => i.UserID == GetCurrentSysUser.Instance.UserID && FormIDs.Contains(i.FormID)).Count() > 0)
{
return(true);
}
return(false);
}
}
public static bool AccessUserForm(int FormID)
{
using (var context = new Connections.AtiranAccModel.AccModelEntities(ConnectionInfo.BuildConnectionString()))
{
UserFormPermission instance = context.UserFormPermissions.Where(i => i.UserID == GetCurrentSysUser.Instance.UserID && i.FormID == FormID).FirstOrDefault();
if (instance != null && context.Menus.Any(a => a.FormID == FormID && a.SubSystemID != null))
{
return(true);
}
return(false);
}
}
public static bool CheckPardakht()
{
using (var context = new Connections.AtiranAccModel.AccModelEntities(Connections.AtiranAccModel.ConnectionInfo.BuildConnectionString()))
{
if (context.UserFieldPermissions.Count() > 0)
{
if (context.UserFieldPermissions.AsNoTracking().Where(i => i.UserID == GetCurrentSysUser.Instance.UserID & i.Field.FormID == 301).Count() > 0)
{
return(true);
}
return(false);
}
return(false);
}
}
private static void SetSubsystem(bool IsTabBar)
{
using (var ctx = new Connections.AtiranAccModel.AccModelEntities(ConnectionInfo.BuildConnectionString()))
{
if (!IsTabBar)
{
_allSubSystem = ctx.SubSystems.ToList();
}
else
{
GetHideMenu();
_resultAllSubSystemTabBar = ctx.SubSystems.Where(m => (!HideMenu.Contains(m.SubSystemId))).ToList();
}
}
}
public static bool HaveRoleID(int userid)
{
using (var context = new Connections.AtiranAccModel.AccModelEntities(ConnectionInfo.BuildConnectionString()))
{
int roleid = context.Users.Where(i => i.UserID == userid).Select(i => i.UserID).FirstOrDefault();
if (roleid != 1)
{
return(false);
}
else
{
return(true);
}
}
}
public static List <ShortcutKey> ReturnAllShortcutKeys()
{
using (var context = new Connections.AtiranAccModel.AccModelEntities(Connections.AtiranAccModel.ConnectionInfo.BuildConnectionString()))
{
var AllList = context.ShortcutKeys.AsNoTracking().ToList();
var resultList = AllList.Where(w => w.MainForm.ToLower() == "main").OrderBy(o => o.Shurtcut.Length).ToList();
resultList.AddRange(context.ShortcutKeys.AsNoTracking()
.Where(w => w.MainForm.ToLower() != "main")
.OrderBy(o => new { o.MainForm, o.Shurtcut.Length }).ToList());
return(resultList);
}
}
private static void SetMenu(bool IsTabBar)
{
using (var ctx =
new Connections.AtiranAccModel.AccModelEntities(ConnectionInfo.BuildConnectionString()))
{
if (!IsTabBar)
{
_allMenu = ctx.Menus.Include("Form").Include("Form.UserFormPermissions").ToList();
}
else
{
_resultAllMenuTabBar = ctx.Menus.Include("Form").Include("Form.UserFormPermissions").Where(m =>
m.SubSystemID != null ||
m.FormID == null && ctx.Menus.Any(m1 => m1.ParentMenuID == m.MenuID))
.ToList();
}
}
}