// Donate
        public async Task <IActionResult> Donate()
        {
            var user = HttpContext.User.Claims.FirstOrDefault(c => c.Type == "http://schemas.xmlsoap.org/ws/2005/05/identity/claims/nameidentifier");

            var user_id = user.Value;

            var cart = _context.Cart.Where(c => c.UserId == user_id);

            if (String.IsNullOrEmpty(user_id))
            {
                return(RedirectToAction("Index"));
            }
            else
            {
                foreach (var item in cart)
                {
                    Donation donation = new Donation();
                    donation.Amount    = item.Amount;
                    donation.SpeciesId = item.SpeciesId;
                    donation.UserId    = item.UserId;
                    _context.Add(donation);
                }

                _context.SaveChanges();
            }

            RemoveFromCartByUser(user_id);
            // var donate = _context.Donation.Where(c => c.UserId == user_id);
            return(RedirectToAction("Index"));
            // View(await donate.ToListAsync());
        }
 public void CreateStudent(Student student)
 {
     using (var db = new EsDbContext())
     {
         db.Students.Add(student);
         db.SaveChanges();
     }
 }
 public void CreateLoanInformation(LoanInformation loanInformation)
 {
     using (var db = new EsDbContext())
     {
         db.LoanInformations.Add(loanInformation);
         db.SaveChanges();
     }
 }
 public void CreateComponentType(ComponentType componentType)
 {
     using (var db = new EsDbContext())
     {
         db.ComponentTypes.Add(componentType);
         db.SaveChanges();
     }
 }
 public void CreateComponent(Component component)
 {
     using (var db = new EsDbContext())
     {
         db.Components.Add(component);
         db.SaveChanges();
     }
 }
 public void DeleteStudent(int id)
 {
     using (var db = new EsDbContext())
     {
         var student = db.Students.Find(id);
         db.Students.Remove(student);
         db.SaveChanges();
     }
 }
 public void DeleteLoanInformation(int id)
 {
     using (var db = new EsDbContext())
     {
         var loanInformation = db.LoanInformations.Find(id);
         db.LoanInformations.Remove(loanInformation);
         db.SaveChanges();
     }
 }
 public void DeleteComponentType(int id)
 {
     using (var db = new EsDbContext())
     {
         var componentType = db.ComponentTypes.Find(id);
         db.ComponentTypes.Remove(componentType);
         db.SaveChanges();
     }
 }
示例#9
0
        public void RemoveFromCart(int id)
        {
            var cart = _context.Cart.SingleOrDefault(m => m.Id == id);

            _context.Cart.Remove(cart);
            _context.SaveChanges();

            return;
        }
        public void Update(EsDbContext context)
        {
            var category1 = new Category
            {
                CategoryName = "Cameras"
            };
            context.Categories.Add(category1);

            var comType1 = new ComponentType
            {
                ComponentName = "Camera",
                CategoryId = category1.Id
            };
            context.ComponentTypes.Add(comType1);

            var com1 = new Component
            {
                ComponentNumber = 14,
                ComponentTypeId = comType1.Id,
                SerieNr = "983234-EB",
                UserComment = "Great camera!",
                AdminComment = "Need to buy more of these",
            };
            context.Components.Add(com1);

            var student1 = new Student
            {
                Email = "*****@*****.**",
                MobilNo = "88888888",
                StudentName = "Leasy",
                StudentId = "201012345",
            };
            context.Students.Add(student1);

            var loan1 = new LoanInformation
            {
                IsReservation = false,
                LoanDate = DateTime.Now,
                StudentId = student1.Id,
                ReservationDate = DateTime.Now,
                ReturnDate = DateTime.Now.AddMonths(1)
            };
            context.LoanInformations.Add(loan1);

            context.SaveChanges();
        }
 public void UpdateStudent(Student student)
 {
     using (var db = new EsDbContext())
     {
         db.Entry(student).State = EntityState.Modified;
         db.SaveChanges();
     }
 }
 public void UpdateLoanInformation(LoanInformation loanInformation)
 {
     using (var db = new EsDbContext())
     {
         db.Entry(loanInformation).State = EntityState.Modified;
         db.SaveChanges();
     }
 }
 public void UpdateComponentType(ComponentType componentType)
 {
     using (var db = new EsDbContext())
     {
         db.Entry(componentType).State = EntityState.Modified;
         db.SaveChanges();
     }
 }