// 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(); }