public ActionResult EditBook(int id)
{
BookTypeRepository bookTypeRepository = new BookTypeRepository();
BookTypes bookType = bookTypeRepository.GetSingleBookType(id);
return(View("EditBook", bookType));
}
internal static void Dump(AssistantDumper assistant, BookTypes value, bool withSeparator = false)
{
assistant.IncrementDepth();
if (assistant.MaximumDepthExceeded())
return;
assistant.AddStartObject();
assistant.AddType("Dogen.TestModels.CSharpModel.BookTypes", true/*withSeparator*/);
string valueAsString = "Unsupported Value";
switch (value)
{
case BookTypes.Invalid:
valueAsString = "Invalid";
break;
case BookTypes.Great:
valueAsString = "Great";
break;
case BookTypes.NotSoGreat:
valueAsString = "NotSoGreat";
break;
case BookTypes.Bad:
valueAsString = "Bad";
break;
}
assistant.Add("value", valueAsString);
assistant.AddEndObject();
assistant.DecrementDepth();
}
public static string Dump(BookTypes value)
{
var assistant = new AssistantDumper();
Dump(assistant, value);
return(assistant.ToString());
}
/// <summary>
/// 删除
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Delete(BookTypes model)
{
using (IDbConnection conn = DataBaseConfig.GetSqlConnection(null))
{
return(conn.Delete(model));
}
}
public async Task <IActionResult> Edit(int id, [Bind("Name,Id")] BookTypes bookTypes)
{
if (id != bookTypes.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(bookTypes);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!BookTypesExists(bookTypes.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(bookTypes));
}
public BookTypes GetSingleBookType(string title)
{
string sqlString = $"SELECT * FROM BookTypes Where title = '{title}';";
BookTypes bookType = _db.Query <BookTypes>(sqlString).SingleOrDefault();
return(FillMissingImages(bookType));
}
private void btnAddBook_Click(object sender, EventArgs e)
{
Books book = new Books();
Authors author = new Authors();
book.Title = this.tbTitle.Text.ToString();
author.Name = this.tbAuthorName.Text.ToString();
author.Surname = this.tbAuthorSurname.Text.ToString();
//book.Year =
book.Description = this.tbDescription.Text.ToString();
if (comboBoxPublishers.SelectedItem == null)
{
book.Publishers = new Publishers();
book.Publishers.Name = comboBoxPublishers.Text;
}
else
{
book.Publishers = (Publishers)comboBoxPublishers.SelectedItem;
}
foreach (Types t in listBoxTypes.SelectedItems)
{
BookTypes bt = new BookTypes();
bt.Books = book;
bt.Types = t;
}
dbDataContext.Books.InsertOnSubmit(book);
dbDataContext.SubmitChanges();
addBookCopies(Convert.ToInt32(bcCount.Value), book.ID);
//this.listBox1.Items.Add(book.Title.ToString());
}
private void button1_Click_1(object sender, EventArgs e)
{
Books book = new Books();
book.Title = this.textBox1.Text.ToString();
book.Description = "Kurs programowania w języku C#";
book.Year = 2018;
if (comboBoxPublishers.SelectedItem == null)
{
book.Publishers = new Publishers();
book.Publishers.Name = comboBoxPublishers.Text;
}
else
{
book.Publishers = (Publishers)comboBoxPublishers.SelectedItem;
}
foreach (Types t in listBoxTypes.SelectedItems)
{
BookTypes bt = new BookTypes();
bt.Books = book;
bt.Types = t;
}
dbDataContext.Books.InsertOnSubmit(book);
dbDataContext.SubmitChanges();
this.listBox1.Items.Add(book.Title.ToString());
}
public static BookTypes GetBooksOfType(BookTypes bookType)
{
string sqlString = $"SELECT * FROM Book WHERE Book.BookTypes_Id = {bookType.id};";
bookType.Books = (List <Book>)Db.Query <Book>(sqlString);
return(bookType);
}
public ActionResult ViewStatus(int id)
{
BookTypeRepository bookTypeRepository = new BookTypeRepository();
BookTypes bookTypes = bookTypeRepository.GetSingleBookType(id);
return(View(bookTypes));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Create(BookTypes model)
{
using (IDbConnection conn = DataBaseConfig.GetSqlConnection(null))
{
string sql = "insert into BookTypes(TypeName,ParentId) values(@typename,@ParentId)";
return(conn.Execute(sql, model));
}
}
public Book(BookTypes Type, string AutherName, string ShortTitle, double Price, ushort Pages)
{
type = Type;
autherName = AutherName;
shortTitle = ShortTitle;
price = Price;
pages = Pages;
}
public Book(Book bk)
{
type = bk.type;
autherName = bk.autherName;
shortTitle = bk.shortTitle;
price = bk.price;
pages = bk.pages;
}
public ActionResult EditBookResult(BookTypes bookType)
{
AuthorRepository authorRepository = new AuthorRepository();
BookTypeRepository bookTypeRepository = new BookTypeRepository();
bookType.author_id = authorRepository.GetAuthorId(bookType.author.name);
bookTypeRepository.UpdateBookType(bookType);
return(View("Library", new LibraryParameters()));
}
public BookTypes GetSingleBookType(int bookTypeId)
{
string sqlString = $"SELECT * FROM BookTypes Where id = '{bookTypeId}';";
BookTypes bookType = _db.Query <BookTypes>(sqlString).SingleOrDefault();
AuthorRepository authorRepository = new AuthorRepository();
bookType.author = authorRepository.GetSingleAuthor(bookType.author_id);
return(FillMissingImages(bookType));
}
public IReadOnlyList <TESObjectBOOK> GetAllBooks(BookTypes type)
{
int ix = (int)type;
if (ix < 0 || ix >= max_booktypes)
{
return(null);
}
return(all[ix]);
}
public int GetReadCount(BookTypes type)
{
int ix = (int)type;
if (ix < 0 || ix >= max_booktypes)
{
return(0);
}
return(this.read_count[ix]);
}
private BookTypes FillMissingImages(BookTypes bookType)
{
if (bookType.coverImageURL != "NULL")
{
return(bookType);
}
Random random = new Random();
bookType.coverImageURL = _missingImageReplacements[random.Next(0, _missingImageReplacements.Length - 1)];
return(bookType);
}
public async Task <IActionResult> Create([Bind("Name,Id")] BookTypes bookTypes)
{
if (ModelState.IsValid)
{
_context.Add(bookTypes);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(bookTypes));
}
public async Task <IActionResult> Create(BookTypes bookTypes)
{
if (ModelState.IsValid)
{
_db.Add(bookTypes);
await _db.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(bookTypes));
}
public static void CreateBooks(BookTypes bookType, int quantity)
{
BookRepository bookRepository = new BookRepository();
for (int i = 0; i < quantity; i++)
{
Book newBook = new Book()
{
available = true,
BookTypes_id = bookType.id
};
bookRepository.InsertBook(newBook);
}
}
public async Task <IActionResult> Edit(int id, BookTypes bookTypes)
{
if (id != bookTypes.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
_db.Update(bookTypes);
await _db.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(bookTypes));
}
/// <summary>
/// Добавление элемента в справочник
/// </summary>
/// <param name="bi">Добавляемый элемент</param>
/// <param name="btype">Тип справочника</param>
public void AddBookItem(BookItem bi, BookTypes bk)
{
try
{
string sql = string.Format(@"INSERT INTO {0} (Name) VALUES (@Name)", bk.ToString());
using (IDbConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString))
{
con.Open();
var result = con.Execute(sql, bi);
}
}
catch (Exception ex)
{
Log.WriteLog(ex.Message);
}
}
public Book CreateBook(BookTypes bookType)
{
Book book = null;
switch (bookType)
{
case BookTypes.ComicBook:
book = new ComicBook();
break;
default:
break;
}
return(book);
}
public static BookTypes CreateBookType(BookData book)
{
AuthorRepository authorRepository = new AuthorRepository();
BookTypeRepository bookTypeRepository = new BookTypeRepository();
BookTypes bookType = new BookTypes()
{
author_id = authorRepository.GetAuthorId(book.author),
title = book.title,
coverImageURL = book.coverImageURL,
genre = book.genre,
ISBN = book.ISBN,
releaseDate = book.releaseDate
};
bookTypeRepository.InsertBookType(bookType);
return(bookTypeRepository.GetSingleBookType(bookType.title));
}
/// <summary>
/// Удаление элемента справочника по id
/// </summary>
/// <param name="id">Id справочника</param>
/// <param name="bk">Тип справочника</param>
public void DeleteBookItem(int id, BookTypes bk)
{
try
{
using (IDbConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString))
{
con.Open();
con.Execute(string.Format("DELETE FROM {0} WHERE Id = @Id", bk.ToString()), new BookItem {
Id = id
});
}
}
catch (Exception ex)
{
Log.WriteLog(ex.Message);
}
}
public ActionResult AddBookResult(BookData book)
{
if (!InsertBook.CheckNewBookTitle(book.title))
{
book = new BookData()
{
Error = "Title already exists in library."
};
return(View("AddBook", book));
}
BookRepository bookRepository = new BookRepository();
BookTypes bookType = InsertBook.CreateBookType(book);
InsertBook.CreateBooks(bookType, book.quantity);
return(View("Library", new LibraryParameters()));
}
/// <summary>
/// Выгрузка всех элементов справочника
/// </summary>
/// <param name="bk">Тип справочника</param>
/// <returns></returns>
public IEnumerable <BookItem> GetBookItems(BookTypes bk)
{
try
{
string sql = string.Format("SELECT * FROM {0} ORDER BY Name", bk.ToString());
using (IDbConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString))
{
con.Open();
var result = con.Query <BookItem>(sql);
return(result);
}
}
catch (Exception ex)
{
Log.WriteLog(ex.Message);
}
return(null);
}
private static BookTypes GetBook(string[] line)
{
DateTime releaseDate = DateTime.MinValue;
DateTime.TryParse(line[3], out releaseDate);
BookTypes bookType = new BookTypes()
{
title = line[0],
author_id = GetAuthorId(line[1]),
genre = line[2],
releaseDate = releaseDate,
ISBN = line[4],
coverImageURL = line[5],
availableCopies = int.Parse(line[6])
};
return(bookType);
}
/// <summary>
/// 保存
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ResultInfo Create(BookTypeModel model)
{
ResultInfo ri = new ResultInfo()
{
Code = -1
};
if (model.BookType == null)
{
ri.Msg = "无法获取数据";
return(ri);
}
BookTypes bookTypes = model.BookType;
if (string.IsNullOrWhiteSpace(bookTypes.TypeName))
{
ri.Msg = "请输入分类名称";
return(ri);
}
if (bookTypes.ParentId > 0)
{
var queryModel = bookTypeRepository.GetItem(bookTypes.ParentId);
if (queryModel == null)
{
ri.Msg = "选择的父类不存在";
return(ri);
}
}
if (bookTypeRepository.GetItemByName(bookTypes.TypeName) != null)
{
ri.Msg = "添加名称已经存在";
return(ri);
}
bookTypeRepository.Create(bookTypes);
ri.Code = 0;
ri.Msg = "Success";
ri.Url = "/BookType";
return(ri);
}
BookTypes ConvertBookTypeFromString(string bookType)
{
BookTypes rtnVal = BookTypes.ECBOOK;
switch (bookType)
{
case "DON2BOOK":
rtnVal = BookTypes.DON2BOOK;
break;
case "PSBOOK":
rtnVal = BookTypes.PSBOOK;
break;
case "DAT":
rtnVal = BookTypes.DAT;
break;
case "SOS":
rtnVal = BookTypes.SOS;
break;
case "CARLSBERGVIKAR":
rtnVal = BookTypes.CARLSBERGVIKAR;
break;
case "TXBOOK":
rtnVal = BookTypes.TXBOOK;
break;
case "BCBOOK":
rtnVal = BookTypes.BCBOOK;
break;
}
return(rtnVal);
}
public static string Dump(BookTypes value)
{
var assistant = new AssistantDumper();
Dump(assistant, value);
return assistant.ToString();
}
