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(); }
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"); } }