public IActionResult Inserir(User user)
{
_context.Users.Add(user);
_context.SaveChanges();
return(View());
}
public JsonResult AddBasketItem(int itemId)
{
using (Models.AppContext context = Models.AppContext.Create())
{
var user = context.Users.Where(x => x.UserName == this.User.Identity.Name).FirstOrDefault();
var item = context.HairItems.Find(itemId);
if (user != null && item != null)
{
context.Entry(user).Reference("UserBasket").Load();
context.Entry(user.UserBasket).Collection("BasketItems").Load();
foreach (BasketItem tempItem in user.UserBasket.BasketItems)
{
context.Entry(tempItem).Reference("HairItem").Load();
if (tempItem.HairItem.Id == itemId)
{
tempItem.Quality += 1;
context.SaveChanges();
return(Json(true));
}
}
BasketItem basketItem = new BasketItem {
HairItem = item, Quality = 1, UserBasket = user.UserBasket
};
context.BasketItems.Add(basketItem);
context.SaveChanges();
return(Json(true));
}
return(Json(false));
}
}
public ActionResult New(Subscription subscription)
{
subscription.Cls = GetAllCls();
var numere = db.Subscriptions.Select(s => s.Numar).ToList();
try
{
if (ModelState.IsValid)
{
if (subscription.DataEmitere < DateTime.Now.Date)
{
ViewBag.Message = "Data trebuie sa fie una trecuta!";
return(View(subscription));
}
if (numere.Contains(subscription.Numar))
{
ViewBag.Message = "Numarul trebuie sa fie unic!";
return(View(subscription));
}
db.Subscriptions.Add(subscription);
db.SaveChanges();
TempData["message"] = "Abonamentul a fost adaugat cu succes!";
return(RedirectToAction("Index"));
}
return(View(subscription));
}
catch (Exception)
{
return(View(subscription));
}
}
public ActionResult New(Product product)
{
product.Date = DateTime.Now;
product.Categories = GetAllCategories();
product.Animals = GetAllAnimals();
try
{
if (ModelState.IsValid)
{
db.Products.Add(product);
db.SaveChanges();
TempData["message"] = "Produsul a fost adaugat cu succes!";
return(RedirectToAction("Index"));
}
else
{
return(View(product));
}
}
catch (Exception e)
{
return(View(product));
}
}
public T Update(T entity)
{
var result = Context.Set <T>().Update(entity).Entity;
Context.SaveChanges();
return(result);
}
public void Post()
{
var httpRequest = HttpContext.Current.Request;
foreach (string file in httpRequest.Files)
{
var postedFile = httpRequest.Files[file];
byte[] bytes;
using (BinaryReader br = new BinaryReader(postedFile.InputStream))
{
bytes = br.ReadBytes(postedFile.ContentLength);
}
var name = httpRequest.Form["name"];
var price = httpRequest.Form["price"];
var pr = Convert.ToInt32(price);
ImageEntity image = new ImageEntity()
{
Name = postedFile.FileName, ContentType = postedFile.ContentType, Data = bytes
};
HairItem hair = new HairItem()
{
Name = name, Price = Convert.ToInt32(price), HairImage = image
};
context.Images.Add(image);
context.HairItems.Add(hair);
context.SaveChanges();
}
}
public ActionResult Delete(int id)
{
Review rev = db.Reviews.Find(id);
db.Reviews.Remove(rev);
db.SaveChanges();
return(Redirect("/Products/Show/" + rev.ProductID));
}
public ActionResult Create([Bind(Include = "Id,Brand,TypeOfEngine")] CarList carList)
{
if (ModelState.IsValid)
{
db.CarLists.Add(carList);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(carList));
}
public ActionResult Create([Bind(Include = "Id,TownName,Color")] HomeList homeList)
{
if (ModelState.IsValid)
{
db.HomeLists.Add(homeList);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(homeList));
}
public ActionResult Create([Bind(Include = "Message")] Soliloquy soliloquy)
{
if (ModelState.IsValid)
{
soliloquy.Created = DateTime.UtcNow;
db.Soliluies.Add(soliloquy);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(soliloquy));
}
public IHttpActionResult DeleteResource(int id)
{
var res = db.Resources.FirstOrDefault(x => x.Id == id);
if (res != null)
{
db.Resources.Remove(res);
db.SaveChanges();
return(Ok(res));
}
return(BadRequest());
}
public ActionResult New(Category category)
{
try
{
db.Categories.Add(category);
db.SaveChanges();
TempData["message"] = "Categoria a fost adaugata cu succes!";
return(RedirectToAction("Index"));
}
catch (Exception)
{
return(View(category));
}
}
public ActionResult New(Review rev)
{
try
{
db.Reviews.Add(rev);
db.SaveChanges();
return(Redirect("/Products/Show/" + rev.ProductId));
}
catch (Exception e)
{
return(Redirect("/Products/Show/" + rev.ProductId));
}
}
public ActionResult New(Comment comment)
{
comment.Date = DateTime.Now;
try
{
db.Comments.Add(comment);
db.SaveChanges();
TempData["message"] = "Comentariul a fost adaugat cu succes!";
return(Redirect("/Articles/Show/" + comment.ArticleId));
}
catch (Exception)
{
return(Redirect("/Articles/Show/" + comment.ArticleId));
}
}
public HomeController(ILogger <HomeController> logger)
{
_logger = logger;
using (Models.AppContext context = new Models.AppContext())
{
context.AddRange(new UserModel[]
{
new UserModel
{
Name = "Александр",
Balance = 543.2,
Created = DateTime.ParseExact("2005-05-05 22:12", "yyyy-MM-dd HH:mm", null)
},
new UserModel
{
Name = "Виталий",
Balance = 543232.26,
Created = DateTime.ParseExact("2010-11-11 15:12", "yyyy-MM-dd HH:mm", null)
},
new UserModel
{
Name = "Константин",
Balance = 21,
Created = DateTime.ParseExact("2070-01-25 15:12", "yyyy-MM-dd HH:mm", null)
}
});
context.SaveChanges();
}
}
public IHttpActionResult Put(Pessoa pessoa)
{
if (!ModelState.IsValid || pessoa == null)
{
return(BadRequest("Dados do contato inválidos"));
}
using (var ctx = new Models.AppContext())
{
var contatoSelecionado = ctx.Pessoas.Where(p => p.Id == pessoa.Id).FirstOrDefault <Pessoa>();
if (contatoSelecionado != null)
{
contatoSelecionado.Name = pessoa.Name;
contatoSelecionado.Email = pessoa.Email;
contatoSelecionado.Username = pessoa.Username;
contatoSelecionado.Password = pessoa.Password;
ctx.Entry(contatoSelecionado).State = EntityState.Modified;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok($"{pessoa.Name} atualizado com sucesso"));
}
public virtual void Update(T entity)
{
using (var context = new Models.AppContext())
{
context.Entry(entity).State = EntityState.Modified;
context.SaveChanges();
}
}
public virtual void Create(T entity)
{
using (var context = new Models.AppContext())
{
context.Set <T>().Add(entity);
context.SaveChanges();
}
}
public ActionResult Create([Bind(Include = "Id,UserName,Password")] User user)
{
if (ModelState.IsValid)
{
var role = db.Roles.Where(r => r.Id == 2).FirstOrDefault();
if (role != null)
{
user.Roles = new List <Role>();
user.Roles.Add(role);
role.Users.Add(user);
}
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
public ActionResult Create([Bind(Include = "Id,Title,Detail,Done")] Todo todo)
{
if (ModelState.IsValid)
{
int userId = (int)Session["AuthUserId"];
var user = db.Users.Where(u => u.Id == userId).FirstOrDefault();
if (user != null)
{
todo.User = user;
}
db.Todoes.Add(todo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(todo));
}
public ActionResult New(Article article)
{
article.Categ = GetAllCategories();
article.Date = DateTime.Now;
try
{
if (ModelState.IsValid)
{
db.Articles.Add(article);
db.SaveChanges();
TempData["message"] = "Articolul a fost adaugat cu succes!";
return(RedirectToAction("Index"));
}
return(View(article));
}
catch (Exception)
{
return(View(article));
}
}
public virtual void Delete(T entity)
{
using (var context = new Models.AppContext())
{
if (context.Entry(entity).State == EntityState.Detached)
{
context.Set <T>().Attach(entity);
}
context.Set <T>().Remove(entity);
context.SaveChanges();
}
}
public ActionResult New(Category cat)
{
try
{
if (ModelState.IsValid)
{
db.Categories.Add(cat);
db.SaveChanges();
TempData["message"] = "Categoria a fost adaugata";
return(RedirectToAction("Index"));
}
else
{
return(View(cat));
}
}
catch (Exception e)
{
return(View(cat));
}
}
public ActionResult New(Student student)
{
student.Dom = GetAllDomains();
try
{
if (ModelState.IsValid)
{
db.Students.Add(student);
db.SaveChanges();
TempData["message"] = "Studentul a fost adaugat cu succes!";
return(RedirectToAction("Index"));
}
else
{
return(View(student));
}
}
catch (Exception e)
{
return(View(student));
}
}
IHttpActionResult DeleteOrder(int id)
{
Order order = db.Orders.Include(y => y.OrderItems).SingleOrDefault(x => x.Id == id);
foreach (var item in order.OrderItems.ToList())
{
db.OrderItems.Remove(item);
}
db.Orders.Remove(order);
db.SaveChanges();
return(Ok(order));
}
public ActionResult SignUp(string fname, string mname, string lname, int age, string img_url, string address, int specialty_id, string email, string password)
{
User newUser = new User();
newUser.fname = fname;
newUser.mname = mname;
newUser.lname = lname;
newUser.age = age;
newUser.img_url = img_url;
newUser.address = address;
newUser.specialty_id = specialty_id;
newUser.specialty = db.Specialties.Find(specialty_id);
newUser.login = email;
newUser.password = password;
//db.Users.Attach(newUser);
db.Specialties.Find(specialty_id).users.Add(newUser);
//db.Users.Add(newUser);
db.SaveChanges();
return(RedirectToAction("SignIn"));
}
public IActionResult Register(NotepadModel model)
{
if (!this.ModelState.IsValid)
{
return(BadRequest(ModelState.Values.SelectMany(e => e.Errors)));
}
if (!string.IsNullOrEmpty(model.Name))
{
var newContact = new Contact()
{
Name = model.Name
};
_context.Set <Contact>().Add(newContact);
foreach (PhoneNumber phoneNumber in model.PhoneNumbers)
{
_context.Set <PhoneNumber>().Add(new PhoneNumber()
{
Number = phoneNumber.Number,
Contact = newContact
});
}
foreach (Email email in model.Emails)
{
_context.Set <Email>().Add(new Email()
{
EmailName = email.EmailName,
Contact = newContact
});
}
_context.SaveChanges();
}
return(Ok());
}
public Task RemoveFromRoleAsync(AppUser user, string roleName, CancellationToken cancellationToken)
{
IdentityRole role = _roleManager.FindByNameAsync(roleName).Result;
string[] userRoleKeys = { user.Id, role.Id };
var result = Context.UserRoles.Find(userRoleKeys);
if (result != null)
{
Context.UserRoles.Remove(result);
Context.SaveChanges();
}
return(Task.FromResult(true));
}
public void Delete(int Id)
{
var record = _context.Customers.SingleOrDefault(c => c.Id == Id);
if (record != null)
{
_context.Customers.Remove(record);
_context.SaveChanges();
}
else
{
throw new HttpRequestException();
}
}
public ActionResult New(Product prod)
{
prod.Categ = GetAllCategories();
try
{
if (ModelState.IsValid)
{
db.Products.Add(prod);
db.SaveChanges();
TempData["message"] = "Produsul a fost adaugat";
return(RedirectToAction("Index"));
}
else
{
return(View(prod));
}
}
catch (Exception e)
{
return(View(prod));
}
}