public override async Task <AuthenticationState> GetAuthenticationStateAsync() // automatically called when site is loaded, we can restore session here
{
var token = await _localStorageService.GetItemAsync <string>("token");
var xtra = await _localStorageService.GetItemAsync <string>("xtra");
ClaimsIdentity identity = new ClaimsIdentity();;
if (!string.IsNullOrEmpty(token))
{
try
{
List <UserModel> users = DBExecuter.SQLRequestSPAutoFillParams("sp_VerifyUserByToken", new ParamList {
["token"] = token, ["extrainfo"] = xtra
}).Map <UserModel>(); //token auth
if (users.Count == 1)
{
identity = GetClaimsIdentity(users.FirstOrDefault());
}
} catch (Exception e)
{
Console.WriteLine(e.GetBaseException().Message);
}
}
var claimsPrincipal = new ClaimsPrincipal(identity);
return(await Task.FromResult(new AuthenticationState(claimsPrincipal)));
}
public static List <object> Select(this Entity item)
{
DataTable table = new DBExecuter().GetData(SqlGenerator.BuildSelectCommand(item));
if (table.Rows.Count == 0)
{
return(null);
}
return(table.ToObjectCollection(item));
}
public List <T> Select(T item)
{
DataTable table = new DBExecuter().GetData(SqlGenerator <T> .BuildSelectCommand(item));
if (table.Rows.Count == 0)
{
return(null);
}
return(table.ToObjectCollection <T>());
}
public List <Setor> GetALL()
{
SqlCommand command = new SqlCommand();
command.CommandText = "SELECT * FROM Usuario";
DataTable table = new DBExecuter().GetData(command);
if (table.Rows.Count == 0)
{
return(null);
}
return(table.ToObjectCollection <Setor>());
}
public List <Usuario> GetALL(SqlCommand Where)
{
SqlCommand command = new SqlCommand();
command.CommandText = "SELECT * FROM Usuario ";
command.CommandText += Where.CommandText;
foreach (SqlParameter item in Where.Parameters)
{
command.Parameters.Add(new SqlParameter(item.ParameterName, item.Value));
}
DataTable table = new DBExecuter().GetData(command);
if (table.Rows.Count == 0)
{
return(null);
}
return(table.ToObjectCollection <Usuario>());
}
public override Task <InsertResponse> Insert(SetRequest request, ServerCallContext context)
{
string error = "";
int idVal = -1;
try
{
query q = QueryGenerator.Insert(request.Assembly, request.SystemType, request.JSON, request.TPHType);
idVal = (int)DBExecuter.execScalar <int>(q.sql, q.paramList);
}
catch (Exception e)
{
error = e.GetBaseException().Message;
}
return(Task.FromResult(new InsertResponse
{
Error = new basicResponse {
ErrorResponse = error
},
InsertedID = idVal
}));
}
public override Task <DeleteUpdateResponse> Update(SetRequest request, ServerCallContext context)
{
string error = "";
int rows = -1;
try
{
query q = QueryGenerator.Update(request.Assembly, request.SystemType, request.JSON, request.TPHType);
rows = DBExecuter.execNonQuery(q.sql, q.paramList);
}
catch (Exception e)
{
error = e.GetBaseException().Message;
}
return(Task.FromResult(
new DeleteUpdateResponse
{
Error = new basicResponse {
ErrorResponse = error
},
RowsAffected = rows
}));;
}