public Language ReadByName(string name) { using (var connection = new SqlConnection(_connectionString)) { connection.Open(); using (var command = new SqlCommand()) { command.Connection = connection; command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = DbStrings.LANGUAGES_READ_BY_NAME; command.Parameters.Add(new SqlParameter("@Name", name)); using (var dataReader = command.ExecuteReader()) { if (dataReader.Read()) { return(ModelConverter.GetLanguage(dataReader)); } } } } return(null); }
public IActionResult UsersModifyOverview() { var users = userService.GetAll(); var usersModify = users.Select(x => ModelConverter.ConvertToUserModifyOverviewModel(x)).ToList(); return(View(usersModify)); }
//@TODO: Add validation for user type in later iteration. public void Create(IArticleModel article) { article.ArticleText = article.ArticleText; var result = ModelConverter.ConvertModelToDto(article); DalFactory.ArticleHandler.Create(result); }
public void ToCharacterViewModelTest() { //Arrange Character dbCharacter = new Character() { Id = 1, CampaignId = 1, HistoryId = 1, Name = "Cassidy", Description = "A woman with a heart of gold, but ironically has no heart. She has crazy red hair and is mean with a Guisarm.", Notes = "She has a mechanical heart because an evil fairy stole her real one! She's on a quest to find a new heart. She's also known as Big T!", Sessions = SessionsTestData.getDbSessions() }; //Act CharacterViewModel characterVM = ModelConverter.ToCharacterViewModel(dbCharacter); //Assert Assert.IsNotNull(characterVM); Assert.AreEqual(dbCharacter.Id, characterVM.Id); Assert.AreEqual(dbCharacter.CampaignId, characterVM.CampaignId); Assert.AreEqual(dbCharacter.Name, characterVM.Name); Assert.AreEqual(dbCharacter.Description, characterVM.CharDescription); Assert.AreEqual(dbCharacter.Notes, characterVM.Notes); Assert.AreEqual(dbCharacter.Sessions.Count, characterVM.SessionList.Count); }
public async Task <IActionResult> GetOrganizationBookingDetail([FromRoute] int organizationId, [FromRoute] string day) { try { if (organizationId <= 0) { return(BadRequest()); } if (!DateTime.TryParse(day, out var date)) { return(BadRequest()); } var organization = await _organizationStore.GetOrganizationAsync(organizationId); if (organization == null) { return(Conflict(1)); } var bookingDetail = await _organizationStore.GetOrganizationBookingPlacement(organizationId, date); var result = ModelConverter.GetOrganizationBookingDetail(organization, bookingDetail.ToList()); return(Ok(result)); } catch (Exception ex) { return(StatusCode((int)HttpStatusCode.InternalServerError)); } }
public Project Add(Project project) { Project addedProject = null; using (var connection = new SqlConnection(_connectionString)) { connection.Open(); using (var command = new SqlCommand()) { command.Connection = connection; command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = DbStrings.PROJECTS_ADD; command.Parameters.Add(new SqlParameter("@Name", project.Name)); command.Parameters.Add(new SqlParameter("@Description", project.Description)); command.Parameters.Add(new SqlParameter("@UserId", project.UserID)); command.Parameters.Add(new SqlParameter("@SourceLanguageId", project.SourceLanguage.ID)); using (var dataReader = command.ExecuteReader()) { if (dataReader.Read()) { addedProject = ModelConverter.GetProject(dataReader); AddTargetLanguages(project.TargetLanguages, addedProject.ID); addedProject = GetProjectWithSourceAndTargetLanguages(dataReader); } } } } return(addedProject); }
public IActionResult Modify(int id) { Blog blog = BlogService.GetById(id); BlogModifyModel model = ModelConverter.ConvertToBlogModifyModel(blog); return(View(model)); }
public IActionResult Details(int id) { Blog blog = BlogService.GetBlogDetails(id); BlogDetailsModel model = ModelConverter.ConvertToDetailsModel(blog); model.SidebarData = BlogService.GetSidebarData(); if (User.Identity.IsAuthenticated) { BlogLikeModel blogLike = model.BlogLikes.FirstOrDefault(x => x.UserId == Convert.ToInt32(User.FindFirst("Id").Value)); if (blogLike != null) { if (blogLike.Status) { model.LikeStatus = BlogLikeStatus.Liked; } else { model.LikeStatus = BlogLikeStatus.Disliked; } } } return(View(model)); }
public ActionResult Search(string query) { Model.Restaurant[] results = lib.SearchAndParse(query); return(View("Index", ModelConverter.Convert(results))); }
// GET: Restaurant/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Model.Restaurant r; try { r = lib.GetRestaurant((int)id); } catch (Exception) { return(HttpNotFound()); } if (r == null) { return(HttpNotFound()); } TempData["restId"] = id; return(View(ModelConverter.Convert(r))); }
// GET: Restaurant/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Model.Restaurant r; try { r = lib.GetRestaurant((int)id); } catch (Exception) { return(HttpNotFound()); } if (r == null) { return(HttpNotFound()); } return(View(ModelConverter.ConvertLite(r))); }
public IEnumerable <ApprovalReportModel> GetSalesApprovalReport() { Dictionary <string, string> parameters = new Dictionary <string, string>(); parameters.Add("@flag", DashboardReportConstatnts.PendingApprovals); return(ModelConverter.CreateListFromTable <ApprovalReportModel>(_repo.Retrieve(parameters).Tables[0])); }
/// <summary> /// Gets the latest hot news. /// </summary> /// <param name="count">The count.</param> /// /// <param name="userName">The userName.</param> /// <returns>WeiboNewsList.</returns> public WeiboNewsList GetLatestHotNews(int count, string userName) { if (string.IsNullOrEmpty((userName))) { userName = currentClientUser.Name; } var weiboList = this.weiboRepository.GetLatestWeiboHotNews(count, userName).ToList(); List <WeiboBrief> result = null; if (!weiboList.Any()) { return new WeiboNewsList() { NewsList = null } } ; result = new List <WeiboBrief>(); foreach (var weibo in weiboList) { result.Add(ModelConverter.ToWeiboBrief(weibo)); } return(new WeiboNewsList() { NewsList = result }); }
public ActionResult Edit(int?id = null) { EditProjectSourceModel model = null; int?currentConfigTypeId = null; if (id.HasValue) { var obj = ProjectSourceLogic.Get(id.Value); if (obj != null) { model = ModelConverter.ConvertToEdit(obj); currentConfigTypeId = obj.SourceConfig.Id; } else { this.AddWarning("NoProjectSourceFound", "No ProjectSource was found with that Id. Switching to Create mode."); return(Redirect(Url.ProjectSource_Create())); } } if (model == null) { model = new EditProjectSourceModel(); } var availableTypeItems = ProjectSourceTypeLogic.GetAll() .Select(c => new SelectListItem { Text = c.Name, Value = c.Id.ToString() }); model.AvailableTypes = new SelectList(availableTypeItems, availableTypeItems.FirstOrDefault(a => a.Value == currentConfigTypeId.ToString())); return(View("Edit", model)); }
public IActionResult Modify(int id) { var recipe = RecipesService.GetById(id); var recipeModify = ModelConverter.ConvertToRecipeModify(recipe); return(View(recipeModify)); }
public ActionResult Edit(EditProjectModel model) { if (!ModelState.IsValid) { return(Redirect(Url.Project_Edit(model.Id))); } ProjectObj project; if (!model.Id.HasValue) { project = ModelConverter.Convert(model); project.Id = ProjectLogic.Create(project, CurrentUserName); if (project.Id == -1) { this.AddError("CreatingProject", "There was an error creating your project. If this continues contact support."); return(Redirect(Url.Project_Create())); } } else { project = ModelConverter.Convert(model); var success = ProjectLogic.Update(project, CurrentUserName); if (!success) { this.AddError("UpdatingProject", "There was an error updating your project. If this continues contact support."); return(Redirect(Url.Project_Edit(model.Id.Value))); } } return(Redirect(Url.Project_Show(project.Id.Value))); }
public Phrase Add(Phrase phrase) { using (var connection = new SqlConnection(_connectionString)) { connection.Open(); using (var command = new SqlCommand()) { command.Connection = connection; command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = DbStrings.PHRASES_ADD; command.Parameters.Add(new SqlParameter("@Text", phrase.Text)); command.Parameters.Add(new SqlParameter("@ProjectId", phrase.ProjectID)); using (var dataReader = command.ExecuteReader()) { if (dataReader.Read()) { return(ModelConverter.GetPhrase(dataReader)); } } } } return(null); }
public ActionResult Edit(int?id = null) { EditProjectModel model = null; if (id.HasValue) { var project = ProjectLogic.Get(id.Value); if (project != null) { model = ModelConverter.ConvertToEdit(project); } else { this.AddWarning("NoItemFound", "No project was found with that Id. Switching to Create mode."); return(Redirect(Url.Project_Create())); } } if (model == null) { model = new EditProjectModel(); model.Tags = new List <ListItemTagModel>(); } return(View("Edit", model)); }
public Phrase ReadById(Guid id) { using (var connection = new SqlConnection(_connectionString)) { connection.Open(); using (var command = new SqlCommand()) { command.Connection = connection; command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = DbStrings.PHRASES_READ_BY_ID; command.Parameters.Add(new SqlParameter("@Id", id)); using (var dataReader = command.ExecuteReader()) { if (dataReader.Read()) { return(ModelConverter.GetPhrase(dataReader)); } } } } return(null); }
public List <Phrase> ReadAllByProjectId(Guid projectId) { var result = new List <Phrase>(); using (var connection = new SqlConnection(_connectionString)) { connection.Open(); using (var command = new SqlCommand()) { command.Connection = connection; command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = DbStrings.PHRASES_READ_BY_PROJECT_ID; command.Parameters.Add(new SqlParameter("@ProjectId", projectId)); using (var dataReader = command.ExecuteReader()) { while (dataReader.Read()) { result.Add(ModelConverter.GetPhrase(dataReader)); } } } } return(result); }
public IActionResult Modify(ModifyCurrentUserModel model) { if (!AuthorizeService.AuthorizeUser(User, model.Id)) { return(RedirectToAction("AccessDenied", "Auth")); } else { if (ModelState.IsValid) { User user = ModelConverter.ConvertFromUserModifyCurrnetUserModel(model); Response response = UserService.UpdateUser(user); if (response.IsSuccessful) { return(RedirectToAction("Success")); } else { ModelState.AddModelError(string.Empty, response.Message); return(View(model)); } } else { return(View(model)); } } }
public List <Phrase> ReadAll() { var result = new List <Phrase>(); using (var connection = new SqlConnection(_connectionString)) { connection.Open(); using (var command = new SqlCommand()) { command.Connection = connection; command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = DbStrings.PHRASES_READ_ALL; using (var dataReader = command.ExecuteReader()) { while (dataReader.Read()) { result.Add(ModelConverter.GetPhrase(dataReader)); } } } } return(result); }
public IActionResult EditCompany(EditCompanyViewmodel model) { var company = new Company(model.CompanyID, model.CompanyName); _companyHandler.Update(ModelConverter.ConvertModelToCompanyDto(company)); return(RedirectToAction("ListCompanies")); }
public IActionResult EditUsersInCompany(string companyId) { ViewBag.companyId = companyId; var company = ModelConverter.ConvertCompanyDtoToModel(_companyHandler.GetById(companyId)); if (company == null) { throw new Exception("Company not found"); } var model = new List <UserRoleViewModel>(); foreach (var user in _userManager.Users) { var userRoleViewModel = new UserRoleViewModel() { UserId = user.Id, UserName = user.UserName }; userRoleViewModel.IsSelected = _companyHandler.CheckIfEmployeeInCompany(user.Id, company.CompanyId); model.Add(userRoleViewModel); } return(View(model)); }
public void Add(ProductModel model) { var product = ModelConverter.Create(model); _context.Products.Add(product); _context.SaveChanges(); }
public void SortByRatingTestAscending() { string order = "asc"; List <Models.Restaurant> testRestaurants = new List <Models.Restaurant>(); testRestaurants.Add(test1); testRestaurants.Add(test2); testRestaurants.Add(test3); testRestaurants.Add(test4); testRestaurants.Add(test5); testRestaurants.Add(test6); int expected = testRestaurants[0].ID; List <RestaurantReviewData.Restaurant> convertedList = new List <RestaurantReviewData.Restaurant>(); foreach (Models.Restaurant mr in testRestaurants) { convertedList.Add(ModelConverter.ResObjToDB(mr)); } List <RestaurantReviewData.Restaurant> expectedList = new List <RestaurantReviewData.Restaurant>(); foreach (RestaurantReviewData.Restaurant dbr in testManager.SortByRating(order, convertedList)) { expectedList.Add(dbr); } int actual = expectedList[0].ID; Assert.AreEqual(expected, actual); }
public void AverageforCategoryTestYearIncams() { var jsonArray = TestsHelper.GetJonsArrayFromFile("TransactionsArray.json"); List <AccountMovement> accountMovements = ModelConverter.GetAccountMovmentsFromJarray(jsonArray); accountMovements.Count.Should().Be(122); jsonArray = TestsHelper.GetJonsArrayFromFile("CategoriesArray.json"); List <SubCategory> categorisModel = ModelConverter.GetCategoriesFromJarray(jsonArray); categorisModel.Count.Should().Be(105); var modementsViewModels = ModelConverter.CreateMovementsViewModels(accountMovements, categorisModel, "Felles"); modementsViewModels[0].Category.Should().BeEquivalentTo("Altibox"); string category = "Mat"; int? year = null; int? month = null; bool justExtrations = false; var average = ModelOperation.AverageforCategory(modementsViewModels, category, 2017, month, justExtrations); average.Should().Be(117.5); }
public ActionResult Edit(EditProjectSourceTypeModel model) { if (!ModelState.IsValid) { return(Redirect(Url.ProjectSourceType_Edit(model.Id))); } ProjectSourceTypeObj obj; if (!model.Id.HasValue) { obj = ModelConverter.Convert(model); obj.Id = ProjectSourceTypeLogic.Create(obj, CurrentUserName); if (obj.Id == -1) { this.AddError("CreatingProjectSourceType", "There was an error creating your ProjectSourceType. If this continues contact support."); return(Redirect(Url.ProjectSourceType_Create())); } } else { obj = ModelConverter.Convert(model); var success = ProjectSourceTypeLogic.Update(obj, CurrentUserName); if (!success) { this.AddError("UpdatingProjectSourceType", "There was an error updating your ProjectSourceType. If this continues contact support."); return(Redirect(Url.ProjectSourceType_Edit(model.Id.Value))); } } return(Redirect(Url.ProjectSourceType_Show(obj.Id.Value))); }
public IActionResult Modify(int id) { BlogComment blogComment = BlogCommentService.GetById(id); ModifyCommentModel model = ModelConverter.ConvertToModifyCommentModel(blogComment); return(View(model)); }
public IActionResult Details(int id) { var recipe = RecipesService.GetRecipeDetails(id); var sidebarData = RecipesService.GetSidebarData(); var recipeDetails = ModelConverter.ConvertToRecipeDetailsModel(recipe); recipeDetails.SidebarData = sidebarData; if (User.Identity.IsAuthenticated) { var userId = Convert.ToInt32(User.FindFirst("Id").Value); var currentLike = recipeDetails.RecipeLikes.FirstOrDefault(x => x.UserId == userId); if (currentLike != null) { if (currentLike.Status) { recipeDetails.LikeStatus = RecipeLikeStatus.Liked; } else { recipeDetails.LikeStatus = RecipeLikeStatus.Disliked; } } } return(View(recipeDetails)); }
public void Convert_WithNoConveter_ShouldThrowException() { var factory = new Mock<IConverterFactory>(); factory.Setup(x => x.Create<CustomerRequest, Customer>()).Throws<Exception>(); var sut = new ModelConverter(factory.Object); Should.Throw<Exception>( () => { var customer = sut.Convert<CustomerRequest, Customer>(new CustomerRequest()); }); }
public void Convert_WithDestinationAndDynamic_ShouldNotBeNull() { var factory = new Mock<IConverterFactory>(); factory.Setup(x => x.Create<CustomerRequest, Customer>()).Returns(new CustomerRequestCustomerConverter()); var sut = new ModelConverter(factory.Object); var customer = sut.Convert(new CustomerRequest(), new Customer(), new {}); customer.ShouldNotBeNull(); customer.ShouldBeOfType<Customer>(); }