public void Timer1_Tick(object sender, EventArgs e) { var taskInstanceManager = new TaskInstanceManager(); var q = from i in taskInstanceManager.GetQuery().Where(r => r.PerformerID == CurrentUserCode && r.TaskInstanceStatusID == 0) where !_primaryKeys.Contains(i.TaskInstanceID) select i; if (q.Any()) { var count = q.Count(); //PopUpLbl.Text = "شما درخواست جدید دارید ( " + Extensions.ToPersianDigit(count.ToString()) + " )"; PopUpLbl.Text = "شما " + count.ToString().ToPersianDigit() + " درخواست جدید دارید."; radNotification.VisibleOnPageLoad = true; FillGrid(); TaskInstanceRadGrid.Rebind(); } else { PopUpLbl.Text = ""; radNotification.VisibleOnPageLoad = false; } _primaryKeys = taskInstanceManager .GetQuery(r => r.PerformerID == CurrentUserCode && r.TaskInstanceStatusID == 0) .Select(r => r.TaskInstanceID) .ToList(); }
//----------------------------------------------------------------------------------------- #region "Request Worker" private List <Worker> GetListRequestByWorker(long _Worker, List <BusinessObjects.Request> _Requests) { List <Worker> _workerClass = new List <Worker>(); var taskInstanceManager = new TaskInstanceManager(); MemberManager memberManager = new MemberManager(); EntityManager entityManager = new EntityManager(); var typeEntity = entityManager.GetQuery(e => e.EntityID == _Worker).ToList(); if (typeEntity.Count == 0) { return(_workerClass); } int entityTypeID = typeEntity.FirstOrDefault().EntityTypeID.Value; switch (entityTypeID) { case 2: // User = 2, string PersonalCardNo1 = typeEntity.FirstOrDefault().PersonalCardNo; var tis = taskInstanceManager.GetQuery(c => c.PerformerID == PersonalCardNo1).ToList(); foreach (var g in tis) { _workerClass.Add(new Worker { RequestID = long.Parse(g.EntityID), WorkerPersonalCardNo = g.PerformerID }); } break; case 9: //Group = 9, var groups = memberManager.GetQuery(p => p.EntityID1 == _Worker).Select(m => m.EntityID2).ToList(); var ListPersonalCardNo = entityManager.GetQuery().Where(en => groups.Contains(en.EntityID)).Select(c => c.PersonalCardNo).ToList(); var taskInstanceg = taskInstanceManager.GetQuery(c => ListPersonalCardNo.Contains(c.PerformerID)).ToList(); foreach (var g2 in taskInstanceg) { _workerClass.Add(new Worker { RequestID = long.Parse(g2.EntityID), WorkerPersonalCardNo = g2.PerformerID }); } break; case 7: //Role = 7 var Roles = memberManager.GetQuery(p => p.EntityID1 == _Worker).Select(m => m.EntityID2).ToList(); var Group = memberManager.GetQuery(p => Roles.Contains(p.EntityID1)).Select(q => q.EntityID2).ToList(); var ListPersonalCardNoRoles = entityManager.GetQuery().Where(en => Group.Contains(en.EntityID)).Select(c => c.PersonalCardNo).ToList(); var taskInstancegRoles = taskInstanceManager.GetQuery(c => ListPersonalCardNoRoles.Contains(c.PerformerID)).ToList(); foreach (var g2 in taskInstancegRoles) { _workerClass.Add(new Worker { RequestID = long.Parse(g2.EntityID), WorkerPersonalCardNo = g2.PerformerID }); } break; } return(_workerClass); }
protected void FillGrid() { var taskInstanceManager = new TaskInstanceManager(); var kartableList = taskInstanceManager.GetQuery() .Where(r => r.PerformerID == CurrentUserCode && r.TaskInstanceStatusID == 0) .ToList(); foreach (var taskInstance in kartableList) { var date = taskInstance.InsertDate; var differenceDate = DateTime.Now - date; if (differenceDate != null) { var daysCount = differenceDate.Value.Days; if (daysCount > 0) { taskInstance.PriorityID += Convert.ToInt32(Math.Floor(daysCount * Constants.PriorityCoefficient)); } } var instance = taskInstance; var entity = _entityManager.GetQuery(it => it.PersonalCardNo == instance.InsertUser).FirstOrDefault(); if (entity != null) { taskInstance.InsertUser = entity.Title; } taskInstance.InsertDatePrescriptive = UIUtils.ToPersianDate(taskInstance.InsertDate).ToPersianDigit(); //Mahyar Mahyar Mahyar //taskInstance.InsertDatePrescriptive = UIUtils.ToPersianDate(taskInstance.InsertDate); } TaskInstanceRadGrid.DataSource = kartableList.OrderByDescending(r => r.PriorityID); _primaryKeys = kartableList.Select(m => m.TaskInstanceID).ToList(); }
public List <RequestInsertUserAction> ReportBySupportGroup(long roleId, DateTime?fromDate, DateTime?toDate, long exeprtEntityId) { var memberManager = new MemberManager(); var entityManager = new EntityManager(); var requestManager = new RequestManager(); var taskInstanceManager = new TaskInstanceManager(); var performerPersonalCardNo = entityManager.GetQuery(it => it.EntityID == exeprtEntityId).Select(it => it.PersonalCardNo). FirstOrDefault(); var tis = taskInstanceManager.GetQuery(p => p.PerformerID == performerPersonalCardNo).Select(instance => instance.PerformerID).Distinct().ToList(); var taskInstanceDistinct = taskInstanceManager.GetQuery(p => tis.Contains(p.PerformerID)).ToList();//.Select(p => p.EntityID); var taskInstances = new List <long>(); foreach (var taskInstance in taskInstanceDistinct) { if (taskInstance.PerformerID != null) { taskInstances.Add(long.Parse(taskInstance.EntityID)); } } var entitiesList = requestManager.GetQuery(p => taskInstances.Contains(p.RequestID)).ToList().Where(p => p.InsertDate >= fromDate && p.InsertDate <= toDate).ToList(); var x = (from r in entitiesList join t in taskInstanceDistinct on r.RequestID.ToString() equals t.EntityID select new RequestInsertUserAction { RequestId = r.RequestID, RegisterByName = r.RegisterByName, RequesterID = r.InsertUser, InsertDateEn = r.InsertDate, OptionalLocation = r.OptionalLocation, //RequestPriority = r.Priority.Title, RequertTypeId = r.RequestTypeID, //RequertType = r.RequestType.Title, PerformerID = t.PerformerID }).OrderBy(p => p.PerformerID).ToList(); return(x); }
protected void TaskInstanceRadGrid_ItemDataBound(object sender, GridItemEventArgs e) { if (e.Item.ItemType == GridItemType.Item || e.Item.ItemType == GridItemType.AlternatingItem) { var target = e.Item.FindControl("targetControl"); if (!Equals(target, null)) { //if (!Equals(RadToolTipManager1, null)) //{ // //Add the button (target) id to the tooltip manager // var item = (GridDataItem)e.Item; // RadToolTipManager1.TargetControls.Add(target.ClientID, item["EntityID"].Text, true); //} } } else if (e.Item is GridEditFormItem) { var item = (GridEditFormItem)e.Item; item["ExtraInfo"].Text = item["ExtraInfo"].Text.ToPersianDigit(); item["WorkflowInstanceInsertUser"].Text = item["WorkflowInstanceInsertUser"].Text.ToPersianDigit(); var personalCardNo = item["InsertUser"].Text; //var entity = _entityManager.GetQuery(it => it.PersonalCardNo == personalCardNo).FirstOrDefault(); //item["InsertUser"].Text = entity.Title; } if (e.Item is GridDataItem) { var dataItem = (GridDataItem)e.Item; TableCell myCell = dataItem["TaskCode"]; if (myCell.Text == "Verify_By_Oprator") { dataItem.ForeColor = System.Drawing.Color.Maroon; dataItem.Font.Bold = true; } else if (myCell.Text == "Verify_By_Leader") { dataItem.ForeColor = System.Drawing.Color.MidnightBlue; dataItem.Font.Bold = true; } var taskInstanceId = Guid.Parse(dataItem["taskInstanceId"].Text); var taskInstance = _taskInstanceManager.GetQuery(it => it.TaskInstanceID == taskInstanceId).FirstOrDefault(); var entityId = long.Parse(taskInstance.EntityID); var request = _attachmentManager.GetQuery(it => it.RequestID == entityId); var image = (Image)dataItem.FindControl("img"); if (request.Any()) { image.ImageUrl = "~/Images/attachment.png"; } else { image.Visible = false; image.Enabled = false; } } }
public List <Request> GetRequestWithPriority(DateTime?toDate, DateTime?fromDate, long value1, long value2) { //var requests = this.GetQuery(r => r.RequestPriority == value // && r.InsertDate <= toDate // && r.InsertDate >= fromDate) // .ToList(); //return requests; var taskinstanceManager = new TaskInstanceManager(); var requestEntitites = taskinstanceManager.GetQuery(p => p.PriorityID > value1 && p.PriorityID <= value2).Select(p => p.EntityID).ToList(); var stringIdnetities = new List <long>(); foreach (var requestEntitity in requestEntitites) { stringIdnetities.Add(long.Parse(requestEntitity)); } var requests = this.GetQuery(p => stringIdnetities.Contains(p.RequestID)).ToList(); return(requests); }