public async Task <IActionResult> PutPeopleModel(Guid id, PeopleModel peopleModel) { if (id != peopleModel.Id) { return(BadRequest()); } _context.Entry(peopleModel).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!PeopleModelExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <UserDb> AddUser(UserDb user) { user.Id = 0; await _context.Users.AddAsync(user); await _context.SaveChangesAsync(); return(user); }
public async Task <IActionResult> Create([Bind("MemberID,MemberName,InductionDate,Age")] Member member) { if (ModelState.IsValid) { _context.Add(member); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(member)); }
public async Task <IActionResult> Create([Bind("Inv_ID,Inv_des,Inv_amount,Inv_date")] Invoice invoice) { if (ModelState.IsValid) { _context.Add(invoice); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(invoice)); }
public async Task <ActionResult> Edit([Bind(Include = "Id,Email,EmailConfirmed,PasswordHash,SecurityStamp,PhoneNumber,PhoneNumberConfirmed,TwoFactorEnabled,LockoutEndDateUtc,LockoutEnabled,AccessFailedCount,UserName")] AspNetUser aspNetUser) { if (ModelState.IsValid) { db.Entry(aspNetUser).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(aspNetUser)); }
public async Task <ActionResult> Create([Bind(Include = "ForemanID,FirstName,LastName,Cell")] Foreman foreman) { if (ModelState.IsValid) { db.Foremen.Add(foreman); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(foreman)); }
public async Task <ActionResult> Create([Bind(Include = "PurchaserID,Name")] Purchaser purchaser) { if (ModelState.IsValid) { db.Purchasers.Add(purchaser); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(purchaser)); }
public async Task <IActionResult> Create([Bind("Emp_ID,Emp_lname,Emp_fname,Emp_phone,Emp_email,Cus_ID")] Employee employee) { if (ModelState.IsValid) { _context.Add(employee); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["Cus_ID"] = new SelectList(_context.Customers, "Cus_ID", "Cus_ID", employee.Cus_ID); return(View(employee)); }
public async Task <IActionResult> Create([Bind("Cus_ID,Cus_lname,Cus_fname,Cus_phone,Cus_email,Cus_street,Cus_city,Cus_pro,Cus_country,Inv_ID")] Customer customer) { if (ModelState.IsValid) { _context.Add(customer); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["Inv_ID"] = new SelectList(_context.Invoices, "Inv_ID", "Inv_ID", customer.Inv_ID); return(View(customer)); }
public async Task <ActionResult> Create([Bind(Include = "SiteSuperID,Name,Phone,Work")] SiteSuper siteSuper) { if (ModelState.IsValid) { db.SiteSupers.Add(siteSuper); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(siteSuper)); }
public async Task <ActionResult> Create([Bind(Include = "GenContractorID,Name")] GenContractor genContractor) { if (ModelState.IsValid) { db.GenContractors.Add(genContractor); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(genContractor)); }
public async Task <ActionResult> Create([Bind(Include = "EmployeeID,EmployeeNumber,FirstName,LastName,Address,City,ProvinceOrState,HomePhone,HomeCellPhone,WorkPhone,WorkCellPhone,EmergencyContactName,EmergencyContactPhone")] Employee employee) { if (ModelState.IsValid) { db.Employees.Add(employee); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(employee)); }
public async Task <ActionResult> Create([Bind(Include = "PMID,FirstName,LastName,Address,City,Province,Phone,WorkPhone")] PM pM) { if (ModelState.IsValid) { db.PMs.Add(pM); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(pM)); }
public async Task <ActionResult> Create([Bind(Include = "ContactId,ContactName,WorkPhone,WorkCellPhone")] PhoneBook phoneBook) { if (ModelState.IsValid) { db.PhoneBooks.Add(phoneBook); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(phoneBook)); }
public async Task <ActionResult> Create([Bind(Include = "SiteSuperID,Name,Phone,Work")] SiteSuper siteSuper) { if (ModelState.IsValid) { db.SiteSupers.Add(siteSuper); await db.SaveChangesAsync(); AccountController.dynamicLogRecord(User.Identity.Name.ToString() + " created: " + "Site Super ID: " + siteSuper.SiteSuperID + " Site Super Name: " + siteSuper.Name + " Site Super Phone: " + siteSuper.Phone + " Site Super Work: " + siteSuper.Work, User.Identity.Name.ToString(), AccountController.setDynamicLog(User.Identity.Name)); return(RedirectToAction("Index")); } return(View(siteSuper)); }
public async Task <ActionResult> Create([Bind(Include = "ForemanID,FirstName,LastName,Cell")] Foreman foreman) { if (ModelState.IsValid) { db.Foremen.Add(foreman); await db.SaveChangesAsync(); AccountController.dynamicLogRecord(User.Identity.Name.ToString() + " created: " + "Foreman ID: " + foreman.ForemanID + " Foreman First Name: " + foreman.FirstName + " Foreman Last Name: " + foreman.LastName + " Foreman Cell: " + foreman.Cell, User.Identity.Name.ToString(), AccountController.setDynamicLog(User.Identity.Name)); return(RedirectToAction("Index")); } return(View(foreman)); }
public async Task <ActionResult> Create([Bind(Include = "GenContractorID,Name")] GenContractor genContractor) { if (ModelState.IsValid) { db.GenContractors.Add(genContractor); await db.SaveChangesAsync(); AccountController.dynamicLogRecord(User.Identity.Name.ToString() + " created: " + " Gen Contractor ID: " + genContractor.GenContractorID + " Gen Contractor Name: " + genContractor.Name, User.Identity.Name.ToString(), AccountController.setDynamicLog(User.Identity.Name)); return(RedirectToAction("Index")); } return(View(genContractor)); }
public async Task <ActionResult> Create([Bind(Include = "PMID,FirstName,LastName,Address,City,Province,Phone,WorkPhone")] PM pM) { if (ModelState.IsValid) { db.PMs.Add(pM); await db.SaveChangesAsync(); AccountController.dynamicLogRecord(User.Identity.Name.ToString() + " created: PMID: " + pM.PMID + " First Name: " + pM.FirstName + " Last Name: " + pM.LastName + " Address: " + pM.Address + " City: " + pM.City + " Province: " + pM.Province + " Phone: " + pM.Phone + " Work Phone: " + pM.WorkPhone, User.Identity.Name.ToString(), AccountController.setDynamicLog(User.Identity.Name)); return(RedirectToAction("Index")); } return(View(pM)); }
public async Task <ActionResult> Create([Bind(Include = "EmployeeID,EmployeeNumber,FirstName,LastName,Address,City,ProvinceOrState,HomePhone,HomeCellPhone,WorkPhone,WorkCellPhone,EmergencyContactName,EmergencyContactPhone")] Employee employee) { if (ModelState.IsValid) { db.Employees.Add(employee); await db.SaveChangesAsync(); //Logging employee creation logger.Info(User.Identity.Name + " created " + employee.FirstName + " " + employee.LastName + " Values " + "Employee Number: " + employee.EmployeeNumber + " First Name: " + employee.FirstName + " Last Name: " + employee.LastName + " Address: " + employee.Address + " City: " + employee.City + " Province/State: " + employee.ProvinceOrState + " Home Phone: " + employee.HomePhone + " Home Cell Phone: " + employee.HomeCellPhone + " Work Phone: " + employee.WorkPhone + " Work Cell Phone: " + employee.WorkCellPhone + " Emergency Contact Name: " + employee.EmergencyContactName + " Emergency Contant Phone: " + employee.EmergencyContactPhone); AccountController.dynamicLogRecord(User.Identity.Name.ToString() + " created " + employee.FirstName + " " + employee.LastName + " Values " + "Employee Number: " + employee.EmployeeNumber + " First Name: " + employee.FirstName + " Last Name: " + employee.LastName + " Address: " + employee.Address + " City: " + employee.City + " Province/State: " + employee.ProvinceOrState + " Home Phone: " + employee.HomePhone + " Home Cell Phone: " + employee.HomeCellPhone + " Work Phone: " + employee.WorkPhone + " Work Cell Phone: " + employee.WorkCellPhone + " Emergency Contact Name: " + employee.EmergencyContactName + " Emergency Contant Phone: ", User.Identity.Name, AccountController.setDynamicLog(User.Identity.Name)); return(RedirectToAction("Index")); } return(View(employee)); }
public bool Update(Position position) { try { List <Position> positions = _mgmtContext.Position.Where(p => p.Id != position.Id && p.Position_Type == position.Position_Type).ToList(); if (positions.Count() == 1) { return(false); } _mgmtContext.Update(position); _mgmtContext.SaveChangesAsync(); return(true); } catch (InvalidOperationException ioe) { Debug.WriteLine("Message " + ioe.Message); return(false); } catch (DbUpdateConcurrencyException dce) { Debug.WriteLine("Message " + dce.Message); return(false); } }
public async Task <JobDb> AddJob(JobDb job) { job.Id = 0; var newJob = new JobDb { Id = 0, Name = job.Name, UserId = job.UserId, ClientId = job.ClientId, HoursReported = job.HoursReported }; await _context.Jobs.AddAsync(newJob); await _context.SaveChangesAsync(); return(job); }
public async Task <ActionResult> Create([Bind(Include = "Id,Email,EmailConfirmed,PasswordHash,SecurityStamp,PhoneNumber,PhoneNumberConfirmed,TwoFactorEnabled,LockoutEndDateUtc,LockoutEnabled,AccessFailedCount,UserName")] AspNetUser aspNetUser) { if (ModelState.IsValid) { db.AspNetUsers.Add(aspNetUser); await db.SaveChangesAsync(); //Log user being created (with username and Email) logger.Info(User.Identity.Name + " created " + aspNetUser.UserName + " " + aspNetUser.Email + " "); AccountController.dynamicLogRecord(User.Identity.Name.ToString() + " created " + aspNetUser.UserName + " " + aspNetUser.Email + " ", User.Identity.Name, AccountController.setDynamicLog(User.Identity.Name)); return(RedirectToAction("Index")); } return(View(aspNetUser)); }
public async Task <IActionResult> Create([FromBody] Dish dish) { if (dish == null) { return(BadRequest()); } try { _context.Dishes.Add(dish); await _context.SaveChangesAsync(); return(Ok()); } catch (DbUpdateException /* ex */) { Response.StatusCode = (int)HttpStatusCode.InternalServerError; return(Json(new { error = "Ocorreu um erro interno, por favor tente novamente." })); } }
public async Task <bool> Handle(AddGoodsCommand request, CancellationToken cancellationToken) { var goods = new Goods(request.Name); goods.CreateTime = DateTime.Now; // TODO: User goods.CreateUser = _httpContext.HttpContext.User.Claims.FirstOrDefault(f => f.Type == "UserName").Value; goods.LastUpdateTime = DateTime.Now; // TODO: User goods.LastUpdateUser = ""; var ImageIds = JsonConvert.DeserializeObject <List <Guid> >(request.ExtendValues["images"].ToString()); var keys = request.ExtendValues.Keys; var extendFields = _managementContext.GoodsExtendFields.Where(w => keys.Contains(w.Key)); List <GoodsExtendAttribute> extendAttributes = new List <GoodsExtendAttribute>(); foreach (var extendField in extendFields) { string value = request.ExtendValues[extendField.Key]?.ToString(); if (!string.IsNullOrEmpty(value)) { extendAttributes.Add(new GoodsExtendAttribute { GoodsId = goods.Id, GoodsExtendFieldId = extendField.Id, Value = value }); } } // 事务 using IDbContextTransaction tran = _managementContext.Database.BeginTransaction(); try { // 更新图片 await _managementContext.GoodsImages.Where(w => w.GoodsId == goods.Id).ForEachAsync(f => f.GoodsId = null); await _managementContext.GoodsImages.Where(w => ImageIds.Contains(w.Id)).ForEachAsync(f => f.GoodsId = goods.Id); // 保存物品 await _managementContext.Goods.AddAsync(goods); await _managementContext.GoodsExtendAttributes.AddRangeAsync(extendAttributes); var result = await _managementContext.SaveChangesAsync(); await tran.CommitAsync(); return(result > 0); } catch (Exception) { tran.Rollback(); // 保存错误 or 抛出错误 } return(false); }
public async Task <ActionResult> Create([Bind(Include = "JobID,JobNumber,JobName,LocationName,Address,City,ProvinceOrState,GenContractorContact,Foreman_ForemanID,GenContractor_GenContractorID,PM_PMID,Purchaser_PurchaserID,SiteSuper_SiteSuperID")] Job job) { if (ModelState.IsValid) { db.Jobs.Add(job); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.Foreman_ForemanID = new SelectList(db.Foremen, "ForemanID", "FullName", job.Foreman_ForemanID); ViewBag.GenContractor_GenContractorID = new SelectList(db.GenContractors, "GenContractorID", "Name", job.GenContractor_GenContractorID); ViewBag.PM_PMID = new SelectList(db.PMs, "PMID", "FullName", job.PM_PMID); ViewBag.Purchaser_PurchaserID = new SelectList(db.Purchasers, "PurchaserID", "Name", job.Purchaser_PurchaserID); ViewBag.SiteSuper_SiteSuperID = new SelectList(db.SiteSupers, "SiteSuperID", "Name", job.SiteSuper_SiteSuperID); return(View(job)); }
public async Task <ActionResult> Create([Bind(Include = "HourRecordID,DateTime,Hours,Employee_EmployeeID,Job_JobID,Comment")] HourRecord hourRecord) { ApplicationDbContext context = new ApplicationDbContext(); //used to see who is currently logged in UserManager <ApplicationUser> UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context)); ApplicationUser currentUser = UserManager.FindById(User.Identity.GetUserId()); if (ModelState.IsValid) { hourRecord.Employee_EmployeeID = currentUser.Employee_EmployeeID; db.HourRecords.Add(hourRecord); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } //Possibly adding again for admin use? //ViewBag.Employee_EmployeeID = new SelectList(db.Employees, "EmployeeID", "FirstName", hourRecord.Employee_EmployeeID); return(View(hourRecord)); }
private async Task <string> updateToken(string username) { using (var db = new ManagementContext()) { ManagementModel model = await db.management .Where(x => x.username == username) .SingleAsync(); DateTime dt = DateTime.Now; if (dt.Subtract((DateTime)(model.token_update)).Minutes > 3) { model.token = Token.createToken(); model.token_update = DateTime.Now; db.management.Update(model); await db.SaveChangesAsync(); } return(model.token); } }
public async Task <GoodsExtendField> Handle(AddGoodsExtendFieldCommand request, CancellationToken cancellationToken) { var model = _mapper.Map <GoodsExtendField>(request); model.Key = request.Name.GetPinyin(); model.CreateTime = DateTime.Now; // TODO: User model.CreateUser = _httpContext.HttpContext.User.Claims.FirstOrDefault(f => f.Type == "UserName").Value; model.LastUpdateTime = DateTime.Now; // TODO: User model.LastUpdateUser = ""; await _managementContext.GoodsExtendFields.AddAsync(model); if (await _managementContext.SaveChangesAsync() > 0) { return(model); } return(null); }
public bool Update(SubCompany subCompany) { try { _mgmtContext.Update(subCompany); _mgmtContext.SaveChangesAsync(); return(true); } catch (InvalidOperationException ioe) { Debug.WriteLine("Message " + ioe.Message); return(false); } catch (DbUpdateConcurrencyException dce) { Debug.WriteLine("Message " + dce.Message); return(false); } }
public async Task <ActionResult <LoginResponse> > Login(LoginRequest request) { ManagementModel model = null; using (var db = new ManagementContext()) { model = await db.management .Where(x => x.username.Contains(request.username)) .SingleAsync(); if (model == null) { return(NotFound()); } // ハッシュ計算を行う string hash = calclateHashValue(request.password); if (!hash.Contains(model.hashnum)) { return(BadRequest()); } // トークンを生成する DateTime dt = DateTime.Now; model.token = Token.createToken(); model.token_update = dt; model.last_login = dt; db.management.Update(model); await db.SaveChangesAsync(); return(new LoginResponse() { token = model.token }); } }