public async Task <HttpStatusCode> DeleteWhere(object list)
{
try
{
if (list == null)
{
return(HttpStatusCode.UnprocessableEntity);
}
var parameterSqlString = "";
Dictionary <string, object> values = PropertyValuesDict(list);
foreach (KeyValuePair <string, object> entry in values)
{
parameterSqlString = parameterSqlString + entry.Key + "= @" + entry.Key + " AND ";
}
string sql = $@"DELETE FROM `{DbName}` WHERE {parameterSqlString} DeactivatedOn IS NULL";
using (var con = new MySqlConnection(GetConnection()))
await con.ExecuteAsync(sql, list);
return(HttpStatusCode.OK);
}
catch (MySqlException e)
{
logger.LogError(e, e.Message);
return(MySqlExpcetionMapper.ExceptionHttpCode(e));
}
catch (Exception e)
{
logger.LogError(e, e.Message);
return(HttpStatusCode.InternalServerError);
}
}
public async Task <HttpStatusCode> Deactivate(T obj)
{
try
{
if (obj.DeactivatedOn == null)
{
obj.DeactivatedOn = DateTime.Now;
}
string sql = $@"
UPDATE `{DbName}`
SET
`DeactivatedOn` = @DeactivatedOn
WHERE
`Id` = @Id" ;
using (var con = new MySqlConnection(GetConnection()))
await con.ExecuteAsync(sql, obj);
return(HttpStatusCode.OK);
}
catch (MySqlException e)
{
return(MySqlExpcetionMapper.ExceptionHttpCode(e));
}
}
public async Task <HttpStatusCode> Update(T obj, string updateFields = null)
{
try
{
string sql = UpdateQuery <T>(updateFields);
using (var con = new MySqlConnection(GetConnection()))
await con.ExecuteAsync(sql, obj);
return(HttpStatusCode.OK);
}
catch (MySqlException e)
{
logger.LogError(e, e.Message);
return(MySqlExpcetionMapper.ExceptionHttpCode(e));
}
}
public async Task <HttpStatusCode> Add(T obj)
{
try
{
string sql = InsertQuery <T>();
using (var con = new MySqlConnection(GetConnection()))
await con.ExecuteAsync(sql, obj);
return(HttpStatusCode.OK);
}
catch (MySqlException e)
{
logger.LogError(e, e.Message);
return(MySqlExpcetionMapper.ExceptionHttpCode(e));
}
catch (Exception e)
{
logger.LogError(e, e.Message);
return(HttpStatusCode.InternalServerError);
}
}
public async Task <HttpStatusCode> Delete(T obj)
{
try
{
string sql = $@"DELETE FROM `{DbName}` WHERE `Id` = @Id";
using (var con = new MySqlConnection(GetConnection()))
await con.ExecuteAsync(sql, obj);
return(HttpStatusCode.OK);
}
catch (MySqlException e)
{
logger.LogError(e, e.Message);
return(MySqlExpcetionMapper.ExceptionHttpCode(e));
}
catch (Exception e)
{
logger.LogError(e, e.Message);
return(HttpStatusCode.InternalServerError);
}
}