public IHttpActionResult Put(int id, Task task) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != task.Id) { return(BadRequest()); } db.Entry(task).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!DoesTaskExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
// PUT api/Default/5 public Task PutTask(int id, Task task) { if (!ModelState.IsValid) { throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState)); } if (id != task.TaskId) { throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.BadRequest)); } db.Entry(task).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException ex) { throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound, ex)); } return(task); }
public IActionResult Create(Domain.Task task) { task.AddedOn = DateTime.UtcNow; _tasksContext.Tasks.Add(task); _tasksContext.SaveChanges(); return(RedirectToAction("Index")); }
public IActionResult Student(Student S, IFormFile Image, IFormFile Cv) { bool x = mydb.Student.Where(a => a.Email == S.Email).Any(); if (x) { ViewBag.Message = "Email Already Exists"; return(View()); } string path = _env.WebRootPath + "/Data/StudentsImages/"; var E = Path.GetExtension(Image.FileName); var Name = DateTime.Now.ToString("yymmddhhmmss") + E; var f = new FileStream(path + E, FileMode.Create); Image.CopyTo(f); f.Close(); S.Image = "/Data/StudentsImages/" + Name; string C = _env.WebRootPath + "/Data/StudentsDocuments/"; var O = Path.GetExtension(Cv.FileName); var N = DateTime.Now.ToString("yymmhhddmmss") + O; var fs = new FileStream(C + O, FileMode.Create); Cv.CopyTo(fs); fs.Close(); S.Cv = "/Data/StudentsDocuments/" + N; try { var msg = new MailMessage(); msg.From = new MailAddress("Registration Mail"); msg.To.Add(new MailAddress(S.Email)); msg.CC.Add(new MailAddress("*****@*****.**")); msg.Subject = "Registration Mail"; msg.Body = "Dear" + @S.Name + "Thanks" + "For" + "Registration"; msg.IsBodyHtml = true; if (!string.IsNullOrEmpty(@S.Image)) { msg.Attachments.Add(new Attachment(path + Name)); } if (!string.IsNullOrEmpty(@S.Cv)) { msg.Attachments.Add(new Attachment(C + N)); } SmtpClient sc = new SmtpClient(); sc.Credentials = new System.Net.NetworkCredential(); sc.Host = "smtp.gmail.com"; sc.Port = 587; sc.EnableSsl = true; sc.Send(msg); } catch (Exception w) { } mydb.Student.Add(S); mydb.SaveChanges(); return(View()); }
public async Task <T> Save(T e) { await this._dbSet.AddAsync(e); _context.SaveChanges(); return(await Task.FromResult(e)); }
public void PutTaskModel(TaskModel taskModel) { if (ModelState.IsValid) { db.Entry(taskModel).State = EntityState.Modified; db.SaveChanges(); } }
public IActionResult Teacher(Teacher T, IFormFile Image, IFormFile Cv) { bool Email = mydb.Teacher.Where(p => p.Email == T.Email).Any(); if (Email) { ViewBag.Message = "Email Already Exists"; return(View()); } string path = _env.WebRootPath + "/Data/TeachersImages/"; var FileExt = Path.GetExtension(Image.FileName); var Name = DateTime.Now.ToString("yymmddhhmmss") + FileExt; var fs = new FileStream(path + FileExt, FileMode.Create); Image.CopyTo(fs); fs.Close(); T.Image = "/Data/TeachersImages/"; string pa = _env.WebRootPath + "/Data/TeachersDocuments/"; string N = Path.GetExtension(Cv.FileName); string Na = DateTime.Now.ToString("yymmddhhmmss") + FileExt; FileStream f = new FileStream(pa + N, FileMode.Create); Cv.CopyTo(f); f.Close(); T.Cv = "/Data/TeachersDocuments/" + Na; mydb.Teacher.Add(T); mydb.SaveChanges(); var msg = new MailMessage(); msg.From = new MailAddress("*****@*****.**", "Registration Mail"); msg.To.Add(new MailAddress(T.Email)); msg.CC.Add(new MailAddress("*****@*****.**")); msg.Subject = "ragistration Mail"; msg.Body = "Dear" + T.Name + "Thanks For Registration"; msg.IsBodyHtml = true; if (!string.IsNullOrEmpty(@T.Image)) { msg.Attachments.Add(new Attachment(path + T.Image)); } SmtpClient sc = new SmtpClient(); sc.Credentials = new System.Net.NetworkCredential("*****@*****.**", "88669966@@"); sc.Host = "smpt.gmail.com"; sc.Port = 587; sc.EnableSsl = true; sc.Send(msg); return(View()); }
public ActionResult Create([Bind(Include = "Id,TaskName,ResponsibleName,Description,StartTime,EndTime")] Tasks tasks) { if (ModelState.IsValid) { db.MyTasks.Add(tasks); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tasks)); }
public ActionResult Create([Bind(Include = "Id,Name,Title,Description,FinishDate,Status")] Tasks tasks) { if (ModelState.IsValid) { db.Tasks.Add(tasks); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tasks)); }
public UsuarioDto Add(UsuarioDto dto) { if (!dto.Validar(_usuarioValidator).IsValid) { return(dto); } dto.Senha = EncryptProvider.Md5(dto.Senha); _context.Add(MontarEntidade(dto)); _context.SaveChanges(); return(dto); }
public TaskDto Add(TaskDto dto) { if (!dto.Validar(_taskValidator).IsValid) { return(dto); } _context.Tasks.Add(MontarEntidade(dto)); _context.SaveChanges(); return(dto); }
public ActionResult Create([Bind(Include = "ID,Title,SavedDates,Created,Modified,Expired")] Task task) { if (ModelState.IsValid) { task.Modified = DateTime.UtcNow; task.SavedDates = $"N: {DateTime.UtcNow} || M: {task.Modified} || X: {task.Expired}"; db.Tasks.Add(task); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(task)); }
public ActionResult Create(User user) { if (ModelState.IsValid) { db.Users.Add(user); db.SaveChanges(); return(RedirectToAction("Index")); } SelectList roles = new SelectList(db.Roles, "Id", "Name"); ViewBag.Roles = roles; return(View(user)); }
public static void CreateInitialData(TasksContext ctx) { Task task1 = new Task { Name = "task1" }; Task task2 = new Task { Name = "task2" }; Task task3 = new Task { Name = "task3" }; ctx.Tasks.AddRange(new HashSet <Task> { task1, task2, task3 }); Category c1 = new Category { Name = "Category 1" }; Category c2 = new Category { Name = "Category 2" }; Category c3 = new Category { Name = "Category 3" }; ctx.Categories.AddRange(new HashSet <Category> { c1, c2, c3 }); ctx.SaveChanges(); task1.TaskCategories.Add(new TaskCategory { CategoryId = c1.Id, TaskId = task1.Id }); task2.TaskCategories.Add(new TaskCategory { CategoryId = c1.Id, TaskId = task2.Id }); task2.TaskCategories.Add(new TaskCategory { CategoryId = c2.Id, TaskId = task2.Id }); task3.TaskCategories.Add(new TaskCategory { CategoryId = c2.Id, TaskId = task3.Id }); task3.TaskCategories.Add(new TaskCategory { CategoryId = c3.Id, TaskId = task3.Id }); ctx.SaveChanges(); }
public async Task <IActionResult> AddTask(TaskInfo task) { if (ModelState.IsValid) { var user = await userManager.GetUserAsync(User); task.UserId = user.Id; db.TaskInfos.Add(task); db.SaveChanges(); return(RedirectToAction("Index")); } return(BadRequest()); }
public IHttpActionResult Register(RegisterDTO _user) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } else { var users = _db.Users.ToList().Find(u => u.Username == _user.Username); if (users != null) { return(BadRequest("Username already Exists")); } else { User u = new User(); u.Username = _user.Username; u.Password = _user.Password; _db.Users.Add(u); _db.SaveChanges(); return(Ok("User Added")); } } }
public async Task Read_Returns_Result() { Random rand = new Random(); int initialCount; using (var context = new TasksContext(_options)) { initialCount = context.Todos.Count(); context.Todos.Add(new Todo() { ID = rand.Next(), Description = "First", Completed = true }); context.Todos.Add(new Todo() { ID = rand.Next(), Description = "Second", Completed = true }); context.Todos.Add(new Todo() { ID = rand.Next(), Description = "Third", Completed = true }); context.SaveChanges(); } using (var context = new TasksContext(_options)) { var service = new TodoService(context); var todos = await service.Read(); Assert.AreEqual(initialCount + 3, todos.Count()); } }
public TEntity Save() { _context.Add(_entity); _context.Entry(_entity).State = EntityState.Added; _context.SaveChanges(); return(_entity); }
public void Should_Create_Database_From_TasksContext() { using (var ctx = new TasksContext()) { ctx.Categories.Add(new Category() {Color = Color.Red, Name = "ISEL"}); ctx.SaveChanges(); } }
public ActionResult AddNewTask(Tasks task) { // saved taskDb.tasks.Add(task); taskDb.SaveChanges(); return(RedirectToRoute(new { controller = "Home", action = "Index" })); }
public void Post([FromBody] Task task) { using (var context = new TasksContext()) { context.Tasks.Add(task); context.SaveChanges(); } }
public JsonResult TaskInstanceSolved([FromRoute] Guid id, [FromQuery] string result) { var instance = _context.TaskInstances.FirstOrDefault(i => i.Id == id); instance.Finished = true; instance.Resoult = result; _context.SaveChanges(); return(GetTaskInstance(instance.TaskId)); }
public void Delete(int id) { using (var context = new TasksContext()) { Task taskToDelete = context.Tasks.Find(id); context.Remove(taskToDelete); context.SaveChanges(); } }
public void Put(int id, [FromBody] Task task) { using (var context = new TasksContext()) { Task taskToChange = context.Tasks.Find(id); taskToChange.State = task.State; context.SaveChanges(); } }
public MainWindow() { InitializeComponent(); using (var context = new TasksContext()) { context.Tasks.ToList(); context.SaveChanges(); } }
public void Update(Todo model) { using (_context) { _context.Todos.Attach(model); _context.Entry(model).State = EntityState.Modified; _context.SaveChanges(); } }
public void Seed() { context.Database.EnsureCreated(); if (!context.Thoughts.Any()) { context.Add(User.GetDefaultUser()); context.SaveChanges(); } context.Thoughts.RemoveRange(context.Thoughts); context.SaveChanges(); if (!context.Thoughts.Any()) { var thoughts = getThoughts(); context.Thoughts.AddRange(thoughts); context.SaveChanges(); } }
static void InsertProjectTask(string name, TasksContext context) { ProjectTask projectTask = new ProjectTask() { Id = Guid.NewGuid(), Name = name, IsProjectTask = true, ProjectName = "My Project", PWAInstance = "ILABS" }; context.Tasks.Add(projectTask); context.SaveChanges(); }
public AutenticacaoDoLogin FazerLogin(LoginDto loginDto) { bool credenciaisValidas = false; UsuarioDto usuarioBase = new UsuarioDto(); if (loginDto != null && !string.IsNullOrWhiteSpace(loginDto.Login)) { usuarioBase = _usuarioServices.GetByEmail(loginDto.Login); credenciaisValidas = usuarioBase.Id != Guid.Empty && !usuarioBase.Excluido && loginDto.Login == usuarioBase.Email && EncryptProvider.Md5(loginDto.Senha).ToUpper() == usuarioBase.Senha.ToUpper(); } if (credenciaisValidas) { var dataDeExpiracao = DateTime.Now.AddDays(1); var tokenHandler = new JwtSecurityTokenHandler(); var key = Encoding.ASCII.GetBytes(_appSettings.Secret); var tokenDescriptor = new SecurityTokenDescriptor { Subject = new ClaimsIdentity(new Claim[] { new Claim(ClaimTypes.Name, usuarioBase.Id.ToString()) }), Expires = dataDeExpiracao, SigningCredentials = new SigningCredentials(new SymmetricSecurityKey(key), SecurityAlgorithms.HmacSha256Signature) }; var tokenObj = tokenHandler.CreateToken(tokenDescriptor); var token = tokenHandler.WriteToken(tokenObj); _context.SaveChanges(); return(new AutenticacaoDoLogin { Autenticado = true, DataDeCriacao = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), DataDeExpiracao = dataDeExpiracao.ToString("yyyy-MM-dd HH:mm:ss"), TokenDeAcesso = token, Mensagem = "OK", UsuarioId = usuarioBase.Id, Usuario = usuarioBase.Apelido, }); } else { return(new AutenticacaoDoLogin { Autenticado = false, Mensagem = "Falha ao autenticar" }); } }
static void InsertTrelloTask(string name, TasksContext context) { TrelloTask trelloTask = new TrelloTask() { Id = Guid.NewGuid(), Name = name, Description = "Description da trello task 1", IsTrelloTask = true, BoardName = "Board teste", BoardId = "xyz" }; context.Tasks.Add(trelloTask); context.SaveChanges(); }
private void TaskButtonClick(object sender, RoutedEventArgs e) { try { Date = (DateTime)calendar.SelectedDate; DateTime time = (DateTime)timePicker.SelectedTime; Date = Date.AddHours(time.Hour).AddMinutes(time.Minute); } catch (Exception) { Date = DateTime.Now; } using (var context = new TasksContext()) { context.Tasks.Add ( new Models.Task { DateTime = Date.ToString("g"), IsDownloadFile = downloadRadioButton.IsChecked, IsMoveCatalog = moveRadioButton.IsChecked, IsEmailSend = emailRadioButton.IsChecked, IsSingly = singlyRadioButton.IsChecked, IsAnnually = annuallyRadioButton.IsChecked, IsDaily = dailyRadioButton.IsChecked, IsWeekly = weeklyRadioButton.IsChecked, Url = urlTextBox.Text, WhereDownload = whereDownloadTextBox.Text, WhatCopyCatalog = whatCopyCatalogTextBox.Text, WhereCopyCatalog = whereCopyCatalogTextBox.Text, ToEmail = toEmailTextBox.Text, Thema = thema.Text, Attachment = PathAttachment } ); context.SaveChanges(); } }