Ejemplo n.º 1
0
 public int funcAuthenticate(BOlogin objBOlogin)
 {
     try
     {
         objDB_Util = new DB_Utility();
         SqlConnection con = objDB_Util.funcOpenConnection();
         SqlCommand    cmd = new SqlCommand();
         cmd.Connection  = con;
         cmd.CommandText = "SELECT count(*) FROM tblLogin WHERE username = '******' and password = '******'";
         int retVal = (int)cmd.ExecuteScalar();
         return(retVal);
     }
     catch
     {
         //exception handling for login
         return(-1);
     }
     finally
     {
         objDB_Util.funcCloseConnection();
     }
 }
Ejemplo n.º 2
0
 public int funcAuthenticate(BOlogin objBOlogin)
 {
     return(objDAlogin.funcAuthenticate(objBOlogin));
 }