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