private static GenericResponse UpdatePack(PackInformation pkinfo) { try { var response = new GenericResponse(); using (var context = new Entities()) { var yd = (from yard in context.Yards where yard.Id == pkinfo.YardId select yard.CustomerNumberPrefix).First() ?? string.Empty; pkinfo.NumberPrefix = yd; pkinfo.InternalPackNumber = yd.Trim() + pkinfo.TagNumber; var pack = (from pk in context.Packs where pk.Id == pkinfo.Id select pk).FirstOrDefault(); if (pack == null) { var pk = new Pack(); Mapper.Map(pkinfo, pk); context.Packs.AddObject(pk); } else Mapper.Map(pkinfo, pack); context.SaveChanges(); } response.Success = true; return response; } catch (Exception ex) { LoggingMediator.Log("UpdatePack"); LoggingMediator.Log(ex); return new GenericResponse {Success = false, FailureInformation = "Error in PAPService:UpdatePack"}; } }
private GenericResponse WritePapXml() { try { var response = new GenericResponse(); using (var context = new Entities()) { var availablePacks = GetPacksByYard(context); var availablePackLists = GetPackListsByYard(context); var availableTransfersPackLists = GetTransferPackListsByYard(context); var availableContracts = GetOpenContractsByYard(context); var availableTransfers = GetHeldTransferSentHeadByYard(context); var availableInventory = GetAvailableInventoryByYard(context); var allAvailableContracts = availableContracts.Concat(availableTransfers).ToArray(); var allAvailablePacklists= availablePackLists.Concat(availableTransfersPackLists).ToArray(); var sendData = new Root { AvailableContracts = allAvailableContracts, InventoryItems = availableInventory, PackLists = allAvailablePacklists, AvailablePacks = availablePacks }; var writer = new XmlSerializer(typeof (Root)); var desktopFolder = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory); var fullFileName = Path.Combine(desktopFolder, "SendPAP.xml"); using (var fs = new FileStream(fullFileName, FileMode.Create)) { writer.Serialize(fs, sendData); fs.Close(); } } response.Success = true; return response; } catch (Exception ex) { LoggingMediator.Log("ReadPapXml"); LoggingMediator.Log(ex); throw; } }
private GenericResponse CreatePackListsFromXml(IEnumerable<PackListReadInformation> listcollection) { var response = new GenericResponse(); var userId = Guid.Parse("9BB44614-26C8-4761-BD54-2204E0E76C2D"); using (var context = new Entities()) { foreach (var pl in listcollection) { var isTransfer = context.TransferSentHeads.FirstOrDefault(trans => trans.Id == Guid.Parse(pl.ContractId)) != null; var plist = new PackListInformation { Id = Guid.Parse(pl.PackListId), ContractHeadId = isTransfer?Guid.Empty:Guid.Parse(pl.ContractId), TransferSentHeadId = isTransfer ? Guid.Parse(pl.ContractId):Guid.Empty, CreatedByUserId = userId, PackListNumber = Convert.ToInt32(pl.PackListNumber), DateCreated = DateTime.Now, SealNumber = string.Empty, Units = 0, PackListStatus = (int) PackListStatus.Held, }; var pkresponse = isTransfer?UpdateTransferPackList(plist):UpdatePackList(plist); if (!pkresponse.Success) response.FailureInformation += pkresponse.FailureInformation; } } return response; }
private GenericResponse CreatePacksFromXml(IEnumerable<PackReadInformation> packcollection) { var response = new GenericResponse(); var userId = Guid.Parse("9BB44614-26C8-4761-BD54-2204E0E76C2D"); foreach (var pk in packcollection) { var pack = new PackInformation { Id = Guid.Parse(pk.Id), GrossWeight = Convert.ToDecimal(pk.GrossWeight), TareWeight = Convert.ToDecimal(pk.TareWeight), ScaleGrossWeight = Convert.ToDecimal(pk.ScaleGrossWeight), ScaleTareWeight = Convert.ToDecimal(pk.ScaleTareWeight), TagNumber = Convert.ToInt32(pk.TagNumber), PrintDescription = pk.PrintDescription, UnitOfMeasure = pk.UnitOfMeasure, DateCreated = Convert.ToDateTime(pk.DateCreated), DateClosed = Convert.ToDateTime(pk.DateClosed), Quantity = Convert.ToInt16(pk.Quantity), CommodityType = Convert.ToInt16(pk.CommodityType), PackStatus = Convert.ToInt16(pk.PackStatus), InventoryId = Guid.Parse(pk.InventoryId), YardId = YardId, NumberPrefix = string.Empty, InternalPackNumber = string.Empty, Cost = Convert.ToDecimal(pk.Cost), CreatedByUserId = userId, }; var pkresponse = UpdatePack(pack); if (!pkresponse.Success) response.FailureInformation += pkresponse.FailureInformation; } return response; }
private GenericResponse ReadPapXml() { try { var response = new GenericResponse(); var xmlDoc = XDocument.Load(@"Files\ReceivePAP.xml"); var packxmldata = new Packs(); var packlistxmldata = new PackLists(); var settings = new XmlReaderSettings {IgnoreWhitespace = true}; var buffer = Encoding.ASCII.GetBytes(xmlDoc.ToString()); var xmlStream = new MemoryStream(buffer); using (var xmlReader = XmlReader.Create(xmlStream, settings)) { var packXmlSerializer = new XmlSerializer(packxmldata.GetType()); var packlistXmlSerializer = new XmlSerializer(packlistxmldata.GetType()); packxmldata = (Packs) packXmlSerializer.Deserialize(xmlReader); packlistxmldata = (PackLists) packlistXmlSerializer.Deserialize(xmlReader); response.FailureInformation = CreatePacksFromXml(packxmldata.PackCollection).FailureInformation; response.FailureInformation += CreatePackListsFromXml(packlistxmldata.PackListCollection); } return response; } catch (Exception ex) { LoggingMediator.Log("ReadPapXml"); LoggingMediator.Log(ex); throw; } }
private static GenericResponse UpdateTransferPackList(PackListInformation listinfo) { try { var response = new GenericResponse(); using (var context = new Entities()) { var plist = (from list in context.TransferPackListHeads where list.Id == listinfo.Id select list).FirstOrDefault(); if (plist == null) { var list = new TransferPackListHead(); Mapper.Map(listinfo, list); context.TransferPackListHeads.AddObject(list); } else Mapper.Map(listinfo, plist); context.SaveChanges(); } response.Success = true; return response; } catch (Exception ex) { LoggingMediator.Log("UpdatePack"); LoggingMediator.Log(ex); return new GenericResponse {Success = false, FailureInformation = "Error in PAPService:UpdateTransferPackList"}; } }