public ActionResult DeleteConfirmed(int id)
{
ContestTable contestTable = db.ContestTables.Find(id);
db.ContestTables.Remove(contestTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,ContestName,ContestLink,Date,NumberOfProblems,Participation")] ContestTable contestTable)
{
if (ModelState.IsValid)
{
db.Entry(contestTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(contestTable));
}
public ActionResult Create([Bind(Include = "Id,ContestName,ContestLink,Date,NumberOfProblems,Participation")] ContestTable contestTable)
{
if (ModelState.IsValid)
{
db.ContestTables.Add(contestTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(contestTable));
}
// GET: ContestTables/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ContestTable contestTable = db.ContestTables.Find(id);
if (contestTable == null)
{
return(HttpNotFound());
}
return(View(contestTable));
}
public ActionResult InputFromExcelFile(HttpPostedFileBase excelfile)
{
string path = Server.MapPath("~/Excel_Files/" + excelfile.FileName);
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
excelfile.SaveAs(path);
// read data from excel file
using (SpreadsheetDocument spreadSheetDocument = SpreadsheetDocument.Open(path, false))
{
WorkbookPart workbookPart = spreadSheetDocument.WorkbookPart;
IEnumerable <Sheet> sheets = spreadSheetDocument.WorkbookPart.Workbook.GetFirstChild <Sheets>().Elements <Sheet>();
string relationshipId = sheets.First().Id.Value;
WorksheetPart worksheetPart = (WorksheetPart)spreadSheetDocument.WorkbookPart.GetPartById(relationshipId);
Worksheet workSheet = worksheetPart.Worksheet;
SheetData sheetData = workSheet.GetFirstChild <SheetData>();
List <Row> rows = sheetData.Descendants <Row>().ToList();
for (int i = 12; i < rows.Count(); i++) // start with 0 index
{
ContestTable contestTable = new ContestTable();
try
{
string contestName = GetCellValue(spreadSheetDocument, rows[i].Descendants <Cell>().ElementAt(0));
string date = GetCellValue(spreadSheetDocument, rows[i].Descendants <Cell>().ElementAt(1));
string numberOfProblems = GetCellValue(spreadSheetDocument, rows[i].Descendants <Cell>().ElementAt(2));
string participation = GetCellValue(spreadSheetDocument, rows[i].Descendants <Cell>().ElementAt(3));
contestTable.ContestName = contestName;
//contestTable.Date = Convert.ToDateTime(date);
double d = Convert.ToDouble(numberOfProblems);
contestTable.NumberOfProblems = Convert.ToInt32(d);
contestTable.Participation = Convert.ToInt32(participation);
db.ContestTables.Add(contestTable);
}
catch (Exception)
{
//break;
}
}
for (int col = 5; col < rows[3].Count(); col++) // start with 0 index
{
ContestantsTable contestantsTable = new ContestantsTable();
try
{
string studentId = GetCellValue(spreadSheetDocument, rows[3].Descendants <Cell>().ElementAt(col));
string contestantsName = GetCellValue(spreadSheetDocument, rows[4].Descendants <Cell>().ElementAt(col));
string cFHandle = GetCellValue(spreadSheetDocument, rows[5].Descendants <Cell>().ElementAt(col));
contestantsTable.ContestantsName = contestantsName;
contestantsTable.StudentId = studentId;
contestantsTable.CFHandle = cFHandle;
db.ContestantsTables.Add(contestantsTable);
}
catch (Exception)
{
//break;
}
}
db.SaveChanges();
List <ContestantsTable> contestant = db.ContestantsTables.ToList();
List <ContestTable> contest = db.ContestTables.ToList();
//for (int i = 0; i < 130; i++)
//{
// ContestContestant contestContestant = new ContestContestant();
// string conTimeSol = "", upsolve = "";
// try
// {
// conTimeSol = GetCellValue(spreadSheetDocument, rows[12].Descendants<Cell>().ElementAt(i));
// upsolve = GetCellValue(spreadSheetDocument, rows[8].Descendants<Cell>().ElementAt(i));
// if(upsolve == "Upsolves")
// {
// contestContestant.ContestTimeSolve = conTimeSol + "-U-" + i;
// }
// else
// {
// contestContestant.ContestTimeSolve = conTimeSol + "-O-" + i;
// }
// //contestContestant.UpSolve = upsolve + "--" + i;
// db.ContestContestants.Add(contestContestant);
// }
// catch (Exception)
// {
// }
//}
//conTimeSol = GetCellValue(spreadSheetDocument, rows[115].Descendants<Cell>().ElementAt(26));
//upsolve = GetCellValue(spreadSheetDocument, rows[115].Descendants<Cell>().ElementAt(27));
//contestContestant.ContestTimeSolve = conTimeSol;
//contestContestant.UpSolve = upsolve;
//db.ContestContestants.Add(contestContestant);
for (int i = 12; i < contest.Count() + 12; i++)
{
for (int col = 5, row = 0; col < (contestant.Count() * 2) + 5; row++)
{
ContestContestant contestContestant = new ContestContestant();
contestContestant.ContestantId = contestant[row].Id;
contestContestant.ContestId = contest[i - 12].Id;
string conTimeSol = "", upsolve = "";
try
{
conTimeSol = GetCellValue(spreadSheetDocument, rows[i].Descendants <Cell>().ElementAt(col));
//if(conTimeSol != "A")
//{
contestContestant.ContestTimeSolve = conTimeSol; // + "--" + i + "--" + c1; // Convert.ToInt32(conTimeSol);
//}
col++;
}
catch (Exception)
{
col++;
contestContestant.ContestTimeSolve = conTimeSol; // + "--" + i + "--" + c1;
}
try
{
upsolve = GetCellValue(spreadSheetDocument, rows[i].Descendants <Cell>().ElementAt(col));
//if (upsolve != "A")
//{
contestContestant.UpSolve = upsolve; // + "--" + i + "--" + c2; // Convert.ToInt32(upsolve);
//}
col++;
}
catch (Exception)
{
col++;
contestContestant.UpSolve = upsolve; // + "--" + i + "--" + c2;
}
db.ContestContestants.Add(contestContestant);
}
}
//for (int col = 5, row = 5; row < contestant.Count() + 5; row++, col += 2)
//{
// for (int i = 12; i < contest.Count() + 12; i++)
// {
// ContestContestant contestContestant = new ContestContestant();
// contestContestant.ContestantId = contestant[row - 5].Id;
// contestContestant.ContestId = contest[i - 12].Id;
// string conTimeSol = "", upsolve = "";
// try
// {
// conTimeSol = GetCellValue(spreadSheetDocument, rows[i].Descendants<Cell>().ElementAt(col));
// //if (conTimeSol != "A")
// //{
// contestContestant.ContestTimeSolve = conTimeSol; // Convert.ToInt32(conTimeSol);
// //}
// }
// catch (Exception)
// {
// contestContestant.ContestTimeSolve = conTimeSol;
// }
// try
// {
// upsolve = GetCellValue(spreadSheetDocument, rows[i].Descendants<Cell>().ElementAt(col+1));
// //if (upsolve != "A")
// //{
// contestContestant.UpSolve = upsolve; // Convert.ToInt32(upsolve);
// //}
// }
// catch (Exception)
// {
// contestContestant.UpSolve = upsolve;
// }
// db.ContestContestants.Add(contestContestant);
// }
//}
db.SaveChanges();
}
System.IO.File.Delete(path);
return(RedirectToAction("Index", "ContestContestants"));
}
