public async Task <int> ImportFromExcelAsync(List <ExcelUsefulLinkViewModel> list)
{
var entities = new List <UsefulLink>(list.Count);
foreach (var viewModel in list)
{
var entity = new UsefulLink()
{
Id = viewModel.Id,
Name = viewModel.Name,
Link = viewModel.Link,
Order = viewModel.Order,
Description = viewModel.Description,
IsShow = viewModel.IsShow,
};
entities.Add(entity);
}
await _usefulLinks.AddRangeAsync(entities);
var result = await _unitOfWork.SaveChangesAsync();
return(result);
}
public async Task <ActionResult> Create(UsefulLink usefulLink, int?id)
{
try
{
var matchingConcept = await _context.Concepts.FirstOrDefaultAsync(c => c.Id == id);
var user = await GetCurrentUserAsync();
var useful = new UsefulLink();
useful.Title = usefulLink.Title;
useful.Link = usefulLink.Link;
useful.ConceptId = id;
useful.ApplicationUserId = user.Id;
useful.Concept = matchingConcept;
_context.UsefulLinks.Add(useful);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index), "Concepts", new { id = useful.Concept.SoftwareLanguageId }));
}
catch
{
return(View());
}
}
public async Task WhenAdd_NumberOfRecordsShouldIncrease()
{
//arange
var options = new DbContextOptionsBuilder <GravityGymDbContext>()
.UseInMemoryDatabase(databaseName: "Add_UsefulLinks")
.Options;
using (var ctx = new GravityGymDbContext(options))
{
ctx.UsefulLinks.AddRange(_usefulLinks);
ctx.SaveChanges();
}
using (var ctx = new GravityGymDbContext(options))
{
var usefulLinkRepo = new UsefulLinksRepository(ctx, _mapperMoq.Object);
var ul = new UsefulLink {
Id = 5L, Description = "some description 5", Link = "https://amdaris.com/"
};
//act
await usefulLinkRepo.AddAsync(ul);
var result = await usefulLinkRepo.GetAllAsync();
//assert
Assert.Greater(result.Count, _usefulLinks.Count);
}
}
public ActionResult DeleteConfirmed(int id)
{
UsefulLink link = _unitOfWork.UsefulLinks.GetById(id);
_unitOfWork.UsefulLinks.Delete(link);
_unitOfWork.Commit();
return(RedirectToAction("Index"));
}
public UsefulLinkViewModel(UsefulLink usefulLink)
{
Id = usefulLink.Id;
Name = usefulLink.Name;
Link = usefulLink.Link;
Order = usefulLink.Order;
IsShow = usefulLink.IsShow;
Description = usefulLink.Description;
}
// GET: Admin/UsefulLinks/Delete/5
public ActionResult Delete(int id)
{
UsefulLink link = _unitOfWork.UsefulLinks.GetById(id);
if (link == null)
{
return(HttpNotFound());
}
return(View(link));
}
public ActionResult Edit([Bind(Include = "LinkId,Name,Description,URL")] UsefulLink link)
{
if (ModelState.IsValid)
{
_unitOfWork.UsefulLinks.Update(link);
_unitOfWork.Commit();
return(RedirectToAction("Index"));
}
return(View(link));
}
/// <summary>
/// Maps <paramref name="addUsefulLinkDTO"/> to <c><b>Useful Link</b></c> object and adds that product to repository.
/// </summary>
/// <param name="addUsefulLinkDTO">Useful Link to be added.</param>
/// <returns></returns>
public async Task AddUsefulLinkAsync(AddUsefulLinkDTO addUsefulLinkDTO)
{
var usefullink = new UsefulLink
{
Title = addUsefulLinkDTO.Title,
Description = addUsefulLinkDTO.Description,
Url = addUsefulLinkDTO.Url,
ProfessionId = addUsefulLinkDTO.ProfessionId
};
await _usefulLinkRepository.AddAsync(usefullink).ConfigureAwait(false);
}
public ActionResult Create(UsefulLink link)
{
try
{
_unitOfWork.UsefulLinks.Add(link);
_unitOfWork.Commit();
return(RedirectToAction("List"));
}
catch
{
return(View());
}
}
public async Task <ActionResult> Create(int?id)
{
//if (ModelState.IsValid)
//{
// _context.Add(usefulLink);
// await _context.SaveChangesAsync();
// return RedirectToAction(nameof(Index), "Concepts", new { area = "" });
//}
var matchingConcept = await _context.Concepts.FirstOrDefaultAsync(c => c.Id == id);
var link = new UsefulLink();
link.Concept = matchingConcept;
return(View(link));
}
public async Task <bool> InsertAsync(UsefulLinkViewModel viewModel)
{
var entity = new UsefulLink()
{
Id = viewModel.Id,
Name = viewModel.Name,
Link = viewModel.Link,
Order = viewModel.Order,
Description = viewModel.Description,
IsShow = viewModel.IsShow,
};
await _usefulLinks.AddAsync(entity);
var result = await _unitOfWork.SaveChangesAsync();
return(result != 0);
}
public IActionResult AddUsefulLink(UsefulLink usefulLink)
{
var personalProfile = _context.PersonalProfiles
.Where(x => x.LoginName == User.Identity.Name)
.SingleOrDefault();
usefulLink.PersonalProfile = personalProfile;
_context.Add(usefulLink);
_context.SaveChanges();
var usefulLinks = _context.UsefulLinks
.Where(x => x.PersonalProfile == personalProfile);
return(Json(usefulLinks));
}
public async Task <ActionResult> Delete(int id, UsefulLink usefulLink)
{
try
{
var matchingLink = await _context.UsefulLinks
.Include(ml => ml.Concept)
.FirstOrDefaultAsync(ml => ml.Id == id);
var matchingSoftwareLangId = matchingLink.Concept.SoftwareLanguageId;
_context.UsefulLinks.Remove(matchingLink);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index), "Concepts", new { id = matchingSoftwareLangId }));
// TODO: Add delete logic here
}
catch
{
return(View());
}
}
public void CreateUsefulLink(UsefulLink link)
{
this._unitOfWork.UsefulLinks.Add(link);
SaveChanges();
}
public void Update(UsefulLink link)
{
this._context.Entry(link);
}
public void Delete(UsefulLink link)
{
this._context.UsefulLinks.Remove(link);
}
public void Add(UsefulLink link)
{
this._context.UsefulLinks.Add(link);
}
// GET: Admin/UsefulLinks/Create
public ActionResult Create()
{
var link = new UsefulLink();
return(View(link));
}
public async Task <IActionResult> Post([FromBody] UsefulLink usefulLink)
{
var link = await _usefulLinksRepository.AddAsync(usefulLink);
return(Ok(link));
}
public void UpdateUsefulLink(UsefulLink link)
{
this._usefulLinkRepository.Update(link);
SaveChanges();
}
