Exemple #1
0
        public string GetStartDate(Project_Employee_Working_hours_Property empproject)
        {
            string startdate = "";

            objProject_Employee_Working_hours_Property = empproject;
            objProjectDAl = new Project_DAL(objprojectproperty);
            DataTable dt = objProjectDAl.GetStartDate(objProject_Employee_Working_hours_Property);

            foreach (DataRow dr in dt.Rows)
            {
                startdate = dr["starttime"].ToString();
            }
            return(startdate);
        }
Exemple #2
0
        public bool CheckProjectID()
        {
            objProjDAL = new Project_DAL(objprojectproperty);
            DataTable dt = objProjDAL.CheckProjectID();

            if (dt.Rows.Count > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Exemple #3
0
        //Delete Project
        public static int DeleteProject_BL(int Projectid)
        {
            int rowsAffected = 0;

            try
            {
                rowsAffected = Project_DAL.DeleteProject(Projectid);
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            catch (HRMSException ex)
            {
                throw ex;
            }
            return(rowsAffected);
        }
Exemple #4
0
        //Dispaly All Project
        public static DataTable DisplayProject_BL()
        {
            DataTable Project = null;

            try
            {
                Project = Project_DAL.DisplayAllProjects();
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            catch (HRMSException ex)
            {
                throw ex;
            }
            return(Project);
        }
Exemple #5
0
        //Search Project By Id
        public static DataTable SearchProjectById_BL(int Projectid)
        {
            DataTable Project = null;

            try
            {
                Project = Project_DAL.SearchProjectById(Projectid);
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            catch (HRMSException ex)
            {
                throw ex;
            }
            return(Project);
        }
Exemple #6
0
        //Get Autogenerated ID
        public static int GetAutogeneratedProjectID_BL()
        {
            int Projectid = 0;

            try
            {
                Projectid = Project_DAL.GetAutoGeneratedProjectId();
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            catch (HRMSException ex)
            {
                throw ex;
            }
            return(Projectid);
        }
Exemple #7
0
        //Calling Add Project
        public static int AddProject_BL(Project newProject)
        {
            int rowsAffected = 0;

            try
            {
                if (ValidatProject(newProject))
                {
                    rowsAffected = Project_DAL.AddProject(newProject);
                }
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            catch (HRMSException ex)
            {
                throw ex;
            }
            return(rowsAffected);
        }
Exemple #8
0
 public bool Update()
 {
     objProjectDAl = new Project_DAL(objprojectproperty);
     return(objProjectDAl.Update());
 }
Exemple #9
0
 public DataTable GetAllTaskByIdMilesToneID()
 {
     objProjectDAl = new Project_DAL(objTimeline);
     return(objProjectDAl.GetAllTaskByIdMilesToneID());
 }
Exemple #10
0
 public DataTable GetMilestoneById()
 {
     objProjectDAl = new Project_DAL(objTimeline);
     return(objProjectDAl.GetMilestoneById());
 }
Exemple #11
0
 public DataTable GetAllMilestoneById()
 {
     objProjectDAl = new Project_DAL(objprojectproperty);
     return(objProjectDAl.GetAllMilestoneByProjectID());
 }
Exemple #12
0
 public DataTable SelectProjectNew()
 {
     objProjectDAl = new Project_DAL(objprojectproperty);
     return(objProjectDAl.SelectAll());
 }
Exemple #13
0
 public bool EndTime(Project_Employee_Working_hours_Property empproject)
 {
     objProject_Employee_Working_hours_Property = empproject;
     objProjectDAl = new Project_DAL(objprojectproperty);
     return(objProjectDAl.EndTask(objProject_Employee_Working_hours_Property));
 }
Exemple #14
0
 public DataSet SelectOne()
 {
     objProjectDAl = new Project_DAL(objprojectproperty);
     return(objProjectDAl.SelectOne());
 }
Exemple #15
0
 public DataTable SelectAssignedCompletedProjectsForEmployee()
 {
     objProjectDAl = new Project_DAL(objprojectproperty);
     return(objProjectDAl.SelectAssignedCompletedProjectsForEmployee());
 }
Exemple #16
0
 public bool InsertTask()
 {
     objProjectDAl = new Project_DAL(objprojectproperty);
     return(objProjectDAl.InsertTAsk());
 }
Exemple #17
0
 public bool InsertMileStone()
 {
     objProjectDAl = new Project_DAL(objprojectproperty);
     return(objProjectDAl.InsertMilesStone(objMileStone.MilestoneDetails));
 }
Exemple #18
0
 public DataTable SelectOneEdit()
 {
     objProjectDAl = new Project_DAL(objprojectproperty);
     return(objProjectDAl.SelectOneEdit());
 }
Exemple #19
0
 public DataTable SelectAssignedProjects()
 {
     objProjectDAl = new Project_DAL(objprojectproperty);
     return(objProjectDAl.SelectAssignedProjects());
 }
Exemple #20
0
 public DataTable GetDetailsForProjectEstimation()
 {
     objProjectDAl = new Project_DAL(objprojectproperty);
     return(objProjectDAl.GetDetailsForProjectEstimation());
 }