public IEnumerable <UserDetailJson> LoadUsers()
{
string jsonDataDir = CommonFileProcs.GetLocalDirectory("JsonData");
string jsonData = CommonFileProcs.GetAllRecords(jsonDataDir, "UserAccountInitList.json");
List <UserDetailJson> rtn_list = CommonJSONProcs.ProcessJSONClass <UserDetailJson>(jsonData);
using (var db_con = new SqlExpIdentity())
{
var users = db_con.Users.ToList();
foreach (UserDetailJson json_user in rtn_list)
{
AspNetUser ident_user = new AspNetUser(json_user);
db_con.Users.Add(ident_user);
}
try
{
int row_cnt = db_con.SaveChanges();
}
catch
{
var errors = db_con.GetValidationErrors();
var errorList = CommonErrorProcs.ExtractValidationErrors(db_con);
//return errorList;
}
}
return(rtn_list);
}
public static List <AppUser> GetUsers(AppRoleView model)
{
List <AppUser> rtn_list = new List <AppUser>();
using (var db_context = new SqlExpIdentity())
{
model.appRole = db_context.Roles.Where(w => w.Id == model.appRole.Id).ToList().FirstOrDefault();
var query = from users in db_context.Users select users;
string q1 = query.ToString();
if (!string.IsNullOrEmpty(model.FirstName))
{
query = query.Where(w => w.FirstName.StartsWith(model.FirstName));
}
string q2 = query.ToString();
if (!string.IsNullOrEmpty(model.LastName))
{
query = query.Where(w => w.LastName.StartsWith(model.LastName));
}
string q3 = query.ToString();
rtn_list = query.ToList();
}
return(rtn_list);
}
public static AppSystem Update(AppSystem appSystem)
{
using (var dbContext = new SqlExpIdentity())
{
try
{
AppSystem tmpSystem = dbContext.appSystems.Where(w => w.Id == appSystem.Id).FirstOrDefault();
if (tmpSystem == null)
{
tmpSystem = new AppBuilder().AppName(appSystem.Name).AppDesc(appSystem.Desc).Build();
tmpSystem = Create(tmpSystem);
}
else
{
tmpSystem.Name = appSystem.Name != appSystem.Name ? tmpSystem.Name : appSystem.Name;
tmpSystem.Desc = appSystem.Desc != appSystem.Desc ? tmpSystem.Desc : appSystem.Desc;
tmpSystem.UpdateDate = DateTime.Now;
int updCount = dbContext.SaveChanges();
}
return(tmpSystem);
}
catch (Exception ex)
{
throw ex;
}
}
}
public static AppSystem GetAppByName(string appName)
{
using (var dbContext = new SqlExpIdentity())
{
try
{ return(dbContext.appSystems.Where(w => w.Name == appName).FirstOrDefault()); }
catch (Exception ex)
{ throw ex; }
}
}
public static AppSystem GetAppById(int appId)
{
using (var dbContext = new SqlExpIdentity())
{
try
{ return(dbContext.appSystems.Where(w => w.AppId == appId).FirstOrDefault()); }
catch (Exception ex)
{ throw ex; }
}
}
public static List <AppSystem> GetAppsAll()
{
using (var dbContext = new SqlExpIdentity())
{
try
{ return(dbContext.appSystems.ToList()); }
catch (Exception ex)
{ throw ex; }
}
}
//===============================================================================
private static List <AppUser> GetUsersByRole(AppRole appRole)
{
List <AppUser> rtn_list = new List <AppUser>();
using (var db_context = new SqlExpIdentity())
{
var users1 = appRole.Users.Select(s => s.UserId).ToList();
rtn_list = db_context.Users.Where(w => users1.Contains(w.Id)).ToList();
}
return(rtn_list);
}
public static AppSystem GetAppByGuid(string appId)
{
using (var dbContext = new SqlExpIdentity())
{
try
{
AppSystem appSystem = dbContext.appSystems.Where(w => w.Id == appId).FirstOrDefault();
if (appSystem != null)
{
appSystem.AppRoles.ToList();
}
return(appSystem);
}
catch (Exception ex)
{ throw ex; }
}
}
public static AppSystem Create(AppSystem appSystem)
{
using (var dbContext = new SqlExpIdentity())
{
try
{
appSystem.CreateDate = DateTime.Now;
appSystem.UpdateDate = DateTime.Now;
dbContext.appSystems.Add(appSystem);
dbContext.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
return(appSystem);
}
public static AppSystem Delete(AppSystem appSystem)
{
using (var dbContext = new SqlExpIdentity())
{
try
{
AppSystem tmpSystem = dbContext.appSystems.Where(w => w.Id == appSystem.Id).FirstOrDefault();
if (tmpSystem != null)
{
dbContext.appSystems.Remove(tmpSystem);
dbContext.SaveChanges();
}
return(tmpSystem);
}
catch (Exception ex)
{
throw ex;
}
}
}
public static AppRole AddRole(string appName, AppRole appRole)
{
using (var dbContext = new SqlExpIdentity())
{
try
{
AppSystem appSystem = dbContext.appSystems.Where(w => w.Name == appName).FirstOrDefault();
if (appSystem == null)
{
throw new ArgumentNullException("AppName");
}
appSystem.AppRoles.Add(appRole);
dbContext.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
return(appRole);
}
