public SaveDataResult ImportAbsence(List <ImportAbsenceData> list)
{
SaveDataResult result = new SaveDataResult();
result.Success = true;
if (list.Count > 0)
{
string query =
@" create table #abs4insert
(
SystemID int,
CharID nvarchar (10),
[Name] nvarchar (50)
)
";
using (IDbCommand command = CreateCommand())
{
command.CommandText = query;
command.CommandTimeout = 60 * 3;
command.ExecuteNonQuery();
foreach (ImportAbsenceData value in list)
{
query = @"insert into #abs4insert (SystemID, CharID, [Name])
values({0},'{1}',N'{2}')" ;
command.CommandText = string.Format(query,
value.SystemID,
value.CharID,
value.Name);
command.ExecuteNonQuery();
}
command.CommandText = "spAbsence_ImportData";
command.CommandType = CommandType.StoredProcedure;
SqlParameter importResult = new SqlParameter("@result", SqlDbType.Int, 4);
importResult.Direction = ParameterDirection.Output;
command.Parameters.Add(importResult);
using (IDataReader reader = command.ExecuteReader(CommandBehavior.SequentialAccess))
{
list.Clear();
while (reader.Read())
{
ImportAbsenceData value = new ImportAbsenceData();
value.SystemID = reader.GetInt32(0);
list.Add(value);
}
reader.NextResult();
result.Success = ((int)importResult.Value > 0);
}
result.Data = list;
}
}
OnDaoInvalidateWholeCache();
return(result);
}
internal ImportFileAbsenceData(int recordNumber, ImportAbsenceData data)
{
RecordNumber = recordNumber;
Data = data;
}
