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();
}
}
