/* * 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; }