public clsILProcess(Utility.BU bU, Utility.ENV eNV, Utility.PERIOD pERIOD, System.Windows.Forms.Button btn)
{
// TODO: Complete member initialization
this._bU = bU;
this._eNV = eNV;
this._pERIOD = pERIOD;
this._dashboardStatusButton = btn;
}
public LogBoekForm(Utility.ENV eNV, Utility.BU bU, Utility.PERIOD period)
{
InitializeComponent();
_eNV = eNV;
_period = period;
_bU = bU;
Refresh();
}
private void btnTroubleshooting_Click(object sender, EventArgs e)
{
Utility.ENV env = (Utility.ENV)cbEnvironment.SelectedIndex;
Utility.BU bu = (Utility.BU)cbBU.SelectedIndex;
Utility.PERIOD period = (Utility.PERIOD)cbPeriod.SelectedIndex;
TroublehsootingForm tsForm = new TroublehsootingForm(env, bu, period, _kalenderDatum, _runID, _SSISRunID);
tsForm.ShowDialog();
}
protected void Init(Utility.ENV eNV, Utility.BU bU, Utility.PERIOD period, int ILRunID, Int64 ssisRunID, DateTime calendarDate)
{
_eNV = eNV;
_period = period;
_bU = bU;
_ILRunID = ILRunID;
_ssisRunID = ssisRunID;
_calendarDate = calendarDate;
Refresh();
}
protected void Init(Utility.ENV eNV, Utility.BU bU, Utility.PERIOD period, int ILRunID, Int64 ssisRunID, DateTime calendarDate, ToolStripStatusLabel toolStripStatusLabel)
{
_eNV = eNV;
_period = period;
_bU = bU;
_ILRunID = ILRunID;
_ssisRunID = ssisRunID;
_calendarDate = calendarDate;
_toolStripStatusLabel = toolStripStatusLabel;
Refresh();
}
public RunDetailLogForm(Utility.ENV eNV, Utility.BU bU, Utility.PERIOD period, int runID)
{
InitializeComponent();
_eNV = eNV;
_period = period;
_bU = bU;
_runID = runID;
this.dgvRunDetailLog.RowPrePaint += new System.Windows.Forms.DataGridViewRowPrePaintEventHandler(this.dgvRunDetailLog_RowPrePaint);
Refresh();
}
public VVRunDetailsForm(Utility.ENV env, Utility.BU bu, Utility.PERIOD period, DateTime kalenderDatum, Int64 ssisRunID)
{
InitializeComponent();
Init(env, bu, period, ILRunID, ssisRunID, kalenderDatum, toolStripStatusLabel1);
lblEnvironment.Text = env.ToString();
lblBU.Text = bu.ToString();
lblPeriod.Text = period.ToString();
// Fill Kalenderdatum dropbox with dates from kalender
FillCalendarDateDropbox(kalenderDatum, cbCalendarDates);
SetupDetailsList();
RefreshData();
_initialized = true;
}
private void btnRunDetails_Click(object sender, EventArgs e)
{
Utility.ENV env = (Utility.ENV)cbEnvironment.SelectedIndex;
Utility.BU bu = (Utility.BU)cbBU.SelectedIndex;
Utility.PERIOD period = (Utility.PERIOD)cbPeriod.SelectedIndex;
RunDetailBaseForm runDetailsForm;
if (bu == Utility.BU.ILVB)
{
runDetailsForm = new RunDetailsForm(env, bu, period, _kalenderDatum, _SSISRunID);
}
else
{
runDetailsForm = new VVRunDetailsForm(env, bu, period, _kalenderDatum, _SSISRunID);
}
runDetailsForm.ShowDialog();
RefreshData();
}
public TroublehsootingForm(Utility.ENV env, Utility.BU bu, Utility.PERIOD period, DateTime kalenderDatum, int ILRunID, Int64 ssisRunID)
{
InitializeComponent();
Init(env, bu, period, ILRunID, ssisRunID, kalenderDatum);
// Get Failure Details
string cs = Utility.GetConnectionString(ENV, BU, Period, false);
DataSet dsFailureDetails = SqlDA.GetQueryDataSet(cs, SQLQueries.SQL_RUN_FAILURES.Replace("<RunID>", ILRunID.ToString()), false);
dgvFailureDetails.DataSource = dsFailureDetails.Tables[0];
dgvFailureDetails.Refresh();
// Get SSIS Errors
DataSet dsFSSISErrors = SqlDA.GetQueryDataSet(cs, SQLQueries.SQL_SSIS_ERRORS.Replace("<RunID>", SsisRunID.ToString()), false);
dgvSSISErrors.DataSource = dsFSSISErrors.Tables[0];
dgvSSISErrors.Refresh();
}
private int RefreshData()
{
string cs;
int rc = 0;
bool bNewInfo = false;
tssLabel.Text = "";
if (_initialized == true)
{
string BUPart = cbBU.SelectedIndex == (int)Utility.BU.ILVB ? "ILH" : "ILSB";
//string periodPart = cbPeriod.SelectedIndex == (int)Utility.PERIOD.DAG ? "DAG" : "MAAND";
//string databasePart = "; Database=" + BUPart + "_LOGGING_" + periodPart;
string histOffset = cbHistoryVersion.Text;
if (histOffset == "")
{
histOffset = "0";
}
string statusQuery = (BUPart == "ILH" ? SQLQueries.SQL_RUN_STATUS_ILH : SQLQueries.SQL_RUN_STATUS_ILSB).Replace("<HistOffset>", histOffset);
Utility.ENV env = (Utility.ENV)cbEnvironment.SelectedIndex;
Utility.BU bu = (Utility.BU)cbBU.SelectedIndex;
Utility.PERIOD period = (Utility.PERIOD)cbPeriod.SelectedIndex;
cs = Utility.GetConnectionString((Utility.ENV)cbEnvironment.SelectedIndex, (Utility.BU)cbBU.SelectedIndex, (Utility.PERIOD)cbPeriod.SelectedIndex, false);
if (cs != "")
{
string runStatus = "Unknown";
try
{
DataSet ds = _sqlDA.GetQueryDataSet(cs, statusQuery, false);
// set process status
if (ds.Tables[0].Rows.Count > 0)
{
_runID = (int)(ds.Tables[0].Rows[0]["RunID"]);
runStatus = ds.Tables[0].Rows[0]["RunStatus"].ToString();
lblResult.Text = runStatus;
if (runStatus != _status)
{
bNewInfo = true;
}
_status = runStatus;
_kalenderDatum = Utility.ParseDateStringToDate(ds.Tables[0].Rows[0]["KalenderDatum"].ToString());
lblKalenderDatum.Text = Utility.ParseDateStringToLabel(ds.Tables[0].Rows[0]["KalenderDatum"].ToString());
lblBeginDTM.Text = ds.Tables[0].Rows[0]["StartDatumTijd"].ToString();
lblEndDTM.Text = ds.Tables[0].Rows[0]["EindDatumTijd"].ToString();
_SSISRunID = Convert.ToInt64(ds.Tables[0].Rows[0]["Execution_ID"]);
lblSSISRunID.Text = _SSISRunID.ToString();
// Set label background color depending on the SSIS status
//Created (1), running (2), canceled (3), failed (4), pending (5), ended unexpectedly (6), succeeded (7), stopping (8), and completed (9).
Color c = Color.Transparent;
string toolTipText = "";
if (ds.Tables[0].Rows[0]["SSISStatus"] != DBNull.Value)
{
switch (Convert.ToInt16(ds.Tables[0].Rows[0]["SSISStatus"]))
{
case 1:
c = Color.Aqua;
toolTipText = "Created (1)";
break;
case 2:
c = Color.SkyBlue;
toolTipText = "Running (2)";
break;
case 3:
c = Color.Yellow;
toolTipText = "Canceled (3)";
break;
case 4:
c = Color.Red;
toolTipText = "Failed (4)";
break;
case 5:
c = Color.Orange;
toolTipText = "Pending (5)";
break;
case 6:
c = Color.Purple;
toolTipText = "Ended unexpectedly (6)";
break;
case 7:
c = Color.LightGreen;
toolTipText = "Succeeded (7)";
break;
case 8:
c = Color.Blue;
toolTipText = "Stopping (8)";
break;
case 9:
c = Color.YellowGreen;
toolTipText = "Completed (9)";
break;
default:
c = Color.Pink;
toolTipText = "Status Unknown";
break;
}
}
lblSSISRunID.BackColor = c;
System.Windows.Forms.ToolTip SSISStatusToolTip = new System.Windows.Forms.ToolTip();
SSISStatusToolTip.SetToolTip(lblSSISRunID, toolTipText);
//lblLatestSSISMessage.Text = GetLatestSSISMessage(cs, _SSISRunID);
if (ds.Tables[0].Rows[0]["PeilDatum"].ToString() != "")
{
lblPeilDatum.Text = Convert.ToDateTime(ds.Tables[0].Rows[0]["PeilDatum"]).ToString("dd-MM-yyyy");
}
else
{
lblPeilDatum.Text = "";
}
if (ds.Tables[0].Rows[0]["Stepomschrijving"].ToString() != "")
{
lblLastStep.Text = ds.Tables[0].Rows[0]["Stepomschrijving"].ToString();
}
else
{
lblLastStep.Text = "";
}
if (lblLastStep.Text != _lastStep)
{
bNewInfo = true;
}
_lastStep = lblLastStep.Text;
lblControleType.Text = ds.Tables[0].Rows[0]["ControleType"].ToString();
lblPackage.Text = ds.Tables[0].Rows[0]["Packagenaam"].ToString();
lblDetailDTM.Text = ds.Tables[0].Rows[0]["DetailDTM"].ToString();
lblOpmerkingen.Text = ds.Tables[0].Rows[0]["Opmerkingen"].ToString();
lblBronsysteem.Text = ds.Tables[0].Rows[0]["Bronsysteem"].ToString();
}
else
{
ReportMessage("There is no run information available", "Info");
}
}
catch (Exception e)
{
ReportMessage(e.Message, "Error");
};
if (runStatus == "OK")
{
lblResult.BackColor = Color.LightGreen;
}
else if (runStatus == "NOK")
{
lblResult.BackColor = Color.Red;
}
else
{
lblResult.BackColor = Color.Yellow;
}
lblLastRefreshDTM.Text = DateTime.Now.ToString();
if (bNewInfo == true)
{
rc = 1;
}
}
else
{
rc = -1;
}
}
return(rc);
}
public SSISLogForm(Utility.ENV eNV, Utility.BU bU, Utility.PERIOD period, int ILRunID, Int64 ssisRunID, DateTime calenderDate)
{
InitializeComponent();
Init(eNV, bU, period, ILRunID, ssisRunID, calenderDate);
}
