public async static Task <IDTO> AddUpdateMode(Acttribute busnies) { string SPName = ""; string message = ""; OracleDynamicParameters oracleParams = new OracleDynamicParameters(); ComplateOperation <int> complate = new ComplateOperation <int>(); if (busnies.ID.HasValue) { oracleParams.Add(AttributesSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)busnies.ID ?? DBNull.Value); SPName = AttributesPName.SP_UPADTE_Attribute; message = "Updated Successfully"; } else { oracleParams.Add(AttributesSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output); SPName = AttributesPName.SP_INSERT_Attribute; message = "Inserted Successfully"; } oracleParams.Add(AttributesSpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)busnies.Name ?? DBNull.Value, 1000); oracleParams.Add(AttributesSpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)busnies.Name2 ?? DBNull.Value, 1000); oracleParams.Add(AttributesSpParams.PARAMETER_TYPE, OracleDbType.Long, ParameterDirection.Input, (object)busnies.Type ?? DBNull.Value, 1000); if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1) { complate.message = message; } else { complate.message = "Operation Failed"; } return(complate); }
public async static Task <IDTO> DeleteAttributeAsync(Acttribute Attribute) { OracleDynamicParameters oracleParams = new OracleDynamicParameters(); ComplateOperation <int> complate = new ComplateOperation <int>(); var dyParam = new OracleDynamicParameters(); dyParam.Add(AttributesSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)Attribute.ID ?? DBNull.Value); if (await NonQueryExecuter.ExecuteNonQueryAsync(AttributesPName.SP_DELETE_Attribute, dyParam) == -1) { complate.message = "Operation Successed"; } else { complate.message = "Operation Failed"; } return(complate); }