public int Update_TokenKey(TokenKeyModel data)
{
int resp = -1;
try
{
using (MSSql mssql = new MSSql(DBConnectionType.RBAC, _EnvironmentModel))
{
string query = string.Format(@"UPDATE SYS_JWT_TOKEN SET
secret='{1}', issuer='{2}', audience='{3}', expires='{4}', create_date='{5}'
WHERE code='{0}'",
data.code, data.secret, data.issuer, data.audience, data.expire, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
int rest = mssql.ExcuteNonQueryStr(query);
if (rest >= 0)
{
resp = 0;
}
}
}
catch (Exception ex)
{
_ILogs.LogError("Update TokenKey Repository: ", ex.Message.ToString(), ex.StackTrace);
}
return(resp);
}
public ResponseTokenKey Insert_TokenKey(TokenKeyModel data)
{
ResponseTokenKey resp = new ResponseTokenKey();
try
{
var _validate = Validate_MasterTokenKey(data);
if (_validate != null)
{
resp = _validate;
}
else
{
var rest = _ITokenKeyRepository.Insert_TokenKey(data);
resp.status = rest >= 0 ? StatusResponse.Success : StatusResponse.Error;
resp.message = rest >= 0 ? "Insert Successfull." : "Insert Fail.";
}
return(resp);
}
catch (Exception ex)
{
_ILogs.LogError("Token Key Service: ", ex.Message.ToString(), ex.StackTrace);
}
return(null);
}
public ResponseTokenKey Validate_MasterTokenKey(TokenKeyModel data)
{
ResponseTokenKey resp = new ResponseTokenKey();
try
{
if (string.IsNullOrEmpty(data.code))
{
resp.status = StatusResponse.Error;
resp.message = "Code is required.";
return(resp);
}
if (string.IsNullOrEmpty(data.secret))
{
resp.status = StatusResponse.Error;
resp.message = "Secret is required.";
return(resp);
}
if (string.IsNullOrEmpty(data.issuer))
{
resp.status = StatusResponse.Error;
resp.message = "Issuer is required.";
return(resp);
}
if (string.IsNullOrEmpty(data.audience))
{
resp.status = StatusResponse.Error;
resp.message = "Audience is required.";
return(resp);
}
if (data.expire <= 0)
{
resp.status = StatusResponse.Error;
resp.message = "Expire is required more than Zero.";
return(resp);
}
}
catch (Exception ex)
{
_ILogs.LogError("Validate User Group Service: ", ex.Message.ToString(), ex.StackTrace);
}
return(null);
}
public IList <TokenKeyModel> GetListTokenKey()
{
IList <TokenKeyModel> resp = new List <TokenKeyModel>();
try
{
string query = string.Format(
@"SELECT * FROM SYS_JWT_TOKEN
ORDER BY create_date ASC");
using (MSSql mssql = new MSSql(DBConnectionType.RBAC, _EnvironmentModel))
{
var dt = mssql.GetDataTableFromQueryStr(query);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
TokenKeyModel token_model = new TokenKeyModel()
{
code = dr["code"].ToString(),
secret = dr["secret"].ToString(),
issuer = dr["issuer"].ToString(),
audience = dr["audience"].ToString(),
expire = Convert.ToInt32(dr["expires"]),
create_date = Convert.ToDateTime(dr["create_date"]),
};
resp.Add(token_model);
}
return(resp);
}
}
}
catch (Exception ex)
{
_ILogs.LogError("GetList TokenKey Repository: ", ex.Message.ToString(), ex.StackTrace);
}
return(null);
}
public int Delete_TokenKey(TokenKeyModel data)
{
int resp = -1;
try
{
using (MSSql mssql = new MSSql(DBConnectionType.RBAC, _EnvironmentModel))
{
string query = string.Format("DELETE FROM SYS_JWT_TOKEN WHERE code='{0}'", data.code);
int rest = mssql.ExcuteNonQueryStr(query);
if (rest >= 0)
{
resp = 0;
}
}
}
catch (Exception ex)
{
_ILogs.LogError("Delete TokenKey Repository: ", ex.Message.ToString(), ex.StackTrace);
}
return(resp);
}
public ActionResult DeleteTokenKey([FromBody] TokenKeyModel data)
{
ResponseTokenKey resp = _ITokenKeyService.Delete_TokenKey(data);
return(Ok(new { resp }));
}
