public async Task <ActionResult> Create([Bind(Include = "Id,PicturePath,Name,Description,Cost,LifeStatus,Sex")] Character character) { if (!User.IsInRole("Admin")) { return(RedirectToAction("Login", "Account")); } if (ModelState.IsValid) { if (Request.Files[0].FileName != "") { character.PicturePath = Request.Files[0].FileName; Request.Files[0].SaveAs(Server.MapPath("~") + "/Content/Images/" + character.PicturePath); } else { character.PicturePath = Server.MapPath("~") + "/Content/Images/peppa.jpg"; } db.Characters.Add(character); await db.SaveChangesAsync(); return(RedirectToAction("List", "Character")); } return(RedirectToAction("List", "Character")); }
public async Task <string> SaveHotelTypeAsync(utblMstHotelType model) { try { if (model.HotelTypeID == 0) { db.utblMstHotelTypes.Add(model); await db.SaveChangesAsync(); return("New Hotel Type Added"); } else { utblMstHotelType curObj = await db.utblMstHotelTypes.FindAsync(model.HotelTypeID); curObj.HotelTypeName = model.HotelTypeName; curObj.BaseFare = model.BaseFare; await db.SaveChangesAsync(); return("Hotel Type Details Updated"); } } catch (Exception ex) { return("Error: " + ex.Message); } }
public virtual async Task <List <TEntity> > BulkInsert(List <TEntity> entity) { dbSet.AddRange(entity); await context.SaveChangesAsync(); return(entity); }
public async Task AddFlight(FlightModel flightModel) { var flight = _mapper.Map <Flight>(flightModel); await _context.Flights.AddAsync(flight); await _context.SaveChangesAsync(); }
public async Task <IActionResult> Create(ToDo todo) { todo.DateDue = todo.GetDateDue(todo.DateDue, todo.DateFor); todo.Done = false; todo.DateCreate = DateTime.UtcNow; db.ToDo.Add(todo); todo.LoginUser = User.Identity.Name; await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task DeleteForAnybody(Guid messageId, string userId) { var message = await _context.Messages.FindAsync(messageId); if ((message != null) && (message.AuthorId == userId)) { _context.Messages.Attach(message); _context.Messages.Remove(message); await _context.SaveChangesAsync(); } }
//public async Task<string> EditPackageOfferAsync(EditPackageOffer model) //{ // try // { // var parPOffID = new SqlParameter("@PackageOfferID", model.PackageOffer.PackageOfferID); // var parPacID = new SqlParameter("@PackageID", model.PackageOffer.PackageID); // var parOfferDesc = new SqlParameter("@OfferDesc", model.PackageOffer.OfferDesc); // var parPOffer = new SqlParameter("@OfferPercent", model.PackageOffer.OfferPercent); // var parOfferImgPath = new SqlParameter("@OfferImagePath", model.PackageOffer.OfferImagePath); // var parStart = new SqlParameter("@StartDate", model.PackageOffer.StartDate); // var parEnd = new SqlParameter("@EndDate", model.PackageOffer.EndDate); // return await db.Database.SqlQuery<string>("udspPackageOfferEdit @PackageOfferID,@PackageID,@OfferDesc, @OfferPercent,@OfferImagePath, @StartDate, @EndDate", // parPOffID, parPacID, parOfferDesc, parPOffer, parOfferImgPath, parStart, parEnd).FirstOrDefaultAsync(); // } // catch (Exception ex) // { // return "Error: " + ex.Message; // } //} public async Task <string> DeletePackageOfferAsync(long POID) { try { utblPackageOffer curObj = await db.utblPackageOffers.FindAsync(POID); db.utblPackageOffers.Remove(curObj); await db.SaveChangesAsync(); return("Package Details Removed"); } catch (SqlException ex) { if (ex.Errors.Count > 0) // Assume the interesting stuff is in the first error { switch (ex.Errors[0].Number) { case 547: // Foreign Key violation return("This record has dependencies on other records, so cannot be removed."); default: return("Error: " + ex.Message); } } return("Error while operation. Error Message: " + ex.Message); } catch (Exception ex) { return("Error: " + ex.Message); } }
public async Task AddMark(string userId, Guid flightId) { var user = await _context.Users.FindAsync(userId); var flight = await _context.Flights.FindAsync(flightId); if ((user == null) || (flight == null)) { throw new Exception("User of flight not found"); } var userMark = new UserMark { FlightId = flight.Id, UserId = user.Id }; await _context.UserMarks.AddAsync(userMark); await _context.SaveChangesAsync(); }
public async Task AddMessage(Guid chatId, string text, string authorId, Guid?isAnswerFor) { var chat = await _context.Chats.FindAsync(chatId); var author = await _userManager.FindByIdAsync(authorId); if ((text != null) && (text != "") && (chat != null) && (author != null)) { _context.Messages.Add(new Message { Author = author, DeletedForOwner = false, ChatId = chat.Id, IsAnswerForId = isAnswerFor, TimeStamp = DateTime.Now, Text = text }); await _context.SaveChangesAsync(); } }
public async Task ModifyUser(UserModel u) { var user = await _context.ApplicationsUsers.FindAsync(u.Id); user.UserName = u.UserName; user.Year = u.Year; user.PremiumMarksCount = u.PremiumMarksCount; user.Email = u.Email; await _context.SaveChangesAsync(); }
public async Task <EUser> EnsureFakeUser(EFDBContext context) { EUser user = await context.Users.FirstOrDefaultAsync(u => u.Token == FAKE_USER_TOKEN); if (user == null) { user = MakeFakeUser(); context.Users.Add(user); await context.SaveChangesAsync(); } return(user); }
public async Task SaveFired(Fired Fired) { if (Fired.FiredId == 0) { await _context.Fireds.AddAsync(Fired); } else { _context.Entry(Fired).State = EntityState.Modified; } await _context.SaveChangesAsync(); }
public async Task SaveRank(Rank rank) { if (rank.RankId == 0) { await _context.Ranks.AddAsync(rank); } else { _context.Entry(rank).State = EntityState.Modified; } await _context.SaveChangesAsync(); }
public async Task <IActionResult> Login() { //DEV var user = await new FakeAuthService().EnsureFakeUser(this.eFDBContext); //DEV await eFDBContext.SaveChangesAsync(); await Authenticate(user.Token); return(RedirectToAction("Index", "Home")); }
public async Task SaveDepartment(Department department) { if (department.DepartmentId == 0) { _context.Departments.Add(department); } else { _context.Entry(department).State = EntityState.Modified; } await _context.SaveChangesAsync(); }
public async Task SaveDecree(Decree decree) { if (decree.DecreeId == 0) { _context.Decrees.Add(decree); } else { _context.Entry(decree).State = EntityState.Modified; } await _context.SaveChangesAsync(); }
public async Task SavePosition(Position position) { if (position.PositionId == 0) { _context.Positions.Add(position); } else { _context.Entry(position).State = EntityState.Modified; } await _context.SaveChangesAsync(); }
public async Task SaveStaff(Staff staff) { if (staff.StaffId == 0) { await _context.Staffs.AddAsync(staff); } else { _context.Entry(staff).State = EntityState.Modified; } await _context.SaveChangesAsync(); }
public async Task <TicketModel> ReserveTicket(string userId, Guid flightId, TicketClass ticketClass = TicketClass.econom, int premiumMarksUsedCount = 0) { var flight = _context.Flights.Find(flightId); var user = _context.ApplicationsUsers.Find(userId); int endPrice = flight.Price; if (ticketClass == TicketClass.vip) { endPrice = (int)(endPrice * 1.5f); } if ((user.PremiumMarksCount < premiumMarksUsedCount) || (premiumMarksUsedCount > endPrice)) { return(null); } endPrice -= premiumMarksUsedCount; user.PremiumMarksCount -= premiumMarksUsedCount; var ticket = new Ticket { FlightId = flightId, UserId = userId, PremiumMarksUsedCount = premiumMarksUsedCount, TicketClass = ticketClass, EndPrice = endPrice, IsBought = false }; await _context.Tickets.AddAsync(ticket); flight.PlacesCount += 1; await _context.SaveChangesAsync(); return(_mapper.Map <TicketModel>(ticket)); }
public async Task <string> DeleteGuideAsync(long id) { try { utblTourGuide obj = await db.utblTourGuides.FindAsync(id); db.utblTourGuides.Remove(obj); await db.SaveChangesAsync(); return("Tour Guide Details Removed"); } catch (Exception ex) { return("Error: " + ex.Message); } }
public IActionResult Delete(string parametre) { Guid id = new Guid(parametre); var file = _context.Docs.FirstOrDefault(d => d.Id == id); var childFiles = _context.Docs.Where(d => d.ParentId == file.Id); if (file != null) { foreach (var child in childFiles) { _context.Docs.Remove(child); } _context.Docs.Remove(file); } _context.SaveChangesAsync(); JsonResult json = new JsonResult(parametre); return(json); }
public async Task <string> UpdateClientEnquiryStatusAsync(ClientEnquiryView model) { try { utblClientEnquirie cmodel = await objDB.utblClientEnquiries.Where(x => x.EnquiryCode == model.EnquiryCode).FirstOrDefaultAsync(); cmodel.Status = "Submitted"; await objDB.SaveChangesAsync(); return("Status Updated"); } catch (SqlException ex) { return("Error Message: " + ex.Message); } catch (Exception ex) { return("Error: " + ex.Message); } }
public async Task <IActionResult> CreateDepartment(Department department) { if (department != null) { if (ModelState.IsValid) { await _context.Department.AddAsync(department); await _context.SaveChangesAsync(); return(RedirectToAction("Index", "Home")); } } return(View()); }
public async Task <IActionResult> Register(LoginAndRegisterModel model) { if (ModelState.IsValid) { User user = await context.User.FirstOrDefaultAsync(u => u.Email == model.registerModel.Email); if (user == null) { context.User.Add(new Entity.User { Email = model.registerModel.Email, Name = model.registerModel.Name, Password = model.registerModel.Password }); await context.SaveChangesAsync(); await Authenticate(model.registerModel.Email); return(RedirectToAction("Index", "Home")); } } else { ModelState.AddModelError("", "Некорректные логин или пароль"); } return(View(model)); }
public async Task <IActionResult> Create(Clothes clothes) { if (_userManager.GetUserId(User) == adminId) { if (ModelState.IsValid) { //save image to wwwroot/Image string wwwRootPath = _hostEnvironment.WebRootPath; string fileName = Path.GetFileNameWithoutExtension(clothes.Image.ImageFile.FileName); string extention = Path.GetExtension(clothes.Image.ImageFile.FileName); clothes.Image.ImageName = fileName = fileName + DateTime.Now.ToString("yymmssfff") + extention; string path = Path.Combine(wwwRootPath + "/Image/", fileName); using (var fileStream = new FileStream(path, FileMode.Create)) { await clothes.Image.ImageFile.CopyToAsync(fileStream); } Image img = new Image { ImageName = clothes.Image.ImageName, Title = clothes.Image.Title }; await _context.Images.AddAsync(img); await _context.SaveChangesAsync(); clothes.Image = null; clothes.ImageId = _context.Images.FirstOrDefault(i => i.ImageName == img.ImageName).Id; await _context.Clothes.AddAsync(clothes); await _context.SaveChangesAsync(); } return(RedirectToAction("Index")); } else { return(Permission()); } }
public async Task <string> addCountriesAsync(utblMstCountries model) { try { if (model.CountryID == 0) { objDB.utblMstCountries.Add(model); await objDB.SaveChangesAsync(); return("New Country Details Added"); } else { utblMstCountries curObj = await objDB.utblMstCountries.FindAsync(model.CountryID); curObj.CountryName = model.CountryName; await objDB.SaveChangesAsync(); return("Country Details Updated"); } } catch (Exception ex) { return("Error: " + ex.Message); } }
public async Task PrefillPlaces() { if (eFDBContext.SportObjects.Count <ESportObject>() == 0) { EObjectCategory oc1 = new EObjectCategory() { Name = "Футбольный стадион" }; eFDBContext.ObjectCategories.Add(oc1); EObjectCategory oc2 = new EObjectCategory() { Name = "Баскетбольная площадка" }; eFDBContext.ObjectCategories.Add(oc2); EObjectCategory oc3 = new EObjectCategory() { Name = "Каток" }; eFDBContext.ObjectCategories.Add(oc3); EObjectCategory oc4 = new EObjectCategory() { Name = "Пустырь с кустами и пеньками" }; eFDBContext.ObjectCategories.Add(oc4); ESportObject s1 = new ESportObject() { Name = "Стадион Заря", Description = "Спортивный объект, оборудованный по последнему слову техники", Address = "Спортивная 21", ObjectCategory = oc1, MaxMinRentalUnitsType = 0, MinRentalTime = 1, MaxRentalTime = 10, ImageLink = "", MaxPerson = 100 }; eFDBContext.SportObjects.Add(s1); ESportObject s2 = new ESportObject() { Name = "Каток ЛЁД", Description = "Спортивный объект, оборудованный по последнему слову техники", Address = "Спортивная 22", ObjectCategory = oc2, MaxMinRentalUnitsType = 0, MinRentalTime = 1, MaxRentalTime = 10, ImageLink = "", MaxPerson = 100 }; eFDBContext.SportObjects.Add(s2); ESportObject s3 = new ESportObject() { Name = "Стадион Рассвет", Description = "Спортивный объект, оборудованный по последнему слову техники", Address = "Спортивная 23", ObjectCategory = oc1, MaxMinRentalUnitsType = 0, MinRentalTime = 1, MaxRentalTime = 10, ImageLink = "", MaxPerson = 100 }; eFDBContext.SportObjects.Add(s3); } if (eFDBContext.RentPlaces.Count <ERentPlace>() == 0) { ERentPlace r1 = new ERentPlace() { Name = "Прокат самокатов", Description = "Здесь можно взять самокат на прокат", Address = "Самокатная 11", }; eFDBContext.RentPlaces.Add(r1); ERentPlace r2 = new ERentPlace() { Name = "Прокат велосипедов", Description = "Здесь можно взять велосипед на прокат", Address = "Педальная 31", }; eFDBContext.RentPlaces.Add(r2); ERentPlace r3 = new ERentPlace() { Name = "Прокат лыж", Description = "Здесь можно взять лыжи на прокат", Address = "Лыжная 41", }; eFDBContext.RentPlaces.Add(r3); ERentPlace r4 = new ERentPlace() { Name = "Прокат сноубордов", Description = "Здесь можно взять сноуборд на прокат", Address = "Спусковая 12", }; eFDBContext.RentPlaces.Add(r4); ERentPlace r5 = new ERentPlace() { Name = "Прокат коньков", Description = "Здесь можно взять коньки на прокат", Address = "Конькобежная 56", }; eFDBContext.RentPlaces.Add(r5); } await eFDBContext.SaveChangesAsync(); }