コード例 #1
0
        public string UpdageLocation(string userName, string tdUserGroupId)
        {
            object[] appUsrId =
            {
                new SqlParameter("@app_usr_id", userName)
            };
            object[] tdUserGroupIdParam =
            {
                new SqlParameter("@tdUserGroupId", tdUserGroupId)
            };
            var rep = new GenericRepository <usp_returnUserData>(_context);

            rep.ExecueUpdate("sp_SetAppUser", appUsrId);
            rep.ExecueUpdate("usp_ChangeUserLocation", tdUserGroupIdParam);

            return("success");
        }
コード例 #2
0
        public int TdmsFailedTradesSave(string idList, int tdxfailurereason, string resolveddate, string comment, string userName)
        {
            var count      = 0;
            var parameters = new[]
            {
                new SqlParameter("@tdtradeList", idList),
                new SqlParameter("@enteredby", userName),
                new SqlParameter("@tdxfailurereason", tdxfailurereason),
                new SqlParameter("@resolveddate", resolveddate),
                new SqlParameter("@comment", comment)
            };
            var repo = new GenericRepository <EmptyUpdateModel>(_context);

            count = repo.ExecueUpdate("usp_UpdateFailedTrades", parameters);

            return(count);
        }