public static void Update(PartDTO partDTO) { string sql = "update Part set Name =('" + partDTO.Name + "'), Sign =('" + partDTO.Sign + "'), Amount =(" + partDTO.Amount + "), Limit =(" + partDTO.Limit + ") where PartID =" + partDTO.Id + ""; Database.ExcuNonQuery(sql); }
public PartDTO WritePartDto(Part part) { var partDto = new PartDTO(); partDto.PartNumber = part.PartNumber; partDto.UnitOfMeasure = part.UnitOfMeasure; partDto.ExtendedDescription = part.ExtendedDescription; partDto.PartDescription = part.PartDescription; partDto.SalesCode = part.SalesCode; var componentsList = part.Components .Select(component => new ComponentDTO() { Number = component.ComponentNumber, Description = component.ComponentDescription, Material = component.Material, UnitOfMeasure = component.UnitOfMeasure, QuantityPerAssembly = component.QuantityPerAssembly, CostPerUnit = component.CostPerUnit }).ToList(); var laborSequenceList = part.LaborSequences .Select(labor => new LaborSequenceDTO() { LaborSequenceNumber = labor.LaborSequenceNumber, LaborSequenceDesc = labor.LaborSequenceDesc, RunTime = labor.RunTime, LaborRate = labor.LaborRate, Burden = labor.Burden }).ToList(); partDto.Components = componentsList; partDto.Labor = laborSequenceList; return(partDto); }
public IEnumerable <PartDTO> GetReportDetails(PartDTO partDTO) { var parts = _bheUOW.PartsRepository.Query(); if (!string.IsNullOrEmpty(partDTO.PartNumber)) { parts = parts.Where(x => x.PartNumber == partDTO.PartNumber); } if (!string.IsNullOrEmpty(partDTO.Make) && partDTO.Make != "All") { parts = parts.Where(x => x.Make == partDTO.Make); } if (!string.IsNullOrEmpty(partDTO.Model)) { parts = parts.Where(x => x.Model == partDTO.Model); } if (!string.IsNullOrEmpty(partDTO.PartDescription)) { parts = parts.Where(x => x.PartDescription.Contains(partDTO.PartDescription)); } if (!string.IsNullOrEmpty(partDTO.PartManual)) { parts = parts.Where(x => x.PartManual.Contains(partDTO.PartManual)); } if (!string.IsNullOrEmpty(partDTO.SerialNumberRange)) { parts = parts.Where(x => x.SerialNumberRange.Contains(partDTO.SerialNumberRange)); } return(parts.ToList().ConvertAll(PartDTOMapper)); }
public long Add(PartDTO partDTO) { try { Part part = new Part() { CompanyID = partDTO.CompanyID, ListPrice = partDTO.ListPrice, Make = partDTO.Make, Model = partDTO.Model, PartDescription = partDTO.PartDescription, PartManual = partDTO.PartManual, PartNumber = partDTO.PartNumber, SerialNumberRange = partDTO.SerialNumberRange, AddedBy = "Admin", AddedDate = DateTime.Now, IsDeleted = false }; var partID = _bheUOW.PartsRepository.Add(part); _bheUOW.SaveChanges(); return(partID); } catch (Exception ex) { throw ex; } }
public IEnumerable <BikeDTO> GetBikes() { return(_bikeRepository.GetAll().Select(b => { return new BikeDTO { Id = b.Id, Name = b.Name, Type = b.Type, Parts = b.Parts.Select(p => { PartDTO part = new PartDTO { Id = p.Part.Id, Name = p.Part.Name, Description = p.Part.Description, Functionality = p.Part.Functionality.ToString(), IsOptional = p.Part.IsOptional, DominantParts = p.Part.DominantParts.Select(dp => dp.DominantPart.Name).ToList(), DependantParts = p.Part.DependantParts.Select(dp => dp.DependantPart.Name).ToList(), BikeId = p.Part.BikeParts.Select(b => b.BikeId).ToList() }; return part; }).OrderBy(p => p.Name).ToList() }; }).ToList()); }
public HttpResponseMessage GetPartsDetails(PartDTO partDTO) { //PartDTO partDTO = new PartDTO(); var partsList = _partBL.GetReportDetails(partDTO); return(_httpResponseMessageBuilder.GetResponse(partsList, Request)); }
public ActionResult GetPartsReport(PartDTO part) { try { Parts parts = new Parts(); InitializeReportViewer(); //List<PartDTO> parts = GetPartData(part); List <PartDTO> partsList = parts.GetPartData(part); if (partsList != null && partsList.Count > 0) { if (partsList.Count > 10000) { ViewBag.MaxRecordExceed = " Search results exceed maximum limit of 10,000 records, please refine the 'Search Terms' and try again"; } else { string path = Path.Combine(Server.MapPath("~/BrownsReports"), "rpdPart.rdlc"); _reportViewer.LocalReport.ReportPath = path; _reportViewer.LocalReport.DataSources.Add(new ReportDataSource("BHEDS", partsList)); ViewBag.ReportViewer = _reportViewer; } } ViewBag.OnLoad = "OnReportLoading"; return(View("Index")); } catch (Exception ex) { WrapLogException(ex); return(null); } }
public async Task <List <PartDTO> > Search(PartSearchCriteria searchCriteria) { var partList = await this.FindParts(searchCriteria); var partListDTO = new List <PartDTO>(); foreach (var p in partList) { var partDto = new PartDTO { PartId = p.PartId, ItemId = p.ItemId, ItemName = p.ItemName, CategoryId = p.CategoryId, IconLink = p.IconLink, ImageLink = p.ImageLink, ItemDimensionX = p.ItemDimensionX, ItemDimensionY = p.ItemDimensionY, ItemDimensionZ = p.ItemDimensionZ, ItemTypeId = p.ItemTypeId, ItemTypeName = p.ItemType.ItemTypeName, CategoryName = p.Category.Name, Quantity = p.Quantity, ColorCount = p.ColorQuantity }; partDto.PartColors = await PartColors(p.ItemId); partListDTO.Add(partDto); } return(partListDTO); }
public ActionResult <BikeDTO> GetBikeByName(string name) { try { Bike bike = _bikeRepository.GetByName(name); BikeDTO bikeDTO = new BikeDTO { Id = bike.Id, Name = bike.Name, Parts = bike.Parts.Select(p => { PartDTO part = new PartDTO { Id = p.Part.Id, Name = p.Part.Name, Description = p.Part.Description, Functionality = p.Part.Functionality.ToString(), IsOptional = p.Part.IsOptional, DominantParts = p.Part.DominantParts.Select(dp => dp.DominantPart.Name).ToList(), DependantParts = p.Part.DependantParts.Select(dp => dp.DependantPart.Name).ToList(), BikeId = p.Part.BikeParts.Select(b => b.BikeId).ToList() }; return(part); }).OrderBy(p => p.Name).ToList(), Type = bike.Type }; return(Ok(bikeDTO)); } catch (Exception e) { return(BadRequest(e)); } }
public async Task PartService_Should_Update_Part() { // Arrange SetUpUnitOfWork(); var service = new PartService(_unitOfWork.Object, _mapper); var entity = new PartDTO() { Name = "TestName", Code = "12345", }; var newEntity = new PartDTO() { Name = "NewTestName", Code = "12345678", }; await service.CreateAsync(entity); await _unitOfWork.Object.SaveAsync(); // Act entity.Name = newEntity.Name; entity.Code = newEntity.Code; await service.UpdateAsync(entity); await _unitOfWork.Object.SaveAsync(); // Assert Assert.NotNull(entity); Assert.Equal(newEntity.Name, entity.Name); Assert.Equal(newEntity.Code, entity.Code); }
public static void Insert(PartDTO partDTO) { string sql = "insert into Part(PartID, PartName, Sign, Amount, Limit) values ('" + partDTO.Id + "', '" + partDTO.Name + "', '" + partDTO.Sign + "', " + partDTO.Amount + ", " + partDTO.Limit + ")"; Database.ExcuNonQuery(sql); }
public async Task <PartDTO> UpdateAsync(PartDTO dto) { var model = _mapper.Map <Part>(dto); _unitOfWork.PartRepository.Update(model); await _unitOfWork.SaveAsync(); return(_mapper.Map <PartDTO>(model)); }
public async Task <IActionResult> Add([FromRoute] string buildingId, [FromBody] PartDTO request) { await _mediator.Send(new CreatePartCommand { BuildingExternalId = buildingId, Name = request.Name, Budget = request.Budget, EndDate = request.EndDate, StartDate = request.StartDate }); return(Ok()); }
public void Execute(PartDTO partDto) { using (_context = new CarHistoryContext()) { //_context.Database.CreateIfNotExists(); DB.Domain.Part part = new DB.Domain.Part(); part.Name = partDto.Name; _context.Parts.Add(part); _context.SaveChanges(); } }
private void updatePart() { PartDTO partDTO = new PartDTO(); partDTO.Id = tbPartIdEdit.Text; partDTO.Name = tbPartNameEdit.Text; partDTO.Sign = tbPartSignEdit.Text; partDTO.Amount = int.Parse(tbPartAmountEdit.Text); partDTO.Limit = int.Parse(tbPartIdEdit.Text); PartDAO.Update(partDTO); loadPartList(); }
public async Task <IActionResult> Update([FromRoute] string id, [FromBody] PartDTO request) { await _mediator.Send(new UpdatePartCommand { EndDate = request.EndDate, Budget = request.Budget, Name = request.Name, PartExternalId = id, StartDate = request.StartDate }); return(Ok()); }
private void createPart() { PartDTO partDTO = new PartDTO(); partDTO.Id = tbPartIdCreate.Text; partDTO.Name = tbPartNameCreate.Text; partDTO.Sign = tbPartSignCreate.Text; partDTO.Amount = int.Parse(tbPartAmountCreate.Text); partDTO.Limit = int.Parse(tbPartIdCreate.Text); PartDAO.Insert(partDTO); loadPartList(); }
public List <PartDTO> GetPartListforReport(PartDTO partDTO) { HttpResponseMessage response = null; List <PartDTO> plist = null; _client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json")); response = _client.PostAsync("Part/GetReportDetails", new StringContent( new JavaScriptSerializer().Serialize(partDTO), Encoding.UTF8, "application/json")).Result; if (response.IsSuccessStatusCode) { plist = response.Content.ReadAsAsync <List <PartDTO> >().Result; } return(plist); }
public long Delete(PartDTO partDTO) { Part part = new Part() { CompanyID = partDTO.CompanyID, ListPrice = partDTO.ListPrice, Make = partDTO.Make, Model = partDTO.Model, PartDescription = partDTO.PartDescription, PartManual = partDTO.PartManual, PartNumber = partDTO.PartNumber, SerialNumberRange = partDTO.SerialNumberRange, ID = partDTO.ID }; var partID = _bheUOW.PartsRepository.Delete(part); _bheUOW.SaveChanges(); return(partID); }
public async Task PartService_Should_Create_Part_Async() { // Arrange SetUpUnitOfWork(); var service = new PartService(_unitOfWork.Object, _mapper); var expectedEntity = new PartDTO() { Name = "TestName", Code = "12345", }; // Act var actualEntity = await service.CreateAsync(expectedEntity); await _unitOfWork.Object.SaveAsync(); // Assert Assert.NotNull(actualEntity); Assert.Equal(expectedEntity.Name, actualEntity.Name); Assert.Equal(expectedEntity.Code, actualEntity.Code); }
public async Task PartService_Should_Delete_Part_Async() { // Arrange SetUpUnitOfWork(); var service = new PartService(_unitOfWork.Object, _mapper); var entity = new PartDTO() { Name = "TestName", Code = "12345" }; entity = await service.CreateAsync(entity); await _unitOfWork.Object.SaveAsync(); // Act await service.DeleteAsync(entity.Id); await _unitOfWork.Object.SaveAsync(); // Assert Assert.Null(await service.GetAsync(entity.Id)); }
public long Update(PartDTO partDTO) { long ID = -1; var existingPart = _bheUOW.PartsRepository.Query().SingleOrDefault(x => x.ID == partDTO.ID); if (existingPart != null) { existingPart.CompanyID = partDTO.CompanyID; existingPart.ListPrice = partDTO.ListPrice; existingPart.Make = partDTO.Make; existingPart.Model = partDTO.Model; existingPart.PartDescription = partDTO.PartDescription; existingPart.PartManual = partDTO.PartManual; existingPart.PartNumber = partDTO.PartNumber; existingPart.SerialNumberRange = partDTO.SerialNumberRange; existingPart.LastUpdatedBy = "Admin"; existingPart.LastUpdatedDate = DateTime.Now; existingPart.IsDeleted = false; _bheUOW.SaveChanges(); ID = existingPart.ID; } return(ID); }
public ActionResult <PartDTO> GetById(int id) { Part p = _partRepository.GetById(id); if (p == null) { return(NotFound()); } PartDTO partDTO = new PartDTO { Id = p.Id, Name = p.Name, Description = p.Description, Functionality = p.Functionality.ToString(), IsOptional = p.IsOptional, DominantParts = p.DominantParts.Select(dp => dp.DominantPart.Name).ToList(), DependantParts = p.DependantParts.Select(dp => dp.DependantPart.Name).ToList(), BikeId = p.BikeParts.Select(b => b.BikeId).ToList() }; return(Ok(partDTO)); }
public List <PartDTO> GetPartData(PartDTO partDTO) { try { SqlCommand command = new SqlCommand(); ISqlConnectionHelper sqlHelper = new SqlConnectionHelper(ConfigurationManager.ConnectionStrings["BrownsAppDBConnectionString"].ConnectionString); DataTable dtResults = new DataTable(); DataSet dsResults = new DataSet(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "dbo.GetPartReportData"; command.Parameters.AddWithValue("@Make", string.IsNullOrEmpty(partDTO.Make) ? null : partDTO.Make.Trim()); command.Parameters.AddWithValue("@Model", string.IsNullOrEmpty(partDTO.Model) ? null : partDTO.Model.Trim()); command.Parameters.AddWithValue("@SerialNumberRange", string.IsNullOrEmpty(partDTO.SerialNumberRange) ? null : partDTO.SerialNumberRange.Trim()); command.Parameters.AddWithValue("@PartNumber", string.IsNullOrEmpty(partDTO.PartNumber) ? null : partDTO.PartNumber.Trim()); command.Parameters.AddWithValue("@PartManual", string.IsNullOrEmpty(partDTO.PartManual) ? null : partDTO.PartManual.Trim()); command.Parameters.AddWithValue("@PartDescription", string.IsNullOrEmpty(partDTO.PartDescription) ? null : partDTO.PartDescription.Trim()); dsResults = sqlHelper.ExecuteStoredProcedure(command); if (dsResults != null && dsResults.Tables.Count > 0) { return(ConvertToList(dsResults)); } else { return(null); } } catch (Exception ex) { ExceptionHandler exceptionHandler = new ExceptionHandler(); exceptionHandler.WrapLogException(ex); return(null); } }
public HttpResponseMessage Delete(PartDTO partDTO) { var partID = _partBL.Delete(partDTO); return(_httpResponseMessageBuilder.GetSimpleResponse(partID, Request)); }
public HttpResponseMessage Put(PartDTO partDTO) { var part = _partBL.Update(partDTO); return(_httpResponseMessageBuilder.GetSimpleResponse(part, Request)); }
public IEnumerable <PartDTO> Get([FromQuery] QueryParams queryParams) { List <PartDTO> rows = new List <PartDTO>(); using (TextFieldParser parser = new TextFieldParser(@"/Users/karukenert/Documents/projects.tmp/WebApplicationVaruosad/LE.txt")) { parser.TextFieldType = FieldType.Delimited; parser.SetDelimiters("\t"); while (!parser.EndOfData) { //Processing row string[] columns = parser.ReadFields(); var part = new PartDTO(); part.Serial = columns[0]; part.Name = columns[1]; part.Price = columns[8]; part.PriceVAT = columns[10]; part.CarModel = columns[9]; int stockCount = 0; int.TryParse(columns[2], out stockCount); part.Stock.Add("Tallinn", stockCount); int.TryParse(columns[3], out stockCount); part.Stock.Add("Tartu", stockCount); int.TryParse(columns[4], out stockCount); part.Stock.Add("Pärnu", stockCount); int.TryParse(columns[5], out stockCount); part.Stock.Add("Kohta-Järve", stockCount); int.TryParse(columns[6], out stockCount); rows.Add(part); } } var query = rows.AsQueryable(); // Nime järgi otsimine - works if (queryParams.Name.Length > 0) { query = query.Where(row => row.Name.ToLower().Contains(queryParams.Name.ToLower())); } // Seerianumbri järgi otsimine - works if (queryParams.Serial.Length > 0) { query = query.Where(row => row.Serial == queryParams.Serial); } NumberFormatInfo provider = new NumberFormatInfo(); provider.NumberDecimalSeparator = ","; //Sorting - works if (queryParams.Sort.ToLower() == "price") { query = query.OrderBy(item => Convert.ToDouble(item.Price, provider)); } else if (queryParams.Sort.ToLower() == "-price") { query = query.OrderByDescending(item => Convert.ToDouble(item.Price, provider)); } query = query.Skip((queryParams.Page - 1) * queryParams.PageSize).Take(queryParams.PageSize); return(query.ToList()); }