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 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 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 <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 <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 UserAccess GetByUserName(string userName) { UserAccess userAccess = new UserAccess(); using (ObjectConnection objectConnection = new ObjectConnection()) { using (GetUserAccessByUserNameCommand objectCommand = new GetUserAccessByUserNameCommand(objectConnection)) { objectCommand.UserName = userName; objectConnection.Open(); using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader()) { if (!sqlDataReader.HasRows) { return(null); } using (UserAccessSqlDataReader objectSqlDataReader = new UserAccessSqlDataReader(sqlDataReader)) { while (objectSqlDataReader.Read()) { userAccess = objectSqlDataReader.UserAccess; } } } } } return(userAccess); }
public static List <OrderItem> GetByOrderId(Guid orderId) { List <OrderItem> orderItemList = new List <OrderItem>(); using (ObjectConnection objectConnection = new ObjectConnection()) { using (GetOrderItemByOrderIdCommand objectCommand = new GetOrderItemByOrderIdCommand(objectConnection)) { objectCommand.OrderId = orderId; 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 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 List <Notification> GetByJobRole(string permissionEnum) { List <Notification> notificationList = new List <Notification>(); using (ObjectConnection objectConnection = new ObjectConnection()) { using (GetNotificationByJobRoleCommand objectCommand = new GetNotificationByJobRoleCommand(objectConnection)) { objectCommand.PermissionEnum = permissionEnum; 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); }
//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 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 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> 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 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 <InventoryItem> GetByInventoryItemIdAndInventoryItemStatusId(Guid inventoryItemId, int inventoryItemStatusId) { List <InventoryItem> inventoryItemList = new List <InventoryItem>(); using (ObjectConnection objectConnection = new ObjectConnection()) { using (GetInventoryItemByInventoryItemIdAndInventoryItemStatusIdCommand objectCommand = new GetInventoryItemByInventoryItemIdAndInventoryItemStatusIdCommand(objectConnection)) { objectCommand.InventoryItemId = inventoryItemId; 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); }
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 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(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 UpdateByUserId(Guid userId, string userName, string userPassword, Guid personId) { using (ObjectConnection objectConnection = new ObjectConnection()) { using (UpdateUserAccessByUserIdCommand objectCommand = new UpdateUserAccessByUserIdCommand(objectConnection)) { objectCommand.UserId = userId; objectCommand.UserName = userName; objectCommand.UserPassword = userPassword; objectCommand.PersonId = personId; 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 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 InsertOrder(Order order) { using (ObjectConnection objectConnection = new ObjectConnection()) { using (InsertOrderCommand objectCommand = new InsertOrderCommand(objectConnection)) { objectCommand.OrderId = order.OrderId; objectCommand.OrderEntryDate = order.OrderEntryDate; objectCommand.OrderFulfillDate = order.OrderFulfillDate; objectCommand.OrderStatusId = order.OrderStatusId; objectCommand.PersonId = order.PersonId; objectConnection.Open(); objectCommand.ExecuteNonQuery(); return(objectCommand.ReturnValue); } } }
public static int Insert(UserAccess userAccess) { using (ObjectConnection objectConnection = new ObjectConnection()) { using (InsertUserAccessCommand objectCommand = new InsertUserAccessCommand(objectConnection)) { objectCommand.UserId = userAccess.UserId; objectCommand.UserName = userAccess.UserName; objectCommand.UserPassword = userAccess.UserPassword; objectCommand.PermissionToken = userAccess.PermissionToken; objectCommand.PersonId = userAccess.PersonId; objectConnection.Open(); objectCommand.ExecuteNonQuery(); return(objectCommand.ReturnValue); } } }
public static int Insert(Guid?notificationId, string notificationMessage, Guid orderId, int notificationTypeId, bool isRead) { using (ObjectConnection objectConnection = new ObjectConnection()) { using (InsertNotificationCommand objectCommand = new InsertNotificationCommand(objectConnection)) { objectCommand.NotificationId = notificationId ?? Guid.NewGuid(); objectCommand.NotificationMessage = notificationMessage; objectCommand.OrderId = orderId; objectCommand.NotificationTypeId = notificationTypeId; objectCommand.IsRead = isRead; objectConnection.Open(); objectCommand.ExecuteNonQuery(); return(objectCommand.ReturnValue); } } }
public static int UpdateByNotificationId(Notification notification) { using (ObjectConnection objectConnection = new ObjectConnection()) { using (UpdateNotificationByNotificationIdCommand objectCommand = new UpdateNotificationByNotificationIdCommand(objectConnection)) { objectCommand.NotificationId = notification.NotificationId; objectCommand.OrderId = notification.OrderId; objectCommand.NotificationMessage = notification.NotificationMessage; objectCommand.NotificationTypeId = notification.NotificationTypeId; objectCommand.IsRead = notification.IsRead; 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 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); } } }