private void Button_Click_1(object sender, RoutedEventArgs e) // remove button
{
RemovePage myWin = new RemovePage();
myWin.Show();
this.Close();
}
private void DataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
DataGrid gd = (DataGrid)sender;
DataRowView row_selected = gd.SelectedItem as DataRowView;
MessageBoxResult result = MessageBox.Show("Mark This Row Complte? : ", "Mark item Complete", MessageBoxButton.YesNoCancel);
switch (result)
{
case MessageBoxResult.Yes:
MessageBox.Show("item Marked completed", "Item makred!");
string ConString = Properties.Resources.ConnectionDB;
string CmdString = string.Empty;
using (SqlConnection con = new SqlConnection(ConString))
{
con.Open();
string temp = "temp"; // till i create user accounts
CmdString = "DELETE FROM " + "New_Task_Table" + " WHERE " + "UserID" + " = '" + row_selected["UserID"] + "'"
+ " AND " + "AssignedBy" + " = '" + row_selected["AssignedBy"] + "'"
+ " AND " + "TaskName" + " = '" + row_selected["TaskName"] + "'"
+ " AND " + "DateStarted" + " = '" + row_selected["DateStarted"] + "'"
+ " AND " + "ETA" + " = '" + row_selected["ETA"] + "'"; // deleting data from the old task table
SqlCommand cmd = new SqlCommand(CmdString, con);
cmd.ExecuteNonQuery();
CmdString = " INSERT INTO Task_Table_Completed ( UserID, AssignedBy, TaskName, DateStarted, ETA, CurrentState ) VALUES(@UserID, @AssignedBy, @TaskName, @DateStarted, @ETA, @CurrentState )"; // adding new data to the new task complete
cmd = new SqlCommand(CmdString, con);
cmd.Parameters.AddWithValue("@UserID", temp);
cmd.Parameters.AddWithValue("@AssignedBy", temp);
cmd.Parameters.AddWithValue("@TaskName", row_selected["TaskName"]);
cmd.Parameters.AddWithValue("@DateStarted", row_selected["DateStarted"]);
cmd.Parameters.AddWithValue("@ETA", row_selected["ETA"]);
cmd.Parameters.AddWithValue("@CurrentState", ""); // adding to the new table
cmd.ExecuteNonQuery();
con.Close(); // close connection
}
RemovePage myWin = new RemovePage();
myWin.Show();
this.Close();
break;
}
}
private void DataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
DataGrid gd = (DataGrid)sender;
DataRowView row_selected = gd.SelectedItem as DataRowView;
MessageBoxResult result = MessageBox.Show("Are your sure you want to delete ID ITEM : " + row_selected["UserID"] + "?", "delete item", MessageBoxButton.YesNoCancel);
switch (result)
{
case MessageBoxResult.Yes:
MessageBox.Show("Id deleted!", "delete item");
string ConString = Properties.Resources.ConnectionDB;
string CmdString = string.Empty;
using (SqlConnection con = new SqlConnection(ConString))
{
con.Open();
string temp = "temp"; // till i create user accounts
CmdString = "DELETE FROM " + "New_Task_Table" + " WHERE " + "UserID" + " = '" + row_selected["UserID"] + "'"
+ " AND " + "AssignedBy" + " = '" + row_selected["AssignedBy"] + "'"
+ " AND " + "TaskName" + " = '" + row_selected["TaskName"] + "'"
+ " AND " + "DateStarted" + " = '" + row_selected["DateStarted"] + "'"
+ " AND " + "ETA" + " = '" + row_selected["ETA"] + "'";
SqlCommand cmd = new SqlCommand(CmdString, con);
cmd.ExecuteNonQuery();
con.Close(); // close connection
}
RemovePage myWin = new RemovePage();
myWin.Show();
this.Close();
break;
}
}
