117
if (data != null && data.HasRows)
{
while (data.Read())
{
try
{
projects.Add(new Project((int)data["idproject"], (string)data["Name"],
(string)data["Description"], null));
}
catch (Exception e)
{
Console.WriteLine("Error: " + e.Message);
return null;
}
}
//
}
ClearRequest();
return projects.ToArray();
}
public bool AddQuarter(Quarter quarter)
{
if (CheckObjectForNull(quarter))
{
string request = string.Format("INSERT INTO quarter (Name, ReleaseDate,
Status, ProjectId) VALUES('{0}', '{1}', {2}, {3})",
quarter.Name, quarter.ReleaseDate, (int)quarter.Status, quarter.ParentId);
118
return WriteRequest(request);
}
return false;
}
public bool UpdateQuarter(Quarter quarter)
{
if (CheckObjectForNull(quarter))
{
string request = string.Format("UPDATE quarter SET Name = '{1}',
ReleaseDate = '{2}', Status = '{3}', ProjectId = '{4}' WHERE idquarter = {0}",
quarter.Id, quarter.Name, quarter.ReleaseDate, (int)quarter.Status,
quarter.ParentId);
return WriteRequest(request);
}
return false;
}
public bool RemoveQuarter(Quarter quarter)
{
if (CheckObjectForNull(quarter))
{
string request = string.Format("DELETE FROM quarter WHERE idquarter
= {0}", quarter.Id);
return WriteRequest(request);
}
return false;
119
}
public Quarter[] GetQuarters(int projectId)
{
ReadRequest(string.Format("SELECT * FROM quarter WHERE ProjectId =
{0}", projectId));
List<Quarter> quarters = new List<Quarter>();
if (data != null && data.HasRows)
{
while (data.Read())
{
try
{
quarters.Add(new Quarter((int)data["idquarter"],
(int)data["ProjectId"], (string)data["Name"], (string)data["ReleaseDate"],
(ObjectStatus)data["Status"], null));
}
catch (Exception e)
{
Console.WriteLine("Error: " + e.Message);
return null;
}
}
}
ClearRequest();
return quarters.ToArray();
}
public bool AddFlow(Flow flow)
120
{
if (CheckObjectForNull(flow))
{
string request = string.Format("INSERT INTO flow (Name, QuarterId)
VALUES('{0}', {1})", flow.Name, flow.ParentId);
return WriteRequest(request);
}
return false;
}
public bool UpdateFlow(Flow flow)
{
if (CheckObjectForNull(flow))
{
string request = string.Format("UPDATE flow SET Name = '{1}', QuarterId
= {2}, GoalsValue = '{3}' WHERE idflow = {0}", flow.Id, flow.Name, flow.ParentId,
flow.GoalsValue);
return WriteRequest(request);
}
return false;
}
public bool RemoveFlow(Flow flow)
{
if (CheckObjectForNull(flow))
{
string request = string.Format("DELETE FROM flow WHERE idflow =
{0}", flow.Id);
121
return WriteRequest(request);
}
return false;
}
public Flow[] GetFlows(int quarterId)
{
ReadRequest(string.Format("SELECT * FROM flow WHERE QuarterId =
{0}", quarterId));
List<Flow> flows = new List<Flow>();
if (data != null && data.HasRows)
{
while (data.Read())
{
try
{
flows.Add(new Flow((int)data["idflow"], (int)data["QuarterId"],
(string)data["Name"], (string)data["GoalsValue"], null));
}
catch (Exception e)
{
Console.WriteLine("Error: " + e.Message);
ClearRequest();
return null;
}
}
}
ClearRequest();
122
return flows.ToArray();
}
public Flow GetFlow(int id)
{
ReadRequest(string.Format("SELECT * FROM flow WHERE idflow = {0}",
id));
if (data != null && data.HasRows)
{
while (data.Read())
{
try
{
return new Flow((int)data["idflow"], (int)data["QuarterId"],
(string)data["Name"], (string)data["GoalsValue"], null);
}
catch (Exception e)
{
Console.WriteLine("Error: " + e.Message);
ClearRequest();
return null;
}
finally
{
ClearRequest();
}
}
}
123
ClearRequest();
return null;
}
public bool AddGoal(Goal goal)
{
if (CheckObjectForNull(goal))
{
string request = string.Format("INSERT INTO goal (Name, Description,
Status, IsHidden, ImageLink, FlowId, TaskPointsValue) " +
"VALUES('{0}', '{1}', {2}, {3}, '{4}', {5}, '{6}')",
goal.Name, goal.Description, (int)goal.Status,
(goal.IsHidden ? 1 : 0), Encoding.UTF8.GetString(goal.ImageByte),
goal.ParentId, goal.TaskPointsValue);
return WriteRequest(request);
}
return false;
}
public bool UpdateGoal(Goal goal)
{
if (CheckObjectForNull(goal))
{
string request = string.Format("UPDATE goal SET Name = '{1}',
Description = '{2}', Status = {3}, IsHidden = {4}, ImageLink = '{5}', FlowId = {6},
TaskPointsValue = '{7}' WHERE idgoal = {0}",
goal.Id, goal.Name, goal.Description, (int)goal.Status,
(goal.IsHidden ? 1 : 0), Encoding.UTF8.GetString(goal.ImageByte),
goal.ParentId, goal.TaskPointsValue);
124
return WriteRequest(request);
}
return false;
}
public bool RemoveGoal(Goal goal)
{
if (CheckObjectForNull(goal))
{
string request = string.Format("DELETE FROM goal WHERE idgoal =
{0}", goal.Id);
return WriteRequest(request);
}
return false;
}
public Goal[] GetGoals(int flowId)
{
ReadRequest(string.Format("SELECT * FROM goal WHERE FlowId = {0}",
flowId));
List<Goal> goals = new List<Goal>();
if (data != null && data.HasRows)
{
while (data.Read())
{
try
{
125
goals.Add(new Goal((int)data["idgoal"], (int)data["FlowId"],
(string)data["Name"],
(string)data["Description"], (string)data["TaskPointsValue"],
(ObjectStatus)data["Status"], null,
(bool)data["IsHidden"],
(Encoding.UTF8.GetBytes((string)data["ImageLink"]))));
}
catch (Exception e)
{
Console.WriteLine("Error: " + e.Message);
ClearRequest();
return null;
}
}
}
ClearRequest();
return goals.ToArray();
}
public Goal GetGoal(int id)
{
ReadRequest(string.Format("SELECT * FROM goal WHERE idgoal = {0}",
id));
if (data != null && data.HasRows)
{
while (data.Read())
{
try
{
126
return new Goal((int)data["idgoal"], (int)data["FlowId"],
(string)data["Name"],
(string)data["Description"], (string)data["TaskPointsValue"],
(ObjectStatus)data["Status"], null,
(bool)data["IsHidden"],
(Encoding.UTF8.GetBytes((string)data["ImageLink"])));
}
catch (Exception e)
{
Console.WriteLine("Error: " + e.Message);
ClearRequest();
return null;
}
finally
{
ClearRequest();
}
}
}
ClearRequest();
return null;
}
public bool AddTaskPoint(TaskPoint taskPoint)
{
if (CheckObjectForNull(taskPoint))
{
string request = string.Format("INSERT INTO taskpoint (Name, IsClosed,
GoalId) VALUES('{0}', {1}, {2})",
taskPoint.Name, (taskPoint.IsClosed ? 1 : 0), taskPoint.ParentId);