public bool Update(TaskInfo entity, string specialMode)//, out List<TrainingProduct> lstupdated)
{
MyServiceReference.MyServiceClient serviceClient = new MyServiceReference.MyServiceClient();
bool ret = false;
List <TaskInfo> lst = new List <TaskInfo>();
TaskInfo tempProd = new TaskInfo();
ret = validate(entity, "Update");
if (ret)
{
if (specialMode == "suspend")
{
entity.Status = true;
serviceClient.UpdateTask(entity.Task_Id, entity.Status);
}
else
{
serviceClient.UpdateTaskDetails(entity.Task_Id, entity.Parent_ID, entity.Project_ID, entity.Task, entity.StartDate, entity.EndDate, entity.Priority, entity.Status);
}
}
lst.Add(tempProd);
// lstupdated = lst;
return(ret);
}
public List <ProjectInfo> GetAllProjects()
{
MyServiceReference.MyServiceClient serviceClient = new MyServiceReference.MyServiceClient();
List <ProjectInfo> ret = new List <ProjectInfo>();
//TODO - Add Empower Data Fetch Call method here
//MyServiceReference.UserProfile[] UserPro = serviceClient.GetAllUsers();
MyServiceReference.ProjectInfo[] ProjInfo = serviceClient.GetAllProjects();
foreach (MyServiceReference.ProjectInfo _User in ProjInfo)
{
ret.Add(new ProjectInfo()
{
Project = _User.Project,
StartDate = _User.StartDate,
EndDate = _User.EndDate,
Priority = _User.Priority,
Project_ID = _User.Project_ID
});
}
// ret = prd.Count >= 5 ? prd : CreateMockData();
//if (!string.IsNullOrEmpty())
//{
// ret = ret.FindAll(p => p.ProductName.ToLower().StartsWith(entity.ProductName.ToLower()));
//}
return(ret);
}
public bool Update(UserInfo entity)//, out List<TrainingProduct> lstupdated)
{
MyServiceReference.MyServiceClient serviceClient = new MyServiceReference.MyServiceClient();
bool ret = false;
List <UserInfo> lst = new List <UserInfo>();
UserInfo tempProd = new UserInfo();
ret = validate(entity, "Update");
if (ret)
{
// lst = CreateMockData();
tempProd = lst.Find(p => p.User_ID == entity.User_ID);
lst.Remove(tempProd);
tempProd = new UserInfo();
tempProd.User_ID = entity.User_ID;
tempProd.FirstName = entity.FirstName;
tempProd.LastName = entity.LastName;
tempProd.Project_ID = entity.Project_ID;
tempProd.Employee_ID = entity.Employee_ID;
tempProd.Task_ID = entity.Task_ID;
//update in DB
serviceClient.UpdateUser(entity.User_ID, entity.FirstName, entity.LastName, entity.Project_ID, entity.Employee_ID, entity.Task_ID);
}
lst.Add(tempProd);
// lstupdated = lst;
return(ret);
}
public List <TaskInfo> GetAllProjects()
{
MyServiceReference.MyServiceClient serviceClient = new MyServiceReference.MyServiceClient();
List <TaskInfo> ret = new List <TaskInfo>();
//TODO - Add Empower Data Fetch Call method here
//MyServiceReference.UserProfile[] UserPro = serviceClient.GetAllUsers();
MyServiceReference.ProjectTaskInfo[] projTasks = serviceClient.GetAllTasks();
foreach (MyServiceReference.ProjectTaskInfo task in projTasks)
{
ret.Add(new TaskInfo()
{
Task = task.Task,
StartDate = task.StartDate,
EndDate = task.EndDate,
Priority = task.Priority
});
}
// ret = prd.Count >= 5 ? prd : CreateMockData();
//if (!string.IsNullOrEmpty())
//{
// ret = ret.FindAll(p => p.ProductName.ToLower().StartsWith(entity.ProductName.ToLower()));
//}
return(ret);
}
public bool Update(ProjectInfo entity)//, out List<TrainingProduct> lstupdated)
{
MyServiceReference.MyServiceClient serviceClient = new MyServiceReference.MyServiceClient();
bool ret = false;
List <ProjectInfo> lst = new List <ProjectInfo>();
ProjectInfo tempProd = new ProjectInfo();
ret = validate(entity, "Update");
if (ret)
{
// lst = CreateMockData();
tempProd = lst.Find(p => p.Project_ID == entity.Project_ID);
lst.Remove(tempProd);
tempProd = new ProjectInfo();
tempProd.Project_ID = entity.Project_ID;
tempProd.Project = entity.Project;
tempProd.StartDate = entity.StartDate;
tempProd.EndDate = entity.EndDate;
tempProd.Priority = entity.Priority;
//update in DB
serviceClient.UpdateProjectUserInfo(entity.Project_ID, entity.Project, entity.StartDate, entity.EndDate, entity.Priority, entity.Manager_ID);
}
lst.Add(tempProd);
// lstupdated = lst;
return(ret);
}
public List <UserInfo> GetAllUsers()
{
MyServiceReference.MyServiceClient serviceClient = new MyServiceReference.MyServiceClient();
List <UserInfo> ret = new List <UserInfo>();
//TODO - Add Empower Data Fetch Call method here
//MyServiceReference.UserProfile[] UserPro = serviceClient.GetAllUsers();
MyServiceReference.UserInfo[] UserPro = serviceClient.GetAllUsers();
foreach (MyServiceReference.UserInfo _User in UserPro)
{
ret.Add(new UserInfo()
{
User_ID = _User.User_ID,
FirstName = _User.FirstName,
LastName = _User.LastName,
Project_ID = _User.Project_ID,
Employee_ID = _User.Employee_ID,
Task_ID = _User.Task_ID,
});
}
// ret = prd.Count >= 5 ? prd : CreateMockData();
//if (!string.IsNullOrEmpty())
//{
// ret = ret.FindAll(p => p.ProductName.ToLower().StartsWith(entity.ProductName.ToLower()));
//}
return(ret);
}
public List <ParentTaskInfo> GetAllParentTask()
{
MyServiceReference.MyServiceClient serviceClient = new MyServiceReference.MyServiceClient();
List <ParentTaskInfo> ret = new List <ParentTaskInfo>();
//TODO - Add Empower Data Fetch Call method here
//MyServiceReference.UserProfile[] UserPro = serviceClient.GetAllUsers();
MyServiceReference.ParentTaskInfo[] parentTaskInfo = serviceClient.GetAllParentTasks();
foreach (MyServiceReference.ParentTaskInfo _task in parentTaskInfo)
{
ret.Add(new ParentTaskInfo()
{
ParentTask_ID = _task.ParentTask_Id,
Parent_Task = _task.ParentTaskName
});
}
// ret = prd.Count >= 5 ? prd : CreateMockData();
//if (!string.IsNullOrEmpty())
//{
// ret = ret.FindAll(p => p.ProductName.ToLower().StartsWith(entity.ProductName.ToLower()));
//}
return(ret);
}
public bool Insert(TaskInfo entity, bool isParentTask, int TaskUser_Id)//, out List<TrainingProduct> lst)
{
List <TaskInfo> lstProdAdd = new List <TaskInfo>();
//lstProdAdd = new List<TrainingProduct>();
MyServiceReference.MyServiceClient serviceClient = new MyServiceReference.MyServiceClient();
bool ret = false;
ret = true;// validate(entity, "add");
if (ret)
{
if (isParentTask)
{
serviceClient.AddParentTask(entity.Task);
}
else
{
serviceClient.AddTask(entity.Parent_ID, entity.Project_ID, entity.Task, entity.StartDate, entity.EndDate, entity.Priority, entity.Status, TaskUser_Id);
}
}
return(ret);
}
public List <TaskInfo> Get(TaskInfo entity, List <TaskInfo> prd, string mode = "")
{
MyServiceReference.MyServiceClient serviceClient = new MyServiceReference.MyServiceClient();
List <TaskInfo> ret = new List <TaskInfo>();
ProjectInfoManager pinfoManager = new SPAData.ProjectInfoManager();
List <ProjectInfo> _projectInfo = pinfoManager.GetAllProjects();
TaskInfoManager mgrTaskinfoManager = new SPAData.TaskInfoManager();
List <ParentTaskInfo> _parentTaskInfo = mgrTaskinfoManager.GetAllParentTask();
MyServiceReference.ProjectTaskInfo[] TaskInfo = serviceClient.GetAllTasks();
foreach (MyServiceReference.ProjectTaskInfo _task in TaskInfo)
{
ret.Add(new TaskInfo()
{
Task = _task.Task,
Parent_ID = _task.Parent_ID,
Priority = _task.Priority,
StartDate = _task.StartDate,
EndDate = _task.EndDate,
Task_Id = _task.Task_Id,
Project_ID = _task.Project_ID,
Status = _task.Status,
});
}
ProjectInfo result;
ParentTaskInfo _result = new ParentTaskInfo();
foreach (TaskInfo _Task in ret)
{
result = _projectInfo.First(item => item.Project_ID == _Task.Project_ID);
_Task.ProjectName = result.Project;
}
foreach (TaskInfo _Task in ret)
{
if (_Task.Parent_ID > 0)
{
_result = _parentTaskInfo.First(item => item.ParentTask_ID == _Task.Parent_ID);
}
_Task.ParentTaskName = _result.Parent_Task;
}
if (!string.IsNullOrEmpty(entity.ProjectName))
{
ret = ret.FindAll(p => p.ProjectName.ToLower().StartsWith(entity.ProjectName.ToLower()));
}
return(ret);
}
public ProjectInfo Get(int ProjectID)
{
MyServiceReference.MyServiceClient serviceClient = new MyServiceReference.MyServiceClient();
ProjectInfo lst = new ProjectInfo();
SPAData.MyServiceReference.ProjectInfo _ret = serviceClient.GetProjectById(ProjectID);
lst.Project_ID = _ret.Project_ID;
lst.Project = _ret.Project;
lst.StartDate = _ret.StartDate;
lst.EndDate = _ret.EndDate;
lst.Priority = _ret.Priority;
return(lst);
}
public bool Delete(TaskInfo entity, out List <TaskInfo> lstupdated)
{
MyServiceReference.MyServiceClient serviceClient = new MyServiceReference.MyServiceClient();
bool ret = false;
List <TaskInfo> lst = new List <TaskInfo>();
TaskInfo tempProd = new TaskInfo();
ret = validate(entity, "delete");
if (ret)
{
serviceClient.DeleteUserById(entity.Project_ID);
}
lstupdated = lst;
return(ret);
}
public bool validate(UserInfo entity, string mode)
{
bool isvalid = false;
ValidationErrors.Clear();
MyServiceReference.MyServiceClient serviceClient = new MyServiceReference.MyServiceClient();
if (mode.ToLower() == "delete")
{
UserInfo lst = new UserInfo();
MyServiceReference.UserInfo usrinfo = serviceClient.GetAllUsersById(entity.User_ID);
if (usrinfo.Project_ID != 0 && usrinfo.Task_ID != 0)
//int ucount = serviceClient.CheckUserDependencyById(entity.User_ID);
// if (ucount > 0)
{
//MyServiceReference.UserInfo usrinfo = serviceClient.GetAllUsersById(entity.User_ID);
ValidationErrors.Add(new KeyValuePair <string, string>(usrinfo.FirstName + "UserDepencyError", "User has Project and Task Mapped hence User" + usrinfo.FirstName + " cannot be deleted"));
}
if (ValidationErrors.Count <= 0)
{
isvalid = true;
}
}
else if (mode.ToLower() == "add")
{
List <UserInfo> checklst = GetAllUsers();
{
foreach (UserInfo usr in checklst)
{
if (usr.User_ID == entity.User_ID)
{
isvalid = false;
}
else
{
isvalid = true;
}
}
}
}
else
{
isvalid = true;
}
return(isvalid); //(ValidationErrors.Count == 0);
}
public UserInfo GetUserInfo(int userId)
{
MyServiceReference.MyServiceClient serviceClient = new MyServiceReference.MyServiceClient();
UserInfo lst = new UserInfo();
//db call get data
//lst = CreateMockData();
//lst = (TrainingProduct)serviceClient.GetAllProductsById(ProductID);
//ret = lstp => p.ProductID == ProductID);
SPAData.MyServiceReference.UserInfo _ret = serviceClient.GetAllUsersById(userId);
//lst.UserId = _ret.UserId;
//lst.UserName = _ret.UserName;
//lst.Password = _ret.Password;
//lst.IsActive = (bool)_ret.IsActive;
return(lst);
}
public bool Insert(UserInfo entity)//, out List<TrainingProduct> lst)
{
List <UserInfo> lstProdAdd = new List <UserInfo>();
//lstProdAdd = new List<TrainingProduct>();
MyServiceReference.MyServiceClient serviceClient = new MyServiceReference.MyServiceClient();
bool ret = false;
ret = validate(entity, "add");
if (ret)
{
serviceClient.AddUserInfo(entity.FirstName, entity.LastName, entity.Employee_ID, entity.Project_ID, entity.Task_ID);
}
return(ret);
}
public bool Insert(ProjectInfo entity)//, out List<TrainingProduct> lst)
{
List <ProjectInfo> lstProdAdd = new List <ProjectInfo>();
//lstProdAdd = new List<TrainingProduct>();
MyServiceReference.MyServiceClient serviceClient = new MyServiceReference.MyServiceClient();
bool ret = false;
ret = validate(entity, "add");
if (ret)
{
serviceClient.AddProjectInfo(entity.Project, entity.StartDate, entity.EndDate, entity.Priority, entity.Manager_ID);
}
return(ret);
}
public TaskInfo GetTaskInfo(int projectID)
{
MyServiceReference.MyServiceClient serviceClient = new MyServiceReference.MyServiceClient();
TaskInfo lst = new TaskInfo();
//db call get data
//lst = CreateMockData();
//lst = (TrainingProduct)serviceClient.GetAllProductsById(ProductID);
//ret = lstp => p.ProductID == ProductID);
///* SPAData.*/MyServiceReference.ProjectTaskInfo _ret = serviceClient.TaskById(projectID);
//lst.UserId = _ret.UserId;
//lst.UserName = _ret.UserName;
//lst.Password = _ret.Password;
//lst.IsActive = (bool)_ret.IsActive;
return(lst);
}
public TaskInfo GetTaskByID(int TaskId)
{
MyServiceReference.MyServiceClient serviceClient = new MyServiceReference.MyServiceClient();
TaskInfo lstTask = new TaskInfo();
SPAData.MyServiceReference.ProjectTaskInfo _ret = serviceClient.GetTaskById(TaskId);
lstTask.Project_ID = _ret.Project_ID;
lstTask.Task_Id = TaskId;
lstTask.StartDate = _ret.StartDate;
lstTask.EndDate = _ret.EndDate;
lstTask.Priority = _ret.Priority;
lstTask.Status = _ret.Status;
lstTask.Parent_ID = _ret.Parent_ID;
lstTask.Task = _ret.Task;
return(lstTask);
}
public List <ProjectInfo> Get(ProjectInfo entity, List <ProjectInfo> prd, string mode = "")
{
MyServiceReference.MyServiceClient serviceClient = new MyServiceReference.MyServiceClient();
//if (mode.ToLower() == "delete")
//{
// return prd;
//}
List <ProjectInfo> ret = new List <ProjectInfo>();
//TODO - Add Empower Data Fetch Call method here
UserInfoManager urMGr = new UserInfoManager();
List <UserInfo> usrInfo = urMGr.GetAllUsers();
MyServiceReference.ProjectInfo[] Projects = serviceClient.GetAllProjects();
foreach (var _Project in Projects)
{
ret.Add(new ProjectInfo()
{
Project_ID = _Project.Project_ID,
EndDate = _Project.EndDate,
StartDate = _Project.StartDate,
Priority = _Project.Priority,
Project = _Project.Project,
Users = usrInfo,
TotalNoOfTasks = GetTotalNoTask(_Project.Project_ID),
CompletedNoOfTasks = GetTotalNoTaskCompleted(_Project.Project_ID)
});
}
// ret = prd.Count >= 5 ? prd : CreateMockData();
if (!string.IsNullOrEmpty(entity.Project))
{
ret = ret.FindAll(p => p.Project.ToLower().StartsWith(entity.Project.ToLower()));
}
MyServiceReference.UserInfo[] Users = serviceClient.GetAllUsers();
return(ret);
}
public UserInfo Get(int userId)
{
MyServiceReference.MyServiceClient serviceClient = new MyServiceReference.MyServiceClient();
UserInfo lst = new UserInfo();
//db call get data
//lst = CreateMockData();
//lst = (TrainingProduct)serviceClient.GetAllProductsById(ProductID);
//ret = lstp => p.ProductID == ProductID);
SPAData.MyServiceReference.UserInfo _ret = serviceClient.GetAllUsersById(userId);
lst.User_ID = _ret.User_ID;
lst.FirstName = _ret.FirstName;
lst.LastName = _ret.LastName;
lst.Project_ID = _ret.Project_ID;
lst.Employee_ID = _ret.Employee_ID;
lst.Task_ID = _ret.Task_ID;
return(lst);
}
public static void LogErrorInfo_in_DB(string errorinfoMessage, string errorinfoType)
{
MyServiceReference.MyServiceClient serviceClient = new MyServiceReference.MyServiceClient();
serviceClient.LogErrorinDB(errorinfoMessage, errorinfoType);
}
