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(); } }
public int funcAuthenticate(BOlogin objBOlogin) { return(objDAlogin.funcAuthenticate(objBOlogin)); }