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);
}
}
}
}
}
public string RegisterUser(string username, string password, string permissions)
{
try
{
using (DGGuardEntities entities = new DGGuardEntities())
{
var data = entities.DimUsers.FirstOrDefault(x => x.UserName == username);
//check for exisiting username
if (data != null)
return JsonConvert.SerializeObject(false);
string s = StringCipher.CreateHash(password);
DimUser u = new DimUser
{
UserName = username,
Password = s.Split(':')[1],
Salt = s.Split(':')[0],
Permisssions = permissions
};
entities.DimUsers.Add(u);
entities.SaveChanges();
Logger.GetInstance.Log(LogType.Info, "New User Registerd");
return JsonConvert.SerializeObject(true);
}
}
catch (Exception ex)
{
Logger.GetInstance.Log(LogType.Error, "Registration Failed: " + ex.Message);
return JsonConvert.SerializeObject(false);
}
}
public void Log(LogType type, string message)
{
using (DGGuardEntities entities = new DGGuardEntities())
{
Log l = new Log { TimeStamp = DateTime.Now, Data = message, Type = type };
entities.Logs.Add(l);
entities.SaveChanges();
}
}
public string AuthenticateUser(string username, string password)
{
using (DGGuardEntities entities = new DGGuardEntities())
{
var data = entities.DimUsers.FirstOrDefault(x => x.UserName == username && x.Password == password);
if (data != null)
return JsonConvert.SerializeObject(true);
return JsonConvert.SerializeObject(false);
}
}
public string PostReport(string url, string img, string dom = "", int category = -1,
string name = "", string lName = "", string phone = "", string email = "",
string description = "", string location = "")
{
try
{
using (DGGuardEntities entities = new DGGuardEntities())
{
genPath = Server.MapPath("/UploadImage/");
;
string fileName = (DateTime.Now.ToString("yyyy-MM-dd_HHmmss") + ".png").Replace(" ", "");
try
{
byte[] data = Convert.FromBase64String(img);
var fs =
new BinaryWriter(new FileStream(Path.Combine(genPath, fileName), FileMode.Append,
FileAccess.Write));
fs.Write(data);
fs.Close();
}
catch (Exception ex)
{
Logger.GetInstance.Log(LogType.Error, "Unable to save Image: " + ex.Message);
}
FactReport f = new FactReport
{
URL = url,
TimeStamp = DateTime.Now,
Location = location,
Description = description,
Name = name,
LastName = lName,
Email = email,
Phone = phone,
ScreenShot = genPath + fileName,
DimCategory = entities.DimCategories.FirstOrDefault(x => x.CategoryId == category),
DimStatu = entities.DimStatus.FirstOrDefault(x => x.StatusID == 0)
};
entities.FactReports.Add(f);
entities.SaveChanges();
}
return "Success";
}
catch (Exception ex)
{
Logger.GetInstance.Log(LogType.Error, "PostReport Failed: "+ ex.Message);
return "fail";
}
}
public string AuthenticateUser(string username, string password)
{
try
{
using (DGGuardEntities entities = new DGGuardEntities())
{
var data = entities.DimUsers.FirstOrDefault(x => x.UserName == username);
if (data != null)
{
return
JsonConvert.SerializeObject(StringCipher.ValidatePassword(password, data.Password, data.Salt));
}
return JsonConvert.SerializeObject(false);
}
}
catch (Exception ex)
{
Logger.GetInstance.Log(LogType.Error, "Authentication Failed: " + ex.Message);
return JsonConvert.SerializeObject(false);
}
}
public string PostReportImage(string img)
{
using (DGGuardEntities entities = new DGGuardEntities())
{
string fileName = DateTime.Now + ".png";
byte[] data = Convert.FromBase64String(img);
var fs =
new BinaryWriter(new FileStream(genPath + fileName, FileMode.Append,
FileAccess.Write));
fs.Write(data);
fs.Close();
}
return "sucess";
}
public string GetCategories()
{
using (DGGuardEntities entities = new DGGuardEntities())
{
var data = entities.DimCategories.ToList();
JsonSerializerSettings settings = new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
};
return JsonConvert.SerializeObject(data, settings);
}
}
public string GetUserActions(string user)
{
using (DGGuardEntities entities = new DGGuardEntities())
{
var data = entities.Changes.Where(x => x.UserName == user).ToList();
JsonSerializerSettings settings = new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
};
return JsonConvert.SerializeObject(data, settings);
}
}
public string GetSubReports(string url)
{
using (DGGuardEntities entities = new DGGuardEntities())
{
var data = entities.FactReports.Where(x => x.URL == url);
JsonSerializerSettings settings = new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
};
return JsonConvert.SerializeObject(data, settings);
}
}
public string GetReports()
{
using (DGGuardEntities entities = new DGGuardEntities())
{
var data = entities.FactReports.Where(x => x.StatusID != 2).ToList();
List<Cluster> list = new List<Cluster>();
foreach (FactReport report in data)
{
Cluster c = list.FirstOrDefault(x => String.Equals(x.URL, report.URL));
if (c == null)
{
c = new Cluster() { URL = report.URL, status = report.DimStatu };
list.Add(c);
}
c.Amount++;
c.Reports.Add(report);
}
JsonSerializerSettings settings = new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
};
return JsonConvert.SerializeObject(list, settings);
}
}
public string GetStatistics()
{
using (DGGuardEntities entities = new DGGuardEntities())
{
string stat = "{";
var data = entities.FactReports.ToList();
stat += "\"Reports\":{\"NumberofPending\":" + data.Count(x => x.StatusID == 0) + "," +
"\"NumberofInProgress\":" + data.Count(x => x.StatusID == 1) + "," +
"\"NumberofDone\":" + data.Count(x => x.StatusID == 2) + "}";
stat += ",\"Categories\":[";
foreach (DimCategory category in entities.DimCategories.ToList())
{
stat += "{\"Name\":\"" + category.Category +
"\",\"AmountOfReports\":" + category.FactReports.Count + "},";
}
stat = stat.Substring(0, stat.Length - 1) + "]";
return stat + "}";
}
}
public string GetReports()
{
List<Cluster> list = new List<Cluster>();
try
{
using (DGGuardEntities entities = new DGGuardEntities())
{
var data = entities.FactReports.Where(x => x.StatusID < 2).ToList();
foreach (FactReport report in data)
{
Cluster c = list.FirstOrDefault(x => String.Equals(x.URL, report.URL));
if (c == null)
{
c = new Cluster
{
URL = report.URL,
status = new DimStatuPrivate(report.DimStatu.StatusID, report.DimStatu.StatusName)
};
if (report.TimeStamp > c.Time)
c.Time = report.TimeStamp;
list.Add(c);
}
c.Amount++;
c.Reports.Add(new FaceReportPrivate(report));
}
}
JsonSerializerSettings settings = new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
};
return JsonConvert.SerializeObject(list, settings);
}
catch (Exception e)
{
Logger.GetInstance.Log(LogType.Error, "GetRerpots Failed: " + e.Message);
return "";
}
}
public string GetAllReports()
{
try
{
using (DGGuardEntities entities = new DGGuardEntities())
{
var data = entities.FactReports.ToList();
List<FaceReportPrivate> list = data.Select(factReport => new FaceReportPrivate(factReport)).ToList();
JsonSerializerSettings settings = new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
};
return JsonConvert.SerializeObject(list, settings);
}
}
catch (Exception ex)
{
Logger.GetInstance.Log(LogType.Error, "GetAllReports Failed: " + ex.Message);
return JsonConvert.SerializeObject(false);
}
}