public UserActivityDTO ConvertItemToDto(CommunityMetrics_UserActivity item)
{
UserActivityDTO dto = new UserActivityDTO();
dto.id = item.id;
dto.activity_id = item.activity_id;
dto.user_id = item.user_id;
dto.date = item.date;
dto.count = item.count;
dto.notes = item.notes;
dto.created_on_date = item.created_on_date;
if (!string.IsNullOrWhiteSpace(item.User.DisplayName))
{
dto.user_name = item.User.DisplayName;
}
else
{
dto.user_name = item.User.FirstName + " " + item.User.LastName;
}
dto.activity_name = item.CommunityMetrics_Activity.name;
return(dto);
}
public HttpResponseMessage Post(UserActivityDTO dto)
{
try
{
CommunityMetrics_UserActivity item = ConvertDtoToItem(null, dto);
item.created_on_date = DateTime.Now;
dc.CommunityMetrics_UserActivities.InsertOnSubmit(item);
dc.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK, ConvertItemToDto(item)));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage Get(int id)
{
try
{
CommunityMetrics_UserActivity item = dc.CommunityMetrics_UserActivities.Where(i => i.id == id).SingleOrDefault();
if (item == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
return(Request.CreateResponse(HttpStatusCode.OK, ConvertItemToDto(item)));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex));
}
}
public CommunityMetrics_UserActivity ConvertDtoToItem(CommunityMetrics_UserActivity item, UserActivityDTO dto)
{
if (item == null)
{
item = new CommunityMetrics_UserActivity();
}
if (dto == null)
{
return(item);
}
item.id = dto.id;
item.activity_id = dto.activity_id;
item.user_id = dto.user_id;
item.date = dto.date;
item.count = dto.count;
item.notes = dto.notes;
item.created_on_date = dto.created_on_date;
return(item);
}
public void SaveUserActivity(UserActivityDTO dto)
{
// prevents saving of duplicate activity
CommunityMetrics_UserActivity user_activity = dc.CommunityMetrics_UserActivities.Where(i => i.activity_id == dto.activity_id && i.user_id == dto.user_id && i.date == dto.date).SingleOrDefault();
if (user_activity == null)
{
user_activity = new CommunityMetrics_UserActivity()
{
activity_id = dto.activity_id,
user_id = dto.user_id
};
dc.CommunityMetrics_UserActivities.InsertOnSubmit(user_activity);
}
user_activity.count = dto.count;
user_activity.notes = dto.notes;
user_activity.date = dto.date;
user_activity.created_on_date = DateTime.Now;
dc.SubmitChanges();
}
public HttpResponseMessage Delete(int id)
{
try
{
CommunityMetrics_UserActivity item = dc.CommunityMetrics_UserActivities.Where(i => i.id == id).SingleOrDefault();
if (item == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
dc.CommunityMetrics_UserActivities.DeleteOnSubmit(item);
dc.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage Put(UserActivityDTO dto)
{
try
{
CommunityMetrics_UserActivity item = dc.CommunityMetrics_UserActivities.Where(i => i.id == dto.id).SingleOrDefault();
if (item == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
item = ConvertDtoToItem(item, dto);
dc.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK, ConvertItemToDto(item))); // send back the updated record
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex));
}
}
