From : Valerian Khvichia <VKhvichia@hssp.org.ge>
To : Batiashvili Zurab <zbatiashvili@moh.gov.ge>
Subject : RE: sakoveltaos fazebi
Received On : 10.06.2014 13:54

#region Private Insurance Logic

 

                                var populations = (from n in db.PopulationALLs

                                                   where n.Phase == 2 && n.PersonID == personalID

                                                   select n).ToList();

                                if (populations.Count != 0)

                                {

                                    var population = (from n in populations

                                                      where n.DateDeleted == null

                                                      select n).ToList();

 

                                    if (population.Count == 0)

                                    {

                                        population = (from n in populations

                                                      where n.DateDeleted != null

                                                      orderby n.DateDeleted descending

                                                      select n).ToList();

                                    }

 

                                    var populationItem = population.FirstOrDefault();

 

                                    // ReSharper disable PossibleNullReferenceException

                                    result.InsuranceStartDate = populationItem.StartDate;

                                    result.InsuranceEndDate = populationItem.EndDate;

                                    result.InsuranceCompany = populationItem.OrganizationList.Name;

                                    // ReSharper restore PossibleNullReferenceException

 

                                    if (populationItem.DateDeleted != null)

                                    {

                                       var reasonItems = population.Select(p => p.Reason).Distinct().ToList();

                                        if (reasonItems.Any(r => r.Code == 3) && reasonItems.All(r => r.Code != 4))

                                        {

                                            result.Phase = BudgetHierarchyItemAttributeEnums.MinimalPackage;

                                        }

                                        if (reasonItems.Count == 2 && reasonItems.Any(r => r.Code == 1) &&

                                            reasonItems.Any(r => r.Code == 5))

                                        {

                                            result.Phase = BudgetHierarchyItemAttributeEnums.BasePackage;

                                        }

                                        if (result.IsVeteran && reasonItems.Any(r => r.Code == 4))

                                        {

                                            result.Phase = BudgetHierarchyItemAttributeEnums.BasePackage;

                                        }

 

                                        if (reasonItems.Count == 1)

                                        {

                                            if (populationItem.Reason != null &&

                                                populationItem.Reason.Code.GetValueOrDefault() == 1)

                                            {

                                                result.Phase = BudgetHierarchyItemAttributeEnums.BasePackage;

                                            }

                                            else if (populationItem.Reason != null &&

                                                     populationItem.Reason.Code.GetValueOrDefault() == 3)

                                            {

                                                result.Phase = BudgetHierarchyItemAttributeEnums.MinimalPackage;

                                            }

                                            else if (populationItem.Reason != null &&

                                                     populationItem.Reason.Code.GetValueOrDefault() == 4)

                                            {

                                                result.Phase = BudgetHierarchyItemAttributeEnums.BasePackage;

                                            }

                                            else if (populationItem.Reason != null &&

                                                     populationItem.Reason.Code.GetValueOrDefault() == 5)

                                            {

                                                result.Phase = BudgetHierarchyItemAttributeEnums.BasePackage;

                                            }

                                        }

 

                                    }

                                }

                                else

                                {

                                    result.Phase = BudgetHierarchyItemAttributeEnums.BasePackage;

                                }

 

                                #endregion

 

From: Batiashvili Zurab [mailto:zbatiashvili@moh.gov.ge]
Sent: Tuesday, June 10, 2014 3:31 PM
To: Valerian Khvichia
Subject: RE: sakoveltaos fazebi

 

Maita kodi

 

 

From: Valerian Khvichia [mailto:VKhvichia@hssp.org.ge]
Sent: Friday, May 30, 2014 11:26
To: Batiashvili Zurab
Subject: RE: sakoveltaos fazebi

 

                                SamedicinoServisiEnum = SamedicinoServisiEnum.SakoveltaoJandacva,

                                SamedicinoServisiGanmarteba = "საყოველთაო ჯანდაცვის პროგრამა",

                                Kategoriebi = new List<SamedicinoSerivisisKategoria>()

                                    {

                                        new SamedicinoSerivisisKategoria()

                                            {

                                                SamedicinoKategoriaEnum = SamedicinoServisisKategoriaEnum.BasePackage, 

                                                SamedicinoKategoria = "საბაზისო",

                                                //TODO დასამატებელი იქნება დამზღვეველი კომპანიის დასახელება

                                                CompanyName =

                                            },

"საყოველთაო ჯანდაცვის პროგრამა"-ის შემთხვევაში უნდა ჩაიწეროს „საყოველთაო ჯანდაცვა“

 

From: Batiashvili Zurab [mailto:zbatiashvili@moh.gov.ge]
Sent: Thursday, May 29, 2014 12:42 PM
To: Valerian Khvichia
Subject: RE: sakoveltaos fazebi

 

ვაკო,

დაახლოებით ასეთი მონაცემების დაბრუნებას ვაპირებ (აქედან ერთი ჩანაწერი მოგივა, გამომდინარე დადგენილებიდან)

 

რა ვიცი, თუ სურვილი გექნებათ, გააინგლისურეთ

 

SamedicinoServisebi = new List<SamedicinoMomsaxurebisServisi>()

                    {

                        new SamedicinoMomsaxurebisServisi()

                            {

                                SamedicinoServisiEnum = SamedicinoServisiEnum.SakoveltaoJandacva,

                                SamedicinoServisiGanmarteba = "საყოველთაო ჯანდაცვის პროგრამა",

                                Kategoriebi = new List<SamedicinoSerivisisKategoria>()

                                    {

                                        new SamedicinoSerivisisKategoria()

                                            {

                                                SamedicinoKategoriaEnum = SamedicinoServisisKategoriaEnum.BasePackage, 

                                                SamedicinoKategoria = "საბაზისო",

                                            },

                                            new SamedicinoSerivisisKategoria()

                                                {

                                                    SamedicinoKategoriaEnum =  SamedicinoServisisKategoriaEnum.MinimalPackage,

                                                    SamedicinoKategoria = "მინიმალური"

                                                },

                                            new SamedicinoSerivisisKategoria()

                                                {

                                                    SamedicinoKategoriaEnum = SamedicinoServisisKategoriaEnum.TargetGroupPackage,

                                                    SamedicinoKategoria = "მიზნობრივი",                                                   

                                                },

 

                                             new SamedicinoSerivisisKategoria()

                                                {

                                                    SamedicinoKategoriaEnum = SamedicinoServisisKategoriaEnum.VeteranPackage,

                                                    SamedicinoKategoria = "ვეტერანები"

                                                },

                                            new SamedicinoSerivisisKategoria()

                                                {

                                                    SamedicinoKategoriaEnum = SamedicinoServisisKategoriaEnum.Asakobrivi,

                                                    SamedicinoKategoria = "ასაკობრივი" // shevcvale N165

                                                },

                                        }

                            },

                            new SamedicinoMomsaxurebisServisi()

                                {

                                    SamedicinoServisiEnum = SamedicinoServisiEnum.SaxelmcifoDazgveva,

                                    SamedicinoServisiGanmarteba = "სახელმწიფო  დაზღვევის პროგრამა",

                                    Kategoriebi = new List<SamedicinoSerivisisKategoria>()

                                        {

                                            new SamedicinoSerivisisKategoria()

                                                {

                                                    SamedicinoKategoriaEnum = SamedicinoServisisKategoriaEnum.N165, // 165-

                                                    SamedicinoKategoria = "დადგენილება 165"

                                                }

                                        }

                                },

                            new SamedicinoMomsaxurebisServisi()

                                {

                                    SamedicinoServisiEnum = SamedicinoServisiEnum.ArEkutvnis,

                                    SamedicinoServisiGanmarteba = "არ ეკუთვნით არანაირი  მომსახურება",

                                    Kategoriebi = new List<SamedicinoSerivisisKategoria>()

                                        {

                                            new SamedicinoSerivisisKategoria()

                                                {

                                                    SamedicinoKategoriaEnum = SamedicinoServisisKategoriaEnum.BiujetitDazgveuli,

                                                    SamedicinoKategoria = "ბიუჯეტით დაზღვეულები"

                                                }

                                        }

                                }

                    };

 

 

From: Valerian Khvichia [mailto:VKhvichia@hssp.org.ge]
Sent: Wednesday, May 28, 2014 10:04
To: Batiashvili Zurab
Subject: RE: sakoveltaos fazebi

 

გაუმარჯოს

 

კი, სწორედ არის მინიშნებული. ოღონდ ეს მთელი კლასი არ არის, ეს არის მხოლოდ იმ კლასის ერთ-ერთი Property.

 

From: Batiashvili Zurab [mailto:zbatiashvili@moh.gov.ge]
Sent: Wednesday, May 28, 2014 7:57 AM
To: Valerian Khvichia
Subject: sakoveltaos fazebi

 

ვაკო გამარჯობა,

 

თქვენი სერვისის ეს მეთოდი

GetPersonInsurancePhaseByDate მიბრუნებს ამ კლასს

 

    public enum BudgetHierarchyItemAttributeEnums : int {      

        public enum BudgetHierarchyItemAttributeEnums : int

        {

            None = 0,   // არ ეკუთვნის

            BasePackage = 1,      // საბაზისო

            MinimalPackage = 2,      // მინიმალური

            TargetGroupPackage = 4,      // მიზნობრივი

            VeteranPackage = 8,        //ვეტერანები

            N165 = 16,  //ასაკობრივი (165- ნაწილი)

        }

 

კომენტარებში ჩემი განმარტებებიმაქვს მიწერილი, იმედია სწორად გავშიფრე J

 

ზურა


Ministry of Labour, Health and Social affairs of Georgia

 


This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system.


Ministry of Labour, Health and Social affairs of Georgia

 


This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system.




This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system.