namespace Weee.Migrations
{
    using CScommon;
    using Microsoft.AspNet.Identity;
    using Microsoft.AspNet.Identity.EntityFramework;
    using System;
    using System.Collections.Generic;
    using System.Data.Entity.Migrations;
    using System.Linq;
    using System.Web;
    using Weee.DAL;
    using Weee.Models;
    using Weee.Models.Paramemter;
    internal sealed class Configuration : DbMigrationsConfiguration<Weee.DAL.WeeeDataContext>
    {
        public Configuration()
        {
            AutomaticMigrationsEnabled = true;// true;
            AutomaticMigrationDataLossAllowed = true;
            ContextKey = "Weee.DAL.WeeeDataContext";
        }

        protected override void Seed(WeeeDataContext context)
        {

            context.AssessmentReportVersion.AddOrUpdate(x => x.ARversionGuid,
                new AssessmentReportVersion()
                {
                    ARversionGuid = new Guid("47A4251D-875B-4B99-AA32-B7C206E6873F"),
                    ARversion = "AR4",
                    createTime = new DateTime(2022, 12, 22),
                    createBy = "admin"
                }, new AssessmentReportVersion()
                {
                    ARversionGuid = new Guid("5191B6FB-F39F-4FAD-B746-007366744EB3"),
                    ARversion = "AR5",
                    createTime = new DateTime(2022, 12, 22),
                    createBy = "admin"
                }, new AssessmentReportVersion()
                {
                    ARversionGuid = new Guid("64B200BA-4D85-4232-BD25-2DC9FA721D34"),
                    ARversion = "AR6",
                    createTime = new DateTime(2022, 12, 22),
                    createBy = "admin"
                });
            using (var UserStore = new UserStore<User>(context))
            using (var RoleStore = new RoleStore<IdentityRole>(context))
            using (var UserManager = new UserManager<User>(UserStore))
            using (var RoleManager = new RoleManager<IdentityRole>(RoleStore))
            {

                if (context.Users.Count() == 0 && context.Parameters.Count() == 0)// run following seed only if the database is totally new
                {
                    #region seed admin and role

                    if (!RoleManager.RoleExists(ProgramConstants.admin))
                    {
                        var roleresult = RoleManager.Create(new IdentityRole(ProgramConstants.admin));
                    }
                    if (!RoleManager.RoleExists(ProgramConstants.normalcompany))
                    {
                        RoleManager.Create(new IdentityRole(ProgramConstants.normalcompany));
                    }

                    if (!RoleManager.RoleExists(ProgramConstants.certification))
                    {
                        RoleManager.Create(new IdentityRole(ProgramConstants.certification));
                    }
                    var u = new User()
                    {
                        Name = "admin",
                        Email = "haha@ha.haha",
                        IsSystemAdmin = true
                    };
                    u.UserName = ProgramConstants.admin;
                    var adminresult = UserManager.Create(u, ProgramConstants.DefaultPassword);

                    if (adminresult.Succeeded)
                    {
                        var result = UserManager.AddToRole(u.Id, ProgramConstants.admin);
                    }
                    #endregion
                    #region initial parameter

                    CreateYearlyParameter(context, Categories.Electric, "electric.csv");
                    CreateYearlyParameter(context, Categories.ElectricOrganization, "electric.csv");
                    CreateYearlyParameter(context, Categories.Water, "water.csv");
                    CreateYearlyParameter(context, Categories.Vehicle, "Vehicle.csv");
                    //CreateYearlyParameter(context, Categories.VehicleOrganization, "Vehicle.csv");
                    CreateYearlyParameter(context, Categories.GasolineEquipment, "GasolineEquipment.csv");
                    CreateYearlyParameter(context, Categories.Kitchen, "Kitchen.csv");
                    CreateYearlyParameter(context, Categories.Steam, "Steam.csv");
                    CreateYearlyParameter(context, Categories.SteamOrganization, "Steam.csv");

                    CreateNonYearlyParameter(context, Categories.FireEquipment, "FireEquipment.csv");
                    CreateNonYearlyParameter(context, Categories.Septic, "Septic.csv");
                    CreateNonYearlyParameter(context, Categories.OtherCompound, "OtherCompound.csv");
                    CreateNonYearlyParameter(context, Categories.RefrigerantGWP, "RefrigerantGWP.csv");
                    CreateNonYearlyParameter(context, Categories.Refrigerant, "Refrigerant.csv");
                    CreateNonYearlyParameter(context, Categories.Waste, "waste.csv");
                    #endregion
                    #region seed pcr
                    //for (var i = 0; i < 10; i++)
                    //{
                    //    var temp = new PCR()
                    //    {
                    //        DisplayNameTW = "hello",
                    //        Percentage = ((decimal)rnd.Next(0, 1000)) / 10
                    //    };
                    //    var ids = context.SimaproParameters.Select(x => x.ID).ToList();
                    //    var count = ids.Count();
                    //    var numbers = ids.OrderBy(x => rnd.Next()).Take(5).ToList();

                    //    foreach (var number in numbers)
                    //    {
                    //        temp.SimaproPCRs.Add(new SimaproPCR() { Parameter = context.SimaproParameters.First(x => x.ID == number) });
                    //    }
                    //    context.PCRs.Add(temp);
                    //}
                    //context.SaveChanges();
                    #endregion
                    
                    RandomSeedComapny(context);
                    context.SaveChanges();
                }

                //seed from transport csv because it is null
                if (context.NonYearlyParameterCategories.Where(x => x.Category == Categories.Transport).SingleOrDefault() == null)
                {
                    CreateNonYearlyParameter(context, Categories.Transport, "Transport.csv");
                    context.SaveChanges();
                }

                if (context.NonYearlyParameterCategories.Where(x => x.Category == Categories.WasteWater).SingleOrDefault() == null)
                {
                    CreateNonYearlyParameter(context, Categories.WasteWater, "WasteWater.csv");
                    context.SaveChanges();
                }

                if (!context.LCARiskAssmtSurveyForm_LifecycleAssmtItems.Any())
                {
                    CreateLifecycleAssmtItem(context, "LifecycleAssmtItem.csv");
                    context.SaveChanges();
                }
            }

            base.Seed(context);
        }


        #region private function
        private static void CreateYearlyParameter(WeeeDataContext context, Categories cate, string filename)
        {
            using (var file = new System.IO.StreamReader(HttpContext.Current.Server.MapPath("~/App_Data/" + filename)))
            {
                var ElectricBuilder = new YearlyParameterBuilder(cate);
                var typeTwNames = file.ReadLine().Split(',').ToList();
                var typeCnNames = file.ReadLine().Split(',').ToList();
                var typeEnNames = file.ReadLine().Split(',').ToList();
                var areaTwNames = file.ReadLine().Split(',').ToList();
                var areaCnNames = file.ReadLine().Split(',').ToList();
                var areaEnNames = file.ReadLine().Split(',').ToList();
                string line;
                var parameters = new Dictionary<int, IEnumerable<decimal?>>();
                int baseyear = 2006;
                while ((line = file.ReadLine()) != null)
                {
                    var row = line.Split(',').ToList();
                    var decimalrow = new List<decimal?>();
                    foreach (var item in row)
                    {
                        decimal parsed;
                        if (decimal.TryParse(item, out parsed))
                            decimalrow.Add(parsed);
                        else
                            decimalrow.Add(null);
                    }
                    parameters.Add(baseyear, decimalrow);
                    baseyear++;
                }
                var buildresult = ElectricBuilder
                    .BuildTypes(typeTwNames, typeCnNames, typeEnNames)
                    .BuildAreas(areaTwNames, areaCnNames, areaEnNames)
                    .BuildParameters(parameters)
                    .GetResults();
                context.YearlyParameterCategories.Add(buildresult);
            }
        }
        private static void CreateNonYearlyParameter(WeeeDataContext context, Categories cate, string filename)
        {
            using (var file = new System.IO.StreamReader(HttpContext.Current.Server.MapPath("~/App_Data/" + filename)))
            {
                var Builder = new NonYearlyParameterBuilder(cate);
                string line;
                var dataset = new List<List<string>>();
                while ((line = file.ReadLine()) != null)
                {
                    var toadd = line.Split(',').ToList();
                    if (toadd.Count == 4) dataset.Add(toadd);
                }

                var typeTwNames = dataset.Select(x => x[0]).ToList();
                var typeCnNames = dataset.Select(x => x[1]).ToList();
                var typeEnNames = dataset.Select(x => x[2]).ToList();
                var parameters = dataset.Select(x => x[3]).ToList();
                //extra handle for waste ,waste water, and transport , replace '_' to ','
                if (cate == Categories.Waste || cate == Categories.WasteWater || cate == Categories.Transport)
                {
                    for (int i = 0; i < typeTwNames.Count; i++)
                    {
                        typeTwNames[i] = typeTwNames[i].Replace('_', ',');
                        typeCnNames[i] = typeCnNames[i].Replace('_', ',');
                        typeEnNames[i] = typeEnNames[i].Replace('_', ',');
                    }
                }

                var decimalrow = new List<decimal>();
                foreach (var item in parameters)
                {
                    decimal parsed;
                    if (decimal.TryParse(item, out parsed))
                        decimalrow.Add(parsed);
                }
                var result = Builder
                    .BuildTypes(typeTwNames, typeCnNames, typeEnNames)
                    .BuildParameters(decimalrow)
                    .GetResults();
                context.NonYearlyParameterCategories.Add(result);
            }
        }
        //remove this when go online
        private void RandomSeedComapny(WeeeDataContext context)
        {
            Random rnd = new Random();
            var UserManager = new UserManager<User>(new UserStore<User>(context));
            var NormalCompanyNumber = 1;// rnd.Next(5, 10);
            for (int i = 0; i < NormalCompanyNumber; i++)
            {
                var company = new NormalCompany()
                {
                    Name = "company " + i,
                    Address = "Taipei" + i,
                    Description = "Hello" + i,
                    VATNumber = "ccccVAT" + i,
                    CEOName = "a ceo" + i,
                    EnglishName= "company " + i,
                    NumberOfEmployees=1
                };
                var UserNumber = rnd.Next(1, 3);
                for (int j = 0; j < UserNumber; j++)// 建立一般測試使用者
                {
                    var u = new User() { UserName = "tester" + i.ToString() + j.ToString(), Name = "normal tester" + rnd.Next(0, 1000).ToString()
                        , Email = "haha@ha.haha", IsCompanyAdmin = j == 0 };

                    UserManager.Create(u, ProgramConstants.DefaultPassword);
                    company.Users.Add(u);
                    var uat = new UserAccountType() { UserId=u.Id, AccountType=ACCOUNT_TYPE.FULL_FUNCTION, StartTime=DateTime.Now, EndTime=DateTime.Now.AddYears(2)
                        , Enabled=true };
                    context.UserAccountType.Add(uat);
                }
                var FabNumber = rnd.Next(9, 12);
                for (int j = 0; j < FabNumber; j++)
                {
                    var f = new Fab() { Name = " 工廠 " + j, Phone = "1234", Address = "haha", IsIso14064Passed = rnd.Next(0, 1) == 0 };
                    company.Fabs.Add(f);
                }
                var ProdNumber = rnd.Next(5, 8);
                for (int j = 0; j < ProdNumber; j++)
                {
                    var p = new Product() { Name = " 產品 " + j, SpecDescription = "haha", Weight = rnd.Next(5, 10), FunctionalUnit="kg" };
                    company.Products.Add(p);
                }
                context.Companies.Add(company);
            }

            var CerificateCompanyNumber = 1;// rnd.Next(2, 4);
            for (int i = 0; i < CerificateCompanyNumber; i++)
            {
                var company = new CertificationCompany()
                {
                    Name = "其他查證單位" + i,
                    Address = "Taipei" + i,
                    Description = "Hello" + i,
                    VATNumber = "ccccVAT" + i,
                    CEOName = "a ceo" + i,
                    EnglishName = "其他查證單位 " + i,
                    NumberOfEmployees = 1

                };
                var UserNumber = rnd.Next(1, 3);
                for (int j = 0; j < UserNumber; j++)// 建立查證測試使用者
                {
                    var u = new User() { UserName = "testerc" + i.ToString() + j.ToString(), Name = "certi tester" + rnd.Next(0, 1000).ToString(), Email = "haha@ha.haha" };

                    UserManager.Create(u, ProgramConstants.DefaultPassword);
                    company.Users.Add(u);
                }
                context.Companies.Add(company);
            }
            //valid company1.Fabs.Add(new Fab() { Name = "test company1 fab", Phone = "1234", Address = "haha", IsIso14064Passed = false });
            //invalid company1.Fabs = new List<Fab>();
        }
        private List<SimaproParameterCategory> SimapeoParameterSeeds()
        {
            var returnvalue = new List<SimaproParameterCategory>()
            {
                new SimaproParameterCategory()
                {
                    DisplayNameTW = "TestingSheet",
                    SubTypes = new List<SimaproParameterType>()
                    {
                        new SimaproParameterType()
                        {
                            DisplayNameTW = "SubType1"
                        },
                        new SimaproParameterType()
                        {
                            DisplayNameTW = "SubType2"
                        }
                    },
                    SimaproVersion = new SimaproVersion()
                    {
                        Version = "v0.1"
                    }
                },
                new SimaproParameterCategory()
                {
                    DisplayNameTW = "TestingSheet2",
                    SubTypes = new List<SimaproParameterType>()
                    {
                        new SimaproParameterType()
                        {
                            DisplayNameTW = "SubType3"
                        },
                        new SimaproParameterType()
                        {
                            DisplayNameTW = "SubType4"
                        },
                        new SimaproParameterType()
                        {
                            DisplayNameTW = "SubType5"
                        },
                        new SimaproParameterType()
                        {
                            DisplayNameTW = "SubType6"
                        }
                    },
                    SimaproVersion = new SimaproVersion()
                    {
                        Version = "v0.2"
                    }
                }
            };
            return returnvalue;
        }
        //seed 來源:Unlock_psd-003-04001 工作表2
        //    化糞池: 總工時 sheet
        private List<YearlyParameterCategory> YearlyParamemterSeeds()
        {
            var returnvalue = new List<YearlyParameterCategory>
            {
                new YearlyParameterCategory(Categories.Electric)
                {
                    Areas=new List<YearlyParameterArea>
                    {
                        new YearlyParameterArea("台灣"),
                        new YearlyParameterArea("華北地區"),
                        new YearlyParameterArea("東北地區"),
                        new YearlyParameterArea("華東地區"),
                        new YearlyParameterArea("華中地區"),
                        new YearlyParameterArea("南方地區")
                    },
                    Types = new List<YearlyParameterType>
                    {
                        new YearlyParameterType("Default")
                    }
                },new YearlyParameterCategory(Categories.ElectricOrganization)
                {
                    Areas=new List<YearlyParameterArea>
                    {
                        new YearlyParameterArea("台灣"),
                        new YearlyParameterArea("華北地區"),
                        new YearlyParameterArea("東北地區"),
                        new YearlyParameterArea("華東地區"),
                        new YearlyParameterArea("華中地區"),
                        new YearlyParameterArea("南方地區")
                    },
                    Types = new List<YearlyParameterType>
                    {
                        new YearlyParameterType("Default")
                    }
                },
                new YearlyParameterCategory(Categories.Water)
                {
                    Areas = new List<YearlyParameterArea>
                    {
                        new YearlyParameterArea("台灣"),
                        new YearlyParameterArea("大陸")
                    },
                    Types = new List<YearlyParameterType>
                    {
                        new YearlyParameterType("Default")
                    }
                },
                //new YearlyParameterCategory(Categories.VehicleOrganization)
                //{
                //     Areas = new List<YearlyParameterArea>
                //    {
                //        new YearlyParameterArea("台灣"),
                //        new YearlyParameterArea("大陸")
                //    },
                //    Types = new List<YearlyParameterType>
                //    {
                //        new YearlyParameterType("移動源汽油"),
                //        new YearlyParameterType("移動源柴油")
                //    }
                //}
                //,
                new YearlyParameterCategory(Categories.Vehicle)
                {
                    Areas = new List<YearlyParameterArea>
                    {
                        new YearlyParameterArea("台灣"),
                        new YearlyParameterArea("大陸")
                    },
                    Types = new List<YearlyParameterType>
                    {
                        new YearlyParameterType("移動源汽油"),
                        new YearlyParameterType("移動源柴油")
                    }
                },
                new YearlyParameterCategory(Categories.GasolineEquipment)
                {
                    Areas = new List<YearlyParameterArea>
                    {
                        new YearlyParameterArea("台灣"),
                        new YearlyParameterArea("大陸")
                    },
                    Types = new List<YearlyParameterType>
                    {
                        new YearlyParameterType("固定源柴油"),
                        new YearlyParameterType("移動源柴油")
                    }
                },
                new YearlyParameterCategory(Categories.Kitchen)
                {
                    Areas = new List<YearlyParameterArea>
                    {
                        new YearlyParameterArea("台灣"),
                        new YearlyParameterArea("大陸")
                    },
                    Types = new List<YearlyParameterType>
                    {
                        new YearlyParameterType("無煤煙"),
                        new YearlyParameterType("天然氣"),
                        new YearlyParameterType("液化石油氣"),
                        new YearlyParameterType("固定源汽油"),
                        new YearlyParameterType("重油")
                    }
                },new YearlyParameterCategory(Categories.SteamOrganization)
                {
                    Areas = new List<YearlyParameterArea>
                    {
                        new YearlyParameterArea("台灣"),
                        new YearlyParameterArea("大陸")
                    },
                    Types = new List<YearlyParameterType>
                    {
                        new YearlyParameterType("Default")
                    }
                },
                new YearlyParameterCategory(Categories.Steam)
                {
                    Areas = new List<YearlyParameterArea>
                    {
                        new YearlyParameterArea("台灣"),
                        new YearlyParameterArea("大陸")
                    },
                    Types = new List<YearlyParameterType>
                    {
                        new YearlyParameterType("Default")
                    }
                }
            };
            return returnvalue;
        }
        private List<NonYearlyParameterCategory> NonYearlyParameterSeeds()
        {
            var Types = new List<NonYearlyParameterCategory>
            {
                new NonYearlyParameterCategory(Categories.Refrigerant)
                {
                    Types = new List<NonYearlyParameterType>
                    {
                        new NonYearlyParameterType("家用冰箱",0.003m),
                        new NonYearlyParameterType("飲水機",0.003m),
                        new NonYearlyParameterType("除濕機",0.003m),
                        new NonYearlyParameterType("餐廳冷藏櫃",0.08m),
                        new NonYearlyParameterType("恆溫除濕機",0.08m),
                        new NonYearlyParameterType("冰水主機",0.085m),
                        new NonYearlyParameterType("分離式主機",0.055m),
                        new NonYearlyParameterType("公務車",0.15m),
                        new NonYearlyParameterType("家用冷凍冷藏設備",0.003m),
                        new NonYearlyParameterType("獨立商用冷凍冷藏設備",0.08m)
                    }
                },
                new NonYearlyParameterCategory(Categories.FireEquipment)
                {
                    Types=new List<NonYearlyParameterType>
                    {
                        new NonYearlyParameterType("CO2",1m),
                        new NonYearlyParameterType("FM-200",3220m),
                        new NonYearlyParameterType("Halon1211",1890m),
                        new NonYearlyParameterType("Halon1301",7140m),
                        new NonYearlyParameterType("Halon2402",1640m)
                    }
                },
                new NonYearlyParameterCategory(Categories.OtherCompound)
                {
                    Types=new List<NonYearlyParameterType>
                    {
                        new NonYearlyParameterType("Carbon tetrachloride",1400m),
                        new NonYearlyParameterType("Methyl bromide",5m),
                        new NonYearlyParameterType("Methyl chloroform",146m),
                        new NonYearlyParameterType("Sulfur hexafluoride",22800m),
                        new NonYearlyParameterType("Nitrogen trifluoride",17200m)
                    }
                },
                new NonYearlyParameterCategory(Categories.RefrigerantGWP)
                {
                    Types=new List<NonYearlyParameterType>
                    {
                        new NonYearlyParameterType("R-11",4750m),
                        new NonYearlyParameterType("R-12",10900m),
                        new NonYearlyParameterType("R-13",14400m),
                        new NonYearlyParameterType("R-113",6130m),
                        new NonYearlyParameterType("R-114",10000m)
                    }
                },
                //此兩個category的parameter 本身就需要binding , 較為特別 , 需重新考慮是否加在此處
                //new NonYearlyParameterCategory("汽柴油密度")
                //{
                //    Parameters=new List<NonYearlyParameter>
                //    {
                //        new NonYearlyParameter("柴油密度",0.84m),
                //        new NonYearlyParameter("汽油密度",0.73m),
                //        new NonYearlyParameter("LPG密度",0.54m)
                //    }
                //},
                new NonYearlyParameterCategory(Categories.Septic)
                {
                    Types=new List<NonYearlyParameterType>
                    {
                        new NonYearlyParameterType("排放因子",0.6m),
                        new NonYearlyParameterType("汙水濃度",200m),
                        new NonYearlyParameterType("每人每天汙水量",125m),
                        new NonYearlyParameterType("化糞池處理效率",0.85m),
                        new NonYearlyParameterType("單位換算",0.000001m),
                        new NonYearlyParameterType("GWP",25m)
                    }
                },
                new NonYearlyParameterCategory(Categories.Transport)
                {
                    Types=new List<NonYearlyParameterType>
                    {
                        new NonYearlyParameterType("air,aircraft, freight/RER S",0.6m),
                        new NonYearlyParameterType("air,aircraft, freight, intercontinental/RER S",200m),
                        new NonYearlyParameterType("sea,transoceanic freight ship/OCE S",125m),
                        new NonYearlyParameterType("sea,barge tanker/RER S",125m),
                        new NonYearlyParameterType("road,lorry 3.5-7.5t, EURO5/RER S",0.85m),
                        new NonYearlyParameterType("road,lorry 7.5-16t, EURO5/RER S",0.85m)
                    }
                }
            };
            return Types;
        }
        private static void CreateLifecycleAssmtItem(WeeeDataContext context, string filename)
        {
            if (HttpContext.Current == null)
            {
                return;
            }

            using (var file = new System.IO.StreamReader(HttpContext.Current.Server.MapPath("~/App_Data/" + filename)))
            {
                string line;
                while ((line = file.ReadLine()) != null)
                {
                    var array = line.Split(',').ToList();
                    var item = new LCARiskAssmtSurveyForm_LifecycleAssmtItem() 
                    { 
                        LifeCycleStage = int.Parse(array[0]),
                        DisplayNameTW = array[1],
                        DisplayNameCN = array[2],
                        DisplayNameEN = array[3]
                    };

                    context.LCARiskAssmtSurveyForm_LifecycleAssmtItems.Add(item);
                }
            }
        }
        private enum unitsfortest
        {
            kg,
            m2,
            cm3,
            p,
            m
        }
        #endregion
    }
}