protected void category_SelectedIndexChanged(object sender, EventArgs e)
{
PowershellScripts pwrObject = new PowershellScripts();
if (category.Text != "")
{
pwrObject.Category = category.Text;
}
}
public DataTable FillAttributecombo(PowershellScripts obj)
{
try
{
return(VSWebDAL.ConfiguratorDAL.MSServerDAL.Ins.FillAttributecombo(obj));
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable FillThresholdcombo(PowershellScripts obj, InputParameters ipobj)
{
try
{
return(VSWebDAL.ConfiguratorDAL.MSServerDAL.Ins.FillThresholdcombo(obj, ipobj));
}
catch (Exception ex)
{
throw ex;
}
}
public PowershellScripts GetPwrData(PowershellScripts pwrObject)
{
try
{
return(VSWebDAL.ConfiguratorDAL.PwrShelDAL.Ins.GetPwrData(pwrObject));
}
catch (Exception ex)
{
throw ex;
}
}
protected void PwrShelGridView_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
PowershellScripts PwrObject = new PowershellScripts();
PwrObject.ScriptName = e.Keys[0].ToString();
//Delete row from DB
Object ReturnValue = VSWebBL.ConfiguratorBL.PwrshelBL.Ins.DeleteData(PwrObject);
//Update Grid after inserting new row, refresh grid as in page load
ASPxGridView gridView = (ASPxGridView)sender;
gridView.CancelEdit();
e.Cancel = true;
FillPowerGrid();
}
public DataTable FillThresholdcombo(PowershellScripts obj, InputParameters ipobj)
{
DataTable dt = new DataTable();
try
{
string SqlQuery = "select Threshold,Type,ApplyThreshold from InputParameters where PSID=(select ID from PowershellScripts where ScriptName= '" + obj.ScriptName + "') and Alias='" + ipobj.Alias + "'";
dt = objAdaptor.FetchData(SqlQuery);
}
catch
{
}
finally
{
}
return(dt);
}
public DataTable FillAttributecombo(PowershellScripts obj)
{
DataTable dt = new DataTable();
try
{
string SqlQuery = "select Alias from InputParameters where PSID=(select ID from PowershellScripts where ScriptName= '" + obj.ScriptName + "' )";
dt = objAdaptor.FetchData(SqlQuery);
}
catch
{
}
finally
{
}
return(dt);
}
public Object DeleteData(PowershellScripts pwrObject)
{
Object Update;
try
{
string SqlQuery = "Delete PowershellScripts Where ScriptName='" + pwrObject.ScriptName + "'";
Update = objAdaptor.ExecuteNonQuery(SqlQuery);
}
catch
{
Update = false;
}
finally
{
}
return(Update);
}
public bool UpdateData(PowershellScripts pwrObject)
{
bool Update;
try
{
string SqlQuery = "UPDATE PowershellScripts SET ScriptDetails='" + pwrObject.ScriptDetails + "' ,Category='" + pwrObject.Category + "',Description='" + pwrObject.Description + "' WHERE ScriptName = '" + pwrObject.ScriptName + "'";
Update = objAdaptor.ExecuteNonQuery(SqlQuery);
}
catch
{
Update = false;
}
finally
{
}
return(Update);
}
public bool InsertData(PowershellScripts pwrObject)
{
bool Insert = false;
try
{
string SqlQuery = "INSERT INTO PowershellScripts (ScriptName ,ScriptDetails,Category,Description)" +
"VALUES('" + pwrObject.ScriptName + "','" + pwrObject.ScriptDetails + "','" + pwrObject.Category + "','" + pwrObject.Description + "')";
Insert = objAdaptor.ExecuteNonQuery(SqlQuery);
}
catch
{
Insert = false;
}
finally
{
}
return(Insert);
}
public Object UpdateScript(PowershellScripts pwrObject)
{
Object ReturnValue = ValidateUpdate(pwrObject);
try
{
if (ReturnValue.ToString() == "")
{
return(VSWebDAL.ConfiguratorDAL.PwrShelDAL.Ins.UpdateData(pwrObject));
}
else
{
return(ReturnValue);
}
}
catch (Exception ex)
{
throw ex;
}
}
public Object ValidateUpdate(PowershellScripts pwrObject)
{
Object ReturnValue = "";
try
{
if (pwrObject.ScriptName == null || pwrObject.ScriptName == "")
{
return("ER#Please enter the Script name");
}
if (pwrObject.ScriptDetails == null || pwrObject.ScriptDetails == "")
{
return("ER#Please enter Script Details");
}
}
catch (Exception ex)
{ throw ex; }
finally
{ }
return("");
}
private PowershellScripts CollectDataForPowershellScripts()
{
try
{
// SetFocusOnControl();
//Cluster Settings
PowershellScripts pwrObject = new PowershellScripts();
pwrObject.ScriptName = txtScriptName.Text.Replace("'", "'");
pwrObject.ScriptDetails = ScriptDetailsMemo.Text.Replace("'", "'");
pwrObject.Category = category.Text.Replace("'", "'");
pwrObject.Description = txtDescripation.Text.Replace("'", "'");
return(pwrObject);
}
catch (Exception ex)
{
//6/27/2014 NS added for VSPLUS-634
Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
throw ex;
}
finally { }
}
private void FillData(string ScriptName)
{
try
{
PowershellScripts Pwrobj = new PowershellScripts();
PowershellScripts ReturnpwrObject = new PowershellScripts();
Pwrobj.ScriptName = ScriptName;
ReturnpwrObject = VSWebBL.ConfiguratorBL.PwrshelBL.Ins.GetPwrData(Pwrobj);
txtScriptName.Text = ReturnpwrObject.ScriptName.Replace("'", "'");
ScriptDetailsMemo.Text = ReturnpwrObject.ScriptDetails.Replace("'", "'");
category.Text = ReturnpwrObject.Category.Replace("'", "'");
txtDescripation.Text = ReturnpwrObject.Description.Replace("'", "'");
}
catch (Exception ex)
{
//6/27/2014 NS added for VSPLUS-634
Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
throw ex;
}
finally { }
}
public PowershellScripts GetPwrData(PowershellScripts pwrObject)
{
DataTable pwrDataTable = new DataTable();
PowershellScripts ReturnObject = new PowershellScripts();
try
{
string SqlQuery = "Select * from PowershellScripts where [ScriptName]='" + pwrObject.ScriptName + "'";
pwrDataTable = objAdaptor.FetchData(SqlQuery);
//populate & return data object
ReturnObject.ScriptName = pwrDataTable.Rows[0]["ScriptName"].ToString();
ReturnObject.ScriptDetails = pwrDataTable.Rows[0]["ScriptDetails"].ToString();
ReturnObject.Category = pwrDataTable.Rows[0]["Category"].ToString();
ReturnObject.Description = pwrDataTable.Rows[0]["Description"].ToString();
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
return(ReturnObject);
}
