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