public static SubSystemPermission GetUserModulePermissionStatus(int userID, int moduleID)
{
using (var context = new Atiran.Connections.AtiranAccModel.AccModelEntities(Atiran.Connections.AtiranAccModel.ConnectionInfo.BuildConnectionString()))
{
try
{
SubSystemPermission find = context.SubSystemPermissions.FirstOrDefault(a => a.UserID == userID && a.SubSystemID == moduleID);
return(find);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
return(null);
}
}
}
public static List <User> GetUserInformation(int userID)
{
using (var context = new Atiran.Connections.AtiranAccModel.AccModelEntities(Atiran.Connections.AtiranAccModel.ConnectionInfo.BuildConnectionString()))
{
List <User> find = null;
try
{
find = (from read in context.Users where read.UserID == userID select read).ToList();
return(find);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
return(find);
}
}
}
public static bool CheckBackupPermission()
{
using (var context =
new Atiran.Connections.AtiranAccModel.AccModelEntities(Atiran.Connections.AtiranAccModel.ConnectionInfo
.BuildConnectionString()))
{
int userid = Connections.Operaions.UserOp.GetCurrentSysUser.Instance.UserID;
if (context.UserFormPermissions.Where(i => i.UserID == userid && i.FormID == 109).Count() > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public static bool ChangePassword(int userID, string usrname, string password)
{
using (var context = new Atiran.Connections.AtiranAccModel.AccModelEntities(Atiran.Connections.AtiranAccModel.ConnectionInfo.BuildConnectionString()))
{
try
{
User ss = context.Users.Where(i => i.UserID == userID).FirstOrDefault();
{
ss.UserPassWord = System.Text.Encoding.UTF8.GetBytes(password);
}
context.SaveChanges();
return(true);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.InnerException.ToString());
return(false);
}
}
}
public static bool EditUser(int UserID, string userName, string passWord)
{
using (var context = new Atiran.Connections.AtiranAccModel.AccModelEntities(Atiran.Connections.AtiranAccModel.ConnectionInfo.BuildConnectionString()))
{
bool result = false;
try
{
Atiran.Connections.AtiranAccModel.User usr = context.Users.Where(i => i.UserID == UserID).FirstOrDefault();
{
//usr.UserName = userName;
usr.UserPassWord = System.Text.Encoding.UTF8.GetBytes(passWord);
};
context.SaveChanges();
result = true;
return(result);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
return(result);
}
}
}
public static bool InsertIntoUserPersonalization(
List <Atiran.Connections.AtiranAccModel.UserPersonalizationForColor> UserPersonalizationForColor,
List <Atiran.Connections.AtiranAccModel.UserPersonalizationForFont> UserPersonalizationForFont, string ImageAddres, bool Default = false)
{
//Color
var PersonalizationColorID = PersonalizationForColor.Where(w => UserPersonalizationForColor.Any(a =>
a.ControlColorID == w.ControlColorID && a.ControlNameID == w.ControlNameID)).Select(s => s.PersonalizationColorID).ToList();
//Font
List <int> PersonalizationFontID = PersonalizationForFont.Where(w => UserPersonalizationForFont.Any(a => a.ControlNameID == w.ControlNameID)).Select(s => s.PersonalizationFontID).ToList();
using (var ctx = new Atiran.Connections.AtiranAccModel.AccModelEntities(Connections.AtiranAccModel.ConnectionInfo.BuildConnectionString()))
{
ctx.Database.CommandTimeout = 0;
using (var trans = ctx.Database.BeginTransaction())
{
try
{
if (Default)
{
//Color
ctx.UserPersonalizationForColors.RemoveRange(ctx.UserPersonalizationForColors.Where(w => w.UserID == GetCurrentSysUser.Instance.UserID).ToList());
//Font
ctx.UserPersonalizationForFonts.RemoveRange(ctx.UserPersonalizationForFonts.Where(w => w.UserID == GetCurrentSysUser.Instance.UserID).ToList());
GetCurrentSysUser.Instance.BackGroundAddress = "";
Atiran.Connections.AtiranAccModel.User temp = ctx.Users.FirstOrDefault(f =>
f.UserID == GetCurrentSysUser.Instance.UserID);
{
temp.BackGroundAddress = "";
GetCurrentSysUser.Instance.BackGroundAddress = "";
}
}
else
{
//Color
ctx.UserPersonalizationForColors.RemoveRange(ctx.UserPersonalizationForColors.Where(w => PersonalizationColorID.Contains(w.PersonalizationColorID)));
ctx.UserPersonalizationForColors.AddRange(UserPersonalizationForColor);
//Font
ctx.UserPersonalizationForFonts.RemoveRange(ctx.UserPersonalizationForFonts.Where(w => PersonalizationFontID.Contains(w.PersonalizationFontID)).ToList());
ctx.UserPersonalizationForFonts.AddRange(UserPersonalizationForFont);
if (ImageAddres != GetCurrentSysUser.Instance.BackGroundAddress)
{
Atiran.Connections.AtiranAccModel.User temp = ctx.Users.FirstOrDefault(f =>
f.UserID == GetCurrentSysUser.Instance.UserID);
{
temp.BackGroundAddress = ImageAddres;
GetCurrentSysUser.Instance.BackGroundAddress = ImageAddres;
}
}
}
//save
ctx.BulkSaveChanges();
trans.Commit();
Atiran.Connections.Operaions.UserPersonalizationOp.UserPersonalizationOperaion.SetUserPersonalization();
return(true);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.ToString());
trans.Rollback();
return(false);
}
}
}
}
public static void GetFormEnvironmentList(TreeView treeView, int EnvironmentID, int userID, List <long> formNodes, List <long> fieldNodes, List <long> allFormNodes, List <long> allFieldNodes)
{
using (var context = new Atiran.Connections.AtiranAccModel.AccModelEntities(Atiran.Connections.AtiranAccModel.ConnectionInfo.BuildConnectionString()))
{
List <Menu> allMenu = context.Menus.ToList();
List <Field> allField = context.Fields.ToList();
List <User> allSysUsers = context.Users.ToList();
List <UserFieldPermission> allUserFieldPermission = context.UserFieldPermissions.Include("Field").AsNoTracking().Where(m => m.UserID == userID).ToList();
List <UserFormPermission> allUserFormPermission = context.UserFormPermissions.AsNoTracking().Where(a => a.UserID == userID).ToList();
if (EnvironmentID == 1000)
{
}
else
{
treeView.Nodes.Clear();
formNodes.Clear(); fieldNodes.Clear(); allFieldNodes.Clear(); allFormNodes.Clear();
TreeNode MainNode = new TreeNode("انتخاب همه")
{
ForeColor = System.Drawing.Color.Blue
};
MainNode.Expand();
MainNode.Tag = "select";
List <Menu> parentformlist = ((from m in context.Menus.Include("Form").Include("Form.Fields").Include("Form.UserFormPermissions").AsNoTracking() where m.ParentMenuID == 0 && m.SubSystemID == EnvironmentID select m).OrderBy(i => i.order).ToList());
foreach (Menu item in parentformlist)
{
MainNode.Nodes.Add(item.Titel.ToString());
if (SetCheckParent(item.MenuID, EnvironmentID, userID, allMenu, allUserFormPermission))
{
MainNode.LastNode.Checked = true;
}
else if (SetCheckParent(item.MenuID, EnvironmentID, userID, allMenu, allUserFormPermission, false))
{
MainNode.LastNode.ForeColor = System.Drawing.Color.Chocolate;
}
if (allMenu.Where(i => i.MenuID == item.MenuID).FirstOrDefault().FormID == null)
{
MainNode.LastNode.Tag = "MI" + item.MenuID;
}
else
{
MainNode.LastNode.Tag = "FI" + item.FormID;
allFormNodes.Add(item.FormID.Value);
if (allUserFormPermission.Where(i => i.UserID == userID && i.FormID == item.FormID).Count() > 0)
{
MainNode.LastNode.Checked = true;
formNodes.Add(item.FormID.Value);
if (CheckForUserFieldPermissions(allField, allUserFieldPermission, item))
{
MainNode.LastNode.ForeColor = System.Drawing.Color.Chocolate;;
}
}
else
{
MainNode.LastNode.Checked = false;
}
}
SubNodes(MainNode, int.Parse(item.MenuID.ToString()), formNodes, fieldNodes, allFormNodes, allFieldNodes, userID, allMenu, allField, allUserFieldPermission, allSysUsers, allUserFormPermission);
}
treeView.Nodes.Add(MainNode);
}
}
}
