public async Task <GroupCreation> AttachFile(int groupId, int userId, GroupCreation groupCreation)
{
GroupUserEntity userGroup = await DbContext.GroupsUsersRepo.GetByUserIdAndGroupId(userId, groupId);
if (userGroup == null)
{
ThrowHttpResponseException(System.Net.HttpStatusCode.Unauthorized, "Access is denied.");
}
ValidateUserAsAuthenticated(userGroup.UserId);
CreationEntity creation = await DbContext.CreationsRepo.GetSingleOrDefaultAsync(groupCreation.CreationId);
if (creation == null)
{
ThrowHttpResponseException(System.Net.HttpStatusCode.NotFound, string.Format("Creation with id {0} not found.", groupCreation.CreationId));
}
GroupCreationEntity groupCreationEntity = await DbContext.GroupCreationsRepo.CreateAsync(
new GroupCreationEntity()
{
CreationId = creation.Id,
GroupId = groupCreation.GroupId,
}).ConfigureAwait(false);
return(groupCreationEntity.ToContract());
}
public List <GroupCreation> GetGroupChildMembersDetailsOnId(Int64 groupId, string connectionString)
{
groupList = new List <GroupCreation>();
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(connectionString, CommandType.Text, "select recordid,contactid,contactreferenceid,contactname,contactnumber,roleingroup,case when roleingroup like 'Group Head%' then 1 else 2 end as orderid from tblgroupnamewisemembers where groupid=" + groupId + " and statusid=" + Convert.ToInt32(Status.Active) + " order by orderid asc;"))
{
while (dr.Read())
{
GroupCreation objGroupDetails = new GroupCreation();
objGroupDetails.pRecordId = Convert.ToInt64(dr["recordid"]);
objGroupDetails.pContactID = Convert.ToInt64(dr["contactid"]);
objGroupDetails.pContactRefId = Convert.ToString(dr["contactreferenceid"]);
objGroupDetails.pContactName = Convert.ToString(dr["contactname"]);
objGroupDetails.pContactNo = Convert.ToString(dr["contactnumber"]);
objGroupDetails.pRoleInGroup = Convert.ToString(dr["roleingroup"]);
groupList.Add(objGroupDetails);
}
}
}
catch (Exception)
{
throw;
}
return(groupList);
}
