/// <summary> /// Adds a new WorkOrder to the database /// </summary> /// <param name="workOrderDTO"></param> /// <returns>The added WorkOrder</returns> public WorkOrderDTO Create(WorkOrderDTO workOrderDTO) { var workOrder = AutoMapper.Mapper.Map <WorkOrder>(workOrderDTO); workOrder.CreatedByUserId = _currentUserId; workOrder.ClientId = (int)_clientUserService.GetUserClientId(workOrder.CreatedByUserId); workOrder.CreatedDate = DateTime.UtcNow; workOrder.Status = Status.Active; _unitOfWork.WorkOrders.Add(workOrder); // Have to call this here to get the new WorkOrderId _unitOfWork.SaveChanges(); // History var workOrderHistory = AutoMapper.Mapper.Map <WorkOrderHistory>(workOrder); workOrderHistory.WorkOrderId = workOrder.Id; workOrderHistory.ModifiedByUserId = _currentUserId; workOrderHistory.ModifiedDate = workOrder.CreatedDate; workOrderHistory.Status = Status.Active; _unitOfWork.WorkOrdersHistory.Add(workOrderHistory); _unitOfWork.SaveChanges(); return(workOrderDTO); }
public ActionResult Edit(WorkOrderDTO workOrderDTO) { if (ModelState.IsValid) { //workOrderDTO.Customer = _customerService.Get(workOrderDTO.CustomerId); //workOrderDTO.AssignedToUser = MyHelper.UserManager.FindById(workOrderDTO.AssignedToUserId); //workOrderDTO.Product = _productService.Get(workOrderDTO.ProductId); //workOrderDTO.Location = _customerLocationService.Get(workOrderDTO.LocationId); var savedWorkOrderDTO = _workOrderService.Update(workOrderDTO.Id, workOrderDTO); if (savedWorkOrderDTO == null) { return(HttpNotFound()); } return(RedirectToAction("Index")); } ViewBag.UserList = _mainService.GetUserDropdownItems(); ViewBag.CustomerList = _mainService.GetCustomerDropdownItems(); ViewBag.LocationList = _mainService.GetLocationDropdownItems(workOrderDTO.CustomerId); ViewBag.ProductList = _mainService.GetProductDropdownItems(); return(View(workOrderDTO)); }
public WorkOrderResponse() { WorkOrder = new WorkOrderDTO(); ImageMap = new List <WorkOrderImageMapDTO>(); WorkOrderList = new List <WorkOrderInventoryMapDTO>(); NotInInventory = new List <NotInInventoryDTO>(); Arrangements = new List <GetArrangementResponse>(); }
public AddWorkOrderRequest() { WorkOrder = new WorkOrderDTO(); ImageMap = new List <WorkOrderImageMapDTO>(); WorkOrderInventoryMap = new List <WorkOrderInventoryMapDTO>(); NotInInventory = new List <NotInInventoryDTO>(); Arrangements = new List <AddArrangementRequest>(); }
private void FormLoad(object sender, EventArgs e) { this.InitGrid(); this.model = dal.Get(guid); this.UIDataBinding(); this.ReflashUI(); this.GetFTPFileList(model.WOCode); }
/// <summary> /// Updates a WorkOrder /// </summary> /// <param name="id"></param> /// <param name="workOrderDTO"></param> /// <returns>The saved WorkOrderDTO</returns> public WorkOrderDTO Update(int id, WorkOrderDTO workOrderDTO) { try { // get the existing workOrder var workOrder = _unitOfWork.WorkOrders.Get(id); if (workOrder == null) { return(null); } // merge the DTO // AutoMapper.Mapper.Map(workOrderDTO, workOrder); workOrder.CustomerId = workOrderDTO.CustomerId; workOrder.LocationId = workOrderDTO.LocationId; workOrder.ProductId = workOrderDTO.ProductId; workOrder.Quantity = workOrderDTO.Quantity; workOrder.Notes = workOrderDTO.Notes; workOrder.DueDate = workOrderDTO.DueDate; workOrder.AssignedToUserId = workOrderDTO.AssignedToUserId; workOrder.CreatedByUserId = _currentUserId; _unitOfWork.WorkOrders.Update(workOrder); _unitOfWork.SaveChanges(); // History var workOrderHistory = AutoMapper.Mapper.Map <WorkOrderHistory>(workOrder); workOrderHistory.WorkOrderId = id; workOrderHistory.ModifiedByUserId = HttpContext.Current.User.Identity.GetUserId(); workOrderHistory.ModifiedDate = DateTime.UtcNow; workOrderHistory.Status = workOrder.Status; _unitOfWork.WorkOrdersHistory.Add(workOrderHistory); _unitOfWork.SaveChanges(); return(workOrderDTO); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } return(null); } }
public int InsertWorkOrder(WorkOrderDTO data) { int workorderId = 0; WorkOrderDTO user = new WorkOrderDTO(); if (_user == null) { _user = new UserService(); } workorderId = _user.InsertWorkOrder(data); return(workorderId); }
private void gridView1_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { if (e.FocusedRowHandle > -1) { this.currentIndex = e.FocusedRowHandle; string guid = gridView1.GetFocusedRowCellValue("guid").ToString(); this.model = dal.Get(guid); this.gridControl3.DataSource = model.WorkOrderRouter; this.gridControl2.DataSource = model.WorkOrderDetail; //this.GetFTPFileList(model.WOCode); } }
public ActionResult Create(WorkOrderDTO workOrderDTO) { if (ModelState.IsValid) { _workOrderService.Create(workOrderDTO); return(RedirectToAction("Index")); } ViewBag.UserList = _mainService.GetUserDropdownItems(); ViewBag.CustomerList = _mainService.GetCustomerDropdownItems(); ViewBag.LocationList = new Dictionary <int, string>(); ViewBag.ProductList = _mainService.GetProductDropdownItems(); return(View(workOrderDTO)); }
private void btnEditDetail_Click(object sender, EventArgs e) { #region 修改子件 if (dal.ExistRef(model.Guid)) { throw new Exception("已经生成流转卡,不能修改!"); } FmWODetails frm = new FmWODetails(model.Guid); if (frm.ShowDialog() == DialogResult.OK) { this.model = dal.Get(model.Guid); gridControl2.DataSource = dal.GetDetail(model.Guid); } #endregion }
public int InsertWorkOrder(WorkOrderDTO data) { int workOrderId = 0; SqlParameter[] sqlParams = new SqlParameter[11]; sqlParams[0] = new SqlParameter("CompletedDate", data.CompletedDate); sqlParams[1] = new SqlParameter("ContractorID", data.ContractorID); sqlParams[2] = new SqlParameter("DeadLineDate", data.DeadLineDate); sqlParams[3] = new SqlParameter("DepartmentID", data.DepartmentID); sqlParams[4] = new SqlParameter("DispatchedDate", data.DispatchedDate); sqlParams[5] = new SqlParameter("DispatchTo", data.DispatchTo); sqlParams[6] = new SqlParameter("PriorityID", data.PriorityID); sqlParams[7] = new SqlParameter("ProblemDescription", data.ProblemDescription); sqlParams[8] = new SqlParameter("ReceivedDate", data.ReceivedDate); sqlParams[9] = new SqlParameter("SiteID", data.SiteID); sqlParams[10] = new SqlParameter("WorkOrderStatus", ActivityStatusEnum.Unscheduled); object objResult = SqlClientRMXProd.ExecuteScalar("udsp_InsertWorkOrder", sqlParams); if ((objResult != null) && (Int32.TryParse(objResult.ToString(), out workOrderId))) { return(workOrderId); } return(workOrderId); }
public bool AddWorkOrder(bool displayAlert = true) { bool result = false; AddWorkOrderRequest addWorkOrderRequest = new AddWorkOrderRequest(); WorkOrderDTO dto = new WorkOrderDTO() { WorkOrderId = currentWorkOrderId, Seller = ((KeyValuePair <long, string>) this.Seller.SelectedItem).Value, Buyer = this.Buyer.Text, CreateDate = DateTime.Now, DeliveryDate = this.DeliveryDate.Date, Comments = this.Comments.Text, IsSiteService = this.DeliveryType.SelectedIndex == 2 ? true : false, IsDelivery = this.DeliveryType.SelectedIndex == 0 ? false : true, DeliveryType = this.DeliveryType.SelectedIndex, Paid = false, IsCancelled = false, CustomerId = customerId, SellerId = ((KeyValuePair <long, string>) this.Seller.SelectedItem).Key, DeliverTo = DeliverTo.Text, DeliveryRecipientId = deliveryRecipientId, OrderType = OrderType.SelectedIndex, DeliveryUserId = this.DeliveryPerson.SelectedItem != null ? ((KeyValuePair <long, string>) this.DeliveryPerson.SelectedItem).Key : 0 }; addWorkOrderRequest.NotInInventory = notInInventory; List <WorkOrderInventoryMapDTO> workOrderInventoryMap = new List <WorkOrderInventoryMapDTO>(); foreach (WorkOrderInventoryItemDTO woii in workOrderInventoryList) { WorkOrderViewModel wovm = null; if (((ObservableCollection <WorkOrderViewModel>)InventoryItemsListView.ItemsSource).Where(a => a.InventoryId == woii.InventoryId).Any()) { wovm = ((ObservableCollection <WorkOrderViewModel>)InventoryItemsListView.ItemsSource).Where(a => a.InventoryId == woii.InventoryId).First(); } workOrderInventoryMap.Add(new WorkOrderInventoryMapDTO() { WorkOrderId = currentWorkOrderId, InventoryId = woii.InventoryId, InventoryName = woii.InventoryName, //Quantity = woii.Quantity, Quantity = wovm != null ? wovm.Quantity : 1, GroupId = woii.GroupId, Size = woii.Size, }); } addWorkOrderRequest.WorkOrder = dto; addWorkOrderRequest.WorkOrderInventoryMap = workOrderInventoryMap.Where(a => a.GroupId == 0).ToList(); foreach (NotInInventoryDTO notIn in notInInventory) { WorkOrderViewModel wovm = null; if (((ObservableCollection <WorkOrderViewModel>)InventoryItemsListView.ItemsSource).Where(a => a.NotInInventoryId == notIn.NotInInventoryId).Any()) { wovm = ((ObservableCollection <WorkOrderViewModel>)InventoryItemsListView.ItemsSource).Where(a => a.NotInInventoryId == notIn.NotInInventoryId).First(); } if (wovm != null) { notIn.NotInInventoryQuantity = wovm.Quantity; } } addWorkOrderRequest.NotInInventory = notInInventory; addWorkOrderRequest.Arrangements = arrangementList; currentWorkOrderId = ((App)App.Current).AddWorkOrder(addWorkOrderRequest); if (currentWorkOrderId > 0) { result = true; //add any images List <EOImgData> imageData = ((App)App.Current).GetImageData(); if (imageData.Count > 0) { foreach (EOImgData img in imageData) { AddWorkOrderImageRequest request = new AddWorkOrderImageRequest() { WorkOrderId = currentWorkOrderId, ImageId = img.ImageId, Image = img.imgData }; ((App)App.Current).AddWorkOrderImage(request); } } Save.IsEnabled = false; Payment.IsEnabled = true; if (displayAlert) { DisplayAlert("Success", "WorkOrder Saved!", "OK"); } } else { if (displayAlert) { DisplayAlert("Error", "There was an error saving this work order.", "Ok"); } } return(result); }
public void AddWorkOrder() { try { AddWorkOrderRequest addWorkOrderRequest = new AddWorkOrderRequest(); WorkOrderDTO dto = new WorkOrderDTO() { Seller = this.SellerTextBox.Text, Buyer = this.BuyerTextBox.Text, CreateDate = DateTime.Now, Comments = this.CommentsTextBox.Text }; foreach (WorkOrderInventoryItemDTO woii in workOrderInventoryList) { workOrderInventoryMap.Add(new WorkOrderInventoryMapDTO() { InventoryId = woii.InventoryId, InventoryName = woii.InventoryName, Quantity = woii.Quantity }); } addWorkOrderRequest.WorkOrder = dto; addWorkOrderRequest.WorkOrderInventoryMap = workOrderInventoryMap; HttpClient client = new HttpClient(); client.BaseAddress = new Uri("http://localhost:9000/"); //client.DefaultRequestHeaders.Add("appkey", "myapp_key"); client.DefaultRequestHeaders.Accept.Add( new MediaTypeWithQualityHeaderValue("application/json")); client.DefaultRequestHeaders.Add("EO-Header", wnd.User + " : " + wnd.Pwd); string jsonData = JsonConvert.SerializeObject(addWorkOrderRequest); var content = new StringContent(jsonData, Encoding.UTF8, "application/json"); HttpResponseMessage httpResponse = client.PostAsync("api/Login/AddWorkOrder", content).Result; if (httpResponse.IsSuccessStatusCode) { Stream streamData = httpResponse.Content.ReadAsStreamAsync().Result; StreamReader strReader = new StreamReader(streamData); string strData = strReader.ReadToEnd(); strReader.Close(); ApiResponse apiResponse = JsonConvert.DeserializeObject <ApiResponse>(strData); if (apiResponse.Messages.Count > 0) { StringBuilder sb = new StringBuilder(); foreach (KeyValuePair <string, List <string> > messages in apiResponse.Messages) { foreach (string msg in messages.Value) { sb.AppendLine(msg); } } MessageBox.Show(sb.ToString()); } else { this.WorkOrderInventoryListView.ItemsSource = null; } } else { MessageBox.Show("Error adding Work Order"); } } catch (Exception ex) { } }
public void AddWorkOrder() { AddWorkOrderRequest addWorkOrderRequest = new AddWorkOrderRequest(); WorkOrderDTO dto = new WorkOrderDTO() { WorkOrderId = currentSiteServiceId, SellerId = ((KeyValuePair <long, string>) this.CreatedBy.SelectedItem).Key, Seller = ((KeyValuePair <long, string>) this.CreatedBy.SelectedItem).Value, Buyer = this.Customer.Text, DeliveredBy = ((KeyValuePair <long, string>)ServicedBy.SelectedItem).Value, CustomerId = customerId, CreateDate = DateTime.Now, Comments = this.Comments.Text, DeliveryUserId = ((KeyValuePair <long, string>) this.ServicedBy.SelectedItem).Key, IsSiteService = true, DeliveryDate = DeliveryDate.Date }; List <WorkOrderInventoryMapDTO> workOrderInventoryMap = new List <WorkOrderInventoryMapDTO>(); foreach (WorkOrderInventoryItemDTO woii in siteServiceInventoryList) { workOrderInventoryMap.Add(new WorkOrderInventoryMapDTO() { WorkOrderId = currentSiteServiceId, InventoryId = woii.InventoryId, InventoryName = woii.InventoryName, Quantity = woii.Quantity }); } List <EOImageSource> imgSource = TabParent.GetImages(); foreach (EOImageSource img in imgSource) { addWorkOrderRequest.ImageMap.Add(new WorkOrderImageMapDTO() { WorkOrderId = currentSiteServiceId, ImageId = img.ImageId, ImageData = img.Image }); } addWorkOrderRequest.WorkOrder = dto; addWorkOrderRequest.WorkOrderInventoryMap = workOrderInventoryMap; long newWorkOrderId = ((App)App.Current).AddWorkOrder(addWorkOrderRequest); if (newWorkOrderId > 0) { //imageData.Clear(); //((App)App.Current).ClearImageData(); //this.siteServiceInventoryList.Clear(); //this.SiteServiceInventoryItemsListView.ItemsSource = null; if (!workOrder.WorkOrder.Paid) { Pay.IsEnabled = true; } } else { //DisplayAlert(?) } }
public WorkOrderRequest() { WorkOrder = new WorkOrderDTO(); InventoryIdList = new List <long>(); }