public async Task <List <ViewedWizard> > GetViewedWizardsAsync(Guid userId) { using (var sdc = new SynthesisDataContext()) { return(await sdc.ViewedWizards.Where(w => w.UserId == userId).ToListAsync()); } }
public async Task <ViewedWizard> CreateViewedWizardAsync(ViewedWizard wizardView) { using (var dc = new SynthesisDataContext()) { dc.ViewedWizards.Add(wizardView); await dc.SaveChangesAsync(); return(await dc.ViewedWizards.SingleAsync(x => x.UserId == wizardView.UserId && x.WizardType == wizardView.WizardType)); } }
public async Task <List <InProductTrainingViewResponse> > GetInProductTrainingViewsAsync(int clientApplicationId, Guid userId) { List <InProductTrainingViewResponse> trainingViews; using (var sdc = new SynthesisDataContext()) { trainingViews = await sdc.InProductTrainingViews .Include(s => s.InProductTrainingSubject) .Where(t => t.UserId == userId && t.InProductTrainingSubject.ClientApplicationId == clientApplicationId) .Select(v => new InProductTrainingViewResponse { InProductTrainingSubjectId = v.InProductTrainingSubjectId, UserId = v.UserId, Title = v.Title, ClientApplicationId = v.InProductTrainingSubject.ClientApplicationId, TrainingMethod = v.InProductTrainingSubject.TrainingMethod, UserTypeId = v.UserTypeId }) .ToListAsync(); } return(trainingViews); }
public InProductTrainingViewResponse CreateInProductTrainingView(int inProductTrainingSubjectId, Guid userId, string title, int userTypeId, string createdByUserName, ref CreateInProductTrainingViewReturnCode returnCode) { if (string.IsNullOrWhiteSpace(title)) { throw new ArgumentNullException(title, "Argument cannot be null, empty, or whitespace."); } if (string.IsNullOrWhiteSpace(createdByUserName)) { throw new ArgumentNullException(createdByUserName, "Argument cannot be null, empty, or whitespace."); } SqlParameter resultCodeOutputParam; InProductTrainingViewResponse result; using (var dc = new SynthesisDataContext()) { var inProductTrainingSubjectIdParam = new SqlParameter("@InProductTrainingSubjectId", inProductTrainingSubjectId); var userIdParam = new SqlParameter("@UserId", userId); var titleParam = new SqlParameter("@Title", title); var userTypeParam = new SqlParameter("@UserTypeId", userTypeId); var createUserParam = new SqlParameter("@CreateUser", createdByUserName); resultCodeOutputParam = new SqlParameter("@ResultCode", SqlDbType.Int) { Direction = ParameterDirection.Output }; result = dc.Database.SqlQuery <InProductTrainingViewResponse>("InsertInProductTrainingViews @InProductTrainingSubjectId, @UserID, @Title, @UserTypeId, @CreateUser, @ResultCode OUTPUT", inProductTrainingSubjectIdParam, userIdParam, titleParam, userTypeParam, createUserParam, resultCodeOutputParam).FirstOrDefault(); } if (!Enum.TryParse(resultCodeOutputParam.Value.ToString(), out returnCode)) { returnCode = CreateInProductTrainingViewReturnCode.CreateFailed; } return(result); }