public bool TestMySqlConnection()
{
MySqldb = new MySQLdb();
DbConnection mySqlconn = MySqldb.Database.Connection;
try
{
mySqlconn.Open(); // check MySql database connection
MySqldb.Database.Exists();
var count = MySqldb.car_request.Count();
return(true);
}
catch (Exception ex)
{
SendEmailandSms sendemail = new SendEmailandSms();
sendemail.Email("*****@*****.**", $"{ex.Message} {ex.InnerException} {ex.StackTrace}", "Blocked Car App - MySql Database not Accessible ");
return(false);
}
}
public virtual object connect()
{
this.conn = MySQLdb.connect(this.options);
}
