public ActionResult Upload(HttpPostedFileBase fileContent)
{
BooksRepository r = new BooksRepository();
string extension = Path.GetExtension(fileContent.FileName);
if (extension.ToLower() == ".json")
{
StreamReader sr = new StreamReader(fileContent.InputStream);
string body = sr.ReadToEnd();
//System.IO.File.AppendAllText("c:\\myfile.json", body);
//string myFileData = System.IO.File.ReadAllText("c:\\myfile.json");
//var myFileStream = System.IO.File.Open("c:\\myfile.json", FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.Read);
//var myFileStream = System.IO.File.OpenRead("c:\\myfile.json");
//StreamReader fileReader = new StreamReader(myFileStream);
//fileReader.ReadLine();
var books = JsonConvert.DeserializeObject <IEnumerable <BookModel> >(body).ToList();
foreach (BookModel b in books)
{
b.Id = 0;
r.Add(b);
}
}
else if (extension.ToLower() == ".csv")
{
StreamReader sr = new StreamReader(fileContent.InputStream);
while (!sr.EndOfStream)
{
string row = sr.ReadLine();
string[] fields = row.Split(',', ';');
BookModel b = new BookModel
{
Name = fields[0].Trim().Trim('"'),
AuthorName = fields[1].Trim().Trim('"'),
ISBN = fields[2].Trim().Trim('"'),
Year = int.Parse(fields[3].Trim().Trim('"'))
};
r.Add(b);
}
}
return(RedirectToAction("List"));
}
private static void Main(string[] args)
{
var rnd = new Random();
var booksRepo = new BooksRepository();
booksRepo.Add(
new RepoAuthor
{
FirstName = "Damon",
LastName = "German"
},
new RepoTitle
{
BookTitle = "Why it's Hard to Write Clean Code",
Copyright = "1998",
EditionNumber = 5,
ISBN = GetRandomString(rnd)
},
new RepoTitle
{
BookTitle = "Why Map is my Favorite Data Structure",
Copyright = "2007",
EditionNumber = 1,
ISBN = GetRandomString(rnd)
}
);
DisplayAuthorsAndTitles(booksRepo);
DisplayAuthorsAndISBNs(booksRepo);
}
private void CreateEdit(object sender, EventArgs e)
{
if (!CheckInputFields())
{
return;
}
if (_bookToEdit == null)
{
var newBook = new Book
{
Name = nameTextBox.Text,
Genre = (Genre)genreComboBox.SelectedItem,
NumberOfCopies = int.Parse(numberOfCopiesTextBox.Text),
NumberOfPages = int.Parse(numberOfPagesTextBox.Text),
AuthorId = ((Author)authorsListBox.SelectedItem).Id,
PublisherId = ((Publisher)publishersListBox.SelectedItem).Id,
};
_booksRepository.Add(newBook);
}
else
{
_bookToEdit.Name = nameTextBox.Text;
_bookToEdit.AuthorId = ((Author)authorsListBox.SelectedItem).Id;
_bookToEdit.PublisherId = ((Publisher)publishersListBox.SelectedItem).Id;
_bookToEdit.Genre = (Genre)genreComboBox.SelectedItem;
_bookToEdit.NumberOfPages = int.Parse(numberOfPagesTextBox.Text);
_bookToEdit.NumberOfCopies = int.Parse(numberOfCopiesTextBox.Text);
_booksRepository.Edit(_bookToEdit);
}
Close();
}
public ActionResult Add(BookModel book)
{
//bookList.Add(book);
BooksRepository r = new BooksRepository();
r.Add(book);
return(View("AddSuccess"));
}
public ActionResult Add(BookModel book)
{
BooksRepository r = new BooksRepository();
r.Add(book);
//listaCarti.Add(book);
return(View("Succes"));
}
public static void AddBook()
{
var bookRepo = new BooksRepository();
bookRepo.Add(new Book {
Title = "Som man bäddar får man ligga", ReleaseDate = new DateTime(2007, 10, 7)
});
bookRepo.Save();
Console.WriteLine("Added new book");
}
public ActionResult Upload(HttpPostedFileBase fileContent)
{
string extension = Path.GetExtension(fileContent.FileName);
if (extension.ToLower() == ".json")
{
StreamReader sr = new StreamReader(fileContent.InputStream);
string body = sr.ReadToEnd();
var books = JsonConvert.DeserializeObject <IEnumerable <BookModel> >(body).ToList();
BooksRepository r = new BooksRepository();
foreach (BookModel b in books)
{
b.Id = 0;
r.Add(b);
}
}
else if (extension.ToLower() == ".csv")
{
StreamReader sr = new StreamReader(fileContent.InputStream);
BooksRepository r = new BooksRepository();
while (!sr.EndOfStream)
{
string row = sr.ReadLine();
string[] fields = row.Split(',', ';');
BookModel b = new BookModel
{
Name = fields[0],
AuthorName = fields[1],
ISBN = fields[2],
Year = int.Parse(fields[3])
};
r.Add(b);
}
}
return(RedirectToAction("List"));
}
private void AddEditBookForm_FormClosing(object sender, FormClosingEventArgs e)
{
if (DialogResult == DialogResult.OK)
{
if (string.IsNullOrEmpty(textBoxName.Text) || string.IsNullOrEmpty(textBoxAuthor.Text))
{
MessageBox.Show("Введите название книги и автора", "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBoxName.Focus();
e.Cancel = true;
return;
}
SetDataFromControls();
if (state == AddEditFormState.Add)
{
booksRepository.Add(book);
}
else
{
booksRepository.Update(book);
}
e.Cancel = false;
}
}
// POST: api/Books
public int Post([FromBody] Book book)
{
BooksRepository booksRepo = new BooksRepository();
return(booksRepo.Add(book));
}
public int Add(Book _Book)
{
return(_BooksRepository.Add(_Book));
}
internal Book Add(Book newBook)
{
return(_repo.Add(newBook));
}
public string Add(BookRequestDTO book)
{
var message = _bookRepository.Add(book);
return(message);
}
public string get()
{
using (var ctx = new libraryContext())
{
var AuthorRepo = new AuthorRepository(ctx);
var PublisherRepo = new PublisherRepository(ctx);
var BooksRepo = new BooksRepository(ctx);
try
{
var authorFile = @"E:\OneDrive - The University of Texas at Dallas\Spring18\DB\Projects\project1\books.csv";
//var borrowerFile = "";
List <Model> list = new List <Model>();
var fileStream = new FileStream(authorFile, FileMode.Open, FileAccess.Read);
HashSet <string> authors = new HashSet <string>();
HashSet <string> publishers = new HashSet <string>();
using (var streamReader = new StreamReader(fileStream, Encoding.UTF8))
{
string line;
line = streamReader.ReadLine();
while ((line = streamReader.ReadLine()) != null)
{
var temp = line.Split('\t');
foreach (var author in temp[3].Split(','))
{
authors.Add(author);
}
publishers.Add(temp[5]);
int pages = Int16.Parse(temp[6]);
var model = new Model(temp[0], temp[2], temp[3].Split(','), temp[4], temp[5], pages);
list.Add(model);
//BooksRepo.Add(temp[0], temp[2], temp[5], Int16.Parse(temp[6]), temp[4], temp[3].Split(','));
//ctx.SaveChanges();
}
}
foreach (var author in authors)
{
AuthorRepo.Add(author);
}
foreach (var publisher in publishers)
{
PublisherRepo.Add(publisher);
}
ctx.SaveChanges();
var count = 0;
foreach (var item in list)
{
count++;
BooksRepo.Add(item.isbn, item.title, item.cover, item.pages, item.publisher, item.authors);
if (count % 5000 == 0)
{
Console.Write(ctx.SaveChanges());
}
}
ctx.SaveChanges();
}
catch (Exception e)
{
return(e.Message);
}
return("Success");
}
}
