public static void DeleteRecipientById(string RecipientId) { ObserverDbContext _db = new ObserverDbContext(); _db.Recipients.Where(e => e.Id == RecipientId).FirstOrDefault().Deleted = true; _db.SaveChanges(); }
public static string GenerateLoginQRCode(string KeyLink) { string id = Guid.NewGuid().ToString(); string Url = HttpRuntime.AppDomainAppPath; string fileName = "Content/QRCode/" + id + ".png"; string fullPath = Path.Combine(Url, fileName); //string Url = "ftp://sg1-wss1%[email protected]/QRCode/" + id + ".png"; QRCodeGenerator qrGenerator = new QRCodeGenerator(); QRCodeData qrCodeData = qrGenerator.CreateQrCode(KeyLink, QRCodeGenerator.ECCLevel.Q); QRCode qrCode = new QRCode(qrCodeData); Bitmap qrCodeImage = qrCode.GetGraphic(20); //FtpWebRequest request = (FtpWebRequest)WebRequest.Create(Url); //request.Credentials = new NetworkCredential("sg1-wss1\\itzmoon", "pD74W87h^#"); //request.Method = WebRequestMethods.Ftp.UploadFile; using (MemoryStream memory = new MemoryStream()) { using (FileStream fs = new FileStream(fullPath, FileMode.Create, FileAccess.ReadWrite)) { qrCodeImage.Save(memory, ImageFormat.Png); byte[] bytes = memory.ToArray(); fs.Write(bytes, 0, bytes.Length); } } //} ObserverDbContext _db = new ObserverDbContext(); string url = _db.WebConfigs .Where(e => e.Key == "SITE_URL") .FirstOrDefault() .Value + "/Content/QRCode/" + id + ".png"; return(url); }
public EventController( ACTokenValidator tokenManager, ObserverDbContext dbContext) { _tokenManager = tokenManager; _dbContext = dbContext; }
public static void DeleteStepById(string StepId) { using (ObserverDbContext _db = new ObserverDbContext()) { StepsModel model = _db.Steps .Where(e => e.Id == StepId) .FirstOrDefault(); int numOrder = model.Order.GetValueOrDefault(); string observeId = model.Observes.Id; model.Deleted = true; model.Order = 0; List <StepsModel> listModel = _db.Steps .Where(e => e.Observes.Id == observeId) .ToList(); foreach (StepsModel item in listModel) { if (item.Order > numOrder) { item.Order = item.Order - 1; } } _db.SaveChanges(); } }
public ActionResult Logout(string from = null) { if (from == "fb") { //AuthenticationManager.SignOut(DefaultAuthenticationTypes.ApplicationCookie); return(RedirectToAction("Index", "Home", new { status = 4 })); } else if (from == "fbexpired") { return(RedirectToAction("Index", "Home", new { status = 5 })); } ObserverDbContext _db = new ObserverDbContext(); HttpCookie SessionCookie = new HttpCookie("SessionId"); SessionCookie.Value = null; SessionCookie.Expires = DateTime.Now.AddYears(-10); Response.SetCookie(SessionCookie); HttpCookie SessionKeyCookie = new HttpCookie("SessionKey"); SessionKeyCookie.Value = null; SessionKeyCookie.Expires = DateTime.Now.AddYears(-10); Response.SetCookie(SessionKeyCookie); AuthenticationManager.SignOut(DefaultAuthenticationTypes.ApplicationCookie); return(RedirectToAction("Index", "Home", new { status = 3 })); }
public ActionResult ObserveM() { if (!Request.Browser.IsMobileDevice) { return(RedirectToAction("Index")); } string UserId = User.Identity.GetUserId(); ObserverDbContext _db = new ObserverDbContext(); List <ObservesModel> oriList = _db.Observes .Where(e => e.Users.Id == UserId && e.Deleted == false) .OrderByDescending(e => e.DateCreated) .ToList(); List <ObserveListOutputModel> newList = new List <ObserveListOutputModel>(); foreach (ObservesModel item in oriList) { ObserveListOutputModel model = new ObserveListOutputModel() { Id = item.Id, Name = item.Name, Status = item.Status.GetValueOrDefault(), DateCreated = item.DateCreated.AddHours(8).ToString("dd/MM/yy") }; newList.Add(model); } return(View(newList)); }
public static void DetectResponseIrregularity(string StepId, int Minutes) { ObserverDbContext _db = new ObserverDbContext(); StepsModel stepsModel = _db.Steps .Where(e => e.Id == StepId) .FirstOrDefault(); int minute = (int)DateTime.UtcNow.Subtract(stepsModel.CheckedTime).TotalMinutes; try { if (minute > Minutes) { string ObservesId = ObserveServiceManager.GetObserveByStepId(StepId).Id; ObservesModel model = _db.Observes.Where(r => r.Id == ObservesId).FirstOrDefault(); model.Status = 0; _db.SaveChanges(); foreach (RecipientsModel item in model.List_Recipients.Where(e => e.Deleted == false).ToList()) { EmailServiceManager.CatchErrorNotification(model.Name, item.Email); } } } catch (NullReferenceException e) { e.ToString(); } }
public static void CreateNewUser(UsersModel users) { ObserverDbContext _db = new ObserverDbContext(); _db.Users.Add(users); _db.SaveChanges(); }
public static List <PCMethodsModel> GetPCMethodList() { ObserverDbContext _db = new ObserverDbContext(); return(_db.PCMethods .ToList()); }
public static List <RecipientsModel> GetRecipientList(string ObserveId) { ObserverDbContext _db = new ObserverDbContext(); return(_db.Recipients .Where(e => e.Observes.Id == ObserveId && e.Deleted == false) .ToList()); }
private async Task AllClean(ObserverDbContext dbContext) { var oldestRecordTime = DateTime.UtcNow - TimeSpan.FromDays(7); var items = await dbContext.ErrorLogs.Where(t => t.LogTime < oldestRecordTime).ToListAsync(); dbContext.ErrorLogs.RemoveRange(items); await dbContext.SaveChangesAsync(); }
public static PCMethodsModel GetPCMethodById(string Id) { ObserverDbContext _db = new ObserverDbContext(); return(_db.PCMethods .Where(e => e.Id == Id) .FirstOrDefault()); }
public static List <StepsModel> GetStepListByObserveId(String ObserveId) { ObserverDbContext _db = new ObserverDbContext(); return(_db.Steps .Where(e => e.Observes.Id == ObserveId && e.Deleted == false) .OrderBy(e => e.Order) .ToList()); }
public async Task <JsonResult> ExecuteBatchStepByObserveId(string ObserveId) { ObserverDbContext _db = new ObserverDbContext(); ObservesModel model = _db.Observes .Where(e => e.Id == ObserveId) .FirstOrDefault(); if (model.Users.Id == User.Identity.GetUserId()) { List <StepsModel> listModel = _db.Observes.Where(e => e.Id == ObserveId).FirstOrDefault().List_Steps.Where(e => e.Deleted == false).OrderBy(e => e.Order).ToList(); List <StepExecutionInputModel> inputList = new List <StepExecutionInputModel>(); PCMethodsModel pcMethodsModel = null; foreach (StepsModel item in listModel) { string PC1 = null; string PC2 = null; int PCMethod = 0; if (item.PC_Method != null) { pcMethodsModel = PCMethodServiceManager.GetPCMethodById(item.PC_Method.Id); PC1 = pcMethodsModel.PC1; PC2 = pcMethodsModel.PC2; PCMethod = int.Parse(item.PC_Method.Id); } StepExecutionInputModel input = new StepExecutionInputModel() { Order = item.Order.GetValueOrDefault(), Uri = item.Url, Method = item.Method.GetValueOrDefault(), PC_Method = PCMethod, PC1 = item.PC1, PC2 = item.PC2, PC2Secret = item.PC2Secret, CustomHeader = item.PredefinedHeader, UseHeader = item.SetHeader.GetValueOrDefault(), LabelPC1 = PC1, LabelPC2 = PC2 }; inputList.Add(input); } return(Json(await StepServiceManager.ExecuteBatchStepReturningResult(inputList))); } else { StepExecutionOutputModel input = new StepExecutionOutputModel() { Status = "Unauthorized" }; return(Json(input)); } }
public EventController( ACTokenValidator tokenManager, ObserverDbContext dbContext, CannonQueue cannon) { _tokenManager = tokenManager; _dbContext = dbContext; _cannon = cannon; }
public static void SetCatchByStepId(string StepId, string CatchId) { ObserverDbContext _db = new ObserverDbContext(); CatchesModel catchesModel = _db.Catches.Where(e => e.Id == CatchId).FirstOrDefault(); _db.Steps.Where(e => e.Id == StepId).FirstOrDefault().Catches = catchesModel; _db.SaveChanges(); }
public JsonResult GetStepDetail(string StepId) { if (ObserveServiceManager.GetObserveByStepId(StepId).Users.Id == User.Identity.GetUserId()) { int numPC = 0; string PC1Label = null; string PC2Label = null; string decrypted = null; ObserverDbContext _db = new ObserverDbContext(); StepsModel model = _db.Steps.Where(e => e.Id == StepId).FirstOrDefault(); if (model.PC_Method != null) { PCMethodsModel models = model.PC_Method; numPC = models.Type; PC1Label = models.PC1; PC2Label = models.PC2; } int pcmethod = 0; if (model.PC_Method != null) { pcmethod = int.Parse(model.PC_Method.Id); } if (model.PC2 != null) { decrypted = EncryptionAlgorithmServiceManager.DecryptStringFromBytes_Aes(Convert.FromBase64String(model.PC2), Convert.FromBase64String(_db._AESSecretKeyS), Convert.FromBase64String(model.PC2Secret)); } StepDetailOutputModel outputModel = new StepDetailOutputModel() { StepId = model.Id, Url = model.Url, Method = model.Method.GetValueOrDefault(), Header = model.SetHeader.GetValueOrDefault(), Priority = model.Order.GetValueOrDefault(), PredefinedHeader = model.PredefinedHeader, Status = "Authorized", PC_Method = pcmethod, PC1 = model.PC1, PC2 = decrypted, PC1Label = PC1Label, PC2Label = PC2Label, numPC = numPC }; return(Json(outputModel)); } else { return(Json(JsonConvert.DeserializeObject("{ 'Status': 'Unauthorized' }"))); } }
public static ObservesModel GetObserveById(string Id) { ObserverDbContext _db = new ObserverDbContext(); ObservesModel query = _db.Observes .Where(e => e.Id == Id) .FirstOrDefault(); return(query); }
public static void DeleteObserveById(string Id) { ObserverDbContext _db = new ObserverDbContext(); var query = _db.Observes .Where(e => e.Id == Id) .FirstOrDefault(); query.Deleted = true; _db.SaveChanges(); }
public static List <ObservesModel> GetObserveListByAspId(string AspId) { ObserverDbContext _db = new ObserverDbContext(); List <ObservesModel> query = _db.Observes .Where(e => e.Users.Id == AspId && e.Deleted == false) .ToList(); return(query); }
public static void SetIntervalByObserveId(string ObserveId, int Interval) { ObserverDbContext _db = new ObserverDbContext(); var query = _db.Observes.Where(e => e.Id == ObserveId).FirstOrDefault(); query.Interval = Interval; query.NextRun = DateTime.UtcNow; _db.SaveChanges(); }
public async Task <ActionResult> VerifyEmail(string Id, string Key) { ObserverDbContext _db = new ObserverDbContext(); var query = _db.PendingUsers .Where(e => e.Id == Id && e.Key == Key) .OrderByDescending(e => e.DateCreated) .ToList(); if (query.Count > 0) { var query2 = query.FirstOrDefault(); if (query2.DateCreated.AddHours(1) < DateTime.UtcNow) { return(RedirectToAction("Index", "Home", new { status = 8 })); } else if (query2.Id == Id && query2.Key == Key) { query2.Status = 1; var user = new ApplicationUser { UserName = query2.Email, Email = query2.Email, LockoutEndDateUtc = System.DateTime.UtcNow }; var result = await UserManager.CreateAsync(user); if (result.Succeeded) { UsersModel newUser = new UsersModel() { Id = user.Id, Name = query2.DisplayName, Email = query2.Email, Status = 1, DateCreated = DateTime.UtcNow, ApiCode = EncryptionAlgorithmServiceManager.GetRNGGuid().ToString() }; _db.Users.Add(newUser); _db.SaveChanges(); await SignInManager.SignInAsync(user, true, true); } return(RedirectToAction("Index", "Home", new { status = 9 })); } else { return(RedirectToAction("Index", "Home", new { status = 8 })); } } else { return(RedirectToAction("Index", "Home", new { status = 8 })); } }
public static UsersModel getUserByEmail(string Email) { using (ObserverDbContext _db = new ObserverDbContext()) { UsersModel user = new UsersModel(); var query = _db.Users .Where(e => e.Email == Email) .FirstOrDefault(); user = query; return(user); } }
public int EmailLoginRequest(string SessionId, string Email, string SessionKey) { ObserverDbContext _db = new ObserverDbContext(); var session = _db.LoginSessions .Where(e => e.Id == SessionId) .FirstOrDefault(); if (session.Status == 6) { // Session expired return(0); } if (session.Status != 1) { // Session type error return(1); } if (session.Key != SessionKey) { // Session expired return(0); } var users = _db.Users .Where(e => e.Email == Email) .ToList(); if (users.Count > 0) { var user = users.FirstOrDefault(); if (user.Status == 1) { session.EmailKey = EncryptionAlgorithmServiceManager.GetRNGGuid().ToString(); session.Status = 4; session.Users = user; _db.SaveChanges(); EmailServiceManager.AccountEmailLogin(user.Name, Request.Url.Scheme + "://" + Request.Url.Host + ":" + Request.Url.Port + "/LoginEmail?Id=" + SessionId + "&Key=" + session.EmailKey, user.Email); return(4); } else { // Inactive user return(3); } } else { // Cannot find user return(2); } }
public static void AddRecipient(RecipientsModel model) { ObserverDbContext _db = new ObserverDbContext(); ObservesModel observesModel = _db.Observes .Where(e => e.Id == model.Observes.Id) .FirstOrDefault(); model.Observes = observesModel; _db.Recipients.Add(model); _db.SaveChanges(); }
public int ResubmitStep(StepResubmitInputModel model) { if (model.Url == null) { return(1); } else if (model.Method != 1 && model.Method != 2) { return(2); } else { ObserverDbContext _db = new ObserverDbContext(); byte[] encrypt = null; byte[] encryptSecret = null; string encrypted = null; string encryptedSecret = null; if (model.PC2 != null) { byte[] secretKey = Convert.FromBase64String(_db._AESSecretKeyS); using (AesManaged myAes = new AesManaged()) { encrypt = EncryptionAlgorithmServiceManager.EncryptStringToBytes_Aes(model.PC2, secretKey, myAes.IV); encryptSecret = myAes.IV; } } if (encrypt != null) { encrypted = Convert.ToBase64String(encrypt); encryptedSecret = Convert.ToBase64String(encryptSecret); } PCMethodsModel pcMethodsModel = PCMethodServiceManager.GetPCMethodById(model.PC_Method.ToString()); StepsModel stepsModel = new StepsModel() { Id = model.StepId, Url = model.Url, Method = model.Method, SetHeader = model.Header, Deleted = false, PredefinedHeader = model.PredefinedHeader, PC1 = model.PC1, PC2 = encrypted, PC2Secret = encryptedSecret }; StepServiceManager.UpdateStep(stepsModel, model.PC_Method.ToString()); return(4); } }
public static void UpdateObserve(ObservesModel model) { ObserverDbContext _db = new ObserverDbContext(); var query = _db.Observes .Where(e => e.Id == model.Id) .FirstOrDefault(); query.Status = model.Status; query.Name = model.Name; _db.SaveChanges(); }
public async Task <JsonResult> ExecuteStep(string StepId) { ObserverDbContext _db = new ObserverDbContext(); StepsModel stepsModel = _db.Steps .Where(e => e.Id == StepId) .FirstOrDefault(); ObservesModel observesModel = stepsModel.Observes; if (observesModel.Users.Id == User.Identity.GetUserId()) { string pcMethodsModelId = null; string LabelPC1 = null; string LabelPC2 = null; int pcMethodsModelIdInt = 0; if (stepsModel.PC_Method != null) { pcMethodsModelId = stepsModel.PC_Method.Id; LabelPC1 = stepsModel.PC_Method.PC1; LabelPC2 = stepsModel.PC_Method.PC2; pcMethodsModelIdInt = int.Parse(pcMethodsModelId); } StepExecutionInputModel input = new StepExecutionInputModel() { Order = stepsModel.Order.GetValueOrDefault(), Uri = stepsModel.Url, Method = stepsModel.Method.GetValueOrDefault(), PC_Method = pcMethodsModelIdInt, PC1 = stepsModel.PC1, PC2 = stepsModel.PC2, CustomHeader = stepsModel.PredefinedHeader, PredefinedHeader = stepsModel.SetHeader.GetValueOrDefault(), LabelPC1 = LabelPC1, LabelPC2 = LabelPC2, PC2Secret = stepsModel.PC2Secret }; return(Json(await StepServiceManager.ExecuteStepReturningResult(input))); } else { StepExecutionOutputModel input = new StepExecutionOutputModel() { Status = "Unauthorized" }; return(Json(input)); } }
public static ObservesModel GetObserveByStepId(string StepId) { ObserverDbContext _db = new ObserverDbContext(); string observeId = _db.Steps .Where(e => e.Id == StepId) .FirstOrDefault() .Observes.Id; ObservesModel query = _db.Observes .Where(e => e.Id == observeId) .FirstOrDefault(); return(query); }
public static ObservesModel GetObservesByRecipientId(string RecipientId) { ObserverDbContext _db = new ObserverDbContext(); string observeId = _db.Recipients .Where(e => e.Id == RecipientId) .FirstOrDefault() .Observes .Id; ObservesModel query = _db.Observes .Where(e => e.Id == observeId) .FirstOrDefault(); return(query); }