public UserReview Map(UserReviewDb userReview)
{
UserReview userReview_newType = new UserReview();
#region Transfer main attributes
userReview_newType.Id = userReview.Id;
userReview_newType.Content = userReview.Content;
userReview_newType.CreateDate = userReview.CreateDate;
userReview_newType.Rating = userReview.Rating;
#endregion
#region Transfering interop attributes
userReview_newType.IdReviewer = new User()
{
Id = userReview.IdReviewer
};
userReview_newType.IdReviewed = new User()
{
Id = userReview.IdReviewed
};
#endregion
return(userReview_newType);
}
/// <summary>
/// Return the UserReviewDb object with interop properties
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public UserReviewDb GetExtended(long id)
{
UserReviewDb userReview = Get(id);
//userReview.PlayersList = GetPlayersList(id);
return(userReview);
}
// Here they will be
#endregion
#endregion
public long Save(UserReviewDb userReview)
{
EntityORM entity = EntityMapping.Map(userReview, attributes);
// Making sure that ID value is not touched.
entity.attributeValue.Remove("ID");
long idUserReview = crud.Create(table, idColumn, entity);
return(idUserReview);
}
public UserReview Get(long id)
{
UserReviewDb userReview = userReviewDAO.GetExtended(id);
UserReview userReview_newTyped = null;
if (userReview != null)
{
userReview_newTyped = mapper.Map(userReview);
}
return(userReview_newTyped);
}
public UserReviewDb Get(long id)
{
UserReviewDb userReview = null;
List <EntityORM> entities = (List <EntityORM>)(crud.Read(table, attributes, new DbTools.WhereRequest[] { new DbTools.WhereRequest(idColumn, DbTools.RequestOperator.Equal, id) }));
if (entities.Any())
{
EntityMapping.Map(entities[0], out userReview);
}
return(userReview);
}
public UserReviewDb Get(long id)
{
UserReviewDb userReview = null;
EntityORM entity = crud.Read(id, idColumn, attributes, table);
if (entity != null)
{
EntityMapping.Map(entity, out userReview);
}
return(userReview);
}
public void Update(UserReviewDb userReview)
{
EntityORM entity = EntityMapping.Map(userReview, attributes);
// Making sure that ID value is not touched.
entity.attributeValue.Remove("ID");
bool ifUpdated = crud.Update(userReview.Id, table, idColumn, entity);
if (ifUpdated)
{
logger.Info($"Game with id={userReview.Id} was successfully updated.");
}
else
{
logger.Info($"Updating userReview with id={userReview.Id} was failed.");
}
}
///<summary>
///Maps properties from UserReviewDb object to EntityORM object
///</summary>
public static EntityORM Map(UserReviewDb userReview, HashSet <string> attributes)
{
EntityORM entity = new EntityORM();
foreach (string attribute in attributes)
{
object value = null; // attribute value
switch (attribute)
{
case "IDREVIEWER":
value = userReview.IdReviewer;
break;
case "IDREVIEWED":
value = userReview.IdReviewed;
break;
case "CONTENT":
value = $"\'userReview.Content\'";
break;
case "CREATEDATE":
value = $"\'{userReview.CreateDate.ToString("dd-MMM-yyyy")}\'";
break;
case "RATING":
value = userReview.Rating;
break;
default:
break;
}
entity.attributeValue.Add(attribute, value);
}
return(entity);
}
///<summary>
///Maps properties from EntityORM object to UserReviewDb object
///</summary>
public static void Map(EntityORM entity, out UserReviewDb userReview)
{
userReview = new UserReviewDb();
foreach (KeyValuePair <string, object> aV in entity.attributeValue)
{
switch (aV.Key) // entity attribute
{
case "ID":
userReview.Id = Convert.ToInt64(aV.Value);
break;
case "IDREVIEWER":
userReview.IdReviewer = Convert.ToInt64(aV.Value);
break;
case "IDREVIEWED":
userReview.IdReviewed = Convert.ToInt64(aV.Value);
break;
case "CONTENT":
userReview.Content = aV.Value.ToString();
break;
case "CREATEDATE":
userReview.CreateDate = (DateTime)aV.Value;
break;
case "RATING":
userReview.Rating = (int)aV.Value;
break;
default:
break;
}
}
}
public void Update(UserReview userReview)
{
UserReviewDb userReviewDb = mapper.Map(userReview);
userReviewDAO.Update(userReviewDb);
}
public long Create(UserReview userReview)
{
UserReviewDb userReviewDb = mapper.Map(userReview);
return(userReviewDAO.Save(userReviewDb));
}
