public int Save(ICustomer customer)
{
String query = @"INSERT INTO [dbo].[Customer]
([Name]
,[Description]
,[Active]
,[DefaultTransactionTypeId])
OUTPUT INSERTED.Id
VALUES
( @Name
, @Description
, @Active
, @DefaultTransactionTypeId)";
if (customer.Id != 0)
{
query = @"UPDATE [dbo].[Customer]
SET [Name] = @Name
,[Description] = @Description
,[Active] = @Active
,[DefaultTransactionTypeId] = @DefaultTransactionTypeId
WHERE Id = @Id";
}
IList <SqlParameter> sqlParameterCollection = new List <SqlParameter>();
sqlParameterCollection.Add(new SqlParameter("@Name", customer.Name));
sqlParameterCollection.Add(new SqlParameter("@Description", customer.Description));
sqlParameterCollection.Add(new SqlParameter("@Active", customer.Active));
if (customer.DefaultTransactionTypeId.HasValue)
{
sqlParameterCollection.Add(new SqlParameter("@DefaultTransactionTypeId", customer.DefaultTransactionTypeId.Value));
}
else
{
sqlParameterCollection.Add(new SqlParameter("@DefaultTransactionTypeId", DBNull.Value));
}
if (customer.Id != 0)
{
sqlParameterCollection.Add(new SqlParameter("@Id", customer.Id));
SqlService.ExecuteNonQuery(query, sqlParameterCollection.ToArray());
return(customer.Id);
}
else
{
return(SqlService.ExecuteScalar(query, sqlParameterCollection.ToArray()));
}
}
public int Save(ITransaction transaction)
{
string query = @"INSERT INTO [dbo].[Transaction]
([Name]
,[Description]
,[Value]
,[TransactionTypeId]
,[CustomerId]
,[Date])
OUTPUT INSERTED.Id
VALUES
( @Name
, @Description
, @Value
, @TransactionTypeId
, @CustomerId
, @Date )";
if (transaction.Id != 0)
{
query = @"UPDATE [dbo].[Transaction]
SET [Name] = @Name
,[Description] = @Description
,[Value] = @Value
,[TransactionTypeId] = @TransactionTypeId
,[CustomerId] = @CustomerId
,[Date] = @Date
WHERE Id = @Id";
}
IList <SqlParameter> sqlParameterCollection = new List <SqlParameter>();
if (string.IsNullOrWhiteSpace(transaction.Name))
{
sqlParameterCollection.Add(new SqlParameter("@Name", DBNull.Value));
}
else
{
sqlParameterCollection.Add(new SqlParameter("@Name", transaction.Name));
}
if (string.IsNullOrWhiteSpace(transaction.Description))
{
sqlParameterCollection.Add(new SqlParameter("@Description", DBNull.Value));
}
else
{
sqlParameterCollection.Add(new SqlParameter("@Description", transaction.Description));
}
sqlParameterCollection.Add(new SqlParameter("@Value", transaction.Value));
sqlParameterCollection.Add(new SqlParameter("@TransactionTypeId", transaction.TransactionTypeId));
sqlParameterCollection.Add(new SqlParameter("@Date", transaction.Date));
if (transaction.CustomerId.HasValue)
{
sqlParameterCollection.Add(new SqlParameter("@CustomerId", transaction.CustomerId));
}
else
{
sqlParameterCollection.Add(new SqlParameter("@CustomerId", DBNull.Value));
}
if (transaction.Id != 0)
{
sqlParameterCollection.Add(new SqlParameter("@Id", transaction.Id));
SqlService.ExecuteNonQuery(query, sqlParameterCollection.ToArray());
return(transaction.Id);
}
else
{
return(SqlService.ExecuteScalar(query, sqlParameterCollection.ToArray()));
}
}
public int Save(ITransactionType transactionType)
{
string query = @"INSERT INTO [dbo].[TransactionType]
([Name]
,[Description]
,[Color]
,[Income])
OUTPUT INSERTED.Id
VALUES
( @Name
, @Description
, @Color
, @Income)";
if (transactionType.Id != 0)
{
query = @"UPDATE [dbo].[TransactionType]
SET [Name] = @Name
,[Description] = @Description
,[Color] = @Color
,[Income] = @Income
WHERE Id = @Id";
}
IList <SqlParameter> sqlParameterCollection = new List <SqlParameter>();
sqlParameterCollection.Add(new SqlParameter("@Income", transactionType.Income));
if (string.IsNullOrWhiteSpace(transactionType.Description))
{
sqlParameterCollection.Add(new SqlParameter("@Description", DBNull.Value));
}
else
{
sqlParameterCollection.Add(new SqlParameter("@Description", transactionType.Description));
}
if (string.IsNullOrWhiteSpace(transactionType.Name))
{
sqlParameterCollection.Add(new SqlParameter("@Name", DBNull.Value));
}
else
{
sqlParameterCollection.Add(new SqlParameter("@Name", transactionType.Name));
}
if (string.IsNullOrWhiteSpace(transactionType.Color))
{
sqlParameterCollection.Add(new SqlParameter("@Color", DBNull.Value));
}
else
{
sqlParameterCollection.Add(new SqlParameter("@Color", transactionType.Color));
}
if (transactionType.Id != 0)
{
sqlParameterCollection.Add(new SqlParameter("@Id", transactionType.Id));
SqlService.ExecuteNonQuery(query, sqlParameterCollection.ToArray());
return(transactionType.Id);
}
else
{
return(SqlService.ExecuteScalar(query, sqlParameterCollection.ToArray()));
}
}
