public void DeleteBorrowForm(Guid ID)
{
Models.DBObjects.BorrowForm borrowFormToDelete = booksLibraryDataContext.BorrowForms.FirstOrDefault(x => x.IDBorrowForm == ID);
if (borrowFormToDelete != null)
{
booksLibraryDataContext.BorrowForms.DeleteOnSubmit(borrowFormToDelete);
booksLibraryDataContext.SubmitChanges();
}
}
public void UpdateBorrowForm(BorrowFormModel borrowFormModel)
{
Models.DBObjects.BorrowForm existingBorrowForm = booksLibraryDataContext.BorrowForms.FirstOrDefault(x => x.IDBorrowForm == borrowFormModel.IDBorrowForm);
if (existingBorrowForm != null)
{
existingBorrowForm.IDBorrowForm = borrowFormModel.IDBorrowForm;
existingBorrowForm.IDBook = borrowFormModel.IDBook;
existingBorrowForm.IDCustomer = borrowFormModel.IDCustomer;
existingBorrowForm.BorrowedFrom = borrowFormModel.BorrowedFrom;
existingBorrowForm.BorrowedUntil = borrowFormModel.BorrowedUntil;
existingBorrowForm.ReturnedOnTime = borrowFormModel.ReturnedOnTime;
existingBorrowForm.ProperConditionsReturn = borrowFormModel.ProperConditionsReturn;
booksLibraryDataContext.SubmitChanges();
}
}
private Models.DBObjects.BorrowForm MapModelToDbObject(BorrowFormModel borrowFormModel)
{
Models.DBObjects.BorrowForm dbBorrowFormModel = new Models.DBObjects.BorrowForm();
if (borrowFormModel != null)
{
dbBorrowFormModel.IDBorrowForm = borrowFormModel.IDBorrowForm;
dbBorrowFormModel.IDBook = borrowFormModel.IDBook;
dbBorrowFormModel.IDCustomer = borrowFormModel.IDCustomer;
dbBorrowFormModel.BorrowedFrom = borrowFormModel.BorrowedFrom;
dbBorrowFormModel.BorrowedUntil = borrowFormModel.BorrowedUntil;
dbBorrowFormModel.ReturnedOnTime = borrowFormModel.ReturnedOnTime;
dbBorrowFormModel.ProperConditionsReturn = borrowFormModel.ProperConditionsReturn;
return(dbBorrowFormModel);
}
return(null);
}
private BorrowFormModel MapDbObjectToModel(Models.DBObjects.BorrowForm dbBorrowForm)
{
BorrowFormModel borrowFormModel = new BorrowFormModel();
if (dbBorrowForm != null)
{
borrowFormModel.IDBorrowForm = dbBorrowForm.IDBorrowForm;
borrowFormModel.IDBook = dbBorrowForm.IDBook;
borrowFormModel.IDCustomer = dbBorrowForm.IDCustomer;
borrowFormModel.BorrowedFrom = dbBorrowForm.BorrowedFrom;
borrowFormModel.BorrowedUntil = dbBorrowForm.BorrowedUntil;
borrowFormModel.ReturnedOnTime = dbBorrowForm.ReturnedOnTime;
borrowFormModel.ProperConditionsReturn = dbBorrowForm.ProperConditionsReturn;
return(borrowFormModel);
}
return(null);
}
