예제 #1
0
        public List <yashaddi> asaletTasdiki()
        {
            List <yashaddi> il = null;

            try
            {
                personelHelper helper = new personelHelper();

                var reader = helper.GetData("SET language turkish select adSoyad,  day(kurumaBaslamaTarihi),DATENAME( Month,(dbo.sicil.kurumaBaslamaTarihi+180)) as month from sicil where getdate()-(kurumaBaslamaTarihi)<180 and getdate()-(kurumaBaslamaTarihi)>165");
                if (reader.HasRows)
                {
                    il = new List <yashaddi>();
                    while (reader.Read())
                    {
                        yashaddi se = new Model.yashaddi();
                        se.adSoyad = reader[0].ToString();
                        se.gun     = Convert.ToInt32(reader[1]);
                        se.ay      = reader[2].ToString();


                        il.Add(se);
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }

            return(il);
        }
예제 #2
0
        public List <yashaddi> yashaddi()
        {
            List <yashaddi> il = null;

            try
            {
                personelHelper helper = new personelHelper();

                var reader = helper.GetData("SET language turkish select adSoyad,  day(dogumtarihi-1),DATENAME( Month,(dbo.sicil.dogumTarihi)) as month from sicil where dbo.FN_YAS_HESAPLA1(dogumTarihi,GETDATE())<65 and dbo.FN_YAS_HESAPLA1(dogumTarihi,(GETDATE()-335))>=64");
                if (reader.HasRows)
                {
                    il = new List <yashaddi>();
                    while (reader.Read())
                    {
                        yashaddi se = new Model.yashaddi();
                        se.adSoyad = reader[0].ToString();
                        se.gun     = Convert.ToInt32(reader[1]);
                        se.ay      = reader[2].ToString();


                        il.Add(se);
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }

            return(il);
        }