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