/// <summary> /// product Inquiry /// </summary> /// <param name="productCode"></param> /// <param name="companyName"></param> /// <param name="paging"></param> /// <param name="transaction"></param> /// <returns></returns> public List<Product> ProductInquiry(string productCode, string description, DataGridPagingInformation paging, out TransactionalInformation transaction) { transaction = new TransactionalInformation(); List<Product> products = new List<Product>(); try { productsDataService.CreateSession(); products = productsDataService.ProductInquiry(productCode, description, paging, out transaction); } catch (Exception ex) { transaction.ReturnMessage = new List<string>(); string errorMessage = ex.Message; transaction.ReturnStatus = false; transaction.ReturnMessage.Add(errorMessage); } finally { productsDataService.CloseSession(); } return products; }
/// <summary> /// customer Inquiry /// </summary> /// <param name="customerCode"></param> /// <param name="companyName"></param> /// <param name="paging"></param> /// <param name="transaction"></param> /// <returns></returns> public List<Customer> CustomerInquiry(string customerCode, string companyName, DataGridPagingInformation paging, out TransactionalInformation transaction) { transaction = new TransactionalInformation(); List<Customer> customers = new List<Customer>(); try { customersDataService.CreateSession(); customers = customersDataService.CustomerInquiry(customerCode, companyName, paging, out transaction); } catch (Exception ex) { transaction.ReturnMessage = new List<string>(); string errorMessage = ex.Message; transaction.ReturnStatus = false; transaction.ReturnMessage.Add(errorMessage); } finally { customersDataService.CloseSession(); } return customers; }
/// <summary> /// Product Inquiry /// </summary> /// <param name="productCode"></param> /// <param name="description"></param> /// <param name="paging"></param> /// <param name="transaction"></param> /// <returns></returns> public List<Product> ProductInquiry(string productCode, string description, DataGridPagingInformation paging, out TransactionalInformation transaction) { transaction = new TransactionalInformation(); string sortExpression = paging.SortExpression; if (paging.SortDirection != string.Empty) sortExpression = sortExpression + " " + paging.SortDirection; List<Product> productInquiry = new List<Product>(); int numberOfRows = 0; var productQuery = dbConnection.Products.AsQueryable(); if (productCode != null && productCode.Trim().Length > 0) { productQuery = productQuery.Where(c => c.ProductCode.StartsWith(productCode)); } if (description != null && description.Trim().Length > 0) { productQuery = productQuery.Where(c => c.Description.StartsWith(description)); } var products = from p in productQuery select new { p.ProductID, p.ProductCode, p.Description, p.UnitPrice, p.UnitOfMeasure }; numberOfRows = products.Count(); products = products.OrderBy(sortExpression); var productList = products.Skip((paging.CurrentPageNumber - 1) * paging.PageSize).Take(paging.PageSize); paging.TotalRows = numberOfRows; paging.TotalPages = AngularJSUtilities.Utilities.CalculateTotalPages(numberOfRows, paging.PageSize); foreach (var product in productList) { Product productData = new Product(); productData.ProductID = product.ProductID; productData.ProductCode = product.ProductCode; productData.Description = product.Description; productData.UnitOfMeasure = product.UnitOfMeasure; productData.UnitPrice = product.UnitPrice; productInquiry.Add(productData); } transaction.TotalPages = paging.TotalPages; transaction.TotalRows = paging.TotalRows; transaction.ReturnStatus = true; transaction.ReturnMessage.Add(numberOfRows.ToString() + " product records found."); return productInquiry; }
public HttpResponseMessage CustomerInquiry([FromUri] CustomerInquiryDTO customerInquiryDTO) { if (customerInquiryDTO.CustomerCode == null) customerInquiryDTO.CustomerCode = string.Empty; if (customerInquiryDTO.CompanyName == null) customerInquiryDTO.CompanyName = string.Empty; if (customerInquiryDTO.SortDirection == null) customerInquiryDTO.SortDirection = string.Empty; if (customerInquiryDTO.SortExpression == null) customerInquiryDTO.SortExpression = string.Empty; CustomersApiModel customersWebApiModel = new CustomersApiModel(); TransactionalInformation transaction = new TransactionalInformation(); CustomersBusinessService customersBusinessService; customersWebApiModel = new CustomersApiModel(); DataGridPagingInformation paging = new DataGridPagingInformation(); paging.CurrentPageNumber = customerInquiryDTO.CurrentPageNumber; paging.PageSize = customerInquiryDTO.PageSize; paging.SortExpression = customerInquiryDTO.SortExpression; paging.SortDirection = customerInquiryDTO.SortDirection; if (paging.SortDirection == "") paging.SortDirection = "ASC"; if (paging.SortExpression == "") paging.SortExpression = "CompanyName"; customersBusinessService = new CustomersBusinessService(customersDataService); List<Customer> customers = customersBusinessService.CustomerInquiry(customerInquiryDTO.CustomerCode, customerInquiryDTO.CompanyName, paging, out transaction); customersWebApiModel.Customers = customers; customersWebApiModel.IsAuthenicated = true; customersWebApiModel.ReturnStatus = transaction.ReturnStatus; customersWebApiModel.ReturnMessage = transaction.ReturnMessage; customersWebApiModel.TotalPages = transaction.TotalPages; customersWebApiModel.TotalRows = transaction.TotalRows; customersWebApiModel.PageSize = paging.PageSize; customersWebApiModel.IsAuthenicated = true; if (transaction.ReturnStatus == true) { var response = Request.CreateResponse<CustomersApiModel>(HttpStatusCode.OK, customersWebApiModel); return response; } var badResponse = Request.CreateResponse<CustomersApiModel>(HttpStatusCode.BadRequest, customersWebApiModel); return badResponse; }
/// <summary> /// Order Inquiry /// </summary> /// <param name="customerCode"></param> /// <param name="companyName"></param> /// <param name="paging"></param> /// <param name="transaction"></param> /// <returns></returns> public List<OrderInquiry> OrderInquiry(string customerCode, string companyName, DataGridPagingInformation paging, out TransactionalInformation transaction) { transaction = new TransactionalInformation(); string sortExpression = paging.SortExpression; if (paging.SortDirection != string.Empty) sortExpression = sortExpression + " " + paging.SortDirection; List<OrderInquiry> orderInquiryList = new List<OrderInquiry>(); int numberOfRows = 0; var customerQuery = dbConnection.Customers.AsQueryable(); if (customerCode != null && customerCode.Trim().Length > 0) { customerQuery = customerQuery.Where(c => c.CustomerCode.StartsWith(customerCode)); } if (companyName != null && companyName.Trim().Length > 0) { customerQuery = customerQuery.Where(c => c.CompanyName.StartsWith(companyName)); } var orders = from customer in customerQuery join order in dbConnection.Orders on customer.CustomerID equals order.CustomerID select new { customer, order, order.OrderDate, order.OrderTotal, customer.CustomerCode, customer.CompanyName }; numberOfRows = orders.Count(); orders = orders.OrderBy(sortExpression); var listOfOrders = orders.Skip((paging.CurrentPageNumber - 1) * paging.PageSize).Take(paging.PageSize); paging.TotalRows = numberOfRows; paging.TotalPages = AngularJSUtilities.Utilities.CalculateTotalPages(numberOfRows, paging.PageSize); foreach (var order in listOfOrders) { OrderInquiry o = new OrderInquiry(); o.Customer = order.customer; o.Order = order.order; orderInquiryList.Add(o); } transaction.TotalPages = paging.TotalPages; transaction.TotalRows = paging.TotalRows; transaction.ReturnStatus = true; transaction.ReturnMessage.Add(numberOfRows.ToString() + " orders found."); return orderInquiryList; }
public HttpResponseMessage OrderInquiry([FromBody] OrderInquiryDTO orderInquiryDTO) { if (orderInquiryDTO.CustomerCode == null) orderInquiryDTO.CustomerCode = string.Empty; if (orderInquiryDTO.CompanyName == null) orderInquiryDTO.CompanyName = string.Empty; if (orderInquiryDTO.SortDirection == null) orderInquiryDTO.SortDirection = string.Empty; if (orderInquiryDTO.SortExpression == null) orderInquiryDTO.SortExpression = string.Empty; OrdersApiModel ordersWebApiModel = new OrdersApiModel(); TransactionalInformation transaction = new TransactionalInformation(); OrdersBusinessService ordersBusinessService; ordersWebApiModel.IsAuthenicated = true; DataGridPagingInformation paging = new DataGridPagingInformation(); paging.CurrentPageNumber = orderInquiryDTO.CurrentPageNumber; paging.PageSize = orderInquiryDTO.PageSize; paging.SortExpression = orderInquiryDTO.SortExpression; paging.SortDirection = orderInquiryDTO.SortDirection; if (paging.SortDirection == "") paging.SortDirection = "DESC"; if (paging.SortExpression == "") paging.SortExpression = "OrderDate"; ordersBusinessService = new OrdersBusinessService(ordersDataService); List<OrderInquiry> orders = ordersBusinessService.OrderInquiry(orderInquiryDTO.CustomerCode, orderInquiryDTO.CompanyName, paging, out transaction); ordersWebApiModel.Orders = orders; ordersWebApiModel.ReturnStatus = transaction.ReturnStatus; ordersWebApiModel.ReturnMessage = transaction.ReturnMessage; ordersWebApiModel.TotalPages = transaction.TotalPages; ordersWebApiModel.TotalRows = transaction.TotalRows; ordersWebApiModel.PageSize = paging.PageSize; if (transaction.ReturnStatus == true) { var response = Request.CreateResponse<OrdersApiModel>(HttpStatusCode.OK, ordersWebApiModel); return response; } var badResponse = Request.CreateResponse<OrdersApiModel>(HttpStatusCode.BadRequest, ordersWebApiModel); return badResponse; }
/// <summary> /// Customer Inquiry /// </summary> /// <param name="customerCode"></param> /// <param name="companyName"></param> /// <param name="paging"></param> /// <param name="transaction"></param> /// <returns></returns> public List<Customer> CustomerInquiry(string customerCode, string companyName, DataGridPagingInformation paging, out TransactionalInformation transaction) { transaction = new TransactionalInformation(); string sortExpression = paging.SortExpression; if (paging.SortDirection != string.Empty) sortExpression = sortExpression + " " + paging.SortDirection; List<Customer> customerInquiry = new List<Customer>(); int numberOfRows = 0; var customerQuery = dbConnection.Customers.AsQueryable(); if (customerCode != null && customerCode.Trim().Length > 0) { customerQuery = customerQuery.Where(c => c.CustomerCode.StartsWith(customerCode)); } if (companyName != null && companyName.Trim().Length > 0) { customerQuery = customerQuery.Where(c => c.CompanyName.StartsWith(companyName)); } var customers = from c in customerQuery select new { c.CustomerID, c.CustomerCode, c.CompanyName, c.WebSiteUrl, c.City, c.Country, c.Address, c.Region, c.PostalCode }; numberOfRows = customers.Count(); customers = customers.OrderBy(sortExpression); var customerList = customers.Skip((paging.CurrentPageNumber - 1) * paging.PageSize).Take(paging.PageSize); paging.TotalRows = numberOfRows; paging.TotalPages = AngularJSUtilities.Utilities.CalculateTotalPages(numberOfRows, paging.PageSize); foreach (var customer in customerList) { Customer customerData = new Customer(); customerData.CustomerID = customer.CustomerID; customerData.CustomerCode = customer.CustomerCode; customerData.CompanyName = customer.CompanyName; customerData.City = customer.City; customerData.Address = customer.Address; customerData.WebSiteUrl = customer.WebSiteUrl; if (customer.Region == "NULL") customerData.Region = "NA"; else customerData.Region = customer.Region; customerData.PostalCode = customer.PostalCode; customerInquiry.Add(customerData); } transaction.TotalPages = paging.TotalPages; transaction.TotalRows = paging.TotalRows; transaction.ReturnStatus = true; transaction.ReturnMessage.Add(numberOfRows.ToString() + " customer records found."); return customerInquiry; }
public HttpResponseMessage ProductInquiry([FromUri] ProductInquiryDTO productInquiryDTO) { if (productInquiryDTO.ProductCode == null) productInquiryDTO.ProductCode = string.Empty; if (productInquiryDTO.Description == null) productInquiryDTO.Description = string.Empty; if (productInquiryDTO.SortDirection == null) productInquiryDTO.SortDirection = string.Empty; if (productInquiryDTO.SortExpression == null) productInquiryDTO.SortExpression = string.Empty; ProductsApiModel productsWebApiModel = new ProductsApiModel(); TransactionalInformation transaction = new TransactionalInformation(); ProductsBusinessService productsBusinessService; productsWebApiModel.IsAuthenicated = true; DataGridPagingInformation paging = new DataGridPagingInformation(); paging.CurrentPageNumber = productInquiryDTO.CurrentPageNumber; paging.PageSize = productInquiryDTO.PageSize; paging.SortExpression = productInquiryDTO.SortExpression; paging.SortDirection = productInquiryDTO.SortDirection; if (paging.SortDirection == "") paging.SortDirection = "ASC"; if (paging.SortExpression == "") paging.SortExpression = "Description"; productsBusinessService = new ProductsBusinessService(productsDataService); List<Product> products = productsBusinessService.ProductInquiry(productInquiryDTO.ProductCode, productInquiryDTO.Description, paging, out transaction); productsWebApiModel.Products = products; productsWebApiModel.ReturnStatus = transaction.ReturnStatus; productsWebApiModel.ReturnMessage = transaction.ReturnMessage; productsWebApiModel.TotalPages = transaction.TotalPages; productsWebApiModel.TotalRows = transaction.TotalRows; productsWebApiModel.PageSize = paging.PageSize; if (transaction.ReturnStatus == true) { var response = Request.CreateResponse<ProductsApiModel>(HttpStatusCode.OK, productsWebApiModel); return response; } var badResponse = Request.CreateResponse<ProductsApiModel>(HttpStatusCode.BadRequest, productsWebApiModel); return badResponse; }