public AuthorsList GetList()
{
AuthorsList authors = new AuthorsList();
SqlDataReader reader = null;
try
{
SqlCommand command = _connection.CreateCommand();
command.CommandText = "SELECT * FROM Authors";
reader = command.ExecuteReader();
while (reader.Read())
{
authors.Add(new Author((String)reader["FirstName"], (String)reader["LastName"]));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ooops", MessageBoxButton.OK);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
return(authors);
}
private void button2_Click(object sender, EventArgs e)
{
BookServiceUtilJSON bookservice = new BookServiceUtilJSON("bookserviceaseece.azurewebsites.net", "", "api");
//Test Author metoder
AuthorsList alist = bookservice.GetAuthors();
this.textBox1.Text = alist.Authors[alist.Authors.Count - 1].Name;
}
/*
* Author metoder
*/
public AuthorsList GetAuthors()
{
AuthorsList al = new AuthorsList(); //AuthorsList er en Wrapper model klasse der indpakker en List<Author> liste
APIGetJSON <List <Author> > authlist = new APIGetJSON <List <Author> >(fullservicepath + "Authors");
al.Authors = authlist.data;
return(al);
}
private void DefaultParametrs(ContractEF contract = null, bool refresh = false)
{
if (!refresh)
{
archiveManager = new ArchiveManager(dataManager);
BanksList = DataBaseClient.ReadBanks();
ContractTypesList = DataBaseClient.ReadContractTypes();
CurrenciesList = DataBaseClient.ReadCurrencies();
BrokersList = DataBaseClient.ReadBrokers();
AuthorsList = DataBaseClient.ReadTraders();
RangeList = new List <string>();
RangeList.Add("От 1 ");
RangeList.Add("От 20.000 тсч.");
RangeList.Add("От 1.000.000 млн.");
RangeList.Add("От 5.000.000 млн.");
RangeList.Add("От 10.000.000 млн.");
RangeList.Add("От 15.000.000 млн.");
RangeList.Add("От 25.000.000 млн.");
RangeList.Add("От 40.000.000 млн.");
RangeList.Add("От 50.000.000 млн.");
RangeList.Add("От 75.000.000 млн.");
RangeList.Add("От 100.000.000 млн.");
RangeList.Add("От 1.000.000.000 млрд.");
SelectedRange = RangeList[0];
ScanTypesList = new List <string>();
ScanTypesList.Add("Копия");
ScanTypesList.Add("Оригинал");
}
if (contract == null)
{
Contract = new ContractEF();
Contract.companyid = companyId;
Contract.agreementdate = DateTime.Now;
SelectedContractType = ContractTypesList[0];
SelectedCurrency = CurrenciesList[0];
SelectedScanType = ScanTypesList[0];
}
else
{
try {
if (contract.bankid != null)
{
SelectedBank = BanksList.Where(x => x.id == contract.bankid).FirstOrDefault();
SearchTxt = SelectedBank.name;
}
SelectedContractType = ContractTypesList.Where(x => x.id == (contract.contracttypeid == null ? 1 : contract.contracttypeid)).FirstOrDefault();
SelectedCurrency = CurrenciesList.Where(x => x.id == contract.currencyid).FirstOrDefault();
SelectedBroker = BrokersList.Where(x => x.id == contract.brokerid).FirstOrDefault();
RatesList = new ObservableCollection <RatesListEF>(DataBaseClient.ReadRatesList(Contract.id));
SelectedAuthor = AuthorsList.FirstOrDefault(a => a.id == (contract.authorid == null ? 1 : contract.authorid));
SelectedScanType = ScanTypesList[(contract.scantype == null ? 0 : (int)contract.scantype)];
} catch (Exception) { }
}
}
public IActionResult CreateBook(IEnumerable <int> AuthorIds, IEnumerable <int> CategoryIds,
CreateUpdateBookViewModel bookToCreate)
{
using (var client = new HttpClient())
{
var book = new Book()
{
Id = bookToCreate.Book.Id,
Isbn = bookToCreate.Book.Isbn,
Title = bookToCreate.Book.Title,
DatePublished = bookToCreate.Book.DatePublished
//books?authId=?&authId=?&catId=?
};
var uriParameters = GetAuthorsCategoriesUri(AuthorIds.ToList(), CategoryIds.ToList());
client.BaseAddress = new Uri("http://localhost:60039/api/");
var responseTask = client.PostAsJsonAsync($"books?{uriParameters}", book);
responseTask.Wait();
var result = responseTask.Result;
if (result.IsSuccessStatusCode)
{
var readTaskNewBook = result.Content.ReadAsAsync <Book>();
readTaskNewBook.Wait();
var newBook = readTaskNewBook.Result;
TempData["SuccessMessage"] = $"Book {book.Title} was successfully created.";
return(RedirectToAction("GetBookById", new { bookId = newBook.Id }));
}
if ((int)result.StatusCode == 422)
{
ModelState.AddModelError("", "ISBN already Exists!");
}
else
{
ModelState.AddModelError("", "Error! Book not created!");
}
}
var authorList = new AuthorsList(_authorRepository.GetAuthors().ToList());
var categoryList = new CategoriesList(_categoryRepository.GetCategories().ToList());
bookToCreate.AuthorSelectListItems = authorList.GetAuthorsList(AuthorIds.ToList());
bookToCreate.CategorySelectListItems = categoryList.GetCategoriesList(CategoryIds.ToList());
bookToCreate.AuthorIds = AuthorIds.ToList();
bookToCreate.CategoryIds = CategoryIds.ToList();
return(View(bookToCreate));
}
public IActionResult Edit(List <int> authorIds, List <int> categoryIds,
CreateUpdateBookViewModel bookToUpdate)
{
using (var client = new HttpClient())
{
var bookDto = new Book()
{
Id = bookToUpdate.Book.Id,
Title = bookToUpdate.Book.Title,
Isbn = bookToUpdate.Book.Isbn,
DatePublish = bookToUpdate.Book.DatePublish
};
var uriParameters = GetAuthorsCategoriesUri(authorIds.ToList(), categoryIds.ToList());
client.BaseAddress = new Uri("http://localhost:5000/api/");
var responseTask = client.PutAsJsonAsync($"books/{bookDto.Id}?{uriParameters}", bookDto);
responseTask.Wait();
var result = responseTask.Result;
if (result.IsSuccessStatusCode)
{
TempData["SuccessMessage"] = $"Book {bookDto.Title} was successfully updated.";
return(RedirectToAction("GetBookById", new { bookId = bookDto.Id }));
}
if ((int)result.StatusCode == 422)
{
ModelState.AddModelError("", "ISBN already exists!");
}
else
{
ModelState.AddModelError("", "Error! Book not updated.");
}
}
var authorList = new AuthorsList(authorRepository.GetAuthors().ToList());
var categoryList = new CategoriesList(categoryRepository.GetCategories().ToList());
bookToUpdate.AuthorSelectListItems = authorList.GetAuthorsList(authorIds.ToList());
bookToUpdate.CategorySelectListItems = categoryList.GetCategories(categoryIds.ToList());
bookToUpdate.AuthorIds = authorIds.ToList();
bookToUpdate.CategoryIds = categoryIds.ToList();
return(View(bookToUpdate));
}
private void Initialize()
{
addBookPresenter = new AddBookPresenter(libraryPresenter);
addBookPresenter.CompleteAuthorList(comboBoxAuthors);
addBookPresenter.CompleteCategoriesList(comboBoxCategiries);
authorList = new AuthorsList(libraryPresenter);
categoriesListControler = new CategoriesList(libraryPresenter);
AuthorListPresenter AuthorPresenter = new AuthorListPresenter(libraryPresenter, authorList);
panelAuthorControl.Controls.Add(authorList);
panelCategoryControler.Controls.Add(categoriesListControler);
textBoxSelectedAuthors.AutoSize = true;
}
public IActionResult UpdateBook(int bookId)
{
var bookDto = _bookRepository.GetBookById(bookId);
var authorList = new AuthorsList(_authorRepository.GetAuthors().ToList());
var categoryList = new CategoriesList(_categoryRepository.GetCategories().ToList());
var bookViewBook = new CreateUpdateBookViewModel
{
Book = bookDto,
AuthorSelectListItems = authorList.GetAuthorList(_authorRepository.GetAuthorOfABook(bookId)
.Select(a => a.Id).ToList()),
CategoriesSelectListItems = categoryList.GetCategoryList(_categoryRepository.GetAllCategoriesOfABook(bookId)
.Select(c => c.Id).ToList())
};
return(View(bookViewBook));
}
public IActionResult Edit(int bookId)
{
var bookDto = bookRepository.GetBookById(bookId);
var authorDto = new AuthorsList(authorRepository.GetAuthors().ToList());
var categoryDto = new CategoriesList(categoryRepository.GetCategories().ToList());
var bookViewModel = new CreateUpdateBookViewModel()
{
Book = bookDto,
AuthorSelectListItems = authorDto.GetAuthorsList(authorRepository.GetAllAuthorsFromBook(bookId).
Select(a => a.Id).ToList()),
CategorySelectListItems = categoryDto.GetCategories(categoryRepository.GetCategoriesFromBook(bookId).
Select(a => a.Id).ToList())
};
return(View(bookViewModel));
}
private void DataGrid_Loaded()
{
DBClass.openConnection();
DBClass.sql = "select * from authors";
DBClass.cmd.CommandType = CommandType.Text;
DBClass.cmd.CommandText = DBClass.sql;
DBClass.da = new SqlDataAdapter(DBClass.cmd);
DBClass.dt = new DataTable();
DBClass.da.Fill(DBClass.dt);
// wyciągamy dane
int i = 0;
int j = 0;
AuthorsList.Clear();
using (SqlDataReader reader = DBClass.cmd.ExecuteReader())
{
while (reader.Read())
{
for (j = 0; j <= reader.FieldCount - 1; j++) // Looping throw colums
{
data[j] = reader.GetValue(j).ToString();
}
AuthorsList.Add(new AuthorModel
{
Id = Int32.Parse(data[0]),
FirstNameAuthor = data[1],
LastNameAuthor = data[2]
});
}
}
DBClass.closeConnection();
try
{
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
public IActionResult CreateBook()
{
var authors = authorRepository.GetAuthors();
var categories = categoryRepository.GetCategories();
if (authors.Count() <= 0 || categories.Count() <= 0)
{
ModelState.AddModelError("", "Some kind or error getting authors or categories");
}
var authorList = new AuthorsList(authors.ToList());
var categoryList = new CategoriesList(categories.ToList());
var createUpdateBook = new CreateUpdateBookViewModel {
AuthorSelectListItems = authorList.GetAuthorsList(),
CategorySelectListItems = categoryList.GetCategories()
};
return(View(createUpdateBook));
}
public void UploadDocumentParams(Document document)
{
this.document = document;
DocumentName = document.name;
DocumentNumber = document.number;
SelectedDocumentType = DocumentTypesList.First(d => d.id == document.type);
SelectedBroker = BrokersList.First(b => b.ShortName == document.broker);
if (CompaniesStorageList.Count(c => c.name.ToLower().Contains(document.company.ToLower())) > 0)
{
SelectedCompany = CompaniesStorageList.First(c => c.name.ToLower().Contains(document.company.ToLower()));
}
SearchCompanyTxt = document.company;
SelectedAuthor = AuthorsList.FirstOrDefault(a => a.name == document.author);
if (SelectedAuthor == null)
{
SelectedAuthor = AuthorsList.First(a => a.name.ToLower().Contains("не наз"));
}
DocumentDate = document.createdDate;
DocumentDescription = document.description;
if (CurrentPresentation == PresentationEnum.Archive)
{
DocumentYear = document.year;
DocumentCase = document.case_;
DocumentVolume = document.volume;
DocumentSerialNumber = document.serialNumber == null ? 0 : (int)document.serialNumber;
}
AttachedDocument = DataManagerService.Instanse().ReadDocumentLink(document.id);
if (!string.IsNullOrEmpty(AttachedDocument))
{
IsAttach = true;
}
}
public void testBookService()
{
BookServiceUtilJSON bookservice = new BookServiceUtilJSON("bookserviceaseece.azurewebsites.net", "", "api");
//Test Author metoder
AuthorsList alist = bookservice.GetAuthors();
Author a = new Author()
{
Id = 2
};
a = bookservice.GetAuthor(a);
Author ath = bookservice.GetAuthor(a);
ath.Name = "Peter Petersen";
ath = bookservice.PostAuthor(ath);
ath.Name = ath.Name + "Nielsen";
bookservice.PutAuthor(ath);//No return of data as the copi comes from Requester/Client
ath = bookservice.DeleteAuthor(ath);
//Test Book metoder
Book abook = new Book()
{
Author = a, AuthorId = a.Id, Genre = "Vrøvl og Snak", Price = 45, Title = "Det dur bare", Year = 2016
};
Book nbook = bookservice.PostBook(abook);
BooksList bkl = bookservice.GetBooks();
//System.Console.WriteLine("Bog der skal slette indtast ID:");
//int i = Int32.Parse(System.Console.ReadLine());
Book bk = new Book()
{
Id = nbook.Id
};
Book gbk = bookservice.GetBook(bk);
gbk.Title = gbk.Title + " Extra Tekst";
bookservice.PutBook(gbk);
bookservice.DeleteBook(gbk);
}
/// <summary>
/// This method adds all the article info to the entry
/// </summary>
/// <param name="showEntryData">A flag that states whether or not to add the entry data to the XML</param>
/// <param name="showPageAuthors">A flag to state whether or not to add the authors list to the XML</param>
/// <param name="parentNode">The node that you want to insert the article info block</param>
/// <returns>The node that represents the articleinfo block</returns>
private XmlNode AddArticleInfo(bool showEntryData, bool showPageAuthors, XmlNode parentNode)
{
// Now add the article info block
XmlNode articleInfoNode = AddElementTag(parentNode, "ARTICLEINFO");
// Check to see if we are needed to add the entry data
if (showEntryData)
{
AddEntryData(articleInfoNode);
}
AddIntElement(articleInfoNode, "FORUMID", _forumID);
AddIntElement(articleInfoNode, "SITEID", _siteID);
if (_hiddenStatus > 0)
{
AddIntElement(articleInfoNode, "HIDDEN", _hiddenStatus);
}
XmlNode modNode = AddIntElement(articleInfoNode, "MODERATIONSTATUS", _moderationStatus);
AddAttribute(modNode, "ID", _h2g2ID);
// Add the page authors if we've been asked to
if (showPageAuthors)
{
// Create the authors list and add it to the page
AuthorsList pageAuthors = new AuthorsList(InputContext, AuthorsList.ArticleType.ARTICLE, _h2g2ID, _editor);
pageAuthors.CreateListForArticle();
XmlNode authorsNode = AddElementTag(articleInfoNode, "PAGEAUTHOR");
AddInside(authorsNode, pageAuthors, "//RESEARCHERS");
AddInside(authorsNode, pageAuthors, "//EDITOR");
}
// Add the date created and last update
XmlNode createdNode = AddElementTag(articleInfoNode, "DATECREATED");
createdNode.AppendChild(DnaDateTime.GetDateTimeAsElement(RootElement.OwnerDocument, _dateCreated, true));
XmlNode updatedNode = AddElementTag(articleInfoNode, "LASTUPDATED");
updatedNode.AppendChild(DnaDateTime.GetDateTimeAsElement(RootElement.OwnerDocument, _lastUpdated, true));
// Create the Article crumbtrail
Category articleCrumbtrail = new Category(InputContext);
articleCrumbtrail.CreateArticleCrumbtrail(_h2g2ID);
AddInside(articleInfoNode, articleCrumbtrail, "//CRUMBTRAILS");
// Insert a related member node and the preprocessed info
XmlNode relatedMembersNode = AddElementTag(articleInfoNode, "RELATEDMEMBERS");
AddIntElement(articleInfoNode, "PREPROCESSED", _preProcessed);
// Create the related clubs
Category relatedMembers = new Category(InputContext);
relatedMembers.GetRelatedClubs(_h2g2ID);
AddInside(relatedMembersNode, relatedMembers, "//RELATEDCLUBS");
// Create the related articles
relatedMembers.IncludeStrippedNames = true;
relatedMembers.GetRelatedArticles(_h2g2ID);
AddInside(relatedMembersNode, relatedMembers, "//RELATEDARTICLES");
// Return the new article info node
return articleInfoNode;
}
public static void RebuildAuthorsList()
{
// TODO: layouts
AuthorsList.ReplaceEverythingBy(from o in AuthorInformationObjects select o.Author);
}
public AuthorListPresenter(ILibraryPresenter libraryPresenter, AuthorsList authorsList)
{
this.libraryPresenter = libraryPresenter;
this.authorsList = authorsList;
}
