//public ReleaseCP getReleseCPDataForView(int ReleseCPID)
//{
// using (IReleaseCPRepository db = new ReleaseCPRepository())
// {
// ReleaseCP ReleaseCPUpdated = db.FindSingle(m => m.ReleaseCPID == ReleaseCPView.ReleaseCPID).
// return DbSet.AsNoTracking().Where(r => r.ReleaseCPID == ReleseCPID).FirstOrDefault().Include(r=>r.Publication);
//}
//public int Edit(ReleaseCPView ReleaseCPView)
//{
// int Count = 0;
// using (IReleaseCPRepository db = new ReleaseCPRepository())
// {
// ReleaseCP ReleaseCPUpdated = db.FindSingle(m => m.ReleaseCPID == ReleaseCPView.ReleaseCPID);
// ReleaseCPUpdated.PublicationID = ReleaseCPView.PublicationID == 0 ? null : ReleaseCPView.PublicationID;
// ReleaseCPUpdated.ExceptionIndicator = ReleaseCPView.ExceptionIndicator;
// ReleaseCPUpdated.ExceptionDate = ReleaseCPView.ExceptionDate;
// ReleaseCPUpdated.ExceptionRemarks = ReleaseCPView.ExceptionRemarks;
// ReleaseCPUpdated.DelayReason = ReleaseCPView.DelayReason;
// ReleaseCPUpdated.DelayReasonHistory = ReleaseCPView.DelayReasonHistory;
// ReleaseCPUpdated.Comments = ReleaseCPView.Comments;
// ReleaseCPUpdated.IsVisible = ReleaseCPView.IsVisible;
// db.Edit(ReleaseCPUpdated);
// Count += await db.SaveAsync(User);
// }
// //if ReleaseCP edit and PublicationID not null edit PublicationMailDate
// //if (Count>0 && (ReleaseCPView.PublicationID ?? 0) > 0 )
// //{
// // using (IPublicationRepository db = new PublicationRepository())
// // {
// // Publication Pub = db.Find(ReleaseCPView.PublicationID);
// // Pub.PublicationMailDate = ReleaseCPView.PublicationMailDate;
// // db.Edit(Pub);
// // Count += await db.SaveAsync(User); ;
// // }
// //}
// return Count;
//}
public async Task <int> Edit(ReleaseCPView ReleaseCPView, WindowsPrincipal User)
{
//DbSet.AsNoTracking().Where(r => r.ReleaseID == releaseId)
// .Include(e => e.ReleaseMilestones)
int Count = 0;
using (IReleaseCPRepository db = new ReleaseCPRepository())
{
try
{
ReleaseCP ReleaseCPUpdated = db.GetReleaseCPId(ReleaseCPView.ReleaseCPID);
ReleaseCPUpdated.PublicationID = ReleaseCPView.PublicationID == 0 ? null : ReleaseCPView.PublicationID;
if (ReleaseCPUpdated.Publication != null)
{
ReleaseCPUpdated.Publication.PublicationMailDate = ReleaseCPView.PublicationMailDate;
}
ReleaseCPUpdated.ExceptionIndicator = ReleaseCPView.ExceptionIndicator;
ReleaseCPUpdated.ExceptionDate = ReleaseCPView.ExceptionDate;
ReleaseCPUpdated.ExceptionRemarks = ReleaseCPView.ExceptionRemarks;
ReleaseCPUpdated.DelayReason = ReleaseCPView.DelayReason;
ReleaseCPUpdated.DelayReasonHistory = ReleaseCPView.DelayReasonHistory;
ReleaseCPUpdated.Comments = ReleaseCPView.Comments;
ReleaseCPUpdated.IsDeleted = ReleaseCPView.IsDeleted;
db.Edit(ReleaseCPUpdated);
}
catch (Exception ex) { var y = ex; }
Count += await db.SaveAsync(User);
}
return(Count);
}
public async Task <int> SaveReleaseCPDetails(ReleaseCPView releaseCP)
{
int count = 0;
using (IReleaseCPRepository db = new ReleaseCPRepository())
{
count += await db.Edit(releaseCP, (WindowsPrincipal)User);
}
return(count);
}
public ReleaseMilstoneCP_Footer(ReleaseMilestone rm, List <int> cpids, ICollection <ReleaseCP> releaseCps, string accountName)
{
this.MilestoneName = rm.Milestone.Name;
this.MilestoneDate = FormatDateTime(rm.MilestoneDate);
ReleaseCPView releaseCP = null;
using (IReleaseCPRepository db = new ReleaseCPRepository())
{
releaseCP = new ReleaseCPView((!rm.Milestone.CPs.Any(cp => cp.MilestoneID == rm.MilestoneID && cpids.Contains(cp.CPID)))? null :
releaseCps.Where(r => r.ReleaseID == rm.ReleaseID &&
r.CPID == rm.Milestone.CPs.Where(cp => cp.MilestoneID == rm.MilestoneID && cpids.Contains(cp.CPID)).FirstOrDefault().CPID).FirstOrDefault(), accountName);
}
IsCreated = releaseCP != null;
this.CheckPointDate = this.IsCreated ? FormatDateTime(releaseCP.PlannedDate) : String.Empty;
this.CheckPointId = this.IsCreated ? releaseCP.ReleaseCPID : -1;
this.CPName = this.IsCreated ? releaseCP.CPName : String.Empty;
}
public async Task <int> Add(ReleaseCPView ReleaseCPView, WindowsPrincipal User)
{
using (IReleaseCPRepository db = new ReleaseCPRepository())
{
ReleaseCP ReleaseCP = new ReleaseCP
{
CPID = ReleaseCPView.CPID,
ReleaseID = ReleaseCPView.ReleaseID,
ExceptionIndicator = ReleaseCPView.ExceptionIndicator,
ExceptionDate = ReleaseCPView.ExceptionDate,
ExceptionRemarks = ReleaseCPView.ExceptionRemarks,
DelayReason = ReleaseCPView.DelayReason,
DelayReasonHistory = ReleaseCPView.DelayReasonHistory,
Comments = ReleaseCPView.Comments,
IsDeleted = ReleaseCPView.IsDeleted
};
db.Add(ReleaseCP);
return(await db.SaveAsync(User));
}
}
public PartialViewResult _ReleaseFooter(int releaseId)
{
Release releaseFooter;
//if after Save
if (CurrentRelease == null || CurrentRelease.ReleaseId != releaseId)
{
if (releaseId == 0)
{
return(PartialView());
}
else
{
using (IReleaseRepository db = new ReleaseRepository())
{
releaseFooter = db.GetReleaseCPData(releaseId);
}
}
}
else
{
releaseFooter = CurrentRelease.Release;
}
if (releaseFooter != null && releaseId != 0)
{
foreach (var rm in releaseFooter.ReleaseMilestones)
{
ViewData[rm.Milestone.Name] = String.Format("{0:d-MMM-yyyy}", rm.MilestoneDate);
}
ReleaseCPView rcpview;
foreach (var rcp in releaseFooter.ReleaseCPs)
{
rcpview = new ReleaseCPView(rcp, releaseFooter.Account.Name);
ViewData[rcpview.CPName.Trim().Replace(" ", String.Empty)] = rcpview.PlannedDate != null ? "(" + String.Format("{0:d-MMM-yyyy}", rcpview.PlannedDate) + ")" : String.Empty;
ViewData[rcpview.CPName.Trim().Replace(" ", String.Empty) + "id"] = rcpview.ReleaseCPID;
}
}
return(PartialView());
}