public IList <Document> GetTaskByUser(TaskByUser data, Location location)
{
IList <Document> list;
try
{
list = Factory.DaoTaskByUser().Select(data).Select(f => f.TaskDocument).ToList();
}
catch
{
list = new List <Document>();
}
list = list.Union <Document>(
Factory.DaoDocument().SelectPending(new Document
{
Location = location,
DocType = new DocumentType {
DocClass = new DocumentClass {
DocClassID = SDocClass.Task
}
}
}, WmsSetupValues.HistoricDaysToShow, WmsSetupValues.NumRegsDevice)
).ToList <Document>();
return(list);
}
private void OnAddTaskByUser(object sender, DataEventArgs <Document> e)
{
if (e.Value == null)
{
return;
}
try
{
if (View.Model.OrderByPicker.Where(f => f.DocID == e.Value.DocID).Count() == 0)
{
TaskByUser task = new TaskByUser
{
CreatedBy = App.curUser.UserName,
CreationDate = DateTime.Now,
TaskDocument = e.Value,
User = View.Model.CurPicker
};
service.SaveTaskByUser(task);
}
}
catch (Exception ex)
{
Util.ShowError("Document could not be loaded.\n" + ex.Message);
}
}
public string GetAllTaskByUserIdAndGroupId(string userid, string username, string profileurl, string days, string groupid)
{
UserRepository userrepo = new UserRepository();
Guid UserId = Guid.Parse(userid);
List <Domain.Socioboard.Domain.Tasks> taskdata = new List <Domain.Socioboard.Domain.Tasks>();
List <Domain.Socioboard.Domain.TaskByUser> taskbyuser = new List <Domain.Socioboard.Domain.TaskByUser>();
TaskByUser _TaskByUser = new TaskByUser();
TaskRepository taskrepo = new TaskRepository();
taskdata = taskrepo.getAllTasksOfUserBYDays(Guid.Parse(userid), Guid.Parse(groupid), Convert.ToInt32(days));
foreach (var item in taskdata)
{
_TaskByUser.TaskMessage = item.TaskMessage;
_TaskByUser.TaskStatus = item.TaskStatus;
_TaskByUser.AssignDate = item.AssignDate;
_TaskByUser.CompletionDate = item.CompletionDate;
try
{
if (UserId == item.AssignTaskTo)
{
_TaskByUser.AssignToUserName = username;
}
else
{
Domain.Socioboard.Domain.User User = userrepo.getUsersById(item.AssignTaskTo);
_TaskByUser.AssignToUserName = User.UserName;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
if (UserId == item.UserId)
{
_TaskByUser.AssignByUserName = username;
}
else
{
Domain.Socioboard.Domain.User User = userrepo.getUsersById(item.UserId);
_TaskByUser.AssignByUserName = User.UserName;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
_TaskByUser.days = Convert.ToInt32(days);
_TaskByUser.UserName = username;
_TaskByUser.ProfileUrl = profileurl;
taskbyuser.Add(_TaskByUser);
}
return(new JavaScriptSerializer().Serialize(taskbyuser));
}
public IList <TaskByUser> Select(TaskByUser data)
{
IList <TaskByUser> datos = new List <TaskByUser>();
try {
datos = GetHsql(data).List <TaskByUser>();
if (!Factory.IsTransactional)
{
Factory.Commit();
}
}
catch (Exception e)
{
NHibernateHelper.WriteEventLog(WriteLog.GetTechMessage(e));
}
return(datos);
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from TaskByUser a where ");
TaskByUser taskUser = (TaskByUser)data;
if (taskUser != null)
{
Parms = new List <Object[]>();
if (taskUser.RowID != 0)
{
sql.Append(" a.RowID = :id and ");
Parms.Add(new Object[] { "id", taskUser.RowID });
}
if (taskUser.User != null && taskUser.User.UserID != 0)
{
sql.Append(" a.User.UserID = :idd1 and ");
Parms.Add(new Object[] { "idd1", taskUser.User.UserID });
}
if (taskUser.User != null && !String.IsNullOrEmpty(taskUser.User.UserName))
{
sql.Append(" a.User.UserName = :idd2 and ");
Parms.Add(new Object[] { "idd2", taskUser.User.UserName });
}
if (taskUser.TaskDocument != null && taskUser.TaskDocument.DocID != 0)
{
sql.Append(" a.TaskDocument.DocID = :idd3 and ");
Parms.Add(new Object[] { "idd3", taskUser.TaskDocument.DocID });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append("1=1 order by a.TaskDocument.Priority asc, a.CreationDate asc");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return(query);
}
private void OnAddTaskByUser(object sender, DataEventArgs<Document> e)
{
if (e.Value == null)
return;
try
{
if (View.Model.OrderByPicker.Where(f => f.DocID == e.Value.DocID).Count() == 0)
{
TaskByUser task = new TaskByUser
{
CreatedBy = App.curUser.UserName,
CreationDate = DateTime.Now,
TaskDocument = e.Value,
User = View.Model.CurPicker
};
service.SaveTaskByUser(task);
}
}
catch (Exception ex)
{
Util.ShowError("Document could not be loaded.\n" + ex.Message);
}
}
public void DeleteTaskByUser(TaskByUser data)
{
try {
SetService(); SerClient.DeleteTaskByUser(data); }
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public TaskByUser SaveTaskByUser(TaskByUser data)
{
try {
SetService(); return SerClient.SaveTaskByUser(data); }
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public IList<Document> GetTaskByUser(TaskByUser data)
{
try {
SetService(); return SerClient.GetTaskByUser(data, App.curLocation); }
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public TaskByUser SelectById(TaskByUser data)
{
return((TaskByUser)base.SelectById(data));
}
public Boolean Delete(TaskByUser data)
{
return(base.Delete(data));
}
public Boolean Update(TaskByUser data)
{
return(base.Update(data));
}
public TaskByUser Save(TaskByUser data)
{
return((TaskByUser)base.Save(data));
}
