private List <ProjectMileStone> GetProjectMileStones(int itemsPerPage, int pageNumber, out int dataCount) { try { var projectMilestoneList = new ProjectMileStoneServices().GetAllOrderedProjectMileStones(itemsPerPage, pageNumber, out dataCount); if (!projectMilestoneList.Any()) { dataCount = 0; ViewBag.TotalPages = 0; ViewBag.Page = 1; return(new List <ProjectMileStone>()); } ViewBag.PrDataCount = dataCount.ToString(CultureInfo.InvariantCulture); var totalPages = dataCount / itemsPerPage; if (dataCount % itemsPerPage != 0) { totalPages++; } ViewBag.TotalPages = totalPages; ViewBag.Page = pageNumber; projectMilestoneList.Remove(projectMilestoneList.Find(m => m.ProjectMileStoneId == (int)ProjectMilestoneNotAvailable.Not_Available)); projectMilestoneList.ForEach(m => { var milestone = new ProjectMileStoneServices().GetProjectMileStone(m.ProjectMileStoneId); if (milestone != null && milestone.ProjectMileStoneId > 0) { m.ParentName = milestone.Title; } else { m.ParentName = "N/A"; } m.ProjectName = m.Project.Name; m.DateDueString = m.DateDue.ToString("yyyy/MM/dd"); m.MileStoneName = m.MilestoneStatu.Name; }); return(projectMilestoneList); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); dataCount = 0; ViewBag.TotalPages = 0; ViewBag.Page = 1; return(new List <ProjectMileStone>()); } }
public ActionResult GetAllProjectMileStones() { try { var projectMilestoneList = new ProjectMileStoneServices().GetProjectMileStones(); if (!projectMilestoneList.Any()) { return(Json(new List <ProjectMilestoneObject>(), JsonRequestBehavior.AllowGet)); } return(Json(projectMilestoneList, JsonRequestBehavior.AllowGet)); } catch (Exception) { return(Json(new List <ProjectMilestoneObject>(), JsonRequestBehavior.AllowGet)); } }
public ActionResult AddProjectMilestone(ProjectMileStone projectMileStone) { ModelState.Clear(); ViewBag.LoadStatus = "0"; try { if (!ModelState.IsValid) { projectMileStone.Error = "Please supply all required fields and try again"; projectMileStone.ErrorCode = -1; return(Json(projectMileStone, JsonRequestBehavior.AllowGet)); } var wx = ValidateControl(projectMileStone); if (wx.Code < 1) { projectMileStone.Error = wx.Error; projectMileStone.ErrorCode = -1; return(Json(projectMileStone, JsonRequestBehavior.AllowGet)); } projectMileStone.LastUpdated = DateTime.Now.ToString("yyyyMM/dd"); var k = new ProjectMileStoneServices().AddProjectMileStoneCheckDuplicate(projectMileStone); if (k < 1) { projectMileStone.Error = "Process Failed! Please contact the Admin or try again later"; projectMileStone.ErrorCode = 0; return(Json(projectMileStone, JsonRequestBehavior.AllowGet)); } projectMileStone.Error = "Record was added successfully"; projectMileStone.ErrorCode = 1; projectMileStone.ProjectMileStoneId = k; projectMileStone.DateDueString = projectMileStone.DateDue.ToString("yyyy/MM/dd"); return(Json(projectMileStone, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); projectMileStone.Error = "An unknown error was encountered. Request could not be serviced. Please try again later."; projectMileStone.ErrorCode = 0; return(Json(projectMileStone, JsonRequestBehavior.AllowGet)); } }
private List <ProjectMileStone> ProjectMileStonesForReport(long projectId) { try { var projectMilestoneList = new ProjectMileStoneServices().GetAllOrderedProjectMileStonesByProject(projectId); if (!projectMilestoneList.Any()) { return(new List <ProjectMileStone>()); } projectMilestoneList.ForEach(m => { if (m.ParentId > 0) { var milestone = new ProjectMileStoneServices().GetProjectMileStone(m.ParentId); if (milestone != null && milestone.ProjectMileStoneId > 0) { m.ParentName = milestone.Title; } else { m.ParentName = "N/A"; } } m.ProjectName = m.Project.Name; m.DateDueString = m.DateDue.ToString("yyyy/MM/dd"); m.MileStoneName = m.MilestoneStatu.Name; }); return(projectMilestoneList); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); return(new List <ProjectMileStone>()); } }
public ActionResult EditProjectMilestone(int id) { var projectMileStone = new ProjectMileStone(); try { if (id < 1) { projectMileStone.Error = "Invalid Selection!"; projectMileStone.ErrorCode = -1; return(Json(projectMileStone, JsonRequestBehavior.AllowGet)); } var myViewObj = new ProjectMileStoneServices().GetProjectMileStone(id); if (myViewObj == null || myViewObj.ProjectId < 1) { projectMileStone.Error = "Project MileStone Information could not be retrieved."; projectMileStone.ErrorCode = -1; return(Json(projectMileStone, JsonRequestBehavior.AllowGet)); } if (myViewObj.DateDue != null) { myViewObj.DateDueString = myViewObj.DateDue.ToString("yyyy/MM/dd"); } Session["_projectMileStone"] = myViewObj; myViewObj.ErrorCode = 7; return(Json(myViewObj, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); projectMileStone.Error = "An unknown error was ProjectMileStone Information could not be retrieved."; projectMileStone.ErrorCode = -1; return(Json(projectMileStone, JsonRequestBehavior.AllowGet)); } }
public ActionResult SaveToFolder(ProjectMileStone projectMileStone, HttpPostedFileBase file) { int dataCount; try { if (projectMileStone.ProjectId < 1 || projectMileStone.MileStoneStatusId < 1) { ViewBag.Title = "Manage Project Milestones"; ViewBag.ErrorCode = -1; ViewBag.ErrorMessage = "Please select the required fields and try again."; return(View("~/Views/ProjectMileStone/ProjectMileStones.cshtml", new ProjectMilestoneViewModel { MilestoneStatuses = GetMilestoneStatus(), Projects = GetProjects(), ProjectMileStones = GetProjectMileStones(ItemsPerPage, PageNumber, out dataCount) })); } if (file.ContentLength > 0) { const string folderPath = "~/BulkUploadTemplate"; var fileName = file.FileName; var path = folderPath + "/" + fileName; if (System.IO.File.Exists(Server.MapPath(path))) { System.IO.File.Delete(Server.MapPath(path)); } file.SaveAs(Server.MapPath(folderPath + "/" + fileName)); var mList = new List <ProjectMileStone>(); var msg = string.Empty; if ( !new ProjectMilestoneUploadManager().Import(Server.MapPath(path), "projectmilestones", ref mList, ref msg)) { ViewBag.ErrorCode = -1; ViewBag.ErrorMessage = "Bulk upload Failed! An unknown error was encountered."; return(View("~/Views/ProjectMileStone/ProjectMileStones.cshtml", new ProjectMilestoneViewModel { MilestoneStatuses = GetMilestoneStatus(), Projects = GetProjects(), CompletionStatuses = GetCompletionStatuses(), ProjectMileStones = GetProjectMileStones(ItemsPerPage, PageNumber, out dataCount) })); } if (!mList.Any()) { ViewBag.ErrorCode = -1; ViewBag.ErrorMessage = msg.Length > 0 ? msg : "Bulk upload Failed! unknown error occurred"; return(View("~/Views/ProjectMileStone/ProjectMileStones.cshtml", new ProjectMilestoneViewModel { MilestoneStatuses = GetMilestoneStatus(), Projects = GetProjects(), CompletionStatuses = GetCompletionStatuses(), ProjectMileStones = GetProjectMileStones(ItemsPerPage, PageNumber, out dataCount) })); } var errorList = new List <ProjectMileStone>(); foreach (var projectInfo in mList) { projectInfo.ParentId = (int)ProjectMilestoneNotAvailable.Not_Available; projectInfo.ProjectId = projectMileStone.ProjectId; projectInfo.LastUpdated = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss t"); projectInfo.MileStoneStatusId = projectMileStone.MileStoneStatusId; projectMileStone.DateDueString = projectMileStone.DateDue.ToString("yyyy/MM/dd"); var processedItem = new ProjectMileStoneServices().AddProjectMileStoneCheckDuplicate(projectInfo); if (processedItem < 1) { errorList.Add(projectInfo); } } if (errorList.Any()) { ViewBag.ErrorCode = -1; ViewBag.ErrorMessage = "Bulk upload failed"; ViewBag.ErrorList = errorList; return(View("~/Views/ProjectMileStone/ProjectMileStones.cshtml", new ProjectMilestoneViewModel { MilestoneStatuses = GetMilestoneStatus(), Projects = GetProjects(), CompletionStatuses = GetCompletionStatuses(), ProjectMileStones = GetProjectMileStones(ItemsPerPage, PageNumber, out dataCount) })); } ViewBag.ErrorCode = 1; ViewBag.ErrorMessage = "Bulk upload was successfully completed"; return(View("~/Views/ProjectMileStone/ProjectMileStones.cshtml", new ProjectMilestoneViewModel { MilestoneStatuses = GetMilestoneStatus(), Projects = GetProjects(), CompletionStatuses = GetCompletionStatuses(), ProjectMileStones = GetProjectMileStones(ItemsPerPage, PageNumber, out dataCount) })); } ViewBag.ErrorCode = -1; ViewBag.ErrorMessage = "Bulk upload Failed! unknown error occurred"; return(View("~/Views/ProjectMileStone/ProjectMileStones.cshtml", new ProjectMilestoneViewModel { MilestoneStatuses = GetMilestoneStatus(), Projects = GetProjects(), CompletionStatuses = GetCompletionStatuses(), ProjectMileStones = GetProjectMileStones(ItemsPerPage, PageNumber, out dataCount) })); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); ViewBag.ErrorCode = -1; ViewBag.ErrorMessage = "Bulk upload Failed! unknown error occurred"; return(View("~/Views/ProjectMileStone/ProjectMileStones.cshtml", new ProjectMilestoneViewModel { MilestoneStatuses = GetMilestoneStatus(), Projects = GetProjects(), CompletionStatuses = GetCompletionStatuses(), ProjectMileStones = GetProjectMileStones(ItemsPerPage, PageNumber, out dataCount) })); } }
public ActionResult EditProjectprojectMileStone(ProjectMileStone projectMileStone) { ModelState.Clear(); ViewBag.LoadStatus = "0"; try { if (Session["_projectMileStone"] == null) { projectMileStone.Error = "Session has expired"; projectMileStone.ErrorCode = 0; return(Json(projectMileStone, JsonRequestBehavior.AllowGet)); } var oldProjectMileStone = Session["_projectMileStone"] as ProjectMileStone; if (oldProjectMileStone == null || oldProjectMileStone.ProjectId < 1) { projectMileStone.Error = "Session has expired"; projectMileStone.ErrorCode = 0; return(Json(projectMileStone, JsonRequestBehavior.AllowGet)); } if (!ModelState.IsValid) { projectMileStone.Error = "Please supply all required fields Projects and try again"; projectMileStone.ErrorCode = -1; return(Json(projectMileStone, JsonRequestBehavior.AllowGet)); } if (projectMileStone.ProjectId < 1) { if (Session["_project_For_Milestone"] == null) { projectMileStone.Error = "Please select a valid Project"; projectMileStone.ErrorCode = -1; return(Json(projectMileStone, JsonRequestBehavior.AllowGet)); } var project = Session["_project_For_Milestone"] as Project; if (project == null || project.ProjectId < 1) { projectMileStone.Error = "Please select a valid Project"; projectMileStone.ErrorCode = -1; return(Json(projectMileStone, JsonRequestBehavior.AllowGet)); } projectMileStone.ProjectId = project.ProjectId; Session["_project_For_Milestone"] = null; } var wx = ValidateControl(projectMileStone); if (wx.Code < 1) { projectMileStone.Error = wx.Error; projectMileStone.ErrorCode = -1; return(Json(projectMileStone, JsonRequestBehavior.AllowGet)); } oldProjectMileStone.ParentId = projectMileStone.ParentId; oldProjectMileStone.ProjectId = projectMileStone.ProjectId; oldProjectMileStone.Title = projectMileStone.Title; oldProjectMileStone.DateDue = projectMileStone.DateDue; oldProjectMileStone.LastUpdated = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss t"); oldProjectMileStone.MileStoneStatusId = projectMileStone.MileStoneStatusId; projectMileStone.DateDueString = projectMileStone.DateDue.ToString("yyyy/MM/dd"); var k = new ProjectMileStoneServices().UpdateProjectMileStoneCheckDuplicate(oldProjectMileStone); if (k < 1) { projectMileStone.Error = "Process Failed! Please contact the Admin or try again later"; projectMileStone.ErrorCode = 0; return(Json(projectMileStone, JsonRequestBehavior.AllowGet)); } projectMileStone.Error = "Project MileStone Information was successfully updated"; projectMileStone.ErrorCode = 1; return(Json(projectMileStone, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message); projectMileStone.Error = "An unknown error was encountered. Request could not be serviced. Please try again later."; projectMileStone.ErrorCode = 0; return(Json(projectMileStone, JsonRequestBehavior.AllowGet)); } }