//Search borrower base name public List <BorrowerDTO> SearchBorrowerName(String name) { using (LibraryManagementEntities entities = new LibraryManagementEntities()) { try { List <BorrowerDTO> oDto = new List <BorrowerDTO>(); var b = entities.Borrowers.Where(x => x.borrowerName.Contains(name)).ToList(); foreach (var i in b) { BorrowerDTO o = new BorrowerDTO(i); oDto.Add(o); } if (oDto != null) { return(oDto); } return(null); } catch (Exception ex) { return(null); } } }
public static List <BorrowerDTO> getBorrowerPersonId(List <string> booklist) { List <BorrowerDTO> dtoborrowerlist = new List <BorrowerDTO>(); string _connectionString = DataSource.GetConnectionString("library2"); // Make possible to define and use different connectionstrings SqlConnection con = new SqlConnection(_connectionString); SqlCommand cmd = new SqlCommand("SELECT * FROM BORROWER WHERE PersonId = '" + Person + "'", con); try { con.Open(); SqlDataReader dar = cmd.ExecuteReader(); if (dar.Read()) { BorrowerDTO dto = new BorrowerDTO(); dto.Categoryid = (int)dar["Categoryid"]; dto.firstName = dar["FirstName"] as string; dto.lastName = dar["LastName"] as string; dto.Address = dar["Address"] as string; dto.Telno = dar["TelNo"] as string; dto.PersonId = dar["PersonId"] as string; dtoborrowerlist.Add(dto); } } catch (Exception er) { throw er; } finally { con.Close(); } return(dtoborrowerlist); }
//add new borrower public bool AddBorrower(BorrowerDTO b) { using (LibraryManagementEntities entities = new LibraryManagementEntities()) { Borrower b1 = new Borrower(); b1.borrowerID = b.BorrowerID; b1.borrowerName = b.BorrowerName; b1.borrowerGender = b.BorrowerGender; b1.borrowerPhone = b.BorrowerPhone; b1.borrowerAddress = b.BorrowerAddress; b1.borrowerEmail = b.BorrowerEmail; b1.borrowerBirthDate = b.BorrowerBirthDate; entities.Borrowers.Add(b1); int ret = entities.SaveChanges(); if (ret == 1) { return(true); } else { return(false); } } }
public static BorrowerDTO LoadallBorrower(string PersonId) { BorrowerDTO dto = new BorrowerDTO(); string _connectionString = DataSource.GetConnectionString("library2"); // Make possible to define and use different connectionstrings SqlConnection con = new SqlConnection(_connectionString); SqlCommand cmd = new SqlCommand("SELECT * FROM Borrower WHERE PersonId = " + PersonId, con); try { con.Open(); SqlDataReader dar = cmd.ExecuteReader(); if (dar.Read()) { dto.PersonId = dar["PersonId"] as string; dto.firstName = dar["FirstName"] as string; dto.lastName = dar["LastName"] as string; dto.Address = dar["Address"] as string; dto.Telno = dar["TelNo"] as string; dto.Categoryid = (int)dar["Categoryid"]; } } catch (Exception er) { throw er; } finally { con.Close(); } return(dto); }
/// <summary> /// Add a borrower to the system /// </summary> /// <param name="entity"></param> public async Task <int> Add(BorrowerDTO entity) { try { // call repository method to save borrower var test = _mapper.Map <BorrowerDTO, Borrower>(entity); return(await _repository.Add(test)); } catch (Exception ex) { throw ex; } }
private void Load() { // Initiates a read from the database of the DTO-object for a specific author, if loadstatus is set to "Ghost" try { if (_BorrowerDTO.loadStatus == LoadStatus.Ghost) { _BorrowerDTO = LibraryDataAccess.LoadallBorrower(_BorrowerDTO.PersonId); } } catch (Exception ex) { //Do some error-log functionality with ex.Data } }
/// <summary> /// Delete a borrower /// </summary> /// <param name="entity"></param> public void Remove(BorrowerDTO entity) { try { // call repository method to delete borrower var selectedBorrower = _mapper.Map <BorrowerDTO, Borrower>(entity); _repository.Remove(selectedBorrower); } catch (Exception ex) { throw ex; } //return isDeleted; }
//get all borrower public List <BorrowerDTO> GetAllBorrower() { using (LibraryManagementEntities entities = new LibraryManagementEntities()) { List <BorrowerDTO> oDto = new List <BorrowerDTO>(); var b = entities.Borrowers.ToList(); foreach (var i in b) { BorrowerDTO o = new BorrowerDTO(i); oDto.Add(o); } if (oDto != null) { return(oDto); } return(null); } }
public async Task <int> SaveBorrower([FromBody] BorrowerDTO borrowerInfo) { int borrowerId = 0; try { borrowerId = await _borrowerService.Add(borrowerInfo); } catch (Exception ex) { using (_logger.BeginScope(new Dictionary <string, object> { { "Borrower", "SaveBorrower" } })) { _logger.LogError(ex.Message); } throw ex; } return(borrowerId); }
public static List <BorrowerDTO> getAllBorrowerDAL() { List <BorrowerDTO> BorrowerDtoList = new List <BorrowerDTO>(); //Connect to the database and read all authors string _connectionString = DataSource.GetConnectionString("library2"); // Make possible to define and use different connectionstrings SqlConnection con = new SqlConnection(_connectionString); SqlCommand cmd = new SqlCommand("SELECT * FROM BORROWER", con); try { con.Open(); SqlDataReader dar = cmd.ExecuteReader(); while (dar.Read()) { BorrowerDTO dto = new BorrowerDTO(); dto.Categoryid = (int)dar["Categoryid"]; dto.firstName = dar["FirstName"] as string; dto.lastName = dar["LastName"] as string; dto.Address = dar["Address"] as string; dto.Telno = dar["TelNo"] as string; dto.PersonId = dar["PersonId"] as string; dto.loadStatus = LoadStatus.Ghost; //Since we are not retrieving the isbn-number list BorrowerDtoList.Add(dto); } } catch (Exception er) { throw er; } finally { con.Close(); } return(BorrowerDtoList); }
//A constructor which creates a DTO-object with data from an existing DTO-object public Borrower(BorrowerDTO _sourceDTO) { _BorrowerDTO = new BorrowerDTO(_sourceDTO); }
//Initialize a new DTO-object for the transferring data about author public Borrower() { _BorrowerDTO = new BorrowerDTO(); }
//add a new borrower public bool AddBorrower(BorrowerDTO b) { return(BorrowerDAO.Instance.AddBorrower(b)); }