private Panel createFrameResult(SheetDTO sheet)
{
Panel p = new Panel();
p.Size = new Size(1365, 70);
p.BackColor = SystemColors.InactiveCaption;
Label NO = new Label();
Label Fullname = new Label();
Label dateDo = new Label();
Label scoreTest = new Label();
Button detail = new Button();
NO.Text = COUNT_NO.ToString();
NO.Location = new Point(5, 24);
Fullname.Text = sheet.Fullname;
Fullname.AutoSize = false;
Fullname.Location = new Point(58, 24);
Fullname.Size = new Size(390, 30);
Fullname.TextAlign = ContentAlignment.MiddleCenter;
dateDo.Text = sheet.DateTake.ToString("dd/MM/yyyy h:mm tt");
dateDo.Location = new Point(510, 24);
dateDo.AutoSize = false;
dateDo.TextAlign = ContentAlignment.MiddleLeft;
dateDo.Size = new Size(404, 30);
scoreTest.Text = sheet.Marks;
scoreTest.Location = new Point(956, 24);
scoreTest.AutoSize = false;
scoreTest.Size = new Size(121, 30);
scoreTest.TextAlign = ContentAlignment.MiddleCenter;
detail.Text = "Detail";
detail.Location = new Point(1167, 0);
detail.Size = new Size(218, 70);
detail.FlatStyle = FlatStyle.Flat;
detail.FlatAppearance.BorderSize = 0;
detail.BackColor = System.Drawing.SystemColors.ActiveCaption;
detail.Click += Btndetail_Click;
detail.Tag = sheet;
COUNT_NO += 1;
p.Controls.Add(NO);
p.Controls.Add(Fullname);
p.Controls.Add(dateDo);
p.Controls.Add(scoreTest);
p.Controls.Add(detail);
return(p);
}
private void Btndetail_Click(object sender, EventArgs e)
{
SheetDTO sheet = (sender as Button).Tag as SheetDTO;
string query = $"select codetest from SHEET_ANSWER where userID='{sheet.userID}' and examID='{sheet.examID}' and courseID='{sheet.courseID}'";
DataTable result = DataProvider.Instance.ExecuteQuery(query);
string codeexam = result.Rows[0]["codeTest"].ToString();
FTest1 f = new FTest1(codeexam, UserDTO.Instance.examSelected.courseID, UserDTO.Instance.examSelected.examID, sheet.userID, true);
f.Show();
}
public void ShouldCreateSheet()
{
var sheetDTO = new SheetDTO()
{
Name = "Ficha modelo",
GameStyle = "3D&T",
Text = "Atributos - Forca: 0"
};
ISheetManager sheetManager = new SheetManager();
var sheet = sheetManager.Create(sheetDTO);
Assert.AreEqual(sheetDTO.Name, sheet.Name);
Assert.AreEqual(sheetDTO.GameStyle, sheet.GameStyle);
Assert.AreEqual(sheetDTO.Text, sheet.Text);
}
public Collection <SheetDTO> extractExcelToCellDtos(string path)
{
Collection <SheetDTO> rtnCollection = new Collection <SheetDTO>();
var filePath = path;
var document = SpreadsheetDocument.Open(filePath, false);
var workbookPart = document.WorkbookPart;
var workbook = workbookPart.Workbook;
var sheets = workbook.Descendants <Sheet>();
foreach (var sheet in sheets)
{
SheetDTO sheetDTO = new SheetDTO();
sheetDTO.Cells = new Collection <CellDTO>();
sheetDTO.SheetId = sheet.Id;
sheetDTO.SheetName = sheet.Name;
var worksheetPart = (WorksheetPart)workbookPart.GetPartById(sheet.Id);
var sharedStringPart = workbookPart.SharedStringTablePart;
var values = sharedStringPart;
var lastCell = worksheetPart.Worksheet.Descendants <Cell>().LastOrDefault();
//var values2 = sharedStringPart.SharedStringTable;
//var values3 = sharedStringPart.SharedStringTable.Elements<SharedStringItem>();
//var values4 = sharedStringPart.SharedStringTable.Elements<SharedStringItem>().ToArray();
var cells = worksheetPart.Worksheet.Descendants <Cell>();
foreach (var cell in cells)
{
CellDTO cellDTO = new CellDTO();
cellDTO.CellAddress = cell.CellReference;
cellDTO.Value = cell.CellValue != null ? cell.CellValue.Text : null;
cellDTO.Formula = cell.CellFormula != null ? cell.CellFormula.Text : null;
sheetDTO.Cells.Add(cellDTO);
}
rtnCollection.Add(sheetDTO);
}
return(rtnCollection);
}
public List <SheetDTO> getSheetAnswerByIduser(string examId, string courseID, string idUser)
{
List <SheetDTO> lst = new List <SheetDTO>();
string query = $"select * from SHEET_ANSWER join systemuser on userID=uID where examID='{examId}' and CourseID='{courseID}' and userID='{idUser}'";
DataTable result = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow i in result.Rows)
{
SheetDTO t = new SheetDTO();
t.examID = examId;
t.courseID = courseID;
t.CodeTest = i["codeTest"].ToString().Trim();
t.DateTake = (DateTime)i["DateTake"];
t.Fullname = i["FirstName"].ToString().Trim() + " " + i["LastName"].ToString().Trim();
t.Marks = i["Marks"].ToString().Trim();
t.userID = idUser;
lst.Add(t);
}
return(lst);
}
public void ShouldEditSheet()
{
var sheetDTO = new SheetDTO()
{
Name = "Ficha modelo [MODIFIED]",
GameStyle = "3D&T [MODIFIED]",
};
var sheet = new Sheet()
{
Name = "Ficha modelo",
GameStyle = "3D&T",
Text = "Atributos - Forca: 0"
};
ISheetManager sheetManager = new SheetManager();
var sheetEdited = sheetManager.Edit(sheet, sheetDTO);
Assert.AreEqual(sheetDTO.Name, sheetEdited.Name);
Assert.AreEqual(sheetDTO.GameStyle, sheetEdited.GameStyle);
Assert.AreEqual(sheet.Text, sheetEdited.Text);
}
public async Task <ActionResult <Sheet> > PostSheet(SheetDTO sheet)
{
Gebruiker gebruiker = await _gebruikersRepository.GetByGebruikersnaam(User.Identity.Name);
if (gebruiker == null)
{
return(Unauthorized());
}
Sheet sheetToCreate = new Sheet()
{
Naam = sheet.Naam, Auteur = gebruiker.Gebruikersnaam
};
sheet.Noten = sheet.Noten.OrderBy(s => s.Tijdstip).ToList();
foreach (var noot in sheet.Noten)
{
sheetToCreate.VoegNootToe(new Noot(noot.Midiwaarde, noot.Tijdstip));
}
gebruiker.VoegSheetToe(sheetToCreate);
_gebruikersRepository.SaveChanges();
return(CreatedAtAction(nameof(GetSheet), new { id = sheetToCreate.Id }, sheetToCreate));
}
public async Task <IEnumerable <SheetDTO> > GetSheets()
{
var x = User.Identity.Name;
Gebruiker gebruiker = await _gebruikersRepository.GetByGebruikersnaam(User.Identity.Name);
List <SheetDTO> sheets = new List <SheetDTO>();
foreach (var sheet in gebruiker.Sheets)
{
SheetDTO sheetdto = new SheetDTO();
sheetdto.Id = sheet.Id;
sheetdto.Naam = sheet.Naam;
sheetdto.Auteur = sheet.Auteur;
foreach (var noot in sheet.Noten)
{
sheetdto.Noten.Add(new NootDTO {
Midiwaarde = noot.Midiwaarde, Tijdstip = noot.Tijdstip
});
}
sheets.Add(sheetdto);
}
return(sheets);
}
public AdvancedList<SheetDTO> GetSheetDTOByDate(DateTime date)
{
AdvancedList<SheetDTO> sheetsDTO = new AdvancedList<SheetDTO>();
foreach (var sheet in sheets.Where(s => s.start.Date.Equals(date.Date) && s.job != null))
{
SheetDTO sheetDTO = new SheetDTO();
sheetDTO.JobName = sheet.job.name;
sheetDTO.JobNum = sheet.job.number.ToString();
sheetDTO.TaskNum = sheet.job.task.number.ToString();
sheetDTO.TaskName = sheet.job.task.name;
sheetDTO.ProjectNum = sheet.job.task.project.number.ToString();
sheetDTO.ProjectName = sheet.job.task.project.name;
sheetDTO.Start = sheet.start.ToLongTimeString();
sheetDTO.End = sheet.end.ToLongTimeString();
sheetDTO.Duration = sheet.end.Subtract(sheet.start).ToString();
sheetDTO.Note = sheet.note;
sheetsDTO.Add(sheetDTO);
}
if (actualSheet != null && actualSheet.start.Date.Equals(date.Date))
{
SheetDTO sheetDTO = new SheetDTO();
sheetDTO.JobNum = actualSheet.job.number.ToString();
sheetDTO.JobName = actualSheet.job.name;
sheetDTO.TaskNum = actualSheet.job.task.number.ToString();
sheetDTO.TaskName = actualSheet.job.task.name;
sheetDTO.ProjectNum = actualSheet.job.task.project.number.ToString();
sheetDTO.ProjectName = actualSheet.job.task.project.name;
sheetDTO.Start = actualSheet.start.ToLongTimeString();
sheetsDTO.Add(sheetDTO);
}
return sheetsDTO;
}
