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(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); } }
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); } } }
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(); } } }
public static string ServerTime() { SqlConnection conn = new SqlConnection { ConnectionString = ConnectionInfo.BuildConnectionString() }; conn.Open(); SqlCommand c1 = new SqlCommand { Connection = conn, CommandText = $"SELECT cast(CONVERT (time, GETDATE()) as nvarchar(8))" }; object Result = c1.ExecuteScalar(); conn.Close(); return(Result.ToString()); }
public static string ReturnDateServerMiladi() { SqlConnection conn = new SqlConnection { ConnectionString = ConnectionInfo.BuildConnectionString() }; conn.Open(); SqlCommand c1 = new SqlCommand { Connection = conn, CommandText = "select cast(cast(GETDATE() as date) as nvarchar(400))", }; object Result = c1.ExecuteScalar(); conn.Close(); return(Result.ToString()); }
public static string ServerDateAndTime() { SqlConnection conn = new SqlConnection { ConnectionString = ConnectionInfo.BuildConnectionString() }; conn.Open(); SqlCommand c1 = new SqlCommand { Connection = conn, CommandText = $"SELECT GETDATE()" }; object Result = c1.ExecuteScalar(); conn.Close(); return(Result.ToString()); }
public static string ReturnDateServer(string Diff) { string ServerTime = DateServer.ServerTime(); SqlConnection conn = new SqlConnection { ConnectionString = ConnectionInfo.BuildConnectionString() }; conn.Open(); SqlCommand c1 = new SqlCommand { Connection = conn, CommandText = ServerTime.CompareTo("12:00:00.0") > 0 ? $"select dbo.[UDF_Gregorian_To_Persian](GETDATE()-{Diff}-1)" : $"select dbo.[UDF_Gregorian_To_Persian](GETDATE()-{Diff})" }; object Result = c1.ExecuteScalar(); conn.Close(); return(Result.ToString()); }
/// <summary> /// Check if username / password matches or not /// </summary> /// <param name="username">username</param> /// <param name="password">password</param> /// <returns>True if username / password matches, otherwise false</returns> public bool UsernamePasswordMatches(string username, string password) { using (var context = new Atiran.Connections.AtiranAccModel.AccModelEntities(ConnectionInfo.BuildConnectionString())) { byte[] bytePassword = Encoding.UTF8.GetBytes(password); Connections.AtiranAccModel.User user = context.Users.Where(u => u.UserName.Equals(username) && u.UserPassWord.Equals(bytePassword)).FirstOrDefault(); if (user != null) { return(true); } return(false); } }
/// <summary> /// Check if this username exists or not /// </summary> /// <param name="username">username</param> /// <returns>True if username exists, otherwise false</returns> public bool UserExists(string username) { using (var context = new Atiran.Connections.AtiranAccModel.AccModelEntities(ConnectionInfo.BuildConnectionString())) { return(context.Users.Any(a => a.UserName == username)); } }
public static bool CheckPasswordForDeleteAllInfo(string password) { using (var context = new Atiran.Connections.AtiranAccModel.AccModelEntities(ConnectionInfo.BuildConnectionString())) { byte[] bytePassword = Encoding.UTF8.GetBytes(password); return(context.Users.Any(i => i.UserName.Equals(Connections.Operaions.UserOp.GetCurrentSysUser.Instance.UserName) & i.UserPassWord.Equals(bytePassword))); } }
public static Atiran.Connections.AtiranAccModel.User GetUserByID(int UserID) { using (var context = new Atiran.Connections.AtiranAccModel.AccModelEntities(ConnectionInfo.BuildConnectionString())) { return(context.Users.AsNoTracking().Single(a => a.UserID == UserID)); } }