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>();
}
