public static async Task<long> Create(Country item) { long results; using (var conn = await DataAccessBase.GetOpenAsync(DataAccessBase.QuangCateConn)) { const string sql = @"INSERT INTO Country(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; }
public static async Task<int> Update(Country item) { int results; using (var conn = await DataAccessBase.GetOpenAsync(DataAccessBase.QuangCateConn)) { string sql = @"update Country set Name=@Name, ShortName=@ShortName, Published=@Published, DisplayOrder=@DisplayOrder, Description = @Description where Id=@Id"; results = await conn.ExecuteAsync(sql, item); } return results; }
/// <summary> /// /// </summary> /// <param name="item"></param> /// <returns></returns> public static async Task<int> Update(Country item) { return await CountryDal.Update(item); }
/// <summary> /// /// </summary> /// <param name="item"></param> /// <returns></returns> public static async Task<long> Create(Country item) { return await CountryDal.Create(item); }