//Validate the conection paramaters
public static bool Validate(Conection con, out string errormessage)
{
//Mandatory fields in Conection (configConnectionStringName is provided by the code [can't fail]but just in case we will change this I will add to the validation)
if (string.IsNullOrEmpty(con.configConnectionStringName) ||
string.IsNullOrEmpty(con.dataSource) ||
string.IsNullOrEmpty(con.initialCatalog))
{
errormessage = "One of this fields are not filled: Sql Server IP or Database Name";
return(false);
}
if (!con.integratedSecurity && (string.IsNullOrEmpty(con.userId) || string.IsNullOrEmpty(con.password)))
{
errormessage = "One of this fields are not filled: UserName or Password";
return(false);
}
errormessage = "";
return(true);
}
