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 })); }