public bool AddCompany(Company company) { context1.Company.Add(company); int RowsAdded = context1.SaveChanges(); return(RowsAdded > 0); }
public IActionResult EditRequest(TrinerRequestModel model, int Id) { var base64 = ""; if (model.Avatar != null) { var tempImage = System.Drawing.Image.FromStream(model.Avatar.OpenReadStream()); var result = Utility.ResizeImage(tempImage, 308, 173); base64 = string.Format("data:image/jpg; base64, {0}", Convert.ToBase64String(Utility.ImageToByte2(result))); model.UserImage = base64; } var request = _context.TrinerRequests.FirstOrDefault(p => p.Id == Id); request.Name = model.Name; request.SurName = model.SurName; request.Phone = model.Phone; request.Email = string.IsNullOrEmpty(model.Email) ? string.Empty : model.Email; request.About = model.About; request.MyRequest = model.MyRequest; request.Accept = true; request.Avatar = string.IsNullOrEmpty(model.UserImage) ? request.Avatar : base64; _context.TrinerRequests.Update(request); _context.SaveChanges(); return(RedirectToAction("TrinerRequestIndex")); }
public void TestShopSaleReadProperly() { //SETUP var options = SqliteInMemory.CreateOptions <CompanyDbContext>(); using (var context = new CompanyDbContext(options, new FakeGetClaimsProvider("accessKey*"))) { context.Database.EnsureCreated(); var company = Company.AddTenantToDatabaseWithSaveChanges("TestCompany", PaidForModules.None, context); var shop = RetailOutlet.AddTenantToDatabaseWithSaveChanges("TestShop", company, context); var shopStock = new ShopStock { Name = "dress", RetailPrice = 12, NumInStock = 2, Shop = shop }; context.Add(shopStock); context.SaveChanges(); //ATTEMPT var status = ShopSale.CreateSellAndUpdateStock(1, shopStock.ShopStockId, context); status.IsValid.ShouldBeTrue(status.GetAllErrors()); context.Add(status.Result); context.SaveChanges(); //VERIFY var salesNotFiltered = context.ShopSales.IgnoreQueryFilters() .Include(x => x.StockItem).ThenInclude(x => x.Shop) .ToList(); salesNotFiltered.Count.ShouldEqual(1); salesNotFiltered.First().StockItem.ShouldNotBeNull(); salesNotFiltered.First().StockItem.Shop.ShouldNotBeNull(); } }
public ActionResult Create([Bind(Include = "ProductID, ProductName, Price, DOP, AvailabilityStatus, CategoryID, BrandID, Active, Photo")] Product product) { //var db = new EFDBFirstDatabaseEntities(); if (!ModelState.IsValid) { ViewBag.Categories = db.Categories.ToList(); ViewBag.Brands = db.Brands.ToList(); return(View()); } if (Request.Files.Count >= 1) { var file = Request.Files[0]; //doesn't work //var imgBytes = new Byte[file.ContentLength - 1]; var imgBytes = new Byte[file.ContentLength]; file.InputStream.Read(imgBytes, 0, file.ContentLength); var base64String = Convert.ToBase64String(imgBytes, 0, imgBytes.Length); product.Photo = base64String; } db.Products.Add(product); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit(Employees Emp, List <Education> education) { if (ModelState.IsValid) { Employees existingEmp = Db.Employees.Where(m => m.EmpId == Emp.EmpId).FirstOrDefault(); existingEmp.EmpName = Emp.EmpName; existingEmp.EmpEmailId = Emp.EmpEmailId; for (int i = 0; i < existingEmp.EmpEdu.Count(); i++) { existingEmp.EmpEdu[i].EduLevel = Emp.EmpEdu[i].EduLevel; existingEmp.EmpEdu[i].EduYOP = Emp.EmpEdu[i].EduYOP; } for (int i = existingEmp.EmpEdu.Count; i < Emp.EmpEdu.Count(); i++) { existingEmp.EmpEdu.Add(Emp.EmpEdu[i]); existingEmp.EmpEdu[i].EduLevel = Emp.EmpEdu[i].EduLevel; existingEmp.EmpEdu[i].EduYOP = Emp.EmpEdu[i].EduYOP; } existingEmp.EmpEdu = Emp.EmpEdu; Db.SaveChanges(); TempData["success"] = "The employee has been successfully added"; return(RedirectToAction("Index", "Home")); } return(View()); }
public bool AddIpo(Ipo ipo) { context.Ipo.Add(ipo); int RowsAdded = context.SaveChanges(); return(RowsAdded > 0); }
public void DeleteDatabase(int id) { var item = _context.RegistrationRequests.FirstOrDefault(p => p.Id == id); _context.RegistrationRequests.Remove(item); _context.SaveChanges(); }
public bool AddStockPrice(StockPrice stockPrice) { context.StockPrice.Add(stockPrice); int RowsAdded = context.SaveChanges(); return(RowsAdded > 0); }
public IActionResult DeleteReview(int Id) { var review = _context.Reviews.FirstOrDefault(p => p.Id == Id); _context.Reviews.Remove(review); _context.SaveChanges(); return(RedirectToAction("Review")); }
public IActionResult DeleteProblem(int Id) { var problem = _context.Problems.FirstOrDefault(p => p.Id == Id); _context.Problems.Remove(problem); _context.SaveChanges(); return(RedirectToAction("ProblemIndex")); }
public IActionResult AddDepartment(Department newDepartment) { if (ModelState.IsValid) { _context.Departments.Add(newDepartment); _context.SaveChanges(); } return(RedirectToAction("Index")); }
public IActionResult AddEmployee(Employee employee) { employee.DepartmentId = 1; if (ModelState.IsValid) { _context.Employees.Add(employee); _context.SaveChanges(); } return(RedirectToAction("Index")); }
public CompanyDTO AddCompany(AddCompanyDTO companyDto) { var company = mapper.Map <Company>(companyDto); dbContext.Add(company); dbContext.SaveChanges(); var result = mapper.Map <CompanyDTO>(company); return(result); }
public ActionResult Create([Bind(Include = "ID,Image,DisplayOrder,Link,Description,CreateDate,CreateBy,ModifiedDate,ModifiedBy,Status")] Slide slide) { if (ModelState.IsValid) { db.Slides.Add(slide); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(slide)); }
public ActionResult Create([Bind(Include = "ID,Name,Description,Detail,Image,CreateDate,CreateBy,ModifiedDate,ModifiedBy,Status")] About about) { if (ModelState.IsValid) { db.Abouts.Add(about); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(about)); }
public ActionResult Create([Bind(Include = "ID,Text,Link,DisplayOrder,Target,Status,TypeID")] Menu menu) { if (ModelState.IsValid) { db.Menus.Add(menu); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(menu)); }
public ActionResult Create([Bind(Include = "ID,Content,Status")] Footer footer) { if (ModelState.IsValid) { db.Footers.Add(footer); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(footer)); }
public ActionResult Create([Bind(Include = "ID,Name,Description,Detail,Status,CreateDate,CreateBy,ModifiedDate,ModifiedBy,ShowOnHome")] CategoryNew categoryNew) { if (ModelState.IsValid) { db.CategoryNews.Add(categoryNew); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(categoryNew)); }
public ActionResult Create([Bind(Include = "ID,Name,Phone,Email,Address,CreateDate,CreateBy,ModifiedDate,ModifiedBy,Content,Status")] Feedback feedback) { if (ModelState.IsValid) { db.Feedbacks.Add(feedback); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(feedback)); }
public ActionResult Create([Bind(Include = "ID,Name")] MenuType menuType) { if (ModelState.IsValid) { db.MenuTypes.Add(menuType); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(menuType)); }
public ActionResult Create([Bind(Include = "ID,Name")] UserGroup userGroup) { if (ModelState.IsValid) { db.UserGroups.Add(userGroup); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(userGroup)); }
public ActionResult Create([Bind(Include = "UserGroupID,RoleID")] Credential credential) { if (ModelState.IsValid) { db.Credentials.Add(credential); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(credential)); }
public ActionResult Create([Bind(Include = "ID,Content,Status")] Contact contact) { if (ModelState.IsValid) { db.Contacts.Add(contact); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(contact)); }
public ActionResult Create([Bind(Include = "ID,Name,Description,Image,Detail,Status,CreateDate,CreateBy,ModifiedDate,ModifiedBy,CategoryServicesID")] Service service) { if (ModelState.IsValid) { service.CreateDate = DateTime.Now; db.Services.Add(service); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(service)); }
public void AddEmployee(int companyId, AddEmployeeDTO employeeDto) { var employee = mapper.Map <Employee>(employeeDto); var company = dbContext.Companies .FirstOrDefault(c => c.Id == companyId && c.IsActive); if (company != null) { company.Employees.Add(employee); dbContext.SaveChanges(); } }
public List <ChatRoomsModel> GetChatRooms() { var id = _context.RegistrationRequests.FirstOrDefault(a => a.Email == User.Identity.Name).Id; List <ChatRoom> foundWithCurrentUserIdRoom = _context.CharRooms.Where(a => (a.CurrentUserId == id)).OrderByDescending(a => a.LastModifiedOn).ToList(); List <ChatRoom> foundInToIdRoom = _context.CharRooms.Where(a => a.ToUserId == id).OrderByDescending(a => a.LastModifiedOn).ToList(); List <ChatRoomsModel> result = new List <ChatRoomsModel>(); foreach (var item in foundWithCurrentUserIdRoom) { var user = _context.RegistrationRequests.FirstOrDefault(a => a.Id == item.ToUserId); if (user == null) { _context.CharRooms.Remove(item); _context.SaveChanges(); continue; } ChatRoomsModel model = new ChatRoomsModel(); model.ChatRoomId = item.Id; model.ToUserUserName = user.Email; model.Image = user.Image; model.ChatRoomData = item.LastModifiedOn; result.Insert(0, model); } foreach (var item in foundInToIdRoom) { var user = _context.RegistrationRequests.FirstOrDefault(a => a.Id == item.CurrentUserId); if (user == null) { _context.CharRooms.Remove(item); _context.SaveChanges(); continue; } ChatRoomsModel model = new ChatRoomsModel(); model.ChatRoomId = item.Id; model.ToUserUserName = user.Email; model.Image = user.Image; model.ChatRoomData = item.LastModifiedOn; result.Insert(0, model); } //return View(result); return(result); }
public ActionResult Create(Product p) { if (Request.Files.Count >= 1) { var file = Request.Files[0]; var imgBytes = new Byte[file.ContentLength]; file.InputStream.Read(imgBytes, 0, file.ContentLength); var base64String = Convert.ToBase64String(imgBytes, 0, imgBytes.Length); p.Photo = base64String; } db.Products.Add(p); db.SaveChanges(); return(RedirectToAction("Index")); }
public int Create(News news) { //Xử lý alias if (string.IsNullOrEmpty(news.MetaTitle)) { news.MetaTitle = StringHelper.ToUnsignString(news.Name); } news.CreateDate = DateTime.Now; news.ModifiedDate = DateTime.Now; db.News.Add(news); db.SaveChanges(); return(news.ID); }
public bool Delete(int id) { try { var menu = db.Menus.Find(id); menu.Deleted = true; menu.ModifiedDate = DateTime.Now; db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public IActionResult Post([FromForm] Administrator admin) { if (admin.Name == "初始化管理员") { throw new Exception("初始化管理员为系统保留名称,不允许使用,请更换"); } admin.Id = admin.Id.ToLower(); if (context.Administrator.Any(a => a.Id == admin.Id)) { throw new Exception(String.Format("登录用户名为 ‘{0}’ 的管理员已存在,请更换", admin.Id)); } if (context.Administrator.Any(a => a.Name == admin.Name)) { throw new Exception(String.Format("名称为 ‘{0}’ 的管理员已存在,请更换", admin.Name)); } //admin.Password = Administrator.ConvertPassword(admin.Password); admin.PasswordChangeTime = DateTime.Now.ToUniversalTime(); context.Administrator.Add(admin); context.SaveChanges(); return(Ok()); }
//[ValidateAntiForgeryToken] public async Task<ActionResult> Register(RegisterViewModel model) { if (ModelState.IsValid) { string org_name = model.CompanyName.Replace(' ', '_'); FileWorker.CreateCompanyRepo(org_name); var user = new ApplicationUser { UserName = model.Email, Email = model.Email, Name = org_name, RegisterDate = DateTime.Now, NextPayment = DateTime.Now.AddMonths(1) }; var result = await UserManager.CreateAsync(user, model.Password); var CompanyDb = new CompanyDbContext(org_name); var fio = model.FIO.Split(' '); CompanyDb.Employees.Add(new Employee() { Surname = fio[0], Name = fio[1], Patronymic = fio[2], Login = model.Email, Password = "" }); CompanyDb.SaveChanges(); if (result.Succeeded) { await SignInManager.SignInAsync(user, isPersistent:false, rememberBrowser:false); // Дополнительные сведения о том, как включить подтверждение учетной записи и сброс пароля, см. по адресу: http://go.microsoft.com/fwlink/?LinkID=320771 // Отправка сообщения электронной почты с этой ссылкой // string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id); // var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme); // await UserManager.SendEmailAsync(user.Id, "Подтверждение учетной записи", "Подтвердите вашу учетную запись, щелкнув <a href=\"" + callbackUrl + "\">здесь</a>"); return Json(Url.Action("Index", "MainPage")); } } return GetErrors(); }