public ActionResult Create([Bind(Include = "ID,FirstName,LastName,Country")] Author author)
{
if (ModelState.IsValid)
{
db.Authors.Add(author);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(author));
}
public ActionResult Create([Bind(Include = "ID,AuthorID,Content,Source,Category")] Quote quote)
{
if (ModelState.IsValid)
{
db.Quotes.Add(quote);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AuthorID = new SelectList(db.Authors, "ID", "FirstName", quote.AuthorID);
return(View(quote));
}
public IActionResult GetAQuoteInSQL(QuoteViewModel model)
{
var watch = Stopwatch.StartNew();
var Quote = new Quote()
{
FirstName = model.FirstName,
LastName = model.LastName,
Email = model.Email,
PostCode = model.PostCode,
Created = DateTime.Now
};
string quoteNumber = RandomString(8);
Quote.QuoteNumber = quoteNumber;
_context.Quotes.Add(Quote);
_context.SaveChanges();
var firstCompany = (from c in _context.Quotes select c).FirstOrDefault();
var kvp = firstCompany.Id;
watch.Stop();
var elapsedMs = watch.ElapsedMilliseconds;
if (ModelState.IsValid)
{
ViewBag.Message = "Quote number is: " + quoteNumber + " Time taken: " + elapsedMs + "ms";
}
return(View());
}
public ActionResult Register(RegistrationVM user)
{
if (ModelState.IsValid)
{
using (var context = new QuoteContext())
{
//check database for existing username
if (context.ClientLogins.Any(x => x.Username == user.Username))
{
ModelState.AddModelError(string.Empty, "Username already exists");
return(View(user));
}
else
{
var newLogin = new ClientLogin();
newLogin.Username = user.Username;
newLogin.Password = user.Password;
var newClient = new Client();
newClient.ClientLogin = newLogin;
context.Clients.Add(newClient);
context.ClientLogins.Add(newLogin);
context.SaveChanges();
return(Redirect("/Account/Login"));
}
}
}
//Redirect to Login Page if model state valid
return(View());
}
public ActionResult Create(Quote quote)
{
quoteDb.Quotes.Add(quote);
quoteDb.SaveChanges();
//Console.WriteLine("here");
return(RedirectToAction("Index"));
}
public ActionResult Create(Quote quote)
{
ViewBag.error = "";
if (quote.body == null || quote.authorName == null)
{
ViewBag.error = "Please fill all fields on the form";
}
try{
quoteDb.Quotes.Add(quote);
quoteDb.SaveChanges();
return(RedirectToAction("Index"));
}
catch {
return(View());
}
}
/// <summary>
/// Creating database table
/// </summary>
/// <param name="context"></param>
private static void PopulateDatabase(QuoteContext context)
{
var author1 = new Author()
{
name = "Danny Pham"
};
var author2 = new Author()
{
name = "Turtle Kid"
};
var author3 = new Author()
{
name = "Robert Frost"
};
var author4 = new Author()
{
name = "Marylin Monroe"
};
var quote1 = new Quote()
{
quote = "I'm selfish, impatient and a little insecure. I make mistakes, I am out of control and at times hard to handle. But if you can't handle me at my worst, then you sure as hell don't deserve me at my best."
};
var quote2 = new Quote()
{
quote = "What Am I doing?"
};
var quote3 = new Quote()
{
quote = "I like Turtles."
};
var quote4 = new Quote()
{
quote = "In three words I can sum up everything I've learned about life: it goes on."
};
var qa1 = new QuoteAuthor()
{
Quote = quote1, Author = author4
};
var qa2 = new QuoteAuthor()
{
Quote = quote2, Author = author1
};
var qa3 = new QuoteAuthor()
{
Quote = quote3, Author = author2
};
var qa4 = new QuoteAuthor()
{
Quote = quote4, Author = author3
};
context.AddRange(qa1, qa2, qa3, qa4);
context.SaveChanges();
}
public IActionResult Process(Quote model)
{
if (ModelState.IsValid)
{
// _quoteFactory.Add(model);
_context.Quotes.Add(model);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Errors = ModelState.Values;
return(View("Landing"));
}
public IActionResult Save([FromBody] QuoteViewModel quote)
{
var user = _userManagement.Find(User.FindFirstValue(ClaimTypes.NameIdentifier));
var repo = new QuoteRepository(_context);
Quote q;
// New Quote
if (quote.Id == 0)
{
q = repo.CreateQuote(user);
}
// Update existing
else
{
q = repo.Search(quote.Id);
if (q == null)
{
// return 404?
return(NotFound());
}
else
{
if (q.CreatedByUserId != user.Id)
{
// Not created by this user??
return(Unauthorized());
}
}
}
q.Text = quote.Text;
// Check if Author has changed
if (q.Author == null || q.Author.Name != quote.Author)
{
q.Author = repo.FindAuthor(quote.Author);
if (q.Author == null)
{
q.Author = new Author()
{
Name = quote.Author,
};
}
}
_context.SaveChanges();
return(Ok(quote));
}
public ActionResult Edit(ProfileVM model)
{
if (ModelState.IsValid)
{
var context = new QuoteContext();
var login = context.ClientLogins.Single(x => x.Username == ApplicationSession.Username);
var client = context.Clients.Single(x => x.LoginId == login.Id);
client.Name = model.Name;
client.AddressLine1 = model.AddressLine1;
client.AddressLine2 = model.AddressLine2;
client.City = model.City;
client.State = model.StateOption.ToString();
client.ZipCode = model.Zipcode;
context.SaveChanges();
return(Redirect("/Home/UserHub"));
}
else
{
return(View(model));
}
}
public async Task AddNewQuote()
{
//arrange
var options = new DbContextOptionsBuilder <QuoteContext>().UseInMemoryDatabase(databaseName: "QuoteTestDb").Options;
using (var dbContext = new QuoteContext(options))
{
var quoteRepository = new QuoteRepository(dbContext);
//act
dbContext.Quotes.Add(new Quote()
{
Content = "It’s a dangerous business, Frodo, going out your door. You step onto the road, and if you don’t keep your feet, there’s no knowing where you might be swept off to.",
Author = "Bilbo"
});
dbContext.SaveChanges();
//assert
string expected = "Bilbo";
var quote = await dbContext.Quotes.FirstOrDefaultAsync(q => q.Author.Equals("Bilbo"));
Assert.Equal(expected, quote.Author);
}
}
public IActionResult Register(RegisterViewModel newUser)
{
if (ModelState.IsValid)
{
user userQuery = _context.Users.SingleOrDefault(user => user.Email == newUser.Email);
if (userQuery != null)
{
ViewBag.Exists = "User already exists.";
return(View("Index"));
}
user addUser = new user {
FirstName = newUser.FirstName,
LastName = newUser.LastName,
Email = newUser.Email,
Password = newUser.Password,
// CreatedAt = DateTime.Now,
// UpdatedAt = DateTime.Now
};
_context.Users.Add(addUser);
_context.SaveChanges();
return(RedirectToAction("Dashboard", "Dashboard"));
}
return(View("Index", newUser));
}
public void AddQuote([FromBody] Quote quote)
{
_context.Quotes.Add(quote);
_context.SaveChanges();
}
public void Complete()
{
context.SaveChanges();
}