Esempio n. 1
0
        protected override void Seed(TCRContext context)
        {
            base.Seed(context);

            //if (System.Diagnostics.Debugger.IsAttached == false) // Для отладки / for debugging
            //    System.Diagnostics.Debugger.Launch();

            context.Receptors.RemoveRange(context.Receptors);
            context.People.RemoveRange(context.People);
            context.VSegments.RemoveRange(context.VSegments);
            context.DSegments.RemoveRange(context.DSegments);
            context.JSegments.RemoveRange(context.JSegments);
            context.SaveChanges();

            context.Configuration.AutoDetectChangesEnabled = false;

            FillVSegments(context);
            FillDSegments(context);
            FillJSegments(context);

            string[] files = Directory.GetFiles(ConfigurationManager.AppSettings["InitDataPath"], "*.tcr");
            for (int i = 0; i < files.Length; ++i)
            {
                string name   = "Person" + (i + 1).ToString();
                Person person = new Person {
                    FirstName = name, MiddleName = name, LastName = name
                };
                context.People.Add(person);
                context.SaveChanges();

                FileStream   fileStream = new FileStream(files[i], FileMode.Open);
                StreamReader reader     = new StreamReader(fileStream);
                string       curStr     = null;
                reader.ReadLine(); // Пропускаем названия столбцов/ Shifting columns' names

                while ((curStr = reader.ReadLine()) != null)
                {
                    string[] fields    = curStr.Split('\t');
                    string   nucleoSeq = fields[2];
                    Receptor receptor  = context.Receptors.FirstOrDefault(r => r.NucleoSequence == nucleoSeq);
                    if (receptor == null)
                    {
                        receptor = new Receptor
                        {
                            NucleoSequence  = fields[2],
                            AminoSequence   = fields[3],
                            LastVNucleoPos  = Convert.ToInt32(fields[7]),
                            FirstDNucleoPos = Convert.ToInt32(fields[8]),
                            LastDNucleoPos  = Convert.ToInt32(fields[9]),
                            FirstJNucleoPos = Convert.ToInt32(fields[10]),
                            VDInsertions    = Convert.ToInt32(fields[11]),
                            DJInsertions    = Convert.ToInt32(fields[12]),
                            TotalInsertions = Convert.ToInt32(fields[13])
                        };

                        FillSegments(context, fields, receptor);
                        context.Receptors.Add(receptor);
                        context.SaveChanges();
                    }

                    context.PersonalReceptors.Add(new PersonalReceptor
                    {
                        ReadCount  = Convert.ToInt32(fields[0]),
                        Percentage = Convert.ToDouble(fields[1], new NumberFormatInfo()
                        {
                            NumberDecimalSeparator = "."
                        }),
                        Receptor = receptor,
                        Person   = person
                    });
                    context.SaveChanges();
                }
            }
        }
Esempio n. 2
0
 private static void FillSegments(TCR.Models.TCRContext context, string[] fields, Receptor receptor)
 {
     string[] alleles = fields[4].Split(new string[] { ", " }, StringSplitOptions.RemoveEmptyEntries);
     foreach (string allele in alleles)
     {
         VSegment segment = context.VSegments.First(s => s.Alleles == allele);
         receptor.VSegments.Add(segment);
     }
     alleles = fields[6].Split(new string[] { ", " }, StringSplitOptions.RemoveEmptyEntries);
     foreach (string allele in alleles)
     {
         DSegment segment = context.DSegments.First(s => s.Alleles == allele);
         receptor.DSegments.Add(segment);
     }
     alleles = fields[5].Split(new string[] { ", " }, StringSplitOptions.RemoveEmptyEntries);
     foreach (string allele in alleles)
     {
         JSegment segment = context.JSegments.First(s => s.Alleles == allele);
         receptor.JSegments.Add(segment);
     }
 }