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