public async Task <int> SaveAssetSettings(SaveAssetInfo asset) { int result = 1; List <SQLParam> sQLParam = new List <SQLParam>(); sQLParam.Add(new SQLParam("@BundleAssetID", asset.AssetID)); sQLParam.Add(new SQLParam("@Name", asset.Names)); sQLParam.Add(new SQLParam("@AssetType", asset.AssetType)); sQLParam.Add(new SQLParam("@Position", asset.Position)); sQLParam.Add(new SQLParam("@FilePath", asset.FilePath)); sQLParam.Add(new SQLParam("@IsExternal", asset.IsExternal)); sQLParam.Add(new SQLParam("@ExcessMode", asset.ExcessMode)); sQLParam.Add(new SQLParam("@Application", asset.Application)); sQLParam.Add(new SQLParam("@UserAreaID", asset.UserAreaID)); sQLParam.Add(new SQLParam("@Roles", asset.Roles)); try { SQLExecuteNonQueryAsync objSQL = new SQLExecuteNonQueryAsync(); await objSQL.ExecuteNonQueryAsync("[dbo].[usp_Asset_Save]", sQLParam); } catch { throw; } return(result); }
public async Task <SaveAssetInfo> GetAssetSettingByID(int bundleAssetID) { List <SQLParam> sQLParam = new List <SQLParam>(); sQLParam.Add(new SQLParam("@BundleAssetID", bundleAssetID)); SaveAssetInfo bundleAsset = new SaveAssetInfo(); try { SQLGetAsync objSQL = new SQLGetAsync(); bundleAsset = await objSQL.ExecuteAsObjectAsync <SaveAssetInfo>("[dbo].[usp_Asset_Settings_GetByID]", sQLParam); } catch { throw; } return(bundleAsset); }
public async Task <int> SaveAssetSettings(SaveAssetInfo asset) { AssetDataprovider assetDataprovider = new AssetDataprovider(); return(await assetDataprovider.SaveAssetSettings(asset)); }