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(); } }