public LocationImport()
{
_db = new HRMWFEntities();
_insertCount = 0;
_updateCount = 0;
_deleteCount = 0;
}
private void PopulateHistory()
{
using (var db = new HRMWFEntities())
{
var dataSource =
db.TaskInstance.Include("WorkflowInstance")
.Include("TaskAction")
.Include("TaskInstanceStatus")
.Where(ti => ti.WorkflowInstanceID == TaskInstance.WorkflowInstanceID && ti.TaskInstanceStatusID == (int)TaskInstanceStatusEnum.Complete)
//.ToList()
.OrderBy(p => p.InsertDate)
.ToList();
var list = new List <DesciptionHistory>();
if (dataSource.Count > 0)
{
list.AddRange(dataSource.Select(item => new DesciptionHistory
{
Sender = item.PerformerID, //Reciever = item.PerformerID,
Date = UIUtils.ToPersianDate(item.InsertDate).ToPersianDigit(), Description = item.Comment, TmpTaskInstanceId = item.TaskInstanceID
}));
HistoryDataList.DataSource = list;
HistoryDataList.DataBind();
}
}
}
public PersonalListImport()
{
_db = new HRMWFEntities();
_insertCount = 0;
_updateCount = 0;
_deleteCount = 0;
}
private void PopulateTaskActionCombobox()
{
using (var db = new HRMWFEntities())
{
TaskActionIDComboBox.DataSource =
db.TaskAction.Where(ti => ti.TaskID == TaskInstance.TaskID && ti.TaskActionCode != "Assign").Select(
m => new { m.TaskActionTitle, m.TaskActionID });
TaskActionIDComboBox.DataBind();
}
}
private List <DesciptionHistory> PopulateHistory()
{
int row = 2;
using (var db = new HRMWFEntities())
{
var dataSource =
db.TaskInstance.Include("WorkflowInstance")
.Include("TaskAction")
.Include("TaskInstanceStatus")
.Where(ti => ti.WorkflowInstanceID == _WorkflowInstanceID) // && ti.TaskInstanceStatusID == (int)TaskInstanceStatusEnum.Complete
//.ToList()
.OrderBy(p => p.InsertDate)
.ToList();
var list = new List <DesciptionHistory>();
if (dataSource.Count > 0)
{
list.AddRange(dataSource.Select(item => new DesciptionHistory
{
Sender = item.PerformerID, //Reciever = item.PerformerID,
// Date =item.InsertDate != ""? UIUtils.ToPersianDate(item.InsertDate).ToPersinDigit(),
Description = item.Comment,
TaskTitle = item.TaskAction != null ? item.TaskAction.TaskActionTitle : "",
Row = row++,
TmpTaskInstanceId = item.TaskInstanceID
}));
var _entityID = dataSource.FirstOrDefault().EntityID;
if (_entityID != null)
{
long _eID = long.Parse(_entityID);
var _Request = new RequestManager().GetQuery(c => c.RequestID == _eID).FirstOrDefault();
if (_Request != null)
{
var entityManager = new EntityManager();
var user = entityManager.GetQuery(p => p.EntityID == _Request.RegisteredByEntityID).FirstOrDefault();
DesciptionHistory des = new DesciptionHistory();
des.Sender = user.PersonalCardNo;
des.Date2 = UIUtils.ToPersianDate(_Request.InsertDate).ToPersinDigit();
des.Description = _Request.Comment;
des.TmpTaskInstanceId = new Guid("00000000-0000-0000-0000-000000000000");
var id = dataSource.FirstOrDefault().PerformerID;
var resiver = entityManager.GetQuery(p => p.PersonalCardNo == id).FirstOrDefault();
des.ResiverName2 = resiver.Title;;
des.Row = 1;
des.TaskTitle = "ارسال خرابی";
list.Add(des);
}
}
}
return(list.OrderBy(c => c.Row).ToList());
}
}
protected void TaskInstanceRadGrid_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
using (var db = new HRMWFEntities())
{
var dataSource =
db.TaskInstance.Include("WorkflowInstance").Include("TaskAction").Include("TaskInstanceStatus").
Where(
ti => ti.WorkflowInstanceID == ParentID).ToList().OrderByDescending(p => p.InsertDate).ToList();
TaskInstanceRadGrid.DataSource = dataSource;
//TaskInstanceRadGrid.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
StiReport rpt = new StiReport();
string path = Server.MapPath("User.mrt");
rpt.Load(path);
//get data
Infra.Common.HRMWFEntities hrmwfEntities = new HRMWFEntities();
var q = (from u in hrmwfEntities.Entity
select new
{
Firstname = u.EntityFirstName,
Lastname = u.EntityLastName,
Username = u.InsertUser
}).ToList();
////set data source
rpt.RegBusinessObject("Cat", "UserDS", q);
rpt.Dictionary.Synchronize();
StiWebViewer1.Report = rpt;
}
public OrganizationChartImport()
{
_db = new HRMWFEntities();
_insertCount = 0;
_updateCount = 0;
}
