public string DeleteLoan(IMPRUMUT imprumut)
{
var message = "";
try
{
var toDelete = new IMPRUMUT();
toDelete = imprumut.ImprumutId == 0 ? context.IMPRUMUTs.FirstOrDefault(t => t.ImprumutId == imprumut.ImprumutId) : context.IMPRUMUTs.FirstOrDefault(t => t.ImprumutId == imprumut.ImprumutId);
if (toDelete != null)
{
context.IMPRUMUTs.Remove(toDelete);
context.SaveChanges();
}
else
{
message = "This loan does not exist or has already been deleted!";
}
}
catch (Exception e)
{
message = e.Message;
}
return(message);
}
public async Task <IActionResult> InsertReview(ReviewViewModel view)
{
var exista_cititor = repository.VerifyReaderByNameAsync(view.CITITOR.Nume.Trim() + " " + view.CITITOR.Prenume.Trim()).Result.ToList();
var queryCititorId = repository.GetReaderAsync(exista_cititor[0].CititorId);
var queryCarteImprumut = repository.GetLoanByBookTitleReaderIdAsync(view.CARTE.Titlu.Trim(), queryCititorId.Result.CititorId).Result.ToList();
if (queryCarteImprumut.LongCount() == 0)
{
return(RedirectToAction("NotPossible", "Home", view));
}
var queryCarteId = repository.GetBookAsync(queryCarteImprumut[0].CarteId);
if (queryCarteId.Result.CarteId > 0)
{
int idCarte = queryCarteId.Result.CarteId;
var queryDateCarteImprumutata = repository.GetLoanAsync(queryCarteImprumut[0].ImprumutId);
IMPRUMUT loan = new IMPRUMUT
{
DataRestituire = DateTime.Now,
ImprumutId = queryDateCarteImprumutata.Result.ImprumutId,
DataImprumut = queryDateCarteImprumutata.Result.DataImprumut,
DataScadenta = queryDateCarteImprumutata.Result.DataScadenta,
CititorId = queryDateCarteImprumutata.Result.CititorId,
CarteId = queryDateCarteImprumutata.Result.CarteId,
};
view.IMPRUMUT = loan;
await repository.UpdateLoanAsync(view.IMPRUMUT);
// issues, I think
var queryDateImprumut = repository.GetLoanAsync(idCarte).Result;
var queryCititorImprumut = repository.GetLoanAsync(idCarte).Result;
if (queryDateImprumut.DataRestituire > queryDateImprumut.DataScadenta)
{
var queryStareCititor = repository.GetReaderAsync(queryCititorImprumut.CititorId);
view.CITITOR.CititorId = queryStareCititor.Result.CititorId;
view.CITITOR.Nume = queryStareCititor.Result.Nume;
view.CITITOR.Prenume = queryStareCititor.Result.Prenume;
view.CITITOR.Email = queryStareCititor.Result.Email;
view.CITITOR.Adresa = queryStareCititor.Result.Adresa;
view.CITITOR.Stare = 1;
await repository.UpdateReaderAsync(view.CITITOR);
}
REVIEW review = new REVIEW
{
Text = view.REVIEW.Text,
ImprumutId = queryDateImprumut.ImprumutId
};
view.REVIEW = review;
await repository.InsertReviewAsync(view.REVIEW);
}
return(RedirectToAction("AfisareReview", "Review", view));
}
public IMPRUMUT UpdateLoan(IMPRUMUT imprumut)
{
using (var context = new ModelDatabaseFirst())
{
context.IMPRUMUTs.AddOrUpdate(imprumut);
context.SaveChanges();
return(imprumut);
}
}
internal ImprumutDTO getImprumutDTO(IMPRUMUT imp)
{
return(new ImprumutDTO()
{
ImprumutId = imp.ImprumutId,
carte = getCARTEDTO(imp.CARTE),
cititor = getCititorDTO(imp.CITITOR),
DataImprumut = imp.DataImprumut,
DataRestituire = imp.DataRestituire,
DataScadenta = imp.DataScadenta
});
}
public async Task <IActionResult> InsertLoan(LoanViewModel view)
{
int cititorId = 0, carteId = 0;
var exista_cititor = repository.VerifyReaderByNameAsync(view.CITITOR.Nume.Trim() + " " + view.CITITOR.Prenume.Trim()).Result.ToList();
if (exista_cititor.LongCount() > 0)
{
var queryReader = repository.GetReaderAsync(exista_cititor[0].CititorId).Result;
cititorId = queryReader.CititorId;
int nrCartiDupaTitluCARTE = repository.GetNumberOfExistingBooksByTitleAsync(view.CARTE.Titlu.Trim()).Result;
int nrCartiImprumutateDupaTitlu = repository.GetNumberOfBorrowedBooksByTitleAsync(view.CARTE.Titlu.Trim()).Result;
if (nrCartiImprumutateDupaTitlu == nrCartiDupaTitluCARTE)
{
var queryDataToLoan = repository.ShowDateToBorrowBookAsync(view.CARTE.Titlu.Trim()).Result;
}
}
else
{
return(RedirectToAction("NotPossible", "Home", view));
}
var exista_carte = repository.VerifyBookByTitleAsync(view.CARTE.Titlu.Trim()).Result.ToList();
if (exista_carte.LongCount() > 0)
{
carteId = exista_carte[0].CarteId;
}
else
{
return(RedirectToAction("NotPossible", "Home", view));
}
DateTime dataImprumut = DateTime.Now;
DateTime dataScadenta = dataImprumut.AddDays(15);
DateTime restituire = new DateTime(1900, 1, 1);
IMPRUMUT loan = new IMPRUMUT
{
CarteId = carteId,
CititorId = cititorId,
DataImprumut = dataImprumut,
DataScadenta = dataScadenta,
DataRestituire = restituire,
};
view.IMPRUMUT = loan;
await repository.InsertLoanAsync(view.IMPRUMUT);
return(RedirectToAction("AfisareImprumuturi", "Loan", view));
}
public string InsertLoan(IMPRUMUT imprumut)
{
try
{
context.IMPRUMUTs.Add(imprumut);
context.SaveChanges();
}
catch (Exception e)
{
return(e.Message);
}
return("");
}
public string UpdateLoan(IMPRUMUT imprumut)
{
var message = "";
try
{
context.IMPRUMUTs.AddOrUpdate(imprumut);
context.SaveChanges();
}
catch (Exception e)
{
message = e.Message;
}
return(message);
}
public void DeleteLoan(IMPRUMUT imprumut)
{
try
{
using (var context = new ModelDatabaseFirst())
{
context.IMPRUMUTs.Remove(imprumut);
context.SaveChanges();
return;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public Response InsertLoan(IMPRUMUT imprumut)
{
var response = new Response();
var mapped = Mapper.Map <IMPRUMUT, Data.Entities.IMPRUMUT>(imprumut);
var reply = _bookRepository.InsertLoan(mapped);
if (reply == "")
{
response.Messages.Add("The loan has been successfully added!");
}
else
{
response.Error = true;
response.Messages.Add(reply);
}
return(response);
}
public bool RestituireCarte(int id)
{
DbSet <IMPRUMUT> borrows = dbContext.IMPRUMUT;
DbSet <CARTE> books = dbContext.CARTE;
try
{
IMPRUMUT carteImprumutata = borrows.FirstOrDefault(x => x.ImprumutId == id);
carteImprumutata.DataRestituire = DateTime.Now;
dbContext.SaveChanges();
return(true);
}
catch (Exception Ex)
{
var error = Ex;
return(false);
}
}
public IMPRUMUTDTO S_imprumut_dto(IMPRUMUT i)
{
//var lista = new List<REVIEWDTO>();
if (i.REVIEW != null)
{
foreach (REVIEW r in i.REVIEW)
{
// REVIEWDTO r1 = S_review_dto(r);
// lista.Add(r1);
}
}
IMPRUMUTDTO i1 = new IMPRUMUTDTO()
{
ImprumutId = i.ImprumutId,
CarteId = i.CarteId,
CititorId = i.CititorId,
DataImprumut = i.DataImprumut,
DataScadenta = i.DataScadenta,
DataRestituire = i.DataRestituire
// REVIEW = lista
};
return(i1);
}
private void InsertImprumut_Click(object sender, EventArgs e)
{
var book = new BookRepository();
var loan = new LoanRepository();
var reader = new ReaderRepository();
int flag = 0;
var exista_carte = book.VerifyBookByTitle(boxNumeCarteInsertImprumut.Text.Trim());
var exista_cititor = reader.VerifyReaderByName(boxNumeCititorInsertImprumut.Text.Trim());
if (exista_carte.LongCount() > 0)
{
var queryBook1 = book.GetBookIdByTitle(boxNumeCarteInsertImprumut.Text.Trim());
int idCarte = queryBook1[0].CarteId;
if (exista_cititor.LongCount() > 0)
{
var queryReader = reader.GetReaderIdByName(boxNumeCititorInsertImprumut.Text.Trim());
int idCititor = queryReader[0].CititorId;
int nrCartiDupaTitluCARTE = book.GetNumberOfExistingBooksByTitle(boxNumeCarteInsertImprumut.Text.Trim());
int nrCartiImprumutateDupaTitlu = book.GetNumberOfBorrowedBooksByTitle(boxNumeCarteInsertImprumut.Text.Trim());
if (nrCartiImprumutateDupaTitlu == nrCartiDupaTitluCARTE)
{
var queryDataToLoan = book.ShowDateToBorrowBook(boxNumeCarteInsertImprumut.Text.Trim());
MessageBox((IntPtr)0, "Cartea nu este disponibila pentru a fi imprumutata!\n Data la care poate fi imprumutata este: " + queryDataToLoan + "\n", "Message Box", 0);
}
else
{
MessageBox((IntPtr)0, "Cartea este disponibila pentru a fi imprumutata!", "Message Box", 0);
flag = 1;
}
if (flag == 1)
{
DateTime dataImprumut = DateTime.Now;
DateTime dataScadenta = dataImprumut.AddDays(15);
DateTime restituire = new DateTime(1900, 1, 1);
IMPRUMUT imprumut = new IMPRUMUT()
{
CarteId = idCarte,
CititorId = idCititor,
DataImprumut = dataImprumut,
DataScadenta = dataScadenta,
DataRestituire = restituire,
};
loan.InsertLoan(imprumut);
MessageBox((IntPtr)0, "\nInsert Operation Completed", "Message Box", 0);
}
}
else
{
MessageBox((IntPtr)0, "\nCititorul nu exista", "Message Box", 0);
}
}
else
{
MessageBox((IntPtr)0, "\nCartea nu exista", "Message Box", 0);
}
boxNumeCarteInsertImprumut.Text = "";
boxNumeCititorInsertImprumut.Text = "";
}
public Response DeleteLoan(IMPRUMUT imprumut)
{
return(_bookServices.DeleteLoan(imprumut));
}
public Response UpdateLoan(IMPRUMUT imprumut)
{
return(_bookServices.UpdateLoan(imprumut));
}
public Response InsertLoan(IMPRUMUT imprumut)
{
return(_bookServices.InsertLoan(imprumut));
}
private void InsertImprumut_Click_1(object sender, EventArgs e)
{
listAfiseazaRaspuns.Items.Clear();
var services = new LibraryServicesClient();
int flag = 0;
var exista_carte = services.VerifyBookByTitle(titluCarteInsertImprumut.Text.Trim());
var exista_cititor = services.VerifyReaderByName(numeCititorInsertImprumut.Text.Trim());
if (exista_carte.LongCount() > 0)
{
var queryBook1 = services.GetBookByTitle(titluCarteInsertImprumut.Text.Trim());
int idCarte = queryBook1[0].CarteId;
if (exista_cititor.LongCount() > 0)
{
var queryReader = services.GetReader(exista_cititor[0].CititorId);
int idCititor = queryReader.CititorId;
int nrCartiDupaTitluCARTE = services.GetNumberOfExistingBooksByTitle(titluCarteInsertImprumut.Text.Trim());
int nrCartiImprumutateDupaTitlu = services.GetNumberOfBorrowedBooksByTitle(titluCarteInsertImprumut.Text.Trim());
if (nrCartiImprumutateDupaTitlu == nrCartiDupaTitluCARTE)
{
var queryDataToLoan = services.ShowDateToBorrowBook(titluCarteInsertImprumut.Text.Trim());
listAfiseazaRaspuns.Items.Add("Cartea nu este disponibila pentru a fi imprumutata!\n Data la care poate fi imprumutata este: " + queryDataToLoan);
}
else
{
listAfiseazaRaspuns.Items.Add("Cartea este disponibila pentru a fi imprumutata!");
flag = 1;
}
if (flag == 1)
{
DateTime dataImprumut = DateTime.Now;
DateTime dataScadenta = dataImprumut.AddDays(15);
DateTime restituire = new DateTime(1900, 1, 1);
IMPRUMUT imprumut = new IMPRUMUT()
{
CarteId = idCarte,
CititorId = idCititor,
DataImprumut = dataImprumut,
DataScadenta = dataScadenta,
DataRestituire = restituire,
};
services.InsertLoan(imprumut);
listAfiseazaRaspuns.Items.Add("Insert Operation Completed");
}
}
else
{
listAfiseazaRaspuns.Items.Add("Cititorul nu exista");
}
}
else
{
listAfiseazaRaspuns.Items.Add("Cartea nu exista");
}
titluCarteInsertImprumut.Text = "";
numeCititorInsertImprumut.Text = "";
}
