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(); }