private void btnDo_Click(object sender, EventArgs e) { using (ProjectDBEntities db_entity = new ProjectDBEntities()) { if (type == MainBoard.type.New && txtWorkerName != null) { Worker work = new Worker(txtWorkerName.Text, btnColor.BackColor); Workers w = new Workers(); w.name = work.GetName(); w.color = work.GetColor().Name; w.experience = work.GetExp(); db_entity.Workers.Add(w); } else { Workers worker = db_entity.Workers.FirstOrDefault(w => w.name == cmbWorkers.SelectedItem.ToString()); if (type == MainBoard.type.Edit) { worker.name = txtWorkerName.Text; worker.color = btnColor.BackColor.Name; } else { pnlWorker.Enabled = false; db_entity.Workers.Remove(worker); } } db_entity.SaveChanges(); pnlWorker_Clear(); MessageBox.Show("İşlem BAŞARILI"); } }
public string GetStoryName(int story_id) { using (ProjectDBEntities db_entity = new ProjectDBEntities()) { Storys s = db_entity.Storys.FirstOrDefault(sid => sid.story_id == story_id); return(s.name); } }
Color GetColor(int workerID) { using (ProjectDBEntities db_entity = new ProjectDBEntities()) { var worker = db_entity.Workers.FirstOrDefault(x => x.worker_id == workerID); return(System.Drawing.ColorTranslator.FromHtml(worker.color)); } }
private void Workers_Fetch() { cmbWorkers.Items.Clear(); using (ProjectDBEntities db_entitiy = new ProjectDBEntities()) { var workerQuery = from w in db_entitiy.Workers select w.name; foreach (var worker in workerQuery) { cmbWorkers.Items.Add(worker); } } }
private void cmbStories_SelectedIndexChanged(object sender, EventArgs e) { string currStory = cmbStories.SelectedItem.ToString(); cStry = currStory; using (ProjectDBEntities db_entitiy = new ProjectDBEntities()) { Storys cStory = db_entitiy.Storys.FirstOrDefault(s => s.name == currStory); txtCurrStoryDesc.Text = cStory.description; lblCurrStoryDate.Text = cStory.startingDate.Value.ToShortDateString() + " -Deadline [" + cStory.deadline.ToString() + " Gün]- " + cStory.endingDate.Value.ToShortDateString(); } tasks_fetch(); }
private void Storys_Fetch() { cmbStories.Items.Clear(); using (ProjectDBEntities db_entitiy = new ProjectDBEntities()) { var storyQuery = from w in db_entitiy.Storys select w.name; foreach (var story in storyQuery) { cmbStories.Items.Add(story); } } }
void StoryDetails() { using (ProjectDBEntities db_entity = new ProjectDBEntities()) { string currStory = cmbStories.SelectedItem.ToString(); if (currStory != null) { Storys story = db_entity.Storys.FirstOrDefault(w => w.name == currStory); txtStoryName.Text = story.name; txtStoryDescription.Text = story.description; txtStoryDeadline.Text = story.deadline.ToString(); lblDateNow.Text = story.startingDate.Value.ToShortDateString() + "-" + story.endingDate.Value.ToShortDateString(); } } }
string cStry;// comboboxtan seçilen story // panel oluşturma ve flowlayout panelleri uyarlama void tasks_fetch() { using (ProjectDBEntities db_entity = new ProjectDBEntities()) { FLPClear(); var task_query = from t in db_entity.Tasks select t; foreach (var item in task_query) { Task t = new Task(item.story_id.Value, item.taskName, item.details, item.commitmentDate.Value, item.deadline.Value, item.worker_id.Value); t.EditState(item.state); CreateTaskPanel(t); } } }
private void btnNewTask_Click(object sender, EventArgs e) { using (ProjectDBEntities db_entity = new ProjectDBEntities()) { if (currType == type.New) { string currStory = cmbStories.SelectedItem.ToString(); string currWorker = cmbWorkers.SelectedItem.ToString(); Storys story = db_entity.Storys.FirstOrDefault(s => s.name == currStory); Workers worker = db_entity.Workers.FirstOrDefault(w => w.name == currWorker); Tasks tsk = new Tasks(); Task task = new Task(story.story_id, txtTaskName.Text, txtTaskDetails.Text, dtTaskDate.Value.Date, Convert.ToInt16(txtTaskDeadline.Text), worker.worker_id); tsk.story_id = task.GetStory(); tsk.worker_id = task.GetWorker(); tsk.taskName = task.GetTaskName(); tsk.details = task.GetDetails(); tsk.commitmentDate = task.GetCommitmentDate(); tsk.endingDate = task.GetEndingDate(); tsk.deadline = task.GetDeadline(); tsk.state = task.GetTaskState(); db_entity.Tasks.Add(tsk); CreateTaskPanel(task); } else { Tasks task = db_entity.Tasks.FirstOrDefault(t => t.taskName == currControl.Name); if (currType == type.Edit) { task.taskName = txtTaskName.Text; task.details = txtTaskDetails.Text; task.deadline = Convert.ToInt16(txtTaskDeadline.Text); task.commitmentDate = dtTaskDate.Value.Date; task.endingDate = task.commitmentDate.Value.AddDays(task.deadline.Value); Workers w = db_entity.Workers.FirstOrDefault(v => v.name == cmbWorkers.SelectedItem.ToString()); task.worker_id = w.worker_id; } if (currType == type.Delete) { db_entity.Tasks.Remove(task); } } db_entity.SaveChanges(); MessageBox.Show("İşlem Başarıyla Gerçekleşti."); ResetTaskGroupBox(); Storys_Fetch(); } }
private void cmbWorkers_SelectedIndexChanged(object sender, EventArgs e) { pnlWorker.Visible = true; string workerName = cmbWorkers.SelectedItem.ToString(); using (ProjectDBEntities db_entitiy = new ProjectDBEntities()) { if (type == MainBoard.type.Delete) { pnlWorker.Enabled = false; } Workers workers = db_entitiy.Workers.FirstOrDefault(w => w.name == workerName); txtWorkerName.Text = workers.name; btnColor.BackColor = ColorConvert(workers.color); //btnColor.BackColor = System.Drawing.ColorTranslator.FromHtml(workers.color); } }
void TaskDetails(string taskName) { using (ProjectDBEntities db_entity = new ProjectDBEntities()) { Tasks currTask = db_entity.Tasks.FirstOrDefault(w => w.taskName == taskName); txtTaskName.Text = currTask.taskName; txtTaskDetails.Text = currTask.details; txtTaskDeadline.Text = currTask.deadline.ToString(); Storys story = db_entity.Storys.FirstOrDefault(s => s.story_id == currTask.story_id); Workers worker = db_entity.Workers.FirstOrDefault(w => w.worker_id == currTask.worker_id); cmbWorkers.Text = worker.name; lblStoryAdi.Text = "Story : " + story.name; dtTaskDate.Value = currTask.commitmentDate.Value.Date; } }
//flowlayout panellerin içine atmayı kabul ettirme void panel_DragDrop(object sender, DragEventArgs e) { Control c = e.Data.GetData(e.Data.GetFormats()[0]) as Control; FlowLayoutPanel destination = sender as FlowLayoutPanel; FlowLayoutPanel source = (FlowLayoutPanel)c.Parent; if (c != null) { using (ProjectDBEntities db_entity = new ProjectDBEntities()) { Tasks currTask = db_entity.Tasks.FirstOrDefault(t => t.taskName == currControl.Name); c.Location = destination.PointToClient(new Point(e.X, e.Y)); if (destination == flaypnlBacklog) { currTask.state = TaskState.Backlog; } else if (destination == flaypnlDoing) { currTask.state = TaskState.Doing; } else if (destination == flaypnlDone) { currTask.state = TaskState.Done; } else if (destination == flaypnlSprint) { currTask.state = TaskState.Sprint; } else if (destination == flaypnlTesting) { currTask.state = TaskState.Testing; } else if (destination == flaypnlToDo) { currTask.state = TaskState.ToDo; } destination.Controls.Add(c); db_entity.SaveChanges(); } } }
private void btnCreateStory_Click(object sender, EventArgs e) { using (ProjectDBEntities db_entity = new ProjectDBEntities()) { if (currType == type.New) { Story st = new Story(txtStoryName.Text, txtStoryDescription.Text, int.Parse(txtStoryDeadline.Text)); st.EditEndingDate(st.GetStartingDate(), st.GetDeadline()); Storys st_db = new Storys(); st_db.name = st.GetName(); st_db.description = st.GetDescription(); st_db.startingDate = st.GetStartingDate(); st_db.endingDate = st.GetEndingDate(); st_db.state = st.GetState(); st_db.deadline = st.GetDeadline(); db_entity.Storys.Add(st_db); } else { string currStory = cmbStories.SelectedItem.ToString(); Storys story = db_entity.Storys.FirstOrDefault(w => w.name == currStory); if (currType == type.Edit && currStory != null) { lblDateNow.Text = story.startingDate.ToString(); story.name = txtStoryName.Text; story.description = txtStoryDescription.Text; story.deadline = Convert.ToInt16(txtStoryDeadline.Text); story.endingDate = story.startingDate.Value.AddDays(story.deadline.Value); } if (currType == type.Delete && currStory != null) { db_entity.Storys.Remove(story); } } db_entity.SaveChanges(); MessageBox.Show("İşlem Başarıyla Gerçekleşti."); ResetStoryGroupBox(); Storys_Fetch(); } }