private void GetDormFromSpreadSheet(int row, ExcelWorksheet sheet, int EventId)
{
Dormitory h = new Dormitory();
h.Capacity = Convert.ToInt32(sheet.Cells[COLUMN_CAPACITE + Convert.ToString(row)].Value);
h.Name = (string)sheet.Cells[COLUMN_NAME + Convert.ToString(row)].Value;
h.EventId = EventId;
try
{
h.DormType = Convertors.GetDormirtoryType((string)sheet.Cells[TYPE_DORM + Convert.ToString(row)].Value.ToString().ToLowerInvariant());
}
catch (Exception)
{
h.DormType = DormitoryTypeEnum.NONE;
}
try
{
h.DormCategory = Convertors.GetDormirtoryCategory((string)sheet.Cells[CATEGORY_DORM + Convert.ToString(row)].Value.ToString().ToLowerInvariant());
}
catch (Exception)
{
h.DormCategory = DormitoryCategoryEnum.MATELAS;
}
h.Persist();
}