public ActionResult AddTask()
{
Project_Property objtimeline = new Project_Property();
ProjectType_BLL objProjectTypeBLL = new ProjectType_BLL();
objProjectProperty = new Project_Property();
objProjectBll = new Project_BLL(objProjectProperty);
DataTable projects = objProjectBll.SelectAll();
List <Project_Property> ProjectType_PropertylistItems = new List <Project_Property>();
foreach (DataRow dr in projects.Rows)
{
Project_Property objProjectType_Property = new Project_Property();
objProjectType_Property.Project_Name = dr["Project_Name"].ToString();
objProjectType_Property.Project_Id = Convert.ToInt32(dr["Project_Id"].ToString());
ProjectType_PropertylistItems.Add(objProjectType_Property);
}
objtimeline.Start_Date = DateTime.Now;
objtimeline.Expected_completedDate = DateTime.Now;
objtimeline.Project_Item = ProjectType_PropertylistItems;
GetEmployee();
GetMilestones();
return(View(objtimeline));
}
public bool CheckProjectID(string projid)
{
objProjectProperty = new Project_Property();
objProjectProperty.Proj_Id = projid;
objProjectBll = new Project_BLL(objProjectProperty);
return(objProjectBll.CheckProjectID());
}
public JsonResult AddProject(Project_Property Project)
{
if (ModelState.IsValid)
{
//add new employee
if (Project.Project_Id == null || Project.Project_Id <= 0)
{
Project.DateCreated = DateTime.Now;
Project.Status = "Active";
Project.Is_Active = true;
Project.In_Progress = false;
Project.Is_Completed = false;
Project.Remarks = "";
objProjectBll = new Project_BLL(Project);
var flag = objProjectBll.Insert();
if (flag)
{
return(Json(new { success = true, statuscode = 200, msg = "Successfully inserted" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, statuscode = 500, msg = "Failed" }, JsonRequestBehavior.AllowGet));
}
}
//when id <0 update case
else
{
Project.DateCreated = DateTime.Now;
Project.Status = "Active";
Project.Is_Active = true;
Project.In_Progress = false;
Project.Is_Completed = false;
objProjectBll = new Project_BLL(Project);
var flag = objProjectBll.Update();
if (flag)
{
return(Json(new { success = true, statuscode = 200, msg = "Successfully inserted" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, statuscode = 500, msg = "Failed" }, JsonRequestBehavior.AllowGet));
}
}
}
//when model state is not valid
else
{
var errors = ModelState.Select(x => x.Value.Errors)
.Where(y => y.Count > 0)
.ToList();
return(Json(new { success = false, statuscode = 500, msg = "Please Enter According To Instructions" }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult AddTimeLineDetails(IEnumerable <Milestone_Details_Property> timeline)
{
Milestone_Details_Property objmilestone = new Milestone_Details_Property();
objmilestone.MilestoneDetails = ToDataTable(timeline);
objProjectBll = new Project_BLL(objmilestone);
var flag = objProjectBll.InsertMileStone();
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetProjectEstimationDetails(int id)
{
objProjectProperty = new Project_Property();
objProjectProperty.P_Id = id;
objProjectBll = new Project_BLL(objProjectProperty);
var estimation = JsonConvert.SerializeObject(objProjectBll.GetDetailsForProjectEstimation());
ViewBag.FooObj = estimation;
return(View());
}
public ActionResult ViewMilesStone(int id)
{
objProjectProperty = new Project_Property();
objProjectProperty.Project_Id = id;
objProjectBll = new Project_BLL(objProjectProperty);
DataTable dt = objProjectBll.GetAllMilestoneById();
var Milestones = JsonConvert.SerializeObject(dt);
ViewBag.Milestone = Milestones;
return(View());
}
public ActionResult AssignedProjectDetails(int id)
{
objProjectProperty = new Project_Property();
objProjectProperty.Project_Id = id;
objProjectBll = new Project_BLL(objProjectProperty);
DataTable dt = objProjectBll.SelectOne().Tables[1];
ViewBag.starttime = dt.Rows.Count > 0 ? false : true;
return(View(objProjectProperty));
}
public JsonResult GetCompletedProjects()
{
objProjectProperty = new Project_Property();
objProjectProperty.Resource_Id = Convert.ToInt32(SessionManager.CurrentUser.EmployeeID);
objProjectBll = new Project_BLL(objProjectProperty);
DataTable projects = objProjectBll.SelectAssignedCompletedProjectsForEmployee();
var projectsJson = JsonConvert.SerializeObject(projects);
var deserilize = JsonConvert.DeserializeObject(projectsJson);
return(Json(new { projectlist = projectsJson }, JsonRequestBehavior.AllowGet));
}
public JsonResult getProjects()
{
objProjectProperty = new Project_Property();
objProjectBll = new Project_BLL(objProjectProperty);
DataTable projects = objProjectBll.SelectAll();
var projectsJson = JsonConvert.SerializeObject(projects);
var deserilize = JsonConvert.DeserializeObject(projectsJson);
return(Json(new { projectlist = projectsJson }, JsonRequestBehavior.AllowGet));
}
public ActionResult ViewMilesStoneTasks(int id)
{
TimeLine_Property objtimeline = new TimeLine_Property();
objtimeline.ID = id;
objProjectBll = new Project_BLL(objtimeline);
DataTable dt = objProjectBll.GetAllTaskByIdMilesToneID();
var Tasklist = JsonConvert.SerializeObject(dt);
ViewBag.Tasklist = Tasklist;
return(View());
}
public List <Project_Property> GetProjects()
{
Project_BLL objprojectbll = new Project_BLL();
DataTable dt = objprojectbll.SelectUnAssignedProjects();
List <Project_Property> objProject_Property = new List <Project_Property>();
foreach (DataRow dr in dt.Rows)
{
Project_Property objprojctpropert = new Project_Property();
objprojctpropert.Project_Id = Convert.ToInt32(dr["Project_Id"].ToString());
objprojctpropert.Project_Name = dr["Project_Name"].ToString();
objProject_Property.Add(objprojctpropert);
}
return(objProject_Property);
}
public void GetMilestones()
{
Project_BLL objprojectbll = new Project_BLL();
DataTable dt = objprojectbll.GetAllMilestone();
List <TimeLine_Property> objTimeLine_PropertyList = new List <TimeLine_Property>();
foreach (DataRow dr in dt.Rows)
{
TimeLine_Property objTimeLineProperty = new TimeLine_Property();
objTimeLineProperty.ID = Convert.ToInt32(dr["ID"].ToString());
objTimeLineProperty.TimeLineName = dr["TimeLineName"].ToString();
objTimeLineProperty.Project_ID = Convert.ToInt32(dr["Project_Id"].ToString());
objTimeLine_PropertyList.Add(objTimeLineProperty);
}
ViewBag.MileStoneItems = objTimeLine_PropertyList;
}
public JsonResult startTime(int id)
{
Project_Employee_Working_hours_Property objprojectempworking = new Project_Employee_Working_hours_Property();
objprojectempworking.projectid = id;
objprojectempworking.status = "Started";
objprojectempworking.IsCompleted = false;
var empid = Convert.ToInt32(SessionManager.CurrentUser.EmployeeID);
objprojectempworking.employeeid = empid;
objprojectempworking.starttime = DateTime.Now;
objProjectBll = new Project_BLL();
objProjectBll.Starttime(objprojectempworking);
return(Json(new { success = true, statuscode = 200, msg = "Successfully inserted" }, JsonRequestBehavior.AllowGet));
}
public ActionResult ShowTimeLine(int id)
{
TimeLine_Property objtimeline = new TimeLine_Property();
objtimeline.Project_Item = GetProjects();
objtimeline.ID = id;
//objProjectProperty = new Project_Property();
//objProjectBll = new Project_BLL(objProjectProperty);
//DataTable projects = objProjectBll.SelectAll();
objProjectBll = new Project_BLL(objtimeline);
DataTable proTimeLine = objProjectBll.GetMilestoneById();
objtimeline = objProjectBll.getTable(proTimeLine);
return(View(objtimeline));
}
public ActionResult ShowProject(int id)
{
GetDepartments();
GetClients();
GetProjectType();
GetEmployee();
objProjectProperty = new Project_Property();
objProjectProperty.Project_Id = id;
//objClientProp.TableName = "tblClient";
objProjectBll = new Project_BLL(objProjectProperty);
DataTable dt = objProjectBll.SelectOneEdit();
ViewBag.Project = dt;
ViewBag.strtdate = objProjectProperty.Start_Date.ToString("yyyy-MM-dd");
ViewBag.wdate = objProjectProperty.Work_Date;
ViewBag.projcttype = objProjectProperty.Project_Type;
return(View("ProjectAdd", objProjectProperty));
}
public JsonResult DeleteProject(int id)
{
objProjectProperty = new Project_Property();
objProjectProperty.Project_Id = id;
// objProjectProperty.TableName = "tblClient";
objProjectProperty.Status = "Deleted";
// objClientProp.U_id = SessionManager.CurrentUser.ID;
objProjectBll = new Project_BLL(objProjectProperty);
var flag = objProjectBll.UpdateStatus();
if (flag)
{
return(Json(new { success = true, statuscode = 200, msg = "Successfull" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, statuscode = 500, msg = "Failed" }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult EndTime(Project_Employee_Working_hours_Property empprojectwork)
{
Project_Employee_Working_hours_Property objprojectempworking = new Project_Employee_Working_hours_Property();
objprojectempworking.projectid = empprojectwork.projectid;
objprojectempworking.status = empprojectwork.status;
var empid = Convert.ToInt32(SessionManager.CurrentUser.EmployeeID);
objprojectempworking.employeeid = empid;
objprojectempworking.TaskCompleted = empprojectwork.TaskCompleted;
objprojectempworking.endtime = DateTime.Now;// TimeSpan.Parse(DateTime.Now.ToString("HH:mm"));
objProjectBll = new Project_BLL();
string startdate = objProjectBll.GetStartDate(objprojectempworking);
var hours = (DateTime.Now - Convert.ToDateTime(startdate)).TotalHours;
objprojectempworking.totaltime = Convert.ToDecimal(Math.Round(hours, 2));
objProjectBll.EndTime(objprojectempworking);
return(Json(new { success = true, statuscode = 200, msg = "Successfully inserted" }, JsonRequestBehavior.AllowGet));
}
public ActionResult AddTimeLine()
{
TimeLine_Property objtimeline = new TimeLine_Property();
objtimeline.Project_Item = GetProjects();
objProjectProperty = new Project_Property();
objProjectBll = new Project_BLL(objProjectProperty);
DataTable projects = objProjectBll.SelectAll();
List <Project_Property> ProjectType_PropertylistItems = new List <Project_Property>();
foreach (DataRow dr in projects.Rows)
{
Project_Property objProjectType_Property = new Project_Property();
objProjectType_Property.Project_Name = dr["Project_Name"].ToString();
objProjectType_Property.Project_Id = Convert.ToInt32(dr["Project_Id"].ToString());
ProjectType_PropertylistItems.Add(objProjectType_Property);
}
objtimeline.Project_Item = ProjectType_PropertylistItems;
return(View(objtimeline));
}
public JsonResult AddTask(Project_Property Project)
{
if (ModelState.IsValid)
{
EmployeeProperty objempproperty = new EmployeeProperty();
objempproperty.Id = Project.Resource_Id;
Employee_BLL objemployeebll = new Employee_BLL(objempproperty);
DataTable dt = objemployeebll.SelectOne();
foreach (DataRow dr in dt.Rows)
{
Project.Employee_Cost = Math.Round(Convert.ToDecimal(dr["TotalSalary"].ToString()) / 270, 2);
}
//add new employee
if (Project.Project_Id == null || Project.Project_Id <= 0)
{
Project.DateCreated = DateTime.Now;
Project.Status = "Active";
Project.Is_Active = true;
Project.In_Progress = false;
Project.Is_Completed = false;
Project.Remarks = "";
//Project.Employee_Cost=
objProjectBll = new Project_BLL(Project);
var flag = objProjectBll.InsertTask();
if (flag)
{
return(Json(new { success = true, statuscode = 200, msg = "Successfully inserted" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, statuscode = 500, msg = "Failed" }, JsonRequestBehavior.AllowGet));
}
}
//when id <0 update case
else
{
Project.DateCreated = DateTime.Now;
Project.Status = "Active";
objProjectBll = new Project_BLL(Project);
var flag = objProjectBll.Insert();
if (flag)
{
return(Json(new { success = true, statuscode = 200, msg = "Successfully inserted" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, statuscode = 500, msg = "Failed" }, JsonRequestBehavior.AllowGet));
}
}
}
//when model state is not valid
else
{
var errors = ModelState.Select(x => x.Value.Errors)
.Where(y => y.Count > 0)
.ToList();
return(Json(new { success = false, statuscode = 500, msg = "Please Enter According To Instructions" }, JsonRequestBehavior.AllowGet));
}
}
