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