private PartnerManagerResponse GetImageId(Guid partnershipId)
{
PartnerManagerResponse partnerManager = new PartnerManagerResponse();
if (partnershipId == default(Guid))
{
return(partnerManager);
}
Select query = new Select(UserConnection)
.Column("C", "PhotoId")
.Column("C", "Email")
.Column("C", "Name")
.From("Account").As("A")
.Join(JoinType.Inner, "Contact").As("C")
.On("C", "Id").IsEqual("A", "OwnerId")
.Join(JoinType.Inner, "Partnership").As("P")
.On("P", "AccountId").IsEqual("A", "Id")
.Where("P", "Id").IsEqual(Column.Parameter(partnershipId)) as Select;
using (DBExecutor dbExecutor = UserConnection.EnsureDBConnection()) {
using (IDataReader reader = query.ExecuteReader(dbExecutor)) {
reader.Read();
partnerManager.PhotoId = reader.GetColumnValue <Guid>("PhotoId");
partnerManager.Email = reader.GetColumnValue <string>("Email");
partnerManager.Name = reader.GetColumnValue <string>("Name");
}
}
return(partnerManager);
}
public PartnerManagerResponse GetManagerData()
{
Guid partnershipId = GetPartnershipId();
PartnerManagerResponse response = GetImageId(partnershipId);
return(response);
}
