public ProjectUpdateResult UpdateProject(ProjectModel oProj)
        {
            Status  oStatus = new Status();
            Project proj    = new Project()
            {
                End_Date   = oProj.End_Date,
                Priority   = oProj.Priority,
                Project1   = oProj.ProjectName,
                Start_Date = oProj.Start_Date,
                Status     = oProj.Status
            };

            if (oProj.Project_ID == 0)
            {
                proj    = repoProject.AddProject(proj);
                oStatus = new Status()
                {
                    Message = "Project added successfully", Result = true
                };
            }
            else
            {
                proj.Project_ID = oProj.Project_ID;
                proj            = repoProject.UpdateProject(proj);
                oStatus         = new Status()
                {
                    Message = "Project updated successfully", Result = true
                };
            }
            if (oProj.Manager_ID != null)
            {
                UserRepository repoUser = new UserRepository();
                User           ouser    = repoUser.GetUserById(oProj.Manager_ID.Value);
                ouser.Project_ID = proj.Project_ID;
                repoUser.UpdateUser(ouser);
            }
            return(new ProjectUpdateResult()
            {
                status = oStatus,
                project = new ProjectModel
                {
                    Project_ID = proj.Project_ID,
                    ProjectName = proj.Project1,
                    Priority = proj.Priority,
                    End_Date = proj.End_Date,
                    NumberOfTasks = proj.Tasks.Count,
                    Start_Date = proj.Start_Date,
                    Status = proj.Status
                }
            });
        }
        /// <summary>
        /// To update the project details to db
        /// </summary>
        /// <param name="oProj"></param>
        /// <returns></returns>
        public ProjectUpdateModel UpdateProject(ProjectModel project_Model)
        {
            StatusModel _status = new StatusModel();
            Project     proj    = new Project()
            {
                End_Date   = project_Model.End_Date,
                Priority   = project_Model.Priority,
                Project1   = project_Model.ProjectName,
                Start_Date = project_Model.Start_Date,
                Status     = project_Model.Status
            };

            if (project_Model.Project_ID == 0)
            {
                proj    = repoProject.AddProject(proj);
                _status = new StatusModel()
                {
                    Message = "Project details are added successfully", Result = true
                };
            }
            else
            {
                proj.Project_ID = project_Model.Project_ID;
                proj            = repoProject.UpdateProject(proj);
                _status         = new StatusModel()
                {
                    Message = "Project details are updated successfully", Result = true
                };
            }
            if (project_Model.Manager_ID != null)
            {
                UserRepository repoUser = new UserRepository();
                User           ouser    = repoUser.GetUserById(project_Model.Manager_ID.Value);
                ouser.Project_ID = proj.Project_ID;
                repoUser.UpdateUser(ouser);
            }
            return(new ProjectUpdateModel()
            {
                status = _status,
                project = new BusinessEntities.ProjectModel
                {
                    Project_ID = proj.Project_ID,
                    ProjectName = proj.Project1,
                    Priority = proj.Priority,
                    End_Date = proj.End_Date,
                    NumberOfTasks = proj.Tasks.Count,
                    Start_Date = proj.Start_Date,
                    Status = proj.Status
                }
            });
        }