Example #1
0
        static void Main(string[] args)
        {
            /*RateLib rate = new RateLib();
             * rate.Currency = "USD";
             * rate.Date = DateTime.Today;
             * rate.Value = 68.9;
             * DateTime date = new DateTime();
             * date = DateTime.Today;
             * Console.WriteLine(date.ToString("dd'/'MM'/'yyyy"));
             * List<RateLib> rates = new List<RateLib>();
             * rates = LibraryRate.getDailyExchange(DateTime.Today);*/

            DBaseContext db = new DBaseContext();

            Console.WriteLine("1");
            try
            {
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            //db.Currency.Add(new Currency("USD", "USD"));
            db.SaveChanges();
            Console.WriteLine("2");
            IEnumerable <Currency> b    = db.Currency;
            List <Currency>        list = b.ToList <Currency>();

            Console.WriteLine("3");
            Console.WriteLine(list.Count);
            Console.WriteLine(list[0].IdCurrency);
            Console.WriteLine("4");
            Console.ReadKey();
        }
Example #2
0
        public string Hello(string log_pass_enc)
        {
            Person user = new Person();

            byte[] data    = Convert.FromBase64String(log_pass_enc);
            byte[] results = Decryption(data);
            user = Deserialize(results);


            var person = context.People
                         .Where(s => s.Login == user.Login && s.Password == user.Password).Select(s => new { s.Name, s.Login, s.Password, s.PersonId, s.Status }).ToList();

            if (person.Count != 0)
            {
                user.PersonId = person[0].PersonId;
                user.Name     = person[0].Name;
                user.Login    = person[0].Login;
                user.Password = person[0].Password;
                user.Status   = person[0].Status;

                // ActionId=0 =>вход
                Models.Action action = new Models.Action();
                int           peron  = context.Actions
                                       .Select(s => new { s.idAction, s.ActionId, s.ActionDescription, s.Date, s.PersonId }).ToList().Count;
                action.idAction          = peron + 1;
                action.ActionId          = 0;
                action.ActionDescription = "Пользователь " + user.Login + " вошёл в систему";
                action.Date     = DateTime.Now;
                action.PersonId = user.PersonId;
                Global.pers     = user;
                context.Actions.Add(action);
                context.SaveChanges();

                return(Encryption(Serialize(user)));
            }
            else
            {
                return("access_denied");
            }
        }