// Verlängert die Leihfrist um 30 Tage
public async Task Verlaengern(Exemplar exemplar)
{
exemplar.EntliehenBis = exemplar.EntliehenBis.Value.AddDays(30);
bibContext.Exemplar.Update(exemplar);
await bibContext.SaveChangesAsync();
}
//envia cadastro de um novo exemplar ao modelo
public void cadastrarNovoExemplar()
{
this.novoexemplar = new Exemplar();
int codigo = int.Parse(this.novaobra.rowResultado["codObra"].ToString());
this.novoexemplar.vincularExemplar(codigo,"Disponível");
this.novoexemplar.cadastrar();
}
public IActionResult Deletar(int id)
{
string msg = "";
msg = new Exemplar().Deletar(id);
return(Json(new { msg }));
}
public void AdaugareExemplar(Exemplar exemplar)
{
try
{
using (SQLiteConnection connection = new SQLiteConnection(Constante.CONNECTION_STRING))
{
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(connection))
{
command.CommandText = "INSERT INTO Exemplar(IdCarte, NumarInregistrare, Pierdut, Imprumutabil, EsteImprumutat) VALUES((SELECT Id FROM Carte WHERE Titlu = @titlu), @numarInregistrare, 0, @imprumutabil, 0)";
command.Prepare();
command.Parameters.AddWithValue("@titlu", exemplar.Carte.Titlu);
command.Parameters.AddWithValue("@numarInregistrare", exemplar.NumarInregistrare);
command.Parameters.AddWithValue("@imprumutabil", exemplar.Imprumutabil);
command.ExecuteNonQuery();
}
connection.Close();
}
}
catch (SQLiteException e)
{
Console.WriteLine(e.Data);
}
}
public List <Exemplar> obterExemplaresPorListLivrosID(List <Livro> livros)
{
List <Exemplar> exemplares = new List <Exemplar>();
int cont = livros.Count;
DataTable[] dt = new DataTable[cont];
_bd.AbrirConexao();
string sql;
Exemplar exemplar = null;
for (int i = 0; i < cont; i++)
{
sql = "SELECT * FROM exemplar WHERE idLivro = @idLivro";
_bd.LimparParametros();
_bd.AdicionarParametro("@idLivro", livros[i].Id.ToString());
dt[i] = _bd.ExecutarSelect(sql);
if (dt[i].Rows.Count > 0)
{
exemplar = new Exemplar()
{
Id = Convert.ToInt32(dt[i].Rows[0]["idExemplar"]),
Livro = new LivroDAL().seleciona(Convert.ToInt32(dt[i].Rows[0]["idLivro"])),
Posicao = new PosicaoDAL().obterPorID(Convert.ToInt32(dt[i].Rows[0]["idPosicao"]))
};
exemplares.Add(exemplar);
}
}
_bd.FecharConexao();
return(exemplares);
}
static void Main(string[] args)
{
Book Book = new Book(1, "Пушкин", "Руслан и Людмила", "Поэма");
Exemplar exemplar = new Exemplar(1, Book, DateTime.Now, "Exmo");
Position position = new Position(1, "Библиотекарь");
Reader reader = new ReaderPro("вип", 1, "Семенов", "Игорь", "Евгеньевич", "муж.", 79835);
Employee employee = new Employee(1, position, "Петрова", "Людмила", "Сергеевна", 345678892, 4, "Киров", "Попова", "6");
Delivery delivery = new Delivery(1, new DateTime(2018, 05, 04), employee, reader, exemplar);
Reader reader2 = new ReaderSimple("обычный", 1, "Крючкова", "Антонина", "Александровна", "жен.", 79835);
Book Book1 = new Book(1, "Лермонтов", "Мцыри", "Поэма");
Exemplar exemplar1 = new Exemplar(1, Book, DateTime.Now, "Exmo");
Position position1 = new Position(1, "Библиотекарь");
Delivery delivery1 = new Delivery(2, new DateTime(2018, 05, 10), employee, reader2, exemplar1);
DateTime start = new DateTime(2018, 05, 6);
DateTime end = new DateTime(2019, 12, 31);
List <Delivery> ListDelivery = new List <Delivery>();
ListDelivery.Add(delivery);
ListDelivery.Add(delivery1);
List <Reader> ListReader = new List <Reader>();
ListReader.Add(reader);
ListReader.Add(reader2);
List <Type> TypeList = new List <Type>();
foreach (Reader t in ListReader)
{
try
{
TypeList.Add(t.GetType());
}
catch (Exception ex)
{
Console.WriteLine("Ошибка {0}", ex.Message);
}
}
XmlSerializer formatter = new XmlSerializer(ListReader.GetType(), TypeList.ToArray());
using (FileStream fs = new FileStream("reader.xml", FileMode.OpenOrCreate))
{
formatter.Serialize(fs, ListReader);
Console.WriteLine("Сериализация XML прошла успешно");
}
using (FileStream fs = new FileStream("reader.xml", FileMode.OpenOrCreate))
{
List <Reader> ListDeserTovar = formatter.Deserialize(fs) as List <Reader>;
foreach (Reader tv in ListDeserTovar)
{
tv.Info();
}
}
Console.ReadLine();
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Exemplar exemplar = (Exemplar)db.Item.Find(id);
if (exemplar == null)
{
return(HttpNotFound());
}
this.ConfiguraNomeEditora(exemplar);
ViewBag.Editoras = new SelectList(db.Fornecedor, "id", "nome", "Editora");
ViewBag.Idiomas = new SelectList(db.Idioma, "id", "nome", exemplar.idiomaId);
ViewBag.Sessoes = new SelectList(db.Sessao, "id", "nome", exemplar.sessaoId);
exemplar.editora = this.RecuperaEditora(exemplar.editoraId);
exemplar.idioma = this.RecuperaIdioma(exemplar.idiomaId);
exemplar.sessao = this.RecuperaSessao(exemplar.sessaoId);
return(View(exemplar));
}
static void Main(string[] args)
{
Book Book = new Book(1, "Пушкин", "Руслан и Людмила", "Поэма");
Exemplar exemplar = new Exemplar(1, Book, DateTime.Now, "Exmo");
Position position = new Position(1, "Библиотекарь");
IReader reader = new ReaderPro("вип", 1, "Семенов", "Игорь", "Евгеньевич", "муж.", 79835);
Employee employee = new Employee(1, position, "Петрова", "Людмила", "Сергеевна", 345678892, 4, "Киров", "Попова", "6");
Delivery delivery = new Delivery(1, new DateTime(2018, 05, 04), employee, reader, exemplar);
// delivery.Info();
//Console.ReadLine();
IReader reader2 = new ReaderSimple("обычный", 1, "Крючкова", "Антонина", "Александровна", "жен.", 79835);
Book Book1 = new Book(1, "Лермонтов", "Мцыри", "Поэма");
Exemplar exemplar1 = new Exemplar(1, Book, DateTime.Now, "Exmo");
Position position1 = new Position(1, "Библиотекарь");
Delivery delivery1 = new Delivery(2, new DateTime(2018, 05, 10), employee, reader2, exemplar1);
DateTime start = new DateTime(2018, 05, 6);
DateTime end = new DateTime(2019, 12, 31);
List <Delivery> ListDelivery = new List <Delivery>();
ListDelivery.Add(delivery);
ListDelivery.Add(delivery1);
foreach (Delivery date in ListDelivery)
{
date.Info();
Console.WriteLine(" ");
}
Console.ReadLine();
}
// 添加
public ExemplarCommand Create(string wlno)
{
Exemplar exemplar = new Exemplar(ExemplarIdentifier.of(wlno));
repository.Save(exemplar);
return(new ExemplarCommand(exemplar, repository));
}
// 修改
public ExemplarCommand Edit(string dbid, string newno)
{
Exemplar exemplar = GetOne(dbid);
exemplar.Id = ExemplarIdentifier.of(newno);
repository.Save(exemplar);
return(new ExemplarCommand(exemplar, repository));
}
private void ConfiguraNomeEditora(Exemplar exemplar)
{
if (exemplar.editora == null)
{
exemplar.editora = (Editora)db.Fornecedor.Find(exemplar.editoraId);
}
exemplar.editoraNome = exemplar.editora.id + " - " + exemplar.editora.nome;
}
public IActionResult Alterar(int id)
{
Exemplar exemplar = new Exemplar().BuscarExemplarID(id);
return(Json(new {
exemplar
}));
}
public Exemplar GetExemplar(Exemplar exemplar)
{
return(context.Exemplars.FirstOrDefault(e =>
e.Volume == exemplar.Volume &&
e.Number == exemplar.Number &&
e.Month == exemplar.Volume &&
e.Journal.Name == exemplar.Journal.Name));
}
// Gibt ein Exemplar zurück an die Bibliothek
public async Task Zurueckgeben(Exemplar exemplar, Leihauftrag leihauftrag)
{
exemplar.EntliehenBis = null;
exemplar.Verfügbarkeit = true;
bibContext.Exemplar.Update(exemplar);
bibContext.Leihauftrag.Remove(leihauftrag);
await bibContext.SaveChangesAsync();
}
public IActionResult Gravar([FromBody] System.Text.Json.JsonElement dados)
{
string msg = "Falhou";
msg = new Exemplar().Gravar(dados);
return(Json(new
{
msg
}));
}
// Leiht einem Benutzer ein Exemplar aus
public async Task Ausleihen(Exemplar exemplar, Leihauftrag leihauftrag)
{
exemplar.EntliehenBis = DateTime.Now.AddDays(30);
exemplar.Verfügbarkeit = false;
leihauftrag.IstVerliehen = true;
bibContext.Exemplar.Update(exemplar);
bibContext.Leihauftrag.Update(leihauftrag);
await bibContext.SaveChangesAsync();
}
public void Setup()
{
FInstance = new Exemplar();
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
Exemplar.Disposed = 0;
Exemplar.Finalizer = 0;
Exemplar.Disposing = 0;
}
public Exemplar EditarExemplar(Exemplar exemplar)
{
var editLivro = GetExemplarByIdService(exemplar.Id);
if (editLivro != null)
{
_unitOfWork.Exemplar.Update(exemplar);
_unitOfWork.Commit();
}
return(exemplar);
}
private bool VerificaJaExiste(Exemplar exemplar)
{
List <Exemplar> resultado = new List <Exemplar>();
resultado = db.Item.OfType <Exemplar>().Where(e => e.isbn == exemplar.isbn).ToList();
if (resultado.Count() > 0)
{
return(true);
}
return(false);
}
public async Task <ActionResult> Edit([Bind(Include = "Id,IdLivro,IdUnidade,Edicao,AnoEdicao,Locado")] Exemplar exemplar)
{
if (ModelState.IsValid)
{
db.Entry(exemplar).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.IdLivro = new SelectList(db.Livro, "Id", "Titulo", exemplar.IdLivro);
ViewBag.IdUnidade = new SelectList(db.Unidade, "Id", "Nome", exemplar.IdUnidade);
return(View(exemplar));
}
public string EditarExemplar(Exemplar exemplar)
{
try
{
_serviceExemplar.EditarExemplar(exemplar);
}
catch (LivrariaExceptions error)
{
Console.WriteLine(error);
}
return("Livro editado com sucesso");
}
public void Add()
{
string EBookName;
string EBookAuthor;
string EPublisher;
int EYearOfPublish;
string EGenre;
int EExemplarAmount;
try
{
Console.WriteLine("Введите название книги");
EBookName = Console.ReadLine();
Console.WriteLine("Введите автора книги");
EBookAuthor = Console.ReadLine();
Console.WriteLine("Введите издатель книги");
EPublisher = Console.ReadLine();
Console.WriteLine("Введите год издания книги");
EYearOfPublish = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Введите жанр книги");
EGenre = Console.ReadLine();
using (TablesContext db = new TablesContext())
{
Genre genre = new Genre {
Name = EGenre
};
Book books = new Book {
BookName = EBookName, BookAuthor = EBookAuthor, Publisher = EPublisher, YearOfPublish = EYearOfPublish
};
db.Genres.Add(genre);
db.Books.Add(books);
Console.WriteLine("Введите количество экземпляров книги");
EExemplarAmount = Convert.ToInt32(Console.ReadLine());
for (int i = 0; i < EExemplarAmount; i++)
{
Console.Write("Введите номер экземпляра {0} > ", i + 1);
string EExemplar = Console.ReadLine();
Exemplar exemplars = new Exemplar {
ExemplarNumber = EExemplar, BookId = books.Id, ExemplarStatus = "In Stock"
};
db.Exemplars.Add(exemplars);
}
db.SaveChanges();
Console.WriteLine("Объекты успешно сохранены");
}
}
catch (Exception) { Console.WriteLine("Данные введены не верно"); }
}
static void Main(string[] args)
{
Book Book = new Book(1, "Пушкин", "Руслан и Людмила", "Поэма");
Exemplar exemplar = new Exemplar(1, Book, DateTime.Now, "Exmo");
Position position = new Position(1, "Библиотекарь");
IReader reader = new ReaderPro("вип", 1, "Семенов", "Игорь", "Евгеньевич", "муж.", 79835);
Employee employee = new Employee(1, position, "Петрова", "Людмила", "Сергеевна", 345678892, 4, "Киров", "Попова", "6");
Delivery delivery = new Delivery(1, new DateTime(2018, 05, 04), employee, reader, exemplar);
IReader reader2 = new ReaderSimple("обычный", 1, "Крючкова", "Антонина", "Александровна", "жен.", 79835);
Book Book1 = new Book(1, "Лермонтов", "Мцыри", "Поэма");
Exemplar exemplar1 = new Exemplar(1, Book, DateTime.Now, "Exmo");
Position position1 = new Position(1, "Библиотекарь");
Delivery delivery1 = new Delivery(2, new DateTime(2018, 05, 10), employee, reader2, exemplar1);
DateTime start = new DateTime(2018, 05, 6);
DateTime end = new DateTime(2019, 12, 31);
List <Delivery> ListDelivery = new List <Delivery>();
ListDelivery.Add(delivery);
ListDelivery.Add(delivery1);
// массив для сериализации:
Delivery[] DeliveryBook = new Delivery[] { delivery, delivery1 };
BinaryFormatter formatter = new BinaryFormatter();
using (FileStream fs = new FileStream("delivery.dat", FileMode.OpenOrCreate))
{
// сериализуем весь массив tovar
formatter.Serialize(fs, DeliveryBook);
Console.WriteLine("Сериализация в поток байтов прошла успешно");
}
// десериализация
using (FileStream fs = new FileStream("delivery.dat", FileMode.OpenOrCreate))
{
Delivery[] deserilizeTovar = (Delivery[])formatter.Deserialize(fs);
foreach (Delivery tv in deserilizeTovar)
{
tv.Info();
}
Console.ReadLine();
}
}
public string CadastrarLivro(Exemplar exemplar)
{
var dados = "";
try
{
dados = _serviceExemplar.CadastrarExemplarService(exemplar);
}
catch (LivrariaExceptions error)
{
Console.WriteLine(error);
}
return(dados);
}
// GET: Exemplar/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Exemplar exemplar = await db.Exemplar.FindAsync(id);
if (exemplar == null)
{
return(HttpNotFound());
}
return(View(exemplar));
}
public ActionResult Edit(Exemplar exemplar)
{
if (ModelState.IsValid)
{
exemplar.ConfigurarParaSalvar();
db.Entry(exemplar).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.editoraId = new SelectList(db.Fornecedor, "id", "nome");
ViewBag.idiomaId = new SelectList(db.Idioma, "id", "nome", exemplar.idiomaId);
ViewBag.sessaoId = new SelectList(db.Sessao, "id", "nome", exemplar.sessaoId);
return(View(exemplar));
}
// 发送内容
public static string SendContent(Exemplar exe)
{
string now = DateTime.Now.ToLocalTime().ToString("yyyy/MM/dd");
string result = "";
result += "<div><h3>您好！以下是 " + now + " 来自IQC的检验结果</h3>";
result += "物料编号：<strong>" + exe.Id.Code + "</strong><br />";
result += "模穴号：<strong>" + exe.ModelNo + "</strong><br />";
result += "物料大类：<strong>" + exe.MaterialClass + "</strong><br />";
result += "供应商：<strong>" + exe.Supplier + "</strong><br />";
result += "不良描述：<strong>" + exe.NGDes + "</strong><br />";
result += "签收日期：<strong>" + exe.SignDate.ToString("yyyy/MM/dd") + "</strong><br /></div>";
return(result);
}
// 提交保存
public void SubmitSave(Dictionary <string, string> dict)
{
Account account = sessionService.GetAccount();
foreach (var d in dict)
{
Exemplar exemplar = GetOne(d.Key);
exemplar.Signer = account.Id.UserName;
var space_back = d.Value.Split(new[] { '&' });
exemplar.SaveSpace = space_back[0];
exemplar.BackReason = space_back[1]; // 备注
exemplar.Status = 4;
}
Commit();
}
// GET: Exemplar/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Exemplar exemplar = await db.Exemplar.FindAsync(id);
if (exemplar == null)
{
return(HttpNotFound());
}
ViewBag.IdLivro = new SelectList(db.Livro, "Id", "Titulo", exemplar.IdLivro);
ViewBag.IdUnidade = new SelectList(db.Unidade, "Id", "Nome", exemplar.IdUnidade);
return(View(exemplar));
}
public void SalvarDevePassar()
{
// Arrange
ExemplaresController controller = new ExemplaresController();
Exception exception = new Exception();
Exemplar exemplar = this.InicializaExemplar();
// Act
ViewResult result = controller.Create(exemplar) as ViewResult;
// Assert
Assert.IsNotNull(result);
ModelState modelState = result.ViewData.ModelState[""];
Assert.IsNotNull(modelState);
Assert.IsTrue(modelState.Errors.Any());
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
try
{
Exemplar exemplar = await db.Exemplar.FindAsync(id);
db.Exemplar.Remove(exemplar);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ModelState.AddModelError("erro", "Não foi possível excluir, favor verificar as dependências.");
return(View());
}
}
public ActionResult Index(string item, int codigo)
{
switch(item)
{
case "exemplar":
this.exemplar = new Exemplar();
this.exemplar.deletar(codigo);
break;
case "obras":
this.obra = new Obras();
this.obra.deletar(codigo);
break;
case "usuarios":
this.usuario = new Usuarios(1000);
this.usuario.deletar(codigo);
break;
}
Response.Write("<script> document.location=\"/Pesquisar/\"; </script>");
return View();
}
