/// <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; }