protected void SearchStudentBtn_Click(object sender, EventArgs e)
{
StudentService service = new StudentService();
ResultsGrid.DataSource = service.Search(s => s.Name.Contains(NameTxt.Text));
ResultsGrid.DataBind();
}
protected void ShowOtherData(string DataArg, string DataMessage)
{
ClearPageMessages();
try
{
ResultPanel.Visible = true;
ResultEditUpdatePanel.Visible = false;
DisableEdit.Value = "1";
dt = CheckError(mrpCalc.WorkProcessResults(ProcessID.Value.ToString(), DataArg));
if ((dt != null) && (dt.Rows.Count > 0))
{
ResultsGrid.Visible = true;
ResultsGrid.DataSource = dt;
Session["MRPResults"] = dt;
}
else
{
ShowPageMessage(DataMessage, 1);
}
ResultsGrid.DataBind();
MainUpdatePanel.Update();
}
catch (Exception ex)
{
ShowPageMessage("OtherData Error " + ex.Message.ToString(), 2);
}
}
private void FillGrid()
{
try
{
ResultPanel.Visible = true;
ResultEditUpdatePanel.Visible = false;
DisableEdit.Value = "0";
ShowPageMessage("Results for process " + ProcessID.Value + ".", 0);
dt = CheckError(mrpCalc.WorkProcessResults(ProcessID.Value.ToString(), "Fed"));
if ((dt != null) && (dt.Rows.Count > 0))
{
ResultsGrid.Visible = true;
ResultsGrid.DataSource = dt;
ResultsGrid.DataBind();
Session["MRPResults"] = dt;
MainUpdatePanel.Update();
}
else
{
ShowPageMessage("No Results were produced", 0);
}
}
catch (Exception ex)
{
ShowPageMessage("Fill Error " + ex.Message.ToString(), 0);
}
}
private void ShowResults(DataTable dataTable)
{
//dataTable.Columns["reference"].
ResultsGrid.DataSource = dataTable;
ResultsGrid.DataBind();
ResultsGrid.Visible = true;
ResultsGrid.HeaderRow.TableSection = TableRowSection.TableHeader;
MessageLabel.Visible = false;
}
private void RunReport()
{
DataTable report = GetReport();
string[] columns = report.Columns.Cast <DataColumn>().Select(c => c.ColumnName).ToArray();
// build header
HeaderRptr.DataSource = columns;
HeaderRptr.DataBind();
// build results
ResultsGrid.DataSource = report;
ResultsGrid.DataBind();
}
public void SortResultsGrid(Object sender, GridViewSortEventArgs e)
{
try
{
// Create a DataView from the Results DataTable.
DataView dv = new DataView((DataTable)Session["MRPResults"]);
dv.Sort = e.SortExpression;
ResultsGrid.DataSource = dv;
ResultsGrid.DataBind();
//ResultsGrid.Height = new Unit(double.Parse(ResultsGridHeightHidden.Value), UnitType.Pixel);
//ResultsGrid.Width = new Unit(double.Parse(ResultsGridWidthHidden.Value), UnitType.Pixel);
}
catch (Exception e2)
{
ShowPageMessage("Sort Error " + e2.Message + ", " + e2.ToString(), 2);
}
}
private void RunReport(String ReportName)
{
try
{
if (ReportName.Length != 0)
{
String sql = string.Empty;
using (SqlConnection conn = DB.dbConn())
{
conn.Open();
using (IDataReader rs = DB.GetRS("Select * from CustomReport with (NOLOCK) where lower(name)=" + DB.SQuote(ReportName.ToLowerInvariant()), conn))
{
if (rs.Read())
{
ResultsPanel.Visible = true;
sql = DB.RSField(rs, "SQLCommand");
}
}
}
using (SqlConnection conn = DB.dbConn())
{
conn.Open();
using (IDataReader rs = DB.GetRS(sql, conn))
{
using (DataTable dt = new DataTable())
{
dt.Load(rs);
ResultsGrid.DataSource = dt;
ResultsGrid.DataBind();
}
}
}
}
else
{
ResultsPanel.Visible = false;
}
}
catch (Exception ex)
{
ltError.Text = CommonLogic.GetExceptionDetail(ex, "<br/>");
}
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt.Columns.Add("Employee Name");
dt.Columns.Add("Variations Found");
dt.Columns.Add("Occurrences");
foreach (Employee employee in employeeList)
{
DataRow row = dt.NewRow();
int occurences = patternChecker.MatchPatterns(employee, InputText.Value);
row[0] = employee.ToString();
row[1] = employee.GetVariations();
row[2] = occurences;
dt.Rows.Add(row);
}
ResultsGrid.DataSource = dt;
ResultsGrid.DataBind();
}