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 IEnumerable <CountryCode> GetCountries()
{
string jsonDataDir = CommonFileProcs.GetLocalDirectory("JsonData");
string jsonData = CommonFileProcs.GetAllRecords(jsonDataDir, "Countries.json");
return(CommonJSONProcs.ProcessJSONClass <CountryCode>(jsonData));
}
public IHttpActionResult GetUsersJSON()
{
string jsonDataDir = CommonFileProcs.GetLocalDirectory("JsonData");
string jsonData = CommonFileProcs.GetAllRecords(jsonDataDir, "UserAccountInitList.json");
List <UserDetailJson> rtn_list = CommonJSONProcs.ProcessJSONClass <UserDetailJson>(jsonData);
return(Ok(new { results = rtn_list }));
}
public IEnumerable <UserDetailJson> GetUsers()
{
string jsonDataDir = CommonFileProcs.GetLocalDirectory("JsonData");
string jsonData = CommonFileProcs.GetAllRecords(jsonDataDir, "UserAccountInitList.json");
List <UserDetailJson> rtn_list = CommonJSONProcs.ProcessJSONClass <UserDetailJson>(jsonData);
return(rtn_list);
}
public IEnumerable <CountryCode> GetCountries(string abbr)
{
string jsonDataDir = CommonFileProcs.GetLocalDirectory("JsonData");
string jsonData = CommonFileProcs.GetAllRecords(jsonDataDir, "Countries.json");
List <CountryCode> rtn_list = CommonJSONProcs.ProcessJSONClass <CountryCode>(jsonData);
return(rtn_list.Where(w => w.CountryAbbr == abbr));
}
public IEnumerable <StateCode> GetStates()
{
string jsonDataDir = CommonFileProcs.GetLocalDirectory("JsonData");
string jsonData = CommonFileProcs.GetAllRecords(jsonDataDir, "States.json");
List <StateCode> rtn_list = CommonJSONProcs.ProcessJSONClass <StateCode>(jsonData);
return(rtn_list);
//using (var db_con = new SqlLclContext())
//{
// List<StateCode> rtn_obj = db_con.StateCodes.ToList();
// return rtn_obj;
//}
}
public IEnumerable <StateCode> LoadStates(string source, bool truncate)
{
string jsonDataDir = CommonFileProcs.GetLocalDirectory("JsonData");
string jsonData = CommonFileProcs.GetAllRecords(jsonDataDir, "States.json");
List <StateCode> rtn_list = CommonJSONProcs.ProcessJSONClass <StateCode>(jsonData);
using (var db_con = new SqlLclContext())
{
if (truncate)
{
DBFunctions.Truncate <StateCode>(db_con);
}
db_con.StateCodes.AddRange(rtn_list);
db_con.SaveChanges();
return(db_con.StateCodes.ToList());
}
}
public IHttpActionResult Get([FromBody] JToken jToken)
{
var parms = jToken.ToObject <GetParms>();
switch (parms.function)
{
case "LoadCountries":
return(Ok(new { results = "Success" }));
case "GetUsers":
string jsonDataDir = CommonFileProcs.GetLocalDirectory("JsonData");
string jsonData = CommonFileProcs.GetAllRecords(jsonDataDir, "UserAccountInitList.json");
List <UserDetailJson> rtn_list = CommonJSONProcs.ProcessJSONClass <UserDetailJson>(jsonData);
return(Ok(new { results = rtn_list }));
default:
return(BadRequest("Unknown function"));
}
}
