public async Task <IHttpActionResult> Update(long id, [FromBody] Machinery entity) { var resp = new ResponseData <Machinery>(); try { var query = from a in DataContext.Machinery where a.Id == id select a; var error = ""; var data = query.FirstOrDefault(); if (data == null) { error = $"data {id} not found"; resp.Message = error; } else { Utils.CopyProperties(entity, data, ID_EXCEPTION); DataContext.Entry(data).State = System.Data.Entity.EntityState.Modified; await DataContext.SaveChangesAsync(); resp.Data = data; } } catch (Exception ex) { resp.Message = ex.Message; Logger.LogError("Update Gesture error", ex); } return(Json(resp)); }
public async Task <ActionResult <Machinery> > Post([FromForm] MachineryDto model) { var user = await _accountRepository.GetByIdAsync(model.User); string path = Path.Combine("img/customers", model.CustomerId.ToString(), "machinery"); string pathFull = _baseUrl.GetBaseUrl(path); var data = new Machinery { Brand = model.Brand, CategoryId = model.CategoryId, CustomerId = model.CustomerId, DateOfPurchase = model.DateOfPurchase, Model = model.Modelo, NameMachinery = model.NameMachinery, Observations = model.Observations, Serie = model.Serie, State = model.State, TechnicalSpecifications = model.TechnicalSpecifications, Ubication = model.Ubication, User = user, }; if (model.Img != null) { string nameFile = _imgService.SaveFile(model.Img, pathFull, 1280, 720); if (model.PhotoPath != null) { await _imgService.DeleteFile(pathFull, model.PhotoPath); } data.PhotoPath = nameFile; } await _genericRepository.CreateAsync(data); return(new CreatedAtRouteResult("GetMachinery", new { id = data.Id }, data)); }
public Machinery Save([FromBody] Machinery entity) { ModelState.Validate(); try { if (entity.Id > 0) { _repository.Update(entity); } else { _repository.Insert(entity); } } catch (SqlException e) { if (e.Number == 2627) { throw new PawnshopApplicationException("Поле номер техпаспорта должно быть уникальным"); } throw new PawnshopApplicationException(e.Message); } catch (Exception e) { throw new PawnshopApplicationException(e.Message); } return(entity); }
public async Task <IHttpActionResult> Add([FromBody] Machinery entity) { DataContext.Machinery.Add(entity); await DataContext.SaveChangesAsync(); return(Json(new ResponseData <Machinery>() { Data = entity })); }
public void CopyFrom(Machinery machine) { Id = machine.Id; Name = machine.Name; if (machine.Type != null) { TypeId = machine.Type.Id; TypeName = machine.Type.Name; } }
public int CreateMachinery(Record record) { Machinery machinery = new Machinery(); try { CatalogDatabaseDataContext context = new WorkLinqToSql.CatalogDatabaseDataContext(); machinery.title = record.Name; machinery.Description = record.Description; machinery.Status = (int)Record.StatusType.PREMODERATION; machinery.Category = record.CategoryID; machinery.UserAuthor = record.UserAuthorID; context.Machineries.InsertOnSubmit(machinery); context.Machineries.Context.SubmitChanges(); foreach (Specification sp in record.Specifications) { if (!CreateSpecifications(sp, machinery.Id)) { throw new Exception("Невожно создать спецификацию"); } } if (record.Tags != null) { foreach (Tag tag in record.Tags) { CreateTag(tag, machinery.Id); } } } catch { return(0); } return(machinery.Id); }
private void ChangeType(Machinery machine, int newTypeId, out IList <Work> conflictWorks) { conflictWorks = null; if (machine.Type.Id != newTypeId) { var newType = dbManager.GetById <MachineryType>(newTypeId); if (CompareAreas(machine, newType)) { machine.SetType(newType); } else { IList <Work> works = FindConflicts(machine); if (works.Count == 0) { machine.SetType(newType); } else { conflictWorks = works; } } } }
public void Update(Machinery entity) { DatabaseFactory.CreateDatabase() .ExecuteNonQuery("UPDATE_MACHINERY_SP", entity.Id, entity.Brand, entity.Model, entity.SerialNumber, entity.LifeHours, entity.CreatedBy, entity.CreationDate); }
public IList <Machinery> GetPaginated(Machinery filters, int pageIndex, int pageSize, out int totalRows) { throw new System.NotImplementedException(); }
private bool CompareAreas(Machinery machine, MachineryType anyType) => anyType.Areas.Any(x => machine.Type.Areas.Any(z => x.Id == z.Id));
private IList <Work> FindConflicts(Machinery machine) => dbManager.GetAll <Work>().Where(x => x.Parent.MachineryId == machine.Id).ToList();
public ActionResult CreateUpdateMachinery(MachineryModel machineryModel) { if (!ModelState.IsValid) { return(ShowErrorMessage(GetModelErrors(ModelState))); } if (!CheckEmployeeHasBalance(machineryModel.Price)) { return(ShowErrorMessage(Constant.InsufficientBalance)); } var machinery = new Machinery(); if (machineryModel.Id > 0) { machinery = FarmManagementEntities.Machineries.Single(x => x.Id == machineryModel.Id); } machinery.FarmId = machineryModel.FarmId; machinery.VendorId = machineryModel.VendorId; machinery.AccountId = machineryModel.AccountId; machinery.Name = machineryModel.Name; machinery.Color = machineryModel.Color; machinery.Type = machineryModel.Type; machinery.RegistrationNo = machineryModel.RegistrationNo; machinery.ModelNo = machineryModel.ModelNo; machinery.CompanyName = machineryModel.CompanyName; machinery.PurchaseDate = machineryModel.PurchaseDate; machinery.OtherDescription = machineryModel.OtherDescription; machinery.Condition = machineryModel.MachineCondition.ToNullIfEmptyEnum <Condition>(); var fileUploadLicense = ClientSession.FileUploads.Single(x => x.FileUploadGuid == machineryModel.MachineryGuid && x.FileUploadName == FileUploadPath.MachineLicenseFile && !x.HasRemoved); machinery.LicenseFile = System.IO.Path.GetFileName(fileUploadLicense.FilePath); var fileUploadPicture = ClientSession.FileUploads.Single(x => x.FileUploadGuid == machineryModel.MachineryGuid && x.FileUploadName == FileUploadPath.MachinePicture && !x.HasRemoved); machinery.Picture = System.IO.Path.GetFileName(fileUploadPicture.FilePath); if (machineryModel.Id == 0) { machinery.Price = machineryModel.Price; machinery.InsertDate = DateTime.Now; machinery.UserId = machineryModel.UserId; FarmManagementEntities.Machineries.Add(machinery); ManageEmployeeBalance(machineryModel.Price); } else { machinery.UpdateDate = DateTime.Now; } FarmManagementEntities.SaveChanges(); UpdateFileUploadPath(FileUploadPath.MachineLicenseFile, fileUploadLicense, machinery.Id); UpdateFileUploadPath(FileUploadPath.MachinePicture, fileUploadPicture, machinery.Id); ClearAllFileUpload(); var message = string.Format(Constant.SuccessMessage, machineryModel.Id > 0 ? "updated" : "added"); return(ShowSuccessMessage(message)); }