public ActionResult ApproveOrders() { //OrdersPendingIndexView viewModel = new OrdersPendingIndexView(); string username = User.Identity.Name; // get current logged in user Supervisor supervisor = db.Supervisors.SingleOrDefault(s => s.UserProfile.UserName == username); // gets supervisor from username // query retrieves orders which have not been checked by project supervisor var query = from o in db.Orders.Include("Student").Include("Student.Project").Include("Components") where (o.Student.Project.Supervisor.SupervisorID == supervisor.SupervisorID && o.IsChecked == false) // display orders for students for supervisor select o; // checks each order if they are above budget and if they are then marks the boolean as true and saves to db foreach (Order o in query) { if (o.OrderTotal > o.Student.Project.Budget) { o.IsOverBudget = true; db.Entry(o).State = EntityState.Modified; } } db.SaveChanges(); // view model.Ienumberalbe = query return(View(query)); }
/// <summary> /// Update map information /// </summary> /// <param name="mapModel"></param> /// <returns></returns> public void UpdateMap(MapModel mapModel) { if (string.IsNullOrWhiteSpace(mapModel.HashId)) { throw HttpResponseExceptionHelper.Create("No map hash id specified", HttpStatusCode.BadRequest); } using (var db = new SystemDBContext()) { var map = db.Maps.FirstOrDefault(x => x.HashId == mapModel.HashId); if (map == null) { throw HttpResponseExceptionHelper.Create("No map correspond to the given hashId", HttpStatusCode.BadRequest); } // Update info if (!string.IsNullOrWhiteSpace(mapModel.Content)) { map.Content = mapModel.Content; } map.Level = mapModel.Level; map.UpdateTime = TimeHelper.CurrentCanadaTime(); // Mark entity as modified db.Entry(map).State = System.Data.Entity.EntityState.Modified; // call SaveChanges db.SaveChanges(); } }
public ActionResult Index() { string username = User.Identity.Name; // get current logged in user Student student = db.Students.SingleOrDefault(s => s.UserProfile.UserName == username); Supervisor supervisor = db.Supervisors.Include("UserProfile").FirstOrDefault(s => s.UserProfile.UserName == username); // check logged in username vs name on table Technician technician = db.Technicians.Include("UserProfile").SingleOrDefault(s => s.UserProfile.UserName == username); // check logged in username vs name on table if (student != null) { return(RedirectToRoute("Student")); } else if (technician != null) { return(RedirectToRoute("Technician")); } else if (supervisor != null) { // get update project details with the right supervisor details foreach (Project project in db.Projects.Include("Supervisor").Include("Supervisor.UserProfile")) { // modify fields if (project.Supervisor.UserProfile.Email == supervisor.UserProfile.Email && project.Supervisor.FirstName == null) { Supervisor oldSupervisor = project.Supervisor; UserProfile oldSupervisorUserProfile = project.Supervisor.UserProfile; project.Supervisor = supervisor; // update the project supervisor details db.Entry(oldSupervisor).State = EntityState.Deleted; // delete old supervisor details db.Entry(oldSupervisorUserProfile).State = EntityState.Deleted; // delete old supervisor user profile// db.Entry(project).State = EntityState.Modified; // update project details } } db.SaveChanges(); return(RedirectToRoute("Supervisor")); } else if (User.IsInRole("Admin")) { return(RedirectToRoute("Admin")); } return(View()); }
public ActionResult EnableAccount(int id) { UserProfile user = db.UserProfiles.Find(id); // retreives user user.IsChecked = true; user.IsVerifyed = true; if (ModelState.IsValid) { db.Entry(user).State = EntityState.Modified; //saves changes of new state to db db.SaveChanges(); } return(RedirectToAction("ReactivateAccount")); // refreshes the reactivate view }
public void Update <T>(T entity) where T : class { DbEntityEntry entityEntry = dataContext.Entry(entity); if (entityEntry.State == EntityState.Detached) { dataContext.Set <T>().Attach(entity); entityEntry.State = EntityState.Modified; } }
public ActionResult ViewNotNotifiedOrderedOrders(int id) { Order order = db.Orders.Find(id); if (order.StudentIsNotified != true) // if the student is not notified then send an email to notify { order.StudentIsNotified = true; // set status to true SendOrderReadyToCollectEmail(order.OrderID); // send the email db.Entry(order).State = EntityState.Modified; // save the order object changes db.SaveChanges(); return(RedirectToAction("ViewNotNotifiedOrderedOrders")); // refresh view } else { //send email method here SendOrderReadyToCollectEmail(order.OrderID); // send email return(RedirectToAction("ViewNotCollectedOrders")); // send to orders not collected view } }
public async Task <bool> UpdateUserAsync(User user) { _Context.users.Attach(user); _Context.Entry(user).State = EntityState.Modified; try { return(await _Context.SaveChangesAsync() > 0 ? true : false); } catch (Exception exp) { _Logger.LogError($"Error in {nameof(UpdateUserAsync)}: " + exp.Message); } return(false); }
/// <summary> /// 更新實體 /// </summary> /// <param name="entity">實體</param> public TEntity Update(TEntity entity) { _dbContext.Set <TEntity>().Attach(entity); _dbContext.Entry(entity).State = EntityState.Modified; return(entity); }
public async Task <Bill> AddNewBillAsync(BillResponse billResponse) { Bill bill = new Bill(); if (billResponse.groupId != 0) { bill.groupId = billResponse.groupId; } bill.bill_created_at = billResponse.bill_created_at; bill.bill_created_byId = billResponse.bill_created_byId; bill.bill_date = billResponse.bill_date; bill.bill_updated_at = billResponse.bill_updated_at; bill.description = billResponse.description; bill.total_amount = billResponse.total_amount; bill.bill_updated_byId = billResponse.bill_updated_byId; _Context.bills.Add(bill); try { await _Context.SaveChangesAsync(); } catch (Exception exp) { _Logger.LogError($"Error in {nameof(AddNewBillAsync)}: " + exp.Message); } //int id = bill.billid; foreach (var x in billResponse.payers) { Payer payer = new Payer(); payer.billId = bill.billid; payer.paid_byId = x.paid_byId; payer.amount_paid = x.amount_paid; _Context.payers.Add(payer); try { await _Context.SaveChangesAsync(); } catch (Exception exp) { _Logger.LogError($"Error in {nameof(AddNewBillAsync)}: " + exp.Message); } } foreach (var x in billResponse.sharedwiths) { SharedWith sharedWith = new SharedWith(); sharedWith.billId = bill.billid; sharedWith.shared_withId = x.shared_withId; sharedWith.owes_amount = x.owes_amount; _Context.sharedWiths.Add(sharedWith); try { await _Context.SaveChangesAsync(); } catch (Exception exp) { _Logger.LogError($"Error in {nameof(AddNewBillAsync)}: " + exp.Message); } } foreach (var x in billResponse.settlements) { if (billResponse.groupId != 0) { Settlements settlements = new Settlements(); settlements = await _Context.settlements .SingleOrDefaultAsync(c => c.groupId == billResponse.groupId && c.payeeId == x.payeeId && c.payerId == x.payerId); if (settlements != null) { settlements.payerId = x.payerId; settlements.payeeId = x.payeeId; settlements.amount = settlements.amount + x.paid_amount; settlements.groupId = billResponse.groupId; _Context.settlements.Attach(settlements); _Context.Entry(settlements).State = EntityState.Modified; } else { settlements = await _Context.settlements .SingleOrDefaultAsync(c => c.groupId == billResponse.groupId && c.payeeId == x.payerId && c.payerId == x.payeeId); if (settlements != null) { if (settlements.amount > x.paid_amount) { settlements.payerId = x.payeeId; settlements.payeeId = x.payerId; settlements.groupId = billResponse.groupId; settlements.amount = settlements.amount - x.paid_amount; _Context.settlements.Attach(settlements); _Context.Entry(settlements).State = EntityState.Modified; } else { settlements.payerId = x.payerId; settlements.payeeId = x.payeeId; settlements.groupId = billResponse.groupId; settlements.amount = x.paid_amount - settlements.amount; _Context.settlements.Attach(settlements); _Context.Entry(settlements).State = EntityState.Modified; } } else { Settlements settlements1 = new Settlements(); settlements1.payerId = x.payerId; settlements1.payeeId = x.payeeId; settlements1.amount = x.paid_amount; settlements1.groupId = billResponse.groupId; _Context.settlements.Add(settlements1); } } } else { Settlements settlements = new Settlements(); settlements = await _Context.settlements .FirstOrDefaultAsync(c => c.groupId == bill.groupId && c.payeeId == x.payeeId && c.payerId == x.payerId); if (settlements != null) { settlements.payerId = x.payerId; settlements.payeeId = x.payeeId; settlements.amount = settlements.amount + x.paid_amount; _Context.settlements.Attach(settlements); _Context.Entry(settlements).State = EntityState.Modified; } else { settlements = await _Context.settlements .FirstOrDefaultAsync(c => c.groupId == bill.groupId && c.payeeId == x.payerId && c.payerId == x.payeeId); if (settlements != null) { if (settlements.amount > x.paid_amount) { settlements.payerId = x.payeeId; settlements.payeeId = x.payerId; settlements.amount = settlements.amount - x.paid_amount; _Context.settlements.Attach(settlements); _Context.Entry(settlements).State = EntityState.Modified; } else { settlements.payerId = x.payerId; settlements.payeeId = x.payeeId; settlements.amount = x.paid_amount - settlements.amount; _Context.settlements.Attach(settlements); _Context.Entry(settlements).State = EntityState.Modified; } } else { Settlements settlements1 = new Settlements(); settlements1.payerId = x.payerId; settlements1.payeeId = x.payeeId; settlements1.amount = x.paid_amount; // settlements1.groupId = billResponse.groupId; _Context.settlements.Add(settlements1); } } } try { await _Context.SaveChangesAsync(); } catch (Exception exp) { _Logger.LogError($"Error in {nameof(AddNewBillAsync)}: " + exp.Message); } } for (int i = 0; i < billResponse.sharedwiths.Count; i++) { for (int j = i + 1; j < billResponse.sharedwiths.Count; j++) { Friend friend = new Friend(); var frdexist = _Context.friends.SingleOrDefault( c => (c.userId == billResponse.sharedwiths[i].shared_withId && c.friendId == billResponse.sharedwiths[j].shared_withId) || (c.userId == billResponse.sharedwiths[j].shared_withId && c.friendId == billResponse.sharedwiths[i].shared_withId)); if (frdexist == null) { friend.friendId = billResponse.sharedwiths[j].shared_withId; friend.userId = billResponse.sharedwiths[i].shared_withId; _Context.friends.Add(friend); try { await _Context.SaveChangesAsync(); } catch (Exception exp) { _Logger.LogError($"Error in {nameof(AddNewBillAsync)}: " + exp.Message); } } } } return(bill); }
public ActionResult Register(RegisterModel model) { if (ModelState.IsValid) { // Attempt to register the user // Attempt to register the user try { string confirmationToken = WebSecurity.CreateUserAndAccount(model.UserName, model.Password, new { Email = model.Email }, true); SendEmailConfirmation(model.Email, model.UserName, confirmationToken); if (model.SelectedVal.Contains("0")) { UserProfile userProfile = db.UserProfiles.FirstOrDefault(s => s.UserName == model.UserName); Student student = new Student { FirstName = model.FirstName, LastName = model.LastName, MiddleName = model.MiddleName, UserProfile = userProfile }; userProfile.UserType = "Student"; if (ModelState.IsValid) { db.Entry <UserProfile>(userProfile).State = EntityState.Modified; db.Students.Add(student); db.SaveChanges(); } } // if dropdown list for supervisor is selected then do the below else if (model.SelectedVal.Contains("1")) { UserProfile userProfile = db.UserProfiles.FirstOrDefault(s => s.UserName == model.UserName); userProfile.Email = userProfile.Email.ToLower(); Supervisor supervisor = new Supervisor { FirstName = model.FirstName, LastName = model.LastName, MiddleName = model.MiddleName, UserProfile = userProfile }; userProfile.UserType = "Supervisor"; if (ModelState.IsValid) { db.Entry <UserProfile>(userProfile).State = EntityState.Modified; db.Supervisors.Add(supervisor); db.SaveChanges(); } } else if (model.SelectedVal.Contains("2")) { UserProfile userProfile = db.UserProfiles.FirstOrDefault(s => s.UserName == model.UserName); Technician technician = new Technician { FirstName = model.FirstName, LastName = model.LastName, MiddleName = model.MiddleName, UserProfile = userProfile }; userProfile.UserType = "Technician"; if (ModelState.IsValid) { db.Entry <UserProfile>(userProfile).State = EntityState.Modified; db.Technicians.Add(technician); db.SaveChanges(); } } return(RedirectToAction("RegisterStepTwo", "Account")); } catch (MembershipCreateUserException e) { ModelState.AddModelError("", ErrorCodeToString(e.StatusCode)); } } // redisplay form, something is wrong if we got this far return(View(model)); }
public int Insert(TEntity entity) { dbcontext.Entry <TEntity>(entity).State = EntityState.Added; return(dbcontext.SaveChanges()); }