public async Task <IActionResult> DonorDetails(int id)
{
var selectedDonor = await _repository.GetByIdAsync <Donor>(id);
var donorDetailsModel = new DonorDetailsDTO
{
Donor = new DonorDTO(id, selectedDonor.Name.FirstName, selectedDonor.Name.LastName)
{
Title = selectedDonor.Name.Title
},
Addresses = new List <AddressDTO>
{
new AddressDTO("Home Address",
selectedDonor.HomeAddress.Line1,
selectedDonor.HomeAddress.City,
selectedDonor.HomeAddress.Postcode_Zip,
selectedDonor.HomeAddress.Country),
new AddressDTO("Work Address",
selectedDonor.WorkAddress.Line1,
selectedDonor.WorkAddress.City,
selectedDonor.WorkAddress.Postcode_Zip,
selectedDonor.WorkAddress.Country)
}
};
return(View(donorDetailsModel));
}
//update data of donors
public void UpdateAllInfo(RegistrationDTO registerDTO, DonorDetailsDTO donorDTO)
{
// for registered Donors
sqlConnection.Open();
string sqlQuery1 = "UPDATE RegisteredDonor SET Name='" + registerDTO.NAME +
"',Email='" + registerDTO.EMAIL +
"',District='" + registerDTO.DISTRICT +
"',BloodGroup='" + registerDTO.BLOODGROUP +
"',ContactNo='" + registerDTO.CONTACTNO +
"' where DonorID=" + registerDTO.ID;
sqlCommand = new SqlCommand(sqlQuery1, sqlConnection);
sqlCommand.ExecuteNonQuery();
//for Donor Details
string sqlQuery2 = "UPDATE DonorDetails SET Address='" + donorDTO.ADDRESS +
"',Gender='" + donorDTO.GENDER +
"',Weight='" + donorDTO.WEIGHT +
"',Height='" + donorDTO.HEIGHT +
"',Smoker='" + donorDTO.SMOKER +
"',Addict='" + donorDTO.ADDICT +
"',DateofBirth='" + donorDTO.DATEOFBIRTH +
"',DonationStatus='" + donorDTO.DONATIONSTATUS +
"',Bio='" + donorDTO.BIO +
"' where DonorID=" + donorDTO.DONORID;
sqlCommand = new SqlCommand(sqlQuery2, sqlConnection);
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
