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