public static List<Address> GetAddressByPersonId(Guid personId)
{
List<Address> addressList = new List<Address>();
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (GetAddressByPersonIdCommand objectCommand = new GetAddressByPersonIdCommand(objectConnection))
{
objectCommand.PersonId = personId;
objectConnection.Open();
using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
{
if (!sqlDataReader.HasRows)
{
return addressList;
}
using (AddressSqlDataReader objectSqlDataReader = new AddressSqlDataReader(sqlDataReader))
{
while (objectSqlDataReader.Read())
{
Address address = objectSqlDataReader.Address;
addressList.Add(address);
}
}
}
}
}
return addressList;
}
public static List<Person> GetByUserId(Guid userId)
{
List<Person> personList = new List<Person>();
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (GetPersonByUserIdCommand objectCommand = new GetPersonByUserIdCommand(objectConnection))
{
objectCommand.UserId = userId;
objectConnection.Open();
using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
{
if (!sqlDataReader.HasRows)
{
return personList;
}
using (PersonSqlDataReader objectSqlDataReader = new PersonSqlDataReader(sqlDataReader))
{
while (objectSqlDataReader.Read())
{
Person person = objectSqlDataReader.Person;
personList.Add(person);
}
}
}
}
}
return personList;
}
public static List<OrderItem> GetByOrderItemId(Guid orderItemId)
{
List<OrderItem> orderItemList = new List<OrderItem>();
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (GetOrderItemByOrderItemIdCommand objectCommand = new GetOrderItemByOrderItemIdCommand(objectConnection))
{
objectCommand.OrderItemId = orderItemId;
objectConnection.Open();
using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
{
if (!sqlDataReader.HasRows)
{
return orderItemList;
}
using (OrderItemSqlDataReader objectSqlDataReader = new OrderItemSqlDataReader(sqlDataReader))
{
while (objectSqlDataReader.Read())
{
OrderItem orderItem = objectSqlDataReader.OrderItem;
orderItemList.Add(orderItem);
}
}
}
}
}
return orderItemList;
}
public static List<Customer> GetCustomerByPersonEmail(string personEmail)
{
List<Customer> customerList = new List<Customer>();
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (GetCustomerByPersonEmailCommand objectCommand = new GetCustomerByPersonEmailCommand(objectConnection))
{
objectCommand.PersonEmail = personEmail;
objectConnection.Open();
using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
{
if (!sqlDataReader.HasRows)
{
return customerList;
}
using (CustomerSqlDataReader objectSqlDataReader = new CustomerSqlDataReader(sqlDataReader))
{
while (objectSqlDataReader.Read())
{
Customer customer = objectSqlDataReader.Customer;
customerList.Add(customer);
}
}
}
}
}
return customerList;
}
public static Person GetByPersonId(Guid personId)
{
Person person = new Person();
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (GetPersonByPersonIdCommand objectCommand = new GetPersonByPersonIdCommand(objectConnection))
{
objectCommand.PersonId = personId;
objectConnection.Open();
using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
{
if (!sqlDataReader.HasRows)
{
return person;
}
using (PersonSqlDataReader objectSqlDataReader = new PersonSqlDataReader(sqlDataReader))
{
while (objectSqlDataReader.Read())
{
person = objectSqlDataReader.Person;
}
}
}
}
}
return person;
}
public static List<Order> GetByInventoryItemId(Guid inventoryItemId)
{
List<Order> orderList = new List<Order>();
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (GetOrderByInventoryItemId objectCommand = new GetOrderByInventoryItemId(objectConnection))
{
objectCommand.InventoryItemId = inventoryItemId;
objectConnection.Open();
using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
{
if (!sqlDataReader.HasRows)
{
return orderList;
}
using (OrderSqlDataReader objectSqlDataReader = new OrderSqlDataReader(sqlDataReader))
{
while (objectSqlDataReader.Read())
{
Order order = objectSqlDataReader.Order;
orderList.Add(order);
}
}
}
}
}
return orderList;
}
public static List<InventoryItem> GetByCatalogItemId(Guid catalogItemId)
{
List<InventoryItem> inventoryItemList = new List<InventoryItem>();
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (GetInventoryItemByCatalogItemIdCommand objectCommand = new GetInventoryItemByCatalogItemIdCommand(objectConnection))
{
objectCommand.CatalogItemId = catalogItemId;
objectConnection.Open();
using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
{
if (!sqlDataReader.HasRows)
{
return inventoryItemList;
}
using (InventoryItemSqlDataReader objectSqlDataReader = new InventoryItemSqlDataReader(sqlDataReader))
{
while (objectSqlDataReader.Read())
{
InventoryItem inventoryItem = objectSqlDataReader.InventoryItem;
inventoryItemList.Add(inventoryItem);
}
}
}
}
}
return inventoryItemList;
}
public static CatalogItem GetByItemName(string itemName)
{
CatalogItem catalogItem = new CatalogItem();
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (GetCatalogItemByItemNameCommand objectCommand = new GetCatalogItemByItemNameCommand(objectConnection))
{
objectCommand.ItemName = itemName;
objectConnection.Open();
using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
{
if (!sqlDataReader.HasRows)
{
return catalogItem;
}
using (CatalogItemSqlDataReader objectSqlDataReader = new CatalogItemSqlDataReader(sqlDataReader))
{
while (objectSqlDataReader.Read())
{
catalogItem = objectSqlDataReader.CatalogItem;
}
}
}
}
}
return catalogItem;
}
public static List<Notification> GetByJobRoleAndIsRead(string permissionEnum, bool isRead)
{
List<Notification> notificationList = new List<Notification>();
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (GetNotificationByJobRoleAndIsReadCommand objectCommand = new GetNotificationByJobRoleAndIsReadCommand(objectConnection))
{
objectCommand.PermissionEnum = permissionEnum;
objectCommand.IsRead = isRead;
objectConnection.Open();
using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
{
if (!sqlDataReader.HasRows)
{
return notificationList;
}
using (NotificationSqlDataReader objectSqlDataReader = new NotificationSqlDataReader(sqlDataReader))
{
while (objectSqlDataReader.Read())
{
Notification notification = objectSqlDataReader.Notification;
notificationList.Add(notification);
}
}
}
}
}
return notificationList;
}
public static List<UserAccess> GetAll()
{
List<UserAccess> userAccessList = new List<UserAccess>();
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (GetUserAccessCommand objectCommand = new GetUserAccessCommand(objectConnection))
{
objectConnection.Open();
using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
{
if (!sqlDataReader.HasRows)
{
return userAccessList;
}
using (UserAccessSqlDataReader objectSqlDataReader = new UserAccessSqlDataReader(sqlDataReader))
{
while (objectSqlDataReader.Read())
{
UserAccess userAccess = objectSqlDataReader.UserAccess;
userAccessList.Add(userAccess);
}
}
}
}
}
return userAccessList;
}
public static int Delete(InventoryItem inventoryItem)
{
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (DeleteInventoryItemByInventoryItemIdCommand objectCommand = new DeleteInventoryItemByInventoryItemIdCommand(objectConnection))
{
objectCommand.InventoryItemId = inventoryItem.InventoryItemId;
objectConnection.Open();
objectCommand.ExecuteNonQuery();
return objectCommand.ReturnValue;
}
}
}
public static int DeleteNotification(Guid notificationId)
{
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (DeleteNotificationByNotificationIdCommand objectCommand = new DeleteNotificationByNotificationIdCommand(objectConnection))
{
objectCommand.NotificationId = notificationId;
objectConnection.Open();
objectCommand.ExecuteNonQuery();
return objectCommand.ReturnValue;
}
}
}
public static int Delete(UserAccess user)
{
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (DeleteUserAccessByUsernameCommand objectCommand = new DeleteUserAccessByUsernameCommand(objectConnection))
{
objectCommand.Username = user.UserName;
objectConnection.Open();
objectCommand.ExecuteNonQuery();
return objectCommand.ReturnValue;
}
}
}
public static int UpdateByAddressId(Address address)
{
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (UpdateAddressByAddressIdCommand objectCommand = new UpdateAddressByAddressIdCommand(objectConnection))
{
objectCommand.AddressId = address.AddressId;
objectCommand.PersonId = address.PersonId;
objectCommand.StreetNumber = address.StreetNumber;
objectCommand.StreetName = address.StreetName;
objectCommand.AddressCity = address.AddressCity;
objectCommand.AddressState = address.AddressState;
objectCommand.AddressZip = address.AddressZip;
objectCommand.AddressTypeId = address.AddressTypeId;
objectConnection.Open();
objectCommand.ExecuteNonQuery();
return objectCommand.ReturnValue;
}
}
}
public static int InsertAddress(Guid addressId, Guid personId, int streetNumber, string streetName, string addressCity,
string addressState, string addressZip, int addressTypeId)
{
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (InsertAddressCommand objectCommand = new InsertAddressCommand(objectConnection))
{
objectCommand.AddressId = addressId;
objectCommand.PersonId = personId;
objectCommand.StreetNumber = streetNumber;
objectCommand.StreetName = streetName;
objectCommand.AddressCity = addressCity;
objectCommand.AddressState = addressState;
objectCommand.AddressZip = addressZip;
objectCommand.AddressTypeId = addressTypeId;
objectConnection.Open();
objectCommand.ExecuteNonQuery();
return objectCommand.ReturnValue;
}
}
}
public static List<Notification> GetByNotificationId(Guid notificationId)
{
List<Notification> notificationList = new List<Notification>();
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (GetNotificationByNotificationIdCommand objectCommand = new GetNotificationByNotificationIdCommand(objectConnection))
{
objectCommand.NotificationId = notificationId;
objectConnection.Open();
using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
{
if (!sqlDataReader.HasRows)
{
return notificationList;
}
using (NotificationSqlDataReader objectSqlDataReader = new NotificationSqlDataReader(sqlDataReader))
{
while (objectSqlDataReader.Read())
{
Notification notification = objectSqlDataReader.Notification;
notificationList.Add(notification);
}
}
}
}
}
return notificationList;
}
public static int Insert(Guid? personId, string firstName, string lastName, string phone, string email, int personTypeId)
{
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (InsertPersonCommand objectCommand = new InsertPersonCommand(objectConnection))
{
objectCommand.PersonId = personId ?? new Guid();
objectCommand.PersonFirstName = firstName;
objectCommand.PersonLastName = lastName;
objectCommand.PersonPhone = phone;
objectCommand.PersonEmail = email;
objectCommand.PersonTypeId = personTypeId;
objectConnection.Open();
objectCommand.ExecuteNonQuery();
return objectCommand.ReturnValue;
}
}
}
public static Customer GetCustomerByPersonId(Guid personId)
{
Customer customer = new Customer();
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (GetCustomerByPersonIdCommand objectCommand = new GetCustomerByPersonIdCommand(objectConnection))
{
objectCommand.PersonId = personId;
objectConnection.Open();
using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
{
if (!sqlDataReader.HasRows)
{
return customer;
}
using (CustomerSqlDataReader objectSqlDataReader = new CustomerSqlDataReader(sqlDataReader))
{
while (objectSqlDataReader.Read())
{
customer = objectSqlDataReader.Customer;
}
}
}
}
}
return customer;
}
public static int UpdateByInventoryItemId(InventoryItem inventoryItem)
{
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (UpdateInventoryItemByInventoryItemIdCommand objectCommand = new UpdateInventoryItemByInventoryItemIdCommand(objectConnection))
{
objectCommand.InventoryItemId = inventoryItem.InventoryItemId;
objectCommand.OrderId = inventoryItem.OrderId;
objectCommand.CatalogItemId = inventoryItem.CatalogItemId;
objectCommand.InventoryItemStatusId = inventoryItem.InventoryItemStatusId;
objectConnection.Open();
objectCommand.ExecuteNonQuery();
return objectCommand.ReturnValue;
}
}
}
public static int Insert(Guid? inventoryItemId, Guid catalogItemId, Guid? orderId, int inventoryItemStatusId)
{
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (InsertInventoryItemCommand objectCommand = new InsertInventoryItemCommand(objectConnection))
{
objectCommand.InventoryItemId = inventoryItemId ?? new Guid();
objectCommand.CatalogItemId = catalogItemId;
objectCommand.OrderId = orderId;
objectCommand.InventoryItemStatusId = inventoryItemStatusId;
objectConnection.Open();
objectCommand.ExecuteNonQuery();
return objectCommand.ReturnValue;
}
}
}
public static int Insert(InventoryItem inventoryItem)
{
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (InsertInventoryItemCommand objectCommand = new InsertInventoryItemCommand(objectConnection))
{
objectCommand.InventoryItemId = (inventoryItem.InventoryItemId != Guid.Empty) ? inventoryItem.InventoryItemId : new Guid();
objectCommand.CatalogItemId = inventoryItem.CatalogItemId;
objectCommand.OrderId = inventoryItem.OrderId;
objectCommand.InventoryItemStatusId = inventoryItem.InventoryItemStatusId;
objectConnection.Open();
objectCommand.ExecuteNonQuery();
return objectCommand.ReturnValue;
}
}
}
public static List<CatalogItem> GetByManufacturer(string manufacturer)
{
List<CatalogItem> catalogItemList = new List<CatalogItem>();
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (GetCatalogItemByManufacturerCommand objectCommand = new GetCatalogItemByManufacturerCommand(objectConnection))
{
objectCommand.Manufacturer = manufacturer;
objectConnection.Open();
using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
{
if (!sqlDataReader.HasRows)
{
return catalogItemList;
}
using (CatalogItemSqlDataReader objectSqlDataReader = new CatalogItemSqlDataReader(sqlDataReader))
{
while (objectSqlDataReader.Read())
{
catalogItemList.Add(objectSqlDataReader.CatalogItem);
}
}
}
}
}
return catalogItemList;
}
public static List<InventoryItem> GetByManufacturer(string manufacturer, int inventoryItemStatusId)
{
List<InventoryItem> inventoryItemList = new List<InventoryItem>();
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (GetInventoryItemByManufacturerCommand objectCommand = new GetInventoryItemByManufacturerCommand(objectConnection))
{
objectCommand.Manufacturer = manufacturer;
objectCommand.InventoryItemStatusId = inventoryItemStatusId;
objectConnection.Open();
using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
{
if (!sqlDataReader.HasRows)
{
return inventoryItemList;
}
using (InventoryItemSqlDataReader objectSqlDataReader = new InventoryItemSqlDataReader(sqlDataReader))
{
while (objectSqlDataReader.Read())
{
InventoryItem inventoryItem = objectSqlDataReader.InventoryItem;
inventoryItemList.Add(inventoryItem);
}
}
}
}
}
return inventoryItemList;
}
//Special code for singe record return only. Do not copy and paste for typical queries.
public static int GetNumberInStock(Guid catalogItemId)
{
int numberInStock = 0;
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (GetCatalogItemStockCountCommand objectCommand = new GetCatalogItemStockCountCommand(objectConnection))
{
objectCommand.CatalogItemId = catalogItemId;
objectConnection.Open();
using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
{
if (!sqlDataReader.HasRows)
{
return numberInStock;
}
using (CatalogItemStockCountSqlDataReader objectSqlDataReader = new CatalogItemStockCountSqlDataReader(sqlDataReader))
{
while (objectSqlDataReader.Read())
{
numberInStock = objectSqlDataReader.NumberInStock;
}
}
}
}
}
return numberInStock;
}
public static int InsertCustomer(Guid customerId, Guid personId)
{
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (InsertCustomerCommand objectCommand = new InsertCustomerCommand(objectConnection))
{
objectCommand.CustomerId = customerId;
objectCommand.PersonId = personId;
objectConnection.Open();
objectCommand.ExecuteNonQuery();
return objectCommand.ReturnValue;
}
}
}
public static int Insert(Person person)
{
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (InsertPersonCommand objectCommand = new InsertPersonCommand(objectConnection))
{
objectCommand.PersonId = (person.PersonId != Guid.Empty) ? person.PersonId : new Guid();
objectCommand.PersonFirstName = person.PersonFirstName;
objectCommand.PersonLastName = person.PersonLastName;
objectCommand.PersonPhone = person.PersonPhone;
objectCommand.PersonEmail = person.PersonEmail;
objectCommand.PersonTypeId = person.PersonTypeId;
objectConnection.Open();
objectCommand.ExecuteNonQuery();
return objectCommand.ReturnValue;
}
}
}
public static int UpdateByOrderId(Order order)
{
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (UpdateOrderByOrderIdCommand objectCommand = new UpdateOrderByOrderIdCommand(objectConnection))
{
objectCommand.PersonId = order.PersonId;
objectCommand.OrderId = order.OrderId;
objectCommand.OrderEntryDate = order.OrderEntryDate;
objectCommand.OrderFulfillDate = order.OrderFulfillDate;
objectCommand.OrderStatusId = order.OrderStatusId;
objectConnection.Open();
objectCommand.ExecuteNonQuery();
return objectCommand.ReturnValue;
}
}
}
public static List<Order> GetOrderByLastName(string lastName)
{
List<Order> orderList = new List<Order>();
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (GetOrderByLastName objectCommand = new GetOrderByLastName(objectConnection))
{
objectCommand.LastName = lastName;
objectConnection.Open();
using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
{
if (!sqlDataReader.HasRows)
{
return orderList;
}
using (OrderSqlDataReader objectSqlDataReader = new OrderSqlDataReader(sqlDataReader))
{
while (objectSqlDataReader.Read())
{
Order order = objectSqlDataReader.Order;
orderList.Add(order);
}
}
}
}
}
return orderList;
}
public static int UpdateByPersonId(Guid personId, string firstName, string lastName, string phone, string email, int personTypeId)
{
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (UpdatePersonByPersonIdCommand objectCommand = new UpdatePersonByPersonIdCommand(objectConnection))
{
objectCommand.PersonId = personId;
objectCommand.PersonFirstName = firstName;
objectCommand.PersonLastName = lastName;
objectCommand.PersonPhone = phone;
objectCommand.PersonEmail = email;
objectCommand.PersonTypeId = personTypeId;
objectConnection.Open();
objectCommand.ExecuteNonQuery();
return objectCommand.ReturnValue;
}
}
}
public static int UpdateByPersonId(Person person)
{
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (UpdatePersonByPersonIdCommand objectCommand = new UpdatePersonByPersonIdCommand(objectConnection))
{
objectCommand.PersonId = person.PersonId;
objectCommand.PersonFirstName = person.PersonFirstName;
objectCommand.PersonLastName = person.PersonLastName;
objectCommand.PersonPhone = person.PersonPhone;
objectCommand.PersonEmail = person.PersonEmail;
objectCommand.PersonTypeId = person.PersonTypeId;
objectConnection.Open();
objectCommand.ExecuteNonQuery();
return objectCommand.ReturnValue;
}
}
}
