public OtherActivityDataDTO GetObj(Guid id) { var result = new OtherActivityDataDTO(); SessionManager.DoWork(session => { result = session.Query <OtherActivityData>().SingleOrDefault(a => a.Id == id).Map <OtherActivityDataDTO>(); //if (sr != null) //{ // result.Id = sr.Id; // result.Name = sr.CriterionDictionary.Name; // result.PlanKPIDetailId = sr.PlanKPIDetail != null ? sr.PlanKPIDetail.Id : Guid.Empty; // result.NumberOfResearch = sr.NumberOfResearch; //} }); return(result); }
public Guid Put(OtherActivityDataDTO obj) { Guid result = Guid.Empty; try { //if (obj.Id == Guid.Empty) //{ // obj.Id = Guid.NewGuid(); //} SessionManager.DoWork(session => { foreach (Guid staffId in obj.StaffIds) { OtherActivityData oad = new OtherActivityData(); oad.Id = Guid.NewGuid(); oad.OrderNumber = obj.OrderNumber; oad.Date = obj.Date; oad.TotalParticipants = obj.TotalParticipants; oad.ActivityManageCode = obj.ActivityManageCode; oad.ManageCode = obj.ManageCode; oad.Name = obj.Name; oad.NumberOfTime = 1; oad.StudyTerm = obj.StudyTerm; oad.StudyYear = obj.StudyYear; Staff staff = session.Query <Staff>().Where(s => s.Id == staffId).SingleOrDefault(); oad.StaffCode = staff.StaffInfo.ManageCode; oad.StaffProfile = new StaffProfile { Id = staffId }; oad.Department = new Department { Id = staff.Department.Id }; session.Save(oad); } }); } catch (Exception e) { } return(result); }
public IEnumerable <OtherActivityDataDTO> GetSearchOtherActivity(Guid deptId, string studyYear, string activityManageCode, string manageCode, string studyTerm) { var result = new List <OtherActivityDataDTO>(); SessionManager.DoWork(session => { bool allDept = (deptId == Guid.Empty) ? true : false; bool allYear = (studyYear == null || studyYear == "" || studyYear == "null") ? true : false; bool allActivity = (activityManageCode == null || activityManageCode == "" || activityManageCode == "null") ? true : false; bool allManage = (manageCode == null || manageCode == "" || manageCode == "null") ? true : false; bool allTerm = (studyTerm == null || studyTerm == "" || studyTerm == "null") ? true : false; List <OtherActivityData> temp = session.Query <OtherActivityData>().Where(d => (allDept || d.Department.Id == deptId) && (allYear || d.StudyYear == studyYear) && (allActivity || d.ActivityManageCode == activityManageCode) && (allManage || d.ManageCode == manageCode) && (allTerm || d.StudyTerm == studyTerm) ).ToList(); foreach (OtherActivityData o in temp) { OtherActivityDataDTO od = new OtherActivityDataDTO(); od.Id = o.Id; od.ActivityManageCode = o.ActivityManageCode; od.DepartmentName = o.Department != null ? o.Department.Name : ""; od.ManageCode = o.ManageCode; od.Name = o.Name; od.NumberOfTime = o.NumberOfTime; od.StaffCode = o.StaffCode; od.StaffName = o.StaffProfile != null ? o.StaffProfile.Name : ""; od.StudyTerm = o.StudyTerm; od.StudyYear = o.StudyYear; result.Add(od); } }); return(result); }