protected override void DoJob()
{
MagazineRepository rep = new MagazineRepository(OpConn);
string query = string.Format("DELETE FROM Magazine WHERE MagazineId = {0}", magazineId);
rep.BsExecute(query);
}
public void Setup()
{
_mockIReader = new Mock <IReader>();
_mockAuthorIDataRepository = new Mock <IDataRepository <Author> >();
_mockMagazineIDataRepository = new Mock <IDataRepository <Magazine> >();
_magazineRepository = new MagazineRepository(_mockIReader.Object, _mockAuthorIDataRepository.Object);
}
protected override void DoJob()
{
MagazineRepository rep = new MagazineRepository(OpConn);
string query = string.Format("UPDATE Magazine SET MagazineName = '{0}' WHERE MagazineId = {1}", magazine.MagazineName, magazine.MagazineId);
rep.BsExecute(query);
}
public IHttpActionResult ModifyMagazineProduct(int id, int count)
{
using (var repository = new MagazineRepository())
{
repository.Update(id, count);
}
return(Ok());
}
public IEnumerable <MagazineEntry> GetAllProducts()
{
using (var repository = new MagazineRepository())
{
var a = repository.GetAll().ToList();
return(a);
}
}
protected override void DoJob()
{
MagazineRepository rep = new MagazineRepository(OpConn);
string query = string.Format("DELETE FROM MagazineDate WHERE MagazineId = {0} AND Date = '{1}'",
obj.MagazineId, obj.Date.ToString("yyyy-MM-dd"));
rep.BsExecute(query);
}
public IHttpActionResult RemoveMagazineProduct(int id)
{
using (var repository = new MagazineRepository())
{
if (repository.Remove(id) == false)
{
return(BadRequest());
}
}
return(Ok());
}
public IHttpActionResult AddMagazineProduct(string name, int count, string localization)
{
using (var repository = new MagazineRepository())
{
var entry = new MagazineEntry();
entry.Name = name;
entry.Count = count;
entry.Localization = localization;
repository.Add(entry);
}
return(Ok());
}
public MagazineService()
{
_applicationContext = new ApplicationContext();
_magazineRepository = new MagazineRepository(_applicationContext);
_publishingHouseRepository = new PublishingHouseRepository(_applicationContext);
_publicationInPublisihngHouseRepository = new PublicationInPublisihngHouseRepository(_applicationContext);
_publicationRepository = new PublicationRepository(_applicationContext);
_publicationInPublisihngHouses = _publicationInPublisihngHouseRepository.Get(/*includeProperties: "PublishingHouse, Publication"*/).ToList();
_magazines = _magazineRepository.Get(includeProperties: "Publication").ToList();
_publishingHouses = _publishingHouseRepository.Get().ToList();
_publications = _publicationRepository.Get().ToList();
}
public IHttpActionResult Synchronize()
{
bool success = true;
try
{
using (var repository = new MagazineRepository())
{
var listOfMagazineEntries = repository.GetAll();
for (int i = 0; i < SERVICE_URLS.Length; i++)
{
IList <UnitEntry> list;
try
{
var client = GetWebClient(SERVICE_URLS[i]);
list = client.Unit.GetAllProducts();
}
catch (HttpRequestException e)
{
Console.WriteLine("Cannot connect to the " + SERVICE_LOCATIONS[i] + "reason: " + e.ToString());
continue;
}
var entiresToRemove = listOfMagazineEntries.Where(x => x.Localization == SERVICE_LOCATIONS[i]);
_log.InfoFormat("entiresToRemove");
foreach (var entry in entiresToRemove)
{
_log.InfoFormat($"{entry.Id.ToString()}");
repository.Remove(entry.Id);
}
foreach (var unitEntry in list)
{
MagazineEntry entry = new MagazineEntry(unitEntry.Name, unitEntry.Count.GetValueOrDefault(), SERVICE_LOCATIONS[i]);
repository.Add(entry);
}
}
synchronize = true;
}
}
catch (System.Net.Http.HttpRequestException e)
{
success = false;
synchronize = false;
}
if (success)
{
return(Ok());
}
return(InternalServerError(new Exception("Cannot connect to unit webservice")));
}
public void TestGetAllMagazines()
{
// Arrange
_magazineRepository = new MagazineRepository();
// Act
var result = _magazineRepository.GetAllMagazines();
var count = result.Count;
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(6, count);
}
public GeneralService()
{
_applicationContext = new ApplicationContext();
_bookRepository = new BookRepository(_applicationContext);
_magazineRepository = new MagazineRepository(_applicationContext);
_brochureRepository = new BrochureRepository(_applicationContext);
_publishingHouseRepository = new PublishingHouseRepository(_applicationContext);
_publicationInPublisihngHouseRepository = new PublicationInPublisihngHouseRepository(_applicationContext);
_publicationRepository = new PublicationRepository(_applicationContext);
_publicationInPublisihngHouses = _publicationInPublisihngHouseRepository.Get().ToList();
_books = _bookRepository.Get(includeProperties: "Publication").ToList();
_publishingHouses = _publishingHouseRepository.Get().ToList();
_publications = _publicationRepository.Get().ToList();
}
public LibraryService()
{
_authorRepository = new AuthorRepository();
_bookRepository = new BookRepository();
_magazineRepository = new MagazineRepository();
//fill all models from data
_authorsList = _authorRepository.GetAllAuthors();
_booksList = _bookRepository.GetAllBooks();
_magazinesList = _magazineRepository.GetAllMagazines();
//fill authors data from author data into author objects in books and magazines
_booksList.ForEach(m => m.Authors.ForEach(a => a.FillAuthorName(_authorsList.FirstOrDefault(f => f.Email == a.Email)?.FullName)));
_magazinesList.ForEach(m => m.Authors.ForEach(a => a.FillAuthorName(_authorsList.FirstOrDefault(f => f.Email == a.Email)?.FullName)));
}
public IHttpActionResult RemoveAllMagazineProducts()
{
using (var repository = new MagazineRepository())
{
var products = repository.GetAll();
foreach (var product in products)
{
if (repository.RemoveAll() == false)
{
return(BadRequest());
}
}
}
return(Ok());
}
protected override void DoJob()
{
MagazineRepository rep = new MagazineRepository(OpConn);
if (string.IsNullOrEmpty(magazineName))
{
throw new BsException("Boş girilemez", OpType.UserError);
}
List <Magazine> magazineList = rep.GetList();
if (magazineList.Any(mag => mag.MagazineName == magazineName))
{
throw new BsException("Zaten mevcut kayıt", OpType.UserError);
}
string query = string.Format("INSERT INTO Magazine (MagazineName) VALUES ('{0}')", magazineName);
rep.BsExecute(query);
}
public MagazineService(EFDbContext context)
{
this.context = context;
magazineRepository = new MagazineRepository(context);
}
public PublicationService(BookRepository bookRepository, MagazineRepository magazineRepository, BrochureRepository brochureRepository)
{
_bookRepository = bookRepository;
_magazineRepository = magazineRepository;
_brochureRepository = brochureRepository;
}
public MagazineService()
{
_magazineRepository = new MagazineRepository();
}
public PublicationsService()
{
_bookRepository = new BookRepository();
_magazineRepository = new MagazineRepository();
_brochureRepository = new BrochureRepository();
}
public MagazineService(MagazineRepository magazineRepository)
{
_magazineRepository = magazineRepository;
}
public MagazineService(ApplicationContext context)
{
_magazineRepository = new MagazineRepository <Magazine>(context);
}
public PublicationService(ApplicationContext context)
{
_bookRepository = new BookRepository <Book>(context);
_brochureRepository = new BrochureRepository <Brochure>(context);
_magazineRepository = new MagazineRepository <Magazine>(context);
}
protected override void DoJob()
{
MagazineRepository rep = new MagazineRepository(OpConn);
MagazineList = rep.GetList();
}
public LibraryService(string connection)
{
_bookRepository = new BookRepository(connection);
_brochureRepository = new BrochureRepository(connection);
_magazineRepository = new MagazineRepository(connection);
}
public MagazineService(string connection)
{
_magazineRepository = new MagazineRepository(connection);
}
