public bool AddOPMTitle(SeriesOPMTitleEntity entity, TransactionManager currentTransaction) { bool isSuccessfullyInserted = false; int retcode = -1; DbCommand commandWrapper = GetDbCommand("spr_AddSeriesOPMTitle"); try { if (entity.SeriesID <= 0) { commandWrapper.Parameters.Add(new SqlParameter("@Series", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@Series", entity.SeriesID)); } if (string.IsNullOrEmpty(entity.OPMTitle)) { commandWrapper.Parameters.Add(new SqlParameter("@SeriesOPMTitle", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@SeriesOPMTitle", entity.OPMTitle)); } if (string.IsNullOrEmpty(entity.OPMDescription)) { commandWrapper.Parameters.Add(new SqlParameter("@SeriesOPMTitleDescription", DBNull.Value)); } else { commandWrapper.Parameters.Add(new SqlParameter("@SeriesOPMTitleDescription", entity.OPMDescription)); } if (currentTransaction != null) { retcode = (int)DatabaseUtility.ExecuteScalar(currentTransaction, commandWrapper); } else { retcode = (int)ExecuteScalar(commandWrapper); } } catch (Exception ex) { currentTransaction.Rollback(); HandleException(ex); } if (retcode > 0) { isSuccessfullyInserted = true; } return(isSuccessfullyInserted); }
public static int SaveOrUpdateProduct(Product item) { string connectionString = ConfigurationManager.ConnectionStrings[ConnectionStringKey].ConnectionString; String commandText = @"test_SaveOrUpdateProduct"; var parameterList = new List <SqlParameter>(); var commandType = CommandType.StoredProcedure; parameterList.Add(DatabaseUtility.GetSqlParameter("ProductId", item.ProductId, SqlDbType.Int)); parameterList.Add(DatabaseUtility.GetSqlParameter("Name", item.Name.ToStr(), SqlDbType.NVarChar)); parameterList.Add(DatabaseUtility.GetSqlParameter("Description", item.Description.ToStr(), SqlDbType.NVarChar)); parameterList.Add(DatabaseUtility.GetSqlParameter("Price", item.Price, SqlDbType.Float)); int id = DatabaseUtility.ExecuteScalar(new SqlConnection(connectionString), commandText, commandType, parameterList.ToArray()).ToInt(); return(id); }