public void ClearTables() { string query = @" DELETE FROM [dbo].[Transaction] "; IList <SqlParameter> sqlParameterCollection = new List <SqlParameter>(); SqlService.ExecuteNonQuery(query, sqlParameterCollection.ToArray()); }
public void Delete(int id) { string query = @" DELETE FROM [dbo].[Transaction] WHERE Id = @Id"; IList <SqlParameter> sqlParameterCollection = new List <SqlParameter>(); sqlParameterCollection.Add(new SqlParameter("@Id", id)); SqlService.ExecuteNonQuery(query, sqlParameterCollection.ToArray()); }
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())); } }