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