public string GetAdministratorPassword()
{
string Rv = "";
ClsConnection_SqlServer Cn = new ClsConnection_SqlServer();
try
{
Cn.Connect();
List<Layer01_Constants.Str_Parameters> Sp = new List<Layer01_Constants.Str_Parameters>();
Sp.Add(new Layer01_Constants.Str_Parameters("ParameterName", "Administrator_Password"));
Sp.Add(new Layer01_Constants.Str_Parameters("ParameterValue", "Password"));
Cn.ExecuteNonQuery("usp_Require_System_Parameter", Sp);
DataTable Dt = Cn.ExecuteQuery(@"Select dbo.udf_Get_System_Parameter('Administrator_Password')").Tables[0];
if (Dt.Rows.Count > 0)
{ Rv = (string)Layer01_Methods.IsNull(Dt.Rows[0][0], ""); }
}
catch { }
finally { Cn.Close(); }
return Rv;
}
public static Int32 ExecuteNonQuery(string ProcedureName, Common.Layer01_Constants.Str_Parameters[] ProcedureParameters)
{
ClsConnection_SqlServer Da = new ClsConnection_SqlServer();
try
{
Da.Connect();
return Da.ExecuteNonQuery(ProcedureName, ProcedureParameters);
}
catch (Exception ex)
{
throw ex;
}
finally
{
Da.Close();
}
}
public static Int32 ExecuteNonQuery(string Query)
{
ClsConnection_SqlServer Da = new ClsConnection_SqlServer();
try
{
Da.Connect();
return Da.ExecuteNonQuery(Query);
}
catch (Exception ex)
{
throw ex;
}
finally
{
Da.Close();
}
}
