public static bool SaveRec(Guid userSid, int userType, String loginName, String loginPassword, String alias)
{
bool result = false;
using (var ctx = new EF6.RT2020Entities())
{
try
{
var user = ctx.UserProfile.Where(x => x.UserSid == userSid).FirstOrDefault();
if (user == null)
{
user = new EF6.UserProfile();
user.UserId = Guid.NewGuid();
user.UserSid = userSid;
ctx.UserProfile.Add(user);
}
user.UserType = userType;
user.LoginName = loginName;
user.LoginPassword = loginPassword;
user.Alias = alias;
ctx.SaveChanges();
result = true;
}
catch { }
}
return(result);
}
public static EF6.UserProfile GetLoginUser(string name, string password)
{
EF6.UserProfile result = null;
using (var ctx = new EF6.RT2020Entities())
{
var item = ctx.UserProfile.Where(x => x.LoginName == name && x.LoginPassword == password).AsNoTracking().FirstOrDefault();
result = item;
}
return(result);
}
public static EF6.UserProfile GetByUserSid(Guid sid)
{
EF6.UserProfile result = null;
using (var ctx = new EF6.RT2020Entities())
{
var item = ctx.UserProfile.Where(x => x.UserSid == sid).AsNoTracking().FirstOrDefault();
result = item;
}
return(result);
}
private EF6.UserProfile CheckUser(string username, string password)
{
EF6.UserProfile result = null;
using (var ctx = new EF6.RT2020Entities())
{
var user = ctx.UserProfile.FirstOrDefault(x => (x.LoginName == username) && (x.LoginPassword == password) && (x.Status >= 1));
if (user != null)
{
result = user;
}
}
return(result);
}
