public void changeStatus(Cluster sCluster, string user) { using (DGGuardEntities entities = new DGGuardEntities()) { foreach (FactReport report in sCluster.Reports) { var data = entities.FactReports.FirstOrDefault(x => x.ReportID == report.ReportID); if (data != null) { if (data.StatusID < entities.DimStatus.Max(x => x.StatusID)) { string oldStat = data.DimStatu.StatusName; data.StatusID++; Change c = new Change() { ReportID = data.ReportID, UserName = user, Data = "Status Changed From " + oldStat + " To " + entities.DimStatus.First(x=>x.StatusID==data.StatusID+1).StatusName, Time = DateTime.Now }; entities.Changes.Add(c); } entities.SaveChanges(); } } } }
public void changeStatus(List<int> sCluster, string user) { using (DGGuardEntities entities = new DGGuardEntities()) { foreach (int reportID in sCluster) { var data = entities.FactReports.FirstOrDefault(x => x.ReportID == reportID); if (data != null) { if (data.StatusID < entities.DimStatus.Max(x => x.StatusID)) { string oldStat = data.DimStatu.StatusName; data.StatusID++; Change c = new Change() { ReportID = data.ReportID, UserName = user, Data = "Status Changed From " + oldStat + " To " + entities.DimStatus.First(x => x.StatusID == data.StatusID).StatusName, Time = DateTime.Now }; entities.Changes.Add(c); } try { entities.SaveChanges(); } catch (Exception ex) { Console.Write(ex.Message); } } } } }