public ActionResult getNotifreq() { DataBaseFuncController db = new DataBaseFuncController(); List <S_ACTORS> users = new List <S_ACTORS>(); NOTIF act = new NOTIF(); S_ACTORS actors = new S_ACTORS(); var notifs = db.GetAllNotif().ToList(); foreach (var x in notifs) { if (x.ACTOR_ID_TO.ToString() == Session["ActorId"].ToString()) { users.Add(db.GetActorDataByID(x.ACTOR_ID_FROM)); } } Notification pum = new Notification() { Users = users, }; return(PartialView("../Shared/_Req", pum)); }
public MidiCommNotif(NOTIF notif, String name, String addr, int signal, byte[] data, String serviceID, String charID) { notification = notif; this.name = name; this.addr = addr; this.signal = signal; this.data = data; this.serviceID = serviceID; this.charID = charID; }
public async Task <IHttpActionResult> Insert(int id, Dictionary <string, object> Items) { Logger.Info("POST Crud: " + id); var model = new CrudModel() { MetaBoID = id, Items = Items }; // var meta = await db.META_BO.FindAsync(model.MetaBoID); var meta = db.META_BO.Find(model.MetaBoID); /* ACCESS RIGHTS */ try { UserRoleManager.Instance.VerifyWrite(meta.BO_DB_NAME); } catch (UnauthorizedAccessException ex) { return(Content(HttpStatusCode.Forbidden, ex.Message)); } /* FIN ACCESS RIGHTS */ BO bo_model = new BO() { CREATED_BY = User.Identity.Name, CREATED_DATE = DateTime.Now, UPDATED_BY = User.Identity.Name, UPDATED_DATE = DateTime.Now, STATUS = "1", BO_TYPE = model.MetaBoID.ToString(), VERSION = meta.VERSION }; db.BO.Add(bo_model); await db.SaveChangesAsync(); int id_ = (int)bo_model.BO_ID; BO_Insert_return = id_; model.MetaBO = meta; model.BO_ID = id_; model.Items.Add("BO_ID", model.BO_ID); //return Ok(model.FormatInsert()); string insert = model.Insert(); // Workflow executer begin var s = new SGBD(); var db_workflow = s.Cmd(" select * from WORKFLOW CROSS APPLY OPENJSON(ITEMS) with(type varchar(50) '$.type', " + " precedent varchar(50) '$.precedent', [index] int '$.index', val nvarchar(500) '$.value.value') as jsonValues where ACTIVE = 1 and jsonValues.val = " + id + "and jsonValues.type = 'bo'"); dynamic _JSON; var where = ""; foreach (DataRow item in db_workflow.Rows) { _JSON = System.Web.Helpers.Json.Decode(item["ITEMS"].ToString()); int level = 0; for (var i = (int)item["index"] + 1; i < _JSON.Length; i++) { var elm = _JSON[i]; if (elm["status"] != "deleted") { where = ""; level++; if (elm["type"] == "validation") { foreach (var rule in elm.value.rules) { var value = rule["value"]; if (!"int,float,decimal,nvarchar(MAX)".Contains(rule["field"]["DB_TYPE"])) { value = "'" + value + "'"; } where += " " + rule["logic"] + " " + rule["field"]["DB_NAME"] + " " + rule["condition"] + " " + value; } var check_validation = s.Cmd("select * from " + meta.BO_DB_NAME + " where BO_ID=" + model.BO_ID + " " + where); if (check_validation.Rows.Count > 0) { TASK valid = new TASK() { BO_ID = id_, JSON_DATA = System.Web.Helpers.Json.Encode(elm.value.validators), CREATED_BY = User.Identity.Name, CREATED_DATE = DateTime.Now, STATUS = elm.value.status, ETAT = 0, TASK_LEVEL = level, TASK_TYPE = "VALIDATION" }; db.TASK.Add(valid); foreach (var _validator in elm.value.validators) { NOTIF notification = new NOTIF() { VALIDATOR = _validator["email"], CREATED_DATE = DateTime.Now, ETAT = 0 }; db.NOTIF.Add(notification); } db.SaveChanges(); } } else if (elm["type"] == "bo") { TASK valid = new TASK() { BO_ID = id_, JSON_DATA = System.Web.Helpers.Json.Encode(elm.value), CREATED_BY = User.Identity.Name, CREATED_DATE = DateTime.Now, ETAT = 0, TASK_LEVEL = level, TASK_TYPE = "BO" }; db.TASK.Add(valid); db.SaveChanges(); var task_id = (int)valid.TASK_ID; // await Insert_Bo_Using_Mapping(id, meta.BO_DB_NAME, model.BO_ID, task_id); } } } } if (insert == "") { BO_Insert_return = id_; return(Ok(model)); } else { return(InternalServerError(new Exception(insert))); } }