public Post(int ID)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM [viewTrackingTool_Boards_Posts] WHERE [postID] = @postID";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@postID", ID);
DataTable DT = TTDB.TTQuery(cmd);
if (DT.Rows.Count == 1)
{
postID = Int32.Parse(DT.Rows[0]["postID"].ToString());
threadID = Int32.Parse(DT.Rows[0]["threadID"].ToString());
post_Full = DT.Rows[0]["post_Full"].ToString();
postBy = Int32.Parse(DT.Rows[0]["postBy"].ToString());
createdTimestamp = DateTime.Parse(DT.Rows[0]["createdTimestamp"].ToString());
Display_Image = DT.Rows[0]["Display_Image"].ToString();
Display_Name = DT.Rows[0]["Display_Name"].ToString();
if (DT.Rows[0]["updatedBy"].ToString() != "")
{
updatedBy = Int32.Parse(DT.Rows[0]["updatedBy"].ToString());
updatedTimestamp = DateTime.Parse(DT.Rows[0]["updatedTimestamp"].ToString());
}
}
}
public DataTable updateFlagCompleted(bool completed)
{
setFlagCompleted(completed);
SqlCommand cmd = new SqlCommand();
if (completed)
{
cmd.CommandText = "UPDATE [TrackingTool_Features] SET [flagCompleted] = @flagCompleted, [updatedTimestamp] = CURRENT_TIMESTAMP, [completedTimestamp] = CURRENT_TIMESTAMP WHERE [ID] = @ID";
}
else
{
cmd.CommandText = "UPDATE [TrackingTool_Features] SET [flagCompleted] = @flagCompleted, [updatedTimestamp] = CURRENT_TIMESTAMP WHERE [ID] = @ID";
}
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@flagCompleted", getFlagCompleted());
cmd.Parameters.AddWithValue("@ID", getID());
DataTable DT = TTDB.TTQuery(cmd);
if (DT == null)
{
DT = new DataTable();
}
return(DT);
}
public DataTable updateFeatureDetails(string name, string description, int weight, int percentComplete)
{
setFeatureName(name);
setFeatureDescription(description);
setWeight(weight);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE [TrackingTool_Features] SET [featureName] = @featName, [featureDescription] = @featDesc, [weight] = @weight, [updatedTimestamp] = CURRENT_TIMESTAMP, percentComplete = @percentComplete WHERE [ID] = @ID";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@featName", getFeatureName());
cmd.Parameters.AddWithValue("@featDesc", getFeatureDescription());
cmd.Parameters.AddWithValue("@weight", getWeight());
cmd.Parameters.AddWithValue("@ID", getID());
cmd.Parameters.AddWithValue("@percentComplete", percentComplete);
DataTable DT = TTDB.TTQuery(cmd);
if (DT == null)
{
DT = new DataTable();
}
updateAllPercentCompletes();
return(DT);
}
public static int addNewBoard(string boardName, int userID, int importance)
{
// importance is 1 if its a milestone, 0 if its a general board.
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "INSERT INTO [TrackingTool_Board_Main] VALUES(@boardName, @importance, CURRENT_TIMESTAMP, @user)";
cmd.Parameters.AddWithValue("@boardName", boardName);
cmd.Parameters.AddWithValue("@importance", importance);
cmd.Parameters.AddWithValue("@user", userID);
TTDB.TTQuery(cmd);
cmd = new SqlCommand();
cmd.CommandText = "SELECT [boardID] FROM [TrackingTool_Board_Main] WHERE [board_CategoryName] = @boardName AND [createdBy] = @user ORDER BY [createdTimestamp] DESC";
cmd.Parameters.AddWithValue("@boardName", boardName);
cmd.Parameters.AddWithValue("@user", userID);
DataTable DT = TTDB.TTQuery(cmd);
int boardID = -1;
if (DT.Rows.Count > 0)
{
boardID = Int32.Parse(DT.Rows[0]["boardID"].ToString());
}
Thread.addNewThread(boardID, "General Discussion", "Generic Thread for the Board", userID);
return(boardID);
}
public bool Login_User(string UserName, string PW, string IP)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM TrackingTool_Users WHERE [ownerAlias] = @UserName AND [user_PW] = @PW";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@UserName", UserName);
cmd.Parameters.AddWithValue("@PW", PW);
DataTable DT = TTDB.TTQuery(cmd);
if (DT.Rows.Count == 1)
{
cmd = new SqlCommand();
cmd.CommandText = "DELETE FROM TrackingTool_Users_Active WHERE [uniqID] = @uniqID OR [User_IP] = @IP";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@uniqID", DT.Rows[0]["ID"].ToString());
cmd.Parameters.AddWithValue("@IP", IP);
TTDB.TTQuery(cmd);
cmd = new SqlCommand();
cmd.CommandText = "INSERT INTO TrackingTool_Users_Active VALUES(@uniqID, @userIP, CURRENT_TIMESTAMP)";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@uniqID", Int32.Parse(DT.Rows[0]["ID"].ToString()));
cmd.Parameters.AddWithValue("@userIP", IP);
TTDB.TTQuery(cmd);
return(true);
}
else
{
return(false);
}
}
public DataTable getActiveUserData(string IP)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM viewTrackingTool_Active_Users WHERE [User_IP] = @IP";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@IP", IP);
setIPLast(IP);
DataTable DT = TTDB.TTQuery(cmd);
if (DT != null)
{
if (DT.Rows.Count == 1)
{
user_UpdateActive();
return(DT);
}
else
{
return(new DataTable());
}
}
else
{
return(new DataTable());
}
}
static public int addNewFeature(int projectID, int parentID, string Name, string Description, int Weight, int boardID)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "INSERT INTO [TrackingTool_Features] VALUES(@projectID, @parentID, @featureName, @featureDescription, @weight, @boardID, 0, 0, CURRENT_TIMESTAMP, NULL, NULL)";
cmd.Parameters.AddWithValue("@projectID", projectID);
cmd.Parameters.AddWithValue("@parentID", parentID);
cmd.Parameters.AddWithValue("@featureName", Name);
cmd.Parameters.AddWithValue("@featureDescription", Description);
cmd.Parameters.AddWithValue("@weight", Weight);
cmd.Parameters.AddWithValue("@boardID", boardID);
TTDB.TTQuery(cmd);
cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM [TrackingTool_Features] WHERE projectID = @projectID AND parentID = @parentID AND featureName = @featureName and featureDescription = @featureDescription and weight = @weight";
cmd.Parameters.AddWithValue("@projectID", projectID);
cmd.Parameters.AddWithValue("@parentID", parentID);
cmd.Parameters.AddWithValue("@featureName", Name);
cmd.Parameters.AddWithValue("@featureDescription", Description);
cmd.Parameters.AddWithValue("@weight", Weight);
DataTable DT = TTDB.TTQuery(cmd);
Feature ftr = new Feature(int.Parse(DT.Rows[0]["ID"].ToString()));
ftr.updateAllPercentCompletes();
if (DT.Rows.Count > 0)
{
return(Int32.Parse(DT.Rows[0]["ID"].ToString()));
}
else
{
return(-1);
}
}
public void deleteTask()
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE [TrackingTool_Projects] SET [isActive] = 0 WHERE [ID] = @ID";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@ID", getID());
TTDB.TTQuery(cmd);
//Deleted projects should not show notifications
cmd = new SqlCommand();
cmd.CommandText = "UPDATE [TrackingTool_ProjectPermissions] SET [userAcknowledged] = 1 WHERE [projectID] = @ID";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@ID", getID());
TTDB.TTQuery(cmd);
//SqlCommand cmd = new SqlCommand();
//cmd.CommandText = "SELECT * FROM [db_forum].[dbo].[TrackingTool_Board_Threads] WHERE [boardID] = @boardID";
//cmd.Parameters.Clear();
//cmd.Parameters.AddWithValue("@boardID", getBoardID());
//DataTable DT = TTDB.TTQuery(cmd);
//foreach (DataRow DR in DT.Rows)
//{
// SqlCommand cmd2 = new SqlCommand();
// cmd2.CommandText = "DELETE FROM [db_forum].[dbo].[TrackingTool_Board_Posts] WHERE [threadID] = @threadID";
// cmd2.Parameters.Clear();
// cmd2.Parameters.AddWithValue("@threadID", DR["threadID"].ToString());
// TTDB.TTQuery(cmd2);
//}
//cmd = new SqlCommand();
//cmd.CommandText = "DELETE FROM [db_forum].[dbo].[TrackingTool_Board_Threads] WHERE [boardID] = @boardID";
//cmd.Parameters.Clear();
//cmd.Parameters.AddWithValue("@boardID", getBoardID());
//TTDB.TTQuery(cmd);
//cmd = new SqlCommand();
//cmd.CommandText = "DELETE FROM [db_forum].[dbo].[TrackingTool_Board_Main] WHERE [boardID] = @boardID";
//cmd.Parameters.Clear();
//cmd.Parameters.AddWithValue("@boardID", getBoardID());
//TTDB.TTQuery(cmd);
//cmd = new SqlCommand();
//cmd.CommandText = "DELETE FROM [db_forum].[dbo].[TrackingTool_Features] WHERE [projectID] = @projectID";
//cmd.Parameters.Clear();
//cmd.Parameters.AddWithValue("@projectID", getID());
//TTDB.TTQuery(cmd);
//cmd = new SqlCommand();
//cmd.CommandText = "DELETE FROM [TrackingTool_Projects] WHERE [ID] = @ID";
//cmd.Parameters.Clear();
//cmd.Parameters.AddWithValue("@ID", getID());
//TTDB.TTQuery(cmd);
}
public static DataTable getAllActiveUserData()
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM view_Active_Users WHERE [Last_Active] > DateADD(mi, -15, Current_TimeStamp)";
cmd.Parameters.Clear();
return(TTDB.TTQuery(cmd));
}
public void reOpenTask()
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE [TrackingTool_Projects] SET [doneFlag] = '0', [actualStop] = NULL WHERE [ID] = @ID";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@ID", getID());
TTDB.TTQuery(cmd);
}
public static DataTable getUserData(int userID)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM viewTrackingTool_Users WHERE [ID] = @userID";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@userID", userID);
return(TTDB.TTQuery(cmd));
}
//used get call instead of param
public void acknowledgeMessage(int projectID)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE [TrackingTool_ProjectPermissions] SET [userAcknowledged] = 1, [updatedTimestamp] = CURRENT_TIMESTAMP WHERE [ID] = @ID";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@ID", projectID);
TTDB.TTQuery(cmd);
}
public void startTask()
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE [TrackingTool_Projects] SET [actualStart] = CURRENT_TIMESTAMP WHERE [ID] = @ID";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@ID", getID());
TTDB.TTQuery(cmd);
}
private void updateProjectPercentComplete()
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE [TrackingTool_Projects] SET [percentComplete] = @perComplete WHERE [ID] = @ID";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@perComplete", getPercentComplete());
cmd.Parameters.AddWithValue("@ID", getID());
TTDB.TTQuery(cmd);
}
protected void btn_AddNewPermission_OnClick(object sender, EventArgs e)
{
btn_AddNewPermission.Enabled = false;
bool userFound = false;
bool roleSelected = false;
string newAlias = "";
string role = roles_DropDownList.SelectedItem.Text;
// Check if name/user id selected
foreach (TableRow TR in tbl_possibleNames.Rows)
{
RadioButton rb = (RadioButton)(TR.Cells[0].Controls[0]);
if (rb.Checked)
{
userFound = true;
newAlias = rb.ID;
break;
}
}
if (!userFound)
{
foreach (TableRow TR in tbl_possibleNames2.Rows)
{
RadioButton rb = (RadioButton)(TR.Cells[0].Controls[0]);
if (rb.Checked)
{
userFound = true;
newAlias = rb.ID;
break;
}
}
}
// Check for User role selected
int index = Convert.ToInt32(roles_DropDownList.SelectedItem.Value);
if (index >= 0)
{
roleSelected = true;
}
if (userFound && roleSelected)
{
int[] permissions = Roles.getPermissions(Convert.ToInt32(roles_DropDownList.SelectedItem.Value));
string IP = Request.ServerVariables["HTTP_X_FORWARDED_FOR"] ?? Request.ServerVariables["REMOTE_ADDR"];
TTDB.addNewPermission(Int32.Parse(Request.QueryString["ID"].ToString()), newAlias, theCake.getActiveUserName(IP),
permissions[0], permissions[1], permissions[2], permissions[3], role);
Response.Redirect("PSharing.aspx?ID=" + Request.QueryString["ID"].ToString());
}
else
{
ValidationLabel.Text = "***Select User and Role to give them permissions***";
}
}
private void user_UpdateActive()
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE TrackingTool_Users_Active SET [Last_Active] = CURRENT_TIMESTAMP WHERE [User_IP] = @IP AND [uniqID] = @ID";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@IP", getIPLast());
cmd.Parameters.AddWithValue("@ID", getID());
TTDB.TTQuery(cmd);
}
public void updateProjectBaseInfo(string Name, string Description)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE [TrackingTool_Projects] SET [taskName] = @Name, [taskDescription] = @Description WHERE [ID] = @taskID";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@taskID", getID());
cmd.Parameters.AddWithValue("@Name", Name);
cmd.Parameters.AddWithValue("@Description", Description);
TTDB.TTQuery(cmd);
}
public static DataTable searchUsersByName(string firstName, string middleName, string lastName)
{
if (firstName.Length == 0 && middleName.Length == 0 && lastName.Length == 0)
{
return(new DataTable());
}
bool first = true;
string whereClause = "WHERE ";
if (firstName.Length > 0)
{
whereClause += "[firstName] LIKE @firstName ";
first = false;
}
if (middleName.Length > 0)
{
if (!first)
{
whereClause += "AND ";
}
whereClause += "[middleName] LIKE @middleName ";
first = false;
}
if (lastName.Length > 0)
{
if (!first)
{
whereClause += "AND ";
}
whereClause += "[lastName] LIKE @lastName ";
}
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Clear();
cmd.CommandText = "SELECT * FROM viewTrackingTool_Users " + whereClause;
cmd.Parameters.AddWithValue("@firstName", "%" + firstName + "%");
cmd.Parameters.AddWithValue("@middleName", "%" + middleName + "%");
cmd.Parameters.AddWithValue("@lastName", "%" + lastName + "%");
DataTable DT = TTDB.TTQuery(cmd);
if (DT != null)
{
return(DT);
}
else
{
return(new DataTable());
}
}
public void Logout_User(string IP)
{
DataTable DT = getActiveUserData(IP);
if (DT.Rows.Count == 1)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "DELETE FROM TrackingTool_Users_Active WHERE [User_IP] = @IP";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@IP", DT.Rows[0]["User_IP"].ToString());
TTDB.TTQuery(cmd);
}
}
// private methods
private void getThreads()
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM [viewTrackingTool_Boards_Threads] WHERE [boardID] = @boardID ORDER BY [createdTimestamp] ASC";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@boardID", boardID);
DataTable DT = TTDB.TTQuery(cmd);
foreach (DataRow DR in DT.Rows)
{
ThreadList.Add(new Thread(Int32.Parse(DR["threadID"].ToString())));
}
}
private void getFeatures()
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM [TrackingTool_Features] WHERE [parentID] is null AND [projectID] = @id ORDER BY [createdTimestamp] ASC";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@id", getID());
DataTable DT = TTDB.TTQuery(cmd);
foreach (DataRow DR in DT.Rows)
{
milestones.Add(int.Parse(DR["ID"].ToString()));
}
}
//Need to check what it is returning
public DataTable getProjectPermissions()
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM [viewTrackingTool_ProjectPermissions] WHERE [projectID] = @projectID ORDER BY [updatedTimestamp]";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@projectID", getID());
DataTable DT = TTDB.TTQuery(cmd);
if (DT == null)
{
DT = new DataTable();
}
return(DT);
}
public void increaseProjectSize(int ID, int userID)
{
Project proj = getTask(ID);
int newBoardID = Board.addNewBoard("General Discussion", userID, 0);
Thread.addNewThread(boardID, "General Discussion", "Generic Thread for the Board", userID);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE [TrackingTool_Projects] SET [projectSize] = '1', [boardID] = @boardID WHERE [ID] = @ID";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@ID", ID);
cmd.Parameters.AddWithValue("@boardID", newBoardID);
TTDB.TTQuery(cmd);
}
// Changed getActiveUserData call
public DataTable CheckNewAcknowledgements()
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM [TrackingTool_ProjectPermissions] WHERE [user_GivenTo] = @ID AND [userAcknowledged] = 0";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@ID", getID());
DataTable DT = TTDB.TTQuery(cmd);
if (DT == null)
{
DT = new DataTable();
}
return(DT);
}
public static void updateUserPassword(int ID, string PW)
{
string hashedSaltPassword;
// Hash the password with salt
hashedSaltPassword = PasswordHash.PasswordHash.CreateHash(PW);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE [TrackingTool_Users] SET [user_PW] = @PW WHERE [ID] = @UserID";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@PW", hashedSaltPassword);
cmd.Parameters.AddWithValue("@UserID", ID);
TTDB.TTQuery(cmd);
}
//Feature Functions
public DataTable getFeatures(int parentID)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM [TrackingTool_Features] WHERE [parentID] = @parentID ORDER BY [createdTimestamp] ASC";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@parentID", parentID);
DataTable DT = TTDB.TTQuery(cmd);
if (DT == null)
{
DT = new DataTable();
}
return(DT);
}
public void update_post_Full(string s, int user)
{
post_Full = s;
updatedBy = user;
updatedTimestamp = DateTime.Now;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE [TrackingTool_Board_Posts] SET [post_Full] = @post_Full, [updatedby] = @updatedBy, [updatedTimestamp] = @updatedTimestamp WHERE [postID] = @postID";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@post_Full", post_Full);
cmd.Parameters.AddWithValue("@updatedBy", updatedBy);
cmd.Parameters.AddWithValue("@updatedTimestamp", updatedTimestamp);
DataTable DT = TTDB.TTQuery(cmd);
}
//Old Functions from DataBase.cs need to be updated .
public void updateUserInfo(int UserID, string FirstName, string MiddleName, string LastName, string DisplayName, string Email, string PhoneNumber, string DisplayImage)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE [TrackingTool_Users] SET [firstName] = @FirstName, [middleName] = @MiddleName, [lastName] = @LastName, [Display_Name] = @DisplayName, [eMail] = @Email, [phoneNumber] = @PhoneNumber, [Display_Image] = @DisplayImage WHERE [ID] = @UserID";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@FirstName", FirstName);
cmd.Parameters.AddWithValue("@MiddleName", MiddleName);
cmd.Parameters.AddWithValue("@LastName", LastName);
cmd.Parameters.AddWithValue("@DisplayName", DisplayName);
cmd.Parameters.AddWithValue("@Email", Email);
cmd.Parameters.AddWithValue("@PhoneNumber", PhoneNumber);
cmd.Parameters.AddWithValue("@DisplayImage", DisplayImage);
cmd.Parameters.AddWithValue("@UserID", UserID);
TTDB.TTQuery(cmd);
}
public bool Register_User(string UserName, string firstName, string middleName, string lastName, string email, string phone, string DisplayName, string PW, string IP)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM TrackingTool_Users WHERE [ownerAlias] = @UserName";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@UserName", UserName);
DataTable DT = TTDB.TTQuery(cmd);
if (DT.Rows.Count == 0)
{
//try
//{
cmd = new SqlCommand();
cmd.CommandText = "INSERT INTO TrackingTool_Users VALUES(@UserName, @user_PW, @IP, @IP, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, @Active, @userLevel, @firstName, @middleName, @lastName, @eMail, @phoneNumber, @DisplayName, @DisplayImage, @User_Status, @Footer)";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@UserName", UserName);
cmd.Parameters.AddWithValue("@user_PW", PW);
cmd.Parameters.AddWithValue("@IP", IP);
cmd.Parameters.AddWithValue("@Active", 1);
cmd.Parameters.AddWithValue("@userLevel", 0);
cmd.Parameters.AddWithValue("@firstName", firstName);
cmd.Parameters.AddWithValue("@middleName", middleName);
cmd.Parameters.AddWithValue("@lastName", lastName);
cmd.Parameters.AddWithValue("@eMail", email);
cmd.Parameters.AddWithValue("@phoneNumber", phone);
cmd.Parameters.AddWithValue("@DisplayName", DisplayName);
cmd.Parameters.AddWithValue("@DisplayImage", "");
cmd.Parameters.AddWithValue("@User_Status", "");
cmd.Parameters.AddWithValue("@Footer", "");
TTDB.TTQuery(cmd);
return(true);
//}
//catch (Exception ex)
//{
// return false;
//}
}
else
{
return(false);
}
}
//Get User's Tasks functions
public static List <Project> getCompletedTasks(string userName)
{
List <Project> completed = new List <Project>();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM [viewTrackingTool_Projects] WHERE [ownerAlias] = @user AND [doneFlag] = '1' AND [isActive] = 1 ORDER BY [actualStop] DESC";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@user", userName);
DataTable DT = TTDB.TTQuery(cmd);
foreach (DataRow DR in DT.Rows)
{
completed.Add(new Project(int.Parse(DR["ID"].ToString())));
}
return(completed);
}
