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 OtherActivityData Delete(OtherActivityData obj) { SessionManager.DoWork(session => session.Delete(obj)); return(obj); }
public static void ImportDataOtherActivity() { try { SessionManager.DoWork(session => { //string deleteAll = string.Format("DELETE FROM {0}", "KPI_ScienceResearchData"); //session.CreateSQLQuery(deleteAll).ExecuteUpdate(); _workbookSet = new Workbook(); _workbookSet.LoadDocument(_directFile, DocumentFormat.OpenXml); var file = _workbookSet; int indexSheet = 1; int startIndexSheet = 0; int countSheet = _workbookSet.Worksheets.Count; for (int j = startIndexSheet; j <= countSheet; j++) { indexSheet = j; #region //Sheet 0 -- Thong Ke Tuyen Moi if (indexSheet == 0) { int i = 2; while (file.Worksheets[indexSheet].Cells["A" + i.ToString()].Value.ToString().Trim() != "") { string staffCode = file.Worksheets[indexSheet].Cells["A" + i.ToString()].Value.ToString().Trim(); string activityCode = file.Worksheets[indexSheet].Cells["B" + i.ToString()].Value.ToString().Trim(); string manageCode = file.Worksheets[indexSheet].Cells["C" + i.ToString()].Value.ToString().Trim(); string name = file.Worksheets[indexSheet].Cells["D" + i.ToString()].Value.ToString().Trim(); string studyYear = file.Worksheets[indexSheet].Cells["E" + i.ToString()].Value.ToString().Trim(); string studyTerm = file.Worksheets[indexSheet].Cells["F" + i.ToString()].Value.ToString().Trim(); Staff staff = session.Query <Staff>().Where(s => s.StaffInfo.ManageCode == staffCode).SingleOrDefault(); if (staff != null) { OtherActivityData srd = new OtherActivityData() { Id = Guid.NewGuid(), StaffCode = file.Worksheets[indexSheet].Cells["A" + i.ToString()].Value.ToString().Trim(), ActivityManageCode = file.Worksheets[indexSheet].Cells["B" + i.ToString()].Value.ToString().Trim(), ManageCode = file.Worksheets[indexSheet].Cells["C" + i.ToString()].Value.ToString().Trim(), Name = file.Worksheets[indexSheet].Cells["D" + i.ToString()].Value.ToString().Trim(), StudyYear = file.Worksheets[indexSheet].Cells["E" + i.ToString()].Value.ToString().Trim(), StudyTerm = file.Worksheets[indexSheet].Cells["F" + i.ToString()].Value.ToString().Trim(), StaffProfile = new StaffProfile { Id = staff.Id }, Department = new Department { Id = staff.Department.Id }, }; session.Save(srd); } i++; } } } }); #endregion } catch { } finally { _workbookSet = null; _directFile = null; if (File.Exists(_directFile)) { File.Delete(_directFile); } _dbConn.Close(); } }