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