public ImportHistory create(ImportHistory i)
{
import_history entity = new import_history();
entity.event_id = i.event_id;
entity.comments = i.comments;
entity.createdate = DateTime.Now;
entity.errored = i.errored;
entity.imported = i.imported;
entity.imported_by = i.imported_by;
entity.status = i.status;
entity.total = i.total;
entity.type = i.type;
entity.filename = i.filename;
this.db.import_histories.InsertOnSubmit(entity);
this.db.SubmitChanges();
i.id = entity.id;
return(i);
}
public ImportHistory parseData(DataTable dt, int event_id)
{
ImportHistory importHistory = new ImportHistory();
importHistory.event_id = event_id;
importHistory.errored = 0;
importHistory.imported = 0;
importHistory.total = 0;
foreach (DataRow row in (InternalDataCollectionBase)dt.Rows)
{
Session s = new Session();
s.name = row[0].ToString();
DateTime result1;
if (DateTime.TryParse(row[1].ToString() + " " + row[2].ToString(), out result1))
{
s.start = result1;
}
DateTime result2;
if (DateTime.TryParse(row[3].ToString() + " " + row[4].ToString(), out result2))
{
s.end = result2;
}
s.event_type = row[5].ToString();
s.venue = row[6].ToString();
s.event_id = event_id;
s.venue_id = this._locations.find_venue_reference_id(s.venue, s.event_id);
s.event_key = "IMPORT_" + Guid.NewGuid().ToString();
s.speakers = row[7].ToString();
s.speaker_companies = row[8].ToString();
s.speaker_images = row[9].ToString();
if (this.insert(s))
{
++importHistory.imported;
}
else
{
++importHistory.errored;
}
}
return(importHistory);
}
