public IEnumerable <User> GetUserList(FlowNode node, FlowData flowData = null, User currentUser = null)
{
var parameter = new UserParameter
{
UserIds = node?.UserIds,
TitleIds = node?.JobTitleIds,
};
if (node != null)
{
if (node.LimitMode == DepartmentLimitMode.Assign)
{
parameter.DepartmentIds = node.DepartmentIds;
}
else if (node.LimitMode == DepartmentLimitMode.Poster)
{
if (flowData != null)
{
var firstNodeData = flowData.GetFirstNodeData();
var user = Core.UserManager.GetModel(firstNodeData.UserId);
parameter.DepartmentIds = user.DepartmentIds;
}
else if (currentUser != null)
{
parameter.DepartmentIds = currentUser.DepartmentIds;
}
}
else if (node.LimitMode == DepartmentLimitMode.Self)
{
parameter.DepartmentIds = currentUser.DepartmentIds;
}
}
return(Core.UserManager.GetList(parameter));
}
public static ParameterEntity FindByParameterName(string name)
{
Parameter parameter = ParameterRepository.FindByName(name);
UserParameter userParameter = UserParameterRepository.FindByParameterId(parameter.Id);
return(new ParameterEntity(parameter, userParameter));
}
public async Task <IActionResult> RunAsync(
[HttpTrigger(AuthorizationLevel.Function, "get", Route = "user/{userUuid}")] HttpRequest req,
string userUuid)
{
Logger.LogInformation("C# HTTP trigger function processed a request.");
var user = new UserParameter()
{
UserUuid = userUuid
};
// validation
var validationResult = await Validation.ValidateAsync(req, user);
if (!validationResult.IsValid)
{
AddBadRequest(req);
return(validationResult.ErrorActionResult);
}
var userResult = new UserResultModel();
userResult.LastNotificationTime = Notification.LastNotificationTime;
return(new OkObjectResult(userResult));
}
public UpdateRelationRequest([NotNull] IApiAccessor accessor,
[NotNull] UserParameter target, Relationships relation)
{
Accessor = accessor ?? throw new ArgumentNullException(nameof(accessor));
Target = target ?? throw new ArgumentNullException(nameof(target));
Relation = relation;
}
public ActionResult Update(UserParameter parameters)
{
var viewModel = MapFromClientParameters(parameters);
byte[] lastModified = null;
var logoFilePath = "";
if (ModelState.IsValid)
{
var sharViewModel = viewModel.SharedViewModel as DashboardUserShareViewModel;
var entity = MasterFileService.GetById(viewModel.SharedViewModel.Id);
var mappedEntity = viewModel.MapPropertiesToInstance(entity);
if (sharViewModel != null)
{
if (!String.IsNullOrEmpty(sharViewModel.Avatar))
{
if (!sharViewModel.Avatar.Contains("data:image/jpg;base64"))
{
logoFilePath = Server.MapPath(sharViewModel.Avatar);
mappedEntity.Avatar = _resizeImage.ResizeImageByHeightAndWidth(logoFilePath, 450, 450);
}
}
}
lastModified = MasterFileService.Update(mappedEntity).LastModified;
}
return(Json(new { Error = string.Empty, Data = new { LastModified = lastModified } }, JsonRequestBehavior.AllowGet));
}
public QueryResult <User> Execute(UserParameter parameters)
{
try
{
var result = new User
{
Id = 1,
Name = "Devansh N Padade",
Message = parameters.Id.ToString()
};
return(new QueryResult <User>()
{
Data = result != null ? result : new User(),
IsExecuted = true,
Message = "Query Executed Successfully",
Status = CommandQueryStatus.Executed
});
}
catch (System.Exception ex)
{
return(new QueryResult <User>()
{
Data = new User(),
IsExecuted = true,
Message = "Query Executed Successfully",
ErrorMessage = ex.ToString(),
Status = CommandQueryStatus.Executed
});
}
}
public static int PermsUpdate(UserParameter param)
{
using (var db = new MsSql(DbName.Official)) {
return
(Convert.ToInt32(
db.Value(
CommandType.StoredProcedure,
"[dbo].[sp_UserFunctionsAndOperations_Upd]",
new DbParameter[] {
new SqlParameter {
Value = param.User.IdentityKey,
SqlDbType = SqlDbType.BigInt,
ParameterName = "@argIntUserId",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.User.Functions,
SqlDbType = SqlDbType.VarChar,
Size = -1,
ParameterName = "@argStrFunctions",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.User.Operations,
SqlDbType = SqlDbType.VarChar,
Size = -1,
ParameterName = "@argStrOperations",
Direction = ParameterDirection.Input
}
})));
}
}
public SendMessageRequest([NotNull] IApiAccessor accessor, [NotNull] UserParameter recipient,
[NotNull] string text)
{
Accessor = accessor ?? throw new ArgumentNullException(nameof(accessor));
Recipient = recipient ?? throw new ArgumentNullException(nameof(recipient));
Text = text ?? throw new ArgumentNullException(nameof(text));
}
public bool Login(UserParameter param)
{
//取得帳號資料
var userDetail = User.FetchAdminUserDetail(param.User.Account);
if (userDetail.Status == 2)
{
return(false);
}
var encryptPassword = Md5.Encrypt(param.User.Password);
//檢查使用者的密碼
if (string.IsNullOrEmpty(userDetail.EncryptPassword) || !userDetail.EncryptPassword.Equals(encryptPassword))
{
return(false);
}
//如果是最高管理者需要再驗證IP
if (userDetail.IsAdministrator)
{
if (!VerifyConnectSourceIp(param.RemoteIp))
{
return(false);
}
}
var principal = new ManagerPrincipal(userDetail.Account);
//HttpContext.Current.User = principal;
//Identity = HttpContext.Current.User.Identity as ManagerIdentity;
//註冊Cookies
//AddCookie(userDetail);
AddCookie(principal);
CacheProvider.Insert(userDetail.Account, principal);
return(true);
}
public ActionResult AjaxLogin(UserParameter param)
{
JsonNetResult result = new JsonNetResult();
var r = new DetailResponse();
try
{
if (Request.ServerVariables["HTTP_VIA"] != null)
{
// 穿過代理服務器取遠程用戶真實IP地址
param.RemoteIp = Request.ServerVariables["HTTP_X_FORWARDED_FOR"].ToString();
}
else
{
param.RemoteIp = Request.ServerVariables["REMOTE_ADDR"].ToString();
}
r.Ok = new AuthenticatorProvider().Login(param);
}
catch (Exception ex)
{
Log.Error(ex.Message, ex);
r.Code = "-11";
}
result.Data = r;
return(result);
}
public static ParameterEntity FindByUserParamaterId(int id)
{
UserParameter userParameter = UserParameterRepository.FindById(id);
Parameter parameter = ParameterRepository.FindById(userParameter.Id);
return(new ParameterEntity(parameter, userParameter));
}
/// <summary>
/// 用户登录验证
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public async Task <IActionResult> Authenticate(UserParameter user)
{
ReturnResult result = new ReturnResult();
UserResult customer = await userManager.GetUserByExactNameAsync(user.Name);
if (customer == null || customer.Password != CommonUtil.MD5(user.Password))
{
result.IsSuccess = false;
result.Message = "用户名或密码错误！";
return(Json(result));
}
//非管理员无法登录
if (customer.Type != EUserType.Admin)
{
result.IsSuccess = false;
result.Message = "您不是管理员！";
return(Json(result));
}
//禁用管理员无法登录
if (customer.Status == EUserStatus.Disabled)
{
result.IsSuccess = false;
result.Message = "您管理员身份已被禁用！";
return(Json(result));
}
await AddClaim(customer.Id, customer.Name, customer.Type);
return(Json(result));
}
private QvDataContractResponse GetDatabases(UserParameter parameter)
{
var databaseList = new List <QlikView.Qvx.QvxLibrary.Database>();
try
{
var config = QlikApp.CreateConfig(parameter);
var qlikApp = new QlikApp(parameter);
var apps = qlikApp.GetAllApps(config);
var appNames = apps.Select(s => s.qDocName).ToList();
foreach (var app in appNames)
{
databaseList.Add(new QlikView.Qvx.QvxLibrary.Database()
{
qName = app
});
}
return(new QvDataContractDatabaseListResponse {
qDatabases = databaseList.ToArray()
});
}
catch (Exception ex)
{
logger.Error(ex, $"databases not loaded.");
return(new QvDataContractDatabaseListResponse {
qDatabases = databaseList.ToArray()
});
}
}
public async Task <IActionResult> Run(
[HttpTrigger(AuthorizationLevel.Function, "get", Route = "user/{userUuid}/{major}/{minor}")] HttpRequest req,
string userUuid,
string major,
string minor)
{
Logger.LogInformation("C# HTTP trigger function processed a request.");
var user = new UserParameter()
{
UserUuid = userUuid, Major = major, Minor = minor
};
// validation
var validationResult = await Validation.ValidateAsync(req, user);
if (!validationResult.IsValid)
{
AddBadRequest(req);
return(validationResult.ErrorActionResult);
}
// query
return(await Query(req, user));
}
private QvDataContractResponse GetPreview(UserParameter parameter, string appId, string objectId)
{
q2gconhypercubemain.Connection connection = null;
try
{
var oId = GetObjectId(objectId);
if (String.IsNullOrEmpty(oId))
{
throw new Exception("no object id for preview table found.");
}
var config = QlikApp.CreateConfig(parameter, appId);
var qlikApp = new QlikApp(parameter);
connection = qlikApp.CreateNewConnection(config);
var script = ScriptCode.Create(appId, oId);
var resultTable = tableFunctions.GetTableInfosFromApp("PreviewTable", script, connection.CurrentApp);
if (resultTable == null)
{
throw new Exception("no preview table found.");
}
return(PreviewResponse.Create(resultTable.Preview));
}
catch (Exception ex)
{
logger.Error(ex, $"fields from app {appId} and table {objectId} not loaded.");
return(new PreviewResponse());
}
finally
{
connection?.Close();
}
}
public static async Task <IApiResult <IEnumerable <TwitterStatus> > > GetUserTimelineAsync(
[NotNull] this IApiAccessor accessor,
[NotNull] UserParameter targetUser, int?count, long?sinceId, long?maxId,
bool?excludeReplies, bool?includeRetweets, CancellationToken cancellationToken)
{
if (accessor == null)
{
throw new ArgumentNullException(nameof(accessor));
}
if (targetUser == null)
{
throw new ArgumentNullException(nameof(targetUser));
}
var param = new Dictionary <string, object>
{
{ "since_id", sinceId },
{ "max_id", maxId },
{ "count", count },
{ "exclude_replies", excludeReplies },
{ "include_rts", includeRetweets },
}.ApplyParameter(targetUser).SetExtended();
return(await accessor.GetAsync("statuses/user_timeline.json", param,
ResultHandlers.ReadAsStatusCollectionAsync, cancellationToken)
.ConfigureAwait(false));
}
private async Task <IActionResult> Query(HttpRequest req, UserParameter user)
{
try
{
var itemResult = await Cosmos.User.ReadItemAsync <UserResultModel>(user.GetId(), PartitionKey.None);
if (itemResult.StatusCode == System.Net.HttpStatusCode.OK)
{
itemResult.Resource.LastNotificationTime = Notification.LastNotificationTime;
return(new OkObjectResult(itemResult.Resource));
}
}
catch (CosmosException ex)
{
// 429–TooManyRequests
if (ex.StatusCode == System.Net.HttpStatusCode.TooManyRequests)
{
return(new StatusCodeResult(503));
}
AddBadRequest(req);
return(new StatusCodeResult((int)ex.StatusCode));
}
AddBadRequest(req);
return(new NotFoundResult());
}
public void ChangeParam(Document doc, string paramName, string paramValue)
{
UserParameters userParams;
if (doc.DocumentType == DocumentTypeEnum.kPartDocumentObject)
{
LogTrace("Part Document");
PartComponentDefinition partComponentDef = ((PartDocument)doc).ComponentDefinition;
Parameters docParams = partComponentDef.Parameters;
userParams = docParams.UserParameters;
}
else
{
LogTrace("Unknown Document");
// unsupported doc type, throw exception
throw new Exception("Unsupported document type: " + doc.DocumentType.ToString());
}
using (new HeartBeat())
{
try
{
LogTrace($"Setting {paramName} to {paramValue}");
UserParameter userParam = userParams[paramName];
userParam.Expression = paramValue;
}
catch (Exception e)
{
LogError("Cannot update '{0}' parameter. ({1})", paramName, e.Message);
}
}
}
private async Task <IActionResult> Query(HttpRequest req, UserParameter user)
{
try
{
var userResult = await UserRepository.GetById(user.GetId());
if (userResult != null)
{
userResult.LastNotificationTime = Notification.LastNotificationTime;
//userResult.LastInfectionUpdateTime = Infection.LastUpdateTime;
return(new OkObjectResult(userResult));
}
}
catch (CosmosException ex)
{
// 429–TooManyRequests
if (ex.StatusCode == System.Net.HttpStatusCode.TooManyRequests)
{
return(new StatusCodeResult(503));
}
AddBadRequest(req);
return(new StatusCodeResult((int)ex.StatusCode));
}
AddBadRequest(req);
return(new NotFoundResult());
}
public override QvxDataTable ExtractQuery(string query, List <QvxTable> tables)
{
try
{
logger.Debug($"Parse query {query}");
var script = ScriptCode.Parse(query);
if (script == null)
{
throw new Exception("The sql script is not valid.");
}
var parameter = UserParameter.Create(MParameters);
var resultTable = GetData(script, parameter);
var qvxTable = TableUtilities.ConvertTable(resultTable);
var result = new QvxDataTable(qvxTable);
result.Select(qvxTable.Fields);
logger.Debug($"Send result table {qvxTable.TableName}");
return(result);
}
catch (Exception ex)
{
logger.Error(ex, "The query could not be executed.");
LogManager.Flush();
return(new QvxDataTable(new QvxTable()
{
TableName = "Error"
}));
}
}
public ActionResult AjaxUpdate(UserParameter param)
{
JsonNetResult result = new JsonNetResult();
var r = new DetailResponse();
try
{
string RoleIDs = param.User.RoleIDs;
if (RoleIDs == null || RoleIDs.IndexOf(",") < 0 || RoleIDs.Equals(","))
{
DataAccessProvider.UserRole.Clear(param.User.IdentityKey);
}
else
{
var tmp = new List <string>();
foreach (var RoleID in RoleIDs.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries))
{
tmp.Add($"({param.User.IdentityKey}, {RoleID})");
}
DataAccessProvider.UserRole.Update(param.User.IdentityKey, string.Join(",", tmp.ToArray()));
}
r.Code = DataAccessProvider.User.Update(param).ToString(Section.Get.Common.Culture);
r.Ok = true;
}
catch (Exception ex)
{
Log.Error(ex.Message, ex);
r.Code = "-11";
}
result.Data = r;
return(result);
}
public ActionResult AjaxAction(UserParameter param)
{
JsonNetResult result = new JsonNetResult();
var r = new DetailResponse();
try
{
if (param.ActionIDs == null || param.ActionIDs.Count == 0)
{
r.Code = DataAccessProvider.UserAction.Clear(param.UserID).ToString();
}
else
{
List <string> tmp = new List <string>();
foreach (string ActionID in param.ActionIDs)
{
tmp.Add(string.Format("({0}, {1})", param.UserID, ActionID));
}
r.Code = DataAccessProvider.UserAction.Update(param.UserID, string.Join(",", tmp.ToArray())).ToString();
}
r.Ok = true;
}
catch (Exception ex)
{
Log.Error(ex.Message, ex);
r.Code = "-11";
}
result.Data = r;
return(result);
}
public async Task <IActionResult> RunAsync(
[HttpTrigger(AuthorizationLevel.Function, "delete", Route = "OptOut/{userUuid}")] HttpRequest req,
string userUuid)
{
Logger.LogInformation($"{nameof(OptOutApi)} processed a request.");
var user = new UserParameter()
{
UserUuid = userUuid
};
// validation
var validationResult = await Validation.ValidateAsync(req, user);
if (!validationResult.IsValid)
{
AddBadRequest(req);
return(validationResult.ErrorActionResult);
}
// delete tek
await DiagnosisRepository.Delete(user);
// delete user
await UserRepository.Delete(user);
return(new NoContentResult());
}
/// <summary>
/// 登入
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public static GeneralResponse Login(UserParameter param)
{
return(new GeneralResponse
{
Ok = new AuthenticatorProvider().Login(param)
});
}
/// <summary>
/// 新帳號註冊
/// </summary>
/// <param name="param"></param>
/// <returns>
/// >0: "帳號編號"
/// -1: "資料庫異常,系統錯誤。"
/// -2: "指定的帳號已被註冊。"
/// -11: "帳號欄位必填。"
/// -12: "密碼欄位必填。"
/// -13: "使用者名稱欄位必填。"
/// </returns>
public static GeneralResponse Register(UserParameter param)
{
var r = new GeneralResponse();
if (0.Equals(param.User.Account.Trim(new[] { ' ' }).Length))
{
r.Code = "-11";
return(r);
}
if (0.Equals(param.User.Password.Trim(new[] { ' ' }).Length))
{
r.Code = "-12";
return(r);
}
if (0.Equals(param.User.FirstName.Trim(new[] { ' ' }).Length) ||
0.Equals(param.User.LastName.Trim(new[] { ' ' }).Length))
{
r.Code = "-13";
return(r);
}
try
{
r.Code = DataAccessProvider.User.Insert(param).ToString();
}
catch (Exception ex)
{
r.Code = "-1";
}
return(r);
}
public ActionResult AjaxRegister(UserParameter param)
{
JsonNetResult result = new JsonNetResult();
var r = UserModel.Register(param);
result.Data = r;
return(result);
}
/// <summary>
/// 创建
/// </summary>
/// <param name="parameter">参数</param>
public async Task <User> CreateAsync(UserParameter parameter)
{
if (await UserRepository.ExistsAsync(x => x.UserName == parameter.UserName))
{
throw new Warning("账户已存在");
}
return(await CreateUserAndAdministratorAsync(parameter));
}
public void PropertiesTest()
{
// preparation
var model = new UserParameter();
// model property access
Helper.ModelTestHelper.PropetiesTest(model);
}
public UserInfoReceiver(IApiAccessor accessor, [NotNull] Action <TwitterUser> handler,
[CanBeNull] Action <Exception> exceptionHandler, [NotNull] UserParameter target)
: base(exceptionHandler)
{
_accessor = accessor;
_handler = handler ?? throw new ArgumentNullException(nameof(handler));
_target = target ?? throw new ArgumentNullException(nameof(target));
}
public void CreateMethod()
{
// action
var model = new UserParameter();
// assert
Assert.IsNotNull(model);
}
