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