/*
* public IList GetFeastsFiltered(long countryID, DateTime? from, DateTime? to)
* {
* ICriteria criteria = Session.CreateCriteria(typeof (Feast));
* criteria.Add(Expression.Eq("CountryID", countryID));
* if (from.HasValue)
* {
* criteria.Add(Expression.Ge("FeastDate", from.Value));
* if (to.HasValue)
* {
* criteria.Add(Expression.Le("FeastDate", to.Value));
* }
* }
* return ResolveCriteria(criteria);
* }*/
public SaveDataResult ImportFeasts(List <ImportDaysData> list)
{
SaveDataResult result = new SaveDataResult();
result.Success = true;
if (list.Count > 0)
{
string query =
@" create table #feast4insert
(
CountryID bigint,
[Date] smalldatetime
)
";
using (IDbCommand command = CreateCommand())
{
command.CommandText = query;
command.CommandTimeout = 60 * 3;
command.ExecuteNonQuery();
foreach (ImportDaysData value in list)
{
query = "insert into #feast4insert (CountryID,[Date]) values({0},'{1}')";
command.CommandText = string.Format(query, value.CountryID, value.Date.ToString("yyyyMMdd"));
command.ExecuteNonQuery();
}
command.CommandText = "spFeasts_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())
{
ImportDaysData value = new ImportDaysData();
value.CountryID = reader.GetInt64(0);
value.Date = reader.GetDateTime(1);
list.Add(value);
}
reader.NextResult();
result.Success = ((int)importResult.Value > 0);
}
result.Data = list;
}
}
OnDaoInvalidateWholeCache();
return(result);
}
internal ImportFeastsData(int recordNumber, ImportDaysData data)
{
RecordNumber = recordNumber;
Data = data;
}
