private void GoBtn_Click(object sender, EventArgs e)
{
string start = StartDateBox.Text;
string end = EndDateBox.Text;
string user = Environment.UserName;
DataTable xlReader = XLant.XLSQL.ReturnTable("EXECUTE [XLant].[dbo].[ActionsLog] @user = '******' ,@start = '" + start + "',@end = '" + end + "'");
ResultsGrid.DataSource = xlReader;
ResultsGrid.Columns[0].ReadOnly = true;
ResultsGrid.Columns[1].ReadOnly = true;
ResultsGrid.Columns[3].ReadOnly = true;
DataGridViewTextBoxColumn hoursColumn = new DataGridViewTextBoxColumn();
hoursColumn.HeaderText = "Hours";
hoursColumn.ReadOnly = false;
hoursColumn.ValueType = typeof(decimal);
ResultsGrid.Columns.Add(hoursColumn);
ResultsGrid.Columns.Add(CreateSelectColumn("Service"));
ResultsGrid.Columns.Add(CreateSelectColumn("Analysis"));
ResultsGrid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
ResultsGrid.MultiSelect = true;
ResultsGrid.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
ResultsGrid.Update();
}
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);
}
}
public MainWindow()
{
InitializeComponent();
StepsGrid.ConfigureSingleClickEditing();
ResultsGrid.DisableSelection();
}
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/>");
}
}
private void PrintResults(object sender, RoutedEventArgs e)
{
if (FoundResults != null)
{
System.Windows.Controls.PrintDialog dialog = new System.Windows.Controls.PrintDialog();
if (dialog.ShowDialog().Value)
{
Size pageSize = new Size(dialog.PrintableAreaWidth, dialog.PrintableAreaWidth);
ResultsGrid.Arrange(new Rect(5, 5, pageSize.Width * 3, pageSize.Height));
dialog.PrintVisual(ResultsGrid, $"Found {Service.ToString()} services for postcode {Postcode}");
}
}
else
{
MessageBox.Show("Nothing to print");
}
}
private void Execute()
{
//get the selected text or the entire box. trim the text
var sql = QueryText.SelectedText.Length > 0 ? QueryText.SelectedText.Trim() : QueryText.Text.Trim();
var tokens = new[] { "update", "insert", "delete" };
//not trying to reinvent ssms, just execute a unidata query without msaccess
//check if the command starts with one of the tokens
//obviously not full-proof
var isExecute = tokens.Any(t => sql.StartsWith(t, StringComparison.InvariantCultureIgnoreCase));
try
{
if (isExecute)
{
this.Connection.DataConnection.Execute(sql);
}
else
{
var t = this.Connection.DataConnection.QueryDataTable(sql);
ResultsGrid.ApplyDataTale(t);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
//apply datatable to datagrid
//show messages
//show execution time?
this.Connection.DataConnection.CommandExecuted += DataConnection_CommandExecuted;
}
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();
}
private void CreateColumns(Strategy strategy)
{
var id = 0;
if (ShowProgress)
{
var progressColumn = (DataGridTextColumn)ResultsGrid.AddTextColumn("Progress", LocalizedStrings.Str1570);
progressColumn.Binding.StringFormat = "{0}%";
}
if (ShowProgress)
{
ResultsGrid.AddTextColumn("Strategy.Name", LocalizedStrings.NameKey);
}
foreach (var strategyParam in strategy.Parameters)
{
var type = strategyParam.Value.GetType();
if (type.IsNumeric() && !type.IsEnum() && !ExcludeParameters.Contains(strategyParam.Name))
{
ResultsGrid.AddTextColumn("Parameters[{0}].Value".Put(id), strategyParam.Name);
}
id++;
}
id = 0;
foreach (var statisticParam in strategy.StatisticManager.Parameters)
{
var column = (DataGridTextColumn)ResultsGrid.AddTextColumn("Statistics[{0}].Value".Put(id++), statisticParam.DisplayName);
var valueType = statisticParam.Value.GetType();
if (valueType.IsNumeric())
{
column.Binding.StringFormat = "{0:0.##}";
}
}
}
