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);
}
public bool CheckProjectID()
{
objProjDAL = new Project_DAL(objprojectproperty);
DataTable dt = objProjDAL.CheckProjectID();
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
//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);
}
//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);
}
//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);
}
//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);
}
//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);
}
public bool Update()
{
objProjectDAl = new Project_DAL(objprojectproperty);
return(objProjectDAl.Update());
}
public DataTable GetAllTaskByIdMilesToneID()
{
objProjectDAl = new Project_DAL(objTimeline);
return(objProjectDAl.GetAllTaskByIdMilesToneID());
}
public DataTable GetMilestoneById()
{
objProjectDAl = new Project_DAL(objTimeline);
return(objProjectDAl.GetMilestoneById());
}
public DataTable GetAllMilestoneById()
{
objProjectDAl = new Project_DAL(objprojectproperty);
return(objProjectDAl.GetAllMilestoneByProjectID());
}
public DataTable SelectProjectNew()
{
objProjectDAl = new Project_DAL(objprojectproperty);
return(objProjectDAl.SelectAll());
}
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));
}
public DataSet SelectOne()
{
objProjectDAl = new Project_DAL(objprojectproperty);
return(objProjectDAl.SelectOne());
}
public DataTable SelectAssignedCompletedProjectsForEmployee()
{
objProjectDAl = new Project_DAL(objprojectproperty);
return(objProjectDAl.SelectAssignedCompletedProjectsForEmployee());
}
public bool InsertTask()
{
objProjectDAl = new Project_DAL(objprojectproperty);
return(objProjectDAl.InsertTAsk());
}
public bool InsertMileStone()
{
objProjectDAl = new Project_DAL(objprojectproperty);
return(objProjectDAl.InsertMilesStone(objMileStone.MilestoneDetails));
}
public DataTable SelectOneEdit()
{
objProjectDAl = new Project_DAL(objprojectproperty);
return(objProjectDAl.SelectOneEdit());
}
public DataTable SelectAssignedProjects()
{
objProjectDAl = new Project_DAL(objprojectproperty);
return(objProjectDAl.SelectAssignedProjects());
}
public DataTable GetDetailsForProjectEstimation()
{
objProjectDAl = new Project_DAL(objprojectproperty);
return(objProjectDAl.GetDetailsForProjectEstimation());
}