public static int InserToUser(string userName, string passWord)
{
using (var context = new Atiran.Connections.AtiranAccModel.AccModelEntities(Atiran.Connections.AtiranAccModel.ConnectionInfo.BuildConnectionString()))
{
int result = 0;
try
{
Atiran.Connections.AtiranAccModel.User usr = new Atiran.Connections.AtiranAccModel.User()
{
UserName = userName,
UserPassWord = System.Text.Encoding.UTF8.GetBytes(passWord),
Active = true
};
context.Users.Add(usr);
context.SaveChanges();
context.AddUser(usr.UserID, Connections.AtiranAccModel.ConnectionInfo.DatabaseName.ToString());
result = usr.UserID;
return(result);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
return(result);
}
}
}
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);
}
}
}
}