public static void TCMBDovizKuruAl() { db.ExchangeRateDatas.RemoveRange(db.ExchangeRateDatas.ToList()); string today = "http://www.tcmb.gov.tr/kurlar/today.xml"; var xmlDoc = new XmlDocument(); xmlDoc.Load(today); ExchangeRateData rateData = new ExchangeRateData(); rateData.Buying = Convert.ToDouble(xmlDoc.SelectSingleNode("Tarih_Date/Currency[@Kod='USD']/BanknoteBuying").InnerXml); rateData.Selling = Convert.ToDouble(xmlDoc.SelectSingleNode("Tarih_Date/Currency[@Kod='USD']/BanknoteSelling").InnerXml); rateData.CurrencyCode = "USD/TRY"; rateData.Currency = new Currency(); rateData.Currency.Unit = 1; rateData.CurrencyName = xmlDoc.SelectSingleNode("Tarih_Date/Currency[@Kod='USD']/CurrencyName").InnerXml; // rateData.CurrencyId = db.Currency.Find(1).Id; rateData.CreatedDate = DateTime.Now; db.ExchangeRateDatas.Add(rateData); db.SaveChanges(); ExchangeRateData rateData1 = new ExchangeRateData(); rateData1.Buying = Convert.ToDouble(xmlDoc.SelectSingleNode("Tarih_Date/Currency[@Kod='EUR']/BanknoteBuying").InnerXml); rateData1.Selling = Convert.ToDouble(xmlDoc.SelectSingleNode("Tarih_Date/Currency[@Kod='EUR']/BanknoteSelling").InnerXml); rateData.Currency = new Currency(); rateData.Currency.Unit = 1; rateData1.CurrencyCode = "EUR/TRY"; rateData1.CurrencyName = xmlDoc.SelectSingleNode("Tarih_Date/Currency[@Kod='EUR']/CurrencyName").InnerXml; rateData1.CreatedDate = DateTime.Now; db.ExchangeRateDatas.Add(rateData1); db.SaveChanges(); }
public ActionResult Create(Rate rate) { if (ModelState.IsValid) { manager.Rates.Add(rate); manager.SaveChanges(); return(RedirectToAction("Index")); } return(RedirectToAction("Index")); }
public ActionResult Create(QuizChoice quizChoice) { if (ModelState.IsValid) { manager.QuizChoices.Add(quizChoice); manager.SaveChanges(); return(RedirectToAction("Index")); } return(RedirectToAction("Index")); }
public ActionResult Create(User user) { if (ModelState.IsValid) { manager.Users.Add(user); manager.SaveChanges(); return(RedirectToAction("Index")); } return(RedirectToAction("Index")); }
public ActionResult Create(Friend friends) { if (ModelState.IsValid) { manager.Friends.Add(friends); manager.SaveChanges(); return(RedirectToAction("Index")); } return(RedirectToAction("Index")); }
public ActionResult Create(Answer answer) { try { if (ModelState.IsValid) { manager.Answers.Add(answer); manager.SaveChanges(); return(RedirectToAction("Index")); } return(RedirectToAction("Index")); } catch { return(RedirectToAction("Index")); } }
public ActionResult SaveRate(float _CurrentRate, DateTime _RateDate) { db.Rates.Add(new Rate { RateDate = _RateDate, CurrentRate = _CurrentRate }); db.SaveChanges(); return(Json(new { DateTime.Now })); }
public ActionResult Register(RegisterModel model) { if (ModelState.IsValid) { User user = null; using (RateContext db = new RateContext()) { user = db.Users.FirstOrDefault(u => u.Email == model.Email); } if (user == null) { // создаем нового пользователя using (RateContext db = new RateContext()) { db.Users.Add(new User { Email = model.Email, Password = model.Password, LastName = model.LastName, FirstName = model.FirstName }); db.SaveChanges(); user = db.Users.Where(u => u.Email == model.Email && u.Password == model.Password).FirstOrDefault(); } // если пользователь удачно добавлен в бд if (user != null) { FormsAuthentication.SetAuthCookie(model.Email, true); return(RedirectToAction("Index", "Home")); } } else { ModelState.AddModelError("", "Пользователь с таким логином уже существует"); } } return(View(model)); }
static void Main(string[] args) { XmlDocument xDoc = new XmlDocument(); xDoc.Load("http://www.cbr.ru/scripts/XML_daily.asp"); XmlElement xRoot = xDoc.DocumentElement; XmlNode xNode = xRoot.SelectSingleNode("//Valute[@ID='R01239']/Value"); using (RateContext db = new RateContext()) { db.RateClasses.Add(new RateClass { Currency = "EUR", Date = DateTime.Now, Rate = Convert.ToDouble(xNode.InnerText) }); db.SaveChanges(); Console.WriteLine("Объект успешно сохранен"); var rates = db.RateClasses; Console.WriteLine("Список объектов:"); foreach (RateClass u in rates) { Console.WriteLine("{0}.{2} - {3}, {1}", u.Id, u.Date, u.Currency, u.Rate); } } Console.ReadKey(); }