public MTasks GetById(int id)
{
FileStream fs = new FileStream(this.filepath, FileMode.OpenOrCreate);
StreamReader sr = new StreamReader(fs);
try
{
while (!sr.EndOfStream)
{
MTasks user = new MTasks();
user.TaskId = Convert.ToInt32(sr.ReadLine());
user.Title = sr.ReadLine();
user.Description = sr.ReadLine();
user.Creator = Convert.ToInt32(sr.ReadLine());
user.EstTime = Convert.ToInt32(sr.ReadLine());
user.Assigned = Convert.ToInt32(sr.ReadLine());
user.CreTime = Convert.ToDateTime(sr.ReadLine());
if (user.Assigned == id)
{
return(user);
}
}
}
finally
{
sr.Close();
fs.Close();
}
return(null);
}
private int GetNextTaskId()
{
int id = 1;
FileStream fs = new FileStream(this.filepath, FileMode.OpenOrCreate);
StreamReader sr = new StreamReader(fs);
try
{
while (!sr.EndOfStream)
{
MTasks user = new MTasks();
user.TaskId = Convert.ToInt32(sr.ReadLine());
user.Title = sr.ReadLine();
user.Description = sr.ReadLine();
user.Creator = Convert.ToInt32(sr.ReadLine());
user.EstTime = Convert.ToInt32(sr.ReadLine());
user.Assigned = Convert.ToInt32(sr.ReadLine());
user.CreTime = Convert.ToDateTime(sr.ReadLine());
if (id <= user.TaskId)
{
id = user.TaskId + 1;
}
}
return(id);
}
finally
{
sr.Close();
fs.Close();
}
}
public List <MTasks> GetAll()
{
List <MTasks> result = new List <MTasks>();
FileStream fs = new FileStream(this.filepath, FileMode.OpenOrCreate);
StreamReader sr = new StreamReader(fs);
try
{
while (!sr.EndOfStream)
{
MTasks user = new MTasks();
user.TaskId = Convert.ToInt32(sr.ReadLine());
user.Title = sr.ReadLine();
user.Description = sr.ReadLine();
user.Creator = Convert.ToInt32(sr.ReadLine());
user.EstTime = Convert.ToInt32(sr.ReadLine());
user.Assigned = Convert.ToInt32(sr.ReadLine());
user.CreTime = Convert.ToDateTime(sr.ReadLine());
result.Add(user);
}
}
finally
{
sr.Close();
fs.Close();
}
return(result);
}
public void Tasks()
{
MTasks user = new MTasks();
TasksMenu taskView = new TasksMenu(user);
taskView.ShowTM();
}
private void Edit(MTasks item)
{
string tempFilePath = "temp." + filepath;
FileStream ifs = new FileStream(filepath, FileMode.OpenOrCreate);
StreamReader sr = new StreamReader(ifs);
FileStream ofs = new FileStream(tempFilePath, FileMode.OpenOrCreate);
StreamWriter sw = new StreamWriter(ofs);
try
{
while (!sr.EndOfStream)
{
MTasks user = new MTasks();
user.TaskId = Convert.ToInt32(sr.ReadLine());
user.Title = sr.ReadLine();
user.Description = sr.ReadLine();
user.Creator = Convert.ToInt32(sr.ReadLine());
user.EstTime = Convert.ToInt32(sr.ReadLine());
user.Assigned = Convert.ToInt32(sr.ReadLine());
user.CreTime = Convert.ToDateTime(sr.ReadLine());
user.Final = Convert.ToBoolean(sr.ReadLine());
if (user.TaskId != item.TaskId)
{
sw.WriteLine(user.TaskId);
sw.WriteLine(user.Title);
sw.WriteLine(user.Description);
sw.WriteLine(user.Creator);
sw.WriteLine(user.EstTime);
sw.WriteLine(user.Assigned);
sw.WriteLine(user.CreTime);
sw.WriteLine(user.Final);
}
else
{
sw.WriteLine(item.TaskId);
sw.WriteLine(item.Title);
sw.WriteLine(item.Description);
sw.WriteLine(item.Creator);
sw.WriteLine(item.EstTime);
sw.WriteLine(item.Assigned);
sw.WriteLine(item.CreTime);
sw.WriteLine(item.Final);
}
}
}
finally
{
sw.Close();
ofs.Close();
sr.Close();
ifs.Close();
}
File.Delete(filepath);
File.Move(tempFilePath, filepath);
}
private void SetTimeSources()
{
MTasks user = (MTasks)tasksBindingSource1.Current;
MTasksRepo gat = new MTasksRepo();
timeBindingSource.DataSource = gat.GetTTime(user);
dataGridView2.DataSource = timeBindingSource;
}
private void tsMainNew_Click(object sender, EventArgs e)
{
MTasks item = new MTasks();
NewTask newTask = new NewTask(item);
if (newTask.ShowDialog() == DialogResult.OK)
{
this.NewTask(item);
SetDataSources();
}
}
public void Save(MTasks item)
{
if (item.TaskId > 0)
{
Edit(item);
}
else
{
Add(item);
}
}
public EditTask(MTasks task)
{
InitializeComponent();
this.task = task;
this.textBox1.Text = task.Title;
this.richTextBox1.Text = task.Description;
this.textBox2.Text = Convert.ToString(task.EstTime);
SetDataSources();
this.comboBox1.SelectedValue = task.Assigned;
}
public void Save(MTasks task)
{
if (task.TaskId > 0)
{
Edit(task);
}
else
{
Add(task);
}
}
public void Delete(MTasks item)
{
using (var db = new BloggingContext())
{
var task =
(from m in db.MTasks
where m.TaskId == item.TaskId
select m).First();
db.MTasks.Remove(task);
db.SaveChanges();
}
}
private void New(MTasks item)
{
using (var db = new BloggingContext())
{
var now = DateTime.Now;//.ToString("MM/dd/yyyy HH:mm:ss");
var task = new MTasks {
Title = item.Title, Description = item.Description, Creator = item.Creator, EstTime = item.EstTime, Assigned = item.Assigned, CreTime = now, Final = false
};
db.MTasks.Add(task);
db.SaveChanges();
}
}
public List <TimeSpent> GetTTime(MTasks item)
{
using (var db = new BloggingContext())
{
// MTasks user = (MTasks)tasksBindingSource1.Current;
var result =
(from t in db.TimeSpent
where t.TheTask == item.TaskId
select t).ToList();
return(result);
}
}
private void DeleteTask(MTasks task)
{
using (var db = new Index.BloggingContext())
{
var item =
(from m in db.MTasks
where m.TaskId == task.TaskId
select m).First();
db.MTasks.Remove(item);
db.SaveChanges();
}
}
private void NewTask(MTasks task)
{
using (var db = new Index.BloggingContext())
{
var now = DateTime.Now;//.ToString("MM/dd/yyyy HH:mm:ss");
var item = new MTasks {
Title = task.Title, Description = task.Description, Creator = task.Creator, EstTime = task.EstTime, Assigned = task.Assigned, CreTime = now, Final = false
};
db.MTasks.Add(item);
db.SaveChanges();
}
}
private List <TimeSpent> GetTTime()
{
using (var db = new Index.BloggingContext())
{
MTasks user = (MTasks)tasksBindingSource1.Current;
var result =
(from t in db.TimeSpent
where t.TheTask == user.TaskId
select t).ToList();
return(result);
}
}
private void toolStripButton3_Click_1(object sender, EventArgs e)
{
Int32 selectedRowCount = dataGridView1.Rows.GetRowCount(DataGridViewElementStates.Selected);
if (selectedRowCount > 0)
{
MTasks task = (MTasks)tasksBindingSource1.Current;
task.Final = Convert.ToBoolean(true);
this.EditTask(task);
SetDataSources();
}
}
public void FinishTask(MTasks item)
{
using (var db = new BloggingContext())
{
var task =
(from m in db.MTasks
where m.TaskId == item.TaskId
select m).First();
db.Database.ExecuteSqlCommand("UPDATE MTasks" +
" SET Final={0}" +
" WHERE TaskId={1}", true, item.TaskId);
db.SaveChanges();
}
}
private void FinishTask(MTasks task)
{
using (var db = new Index.BloggingContext())
{
var item =
(from m in db.MTasks
where m.TaskId == task.TaskId
select m).First();
db.Database.ExecuteSqlCommand("UPDATE MTasks" +
" SET Final={0}" +
" WHERE TaskId={1}", true, task.TaskId);
db.SaveChanges();
}
}
private void EditTask(MTasks task)
{
using (var db = new Index.BloggingContext())
{
var item =
(from m in db.MTasks
where m.TaskId == task.TaskId
select m).First();
db.Database.ExecuteSqlCommand("UPDATE MTasks" +
" SET Title={0},Description={1},EstTime={2},Assigned={3},Final={4}" +
" WHERE TaskId={5}", task.Title, task.Description,
task.EstTime, task.Assigned, task.Final, task.TaskId);
db.SaveChanges();
}
}
private void tsMainDelete_Click(object sender, EventArgs e)
{
Int32 selectedRowCount = dataGridView1.Rows.GetRowCount(DataGridViewElementStates.Selected);
if (selectedRowCount > 0)
{
DialogResult result = MessageBox.Show("Are you sure you want to delete this item", "Delete item", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
MTasks user = (MTasks)tasksBindingSource1.Current;
this.DeleteTask(user);
SetDataSources();
}
}
}
private void tsMainEdit_Click(object sender, EventArgs e)
{
Int32 selectedRowCount = dataGridView1.Rows.GetRowCount(DataGridViewElementStates.Selected);
if (selectedRowCount > 0)
{
MTasks task = (MTasks)tasksBindingSource1.Current;
EditTask editTask = new EditTask(task);
if (editTask.ShowDialog() == DialogResult.OK)
{
this.EditTask(task);
SetDataSources();
}
}
}
private void Add()
{
Console.Clear();
MTasks user = new MTasks();
bool Status = false;
try
{
Console.WriteLine("Add new task");
Console.Write("+Title: ");
user.Title = Console.ReadLine();
Console.Write("+Whats the task: ");
user.Description = Console.ReadLine();
user.Creator = Login.LoggedUser.UserId;
Console.Write("+Finish time: ");
user.EstTime = int.Parse(Console.ReadLine());
Console.Write("+Assigne to: ");
user.Assigned = int.Parse(Console.ReadLine());
DateTime saveNow = DateTime.Now;
user.CreTime = saveNow;
Console.WriteLine();
Status = true;
}
catch (Exception ex)
{
Console.Clear();
Console.WriteLine(ex.Message);
Console.ReadKey(true);
Status = false;
}
Users item = new Users();
UserRepo userRepo = new UserRepo(filepath);
item = userRepo.GetById(user.Assigned);
if (Status == true && item.UserId > 0)
{
TaskRepo taskRepository = new TaskRepo(tasksFilepath);
taskRepository.Save(user);
Console.WriteLine("Task added successfully");
Console.ReadKey(true);
}
}
private void Add(MTasks item)
{
item.TaskId = GetNextTaskId();
FileStream fs = new FileStream(filepath, FileMode.Append);
StreamWriter sw = new StreamWriter(fs);
try
{
sw.WriteLine(item.TaskId);
sw.WriteLine(item.Title);
sw.WriteLine(item.Description);
sw.WriteLine(item.Creator);
sw.WriteLine(item.EstTime);
sw.WriteLine(item.Assigned);
sw.WriteLine(item.CreTime);
}
finally
{
sw.Close();
fs.Close();
}
}
public NewTask(MTasks task)
{
InitializeComponent();
this.item = task;
SetDataSources();
}
public TasksMenu(MTasks user)
{
this.user = user;
}
