Beispiel #1
0
        public void InsertInto(string message)
        {
            string[] parsed    = message.Split(',');;
            string   areaId    = parsed[0];
            string   serialId  = parsed[1];
            string   lineId    = parsed[2];
            string   stateName = parsed[3];
            string   reason    = parsed[4];
            DateTime date      = DateTime.Parse(parsed[5]);
            int      productId = Int32.Parse(parsed[6]);

            using (var context = new YoYoDbContext())
            {
                if (!context.Serial.Any(o => o.SerialId == serialId))
                {
                    context.Serial.Add(new Serial {
                        SerialId = serialId, LineId = lineId, ProductId = productId
                    });
                    if (!context.Lines.Any(o => o.LineId == lineId))
                    {
                        context.Lines.Add(new Line {
                            LineId = lineId, WorkAreaId = areaId
                        });
                        if (!context.WorkAreas.Any(o => o.WorkAreaId == areaId))
                        {
                            context.WorkAreas.Add(new WorkArea {
                                WorkAreaId = areaId
                            });
                        }
                    }
                    context.SerialProduct.Add(new SerialProduct {
                        SerialId = serialId, ProductId = productId
                    });
                }
                context.SerialState.Add(new SerialState {
                    SerialId = serialId, StateName = stateName, Reason = reason, Date = date
                });

                context.SaveChanges();
            }
        }
Beispiel #2
0
        public DAL()
        {
            string connectionString = ConfigurationManager.ConnectionStrings["YoYo"].ConnectionString;

            Console.WriteLine(connectionString);
            //check database exist
            if (Database.Exists(ConfigurationManager.ConnectionStrings["YoYo"].ConnectionString))
            {
                Console.WriteLine("exist");
            }
            else
            {
                Console.WriteLine("Data base is note exist, create one");
                // if not exit create
                using (var context = new YoYoDbContext())
                {
                    #region state
                    var states = new List <State>
                    {
                        new State {
                            StateName = "MOLD"
                        },
                        new State {
                            StateName = "QUEUE_INSPECTION_1"
                        },
                        new State {
                            StateName = "INSPECTION_1"
                        },
                        new State {
                            StateName = "INSPECTION_1_SCRAP"
                        },
                        new State {
                            StateName = "QUEUE_PAINT"
                        },
                        new State {
                            StateName = "PAINT"
                        },
                        new State {
                            StateName = "QUEUE_INSPECTION_2"
                        },
                        new State {
                            StateName = "INSPECTION_2"
                        },
                        new State {
                            StateName = "INSPECTION_2_REWORK"
                        },
                        new State {
                            StateName = "INSPECTION_2_SCRAP"
                        },
                        new State {
                            StateName = "QUEUE_ASSEMBLY"
                        },
                        new State {
                            StateName = "ASSEMBLY"
                        },
                        new State {
                            StateName = "QUEUE_INSPECTION_3"
                        },
                        new State {
                            StateName = "INSPECTION_3"
                        },
                        new State {
                            StateName = "INSPECTION_3_REWORK"
                        },
                        new State {
                            StateName = "INSPECTION_3_SCRAP"
                        },
                        new State {
                            StateName = "PACKAGE"
                        },
                    };
                    context.States.AddRange(states);
                    #endregion
                    #region product
                    context.Products.Add(new Product {
                        ProductId = 1, Description = "Original Sleeper"
                    });
                    context.Products.Add(new Product {
                        ProductId = 2, Description = "Black Beauty"
                    });
                    context.Products.Add(new Product {
                        ProductId = 3, Description = "Firecracker"
                    });
                    context.Products.Add(new Product {
                        ProductId = 4, Description = "Lemon Yellow"
                    });
                    context.Products.Add(new Product {
                        ProductId = 5, Description = "Midnight Blue"
                    });
                    context.Products.Add(new Product {
                        ProductId = 6, Description = "Screaming Orange"
                    });
                    context.Products.Add(new Product {
                        ProductId = 7, Description = "Gold glitter"
                    });
                    context.Products.Add(new Product {
                        ProductId = 8, Description = "White Lightening"
                    });
                    #endregion
                    context.SaveChanges();
                }
                Console.WriteLine("Data base is created!");
            }
        }