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