static void Main(string[] args)
{
var outputFile = new FileInfo("db_management.dat");
if (outputFile.Exists)
{
outputFile.Delete();
}
using (var fileStream = outputFile.OpenWrite())
{
using (var streamWriter = new StreamWriter(fileStream))
{
using (var dbContext = new TaskManagementContext())
{
foreach (var task in dbContext.Tasks.Where(t => t.Employee.Login != "slawek"))
{
var dbManagementRow = new DbManagementRow {
Employee = task.Employee.Login,
Area = task.Area.Name.GetEnum <AreaName>()
};
foreach (var taskSkill in task.TaskSkills)
{
dbManagementRow.CheckValue(taskSkill.Skill.Name);
}
streamWriter.WriteLine(dbManagementRow.ToString());
}
}
}
}
}
public IEnumerable <Models.Task> GetTask()
{
using (var context = new TaskManagementContext())
{
return(context.Task.ToList());
}
}
public IActionResult AddTask([FromBody] Task task)
{
if (ModelState.IsValid)
{
using (var context = new TaskManagementContext())
{
context.Task.Add(task);
context.SaveChanges();
}
}
return(StatusCode(200, "Task inserted."));
}
public IActionResult DeleteTask(int id)
{
if (ModelState.IsValid)
{
using (var context = new TaskManagementContext())
{
var tsk = context.Task.Where(t => t.Id == id).FirstOrDefault <Task>();
if (tsk != null)
{
context.Task.Remove(tsk);
context.SaveChanges();
}
}
}
return(StatusCode(200, "Task updated."));
}
public IActionResult UpdateTask([FromBody] Task task)
{
if (ModelState.IsValid)
{
using (var context = new TaskManagementContext())
{
var tsk = context.Task.Where(t => t.Id == task.Id).FirstOrDefault <Task>();
if (tsk != null)
{
tsk.Description = task.Description;
tsk.ShortDescription = task.ShortDescription;
context.SaveChanges();
}
}
}
return(StatusCode(200, "Task updated."));
}
public async Task <IHttpActionResult> Patch([FromODataUri] int key, Delta <IterationOrSprint> delta)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//var iteration = await _iterationService.GetById(key);//_db.ContactType.Single(t => t.ContactTypeID == key);
//_db.SaveChanges();
using (var ctx = new TaskManagementContext())
{
var iteration = ctx.IterationOrSprints.SingleOrDefault(x => x.Id == key);
delta.Patch(iteration);
await ctx.SaveChangesAsync();
return(Updated(iteration));
}
}
public TaskStatusRepository(TaskManagementContext context)
: base(context)
{
this._context = context;
}
public void Guncelle(Tablo tablo)
{
using var context = new TaskManagementContext();
context.Set <Tablo>().Update(tablo);
context.SaveChanges();
}
internal EmployeeTypeRepository(TaskManagementContext context) : base(context)
{
}
internal CustomerRepository(TaskManagementContext context) : base(context)
{
_context = context;
}
public TaskLogRepository(TaskManagementContext context)
: base(context)
{
_context = context;
}
internal EmployeeRepository(TaskManagementContext context) : base(context)
{
_context = context;
}
public Tablo GetirId(int id)
{
using var context = new TaskManagementContext();
return(context.Set <Tablo>().Find(id));
}
public RequestRepository(TaskManagementContext context) : base(context)
{
_context = context;
}
public void Kaydet(Tablo tablo)
{
using var context = new TaskManagementContext();
context.Set <Tablo>().Add(tablo);
context.SaveChanges();
}
public ProjectRepository(TaskManagementContext context) : base(context)
{
}
public CustomerRepository(TaskManagementContext context) : base(context)
{
}
internal CustomerRequestRepository(TaskManagementContext context) : base(context)
{
}
public CustomerEmployeeRepository(TaskManagementContext context) : base(context)
{
_context = context;
}
public BaseRepository(TaskManagementContext context)
{
_context = context;
}
public ProjectsController(TaskManagementContext context)
{
_context = context;
}
public TaskRepo(TaskManagementContext db)
{
_db = db;
}
internal TasksRepository(TaskManagementContext context) : base(context)
{
}
public RequestTypeRepository(TaskManagementContext context) : base(context)
{
}
public List <Tablo> GetirTum()
{
using var context = new TaskManagementContext();
return(context.Set <Tablo>().ToList());
}
public CommentController(TaskManagementContext context)
{
_context = context;
}
public RoleRepository(TaskManagementContext context) : base(context)
{
}
public void Sil(Tablo tablo)
{
using var context = new TaskManagementContext();
context.Set <Tablo>().Remove(tablo);
context.SaveChanges();
}
internal ProjectEmployeesRepository(TaskManagementContext context) : base(context)
{
_context = context;
}
public TaskRepo()
{
_db = new TaskManagementContext();
}
