/// <summary>
///
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public static async Task<long> Create(Region item)
{
long results;
using (var conn = await DataAccessBase.GetOpenAsync(DataAccessBase.QuangCateConn))
{
const string sql = @"INSERT INTO Regions(Name,ShortName,Published,DisplayOrder, Description) values(@Name,@ShortName,@Published,@DisplayOrder,@Description);
SELECT CONVERT(LAST_INSERT_ID() , UNSIGNED INTEGER) AS id;";
var id = await conn.QueryAsync<ulong>(sql, item);
results = (long)id.Single();
}
return results;
}
/// <summary>
///
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public static async Task<int> Update(Region item)
{
int results;
using (var conn = await DataAccessBase.GetOpenAsync(DataAccessBase.QuangCateConn))
{
string sql = @"update Regions set Name=@Name,
ShortName=@ShortName,
Published=@Published,
DisplayOrder=@DisplayOrder,
Description = @Description
where Id=@Id";
results = await conn.ExecuteAsync(sql, item);
}
return results;
}
