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);
}
}
}
}
}
