public UserActivityModel GetActivityList(int userId)
{
var result = new UserActivityModel
{
Events = _event.GetPreviewList(userId),
Groups = _group.GetPreviewList(userId),
Contacts = _user.GetPreviewList(userId)
};
return(result);
}
public void AddUserActivity(UserActivityModel model)
{
this.db
.TblUserActivity
.Add(new tbl_UserActivity
{
IdLogin = model.IdLogin,
Type = model.Type,
ChangeStamp = model.ChangeStamp,
Comment = model.Comment,
Sandbox = model.Sandbox
});
this.db.SaveChanges();
}
public ActionResult Post([FromBody] UserActivityModel model)
{
var entry = new ActivitiesUsers
{
ActivityGuid = model.ActivityUid,
UserGuid = model.UserUid,
Uid = Guid.NewGuid(),
UserType = BLModels.Enums.UserTypes.Volunteer
};
if (activitiesUsersService.Save(entry))
{
return(Ok());
}
return(BadRequest("Ошибка сохранения"));
}
public async Task <IActionResult> UpdateStatus(UserActivityModel model)
{
if (!ModelState.IsValid)
{
return(Json(new { success = false, errors = ModelState.Values.SelectMany(x => x.Errors).Select(x => x.ErrorMessage).ToList() }));
}
var currentUser = await this.GetUserDetailsAsync();
model.IdLogin = currentUser.IdLogin;
model.ChangeStamp = DateTime.Now;
model.Sandbox = currentUser.Sandbox;
this.mining.AddUserActivity(model);
return(Json(new { Status = model.Type }));
}
public async Task <IActionResult> AddActivity([FromBody] UserActivityModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
await _userSessionRepository.LogUserActivityAsync(model.UserSessionId, new UserActivity
{
Id = DataUtil.GenerateUniqueId(),
ActivityName = model.ActivityName,
ActivityType = model.ActivityType,
ActivityDate = DateTime.UtcNow,
Content = model.Content
});
return(NoContent());
}
/// <summary>
/// 用户报名
/// </summary>
/// <param name="userActivityModel"></param>
/// <returns></returns>
public static async Task <bool> InsertUserActivityModelAsync(UserActivityModel userActivityModel)
{
string sql = @"INSERT Activity..T_UserApplyActivity
(
UserId,
ActivityId,
Mobile,
CarNum,
DriverNum,
Ip,
Region,
Status,
ExpirationTime,
CreatedDateTime,
UpdatedDateTime
)
VALUES
(@UserId, @ActivityId, @Mobile, @CarNum, @DriverNum, @Ip, @Region, @Status, NULL, GETDATE(), GETDATE())";
using (var dbHelper = new SqlDbHelper(ActivityConnectionString))
using (var cmd = new SqlCommand(sql))
{
cmd.CommandType = CommandType.Text;
var parameters = new SqlParameter[]
{
new SqlParameter("@UserId", userActivityModel.UserId),
new SqlParameter("@ActivityId", userActivityModel.ActivityId),
new SqlParameter("@Mobile", userActivityModel.Mobile),
new SqlParameter("@CarNum", userActivityModel.CarNum),
new SqlParameter("@DriverNum", userActivityModel.DriverNum),
new SqlParameter("@Ip", userActivityModel.Ip),
new SqlParameter("@Region", userActivityModel.Region),
new SqlParameter("@Status", userActivityModel.Status)
};
cmd.Parameters.AddRange(parameters);
return(await dbHelper.ExecuteNonQueryAsync(cmd) > 0);
}
}
/// <summary>
/// 审核用户报名活动
/// </summary>
/// <returns></returns>
public static async Task <bool> UpdateUserActivityStatusByPKIDAsync(UserActivityModel userActivityModel)
{
string sql = @"UPDATE Activity..T_UserApplyActivity
SET Status = @Status,
Remark = @Remark,
ServiceCode = @ServiceCode
WHERE PKID = @PKID";
using (var dbHelper = new SqlDbHelper(ActivityConnectionString))
using (var cmd = new SqlCommand(sql))
{
cmd.CommandType = CommandType.Text;
var parameters = new SqlParameter[]
{
new SqlParameter("@Status", userActivityModel.Status),
new SqlParameter("@Remark", userActivityModel.Remark),
new SqlParameter("@ServiceCode", userActivityModel.ServiceCode),
new SqlParameter("@PKID", userActivityModel.PKID)
};
cmd.Parameters.AddRange(parameters);
return(await dbHelper.ExecuteNonQueryAsync(cmd) > 0);
}
}
public ActionResult ViewDetail(UserViewDetailModel model)
{
if (!Request.IsAjaxRequest())
{
IUser user = _service.GetUserByUsername(Request.QueryString["userName"]);
UserModel userModel = new UserModel(user);
IList <IRole> roleList = _service.GetRoles(string.Empty);
userModel.Roles = roleList.Where(r => user.RoleIds.Contains(r.Id)).Select(r => r.Name).ToList();
return(View(userModel));
}
IPagedList <UserActivity> list = _service.GetUserActivities(model.PageIndex, model.PageSize, model.UserId);
List <UserActivityModel> modelList = new List <UserActivityModel>();
foreach (UserActivity ua in list)
{
UserActivityModel uaModel = new UserActivityModel();
uaModel.CreatedOn = ua.CreatedOn;
uaModel.Activity = _resourceManager.GetString("UserActivityType_" + ua.UserActivityType.ToString());
modelList.Add(uaModel);
}
return(DataTableResult(modelList, list.TotalCount, model.Draw));
}
public List <UserActivityModel> GetAllUserActivity()
{
List <UserActivityModel> activityModels = new List <UserActivityModel>();
using (var conn = new NpgsqlConnection(connectingString))
{
conn.Open();
using (var command = new NpgsqlCommand($"SELECT * FROM userlog", conn))
{
var reader = command.ExecuteReader();
while (reader.Read())
{
UserActivityModel userActivity = new UserActivityModel();
var user_id = Convert.ToString(reader["user_name"]);
var user_activity = Convert.ToString(reader["user_activity"]);
userActivity = new UserActivityModel(user_id, user_activity);
activityModels.Add(userActivity);
}
}
conn.Close();
}
return(activityModels);
}
/// <summary>
/// This action returns list of user activities
/// </summary>
/// <returns></returns>
public ActionResult GetClientRecentActivityDetails()
{
try
{
if (SessionManagement.UserInfo != null)
{
LoginInformation loginInfo = SessionManagement.UserInfo;
var lstUserActivities = new List <UserActivityModel>();
//Get latest activities
var activities = usrActivityBO.GetUserRecentActivityDetails(loginInfo.UserID);
//Set IsSeen true for new activities if any
usrActivityBO.MarkSeenRecentActivity(loginInfo.UserID);
foreach (var act in activities)
{
var usrAct = new UserActivityModel();
usrAct.ActivityTimestamp = Convert.ToDateTime(act.Timestamp).ToString("dd/MM/yyyy HH:mm:ss tt");
usrAct.IsSeen = (bool)act.IsSeen;
//Profile Activities
if (act.FK_ActivityTypeID == (int)ActivityType.ProfileActivity)
{
usrAct.ActivityDetails = act.ProfileActivities.FirstOrDefault().ProfileActivityDetails;
}
//Document activities
else if (act.FK_ActivityTypeID == (int)ActivityType.DocumentActivity)
{
usrAct.ActivityDetails = "<a href=Document>" +
act.DocumentActivities.FirstOrDefault().Document.DocumentName +
"</a>" + " document status has changed to <i>" +
act.DocumentActivities.FirstOrDefault().DocumentStatus + "</i>.";
}
//Account activities
else if (act.FK_ActivityTypeID == (int)ActivityType.AccountActivity)
{
//New acc creation activity
if (act.AccountActivities.FirstOrDefault().FK_AccActivityTypeID ==
(int)AccountActivityType.NewAccountCreation)
{
//If account number is present
if (act.AccountActivities.FirstOrDefault().FK_ClientAccountID != null)
{
//If landing acc
if (act.AccountActivities.FirstOrDefault().AccountType == "Landing")
{
usrAct.ActivityDetails = "A new " +
act.AccountActivities.FirstOrDefault()
.L_CurrencyValue.CurrencyValue + " " +
act.AccountActivities.FirstOrDefault().AccountType +
" <a href='MyAccount'>" +
act.AccountActivities.FirstOrDefault()
.Client_Account.LandingAccount +
"</a> account has been created.";
}
else
{
usrAct.ActivityDetails = "A new " +
act.AccountActivities.FirstOrDefault()
.L_CurrencyValue.CurrencyValue + " " +
act.AccountActivities.FirstOrDefault().AccountType +
" <a href='MyAccount'>" +
act.AccountActivities.FirstOrDefault()
.Client_Account.TradingAccount +
"</a> account has been created.";
}
}
else
{
usrAct.ActivityDetails = "A new " +
act.AccountActivities.FirstOrDefault()
.L_CurrencyValue.CurrencyValue + " " +
act.AccountActivities.FirstOrDefault().AccountType +
" account has been created.";
}
}
}
//Transfer activities
else if (act.FK_ActivityTypeID == (int)ActivityType.TransferActivity)
{
if (act.TransferActivities.FirstOrDefault().TransferStatus == Constants.K_STATUS_TRANSFERRED)
{
if (act.TransferActivities.FirstOrDefault().FK_FromUserID == null &&
act.TransferActivities.FirstOrDefault().FK_ToUserID == null)
{
usrAct.ActivityDetails = "<b>" +
Utility.FormatCurrencyValue(
(decimal)act.TransferActivities.FirstOrDefault()
.TransferAmount, "") + " " +
act.TransferActivities.FirstOrDefault()
.L_CurrencyValue.CurrencyValue +
"</b> has been transferred from account <a href='MyAccount'>" +
act.TransferActivities.FirstOrDefault().FromAccount +
"</a> to <a href='MyAccount'>" +
act.TransferActivities.FirstOrDefault().ToAccount + "</a>.";
}
else if (act.TransferActivities.FirstOrDefault().FK_FromUserID != null)
{
string fromClientName = String.Empty;
if (
userBO.GetUserDetails(
(int)act.TransferActivities.FirstOrDefault().FK_FromUserID) !=
null)
{
fromClientName =
clientBO.GetClientName(
(int)act.TransferActivities.FirstOrDefault().FK_FromUserID);
}
else
{
fromClientName =
introducingBrokerBO.GetPartnerName(
(int)act.TransferActivities.FirstOrDefault().FK_FromUserID);
}
usrAct.ActivityDetails = "<b>" +
Utility.FormatCurrencyValue(
(decimal)act.TransferActivities.FirstOrDefault()
.TransferAmount, "") + " " +
act.TransferActivities.FirstOrDefault()
.L_CurrencyValue.CurrencyValue +
"</b> has been deposited from " + fromClientName +
" to <a href='MyAccount'>" +
act.TransferActivities.FirstOrDefault().ToAccount + "</a>.";
}
else if (act.TransferActivities.FirstOrDefault().FK_ToUserID != null)
{
string toClientName = String.Empty;
if (
userBO.GetUserDetails((int)act.TransferActivities.FirstOrDefault().FK_ToUserID) !=
null)
{
toClientName =
clientBO.GetClientName(
(int)act.TransferActivities.FirstOrDefault().FK_ToUserID);
}
else
{
toClientName =
introducingBrokerBO.GetPartnerName(
(int)act.TransferActivities.FirstOrDefault().FK_ToUserID);
}
usrAct.ActivityDetails = "<b>" +
Utility.FormatCurrencyValue(
(decimal)act.TransferActivities.FirstOrDefault()
.TransferAmount, "") + " " +
act.TransferActivities.FirstOrDefault()
.L_CurrencyValue.CurrencyValue +
"</b> has been transferred from account <a href='MyAccount'>" +
act.TransferActivities.FirstOrDefault().FromAccount +
"</a> to " + toClientName + ".";
}
}
else
{
usrAct.ActivityDetails = "<b>" +
Utility.FormatCurrencyValue(
(decimal)act.TransferActivities.FirstOrDefault()
.TransferAmount, "") + " " +
act.TransferActivities.FirstOrDefault()
.L_CurrencyValue.CurrencyValue +
"</b> is pending transfer from account <a href='MyAccount'>" +
act.TransferActivities.FirstOrDefault().FromAccount +
"</a> to <a href='MyAccount'>" +
act.TransferActivities.FirstOrDefault().ToAccount + "</a>.";
}
}
//Conversion activities
else if (act.FK_ActivityTypeID == (int)ActivityType.ConversionActivity)
{
if (act.ConversionActivities.FirstOrDefault().ConversionStatus ==
Constants.K_STATUS_TRANSFERRED)
{
if (act.ConversionActivities.FirstOrDefault().FK_FromUserID == null &&
act.ConversionActivities.FirstOrDefault().FK_ToUserID == null)
{
usrAct.ActivityDetails = "<b>" +
Utility.FormatCurrencyValue(
(int)act.ConversionActivities.FirstOrDefault()
.ConversionAmount, "") + " " +
act.ConversionActivities.FirstOrDefault()
.L_CurrencyValue.CurrencyValue +
"</b> has been converted from <a href='MyAccount'>" +
act.ConversionActivities.FirstOrDefault().FromAccount +
"</a> at an exchange rate of " +
act.ConversionActivities.FirstOrDefault().ExchangeRate +
" totaling <b>" +
Math.Round(
Convert.ToDecimal(
act.ConversionActivities.FirstOrDefault()
.ConversionAmount) *
Convert.ToDecimal(
act.ConversionActivities.FirstOrDefault()
.ExchangeRate),
2) +
" " +
act.ConversionActivities.FirstOrDefault()
.L_CurrencyValue1.CurrencyValue +
"</b> and transferred to <a href='MyAccount'>" +
act.ConversionActivities.FirstOrDefault().ToAccount +
"</a>.";
}
else if (act.ConversionActivities.FirstOrDefault().FK_FromUserID != null)
{
string fromClientName = String.Empty;
if (
userBO.GetUserDetails(
(int)act.ConversionActivities.FirstOrDefault().FK_FromUserID) !=
null)
{
fromClientName =
clientBO.GetClientName(
(int)act.ConversionActivities.FirstOrDefault().FK_FromUserID);
}
else
{
fromClientName =
introducingBrokerBO.GetPartnerName(
(int)act.ConversionActivities.FirstOrDefault().FK_FromUserID);
}
usrAct.ActivityDetails = "<b>" +
Utility.FormatCurrencyValue(
(int)act.ConversionActivities.FirstOrDefault()
.ConversionAmount, "") + " " +
act.ConversionActivities.FirstOrDefault()
.L_CurrencyValue.CurrencyValue +
"</b> has been converted from " +
fromClientName +
" at an exchange rate of " +
act.ConversionActivities.FirstOrDefault().ExchangeRate +
" totaling <b>" +
Math.Round(
Convert.ToDecimal(
act.ConversionActivities.FirstOrDefault()
.ConversionAmount) *
Convert.ToDecimal(
act.ConversionActivities.FirstOrDefault()
.ExchangeRate),
2) +
" " +
act.ConversionActivities.FirstOrDefault()
.L_CurrencyValue1.CurrencyValue +
"</b> and transferred to <a href='MyAccount'>" +
act.ConversionActivities.FirstOrDefault().ToAccount +
"</a>.";
}
else if (act.ConversionActivities.FirstOrDefault().FK_ToUserID != null)
{
string toClientName = String.Empty;
if (
userBO.GetUserDetails(
(int)act.ConversionActivities.FirstOrDefault().FK_ToUserID) !=
null)
{
toClientName =
clientBO.GetClientName(
(int)act.ConversionActivities.FirstOrDefault().FK_ToUserID);
}
else
{
toClientName =
introducingBrokerBO.GetPartnerName(
(int)act.ConversionActivities.FirstOrDefault().FK_ToUserID);
}
usrAct.ActivityDetails = "<b>" +
Utility.FormatCurrencyValue(
(decimal)act.ConversionActivities.FirstOrDefault()
.ConversionAmount, "") + " " +
act.ConversionActivities.FirstOrDefault()
.L_CurrencyValue.CurrencyValue +
"</b> has been converted from <a href='MyAccount'>" +
act.ConversionActivities.FirstOrDefault().FromAccount +
"</a> at an exchange rate of " +
act.ConversionActivities.FirstOrDefault().ExchangeRate +
" totaling <b>" +
Math.Round(
Convert.ToDecimal(
act.ConversionActivities.FirstOrDefault()
.ConversionAmount) *
Convert.ToDecimal(
act.ConversionActivities.FirstOrDefault()
.ExchangeRate),
2) +
" " +
act.ConversionActivities.FirstOrDefault()
.L_CurrencyValue1.CurrencyValue +
"</b> and transferred to " +
toClientName +
".";
}
}
else
{
usrAct.ActivityDetails = "<b>" +
Utility.FormatCurrencyValue(
(int)act.ConversionActivities.FirstOrDefault()
.ConversionAmount, "") + " " +
act.ConversionActivities.FirstOrDefault()
.L_CurrencyValue.CurrencyValue +
"</b> has been converted from <a href='MyAccount'>" +
act.ConversionActivities.FirstOrDefault().FromAccount +
"</a> at an exchange rate of " +
act.ConversionActivities.FirstOrDefault().ExchangeRate +
" totaling <b>" +
Math.Round(
Convert.ToDecimal(
act.ConversionActivities.FirstOrDefault()
.ConversionAmount) *
Convert.ToDecimal(
act.ConversionActivities.FirstOrDefault().ExchangeRate),
2) +
" " +
act.ConversionActivities.FirstOrDefault()
.L_CurrencyValue1.CurrencyValue +
"</b> and is pending transfer to <a href='MyAccount'>" +
act.ConversionActivities.FirstOrDefault().ToAccount + "</a>.";
}
}
//Fund or withdraw activities
else if (act.FK_ActivityTypeID == (int)ActivityType.DepositOrWithdrawActivity)
{
if (act.DepositOrWithdrawActivities.FirstOrDefault().TransferStatus ==
Constants.K_STATUS_PENDING)
{
if (act.DepositOrWithdrawActivities.FirstOrDefault().Type == Constants.K_DEPOSIT)
{
usrAct.ActivityDetails = "You have submitted a deposit of <b>" +
Utility.FormatCurrencyValue(
(decimal)act.DepositOrWithdrawActivities
.FirstOrDefault().Amount, "") + " " +
act.DepositOrWithdrawActivities.FirstOrDefault()
.L_CurrencyValue.CurrencyValue + "</b>.";
}
else
{
usrAct.ActivityDetails = "<b>" +
Utility.FormatCurrencyValue(
(decimal)act.DepositOrWithdrawActivities
.FirstOrDefault().Amount, "") +
" " +
act.DepositOrWithdrawActivities.FirstOrDefault()
.L_CurrencyValue.CurrencyValue +
"</b> have been withdrawn from <a href='MyAccount'>" +
act.DepositOrWithdrawActivities.FirstOrDefault()
.AccountNumber +
"</a> and is pending transfer to " +
act.DepositOrWithdrawActivities.FirstOrDefault()
.BankAccountInformation.BankName + ".";
}
}
else
{
if (act.DepositOrWithdrawActivities.FirstOrDefault().Type == Constants.K_DEPOSIT)
{
usrAct.ActivityDetails = "<b>" +
Utility.FormatCurrencyValue(
(decimal)act.DepositOrWithdrawActivities
.FirstOrDefault().Amount, "") + " " +
act.DepositOrWithdrawActivities.FirstOrDefault()
.L_CurrencyValue.CurrencyValue +
"</b> has been received and deposited into <a href='MyAccount'>" +
act.DepositOrWithdrawActivities.FirstOrDefault()
.AccountNumber + "</a>.";
}
else
{
usrAct.ActivityDetails = "<b>" +
Utility.FormatCurrencyValue(
(decimal)act.DepositOrWithdrawActivities
.FirstOrDefault().Amount, "") +
" " +
act.DepositOrWithdrawActivities.FirstOrDefault()
.L_CurrencyValue.CurrencyValue +
"</b> have been withdrawn from <a href='MyAccount'>" +
act.DepositOrWithdrawActivities.FirstOrDefault()
.AccountNumber + "</a> and transferred to " +
act.DepositOrWithdrawActivities.FirstOrDefault()
.BankAccountInformation.BankName + ".";
}
}
}
lstUserActivities.Add(usrAct);
}
return(Json(new
{
total = 1,
page = 1,
records = lstUserActivities.Count,
rows = lstUserActivities
}, JsonRequestBehavior.AllowGet));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
catch (Exception ex)
{
CurrentDeskLog.Error(ex.Message, ex);
return(View("ErrorMessage"));
}
}
/// <summary>
/// 审核用户报名活动
/// </summary>
/// <returns></returns>
public static async Task <bool> AuditUserActivityStatusByPKIDAsync(UserActivityModel userActivityModel)
{
return(await DataAccess.Activity.UpdateUserActivityStatusByPKIDAsync(userActivityModel));
}
/// <summary>
/// 用户报名
/// </summary>
/// <param name="userActivityModel"></param>
/// <returns></returns>
public static async Task <bool> CreateUserActivityModelAsync(UserActivityModel userActivityModel)
{
return(await DataAccess.Activity.InsertUserActivityModelAsync(userActivityModel));
}
