protected void AddRoleAction(int role_id, int scope_id, qPtl_User user) { var role_actions = qPtl_RoleAction.GetAvailableRoleActionsByRole(role_id, scope_id); DateTime startTime = DateTime.Now; DateTime endTime = DateTime.Now; foreach (var a in role_actions) { qPtl_UserAction action = new qPtl_UserAction(); qPtl_Action act = new qPtl_Action(a.ActionID); action.ScopeID = scope_id; action.Available = "Yes"; action.Created = DateTime.Now; action.CreatedBy = user.UserID; action.LastModified = DateTime.Now; action.LastModifiedBy = user.UserID; action.MarkAsDelete = 0; action.UserID = user.UserID; action.ActionID = a.ActionID; startTime = startTime.AddDays(a.StartDaysFromNow); endTime = endTime.AddDays(a.EndDaysFromNow); action.AvailableFrom = startTime; action.AvailableTo = endTime; action.AfterNumLogins = a.AfterNumLogins; action.Priority = a.Priority; action.SkipAllowed = a.SkipAllowed; action.NumberSkipsAllowed = a.NumberSkipsAllowed; action.Required = a.Required; action.OptionalOptOut = a.OptionOptOut; action.RedirectSkipURL = a.RedirectSkipURL; action.RedirectURL = a.RedirectURL; action.ReferenceID = act.ReferenceID; action.Insert(); } }
protected static void AddRoleAction(int role_id, int scope_id, qPtl_User user) { var role_actions = qPtl_RoleAction.GetAvailableRoleActionsByRole(role_id, scope_id); DateTime startTime = DateTime.Now; DateTime endTime = DateTime.Now; foreach (var a in role_actions) { qPtl_UserAction action = new qPtl_UserAction(); qPtl_Action act = new qPtl_Action(a.ActionID); action.ScopeID = scope_id; action.Available = "Yes"; action.Created = DateTime.Now; action.CreatedBy = user.UserID; action.LastModified = DateTime.Now; action.LastModifiedBy = user.UserID; action.MarkAsDelete = 0; action.UserID = user.UserID; action.ActionID = a.ActionID; startTime = startTime.AddDays(a.StartDaysFromNow); endTime = endTime.AddDays(a.EndDaysFromNow); action.AvailableFrom = startTime; action.AvailableTo = endTime; action.AfterNumLogins = a.AfterNumLogins; action.Priority = a.Priority; action.SkipAllowed = a.SkipAllowed; action.NumberSkipsAllowed = a.NumberSkipsAllowed; action.Required = a.Required; action.OptionalOptOut = a.OptionOptOut; action.RedirectSkipURL = a.RedirectSkipURL; action.RedirectURL = a.RedirectURL; action.ReferenceID = act.ReferenceID; action.Insert(); } }
public static qPtl_UserAction GetActionByUserAndAction(Int32 user_id, int action_id) { var action = new qPtl_UserAction(); action.container.Select( new DbQuery { Where = "UserID = @UserID AND ActionID = @ActionID", Parameters = new SqlQueryParameter[] { new SqlQueryParameter("@ActionID", action_id), new SqlQueryParameter("@UserID", user_id) } }); return(action.UserActionID > 0 ? action : null); }
protected void btnAgreeRules_Click(object sender, EventArgs e) { int user_id = Convert.ToInt32(Context.Items["UserID"]); qPtl_UserProfile profile = new qPtl_UserProfile(user_id); profile.AgreeRules = DateTime.Now; profile.Update(); // see if this is the action page -- if so, update actionID int action_id = 0; if (!String.IsNullOrEmpty(Convert.ToString(Request.QueryString["actionID"]))) { action_id = Convert.ToInt32(Request.QueryString["actionID"]); qPtl_UserAction action = new qPtl_UserAction(user_id, action_id); action.LastModified = DateTime.Now; action.LastModifiedBy = user_id; action.UserCompleted = DateTime.Now; action.Update(); Response.Redirect(action.RedirectURL); } }
public static qPtl_UserAction GetActionByUserAndAction(Int32 user_id, int action_id) { var action = new qPtl_UserAction(); action.container.Select( new DbQuery { Where = "UserID = @UserID AND ActionID = @ActionID", Parameters = new SqlQueryParameter[] { new SqlQueryParameter("@ActionID", action_id), new SqlQueryParameter("@UserID", user_id) } }); return action.UserActionID > 0 ? action : null; }