public ActionResult <DeleteScheduleResponse> Post(DeleteSchedule request) { //Remove mapping. if (request.AttributeIds != null && request.ScheduleIds != null) { for (int pos = 0; pos != request.AttributeIds.Length; ++pos) { GXDeleteArgs arg = GXDeleteArgs.Delete <GXScheduleToAttribute>(q => request.ScheduleIds[pos] == q.ScheduleId); arg.Where.And <GXScheduleToAttribute>(q => request.AttributeIds[pos] == q.AttributeId); host.Connection.Delete(arg); } host.SetChange(TargetType.Schedule, DateTime.Now); } else if (request.ScheduleIds != null) { GXSelectArgs arg = GXSelectArgs.Select <GXSchedule>(a => a.Id, q => request.ScheduleIds.Contains(q.Id)); List <GXSchedule> list = host.Connection.Select <GXSchedule>(arg); DateTime now = DateTime.Now; foreach (GXSchedule it in list) { it.Removed = now; host.Connection.Update(GXUpdateArgs.Update(it, q => q.Removed)); } host.SetChange(TargetType.Schedule, now); } return(new DeleteScheduleResponse()); }
public void RemoveUserRolesTest() { GXUser user = new GXUser(); user.Id = "642c8f77-aeeb-4e86-86db-1a8b1b2fc982"; user.UserName = "******"; List <string> roles = new List <string>(); roles.Add("Admin"); roles.Add("User"); roles.Add("DeviceManager"); roles.Add("SystemErrorManager"); GXSelectArgs sel = GXSelectArgs.Select <GXRole>(q => GXSql.One); sel.Where.And <GXUserRole>(q => q.UserId == user.Id); sel.Where.And <GXRole>(q => !roles.Contains(q.Name)); GXDeleteArgs d = GXDeleteArgs.Delete <GXUserRole>(q => q.UserId == user.Id); d.Where.And <GXRole>(q => GXSql.Exists <GXUserRole, GXRole>(q => q.RoleId, q => q.Id, sel)); /* * GXSelectArgs sel = GXSelectArgs.Select<GXUserRole>(q => q.UserId, q => q.UserId == "642c8f77-aeeb-4e86-86db-1a8b1b2fc982"); * sel.Joins.AddInnerJoin<GXUserRole, GXRole>(a => a.RoleId, b => b.Id); * sel.Where.And<GXRole>(q => !roles.Contains(q.Name)); * GXDeleteArgs d = GXDeleteArgs.Delete<GXUserRole>(q => GXSql.Exists(sel)); */ Assert.AreEqual("", d.ToString()); }
public ActionResult <DeleteTaskResponse> Post(DeleteTask request) { if (request.Ids != null) { host.Connection.Delete(GXDeleteArgs.Delete <GXTask>(q => request.Ids.Contains(q.Id))); host.SetChange(TargetType.Tasks, DateTime.Now); } return(new DeleteTaskResponse()); }
public ActionResult <ClearDeviceLogResponse> Post(ClearDeviceLog request) { if (request.Ids != null) { host.Connection.Delete(GXDeleteArgs.Delete <GXError>(q => request.Ids.Contains(q.DeviceId))); } else { host.Connection.Delete(GXDeleteArgs.DeleteAll <GXError>()); } host.SetChange(TargetType.DeviceLog, DateTime.Now); return(new ClearDeviceLogResponse()); }
public ActionResult <RemoveReaderResponse> Post(RemoveReader request) { if (request.Ids != null) { host.Connection.Delete(GXDeleteArgs.Delete <GXReaderInfo>(q => request.Ids.Contains(q.Id))); } else { host.Connection.Delete(GXDeleteArgs.DeleteAll <GXReaderInfo>()); } host.SetChange(TargetType.Readers, DateTime.Now); return(new RemoveReaderResponse()); }