public IActionResult CreateRoomRecords([FromRoute] string location, [FromRoute] int start, [FromRoute] int end, [FromRoute] int capacity, [FromRoute] string prefix) { if (prefix == "NN") { prefix = ""; } StringBuilder str = new StringBuilder(); for (int i = start; i <= end; i++) { string rn = prefix + i.ToString(); if (_context.Room.Where(m => m.Location == location && m.RoomName == rn).Count() > 0) { str.Append(rn + " "); continue; } Room room = new Room(); room.Location = location; room.RoomName = rn; room.Capacity = capacity; room.Status = 0; _context.Add(room); _context.SaveChanges(); } return(Content("Done -- " + str)); }
public async Task <ActionResult> UploadSheet() { var file = Request.Form.Files[0]; if (file.Length > 0) { string fileName = ContentDispositionHeaderValue.Parse(file.ContentDisposition).FileName.Trim('"'); var stream = file.OpenReadStream(); /* Maintain a list of updated things */ var updatedPeople = new List <Person>(); var updatedContingents = new List <Contingent>(); /* Read the worksheet */ using (ExcelPackage package = new ExcelPackage(stream)) { ExcelWorksheet workSheet = package.Workbook.Worksheets[0]; for (int i = workSheet.Dimension.Start.Row + 1; i <= workSheet.Dimension.End.Row; i++) { string clno = getValue(workSheet, i, UploadSheetColumns.clno).ToUpper(); string mino = getValue(workSheet, i, UploadSheetColumns.mino).ToUpper(); Contingent contingent = _context.Contingents.SingleOrDefault(c => c.ContingentLeaderNo == clno); /* Create contingent if it does not exist */ if (contingent == null) { contingent = new Contingent(); contingent.ContingentLeaderNo = clno; _context.Contingents.Add(contingent); _context.SaveChanges(); updatedContingents.Add(contingent); } Person person = _context.Person.SingleOrDefault(p => p.Mino == mino); /* Create person if does not exist */ if (person == null) { person = new Person(); person.Name = getValue(workSheet, i, UploadSheetColumns.name); person.ContingentLeaderNo = clno; person.Mino = mino; person.College = getValue(workSheet, i, UploadSheetColumns.college); person.Sex = (getValue(workSheet, i, UploadSheetColumns.gender).ToLower().Contains('f')) ? "F" : "M"; person.Email = getValue(workSheet, i, UploadSheetColumns.email); person.Phone = getValue(workSheet, i, UploadSheetColumns.contact); _context.Person.Add(person); _context.SaveChanges(); updatedPeople.Add(person); } } await _context.SaveChangesAsync(); } return(Ok()); } return(BadRequest("Nothing found here")); }
public static void Log(ferrousContext dbContext, HttpContext httpContext, string message, int level, bool no_save = false) { var entry = new LogEntry(); entry.Timestamp = DateTime.Now; entry.username = httpContext.User.Identity.Name; entry.message = message; entry.level = level; dbContext.Add(entry); if (!no_save) { dbContext.SaveChanges(); } }