public async Task EditActivityRecord(ActivityRecordViewModel activityRecord)
{
var queryFactory = _dataAccess.GetQueryFactory(_connectionString);
var activityQuery = queryFactory.Query(TableConstants.ActivityRecordTable);
var item = activityQuery.Where(ActivityRecordConstants.Id, activityRecord.MyId);
await item.UpdateAsync(new Dictionary <string, object>
{
{ ActivityRecordConstants.Date, activityRecord.MyDate },
{ ActivityRecordConstants.DurationHours, activityRecord.MyDurationHours },
{ ActivityRecordConstants.Notes, activityRecord.MyNotes },
{ ActivityRecordConstants.Place, activityRecord.MyPlace },
{ ActivityRecordConstants.Title, activityRecord.MyTitle },
{ ActivityRecordConstants.SecurityReflection, activityRecord.MySecurityReflection }
});
}
public byte[] Report(ActivityRecordViewModel oActivityRecord)
{
_oActivityRecord = oActivityRecord;
_document = new Document(PageSize.A4, 10f, 10f, 20f, 30f);
_pdfTable.WidthPercentage = 100;
_pdfTable.HorizontalAlignment = Element.ALIGN_LEFT;
_pdfTable2.WidthPercentage = 100;
_pdfTable2.HorizontalAlignment = Element.ALIGN_LEFT;
_pdfTable3.WidthPercentage = 100;
_pdfTable3.HorizontalAlignment = Element.ALIGN_LEFT;
_pdfTable4.WidthPercentage = 100;
_pdfTable4.HorizontalAlignment = Element.ALIGN_LEFT;
_fontStyle = FontFactory.GetFont("Arial", 8f, 1);
PdfWriter.GetInstance(_document, _memoryStream);
_document.Open();
float[] sizes = new float[_maxColumn];
for (var i = 0; i < _maxColumn; i++)
{
if (i == 0)
{
sizes[i] = 50;
}
else
{
sizes[i] = 100;
}
}
_pdfTable.SetWidths(sizes);
this.ReportHeader();
this.ReportBody();
this.ReportBody2();
this.ReportBody3();
this.ReportBody4();
_pdfTable.HeaderRows = 2;
//_pdfTable2.HeaderRows = 2;
_document.Add(_pdfTable);
_document.Add(_pdfTable2);
_document.Add(_pdfTable3);
_document.Add(_pdfTable4);
_document.Close();
return(_memoryStream.ToArray());
}
public async Task <ActivityRecordViewModel> GetActivityRecord(int id)
{
var queryFactory = _dataAccess.GetQueryFactory(_connectionString);
var activityQuery = queryFactory.Query(TableConstants.ActivityRecordTable);
var membersQuery = queryFactory.Query(TableConstants.ActivityRecordMemberTable);
var commitmentQuery = queryFactory.Query(TableConstants.ActivityRecordCommitmentTable);
var projectQuery = queryFactory.Query(TableConstants.ProjectTable);
var item = (await activityQuery.Where(ActivityRecordConstants.Id, id)
.Include(TableConstants.ProjectTable, projectQuery,
ProjectConstants.ProjectId,
ActivityRecordConstants.ProjectId)
.IncludeMany(TableConstants.ActivityRecordMemberTable, membersQuery,
$"{ActivityRecordMemberConstants.ActivityRecordId}",
$"{ActivityRecordConstants.Id}")
.IncludeMany(TableConstants.ActivityRecordCommitmentTable, commitmentQuery,
$"{ActivityRecordCommitmentConstants.ActivityRecordId}",
$"{ActivityRecordConstants.Id}").GetAsync())
.Cast <IDictionary <string, object> >().ToList().First();
var project = (IDictionary <string, object>)item[TableConstants.ProjectTable];
var activityRecord = new ActivityRecordViewModel
{
MyId = (int)item[ActivityRecordConstants.Id],
MyDate = (DateTime)item[ActivityRecordConstants.Date],
MyDurationHours = (double?)item[ActivityRecordConstants.DurationHours],
MyNotes = (string)item[ActivityRecordConstants.Notes],
MyPlace = (string)item[ActivityRecordConstants.Place],
MyTitle = (string)item[ActivityRecordConstants.Title],
MySecurityReflection = (string)item[ActivityRecordConstants.SecurityReflection],
MyProjectName = (string)project[ProjectConstants.ProjectName],
MyProjectId = (int)project[ProjectConstants.ProjectId],
MyProjectCode = (string)project[ProjectConstants.ProjectCode]
};
var members = (IEnumerable <IDictionary <string, object> >)item[TableConstants.ActivityRecordMemberTable];
foreach (var member in members)
{
var activityRecordMember = new ActivityRecordMemberViewModel
{
MyId = (int)member[ActivityRecordMemberConstants.Id],
MyEmail = (string)member[ActivityRecordMemberConstants.Email],
MyRut = (string)member[ActivityRecordMemberConstants.Rut],
MyName = (string)member[ActivityRecordMemberConstants.Name],
MySurname = (string)member[ActivityRecordMemberConstants.Surname],
MyEnterprise = (string)member[ActivityRecordMemberConstants.Enterprise],
MyBminingId = (int?)member[ActivityRecordMemberConstants.BminingId],
IsBminingMember = (ulong)member[ActivityRecordMemberConstants.IsBminingMember] == 1,
};
activityRecord.OurMembers.Add(activityRecordMember);
}
var commitments = (IEnumerable <IDictionary <string, object> >)item[TableConstants.ActivityRecordCommitmentTable];
foreach (var commitment in commitments)
{
var activityRecordCommitment = new ActivityRecordCommitmentViewModel
{
MyId = (int)commitment[ActivityRecordCommitmentConstants.Id],
MyResponsible = (string)commitment[ActivityRecordCommitmentConstants.Responsible],
MyCommitment = (string)commitment[ActivityRecordCommitmentConstants.Commitment],
MyCommitmentDate = (DateTime)commitment[ActivityRecordCommitmentConstants.CommitmentDate],
MyStatus = (ActivityRecordStatusEnum)commitment[ActivityRecordCommitmentConstants.ActivityRecordStatus]
};
activityRecord.OurCommitments.Add(activityRecordCommitment);
}
return(activityRecord);
}
