private DataTable GetUpdateTable(string selectQuery)
{
var tmpTable = controlParser.ReturnUpdateTable(selectQuery);
var row = tmpTable.Rows[0];
//Add Add'l info
if (MunisUser.Number != null && MunisUser.Number != string.Empty)
{
row[DevicesCols.CurrentUser] = MunisUser.Name;
row[DevicesCols.MunisEmpNum] = MunisUser.Number;
}
else
{
if (currentViewDevice.CurrentUser != CurrentUserTextBox.Text.Trim())
{
row[DevicesCols.CurrentUser] = CurrentUserTextBox.Text.Trim();
row[DevicesCols.MunisEmpNum] = DBNull.Value;
}
else
{
row[DevicesCols.CurrentUser] = currentViewDevice.CurrentUser;
row[DevicesCols.MunisEmpNum] = currentViewDevice.CurrentUserEmpNum;
}
}
row[DevicesCols.SibiLinkGuid] = DataConsistency.CleanDBValue(currentViewDevice.SibiLink);
row[DevicesCols.LastModUser] = NetworkInfo.LocalDomainUser;
row[DevicesCols.LastModDate] = DateTime.Now;
return(tmpTable);
}
private void PhoneNumberTextBox_Leave(object sender, EventArgs e)
{
if (!DataConsistency.ValidPhoneNumber(PhoneNumberTextBox.Text))
{
OtherFunctions.Message("Invalid phone number.", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, "Error", this);
}
}
public static void OrgObjSearch(ExtendedForm parentForm)
{
try
{
using (var newDialog = new Dialog(parentForm))
{
string org = "";
string obj = "";
string fy = "";
newDialog.Text = "Org/Object Code Search";
newDialog.AddTextBox("Org", "Org Code:");
newDialog.AddTextBox("Obj", "Object Code:");
newDialog.AddTextBox("FY", "Fiscal Year:");
newDialog.SetControlValue("FY", DateTime.Now.Year);
newDialog.ShowDialog();
if (newDialog.DialogResult == DialogResult.OK)
{
org = newDialog.GetControlValue("Org").ToString();
obj = newDialog.GetControlValue("Obj").ToString();
fy = newDialog.GetControlValue("FY").ToString();
if (org.Trim() != "" && DataConsistency.IsValidYear(fy))
{
NewOrgObjView(org, obj, fy, parentForm);
}
}
}
}
catch (Exception ex)
{
ErrorHandling.ErrHandle(ex, System.Reflection.MethodBase.GetCurrentMethod());
}
}
private void PhoneNumTextBox_Leave(object sender, EventArgs e)
{
if (PhoneNumTextBox.Text.ToString().Trim() != "" && !DataConsistency.ValidPhoneNumber(PhoneNumTextBox.Text))
{
OtherFunctions.Message("Invalid phone number.", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, "Error", this);
PhoneNumTextBox.Focus();
}
}
public string InvokeRemotePSCommand(NetworkCredential credentials, Command pScommand)
{
try
{
var psCreds = new PSCredential(credentials.UserName, credentials.SecurePassword);
string shellUri = "http://schemas.microsoft.com/powershell/Microsoft.PowerShell";
WSManConnectionInfo connInfo = new WSManConnectionInfo(false, targetHostname, 5985, "/wsman", shellUri, psCreds);
using (Runspace remoteRunSpace = RunspaceFactory.CreateRunspace(connInfo))
{
remoteRunSpace.Open();
remoteRunSpace.SessionStateProxy.SetVariable("cred", psCreds);
using (var powerSh = PowerShell.Create())
{
powerSh.Runspace = remoteRunSpace;
powerSh.InvocationStateChanged -= Powershell_InvocationStateChanged;
powerSh.InvocationStateChanged += Powershell_InvocationStateChanged;
powerSh.Commands.AddCommand(pScommand);
CurrentPowerShellObject = powerSh;
Collection <PSObject> results = powerSh.Invoke();
StringBuilder stringBuilder = new StringBuilder();
foreach (var obj in results)
{
stringBuilder.AppendLine(obj.ToString());
}
remoteRunSpace.Close();
powerSh.Stop();
return(DataConsistency.CleanDBValue((stringBuilder.ToString())).ToString());
}
}
}
catch (Exception ex)
{
//Check for incorrect username/password error and rethrow a Win32Exception to be caught in the error handler.
//Makes sure that the global admin credentials variable is cleared so that a new prompt will be shown on the next attempt. See: VerifyAdminCreds method.
if (ex is PSRemotingTransportException)
{
var transportEx = (PSRemotingTransportException)ex;
if (transportEx.ErrorCode == 1326)
{
throw new Win32Exception(1326);
}
}
return(ex.Message);
}
}
public async Task <bool> InvokePowerShellSession(PowerShell session)
{
CurrentPowerShellObject = session;
session.InvocationStateChanged -= Powershell_InvocationStateChanged;
session.InvocationStateChanged += Powershell_InvocationStateChanged;
try
{
var psResults = await Task.Run(() =>
{
Collection <PSObject> results = session.Invoke();
StringBuilder stringBuilder = new StringBuilder();
foreach (var obj in results)
{
stringBuilder.AppendLine(obj.ToString());
}
return(DataConsistency.CleanDBValue((stringBuilder.ToString())).ToString());
});
if (!string.IsNullOrEmpty(psResults))
{
if (psResults.Contains("success"))
{
return(true);
}
else
{
OtherFunctions.Message(psResults, MessageBoxButtons.OK, MessageBoxIcon.Exclamation, "Error Running Script");
return(false);
}
}
else
{
return(true);
}
}
catch (Exception)
{
return(false);
}
finally
{
session.Runspace.Close();
session.Runspace.Dispose();
session.Dispose();
}
}
private void SetHostname()
{
if (OSTypeComboBox.SelectedValue != null)
{
bool windowsSelected = OSTypeComboBox.Text.ToString().ToUpper().Contains("WIN");
if (SerialTextBox.Text != "" && windowsSelected)
{
HostnameTextBox.Text = DataConsistency.DeviceHostnameFormat(SerialTextBox.Text);
}
else
{
HostnameTextBox.Text = string.Empty;
}
}
}
private bool FieldsValid()
{
bool fieldsValid = true;
fieldsValid = controlParser.ValidateFields();
if (!DataConsistency.ValidPhoneNumber(PhoneNumberTextBox.Text))
{
fieldsValid = false;
controlParser.SetError(PhoneNumberTextBox, false);
}
else
{
controlParser.SetError(PhoneNumberTextBox, true);
}
return(fieldsValid); //if fields are missing return false to trigger a message if needed
}
private bool CheckFields()
{
bool validFields = true;
validFields = controlParser.ValidateFields();
LockUnlockUserField();
if (PhoneNumTextBox.Text.Trim() != "" && !DataConsistency.ValidPhoneNumber(PhoneNumTextBox.Text))
{
validFields = false;
controlParser.SetError(PhoneNumTextBox, false);
OtherFunctions.Message("Invalid phone number.", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, "Error", this);
}
return(validFields);
}
private void ViewTrackingEntry(string entryGuid, Device device)
{
try
{
Waiting();
using (DataTable results = DBFactory.GetDatabase().DataTableFromQueryString(Queries.SelectTrackingEntryByGuid(entryGuid)))
{
foreach (DataRow r in results.Rows)
{
txtTimeStamp.Text = DataConsistency.NoNull(r[TrackablesCols.DateStamp]);
txtCheckType.Text = DataConsistency.NoNull(r[TrackablesCols.CheckType]);
if (txtCheckType.Text == "IN")
{
txtCheckType.BackColor = Colors.CheckIn;
}
else if (txtCheckType.Text == "OUT")
{
txtCheckType.BackColor = Colors.CheckOut;
}
txtDescription.Text = device.Description;
txtGuid.Text = DataConsistency.NoNull(r[TrackablesCols.DeviceGuid]);
txtCheckOutUser.Text = DataConsistency.NoNull(r[TrackablesCols.CheckoutUser]);
txtCheckInUser.Text = DataConsistency.NoNull(r[TrackablesCols.CheckinUser]);
txtLocation.Text = DataConsistency.NoNull(r[TrackablesCols.UseLocation]);
txtAssetTag.Text = device.AssetTag;
txtCheckOutTime.Text = DataConsistency.NoNull(r[TrackablesCols.CheckoutTime]);
txtDueBack.Text = DataConsistency.NoNull(r[TrackablesCols.DueBackDate]);
txtSerial.Text = device.Serial;
txtCheckInTime.Text = DataConsistency.NoNull(r[TrackablesCols.CheckinTime]);
txtNotes.Text = DataConsistency.NoNull(r[TrackablesCols.Notes]);
txtEntryGuid.Text = DataConsistency.NoNull(r[TrackablesCols.Guid]);
this.Text = this.Text + " - " + DataConsistency.NoNull(r[TrackablesCols.DateStamp]);
}
}
}
catch (Exception ex)
{
ErrorHandling.ErrHandle(ex, System.Reflection.MethodBase.GetCurrentMethod());
}
finally
{
DoneWaiting();
}
}
public object GetDBControlValue(Control control)
{
if (control is TextBox)
{
var dbTxt = (TextBox)control;
return(DataConsistency.CleanDBValue(dbTxt.Text));
}
else if (control is MaskedTextBox)
{
var dbMaskTxt = (MaskedTextBox)control;
return(DataConsistency.CleanDBValue(dbMaskTxt.Text));
}
else if (control is DateTimePicker)
{
var dbDtPick = (DateTimePicker)control;
return(dbDtPick.Value);
}
else if (control is ComboBox)
{
var dbCmb = (ComboBox)control;
if (dbCmb.SelectedIndex > -1)
{
return(dbCmb.SelectedValue.ToString());
}
else
{
return(dbCmb.Text);
}
}
else if (control is CheckBox)
{
var dbChk = (CheckBox)control;
return(dbChk.Checked);
}
else
{
throw new Exception("Unexpected type.");
//return null;
}
}
public static async void ReqSearch(ExtendedForm parentForm)
{
try
{
string reqNumber = "";
string fy = "";
using (var newDialog = new Dialog(parentForm))
{
newDialog.Text = "Req Search";
newDialog.AddTextBox("ReqNum", "Requisition #:");
newDialog.AddTextBox("FY", "FY:");
newDialog.ShowDialog();
if (newDialog.DialogResult == DialogResult.OK)
{
reqNumber = newDialog.GetControlValue("ReqNum").ToString();
fy = newDialog.GetControlValue("FY").ToString();
if (DataConsistency.IsValidYear(fy))
{
parentForm.Waiting();
var blah = await NewMunisReqSearch(reqNumber, fy, parentForm);
}
else
{
OtherFunctions.Message("Invalid year.", MessageBoxButtons.OK, MessageBoxIcon.Information, "Invalid", parentForm);
}
}
}
}
catch (Exception ex)
{
ErrorHandling.ErrHandle(ex, System.Reflection.MethodBase.GetCurrentMethod());
}
finally
{
parentForm.DoneWaiting();
}
}
private void FillControls(DataTable data)
{
controlParser.FillDBFields(data);
this.Text = this.Text + " - " + DataConsistency.NoNull(data.Rows[0][HistoricalDevicesCols.ActionDateTime]);
}