public static ViewClassReport ToViewModel(ClassReport model)
{
if (model == null)
{
return(null);
}
ViewClassReport item = new ViewClassReport();
item.Id = model.Id;
item.Title = model.Title;
item.Content = model.Content;
item.UserId = model.UserId;
item.ClassId = model.ClassId;
item.IsDeleted = model.IsDeleted;
item.CreateTime = model.CreateTime;
List <ViewClassFile> files = (from f in model.ClassFile select ViewClassFile.ToViewModel(f)).ToList();
item.Images = new List <ViewClassFile>();
item.Videos = new List <ViewClassFile>();
foreach (var file in files)
{
if (file.Type == 11)
{
item.Images.Add(file);
}
else if (file.Type == 12)
{
item.Videos.Add(file);
}
}
return(item);
}
public ActionResult Report(ClassReport classReport)
{
DateTime dFrom;
DateTime dTo;
DateTime dNow = DateTime.Now;
bool dateFromOk = DateTime.TryParseExact(classReport.ClassDateFrom, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out dFrom);
bool dateToOk = DateTime.TryParseExact(classReport.ClassDateTo, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out dTo);
if (dateFromOk && dateToOk)
{
classReport.TotalAttended = db.MemberClassBookings.Where(bk => bk.Attended && bk.GymClass.ClassDateTime >= dFrom && bk.GymClass.ClassDateTime <= dTo).Count();
classReport.TotalBookings = db.MemberClassBookings.Where(bk => !bk.Waiting && bk.GymClass.ClassDateTime >= dFrom && bk.GymClass.ClassDateTime <= dTo).Count();
classReport.TotalWaitingList = db.MemberClassBookings.Where(bk => bk.Waiting && bk.GymClass.ClassDateTime >= dFrom && bk.GymClass.ClassDateTime <= dTo).Count();
if (dFrom < dNow && dNow < dTo)
{
dTo = dNow;
}
if (dFrom < dNow && dTo <= dNow)
{
classReport.NoShowMembers = NoShowList(dFrom, dTo);
}
}
return(View(classReport));
}
private ClassReport ValidateParameterTypes(ClassReport report)
{
foreach (var method in methodPairs.Keys)
{
var methodModel = methodPairs[method];
if (methodModel.ExpectedParameters != null)
{
var parameters = method.ParameterList.Parameters;
var expectedParameters = methodPairs[method].ExpectedParameters;
var areMatching = parameters
.SelectMany(x => new ParamList {
{ x.Type.ToString(), x.Identifier.ToString() }
})
.Intersect(expectedParameters)
.Count() == parameters.Count;
if (areMatching)
{
report.ValidMethodsByParameters.Add(method);
}
else
{
report.MismatchingParametersMethods.Add(method);
}
}
}
return(report);
}
public ClassReport GetClassReportForActualClass(ActualClassDto actualClass)
{
ClassReport cr = new ClassReport();
IList <FeedbackDto> feedbackDtos = _feedbackRepository.GetAllFeedbacksForActualClass(actualClass.Id);
foreach (FeedbackDto dto in feedbackDtos)
{
cr.AttractivenessRating += dto.Attractiveness;
cr.ClearnessRating += dto.Clearness;
cr.ComprehensionRating += dto.Comprehension;
cr.CorrectnessRating += dto.Correctness;
cr.HighScientificLevelRating += dto.HighScientificLevel;
cr.RigorousScientificLevelRating += dto.RigorousScientificLevel;
cr.UsefulnessRating += dto.Usefulness;
cr.NoveltyRating += dto.Novelty;
cr.InteractivityRating += dto.Interactivity;
}
cr.InteractivityRating /= feedbackDtos.Count;
cr.AttractivenessRating /= feedbackDtos.Count;
cr.ClearnessRating /= feedbackDtos.Count;
cr.ComprehensionRating /= feedbackDtos.Count;
cr.CorrectnessRating /= feedbackDtos.Count;
cr.HighScientificLevelRating /= feedbackDtos.Count;
cr.NoveltyRating /= feedbackDtos.Count;
cr.RigorousScientificLevelRating /= feedbackDtos.Count;
cr.UsefulnessRating /= feedbackDtos.Count;
cr.GeneralRating = (cr.InteractivityRating + cr.ClearnessRating + cr.CorrectnessRating +
cr.HighScientificLevelRating + cr.NoveltyRating + cr.RigorousScientificLevelRating +
cr.UsefulnessRating + cr.AttractivenessRating) / 8;
return(cr);
}
private void Report_Load(object sender, EventArgs e)
{
if (str == "Student")
{
StudentReport sr = new StudentReport();
sr.SetDataSource(dss);
crystalReportViewer1.ReportSource = sr;
}
else if (str == "Staff")
{
StaffReport sr2 = new StaffReport();
sr2.SetDataSource(dss);
crystalReportViewer1.ReportSource = sr2;
}
else if (str == "User")
{
UserReport sr2 = new UserReport();
sr2.SetDataSource(dss);
crystalReportViewer1.ReportSource = sr2;
}
else if (str == "Class")
{
ClassReport cr = new ClassReport();
cr.SetDataSource(dss);
crystalReportViewer1.ReportSource = cr;
}
}
private void dgvDetaila_DoubleClick(object sender, EventArgs e)
{
GalDetID = int.Parse(dgvDetaila.CurrentRow.Cells[0].Value.ToString());
txtProduct.Text = dgvDetaila.CurrentRow.Cells[6].Value.ToString();
txtCompany.Text = dgvDetaila.CurrentRow.Cells[7].Value.ToString();
DataTable dt = ClassReport.selectIMGDet(GalDetID);
Gal_id = int.Parse(dt.Rows[0][0].ToString());
Product_ID = int.Parse(dt.Rows[0][1].ToString());
company_id = int.Parse(dt.Rows[0][2].ToString());
proImg = ClassReport.selectProIMG(Product_ID);
comIMG = ClassReport.selectComIMG(company_id);
comBC = ClassReport.selectBCIMG(company_id);
catalog = ClassReport.selectCatalogIMG(Gal_id);
billIMG = ClassReport.selectBillIMG(Gal_id);
QuotIMG = ClassReport.selectQuotIMG(Gal_id);
picN1 = picN2 = 1;
picP1 = picP2 = 0;
pic1State = pic2State = "";
txtDate.Text = "";
// picBox2.Visible = false;
// picBox1.Visible = false;
picBox1.Image = picBox2.Image = null;
}
// Methods
public SchoolYearScoreReportNew()
{
string reportName = "學年成績單(新制)";
string reportPath = "成績相關報表";
this.buttonStudent = new ButtonAdapter();
this.buttonStudent.Text = reportName;
this.buttonStudent.Path = reportPath;
this.buttonStudent.OnClick += new EventHandler(this.buttonStudent_OnClick);
this.buttonClass = new ButtonAdapter();
this.buttonClass.Text = reportName;
this.buttonClass.Path = reportPath;
this.buttonClass.OnClick += new EventHandler(this.buttonClass_OnClick);
StudentReport.AddReport(this.buttonStudent);
ClassReport.AddReport(this.buttonClass);
string Student = "SHEvaluation.SchoolYearScoreReportNew.Student";
string Class = "SHEvaluation.SchoolYearScoreReportNew.Class";
RibbonBarItem item1 = FISCA.Presentation.MotherForm.RibbonBarItems["學生", "資料統計"];
item1["報表"][reportPath][reportName].Enable = FISCA.Permission.UserAcl.Current[Student].Executable;
RibbonBarItem item2 = FISCA.Presentation.MotherForm.RibbonBarItems["班級", "資料統計"];
item2["報表"][reportPath][reportName].Enable = FISCA.Permission.UserAcl.Current[Class].Executable;
//權限設定
Catalog permission1 = RoleAclSource.Instance["學生"]["報表"];
permission1.Add(new RibbonFeature(Student, reportName));
Catalog permission2 = RoleAclSource.Instance["班級"]["報表"];
permission2.Add(new RibbonFeature(Class, reportName));
}
public ViewModel.ViewClassReport Add(ViewModel.ViewClassReport report)
{
ClassReport cr = _repository.Add(ViewClassReport.ToEntity(report));
report.Id = cr.Id;
return(report);
}
public ClassSemesterScore()
{
classButton = new SecureButtonAdapter("Report0160");
classButton.Text = "班級學生學期成績一覽表";
classButton.Path = "成績相關報表";
classButton.OnClick += new EventHandler(classButton_OnClick);
ClassReport.AddReport(classButton);
}
public SemesterMoralScoreCalc()
{
button = new SecureButtonAdapter("Report0270");
button.Text = "德行成績試算表(舊制)";
button.Path = "學務相關報表";
button.OnClick += new EventHandler(button_OnClick);
ClassReport.AddReport(button);
}
public FRM_Report()
{
InitializeComponent();
cmbStatus.Items.Add(FRM_Main.notEXE);
cmbStatus.Items.Add(FRM_Main.ToDoEXE);
cmbStatus.Items.Add(FRM_Main.DoneEXE);
cmbStatus.Text = FRM_Main.ToDoEXE;
fillEmp();
dgvTasks.DataSource = ClassReport.selectAllTask();
}
public CreditStatistic()
{
ButtonAdapter button = new SecureButtonAdapter("Report0180");
button.Text = "學分統計表";
button.Path = "成績相關報表";
button.OnClick += new EventHandler(button_OnClick);
ClassReport.AddReport(button);
}
public static async Task GenerateAsync(ClassReport classReport, Class selectedClass, int session, string[] classSubjects)
{
try
{
//Renderer.RenderHtmlAsPdf("<h1>Hello World<h1>").SaveAs("test.pdf");
//var renderer = new HtmlToPdf();
//var pdf = renderer.RenderHtmlAsPdf("<h1>Hello IronPdf</h1>");
//pdf.SaveAs("test.pdf");
Console.WriteLine("Inside Generator");
//Console.WriteLine(System.Text.Json.JsonSerializer.Serialize(classSubjects, new System.Text.Json.JsonSerializerOptions { PropertyNamingPolicy = System.Text.Json.JsonNamingPolicy.CamelCase }));
// downloads chromium to a temp folder, you can also specify a specific version, or a location where it should look for chromium.
await new BrowserFetcher().DownloadAsync(BrowserFetcher.DefaultRevision);
Console.WriteLine("Downloaded Browser");
using var browser = await Puppeteer.LaunchAsync(new LaunchOptions
{
Headless = false
});
Console.WriteLine("Set headless = false");
using var page = await browser.NewPageAsync();
Console.WriteLine("Executed: using var page = await browser.NewPageAsync();");
var reportCardString = PdfReportCardHtmlTemplate.GetHTMLString(classReport, selectedClass, session, classSubjects);
Console.WriteLine("Executed: reportCardString as follows:");
Console.WriteLine(System.Text.Json.JsonSerializer.Serialize(reportCardString, new System.Text.Json.JsonSerializerOptions {
PropertyNamingPolicy = System.Text.Json.JsonNamingPolicy.CamelCase
}));
await page.SetContentAsync(reportCardString);
Console.WriteLine("Executed: await page.SetContentAsync(reportCardString);");
await page.GetContentAsync();
Console.WriteLine("Executed: await page.GetContentAsync();");
await page.PdfAsync("ReportCard.pdf", new PdfOptions
{
DisplayHeaderFooter = false,
Format = PaperFormat.A4,
Landscape = true,
});
Console.WriteLine("End of Generator");
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
}
public static ClassReport ToEntity(ViewClassReport model)
{
ClassReport item = new ClassReport();
item.Id = model.Id;
item.Title = model.Title;
item.Content = model.Content;
item.UserId = model.UserId;
item.ClassId = model.ClassId;
item.IsDeleted = model.IsDeleted;
item.CreateTime = model.CreateTime;
return(item);
}
public ClassReport Build()
{
var classReport = new ClassReport();
ValidateReturnTypes(classReport);
ValidateParameterTypes(classReport);
ValidateMethodsExisting(classReport);
var methodsToCompile = from m in methodPairs
where m.Value.ToBeCompiled
select m.Key;
if (Directory.Exists(compilationPath))
{
HelperMethods.DeleteDirectory(compilationPath);
}
else
{
Directory.CreateDirectory(compilationPath);
}
Parallel.ForEach(methodsToCompile, (method) =>
{
var methodModel = methodPairs[method];
var compilationResult = CompileMethod(method, methodModel.CompilationParameters);
compilationResults.Add(compilationResult);
if (compilationResult.ToString().Contains("Error"))
{
classReport.HadCompilationError = true;
}
if (
compilationResult.ToString() == methodModel.ExpectedOutput?.ToString() ||
compilationResult.ToString() == methodModel.ExpectedStringOutput?.ToString())
{
classReport.ValidMethodsByOutput.Add(method.Identifier.ValueText);
}
else
{
classReport.MismatchingOutputMethods.Add(method.Identifier.ValueText);
}
});
HelperMethods.DeleteDirectory(compilationPath);
return(classReport);
}
private void OnButtonCreateClick(object sender, EventArgs e)
{
int index = this.cbSubjects.SelectedIndex;
if (index < 0 || index >= avaialableClasses.Count)
{
return;
}
var cls = avaialableClasses[index];
var report = new ClassReport();
SQLConnections.FillResultReportsByClass(this.teacherID, cls.ID, this.start, this.end, report);
this.Close();
new ClassReportForm(report).ShowDialog();
}
private ClassReport ValidateReturnTypes(ClassReport report)
{
foreach (var method in methodPairs.Keys)
{
var methodModel = methodPairs[method];
if (methodModel.ExpectedReturnType != null)
{
if (method.ReturnType.ToString().ToLower() == methodModel.ExpectedReturnType?.Name.ToLower())
{
report.ValidMethodsByReturnType.Add(method);
}
else
{
report.MismatchingReturnTypeMethods.Add(method);
}
}
}
return(report);
}
public static void RegistryFeature()
{
SemesterScoreReportNew semsScoreReport = new SemesterScoreReportNew();
string reportName = "學期成績單(新制)";
string path = "成績相關報表";
semsScoreReport.button = new SecureButtonAdapter("Report0055");
semsScoreReport.button.Text = reportName;
semsScoreReport.button.Path = path;
semsScoreReport.button.OnClick += new EventHandler(semsScoreReport.button_OnClick);
StudentReport.AddReport(semsScoreReport.button);
semsScoreReport.button2 = new SecureButtonAdapter("Report0155");
semsScoreReport.button2.Text = reportName;
semsScoreReport.button2.Path = path;
semsScoreReport.button2.OnClick += new EventHandler(semsScoreReport.button2_OnClick);
ClassReport.AddReport(semsScoreReport.button2);
}
public SemesterScoreReport()
{
string reportName = "學期成績單";
string path = "成績相關報表";
_ErrorMessage = new StringBuilder();
button = new SecureButtonAdapter("Report0050");
button.Text = reportName;
button.Path = path;
button.OnClick += new EventHandler(button_OnClick);
StudentReport.AddReport(button);
button2 = new SecureButtonAdapter("Report0150");
button2.Text = reportName;
button2.Path = path;
button2.OnClick += new EventHandler(button2_OnClick);
ClassReport.AddReport(button2);
}
public ClassReport Build()
{
var classReport = new ClassReport();
ValidateReturnTypes(classReport);
ValidateParameterTypes(classReport);
ValidateMethodsExisting(classReport);
var methodsToCompile = from m in methodPairs
where m.Value.ToBeCompiled
select m.Key;
Parallel.ForEach(methodsToCompile, (method) =>
{
compilationResults.Add(CompileMethod(method, methodPairs[method].CompilationParameters));
});
;
return(classReport);
}
public ActionResult DeleteRange(string classDateFrom, string classDateTo)
{
DateTime dFrom;
DateTime dTo;
ClassReport classReport = new ClassReport();
classReport.ClassDateFrom = classDateFrom;
classReport.ClassDateTo = classDateTo;
bool dateFromOk = DateTime.TryParseExact(classDateFrom, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out dFrom);
bool dateToOk = DateTime.TryParseExact(classDateTo, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out dTo);
if (dateFromOk && dateToOk)
{
var bookings = db.MemberClassBookings.Where(bk => bk.GymClass.ClassDateTime >= dFrom && bk.GymClass.ClassDateTime <= dTo).ToList();
db.MemberClassBookings.RemoveRange(bookings);
var classes = db.GymClass.Where(bk => bk.ClassDateTime >= dFrom && bk.ClassDateTime <= dTo).ToList();
db.GymClass.RemoveRange(classes);
db.SaveChanges();
}
return(RedirectToAction("Report", classReport));
}
private void btnSearch_Click(object sender, EventArgs e)
{
if (dtpDate.Enabled == false && cmbStatus.Enabled == false && cmbEmp.Enabled == false)
{
MessageBox.Show("لم تحدد اي خيار للبحث");
}
else
{
if (cmbEmp.Enabled == true && cmbStatus.Enabled == false && dtpDate.Enabled == false)
{
dgvTasks.DataSource = ClassReport.selectAllTaskEmp(cmbEmp.Text);
}
if (dtpDate.Enabled == true && cmbEmp.Enabled == true && cmbStatus.Enabled == true)
{
dgvTasks.DataSource = ClassReport.selectAllTaskDateNmaeState(dtpDate.Value, cmbEmp.Text, cmbStatus.Text);
}
if (cmbStatus.Enabled == true && cmbEmp.Enabled == false && dtpDate.Enabled == false)
{
dgvTasks.DataSource = ClassReport.selectAllTaskStatus(cmbStatus.Text);
}
if (cmbEmp.Enabled == true && cmbStatus.Enabled == true && dtpDate.Enabled == false)
{
dgvTasks.DataSource = ClassReport.selectAllTaskNmaeState(cmbEmp.Text, cmbStatus.Text);
}
if (dtpDate.Enabled == true && cmbEmp.Enabled == true && cmbStatus.Enabled == false)
{
dgvTasks.DataSource = ClassReport.selectAllTaskDateNmae(dtpDate.Value, cmbEmp.Text);
}
if (dtpDate.Enabled == true && cmbStatus.Enabled == true && cmbEmp.Enabled == false)
{
dgvTasks.DataSource = ClassReport.selectAllTaskDateState(dtpDate.Value, cmbStatus.Text);
}
if (dtpDate.Enabled == true && cmbStatus.Enabled == false && cmbEmp.Enabled == false)
{
dgvTasks.DataSource = ClassReport.selectAllTaskDate(dtpDate.Value);
}
}
}
public MultiSemesterScore()
{
string report_name = "多學期成績單";
string report_path = "成績相關報表";
//_student_button = new ButtonAdapter();
//_student_button.Text = report_name;
//_student_button.Path = report_path;
//_student_button.OnClick += new EventHandler(studentButton_OnClick);
//StudentReport.AddReport(_student_button);
_class_button = new SecureButtonAdapter("Report0170");
_class_button.Text = report_name;
_class_button.Path = report_path;
_class_button.OnClick += new EventHandler(classButton_OnClick);
ClassReport.AddReport(_class_button);
ButtonAdapter _student_button = new SecureButtonAdapter("Report0060");
_student_button.Text = report_name;
_student_button.Path = report_path;
_student_button.OnClick += new EventHandler(_student_button_OnClick);
StudentReport.AddReport(_student_button);
}
public override void DecrementCounterFor(ClassReport classReport)
{
classReport.FailedTests--;
}
//************************
//************************
private void txtSearch_TextChanged(object sender, EventArgs e)
{
dgvDetaila.DataSource = ClassReport.SearchInAllDetails(txtSearch.Text);
}
void displayData()
{
DataTable dt = ClassReport.SelectAllDetails();
dgvDetaila.DataSource = dt;
}
private void ValidateMethodsExisting(ClassReport report)
{
report.MissingMethods = methodsNotFound;
report.ValidMethodsByExistence = methodPairs.Keys.ToList().Select(x => x.Identifier.ValueText).ToList();
}
private DataSet GetGridData()
{
DataSet oDs;
try
{
ClassReport oRep = new ClassReport();
oDs = oRep.GetBudgetReport(Int32.Parse(this.ddlProjects.SelectedValue.ToString()));
}
catch (Exception ex)
{
Log.LogMsg(ex.Message);
oDs = null;
}
return oDs;
}
private void OnRenderGraph(ZedGraph.Web.ZedGraphWeb z, System.Drawing.Graphics g, ZedGraph.MasterPane masterPane)
{
// Get the GraphPane so we can work with it
GraphPane myPane = masterPane[0];
// Set the title and axis labels
myPane.Title.Text = "";
myPane.YAxis.Title.Text = "User";
myPane.XAxis.Title.Text = "Productivity %";
// Get productivity for team users.
DateTime DateStart = this.cc2DateSelector.StartDate();
DateTime DateEnd = this.cc2DateSelector.EndDate();
myPane.Title.Text = string.Format("{0} - {1}", ClassTimeAndDate.DateToString(DateStart), ClassTimeAndDate.DateToString(DateEnd));
ClassReport oRep = new ClassReport();
DataSet oDs = oRep.GetTeamProductivity(Convert.ToInt32(this.DdlTeams.SelectedValue), Convert.ToInt32(this.DdlUsers.SelectedValue), DateStart, DateEnd);
Int32 RowNo = 0;
string[] labels = new string[oDs.Tables[0].Rows.Count];
double[] values = new double[oDs.Tables[0].Rows.Count];
for (RowNo = 0; RowNo < oDs.Tables[0].Rows.Count; RowNo++)
{
labels[RowNo] = oDs.Tables[0].Rows[RowNo]["UserName"].ToString();
values[RowNo] = Convert.ToDouble(oDs.Tables[0].Rows[RowNo]["Productivity"].ToString());
}
myPane.YAxis.Scale.TextLabels = labels;
myPane.YAxis.Type = AxisType.Text;
myPane.XAxis.Scale.Min = 0;
myPane.XAxis.Scale.Max = 120.0;
myPane.XAxis.MajorTic.Size = 10.0F;
myPane.XAxis.MajorTic.IsInside = false;
myPane.XAxis.MajorGrid.IsVisible = true;
myPane.XAxis.MinorTic.Size = 5.0F;
myPane.XAxis.MinorTic.IsInside = false;
// Legend.
BarItem myCurve = myPane.AddBar("Productivity", values, null, Color.Red);
// Chart background.
myPane.Chart.Fill = new Fill(Color.White, Color.FromArgb(255, 255, 166), 45.0F);
myPane.BarSettings.Base = BarBase.Y;
masterPane.AxisChange(g);
BarItem.CreateBarLabels(myPane, false, "f0");
Page.Title = TXT_PAGETITLE;
this.LblPageTitle.Text = TXT_PAGETITLE;
}
public abstract void IncrementCounterFor(ClassReport classReport);
private DataSet GetGridData()
{
DataSet oDs;
DateTime DateStart = this.cc2DateSelector.StartDate();
DateTime DateEnd = this.cc2DateSelector.EndDate();
try
{
ClassReport oRep = new ClassReport();
oDs = oRep.GetTimeSheet(Int32.Parse(this.DdlUsers.SelectedValue.ToString()), DateStart, DateEnd);
}
catch (Exception ex)
{
Log.LogMsg(ex.Message);
oDs = null;
}
return oDs;
}
private void btnDisplayAll_Click(object sender, EventArgs e)
{
dgvTasks.DataSource = ClassReport.selectAllTask();
cmbEmp.Enabled = cmbStatus.Enabled = dtpDate.Enabled = false;
chkEmp.Checked = chkStatus.Checked = chkDate1.Checked = false;
}
private void ShowGrid()
{
this.LblFrom.Text = this.cc2DateSelector.StartDate().ToLongDateString();
this.LblTo.Text = this.cc2DateSelector.EndDate().ToLongDateString();
this.LblProductive.Text = "";
this.LblUnproductive.Text = "";
this.LblProductivePercent.Text = "";
ClassReport oRep = new ClassReport();
DataSet oDs = oRep.GetCostCentre(this.cc2DateSelector.StartDate(), this.cc2DateSelector.EndDate());
double TotalHours = 0.0;
Boolean bOkay = false;
double Productive = 0.0;
double Unproductive = 0.0;
if (oDs != null)
{
if (oDs.Tables.Count > 0)
{
if (oDs.Tables[0].Rows.Count > 0)
{
bOkay = true;
foreach (DataRow oDr in oDs.Tables[0].Rows)
{
TotalHours += Convert.ToDouble(oDr["Hours"].ToString());
if (oDr["IsProductive"].ToString() == "Yes")
Productive += Convert.ToDouble(oDr["Hours"].ToString());
else
Unproductive += Convert.ToDouble(oDr["Hours"].ToString());
}
}
}
}
ViewState["TotalHours"] = TotalHours.ToString();
if (bOkay == true)
{
this.GridTime.DataSource = oDs;
this.GridTime.DataBind();
}
else
{
this.GridTime.DataSource = null;
this.GridTime.DataBind();
}
this.LblProductive.Text = Productive.ToString("N2");
this.LblUnproductive.Text = Unproductive.ToString("N2");
if ((Productive + Unproductive) != 0)
{
this.LblProductivePercent.Text = string.Format("{0:N2}%", (100 * Productive / (Productive + Unproductive)));
}
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
dgvTasks.DataSource = ClassReport.SearchPublicAllTask(txtSearch.Text);
chkDate1.Checked = chkEmp.Checked = chkStatus.Checked = false;
}
public void AddReport(ClassReport report)
{
Reports.Add(report);
}
private DataSet GetGridData()
{
DataSet oDs;
DateTime DateStart = this.cc2DateSelector.StartDate();
DateTime DateEnd = this.cc2DateSelector.EndDate();
try
{
ClassReport oRep = new ClassReport();
oDs = oRep.GetReportByReference(Convert.ToInt32(this.DdlTeams.SelectedValue.ToString()),
Convert.ToInt32(this.DdlUsers.SelectedValue), DateStart, DateEnd);
}
catch (Exception ex)
{
Log.LogMsg(ex.Message);
oDs = null;
}
return oDs;
}
private void DoExport(Boolean bToCSV)
{
ClassReport oRep = new ClassReport();
DataSet oDs = GetGridData();
Boolean bOkay = false;
this.RowError1.Visible = false;
this.RowError2.Visible = false;
if (oDs != null)
{
if (oDs.Tables.Count > 0)
{
if (oDs.Tables[0].Rows.Count > 0)
{
bOkay = true;
}
}
}
if (bOkay == true)
{
RKLib.ExportData.Export oExp = new RKLib.ExportData.Export("Web");
Int32[] Columns = { 0, 1, 2 };
if (bToCSV == true)
{
// Export to CSV file.
oExp.ExportDetails(oDs.Tables[0], Columns, RKLib.ExportData.Export.ExportFormat.CSV, "Report.csv");
}
else
{
// Export to Microsoft Excel.
oExp.ExportDetails(oDs.Tables[0], Columns, RKLib.ExportData.Export.ExportFormat.Excel, "Report.xls");
}
}
else
{
this.RowError1.Visible = true;
this.RowError2.Visible = true;
this.LblMsg.Text = "No Data Found!";
}
}
public static string GetHTMLString(ClassReport classReport, Class selectedClass, int session, string[] classSubjects)
{
var sb = new StringBuilder();
sb.Append($@"
<html>
<head>
</head>
<body>
<div id='all-report-cards'>");
foreach (var studentReport in classReport.StudentReports)
{
sb.Append($@"
<div class='report-card'>
<table align='center'> ");
sb.Append($@"
<tr>
<td>
<h3 class='py-2'>{studentReport.StudentName}</h3>
<p>Class: {selectedClass.Name}</p>
<p>Session: {session}</p>
</td>
</tr>");
sb.Append($@"
<tr>
<td>
<table>
<tr>
<th>First Term</th>
<th>Second Term</th>
<th>Third Term</th>
</tr>
<tr>
<td>");
var firstTermReport = studentReport.TermReports.FirstOrDefault(x => x.Term == Term.FirstTerm);
var firstTermStat = classReport.ScoresStat.TermStats.FirstOrDefault(x => x.Term == Term.FirstTerm);
sb.Append($@"
<table class='report-card-data'>
<colgroup>
<col class='column-width-subject' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
</colgroup>
<tr class='vertical-align'>
<th>Subject</th>
<th>C.A</th>
<th>1st Exam</th>
<th>2nd Exam</th>
<th>Homework</th>
<th>Class Acts</th>
<th>Total</th>
<th>Class Min</th>
<th>Class Max</th>
<th>Class Ave</th>
<th>Grade</th>
</tr>");
foreach (var subject in classSubjects)
{
var subjectReport = firstTermReport?.SubjectReports.FirstOrDefault(x => x.Subject == subject);
var subjectStat = firstTermStat?.Stats.FirstOrDefault(x => x.Subject == subject);
sb.Append($@"
<tr class='report-card-data'>
<td>{subject}</td>
<td>{subjectReport?.CAScore}</td>
<td>{subjectReport?.FirstExamScore}</td>
<td>{subjectReport?.SecondExamScore}</td>
<td>{subjectReport?.HomeworkScore}</td>
<td>{subjectReport?.ClassActivitiesScore}</td>
<td>{subjectReport?.WeightedScore}</td>
<td>{subjectStat?.ClassMinScore}</td>
<td>{subjectStat?.ClassMaxScore}</td>
<td>{subjectStat?.ClassAverageScore}</td>
<td>{subjectReport?.Grade}</td>
</tr>");
}
sb.Append($@"
</table>
</td>
<td>");
var secondTermReport = studentReport.TermReports.FirstOrDefault(x => x.Term == Term.SecondTerm);
var secondTermStat = classReport.ScoresStat.TermStats.FirstOrDefault(x => x.Term == Term.SecondTerm);
sb.Append($@"
<table class='report-card-data'>
<colgroup>
<col class='column-width-subject' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
</colgroup>
<tr class='vertical-align'>
<th>Subject</th>
<th>C.A</th>
<th>1st Exam</th>
<th>2nd Exam</th>
<th>Homework</th>
<th>Class Acts</th>
<th>Total</th>
<th>Class Min</th>
<th>Class Max</th>
<th>Class Ave</th>
<th>Grade</th>
</tr>");
foreach (var subject in classSubjects)
{
var subjectReport = secondTermReport?.SubjectReports.FirstOrDefault(x => x.Subject == subject);
var subjectStat = secondTermStat?.Stats.FirstOrDefault(x => x.Subject == subject);
sb.Append($@"
<tr class='report-card-data'>
<td>{subject}</td>
<td>{subjectReport?.CAScore}</td>
<td>{subjectReport?.FirstExamScore}</td>
<td>{subjectReport?.SecondExamScore}</td>
<td>{subjectReport?.HomeworkScore}</td>
<td>{subjectReport?.ClassActivitiesScore}</td>
<td>{subjectReport?.WeightedScore}</td>
<td>{subjectStat?.ClassMinScore}</td>
<td>{subjectStat?.ClassMaxScore}</td>
<td>{subjectStat?.ClassAverageScore}</td>
<td>{subjectReport?.Grade}</td>
</tr>");
}
sb.Append($@"
</table>
</td>
<td>");
var thirdTermReport = studentReport.TermReports.FirstOrDefault(x => x.Term == Term.ThirdTerm);
var thirdTermStat = classReport.ScoresStat.TermStats.FirstOrDefault(x => x.Term == Term.ThirdTerm);
sb.Append($@"
<table class='report-card-data'>
<colgroup>
<col class='column-width-subject' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
<col class='column-width' />
</colgroup>
<tr class='vertical-align'>
<th>Subject</th>
<th>C.A</th>
<th>1st Exam</th>
<th>2nd Exam</th>
<th>Homework</th>
<th>Class Acts</th>
<th>Total</th>
<th>Class Min</th>
<th>Class Max</th>
<th>Class Ave</th>
<th>Grade</th>
</tr>");
foreach (var subject in classSubjects)
{
var subjectReport = thirdTermReport?.SubjectReports.FirstOrDefault(x => x.Subject == subject);
var subjectStat = thirdTermStat?.Stats.FirstOrDefault(x => x.Subject == subject);
sb.Append($@"
<tr class='report-card-data'>
<td>{subject}</td>
<td>{subjectReport?.CAScore}</td>
<td>{subjectReport?.FirstExamScore}</td>
<td>{subjectReport?.SecondExamScore}</td>
<td>{subjectReport?.HomeworkScore}</td>
<td>{subjectReport?.ClassActivitiesScore}</td>
<td>{subjectReport?.WeightedScore}</td>
<td>{subjectStat?.ClassMinScore}</td>
<td>{subjectStat?.ClassMaxScore}</td>
<td>{subjectStat?.ClassAverageScore}</td>
<td>{subjectReport?.Grade}</td>
</tr>");
}
sb.Append($@"
</table>
</td>
</tr>
</table>
</td>
</tr>");
}
sb.Append(@"
</table>
</div>
<br />
</div>
</body>
</html>");
return(sb.ToString());
}
public override void IncrementCounterFor(ClassReport classReport)
{
}
private void ShowGrid(Int32 PageNo)
{
DateTime DateStart = this.cc2DateSelector.StartDate();
DateTime DateEnd = this.cc2DateSelector.EndDate();
this.LblFrom.Text = DateStart.ToString("dd MMM yyyy");
this.LblTo.Text = DateEnd.ToString("dd MMM yyyy");
ClassReport oRep = new ClassReport();
DataSet oDs = oRep.GetTimeSheet(Int32.Parse(ViewState["UserId"].ToString()), DateStart, DateEnd);
double dTotal = 0;
foreach (DataRow oDr in oDs.Tables[0].Rows)
dTotal += double.Parse(oDr["Hours"].ToString());
ViewState["TotalHours"] = dTotal.ToString();
this.GridTime.DataSource = oDs;
this.GridTime.PageIndex = (PageNo >= 0) ? PageNo : 0;
this.GridTime.DataBind();
if (Int32.Parse(ViewState["TimeId"].ToString()) == 0)
{
this.BtnSubmit.Text = "Submit";
this.LblTimeId.Text = "New";
}
else
{
this.BtnSubmit.Text = "Update";
this.LblTimeId.Text = string.Format("Update ({0})", Int32.Parse(ViewState["TimeId"].ToString()));
}
// Time events which are locked cannot be edited or deleted.
ClassTime oTim = new ClassTime();
foreach (GridViewRow oRow in GridTime.Rows)
{
ImageButton oDel = (ImageButton)oRow.FindControl("ImgTrash");
if (oDel != null)
{
oTim.Load(Int32.Parse(oDel.CommandArgument));
if (oTim.Locked)
{
oDel.ToolTip = "";
oDel.Enabled = false;
oDel.ImageUrl = "~/Images/BlankIcon.gif";
}
}
}
ShowTimeError("");
}
public override void IncrementCounterFor(ClassReport classReport)
{
classReport.SucceededTests++;
}
private void ValidateMethodsExisting(ClassReport report)
{
report.MissingMethods = methodsNotFound;
report.ValidMethodsByExistence = methodPairs.Keys.ToList();
}
public DataSet GetTimeSheet(string UsrNam, string UsrPwd, DateTime StartDate, DateTime EndDate)
{
DataSet oDs = null;
try
{
Int32 UserId = GetUserId(UsrNam, UsrPwd);
if (UserId > 0)
{
ClassReport oRep = new ClassReport();
oDs = oRep.GetTimeSheet(UserId, StartDate, EndDate);
}
}
catch (Exception ex)
{
Log.LogMsg(ex.Message);
}
return oDs;
}
