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