///<summary>
///Maps properties from UserConnectionDb object to EntityORM object
///</summary>
public static EntityORM Map(UsersConnectionDb userConnection, HashSet <string> attributes)
{
EntityORM entity = new EntityORM();
foreach (string attribute in attributes)
{
object value = null; // attribute value
switch (attribute)
{
case "AREFRIENDS":
value = (userConnection.AreFriends) ? "\'y\'" : "\'n\'";
break;
case "BLACKLISTED":
value = (userConnection.BlackListed) ? "\'y\'": "\'n\'";
break;
case "IDUSER1":
value = $"\'{ userConnection.IdUser1}\'";
break;
case "IDUSER2":
value = $"\'{userConnection.IdUser2}\'";
break;
default:
break;
}
entity.attributeValue.Add(attribute, value);
}
return(entity);
}
public bool Unsubscribe(UsersConnectionDb usersConnection)
{
var where_attributes = new Dictionary <string, object>()
{
{ "IDUSER1", usersConnection.IdUser1 },
{ "IDUSER2", usersConnection.IdUser2 }
};
bool isUnsubscribed = Delete(table, attributes, where_attributes);
UsersConnectionDb symmetricConnection = new UsersConnectionDb()
{
IdUser1 = usersConnection.IdUser2, IdUser2 = usersConnection.IdUser1
};
if (ConnectionExists(symmetricConnection))
{
where_attributes["IDUSER1"] = symmetricConnection.IdUser1;
where_attributes["IDUSER2"] = symmetricConnection.IdUser2;
symmetricConnection.AreFriends = false;
EntityORM symmetricConnection_newTyped = Mapping.EntityMapping.Map(symmetricConnection, attributes);
// Making sure that ID value is not touched.
symmetricConnection_newTyped.attributeValue.Remove("ID");
Update(table, attributes, where_attributes, symmetricConnection_newTyped);
}
return(isUnsubscribed);
}
public static EntityORM Map(VerificationDb verify, HashSet <string> attributes)
{
EntityORM entity = new EntityORM();
foreach (string attribute in attributes)
{
object value = null;
switch (attribute)
{
case "EMAIL":
value = $"\'{verify.Email}\'";
break;
case "TOKEN":
value = $"\'{verify.Token}\'";
break;
case "ENDVERIFYDATE":
value = $"TO_TIMESTAMP(\'{verify.EndVerifyDate.ToString("dd.MM.yyyy HH:mm:ss")}\', 'DD.MM.YYYY HH24:MI:SS')";
break;
}
entity.attributeValue.Add(attribute, value);
}
return(entity);
}
///<summary>
///Maps properties from EntityORM object to UseConnectionrDb object
///</summary>
public static void Map(EntityORM entity, out UsersConnectionDb userConnection)
{
userConnection = new UsersConnectionDb();
foreach (KeyValuePair <string, object> aV in entity.attributeValue)
{
switch (aV.Key) // attribute
{
case "ID":
userConnection.Id = Convert.ToInt64(aV.Value);
break;
case "IDUSER1":
userConnection.IdUser1 = Convert.ToInt64(aV.Value);
break;
case "IDUSER2":
userConnection.IdUser2 = Convert.ToInt64(aV.Value);
break;
case "AREFRIENDS":
userConnection.AreFriends = ((string)aV.Value == "y") ? true : false;
break;
case "BLACKLISTED":
userConnection.BlackListed = ((string)aV.Value == "y") ? true : false;
break;
default:
break;
}
}
}
// Here they will be
#endregion
#endregion
public long Save(GameReviewDb gameReview)
{
EntityORM entity = EntityMapping.Map(gameReview, attributes);
entity.attributeValue.Remove("ID"); // getting sure that ID value is not touched
long idGameReview = crud.Create(table, idColumn, entity);
return(idGameReview);
}
// Here they will be
#endregion
#endregion
public long Save(StatisticsDb statistics)
{
EntityORM entity = EntityMapping.Map(statistics, attributes);
entity.attributeValue.Remove("ID"); // getting sure that ID value is not touched
long idStatistic = crud.Create(table, idColumn, entity);
return(idStatistic);
}
public long Save(VerificationDb verify)
{
EntityORM entity = EntityMapping.Map(verify, attributes);
long verify_id = crud.Create(table, idColumn, entity, false);
logger.Info($"User with id = {verify_id} was created");
return(verify_id);
}
public long Save(GameDb game)
{
EntityORM entity = EntityMapping.Map(game, attributes);
// Making sure that ID value is not touched.
entity.attributeValue.Remove("ID");
long idGame = crud.Create(table, idColumn, entity);
return(idGame);
}
// Here they will be
#endregion
#endregion
public long Save(ChatDb chat)
{
EntityORM entity = EntityMapping.Map(chat, attributes);
// Making sure that ID value is not touched.
entity.attributeValue.Remove("ID");
long idChat = crud.Create(table, idColumn, entity);
return(idChat);
}
// 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 VerificationDb Get(object id)
{
VerificationDb verify = null;
EntityORM entity = crud.Read(id, "TOKEN", attributes, table);
if (entity != null)
{
EntityMapping.Map(entity, out verify);
}
return(verify);
}
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 GameDb Get(object id)
{
GameDb game = null;
EntityORM entity = crud.Read(id, idColumn, attributes, table);
if (entity != null)
{
EntityMapping.Map(entity, out game);
}
return(game);
}
public MessageDb Get(long id)
{
MessageDb message = null;
EntityORM entity = crud.Read(id, idColumn, attributes, table);
if (entity != null)
{
EntityMapping.Map(entity, out message);
}
return(message);
}
public GameReviewDb Get(long id)
{
GameReviewDb gameReview = null;
EntityORM entity = crud.Read(id, idColumn, attributes, table);
if (entity != null)
{
EntityMapping.Map(entity, out gameReview);
}
return(gameReview);
}
public long Save(UserDb user)
{
EntityORM entity = EntityMapping.Map(user, attributes);
// Making sure that ID value is not touched.
entity.attributeValue.Remove("ID");
long user_id = crud.Create(table, idColumn, entity);
logger.Info($"User with id = {user_id} was created");
return(user_id);
}
public ChatDb Get(long id)
{
ChatDb chat = null;
EntityORM entity = crud.Read(id, idColumn, attributes, table);
if (entity != null)
{
EntityMapping.Map(entity, out chat);
}
return(chat);
}
public StatisticsDb Get(long id)
{
StatisticsDb statistics = null;
EntityORM entity = crud.Read(id, idColumn, attributes, table);
if (entity != null)
{
EntityMapping.Map(entity, out statistics);
}
return(statistics);
}
private bool ConnectionExists(UsersConnectionDb usersConnection)
{
var where_attributes = new Dictionary <string, object>()
{
{ "IDUSER1", usersConnection.IdUser1 },
{ "IDUSER2", usersConnection.IdUser2 }
};
EntityORM usersConnection_newTyped = Get(table, attributes, where_attributes);
return(usersConnection_newTyped != null);
}
public bool CreateConnection(UsersConnectionDb usersConnection)
{
if (ConnectionExists(usersConnection))
{
return(false);
}
bool isCreated = false;
UsersConnectionDb symmetricConnection = new UsersConnectionDb()
{
IdUser1 = usersConnection.IdUser2, IdUser2 = usersConnection.IdUser1
};
var where_attributes = new Dictionary <string, object>()
{
{ "IDUSER1", symmetricConnection.IdUser2 },
{ "IDUSER2", symmetricConnection.IdUser1 }
};
EntityORM entity = Get(table, attributes, where_attributes);
if (entity != null)
{
if ((bool)entity.attributeValue["BLACKLISTED"])
{
return(isCreated);
}
where_attributes = new Dictionary <string, object>()
{
{ "IDUSER1", usersConnection.IdUser1 },
{ "IDUSER2", usersConnection.IdUser2 }
};
symmetricConnection.AreFriends = true;
EntityORM symmetricConnection_newTyped = Mapping.EntityMapping.Map(symmetricConnection, attributes);
Update(table, attributes, where_attributes, symmetricConnection_newTyped);
usersConnection.AreFriends = true;
}
isCreated = Save(usersConnection);
return(isCreated);
}
///<summary>
///Maps properties from GameDb object to EntityORM object
///</summary>
public static EntityORM Map(GameDb game, HashSet <string> attributes)
{
EntityORM entity = new EntityORM();
foreach (string attribute in attributes)
{
object value = null; // attribute value
switch (attribute)
{
case "NAME":
value = $"\'{game.Name}\'";
break;
case "DESCRIPTION":
value = $"\'{game.Description}\'";
break;
case "GENRE":
value = $"\'{game.Genre}\'";
break;
case "LINK":
value = $"\'{game.Link}\'";
break;
case "LOGOURL":
value = $"\'{game.LogoURL}\'";
break;
case "COVERURL":
value = $"\'{game.CoverURL}\'";
break;
case "ISVERIFIED":
value = (game.IsVerified) ? "\'y\'" : "\'n\'";
break;
default:
break;
}
entity.attributeValue.Add(attribute, value);
}
return(entity);
}
public void Update(GameReviewDb gameReview)
{
EntityORM entity = EntityMapping.Map(gameReview, attributes);
entity.attributeValue.Remove("ID"); // getting sure that ID value is not touched
bool ifUpdated = crud.Update(gameReview.Id, table, idColumn, entity);
if (ifUpdated)
{
logger.Info($"Game review with id={gameReview.Id} was successfully updated.");
}
else
{
logger.Info($"Updating gameReview with id={gameReview.Id} was failed.");
}
}
public void Update(StatisticsDb statistics)
{
EntityORM entity = EntityMapping.Map(statistics, attributes);
entity.attributeValue.Remove("ID"); // getting sure that ID value is not touched
bool ifUpdated = crud.Update(statistics.Id, table, idColumn, entity);
if (ifUpdated)
{
logger.Info($"Game statistics with id={statistics.Id} was successfully updated.");
}
else
{
logger.Info($"Updating statistics with id={statistics.Id} was failed.");
}
}
public void Update(ChatDb chat)
{
EntityORM entity = EntityMapping.Map(chat, attributes);
entity.attributeValue.Remove("ID"); // getting sure that ID value is not touched
bool ifUpdated = crud.Update(chat.Id, table, idColumn, entity);
if (ifUpdated)
{
logger.Info($"Game with id={chat.Id} was successfully updated.");
}
else
{
logger.Info($"Updating chat with id={chat.Id} was failed.");
}
}
///<summary>
///Maps properties from EntityORM object to GameDb object
///</summary>
public static void Map(EntityORM entity, out GameDb game)
{
game = new GameDb();
foreach (KeyValuePair <string, object> aV in entity.attributeValue)
{
switch (aV.Key) // entity attribute
{
case "ID":
game.Id = Convert.ToInt64(aV.Value);
break;
case "NAME":
game.Name = aV.Value.ToString();
break;
case "DESCRIPTION":
game.Description = aV.Value.ToString();
break;
case "GENRE":
game.Genre = aV.Value.ToString();
break;
case "LINK":
game.Link = aV.Value.ToString();
break;
case "LOGOURL":
game.LogoURL = aV.Value.ToString();
break;
case "COVERURL":
game.CoverURL = aV.Value.ToString();
break;
case "ISVERIFIED":
game.IsVerified = ((string)aV.Value == "y") ? true : false;
break;
default:
break;
}
}
}
public bool CreateConnection(UsersConnectionDb usersConnection)
{
if (ConnectionExists(usersConnection))
{
return(false);
}
bool isCreated = false;
UsersConnectionDb symmetricConnection = new UsersConnectionDb()
{
IdUser1 = usersConnection.IdUser2, IdUser2 = usersConnection.IdUser1
};
var where_attributes = new Dictionary <string, object>()
{
{ "IDUSER1", symmetricConnection.IdUser1 },
{ "IDUSER2", symmetricConnection.IdUser2 }
};
EntityORM entity = Get(table, attributes, where_attributes);
if (entity != null)
{
if (DbTools.ProcessBoolean(entity.attributeValue["BLACKLISTED"]))
{
return(isCreated);
}
symmetricConnection.AreFriends = true;
EntityORM symmetricConnection_newTyped = Mapping.EntityMapping.Map(symmetricConnection, attributes);
// Making sure that ID value is not touched.
symmetricConnection_newTyped.attributeValue.Remove("ID");
Update(table, attributes, where_attributes, symmetricConnection_newTyped);
usersConnection.AreFriends = true;
}
isCreated = Save(usersConnection);
return(isCreated);
}
public void Update(MessageDb message)
{
EntityORM entity = EntityMapping.Map(message, attributes);
// Making sure that ID value is not touched
entity.attributeValue.Remove("ID");
bool ifUpdated = crud.Update(message.Id, table, idColumn, entity);
if (ifUpdated)
{
logger.Info($"Game with id={message.Id} was successfully updated.");
}
else
{
logger.Info($"Updating message with id={message.Id} was failed.");
}
}
public UserDb GetByUniqueAttribute(object attribute_value, string attribute_name)
{
UserDb user = null;
if (!unique_attributes.Contains(attribute_name))
{
logger.Info($"{attribute_name} is not unique attribute. GET-method failed..");
return(user);
}
EntityORM entity = crud.Read(attribute_value, attribute_name, attributes, table);
if (entity != null)
{
EntityMapping.Map(entity, out user);
}
return(user);
}
/// <summary>
/// Gets all the records which satisfy sql-expression with WHERE keyword. In the other way returns null.
/// </summary>
/// <param name="table"></param>
/// <param name="attributes"></param>
/// <param name="where_attributes"></param>
/// <returns></returns>
private List <EntityORM> GetAll(string table, HashSet <string> attributes, Dictionary <string, object> where_attributes)
{
List <EntityORM> entities = null;
try
{
dbConnect.OpenConnection();
string where_part = string.Join(" AND ", where_attributes.Select(x => string.Format("{0}={1}", x.Key, x.Value)));
string sqlExpression = String.Format("SELECT * FROM {0} WHERE {1}", table, where_part);
OracleCommand command = new OracleCommand(sqlExpression, dbConnect.GetConnection());
OracleDataReader reader = command.ExecuteReader();
if (reader.Read())
{
entities = new List <EntityORM>();
do
{
EntityORM entity = new EntityORM();
foreach (string attribute in attributes)
{
object value = reader[attribute];
entity.attributeValue.Add(attribute, value);
}
entities.Add(entity);
} while (reader.Read());
}
}
catch (DbException ex)
{
logger.Info("Exception.Message: {0}", ex.Message);
}
finally
{
dbConnect.CloseConnection();
}
return(entities);
}
public bool Save(UsersConnectionDb usersConnection)
{
bool isSaved = false;
EntityORM entity = EntityMapping.Map(usersConnection, attributes);
// Making sure that ID value is not touched.
entity.attributeValue.Remove("ID");
long userConnection_id = crud.Create(table, idColumn, entity);
if (userConnection_id != 0)
{
logger.Info($"UsersConnection with id = {userConnection_id} was created");
isSaved = true;
}
return(isSaved);
}
