public static List<ProjectMilestoneModel> GetProjectMileStones(int projectId)
{
try
{
List<ProjectMilestoneModel> lstMileStoneModel = new List<ProjectMilestoneModel>();
using (DCSEntities db = new DCSEntities())
{
var result = db.Database.SqlQuery<ProjectMilestoneModel>("usp_GetProjectMileStones @ProjectId", new SqlParameter("@ProjectId", projectId)).ToList();
if (result != null && result.Count > 0)
{
foreach (var x in result)
{
ProjectMilestoneModel objProjectMileStoneModel = new ProjectMilestoneModel();
objProjectMileStoneModel.ID = x.ID;
objProjectMileStoneModel.Name = x.Name;
objProjectMileStoneModel.StartDate = x.StartDate;
objProjectMileStoneModel.Complete = x.Complete;
objProjectMileStoneModel.MilestoneStatus = x.MilestoneStatus;
lstMileStoneModel.Add(objProjectMileStoneModel);
}
}
return lstMileStoneModel;
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List<ETOPlaybookModel> GetETOPlayBookMileStones()
{
try
{
List<ETOPlaybookModel> lstMileStoneModel = new List<ETOPlaybookModel>();
using (DCSEntities db = new DCSEntities())
{
var result = db.Database.SqlQuery<ETOPlaybookModel>("usp_GetETOPlayBookMileStones").ToList();
if (result != null && result.Count > 0)
{
foreach (var x in result)
{
ETOPlaybookModel objETOPlaybookMileStoneModel = new ETOPlaybookModel();
objETOPlaybookMileStoneModel.ID = x.ID;
objETOPlaybookMileStoneModel.Name = x.Name;
objETOPlaybookMileStoneModel.IsActive = x.IsActive;
lstMileStoneModel.Add(objETOPlaybookMileStoneModel);
}
}
return lstMileStoneModel;
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool RemoveProject(int projectId)
{
try
{
using (DCSEntities context = new DCSEntities())
{
SqlParameter prmProjectId = new SqlParameter("@ProjectId", projectId);
var result = context.Database.ExecuteSqlCommand("usp_RemoveProject @ProjectId", prmProjectId);
return result > 0 ? true : false;
}
}
catch (Exception ex)
{
throw ex;
}
}
public static string RemoveOwner(int ownerId)
{
string status = string.Empty;
try
{
using (DCSEntities context = new DCSEntities())
{
ProjectOwnerModel model = new ProjectOwnerModel();
SqlParameter prmProjectId = new SqlParameter("@OwnerId", ownerId);
var result = context.Database.SqlQuery<ProjectOwnerModel>("usp_RemoveOwner @OwnerId", prmProjectId).SingleOrDefault();
if (result != null)
{
status = result.Status;
}
return status;
}
}
catch (Exception ex)
{
return status;
}
}
public static ProjectSummaryDetailModel GetProjectSummaryDetail(int projectId)
{
try
{
ProjectSummaryDetailModel objSummaryModel = null;
using (DCSEntities context = new DCSEntities())
{
var result = context.usp_GetProjectSummaryDetails2(projectId).FirstOrDefault();
if (result != null)
{
objSummaryModel = new ProjectSummaryDetailModel();
objSummaryModel.AnthemOwner = result.FullName;
objSummaryModel.PartnerName = result.PartnerName;
objSummaryModel.ETOPlayBookName = result.EtoPlayBookName;
objSummaryModel.ProjectAccomplishments = result.Accomplishments;
objSummaryModel.ProjectFundingAsk = result.FundingAsk;
objSummaryModel.ProjectComplete = result.ProjectComplete.HasValue ? result.ProjectComplete.Value : decimal.MinValue;
objSummaryModel.ProjectDescription = result.ProjectDescription;
objSummaryModel.ProjectDirection = result.Direction;
objSummaryModel.ProjectEndDateString = result.ProjectEndDate.HasValue ? result.ProjectEndDate.Value.ToShortDateString() : DateTime.MinValue.ToShortDateString();
objSummaryModel.ProjectExecutiveSummary = result.ExecutiveStatus;
objSummaryModel.ProjectId = result.ID;
objSummaryModel.ProjectKeyRiskIssues = result.KeyRisksAndIssues;
objSummaryModel.ProjectName = result.ProjectName;
objSummaryModel.ProjectStartDateString = result.ProjectStartDate.HasValue ? result.ProjectStartDate.Value.ToShortDateString() : DateTime.MinValue.ToShortDateString();
objSummaryModel.ProjectStartDate = result.ProjectStartDate.HasValue ? result.ProjectStartDate.Value : DateTime.MinValue;
objSummaryModel.ProjectEndDate = result.ProjectEndDate.HasValue ? result.ProjectEndDate.Value : DateTime.MinValue;
objSummaryModel.ScopeId = result.ScopeId.HasValue ? result.ScopeId.Value : int.MinValue;
objSummaryModel.ResourceId = result.ResourcesId.HasValue ? result.ResourcesId.Value : int.MinValue;
objSummaryModel.FinancialId = result.FinancialId.HasValue ? result.FinancialId.Value : int.MinValue;
objSummaryModel.OverallStatusId = result.ProjectStatusId.HasValue ? result.ProjectStatusId.Value : int.MinValue;
objSummaryModel.ScheduleId = result.ScheduleId.HasValue ? result.ScheduleId.Value : int.MinValue;
List<MileStone> lstMileStones = new List<MileStone>();
var resultMileStones = context.ProjectMilestones.Where(x => x.ProjectId == projectId).ToList();
if (resultMileStones != null && resultMileStones.Count > 0)
{
foreach (var mileStone in resultMileStones)
{
MileStone objMileStone = new MileStone();
objMileStone.Title = mileStone.Name;
objMileStone.MileStoneDate = mileStone.StartDate.HasValue ? mileStone.StartDate.Value : DateTime.MinValue;
objMileStone.DateString = mileStone.StartDate.HasValue ? string.Format("{0:MM/dd/yyyy}", mileStone.StartDate.Value.ToShortDateString()) : DateTime.MinValue.ToShortDateString();
objMileStone.MilestoneStatus = mileStone.MilestoneStatus.GetValueOrDefault();
lstMileStones.Add(objMileStone);
}
}
objSummaryModel.ProjectMileStones = lstMileStones;
}
}
return objSummaryModel;
}
catch (Exception ex)
{
throw ex;
}
}
public static List<ProjectSummaryModel> GetAllProjectsSummary()
{
try
{
List<ProjectSummaryModel> lstSummaryModel = new List<ProjectSummaryModel>();
using (DCSEntities db = new DCSEntities())
{
var result = db.usp_GetAllProjectsSummary().ToList();
if (result != null && result.Count > 0)
{
foreach (var x in result)
{
ProjectSummaryModel objProjectSummaryModel = new ProjectSummaryModel();
objProjectSummaryModel.AnthemOwner = x.AnthemOwner;
objProjectSummaryModel.AnthemOwnerEmail = x.AnthemEmail;
objProjectSummaryModel.ExternalOwner = x.ExternalOwner;
objProjectSummaryModel.ExternalOwnerEmail = x.ExternalEmail;
objProjectSummaryModel.IsETOPlayBook = x.IsETOPlayBook;
objProjectSummaryModel.IsPeerReview = x.IsPeerReview;
objProjectSummaryModel.ProjectComplete = x.ProjectComplete;
objProjectSummaryModel.ProjectDaysRemaining =x.ProjectDaysRemaining.HasValue ? x.ProjectDaysRemaining.Value : decimal.MinValue;
objProjectSummaryModel.ProjectEffortRemaining = x.ProjectEffortRemaining;
objProjectSummaryModel.ProjectEndDate = x.ProjectEndDate;
objProjectSummaryModel.ProjectEndDateString = string.Format("{0:MM-dd-yyyy}", x.ProjectEndDate.ToShortDateString());
objProjectSummaryModel.ProjectFinancial = x.ProjectFinancial;
objProjectSummaryModel.ProjectNumber = x.ProjectNumber;
objProjectSummaryModel.ProjectId = x.ProjectId;
objProjectSummaryModel.ProjectName = x.ProjectName;
objProjectSummaryModel.ProjectOverAll = x.ProjectOverAll;
objProjectSummaryModel.ProjectRAGStatus = x.ProjectRAGStatus;
objProjectSummaryModel.ProjectResource = x.ProjectResource;
objProjectSummaryModel.ProjectSchedule = x.ProjectSchedule;
objProjectSummaryModel.ProjectScope = x.ProjectScope;
objProjectSummaryModel.ProjectStartDate = x.ProjectStartDate;
objProjectSummaryModel.ProjectStartDateString = string.Format("{0:MM-dd-yyyy}", x.ProjectStartDate.ToShortDateString());
int ProjectModifiedDiff = x.ProjectModifedDiff.GetValueOrDefault();
int MilestoneModifiedDiff = x.MilestoneModifiedDiff.GetValueOrDefault();
int StatusModifiedDiff = x.StatusModifiedDiff.GetValueOrDefault();
objProjectSummaryModel.ProjectLastUpdateString = (ProjectModifiedDiff <= MilestoneModifiedDiff && ProjectModifiedDiff <= StatusModifiedDiff) ? Convert.ToString(x.ProjectModifedDate) : (MilestoneModifiedDiff <= StatusModifiedDiff ? Convert.ToString(x.MilestoneModifiedDate) : Convert.ToString(x.StatusModifiedDate));
string TimestampDetail = x.TimestampModifiedDetail;
if(TimestampDetail != null)
{
string[] splitColumns = TimestampDetail.Trim(',').Split(',');
if(splitColumns != null && splitColumns.Length > 0)
{
for (int i = 0; i < splitColumns.Length; i++)
{
string[] splitTime = splitColumns[i].Trim('~').Split('~');
if (splitTime != null && splitTime.Length > 0)
{
if (splitTime[0].ToString().Trim() == "Name")
{
objProjectSummaryModel.ProjectNameModifiedDate = Convert.ToString(splitTime[1]);
}
if (splitTime[0].ToString().Trim() == "EOPlaybook")
{
objProjectSummaryModel.ETOPlayBookModifiedDate = Convert.ToString(splitTime[1]);
}
if (splitTime[0].ToString().Trim() == "PeerReview")
{
objProjectSummaryModel.PeerReviewModifiedDate = Convert.ToString(splitTime[1]);
}
if (splitTime[0].ToString().Trim() == "ProjectOwnerANTMId")
{
objProjectSummaryModel.AnthemOwnerModifiedDate = Convert.ToString(splitTime[1]);
}
if (splitTime[0].ToString().Trim() == "ProjectOwnerExternalId")
{
objProjectSummaryModel.ExternalOwnerModifiedDate = Convert.ToString(splitTime[1]);
}
if (splitTime[0].ToString().Trim() == "StartDate")
{
objProjectSummaryModel.ProjectStartDateModifiedDate = Convert.ToString(splitTime[1]);
}
if (splitTime[0].ToString().Trim() == "EndDate")
{
objProjectSummaryModel.ProjectEndDateModifiedDate = Convert.ToString(splitTime[1]);
}
if (splitTime[0].ToString().Trim() == "Complete")
{
objProjectSummaryModel.ProjectCompleteModifiedDate = Convert.ToString(splitTime[1]);
}
if (splitTime[0].ToString().Trim() == "ScheduleId")
{
objProjectSummaryModel.ProjectScheduleModifiedDate = Convert.ToString(splitTime[1]);
}
if (splitTime[0].ToString().Trim() == "ScopeId")
{
objProjectSummaryModel.ProjectScopeModifiedDate = Convert.ToString(splitTime[1]);
}
if (splitTime[0].ToString().Trim() == "ResourcesId")
{
objProjectSummaryModel.ProjectResourceModifiedDate = Convert.ToString(splitTime[1]);
}
if (splitTime[0].ToString().Trim() == "FinancialId")
{
objProjectSummaryModel.ProjectFinancialModifiedDate = Convert.ToString(splitTime[1]);
}
if (splitTime[0].ToString().Trim() == "ProjectStatusId")
{
objProjectSummaryModel.ProjectOverAllModifiedDate = Convert.ToString(splitTime[1]);
}
if (splitTime[0].ToString().Trim() == "ProjectNumber")
{
objProjectSummaryModel.ProjectNumberModifiedDate = Convert.ToString(splitTime[1]);
}
}
}
}
}
else
{
objProjectSummaryModel.ProjectNumberModifiedDate = objProjectSummaryModel.ProjectLastUpdateString;
objProjectSummaryModel.ProjectNameModifiedDate = objProjectSummaryModel.ProjectLastUpdateString;
objProjectSummaryModel.ETOPlayBookModifiedDate = objProjectSummaryModel.ProjectLastUpdateString;
objProjectSummaryModel.PeerReviewModifiedDate = objProjectSummaryModel.ProjectLastUpdateString;
objProjectSummaryModel.AnthemOwnerModifiedDate = objProjectSummaryModel.ProjectLastUpdateString;
objProjectSummaryModel.ExternalOwnerModifiedDate =objProjectSummaryModel.ProjectLastUpdateString;
objProjectSummaryModel.ProjectStartDateModifiedDate = objProjectSummaryModel.ProjectLastUpdateString;
objProjectSummaryModel.ProjectEndDateModifiedDate = objProjectSummaryModel.ProjectLastUpdateString;
objProjectSummaryModel.ProjectCompleteModifiedDate = objProjectSummaryModel.ProjectLastUpdateString;
objProjectSummaryModel.ProjectScheduleModifiedDate = objProjectSummaryModel.ProjectLastUpdateString;
objProjectSummaryModel.ProjectScopeModifiedDate = objProjectSummaryModel.ProjectLastUpdateString;
objProjectSummaryModel.ProjectResourceModifiedDate = objProjectSummaryModel.ProjectLastUpdateString;
objProjectSummaryModel.ProjectFinancialModifiedDate = objProjectSummaryModel.ProjectLastUpdateString;
objProjectSummaryModel.ProjectOverAllModifiedDate = objProjectSummaryModel.ProjectLastUpdateString;
}
lstSummaryModel.Add(objProjectSummaryModel);
}
}
return lstSummaryModel;
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool RemoveProjectMileStone(ProjectMilestoneModel objProjectMileStone)
{
try
{
using (DCSEntities db = new DCSEntities())
{
List<object> paramObject = new List<object>();
paramObject.Add(new SqlParameter("@MileStoneId", objProjectMileStone.ID));
paramObject.Add(new SqlParameter("@ProjectId", objProjectMileStone.ProjectId));
var result = db.Database.ExecuteSqlCommand("usp_RemoveProjectMileStone @MileStoneId,@ProjectId", paramObject.ToArray());
if (result > 0)
{
return true;
}
else
{
return false;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SaveProjectMileStone(ProjectMilestoneModel objProjectMileStone)
{
try
{
using (DCSEntities db = new DCSEntities())
{
List<object> paramObject = new List<object>();
paramObject.Add(new SqlParameter("@MileStoneId", objProjectMileStone.ID));
paramObject.Add(new SqlParameter("@ProjectId", objProjectMileStone.ProjectId));
paramObject.Add(new SqlParameter("@Name", objProjectMileStone.Name));
paramObject.Add(new SqlParameter("@StartDate", objProjectMileStone.StartDate));
paramObject.Add(new SqlParameter("@Complete", objProjectMileStone.Complete));
paramObject.Add(new SqlParameter("@MilestoneStatus", objProjectMileStone.MilestoneStatus));
// paramObject.Add(new SqlParameter("@ModifiedDate", objProjectMileStone.ModifiedDate));
var result = db.Database.ExecuteSqlCommand("usp_SaveProjectMileStone @MileStoneId,@ProjectId,@Name,@StartDate,@Complete,@MilestoneStatus", paramObject.ToArray());
if (result > 0)
{
return true;
}
else
{
return false;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public ETOPlaybookDTOController()
//: base(DependencyResolver.Current.GetService<IODataRepository<ETOPlaybook>>())
{
_context = new DCSEntities();
}
