public Guid Put(ScienceResearchData obj)
{
Guid result = Guid.Empty;
try
{
SessionManager.DoWork(session =>
{
session.SaveOrUpdate(obj);
});
}
catch (Exception e)
{
}
return(result);
}
public static void ImportDataScienceResearch()
{
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 = 3;
while (file.Worksheets[indexSheet].Cells["A" + i.ToString()].Value.ToString().Trim() != "")
{
string staffCode = file.Worksheets[indexSheet].Cells["A" + i.ToString()].Value.ToString().Trim();
string name = file.Worksheets[indexSheet].Cells["B" + i.ToString()].Value.ToString().Trim();
string manageCode = file.Worksheets[indexSheet].Cells["C" + i.ToString()].Value.ToString().Trim();
string studyTerm = file.Worksheets[indexSheet].Cells["D" + i.ToString()].Value.ToString().Trim();
string studyYear = file.Worksheets[indexSheet].Cells["E" + i.ToString()].Value.ToString().Trim();
double record = (file.Worksheets[indexSheet].Cells["F" + i.ToString()].Value.ToString().Trim() == string.Empty ? 0 : Convert.ToDouble(file.Worksheets[indexSheet].Cells["F" + i.ToString()].Value.ToString().Trim()));
ScienceResearchData srd = new ScienceResearchData()
{
Id = Guid.NewGuid(),
StaffCode = file.Worksheets[indexSheet].Cells["A" + i.ToString()].Value.ToString().Trim(),
Name = file.Worksheets[indexSheet].Cells["B" + i.ToString()].Value.ToString().Trim(),
ManageCode = file.Worksheets[indexSheet].Cells["C" + i.ToString()].Value.ToString().Trim(),
StudyYear = file.Worksheets[indexSheet].Cells["D" + i.ToString()].Value.ToString().Trim(),
StudyTerm = file.Worksheets[indexSheet].Cells["E" + i.ToString()].Value.ToString().Trim(),
Record = (file.Worksheets[indexSheet].Cells["F" + i.ToString()].Value.ToString().Trim() == string.Empty ? 0 : Convert.ToDouble(file.Worksheets[indexSheet].Cells["F" + i.ToString()].Value.ToString().Trim()))
};
session.Save(srd);
i++;
}
}
}
});
#endregion
}
catch { }
finally
{
_workbookSet = null;
_directFile = null;
if (File.Exists(_directFile))
{
File.Delete(_directFile);
}
_dbConn.Close();
}
}
public ScienceResearchData Delete(ScienceResearchData obj)
{
SessionManager.DoWork(session => session.Delete(obj));
return(obj);
}
