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));
}
}
