public async Task OnboardUser(LoginViewModel value) { string token = SendMail(value); UserAccount user = new UserAccount() { EmailId = value.EmailId, Password = token }; _context.UserAccount.Add(user); _context.SaveChanges(); }
// CREATE Sale public JsonResult CreateSale(ProductSold sale) { try { db.ProductSolds.Add(sale); db.SaveChanges(); } catch (Exception e) { Console.Write(e.Data + "Exception Occured"); return(new JsonResult { Data = "Sale Create Failed", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
// CREATE Product public JsonResult CreateCustomer(Customer customer) { try { db.Customers.Add(customer); db.SaveChanges(); Console.Write("Success"); } catch (Exception e) { Console.Write(e.Data + "Exception Occured"); return(new JsonResult { Data = "Customer Create Failed", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
// DELETE Store public JsonResult DeleteStore(int id) { try { var store = _context.Stores.Where(s => s.Id == id).SingleOrDefault(); if (store != null) { _context.Stores.Remove(store); _context.SaveChanges(); } } catch (Exception e) { Console.Write(e.Data + "Exception Occured"); return(new JsonResult { Data = "Deletion Falied", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
// DELETE Product public JsonResult DeleteProduct(int id) { try { var product = db.Products.Where(p => p.Id == id).SingleOrDefault(); if (product != null) { db.Products.Remove(product); db.SaveChanges(); } } catch (Exception e) { Console.Write(e.Data + "Exception Occured"); return(new JsonResult { Data = "Deletion Failed", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public IActionResult Index() { UserViewModel userViewModel = new UserViewModel(); FeedbackViewModel feedbackViewModel = new FeedbackViewModel(); var userClaims = User.Identity as System.Security.Claims.ClaimsIdentity; var userClaimSubject = userClaims?.FindFirst(System.Security.Claims.ClaimTypes.NameIdentifier)?.Value; var dbUser = _db.Set <User>().Where(u => u.Subject == userClaimSubject).FirstOrDefault(); var dbCheck = _db.Users.ToList(); if (!dbCheck.Contains(dbUser)) { User user = new User(); user.Name = userClaims?.FindFirst("name")?.Value; user.Email = userClaims?.FindFirst("preferred_username")?.Value; user.Subject = userClaims?.FindFirst(System.Security.Claims.ClaimTypes.NameIdentifier)?.Value; user.IsAdmin = false; Log log = new Log(); log.UserID = user.UserID; User dbUserMatch = _db.Users.Find(user.UserID); if (dbUserMatch == null) { if (ModelState.IsValid) { _db.Users.Add(user); _db.Logs.Add(log); _db.SaveChanges(); } } } var dbUserCheck = _db.Users.First(u => u.Subject == userClaimSubject); userViewModel.PrivacyChecked = CheckPrivacy().Value; userViewModel.NeuedaIntroChecked = CheckNeuedaIntro().Value; userViewModel.DAERAIntroChecked = CheckDAERAIntro().Value; userViewModel.InformationSecurityChecked = CheckInformationSecurity().Value; userViewModel.HealthAndSafetyChecked = CheckHealthAndSafety().Value; userViewModel.CompanyRelationsChecked = CheckCompanyRelations().Value; userViewModel.OrganisationStructureChecked = CheckOrganisationStructure().Value; userViewModel.IsAdmin = dbUserCheck.IsAdmin; ViewBag.Name = userClaims?.FindFirst("name")?.Value; return(View(userViewModel)); }
/// <summary> /// Deletes Employee record /// </summary> /// <param name="empId"></param> public void Delete(int empId) { using (OnboardingContext ctx = new OnboardingContext()) { var employeeToDelete = ctx.Employees.Find(empId); if (employeeToDelete != null) { //entity is already in the context var attachedEntry = ctx.Entry(employeeToDelete).Entity; ctx.Employees.Remove(attachedEntry); ctx.SaveChanges(); } } }
/// <summary> /// Updates existing employee record /// </summary> /// <param name="employee"></param> public bool Update(Employee employee) { using (OnboardingContext ctx = new OnboardingContext()) { var updatedEmployee = ctx.Employees.Find(employee.Id); if (updatedEmployee != null) { //entity is already in the context var attachedEntry = ctx.Entry(updatedEmployee); attachedEntry.CurrentValues.SetValues(employee); ctx.SaveChanges(); return(true); } return(false); } }
public ActionResult CreateProduct([FromBody] Product product) { using (var db = new OnboardingContext()) { if (ModelState.IsValid) { db.Products.Add(product); db.SaveChanges(); return(StatusCode(StatusCodes.Status201Created)); } else { return(StatusCode(StatusCodes.Status400BadRequest)); } } }
public ActionResult DeleteSales(int id) { using (var db = new OnboardingContext()) { try { var entity = db.Sales.Find(id); db.Sales.Remove(entity); db.SaveChanges(); return(Ok("Sales deleted")); } catch { throw; } } }
public ActionResult Create([FromBody] Customer customer) { //Does not implement catching exception using (var db = new OnboardingContext()) { if (ModelState.IsValid) { db.Customers.Add(customer); db.SaveChanges(); return(StatusCode(StatusCodes.Status201Created)); } else { return(StatusCode(StatusCodes.Status400BadRequest)); } } }
public ActionResult Edit(int id, [FromBody] Customer customer) { using (var db = new OnboardingContext()) { if (ModelState.IsValid) { var entity = db.Customers.Find(id); entity.Name = customer.Name; entity.Address = customer.Address; db.SaveChanges(); return(Ok("Record Updated Succesfully...")); } else { return(NotFound("No record has been found against this id")); } } }
public ActionResult EditProduct(int id, [FromBody] Product product) { using (var db = new OnboardingContext()) { if (ModelState.IsValid) { var entity = db.Products.Find(id); entity.Name = product.Name; entity.Price = product.Price; db.SaveChanges(); return(Ok("Record Updated Succesfully...")); } else { return(NotFound("No record has been found against this id")); } } }
public ActionResult EditSales(int id, [FromBody] Sales sales) { using (var db = new OnboardingContext()) { if (ModelState.IsValid) { var entity = db.Sales.Find(id); entity.CustomerId = sales.CustomerId; entity.ProductId = sales.ProductId; entity.StoreId = sales.StoreId; entity.DateSold = sales.DateSold; db.SaveChanges(); return(Ok("Record Updated Succesfully...")); } else { return(NotFound("No record has been found against this id")); } } }
/// <summary> /// Adds new employee /// </summary> /// <param name="employee"></param> /// <returns>The newly created employee id</returns> public int Add(Employee employee) { ctx.Employees.Add(employee); ctx.SaveChanges(); return(employee.Id); }