public void add_Task(string input1, string input2, string input3, bool input4)
{
using (var context = new OrganaizerContext())
{
var task = new Task
{
Category = input1,
Compleatet = input4,
Date = input3,
Text = input2
};
context.Tasks.Add(task);
context.SaveChanges();
}
/* SqlConnection sqlConn = new SqlConnection(Server_Setting.DataBase);
* sqlConn.Open();
*
* SqlCommand sqlCmd = new SqlCommand();
* sqlCmd.Connection = sqlConn;
*
* string sql = string.Format("Insert Into dbo.Task " +
* "(Category, Text, Date, Compleated) Values('{0}','{1}','{2}','{3}')",
* input1, input2, input3.ToString() , input4);
*
* using (SqlCommand cmd = new SqlCommand(sql, sqlConn))
* {
* cmd.ExecuteNonQuery();
* }
*
*
* sqlConn.Close();*/
}
public void add_Subtask(int ID, string Text, bool Compleated)
{
using (var context = new OrganaizerContext())
{
var subtask = new Subtask
{
TaskID = ID,
Text = Text,
Compleatet = Compleated
};
context.Subtasks.Add(subtask);
context.SaveChanges();
}
/*SqlConnection sqlConn = new SqlConnection(Server_Setting.DataBase);
* sqlConn.Open();
*
* SqlCommand sqlCmd = new SqlCommand();
* sqlCmd.Connection = sqlConn;
*
* string sql = string.Format("Insert Into dbo.Subtask " +
* "(TaskID,Text, Compleated) Values('{0}','{1}','{2}')",
* ID, Text, Compleated);
*
* using (SqlCommand cmd = new SqlCommand(sql, sqlConn))
* {
* cmd.ExecuteNonQuery();
* }
*
*
* sqlConn.Close();*/
}
public List <SubTaskSt> Show_SubTask(int ID)
{
// context.Configuration.LazyLoadingEnabled = false;
var _subtask = new List <SubTaskSt>();
using (var context = new OrganaizerContext())
{
var query = from subtsk in context.Subtasks
where subtsk.TaskID == ID
select subtsk;
int count = 0;
foreach (var subtask in query)
{
// subtask.Task
count++;
for (int i = 0; i < 1; i += 1)
{
_subtask.Add(
new SubTaskSt()
{
Compleatet = subtask.Compleatet,
Text = subtask.Text,
TaskID = ID,
SubtaskID = subtask.SubtaskID
})
;
}
}
}
return(_subtask);
}
public void Deleted_Task()
{
using (var context = new OrganaizerContext())
{
var query = from task in context.Tasks
where task.Compleatet == true
select task;
foreach (var task in query)
{
context.Tasks.Remove(task);
}
context.SaveChanges();
}
/* SqlConnection sqlConn = new SqlConnection(Server_Setting.DataBase);
* sqlConn.Open();
*
* SqlCommand sqlCmd = new SqlCommand();
* sqlCmd.Connection = sqlConn;
*
* string sql = string.Format("DELETE Task FROM Task WHERE ([Task].[Compleated] = 'True')");
*
* using (SqlCommand cmd = new SqlCommand(sql, sqlConn))
* {
* cmd.ExecuteNonQuery();
* }
*
*
* sqlConn.Close();*/
}
public void Compleated_Task(int ID)
{
using (var context = new OrganaizerContext())
{
var query = from task in context.Tasks
where task.TaskID == ID
select task;
foreach (var task in query)
{
task.Compleatet = true;
}
context.SaveChanges();
}
/* using (SqlConnection sqlConn = new SqlConnection(Server_Setting.DataBase))
* {
* const string sql = ("UPDATE Task SET Compleated = 'True' FROM Task WHERE (Task.TaskID =@ID)");
* SqlCommand sqlCmd = new SqlCommand(sql, sqlConn);
* sqlCmd.Parameters.Add("@ID", SqlDbType.Int).Value = ID;
*
*
* sqlConn.Open();
* sqlCmd.ExecuteNonQuery();
* sqlConn.Close();
* }*/
}
public List <TaskSt> Update_Task(int ID)
{
var _task = new List <TaskSt>();
using (var context = new OrganaizerContext())
{
context.Configuration.LazyLoadingEnabled = false;
context.Tasks.Load();
context.Subtasks.Load();
var query = from task in context.Tasks
select task;
var query1 = from sub in context.Subtasks
where sub.TaskID == ID
select sub;
int count = 0;
foreach (var task in query)
{
count++;
for (int i = 0; i < 1; i += 1)
{
_task.Add(
new TaskSt()
{
Category = task.Category,
Compleatet = task.Compleatet,
Date = task.Date,
Text = task.Text,
TaskID = task.TaskID
})
;
}
}
context.SaveChanges();
}
return(_task);
/* using (SqlConnection sqlConn = new SqlConnection(Server_Setting.DataBase))
* {
* const string sql = ("UPDATE Task SET Compleatet = 'True' FROM Task WHERE 'True' = ALL (SELECT Compleatet FROM Subtask WHERE Subtask.TaskID=Task.TaskID) AND EXISTS (SELECT * FROM Subtask WHERE Subtask.TaskID=Task.TaskID)");
* SqlCommand sqlCmd = new SqlCommand(sql, sqlConn);
*
*
* sqlConn.Open();
* sqlCmd.ExecuteNonQuery();
* }*/
}
