public static void NotifyGIN(Guid truckId) { IGINProcess ginProcess = GetGINProcess(true); ILookupSource lookup = ginProcess.LookupSource; GINProcessInfo ginProcessInfo = ginProcess.GINProcessInformation; GINTruckInfo truck = (from trk in ginProcessInfo.Trucks where trk.TruckId == truckId select trk).Single(); ECXCD.WR wr = new WarehouseApplication.ECXCD.WR(); wr.SaveGIN( truck.GIN.GINId, truck.GIN.GINNo, ginProcessInfo.PickupNoticeId, Convert.ToDouble(truck.GIN.GrossWeight), Convert.ToDouble(truck.GIN.NetWeight), Convert.ToDouble(truck.GIN.Quantity), truck.GIN.DateIssued, truck.GIN.SignedByClient, truck.GIN.DateApproved, truck.GIN.ApprovedBy, truck.Load.Remark + Environment.NewLine + truck.Weight.Remark, lookup.GetLookup("GINStatus")[truck.GIN.Status]); }
public bool Save() { bool isSaved = false; try { if (this.CommodityGradeId == Guid.Empty) { throw new Exception("Commodity Grade Can't be empty"); } WarehouseApplication.ECXCD.WR mywarehouse = new WarehouseApplication.ECXCD.WR(); isSaved = mywarehouse.SaveWareHouseReciept(this.GRNId, this.GRNNumber, this.CommodityGradeId, this.WarehouseId, this.BagTypeId, this.VoucherId, this.UnloadingId, this.ScalingId, this.GradingId, this.SampleTicketId, this.DateDeposited, this.DateApproved, this.GRN_Status, this.GrossWeight, (float)((Math.Round(this.NetWeight * 10000)) / 10000), (float)(Math.Round(this.OriginalQuantity * 10000, 0)) / 10000, (float)(Math.Round(this.CurrentQuantity * 10000, 0)) / 10000, DepositTypeId, Source, NetWeightAdjusted, this.CreatedBy, this.CreatedTimestamp, this.ClientId, this.NoBags, this.ProductionYear, this.GRNType); } catch (Exception ex) { throw new Exception("Unable to Create Warehouse Reciept", ex); } return(isSaved); }
public static void UpdatePUNStatus(Guid pickupNoticeId, string punStatus) { ECXCD.WR wr = new WarehouseApplication.ECXCD.WR(); wr.UpdatePUNStatus(pickupNoticeId, punStatus); }
public static bool RequestCancel(Guid GRNId, string TrackingNo, string Remark) { WarehouseApplication.ECXCD.WR o = new WarehouseApplication.ECXCD.WR(); return(o.RequestWHRCancel(GRNId, UserBLL.GetCurrentUser(), Remark, TrackingNo)); }
public static void CachePickupNotices() { List <Guid> cachedPunIds = new List <Guid>(); ECXCD.WR wr = new WarehouseApplication.ECXCD.WR(); List <ECXCD.CPickUpNotice> importedPuns = new List <WarehouseApplication.ECXCD.CPickUpNotice>(wr.GetPun()); int importedPunsCount = importedPuns.Count; if (importedPunsCount == 0) { return; } List <PickupNoticeInformation> cachedPuns = new List <PickupNoticeInformation>( from ipun in importedPuns where ipun.WarehouseId == new Guid(StaticLookupSource.GetLookup("CurrentWarehouse")["Id"]) select new PickupNoticeInformation() { ClientId = ipun.ClientId, MemberId = ipun.MemberId, RepId = ipun.RepId, CommodityGradeId = ipun.CommodityGradeId, ProductionYear = ipun.ProductionYear, ExpectedPickupDate = ipun.ExpectedPickupDate, ExpirationDate = ipun.ExpirationDate, PickupNoticeId = ipun.PickupNoticeId, WarehouseId = ipun.WarehouseId, Quantity = ipun.Quantity, Weight = ipun.Weight, Status = 0 }); int cachedPunsCount = cachedPuns.Count; Dictionary <string, object> contextParameters = new Dictionary <string, object>(); contextParameters.Add("CurrentUser", new Guid(SystemLookup.LookupSource.GetLookup("CurrentUser")["Id"])); cachedPuns.ForEach( delegate(PickupNoticeInformation pun) { pun.PickupNoticeAgents.AddRange( from ipun in importedPuns where ipun.PickupNoticeId == pun.PickupNoticeId from ipuna in ipun.PickupNoticeAgents select new PickupNoticeInformation.PickupNoticeAgentInformation() { AgentName = ipuna.AgentName, AgentTel = ipuna.AgentTel, Id = Guid.NewGuid(), NIDNumber = ipuna.NIDNumber, NIDType = ipuna.NIDType, PickupNoticeId = ipuna.PickupNoticeId, Status = ipuna.Status }); pun.WarehouseReceipts.AddRange( from ipun in importedPuns where ipun.PickupNoticeId == pun.PickupNoticeId from iwr in ipun.WarehouseReciepts select new PickupNoticeInformation.WarehouseReceiptInformation() { Bags = iwr.Bags, BagType = iwr.BagType, GRNID = iwr.GRNID, GRNNo = iwr.GRNNo, Id = iwr.Id, PickupNoticeId = iwr.PickupNoticeId, Quantity = Convert.ToDecimal(iwr.Quantity), ShedId = iwr.ShedId, WarehouseReceiptId = iwr.WarehouseRecieptId, Weight = Convert.ToDecimal(iwr.Weight) }); Queue <object[]> queue = new Queue <object[]>(); queue.Enqueue(new object[] { pun, "spImportPUN" }); pun.PickupNoticeAgents.ForEach(puna => queue.Enqueue(new object[] { puna, "spImportPUNAgent" })); pun.WarehouseReceipts.ForEach(wrct => queue.Enqueue(new object[] { wrct, "spImportWarehouseReceipt" })); SqlTransaction transaction = null; try { transaction = PersistenceTransactionFactory.CreatePersistenceTransaction().Persist(queue, contextParameters); transaction.Commit(); cachedPunIds.Add(pun.PickupNoticeId); } catch (Exception ex) { try { if (transaction != null) { transaction.Rollback(); } } catch (Exception) { } } }); wr.AcknowledgePuns(cachedPunIds.ToArray()); }