public void InsertOrUpdate(RequestInfo requestInfo, bool isInsert) { if (isInsert) //TODO: try. { _databaseContext.RequestsInfo.Add(requestInfo); } else { _databaseContext.Entry(requestInfo).State = System.Data.Entity.EntityState.Modified; } }
//Добавление строки о новом пользователе в таблицу RequestsInfo. public ActionResult CreateRequest() { //Поиск id для текущего пользователя. string userId = System.Web.HttpContext.Current.User.Identity.GetUserId(); //Old option with SQLite context. //SQLiteContext context = new SQLiteContext(); //string sqlInsert = string.Format( // @"INSERT INTO RequestsInfo(UserId, amountOfQueries, registerDateTime, lastLoginDateTime) VALUES ('{0}', {1}, '{2}', '{3}');" // , userId, 0, DateTime.Now.ToString(CultureInfo.InvariantCulture), DateTime.Now.ToString(CultureInfo.InvariantCulture)); //context.ExecuteQuery(sqlInsert); //Option with DAL layer. DALContext _context = new DALContext(); RequestInfo _requestInfo = new RequestInfo() {UserId = userId, AmountOfQueries = 0 , LastLoginDateTime = DateTime.Now.ToString(CultureInfo.InvariantCulture) , RegisterDateTime = DateTime.Now.ToString(CultureInfo.InvariantCulture) }; _context.Requests.InsertOrUpdate(_requestInfo, true); _context.Requests.Save(); return RedirectToAction("Index", "Home"); }