private void btnCopy_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(txtDestination.Text))
{
MessageBox.Show("Destination path is empty");
}
else if (String.IsNullOrEmpty(txtSource.Text))
{
MessageBox.Show("Source path is empty");
}
else
{
//1. Gets all the images list from SQL Server.
ImgManager mgr = new ImgManager();
List<Book> books = mgr.GetImgISBNList();
List<Book> ISBNsImg = new List<Book>();
Book bk = null;
int c_ISBN13Image = 0;
int c_ISBN10Image = 0;
int c_NoImage = 0;
//2. Goes through the list
foreach (Book book in books)
{
if (imgFiles.Contains(String.Format(@"{0}\{1}.jpg", txtSource.Text, book.ISBN13)))
{
bk = new Book(book.ISBN10, book.ISBN13, String.Format("{0}.jpg", book.ISBN13), String.Format("{0}_th.jpg", book.ISBN13));
//File.Move(String.Format(@"{0}\{1}", txtSource.Text, bk.IMAGE_NAME), String.Format(@"{0}\{1}", txtDestination.Text, bk.IMAGE_NAME));
c_ISBN13Image++;
}
else if (imgFiles.Contains(String.Format(@"{0}\{1}.jpg", txtSource.Text, book.ISBN10)))
{
bk = new Book(book.ISBN10, book.ISBN13, String.Format("{0}.jpg", book.ISBN10), String.Format("{0}_th.jpg", book.ISBN10));
//File.Move(String.Format(@"{0}\{1}", txtSource.Text, bk.IMAGE_NAME), String.Format(@"{0}\{1}", txtDestination.Text, bk.IMAGE_NAME));
c_ISBN10Image++;
}
else // No Image
{
bk = new Book(book.ISBN10, book.ISBN13, "no_image.jpg", "no_image_small.jpg");
c_NoImage++;
}
ISBNsImg.Add(bk);
}
//3. Updates DB with new entries (UBCC_SITE)
mgr.UpdateBookImg(ISBNsImg);
MessageBox.Show("Completed :), The number of books without image is: " + c_NoImage + ", with ISBN13 image is:" + c_ISBN13Image + ", and with ISBN10 is:" + c_ISBN10Image);
}
}
private void btnCopy_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(txtDestination.Text))
{
MessageBox.Show("Destination path is empty");
}
else if (String.IsNullOrEmpty(txtSource.Text))
{
MessageBox.Show("Source path is empty");
}
else
{
//1. Gets all the images list from SQL Server.
ImgManager mgr = new ImgManager();
List <Book> books = mgr.GetImgISBNList();
List <Book> ISBNsImg = new List <Book>();
Book bk = null;
int c_ISBN13Image = 0;
int c_ISBN10Image = 0;
int c_NoImage = 0;
//2. Goes through the list
foreach (Book book in books)
{
if (imgFiles.Contains(String.Format(@"{0}\{1}.jpg", txtSource.Text, book.ISBN13)))
{
bk = new Book(book.ISBN10, book.ISBN13, String.Format("{0}.jpg", book.ISBN13), String.Format("{0}_th.jpg", book.ISBN13));
//File.Move(String.Format(@"{0}\{1}", txtSource.Text, bk.IMAGE_NAME), String.Format(@"{0}\{1}", txtDestination.Text, bk.IMAGE_NAME));
c_ISBN13Image++;
}
else if (imgFiles.Contains(String.Format(@"{0}\{1}.jpg", txtSource.Text, book.ISBN10)))
{
bk = new Book(book.ISBN10, book.ISBN13, String.Format("{0}.jpg", book.ISBN10), String.Format("{0}_th.jpg", book.ISBN10));
//File.Move(String.Format(@"{0}\{1}", txtSource.Text, bk.IMAGE_NAME), String.Format(@"{0}\{1}", txtDestination.Text, bk.IMAGE_NAME));
c_ISBN10Image++;
}
else // No Image
{
bk = new Book(book.ISBN10, book.ISBN13, "no_image.jpg", "no_image_small.jpg");
c_NoImage++;
}
ISBNsImg.Add(bk);
}
//3. Updates DB with new entries (UBCC_SITE)
mgr.UpdateBookImg(ISBNsImg);
MessageBox.Show("Completed :), The number of books without image is: " + c_NoImage + ", with ISBN13 image is:" + c_ISBN13Image + ", and with ISBN10 is:" + c_ISBN10Image);
}
}
