public IEnumerable <PurPurchaseOrder> GetPurchaseOrderByAll(PurPurchaseOrder purchaseOrder) { var purchaseOrderDetails = new List <PurPurchaseOrder>(); try { if (purchaseOrder.VendorKey != 0 && !string.IsNullOrEmpty(purchaseOrder.VendorName)) { purchaseOrderDetails = (from p in _dbContext.PurchaseOrder where (p.VendorName.StartsWith(purchaseOrder.VendorName)) && (Convert.ToString(p.VendorKey).StartsWith(Convert.ToString(purchaseOrder.VendorKey))) join c in _dbContext.PurPurchaseOrderDetail on p.PurchaseOrderKey equals c.PurchaseOrderKey into purchseDetails select new PurPurchaseOrder { PurchaseOrderKey = p.PurchaseOrderKey, VendorKey = p.VendorKey, VendorName = p.VendorName, ReferenceNumber = p.ReferenceNumber, DeliveryDate = p.DeliveryDate, Status = p.Status, IsAuthorized = p.IsAuthorized, PurPurchaseOrderDetail = purchseDetails.ToList() }).ToList(); } } catch (Exception exp) { throw exp; } return(purchaseOrderDetails); }
public IActionResult UpdatePurchaseOrderDetails(long purchaseOrderKey, [FromBody] PurPurchaseOrder purchaseOrder) { if (ModelState.IsValid) { var result = _repository.UpdatePurchaseOrderDetails(purchaseOrderKey, purchaseOrder); return(result); } else { return(new HttpStatusCodeResult((int)HttpStatusCode.BadRequest)); } }
public string CreatePurchaseOrderDetails(PurPurchaseOrder _objPurchaseOrder) { try { _dbContext.PurchaseOrder.Add(_objPurchaseOrder); _dbContext.SaveChanges(); return(HttpStatusCode.Created.ToString()); } catch (Exception exp) { throw exp; } }
public IActionResult CreatePurchaseOrderDetails(PurPurchaseOrder _objPurchaseOrder) { try { _dbContext.PurchaseOrder.Add(_objPurchaseOrder); _dbContext.SaveChanges(); return(new HttpStatusCodeResult((int)HttpStatusCode.Created)); } catch (Exception exp) { throw exp; } }
public string UpdatePurchaseOrderDetails(long purchaseOrderKey, PurPurchaseOrder _objPurchaseOrder) { try { var purchaseOrder = from p in _dbContext.PurchaseOrder where p.PurchaseOrderKey == purchaseOrderKey select p; if (purchaseOrder != null) { foreach (var ord in purchaseOrder) { ord.VendorKey = _objPurchaseOrder.VendorKey; ord.VendorName = _objPurchaseOrder.VendorName; ord.ReferenceNumber = _objPurchaseOrder.ReferenceNumber; ord.DeliveryDate = _objPurchaseOrder.DeliveryDate; ord.Status = _objPurchaseOrder.Status; ord.IsAuthorized = _objPurchaseOrder.IsAuthorized; } if (_dbContext.SaveChanges() > 0) { var orderDetails = (from c in _dbContext.PurPurchaseOrderDetail where c.PurchaseOrderKey == purchaseOrderKey select c).ToList(); if (orderDetails != null) { foreach (var ord in orderDetails) { _dbContext.PurPurchaseOrderDetail.Remove(ord); } if (_dbContext.SaveChanges() > 0) { foreach (var purchasedetails in _objPurchaseOrder.PurPurchaseOrderDetail) { _dbContext.PurPurchaseOrderDetail.Add(purchasedetails); } _dbContext.SaveChanges(); } } } } return(HttpStatusCode.OK.ToString()); } catch (Exception exp) { throw exp; } }
public IEnumerable <PurPurchaseOrder> GetPurchaseOrderDetailsByAll(string searchOperator, [FromBody] PurPurchaseOrder purchaseOrder) { var purchaseOrderDetails = _repository.GetPurchaseOrderByAll(purchaseOrder, searchOperator); return(purchaseOrderDetails.ToList()); }
public string UpdatePurchaseOrderDetails(long purchaseOrderKey, PurPurchaseOrder _objPurchaseOrder) { throw new NotImplementedException(); }
public IEnumerable <PurPurchaseOrder> GetPurchaseOrderByAll(PurPurchaseOrder _objpur) { throw new NotImplementedException(); }
public string CreatePurchaseOrderDetails(PurPurchaseOrder _objPurchaseOrder) { throw new NotImplementedException(); }