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;
}
