Example #1
0
        public TblDyeingPlanHeaderAcc SaveDyeingHeaderListAcc(TblDyeingPlanHeaderAcc header, List <TblDyeingPlanACC> mainDetails, List <TblDyeingSummaryAcc> summaryList)
        {
            using (var entities = new WorkFlowManagerDBEntities())
            {
                #region PlanWithoutSummary

                if (header.Iserial != 0)
                {
                    var h = entities.TblDyeingPlanHeaderAccs.SingleOrDefault(x => x.Iserial == header.Iserial);

                    h.DocNo           = header.DocNo;
                    h.Location        = header.Location;
                    h.Brand           = header.Brand;
                    h.TblLkpSeason    = header.TblLkpSeason;
                    h.TransactionDate = header.TransactionDate;
                }
                else
                {
                    entities.AddToTblDyeingPlanHeaderAccs(header);
                }

                foreach (var dyeingPlanRow in mainDetails)
                {
                    if (dyeingPlanRow.Iserial == 0)
                    {
                        dyeingPlanRow.DyeingHeader = header.Iserial;
                        entities.AddToTblDyeingPlanACCs(dyeingPlanRow);
                    }
                    else
                    {
                        var mainDetailRow = (from d in entities.TblDyeingPlanACCs
                                             where d.DyeingHeader == header.Iserial &&
                                             d.Iserial == dyeingPlanRow.Iserial
                                             select d).SingleOrDefault();

                        if (mainDetailRow != null)
                        {
                            // MainDetailRow.TransactionDate = item.TransactionDate;
                        }
                        else
                        {
                            entities.AddToTblDyeingPlanACCs(dyeingPlanRow);
                        }
                    }
                    entities.SaveChanges();

                    if (dyeingPlanRow.DyeingHeader != 0)
                    {
                        foreach (var dyeingDetailsPlanRow in dyeingPlanRow.TblDyeingPlanDetailsAccs.ToList())
                        {
                            var dyeingOrderDetails = (from d in entities.TblDyeingPlanDetailsAccs
                                                      where d.Iserial == dyeingDetailsPlanRow.Iserial &&
                                                      d.FabricColorName == dyeingDetailsPlanRow.FabricColorName
                                                      select d).SingleOrDefault();
                            if (dyeingOrderDetails != null)
                            {
                                dyeingOrderDetails.BatchNo          = dyeingDetailsPlanRow.BatchNo;
                                dyeingOrderDetails.FabricColorValue = dyeingDetailsPlanRow.FabricColorValue;
                                dyeingOrderDetails.BatchNoCreated   = dyeingDetailsPlanRow.BatchNoCreated;
                                dyeingOrderDetails.OldColor         = dyeingDetailsPlanRow.OldColor;
                            }
                            else
                            {
                                dyeingDetailsPlanRow.TblDyeingPlanACC = null;
                                entities.AddToTblDyeingPlanDetailsAccs(dyeingDetailsPlanRow);
                            }
                            entities.SaveChanges();
                        }
                    }
                }

                #endregion PlanWithoutSummary

                #region SummarySaving

                foreach (var summaryRow in summaryList)
                {
                    if (summaryRow.Iserial != 0)
                    {
                        var querySummaryrow = (from d in entities.TblDyeingSummaryAccs
                                               where d.Iserial == summaryRow.Iserial
                                               select d).SingleOrDefault();

                        if (querySummaryrow != null)
                        {
                            querySummaryrow.Color              = summaryRow.Color;
                            querySummaryrow.DyedFabric         = summaryRow.DyedFabric;
                            querySummaryrow.Unit               = summaryRow.Unit;
                            querySummaryrow.CalculatedTotalQty = summaryRow.CalculatedTotalQty;
                            querySummaryrow.FabricCode         = summaryRow.FabricCode;
                            querySummaryrow.Vendor             = summaryRow.Vendor;
                        }
                    }
                    else
                    {
                        summaryRow.TblDyeingPlanHeaderAcc = null;
                        summaryRow.DyeingHeader           = header.Iserial;
                        entities.AddToTblDyeingSummaryAccs(summaryRow);
                    }
                    entities.SaveChanges();
                    foreach (var planLotsMasterRow in summaryRow.TblDyeingPlanLotsMasterAccs)
                    {
                        if (planLotsMasterRow.Iserial != 0)
                        {
                            var queryPlanLotsMasterRow = (from d in entities.TblDyeingPlanLotsMasterAccs
                                                          where d.Iserial == planLotsMasterRow.Iserial
                                                          select d).SingleOrDefault();

                            queryPlanLotsMasterRow.FabricCode        = planLotsMasterRow.FabricCode;
                            queryPlanLotsMasterRow.FabricLot         = planLotsMasterRow.FabricLot;
                            queryPlanLotsMasterRow.AvaliableQuantity = planLotsMasterRow.AvaliableQuantity;
                            queryPlanLotsMasterRow.Config            = planLotsMasterRow.Config;
                            queryPlanLotsMasterRow.RequiredQuantity  = planLotsMasterRow.RequiredQuantity;
                            queryPlanLotsMasterRow.Unit = planLotsMasterRow.Unit;
                        }
                        else
                        {
                            planLotsMasterRow.TblDyeingSummaryAcc       = null;
                            planLotsMasterRow.DyeingsSummaryPlanIserial = summaryRow.Iserial;
                            entities.AddToTblDyeingPlanLotsMasterAccs(planLotsMasterRow);
                        }
                        entities.SaveChanges();

                        foreach (var planLotDetailsRow in planLotsMasterRow.TblDyeingPlanLotsDetailsAccs)
                        {
                            if (planLotDetailsRow.Iserial != 0)
                            {
                                var queryPlanLotsDetailsRow = (from d in entities.TblDyeingPlanLotsDetailsAccs
                                                               where d.Iserial == planLotDetailsRow.Iserial
                                                               select d).SingleOrDefault();

                                queryPlanLotsDetailsRow.DeliveryDate     = planLotDetailsRow.DeliveryDate;
                                queryPlanLotsDetailsRow.RequiredQuantity = planLotDetailsRow.RequiredQuantity;
                                queryPlanLotsDetailsRow.SalesOrder       = planLotDetailsRow.SalesOrder;
                                queryPlanLotsDetailsRow.Saved            = planLotDetailsRow.Saved;
                            }
                            else
                            {
                                planLotDetailsRow.TblDyeingPlanLotsMasterAcc = null;
                                planLotDetailsRow.FabricLotMasterIserial     = planLotsMasterRow.Iserial;
                                entities.AddToTblDyeingPlanLotsDetailsAccs(planLotDetailsRow);
                            }
                        }
                    }
                }

                entities.SaveChanges();

                #endregion SummarySaving

                return(header);
            }
        }