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 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 override void OnInit(EventArgs e) { base.OnInit(e); //UIUtils.TelerikGridUtils.CustomizeFilterMenu(TaskInstanceRadGrid); TaskInstanceRadGrid.FilterMenu.Items.PersianFilter(); _entityManager = new EntityManager(); _taskInstanceManager = new TaskInstanceManager(); _attachmentManager = new AttachmentManager(); IsAuthenticate(); //this.EntityDataSource1.Selecting += new EventHandler<EntityDataSourceSelectingEventArgs>(EntityDataSource1_Selecting); }
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); }
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); }
protected void okRadButton_Click(object sender, EventArgs e) { var report = new StiReport(); string path = Server.MapPath("ExpertActitvitiesReport.mrt"); report.Load(path); report.Compile(); var insertUser = Utility.CurrentUserName; //var fromDate = Convertor.ToGregorianDate(fromDateRadMaskedTextBox.Text); //var toDate = Convertor.ToGregorianDate(toDateRadMaskedTextBox.Text); var fromDate = fromDateRadMaskedTextBox.Text.ConvertToDateTime(); var toDate = toDateRadMaskedTextBox.Text.ConvertToDateTime(); var requestManager = new RequestManager(); var taskInstanceManager = new TaskInstanceManager(); var requestidList = requestManager.GetQuery(r => r.RegisterByName.Contains(insertUser) && r.InsertDate >= fromDate && r.InsertDate <= toDate) .Select(r => new RequestInsertUserAction { RegisterByName = r.RegisterByName, InsertDateEn = r.InsertDate, OptionalLocation = r.OptionalLocation, RequertTypeId = r.RequestTypeID, //RequestPriority = r.Priority.Title, RequestId = r.RequestID, EntityId = r.RegisteredByEntityID }).ToList(); report.RegBusinessObject("requestManager", "requestManager", requestidList); var persianDate = ReportTextHelper.GetPersianDate(); report["TodayDate"] = persianDate; report.Dictionary.Synchronize(); requestTypeStiWebViewer.Report = report; }